PDA

View Full Version : Multiple Oracle instances in Oracle8i Enterprise Edition

pradip_chanda
03-21-03, 03:30
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!
BSchol
04-03-03, 10:23
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
osy45
04-09-03, 02:21
did you configure the listener.ora file for the second SID and restarted it

... and the tnsnames.ora file
Ruudboy
05-11-03, 11:12
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.