Monday 19 November 2007

Eazy connect

Eazy connect, does not use TNSnames file
sqlplus system/oracle@192.168.1.0:1521/NIDB


TNS name files was there but spelling was wrong, 's' was missing tnsnames.ora file
[foglight5@lnx-quest admin]$ tnsping ACTIVE.LNX-ITDB1

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 19-NOV-2007 16:35:47

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/home/foglight5/oracle/product/10.2.0/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

No comments: