4 Replies Latest reply: Dec 18, 2012 2:10 AM by 979666 RSS

    Start up oracle instance

      Hi all,

      Sorry for this simple question. I'm new to oracle and am facing problem starting up oracle database.

      I was told to change to oracle instance id after log in as oracle id, before I can run the startup command.

      May I know what does it mean and how to do that?

        • 1. Re: Start up oracle instance

          What do you mean "instance id" and "oracle id"?

          Belows are rights?
          instance id -> instanse_number
          oracle id -> oracle SID

          • 2. Re: Start up oracle instance

            the oracle id i meant was, we login as oracle user id.

            For the instance id, i was referring to the database instance id, which is the oracle SID

            Edited by: 976663 on Dec 17, 2012 10:46 PM
            • 3. Re: Start up oracle instance
              Mahir M. Quluzade

              Use .bash_profile file for setting Oracle environments or

               export ORACLE_BASE=/u01/app/oracle
               export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
               export ORACLE_SID=orcl -- or your SID
               cd $ORACLE_HOME
               ./sqlplus / as sysdba
               SQL> startup
              Please check : http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm

              Mahir M. Quluzade
              • 4. Re: Start up oracle instance
                Hi Mahir,

                Thanks a lot for your reply. Actually the problem we face is that there is a database instance that we failed to startup. We do not know on which machine the database is located. The listener status command shows all databases were up except that particular one. We were told that it is a separate instance from the instance we are starting, and was told to start it using the instruction I posted.

                lsnrctl status

                Service "db1..." has 1 instance(s).
                Instance "db1", status UNKNOWN, has 1 handler(s) for this service...