Home » RDBMS Server » Server Administration » How to startup second database - created by DBCA (Oracle 10g, 2, Oracle Unbreakable Linux)
How to startup second database - created by DBCA [message #396950] Wed, 08 April 2009 08:30 Go to next message
ey390
Messages: 4
Registered: April 2009
Junior Member
I have Oracle 10g installed in Oracle Unbreakable Linux and everything is OK, except that I can't figure out how to start a second database (let's say SID=DB2), after it was created with DBCA.

DB2 worked immediately after creation, but after reboot, there is no way to start it - I thought that being 'sys as sysdba' from SQL prompt:

SQL> startup <options> PFILE=$ORACLE_HOME/dbs/<pfile for DB2> -

but this doesn't work- it says something like: 'Oracle instance is already running ...'.

BTW: TRUE or FALSE: One Oracle instance - One database, Second database - requires second Oracle instance ?
Re: How to startup second database - created by DBCA [message #396956 is a reply to message #396950] Wed, 08 April 2009 08:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set your ORACLE_SID=DB2 and try
Re: How to startup second database - created by DBCA [message #396999 is a reply to message #396950] Wed, 08 April 2009 10:23 Go to previous messageGo to next message
ey390
Messages: 4
Registered: April 2009
Junior Member
Yes, it looks like working.

$>export ORALCE_SID=DB2

and then:
SQL>startup
I get "can't open .../dbs/initDB2.ora"

But if I try:
SQL>startup PFILE=.../dbs/spfileDB2.ora
then it succeedes.

thank you a lot.
Re: How to startup second database - created by DBCA [message #397008 is a reply to message #396999] Wed, 08 April 2009 10:57 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for your feedback.

and then:
SQL>startup
I get "can't open .../dbs/initDB2.ora"


post output of below details.
cd .../dbs

ls -lrt 


Babu
Re: How to startup second database - created by DBCA [message #397021 is a reply to message #396950] Wed, 08 April 2009 11:38 Go to previous messageGo to next message
ey390
Messages: 4
Registered: April 2009
Junior Member
total 64
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 1544 Jul 29 2007 hc_DB1.dat
-rw-r----- 1 oracle oinstall 24 Jul 29 2007 lkDB1
-rw-r--r-- 1 oracle oinstall 976 Sep 5 2007 DB1_init.ora
-rw-rw---- 1 oracle oinstall 1544 Apr 3 08:53 hc_DB2.dat
-rw-rw---- 1 oracle oinstall 24 Apr 3 18:29 lkDB2
-rw-r----- 1 oracle oinstall 1536 Apr 3 20:21 orapwDB2
-rw-r----- 1 oracle oinstall 1536 Apr 3 20:27 orapwDB1
-rw-r----- 1 oracle oinstall 1178 Apr 5 21:02 spfileDB2.ora
-rw-r----- 1 oracle oinstall 2560 Apr 8 11:01 spfileDB1.ora

as a result of

$>ls -lrt $ORACLE_HOME/dbs

obviously DB2_init.ora is not there --> what is the prob ?
Re: How to startup second database - created by DBCA [message #397022 is a reply to message #397021] Wed, 08 April 2009 11:50 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Connect Sys user. 

Create pfile from spfile;

cd $ORACLE_HOME/dbs

ls -lrt 


Babu

[Updated on: Wed, 08 April 2009 11:50]

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397044 is a reply to message #396950] Wed, 08 April 2009 13:13 Go to previous messageGo to next message
ey390
Messages: 4
Registered: April 2009
Junior Member
what do you mean "create pfile from spfile" ?

dbs$>cp spfileDB2.ora pfileDB2.ora

what is the purpose ?
Re: How to startup second database - created by DBCA [message #397045 is a reply to message #397044] Wed, 08 April 2009 13:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That was create inside sql*plus.
You are not supposed to edit spfile.
Init.ora files are for edits.
Re: How to startup second database - created by DBCA [message #397046 is a reply to message #397044] Wed, 08 April 2009 13:15 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

You know difference between spfile and pfile ??

Check Here

Babu

[Updated on: Wed, 08 April 2009 13:16]

Report message to a moderator

Previous Topic: Oracle lite problem
Next Topic: 10g ORA-01033 Shutdown in process
Goto Forum:
  


Current Time: Wed Dec 07 20:10:24 CST 2016

Total time taken to generate the page: 0.08607 seconds