OraFAQ Forum: Server Administration » How to startup second database

Home » RDBMS Server » Server Administration » How to startup second database - created by DBCA (Oracle 10g, 2, Oracle Unbreakable Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to startup second database - created by DBCA [message #396950]

Wed, 08 April 2009 08:30

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 ?

Report message to a moderator

Re: How to startup second database - created by DBCA [message #396956 is a reply to message #396950]

Wed, 08 April 2009 08:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

set your ORACLE_SID=DB2 and try

Report message to a moderator

Re: How to startup second database - created by DBCA [message #396999 is a reply to message #396950]

Wed, 08 April 2009 10:23

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.

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397008 is a reply to message #396999]

Wed, 08 April 2009 10:57

babuknb
Messages: 1736
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

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397021 is a reply to message #396950]

Wed, 08 April 2009 11:38

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 ?

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397022 is a reply to message #397021]

Wed, 08 April 2009 11:50

babuknb
Messages: 1736
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

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 ?

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397045 is a reply to message #397044]

Wed, 08 April 2009 13:15

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: How to startup second database - created by DBCA [message #397046 is a reply to message #397044]

Wed, 08 April 2009 13:15

babuknb
Messages: 1736
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:25:28 CST 2024