Installation problem [message #9491] |
Sat, 15 November 2003 01:39 |
saravanan
Messages: 70 Registered: October 2000
|
Member |
|
|
dear friends,
i have installed oracle 8i in my system (windows 2000). when i login sql*plus environment using scott/tiger giving following error
Enter user-name: scott/tiger
ERROR:
ORA-12560: TNS:protocol adapter error
how can i overcome this problem
please help me.
saravanan
|
|
|
Re: Installation problem [message #9505 is a reply to message #9491] |
Mon, 17 November 2003 07:37 |
Martin
Messages: 83 Registered: February 2000
|
Member |
|
|
HY saravanan maby this helps
open yor tnsnames.ora file
$ORACLE_HOME/network/admin
look for
this sektion
your_database_name =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yourmachine)(PORT = 1521))
)
(CONNECT_DATA =
(SID = your_sid)
(SERVER = DEDICATED)
)
)
try to login with scott/tiger@your_database_name
|
|
|