2 ORACLE_SID on 1 Unix Box

Hi ORAPERTS (ORAcle exPERTS)
Greetings!

I have a simple basic questions - if anyone could clarify and provide solution.

I am using Oracle 9 on IBM AIX (Unix) System. I have created 2 Databases namely GAURI (created using DBCA) and TEST(created MANUALLY). I would like to know how could I swicth between the 2 Databases - I mean how could I use 2 INSTANCES of DB on Same Server Box. I have following files:

• TNSNAMES.ORA ****

  ---

  GAURI =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = gauri)
  ) ) INST1_HTTP =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVER = SHARED)
  (SERVICE_NAME = MODOSE)
  (PRESENTATION = http://HRService)
  ) ) EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (CONNECT_DATA =
  (SID = PLSExtProc)
  (PRESENTATION = RO)
  ) ) # THE FOLLOWING ENTRY WAS ADDED MANUALLY TEST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = test)
  ) )

  ---

• LISTENER.ORA ****

  ---

  LISTENER_TEST =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
  ) ) ) LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = mydomain)(PORT = 1521))
  ) ) ) SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /myghar/oracle)
  (PROGRAM = extproc)
  )
  (SID_DESC =
  (GLOBAL_DBNAME = gauri)
  (ORACLE_HOME = /myghar/oracle)
  (SID_NAME = gauri)
  ) # THE FOLLOWING SID ENTRY WAS ADDED MANUALLY
  (SID_DESC =
  (GLOBAL_DBNAME = test)
  (ORACLE_HOME = /myghar/oracle)
  (SID_NAME = test)
  ) )

  ---

  • QUESTIONS:

2) Do we need to have 2 LISTENERS - one for each DB. example in my case should I have LISTENER1 for GAURI and LISTENER2 for TEST?

3) How do I configure "netca" or "netmgr"....?

Any related info. on above is appreciated.

Many THANKS to you EXPERTS!

HARI Received on Fri Oct 25 2002 - 17:37:50 CEST