| susk |
Posted: Jun 28, 2009 03:05:45 PM |
Total Post: 48
Joined: Jan, 2008
|
I had installed two oracle 10g instances on my machine one in c:/drive & another in d:/drive . After installation on d:/ drive when i am trying to login instance of c:/drive by giving oracle SID at command prompt i get following msg : ORA-12560: TNS:protocol adapter error
I think it somewhere related to port port 1521 was used twice , plz suggest further
plz help |
|
|
 sivakumar |
| Posted: Jun 28, 2009 11:49:16 PM |  |
|
Total Post: 18
Joined: Jan, 2009
|
hi,
check whether the listener for the database is start?
|
|
|
|
|
| susk |
| Posted: Jun 29, 2009 03:51:20 AM | |
|
Total Post: 48
Joined: Jan, 2008
|
|
|
|
|
| sivakumar |
| Posted: Jun 29, 2009 04:39:34 AM | |
|
Total Post: 18
Joined: Jan, 2009
|
checkout the tnsnames.ora file on the client side, whether the info provided in the tnsnames.ora file entries like (instance name,port no) are match with your listener.ora file. if so then issue the following command in command prompt,
c:\>lsnrctl start
if u got any error during this time post the complete description of that error.
|
|
|
|
|
| joshi |
| Posted: Jul 01, 2009 02:24:21 AM | |
|
Total Post: 9
Joined: Feb, 2009
|
check ur both listener port .always one port open for one listener.define both listener in different port.
|
|
|
|
|
| meeran |
| Posted: Jul 08, 2009 06:57:24 AM | |
|
Total Post: 2
Joined: Jul, 2009
|
hai,
U need start the oracle service of that particular instance if it has not already started.
sql>set oracle_sid=testdb
tnsprotocal adapter error
1)click start-->click run
2)type services.msc on run prompt.
3)select the oracle service named OracleServiceTESTDB.
4)start the oracle service by right clicking OracleServiceTESTDB and then click start.
|
|
|
|
|
| jogi |
| Posted: Jul 13, 2009 01:54:14 AM | |
|
Total Post: 73
Joined: Jul, 2007
|
Hi,
Check for the oracle instances, whether related service is running in the services i.e oracleservicedb1, oracleservicedb2.
Please follow the steps to over come the error.
1) stop the listener and restart
2) start the oracle services related to the database.
3) export the Path variables
4) set the oracle sids
Regards,
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
