Oracle 7.3.2 Multiple Databases on SCO

From: Doug Pippel <dougp_at_primenet.com>
Date: 20 Aug 2001 14:49:21 GMT
Message-ID: <9lr81h$eu$1@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 - 09:49:21 CDT