| multiple dbs, 1 listener [message #63746] |
Thu, 04 November 2004 07:03  |
jimbob
Messages: 20
Registered: April 2004
|
Junior Member |
|
|
I am running an 8.1.7 & 9.2 db on the same server. I am running only 1 listener. I am able to connect to both dbs successfully from an external box, but when I am only able to connect to one db (9.2) from the server itself. I have looked over my tnsnames.ora file and don't see anything wrong. I have run multiple dbs in the past, although they were of the same version with only 1 home. TIA
when using sqlplus username@sid
I am getting the error:
ORA-12154: TNS:could not resolve service name
when setting my ORACLE_SID=sid
then using sqlplus username
I am getting the error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Any direction is appreciated.
jb
|
|
|
|
| Re: multiple dbs, 1 listener [message #63747 is a reply to message #63746] |
Thu, 04 November 2004 10:03  |
billh
Messages: 35
Registered: August 1999
|
Member |
|
|
jb,
In your listener.ora file make sure ORACLE_HOME parameter in the SID_DESC is referencing the correct ORACLE_HOME for the database.
When setting ORACLE_SID you are running into a conflict where database is started under one ORACLE_HOME and the ORACLE_HOME environmental variable is set to the other ORACLE_HOME.
|
|
|
|
| Re: multiple dbs, 1 listener [message #63748 is a reply to message #63746] |
Thu, 04 November 2004 10:47 |
croK
Messages: 170
Registered: April 2002
|
Senior Member |
|
|
Not only tnsnames.ora configuration must be available, but listener.ora must point to both oracle_homes
example:
L9I =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= PRUEBAS))
(ADDRESS= (PROTOCOL= TCP)(Host= localhost)(Port= 1555))
)
SID_LIST_L9I =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= d:oracleora9201)
(SID_name = ora9db)
)
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= d:oracleora817)
(SID_name = ora8db)
)
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
