Link to home
Start Free TrialLog in
Avatar of jtittler
jtittlerFlag for United States of America

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\db)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = BDA)
      (ORACLE_HOME = C:\oracle\product\10.1.0\db)
    )
  )
///////////////////////////////
10G - sqlnet.ora
///////////////////////////////
SQLNET.AUTHENTICATION_SERVICES= (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_SERVICES = (NTS)
//////////////////////////////////

Thank you very much,
Julie

Avatar of Metanil
Metanil

try changing 9i all(both listenter.ora and tnsname.ora) listening port to some other like 10521

and then restart your listener.


Metanil
SOLUTION
Avatar of MohanKNair
MohanKNair

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial