| Multiplie Homes - TNS Problems [message #60083] |
Wed, 14 January 2004 06:01  |
JOHN
Messages: 182
Registered: April 1998
|
Senior Member |
|
|
Hello there. Please can anyone help?
We are building a server with 2 Oracle databases on running different applications which are connected. One is version 9.2 and the other is 8.1.7.
I am getting ORA-12560: TNS:protocol adapter error when trying to connect to the 8.1.7 version.
I can TNSPING both of the different SIDS ok. Here is the output from LSNRCTL - STATUS on the 8.1.7 SID:
Services Summary...
B0D has 1 service handler(s)
PLSExtProc has 1 service handler(s)
RQD has 1 service handler(s)
The command completed successfully
LSNRCTL>
And here is the output from LSNRCTL - STATUS from the 9.2 SID
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=brksapbd.hayscsg.com)(PORT=1527
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeB0Dipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeB0D.worldipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeRQDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeRQD.worldipc)))
Services Summary...
Service "B0D" has 1 instance(s).
Instance "B0D", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service.
Service "RQD" has 1 instance(s).
Instance "RQD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
At present only the 9.2 database is up and running.
Sorry for the length of this post but I am stumped! Any help would be appreciated.
John.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
