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!

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

did you configure the listener.ora file for the second SID and restarted it

... and the tnsnames.ora file

You cannot set 2 at the same time.
You need to set the ORACLE_SID for the database you want to start.