Re: Oracle 7.3.2 Multiple Databases on SCO

Hi,

Your problem is the ORACLE_SID variable. Set the ORACLE_SID to the right value before you start the second db. And you will see the Database works. If you want to toggle between the databases you have also toggle the ORACLE_SID values.

Mike

Doug Pippel <dougp_at_primenet.com> wrote in message news:9lr81h$eu$1_at_nnrp1.phx.gblx.net...
> Hello everyone. I'm a new Oracle user trying to get multiple databases up
and
> running using v7.3.2 on a SCO Openserver v5.0.5 system. Shouldn't be any
> different than a Solaris installation. Anyway, here's my problem:
>
> I've got an existing database that's running fine on this box. I tweaked
the
> db creation scripts, init$SID.ora and config$SID.ora files used to create
> this database and changed the SID references to create the new database.
This
> was successful. I can start the new SID up and connect to it with both
> SQLPLUS and SVRMGRL. What I *cannot* do is run BOTH databases
simultaneously.
> Here's my /etc/oratab file:
>
> AUI4:/eng/oracle/server:Y
> ELIASB:/eng/oracle/server:Y
>
> When dbstart executes using this file, only the first database (AUI4)
starts
> up. Error messages are generated when it attempts to start the ELIASB
database:
>
> ----
> SVRMGR> Connected to an idle instance.
> SVRMGR> ORA-07279: spcre: semget error, uable to get first semaphore set
> AT&T System V/386 Error: 28: No space left on device
> Additional Information: 1
> SVRMGR>
> Server Manager complete.
> Database "ELIASB" warm started.
> ----
>
> I don't know what the "No space left on device" is being caused by. This
system
> has an 18GB drive with a single partition and there's 15GB free on the
filesystem.
>
> Here's my /etc/listener.ora file:
>
> LISTENER=
> (ADDRESS_LIST=
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = bhaui1.mps.bellhowell.com)
> (PORT = 1526)
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = AUI4)
> (ORACLE_HOME = /eng/oracle/server)
> )
> (SID_DESC =
> (SID_NAME = ELIASB)
> (ORACLE_HOME = /eng/oracle/server)
> )
> )
>
>
> STARTUP_WAIT_TIME_LISTENER=0
> CONNECT_TIMEOUT_LISTENER=0
> #TRACE_LEVEL_LISTENER=16
> #TRACE_LEVEL_LISTENER=ADMIN
> TRACE_DIRECTORY_LISTENER=/eng/oracle/server/network/trace
> TRACE_FILE_LISTENER=LISTENER
> LOG_DIRECTORY_LISTENER=/eng/oracle/server/network/log
> LOG_FILE_LISTENER=LISTENER
>
> And here's my /etc/tnsnames.ora file:
>
> AUI4=
> (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=bhaui1.mps.bellhowell.com)
> (PORT=1526)
> )
> (CONNECT_DATA=
> (SID=AUI4)
> )
> )
>
> IM=
> (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=sitemanager.mps.bellhowell.com)
> (PORT=1526)
> )
> (CONNECT_DATA=
> (SID=AUI)
> )
> )
>
> ELIASB=
> (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=bhaui1.mps.bellhowell.com)
> (PORT=1526)
> )
> (CONNECT_DATA=
> (SID=ELIASB)
> )
> )
>
> IM=
> (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=sitemanager.mps.bellhowell.com)
> (PORT=1526)
> )
> (CONNECT_DATA=
> (SID=ELIASB)
> )
> )
>
>
> If anyone has any ideas, know's from a glance what I'm doing wrong or has
> any helpful advice, I'd certainly appreciate hearing form you. Thanks!
>
> DP
>
>
Received on Tue Aug 21 2001 - 07:39:29 CDT