Home » RDBMS Server » Server Administration » multiple db
multiple db [message #56884] Fri, 02 May 2003 12:07 Go to next message
Raju
Messages: 74
Registered: March 1999
Member
How to create multiple dbs in one server.I created separate pfile,passwordfile,and not able to register the enviroment variable more than one at a time in service.Whether we have to change only is sid_list in listener.ora or anything
pls hlp
Re: multiple db [message #56887 is a reply to message #56884] Fri, 02 May 2003 12:59 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
you can have as many database as you can ( as long as u have resources).
every database needs a unique sid.
in UNIX:
export your ORACLE_SID everytime u want to startup / shutdown or use the dbstart script along with oratab, 
so one script can startup/shutdown all databases
in WINDOWS:
create ur own service for every database ( ORACLE_SID).
use ORADIM to do this.

 rem Delete the old service
         ORADIM -DELETE -SID test -SRVC servicename

 rem Create a new services with the STARTMODE AUTO property
         oradim -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile C:orantadminTESTpfileinitTEST.ora

Previous Topic: lost tab table !!!!!!!!!!!!!!!!
Next Topic: URGENT: Index copy
Goto Forum:
  


Current Time: Mon Dec 30 15:16:19 CST 2024