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

    Start up oracle instance

    979666
      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?

      Thanks
        • 1. Re: Start up oracle instance
          asahide
          Hi,

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

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

          Regards,
          • 2. Re: Start up oracle instance
            979666
            hello,

            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
              Hi,

              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
              http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6.php

              Regards
              Mahir M. Quluzade
              http://www.mahir-quluzade.com
              • 4. Re: Start up oracle instance
                979666
                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...