Home » RDBMS Server » Networking and Gateways » urgent .......ERROR: ORA-12545: TNS:name lookup failure
urgent .......ERROR: ORA-12545: TNS:name lookup failure [message #18343] Mon, 28 January 2002 20:07 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
Hai Oracle experts !
i have installed oracle 8 in a machine which is running
on windows nt.
after the installation
when i try to login to sql
i am getting the following message
how can i solve this problem.
tell me some thing about
SQL Net Easy Configurations as well

how can i connect to this oracle database from the client ?

ERROR: ORA-12545: TNS:name lookup failure

Enter user-name:

newcommer to oracle.
urgent please
Re: urgent .......ERROR: ORA-12545: TNS:name lookup failure [message #18345 is a reply to message #18343] Mon, 28 January 2002 22:55 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Open TNSNAMES.ora

Add
--------------------------------
STAGING =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STAG)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STAGING)
)
)

---------------------------------------
SERVICE_NAME = STAGING

STAGING is the database name .look db_name in init.ora on database server

HOST = STAG

STAG is your database machine name .

Now connect using username/password@staging
Previous Topic: SQL*Net/Net8
Next Topic: ORA-01034
Goto Forum:
  


Current Time: Fri Mar 29 03:04:13 CDT 2024