| urgent .......ERROR: ORA-12545: TNS:name lookup failure [message #18343] |
Mon, 28 January 2002 20:07  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
