Re: Oracle 7.3.2 Multiple Databases on SCO

You need to configure your kernel to handle the additional semaphore resources.

You may want to check on the shared memory settings while you're there.

Steve

"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 Mon Aug 20 2001 - 12:45:47 CDT