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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close