Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    6

    Exclamation Unanswered: Multiple Oracle instances in Oracle8i Enterprise Edition

    I have oracle8i Enterprise edition running on SCO UNIXWARE (SVR4). I had one database instance running without any glitch. Then I created another database through 'database configuration assistant'($dbassist). But the system is unable to connect to the database (internal or any other user).

    The database is not starting up though the 'listener' is showing service threads/handlers for each database.

    Both of the database have been created from the same UNIX user login having same variable SETs.

    How do I set 2 oracle SID under a single user (UNIX) environment.

    Please help!

  2. #2
    Join Date
    Jun 2001
    Location
    The Netherlands
    Posts
    38
    You will have to set the correct oracle environment. You can use this by running the oraenv script as follows:

    . oraenv <<don't forget the blank between . and oraenv>>

    This will prompt you for an ORACLE_SID which you can find in /etc/oratab and set the environment accordingly.

    After setting the environment you can start the database using sqlplus:

    sqlplus /nolog
    >connect sys as sysdba
    password:

    >startup

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    did you configure the listener.ora file for the second SID and restarted it

    ... and the tnsnames.ora file

  4. #4
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191

    Re: Multiple Oracle instances in Oracle8i Enterprise Edition

    Originally posted by pradip_chanda
    How do I set 2 oracle SID under a single user (UNIX) environment.
    You cannot set 2 at the same time.
    You need to set the ORACLE_SID for the database you want to start.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •