| How to STARTUP multiple Oracle Databases, using sqlplus [message #481533] |
Wed, 03 November 2010 23:22  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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!
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
