Ask the Expert

Problems starting one of two databases on same server

I have created two Oracle 9i databases on a Sun SPARC machine, and both the databases reside on the same server. One database name is OraSun and the other database name is OraTest. Now to start the OraSun database I just issue a command STARTUP and then OraSun starts, but when I try to start the other database, OraTest, on the same machine with the startup command I receive the following error:
ORA-01081:Cannot start already running ORACLE shut it down first.
 
Please explain to me what to do. Should I configure the .profile file or oratab file or do I have to set the Oracle environment correctly or set Oracle sid?

Please help me to solve the issue.

    Requires Free Membership to View

You need to make sure your ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH and PATH environment variables are set correctly. The LD_LIBRARY_PATH env var should contain the $ORACLE_HOME/lib directory. The PATH env var should contain the $ORACLE_HOME/bin directory. Since both your databases are the same version, they are probably using the same $ORACLE_HOME directory, therefore $ORACLE_HOME, $LD_LIBRARY_PATH, and $PATH do not need to change for each of the databases. However, you will need to change your $ORACLE_SID env var. Simply set $ORACLE_SID to ORATEST and when you fire up SQL*Plus and issue "connect / as sysdba." You will now be connecting to that database. Setting the env var depends on your shell.

For C Shell:

setenv ORACLE_SID oratest

For Korn Shell:

set ORACLE_SID oratest
export ORACLE_SID

This was first published in October 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: