Q

Problems starting one of two databases on same server

I have created two Oracle 9i databases on the same server. To start one database I just issue a command STARTUP and it starts, but when I try to start the other database on the same machine with the startup command I receive an error.

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.

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 last published in October 2005

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close