jtittler
asked on
ORA-12514 error on server with both 9i and 10g on same machine
I have an Oracle server which I've been using to support 9i db application development. There are a number of existing 9i db's on it. I have recently begun a project using 10g. I figured that I could use the same machine. I made sure that the 10g home was different than the 9i home. I tried having the 10g listener listening on the same port and on a different port than 9i. No luck. Unfortunately, none of my db's work now. I think my poor computer is confused with both 9i and 10g on it. Is there anyway to support both on the same machine? Is there a way to resolve the current conflict so I can at least make the 10g db work without scragging my 9i db's? Below are my .ora files for both 9i and 10g:
////////////////////////// /
10G Listener.ora
//////////////////////////
LISTENER_10G =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER_10G =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\d b)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = BDA)
(ORACLE_HOME = C:\oracle\product\10.1.0\d b)
)
)
////////////////////////// /////
10G - sqlnet.ora
////////////////////////// /////
SQLNET.AUTHENTICATION_SERV ICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES)
////////////////////////// /////
////////////////////////// ////
10G - tnsnames.ora
////////////////////////// ////
BDA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BDA)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
////////////////////////// ///
XXXXXXXXXXXXXXXXXXxxxx
////////////////////////// ///
9i - listener.ora
////////////////////////// ///
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = STELLA.TITTLERS)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = STELLA)
)
(SID_DESC =
(GLOBAL_DBNAME = AODB)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = AODB)
)
(SID_DESC =
(GLOBAL_DBNAME = NIMS)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = NIMS)
)
)
////////////////////////// ////////// ///
////////////////////////// ////////// ///
9i - tnsnames.ora
////////////////////////// ////////// ///
STELLA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STELLA.TITTLERS)
)
)
NIMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NIMS)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
AODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AODB)
)
)
WMD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PAVONIS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WMD)
)
)
////////////////////////// ////////// /////
////////////////////////// /////////
9i - sqlnet.ora
////////////////////////// /////////
SQLNET.AUTHENTICATION_SERV ICES = (NTS)
////////////////////////// ////////
Thank you very much,
Julie
//////////////////////////
10G Listener.ora
//////////////////////////
LISTENER_10G =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER_10G =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\d
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = BDA)
(ORACLE_HOME = C:\oracle\product\10.1.0\d
)
)
//////////////////////////
10G - sqlnet.ora
//////////////////////////
SQLNET.AUTHENTICATION_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES)
//////////////////////////
//////////////////////////
10G - tnsnames.ora
//////////////////////////
BDA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BDA)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
//////////////////////////
XXXXXXXXXXXXXXXXXXxxxx
//////////////////////////
9i - listener.ora
//////////////////////////
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = STELLA.TITTLERS)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = STELLA)
)
(SID_DESC =
(GLOBAL_DBNAME = AODB)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = AODB)
)
(SID_DESC =
(GLOBAL_DBNAME = NIMS)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = NIMS)
)
)
//////////////////////////
//////////////////////////
9i - tnsnames.ora
//////////////////////////
STELLA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = STELLA.TITTLERS)
)
)
NIMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NIMS)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
AODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pavonis)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AODB)
)
)
WMD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PAVONIS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WMD)
)
)
//////////////////////////
//////////////////////////
9i - sqlnet.ora
//////////////////////////
SQLNET.AUTHENTICATION_SERV
//////////////////////////
Thank you very much,
Julie
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and then restart your listener.
Metanil