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.