multiple db [message #56884] |
Fri, 02 May 2003 12:07 |
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 |
|
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
|
|
|