Home » Infrastructure » Linux » creating multiple databases...?
creating multiple databases...? [message #134099] Tue, 23 August 2005 10:16 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai all,

we have our 9i database server under linux and running it.in the mean while we need to create one more database on it.the linux server is redhat linux 7.0 and there is no DBCA to do this easily.

1.the question is whether one or more databases can be created under linux and if yes how to do manually..?plz come out with steps..!

2.in linux we need to set ORACLE_SID for the database to be created and there exists one ORACLE_SID and we once set the new ORACLE_SID for the new database to be created , the old existing ORACLE_SID is overwritten.is it right...?but we made the old database to start automatically when linux restarts as by the dbstart script.in that case, if new database is created, which will get started..?because the dbstart script takes the pfile of the database to be started as init$ORACLE_SID.ora, since the ORACLE_SID is overwritten while creating new database , the old ORACLE_SID vanished and the dbstart script takes the pfile of the newly created database finally the old database will not get started by dbstart and hence we need to start the old database manually.hope u understand the scenario.what to do?

plz let us clear.
regards
bala
Re: creating multiple databases...? [message #134134 is a reply to message #134099] Tue, 23 August 2005 11:26 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>1.the question is whether one or more databases can be created under
>>linux and if yes how to do manually..?plz come out with steps..!

DBCA uses the CREATE database statement in GUI. thats it.
You can always create databases manually ( DBCA mode database creation is must for RAC. Not for single instance databases).

Google yourself for this. There must a ton of links available like this

http://www.dbasupport.com/oracle/ora9i/solutions/createDB.shtml

>>.hope u understand the scenario.what to do?
You are confusing yourself and others, by not reading the documenation.

ORACLE_SID is not overwritten or erased.
it is a environment variable. It is just set / unset for that particular session.
to autostart the database,the dbstart/dbshut will read oratab file.
if you have proper entries in oratab file, dbstart/dbshut will automatically controll all the databases. And you are in 9i and you must be using spfile. not pfiles to startup/shutdown.
Previous Topic: parallel program execution!!
Next Topic: Cannot open DB in exclusive mode
Goto Forum:
  


Current Time: Thu Mar 28 16:38:40 CDT 2024