Home » Infrastructure » Unix » How to STARTUP multiple Oracle Databases, using sqlplus
How to STARTUP multiple Oracle Databases, using sqlplus [message #481533] Wed, 03 November 2010 23:22 Go to next message
ajazz102
Messages: 2
Registered: November 2010
Location: Singapore
Junior Member
Hi guys,

I am pretty new at solaris and oracle, right now i have oracle 11gr2 installed in my Solaris 10 machine.

I managed to create 2 databases with 2 different ORACLE_SID, (e.g. A & B)

my question is, is it possible to have both of this Databases mounted and opened??

here is the step i have done so far:

1. go to /ORACLE_HOME/bin

2. I started my one and only LISTENER - ./lsnrctl start LISTENER

3. ORACLE_SID=A

4. ./sqlplus / as sysdba

5. SQL>STARTUP

Everything went well, until i set another ORACLE_SID (in another terminal) to ORACLE_SID=B, and when i tried to start it up using SQLPLUS, i get this "Segmentation Fault - core dumped".

It seems like i start the 2nd database wrongly, is there proper way to do this? i need the 2 databases (SID A & SID B) to be running concurrently. thanks
Re: How to STARTUP multiple Oracle Databases, using sqlplus [message #481538 is a reply to message #481533] Thu, 04 November 2010 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not just explain what you did and got, SHOW us: copy and paste your session (inline, in text, NO image or screen shot).

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Thu, 04 November 2010 01:07]

Report message to a moderator

Re: How to STARTUP multiple Oracle Databases instances, using sqlplus [message #481554 is a reply to message #481538] Thu, 04 November 2010 03:11 Go to previous messageGo to next message
ajazz102
Messages: 2
Registered: November 2010
Location: Singapore
Junior Member
$ ORACLE_SID=AM
$ export ORACLE_SID

$ ./lsnrctl start LISTENER

LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 04-NOV-2010 14:38:45

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/unknown/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.77)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.77)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date 04-NOV-2010 14:38:49
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/unknown/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.77)(PORT=1521)))
The listener supports no services
The command completed successfully

$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 4 14:39:52 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> STARTUP
ORACLE instance started.

Total System Global Area 855982080 bytes
Fixed Size 2215824 bytes
Variable Size 562036848 bytes
Database Buffers 285212672 bytes
Redo Buffers 6516736 bytes
Database mounted.
Database opened.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ ORACLE_SID=SDB3

$ export ORACLE_SID

$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 4 15:11:22 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> STARTUP
Segmentation Fault - core dumped


Hi Michel, thanks for the helpful tips, i wasn't aware of all the regulations.

ORACLE VERSION 11.2.0

Above is the sum of the things i did. I was trying to get the 2 database instances up and running but to no avail.

Would appreciate all your help, since i been stuck here for almost 3 days =p, THANKS!
Re: How to STARTUP multiple Oracle Databases instances, using sqlplus [message #481555 is a reply to message #481554] Thu, 04 November 2010 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is SDB3 a 11.2 database?
Check alert.log if there is any message at this startup time.
Check trace directory if there is any trace file generated at this startup time.

Regards
Michel

Re: How to STARTUP multiple Oracle Databases instances, using sqlplus [message #481556 is a reply to message #481555] Thu, 04 November 2010 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget to add, post result of
uname -a
pwd
ls -l ./sqlplus
env | egrep '(ORACLE|LIB|PATH)' | sort

Regards
Michel

[Updated on: Thu, 04 November 2010 03:36]

Report message to a moderator

Re: How to STARTUP multiple Oracle Databases instances, using sqlplus [message #481725 is a reply to message #481556] Fri, 05 November 2010 12:15 Go to previous message
mkounalis
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Would also be nice to see what the contents of the alert log for the other instance that faulted shows.
Previous Topic: Unmatched error at line 28. Please help
Next Topic: not able to edit crontab
Goto Forum:
  


Current Time: Tue Mar 19 00:49:00 CDT 2024