1 2 Previous Next 17 Replies Latest reply: Oct 18, 2010 10:24 AM by Chinar RSS

    How to Install Oracle Restart

    772262
      Hello All,
      I have a standby database with ASM. I would like it to be start on the server reboot.

      I have read chapter 4 of Oracle Database Administration Guide 11g R2 where it mentions
      If you install Oracle Restart by installing the Oracle Grid Infrastructure for a
      standalone server and then create your database, the database is automatically added
      to the Oracle Restart configuration, and is then automatically restarted when required.
      However, if you install Oracle Restart on a host computer on which a database already
      exists, you must manually add the database, the listener, the Oracle Automatic Storage
      Management (Oracle ASM) instance, and possibly other components to the Oracle
      Restart configuration.

      Please can someone help me with the steps to setup Orace restart in 11gr2.

      Thanks
        • 1. Re: How to Install Oracle Restart
          277993
          Your Platform ?
          • 2. Re: How to Install Oracle Restart
            772262
            Linux 2.6.18-194.11.3.el5 #1 SMP Mon Aug 23 15:51:38 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
            • 3. Re: How to Install Oracle Restart
              Chinar
              user5846399 wrote:
              Hello All,
              I have a standby database with ASM. I would like it to be start on the server reboot.

              I have read chapter 4 of Oracle Database Administration Guide 11g R2 where it mentions
              If you install Oracle Restart by installing the Oracle Grid Infrastructure for a
              standalone server and then create your database, the database is automatically added
              to the Oracle Restart configuration, and is then automatically restarted when required.
              However, if you install Oracle Restart on a host computer on which a database already
              exists, you must manually add the database, the listener, the Oracle Automatic Storage
              Management (Oracle ASM) instance, and possibly other components to the Oracle
              Restart configuration.

              Please can someone help me with the steps to setup Orace restart in 11gr2.

              Thanks
              1) First You have to install Grid Infrastructure for stand alone server.Refer below link and download and install Grid Infrastructure
              http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
              2). Refer installation guide after install Grid Infrastructure you will get an new ORACLE_HOME for Grid inf.
              Then you can use srvctl to adding database into Oracle Restart configuration .For example
              srvctl add database -d <YOUR_DATABASENAME>
              Using srvctl add component option you can also add listener and ASM instance to Oracle Restart configuration.Then Oracle restart will automatically start database after rebooting server.
              • 4. Re: How to Install Oracle Restart
                772262
                [oracle@rs1pre92dvdbsa01 bin]$ . oraenv
                ORACLE_SID = [MDM2] ? MDM2
                The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
                [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:25:44 2010

                Copyright (c) 1982, 2009, Oracle. All rights reserved.

                Connected to an idle instance.

                SQL> startup
                ORACLE instance started.

                Total System Global Area 835104768 bytes
                Fixed Size 2217952 bytes
                Variable Size 608176160 bytes
                Database Buffers 218103808 bytes
                Redo Buffers 6606848 bytes
                Database mounted.
                Database opened.
                SQL> exit


                [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o open
                PRCD-1025 : Failed to create database MDM2
                PRKH-1013 : The oracle home open does not exist.
                [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o mount
                PRCD-1025 : Failed to create database MDM2
                PRKH-1013 : The oracle home mount does not exist.

                MDM2 database is existing, then what can be the reason for the above errors.
                • 5. Re: How to Install Oracle Restart
                  772262
                  SQL> select name,DB_UNIQUE_NAME from v$database;

                  NAME DB_UNIQUE_NAME
                  --------- ------------------------------
                  MDM MDM2

                  SQL> exit
                  • 6. Re: How to Install Oracle Restart
                    772262
                    SQL> select name,DB_UNIQUE_NAME from v$database;

                    NAME DB_UNIQUE_NAME
                    --------- ------------------------------
                    MDM MDM2

                    SQL> exit
                    • 7. Re: How to Install Oracle Restart
                      Chinar
                      user5846399 wrote:
                      [oracle@rs1pre92dvdbsa01 bin]$ . oraenv
                      ORACLE_SID = [MDM2] ? MDM2
                      The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
                      [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                      SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:25:44 2010

                      Copyright (c) 1982, 2009, Oracle. All rights reserved.

                      Connected to an idle instance.

                      SQL> startup
                      ORACLE instance started.

                      Total System Global Area 835104768 bytes
                      Fixed Size 2217952 bytes
                      Variable Size 608176160 bytes
                      Database Buffers 218103808 bytes
                      Redo Buffers 6606848 bytes
                      Database mounted.
                      Database opened.
                      SQL> exit


                      [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o open
                      PRCD-1025 : Failed to create database MDM2
                      PRKH-1013 : The oracle home open does not exist.
                      [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o mount
                      PRCD-1025 : Failed to create database MDM2
                      PRKH-1013 : The oracle home mount does not exist.

                      MDM2 database is existing, then what can be the reason for the above errors.
                      Try as following
                       srvctl add database -d MDM2 -o  /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                      And post result there
                      • 8. Re: How to Install Oracle Restart
                        772262
                        [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                        [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                        Database is not running.
                        [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                        SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:48:31 2010

                        Copyright (c) 1982, 2009, Oracle. All rights reserved.


                        Connected to:
                        Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                        With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                        and Real Application Testing options


                        SQL> select status from v$instance;

                        STATUS
                        ------------
                        OPEN

                        SQL>



                        -- Why does the status "not running"
                        • 9. Re: How to Install Oracle Restart
                          Chinar
                          user5846399 wrote:
                          [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                          [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                          Database is not running.
                          [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                          SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:48:31 2010

                          Copyright (c) 1982, 2009, Oracle. All rights reserved.


                          Connected to:
                          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                          With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                          and Real Application Testing options


                          SQL> select status from v$instance;

                          STATUS
                          ------------
                          OPEN

                          SQL>



                          -- Why does the status "not running"
                          Because this database manually added Oracle Restart configuration.Once you have to stop and start as
                          srvctl stop database -d MDM2
                          srvctl start database -d MDM2
                          srvctl status database -d MDM2
                          And post result there
                          • 10. Re: How to Install Oracle Restart
                            Chinar
                            user5846399 wrote:
                            [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                            [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                            Database is not running.
                            [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                            SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:48:31 2010

                            Copyright (c) 1982, 2009, Oracle. All rights reserved.


                            Connected to:
                            Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                            With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                            and Real Application Testing options


                            SQL> select status from v$instance;

                            STATUS
                            ------------
                            OPEN

                            SQL>



                            -- Why does the status "not running"
                            Because this database manually added Oracle Restart configuration.Once you have to stop and start as
                            srvctl stop database -d MDM2
                            srvctl start database -d MDM2
                            srvctl status database -d MDM2
                            And post result there
                            • 11. Re: How to Install Oracle Restart
                              Chinar
                              user5846399 wrote:
                              [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                              [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                              Database is not running.
                              [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                              SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:48:31 2010

                              Copyright (c) 1982, 2009, Oracle. All rights reserved.


                              Connected to:
                              Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                              With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                              and Real Application Testing options


                              SQL> select status from v$instance;

                              STATUS
                              ------------
                              OPEN

                              SQL>



                              -- Why does the status "not running"
                              Because this database manually added Oracle Restart configuration.Once you have to stop and start as
                              srvctl stop database -d MDM2
                              srvctl start database -d MDM2
                              srvctl status database -d MDM2
                              And post result there
                              • 12. Re: How to Install Oracle Restart
                                Chinar
                                user5846399 wrote:
                                [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s open
                                [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                                Database is not running.
                                [oracle@rs1pre92dvdbsa01 bin]$ sqlplus / as sysdba

                                SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 18 13:48:31 2010

                                Copyright (c) 1982, 2009, Oracle. All rights reserved.


                                Connected to:
                                Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                                With the Partitioning, Automatic Storage Management, OLAP, Data Mining
                                and Real Application Testing options


                                SQL> select status from v$instance;

                                STATUS
                                ------------
                                OPEN

                                SQL>



                                -- Why does the status "not running"
                                Because this database manually added Oracle Restart configuration.Once you have to stop and start as
                                srvctl stop database -d MDM2
                                srvctl start database -d MDM2
                                srvctl status database -d MDM2
                                And post result there
                                • 13. Re: How to Install Oracle Restart
                                  772262
                                  [oracle@rs1pre92dvdbsa01 bin]$ srvctl add database -d MDM2 -o /u01/app/oracle/product/11.2.0/dbhome_1 -s ope
                                  [oracle@rs1pre92dvdbsa01 bin]$ srvctl stop database -d MDM2
                                  PRCC-1016 : MDM2 was already stopped
                                  [oracle@rs1pre92dvdbsa01 bin]$ srvctl start database -d MDM2
                                  [oracle@rs1pre92dvdbsa01 bin]$ srvctl status database -d MDM2
                                  Database is running.
                                  [oracle@rs1pre92dvdbsa01 bin]$ su -
                                  Password:
                                  [root@rs1pre92dvdbsa01 ~]# reboot

                                  ***After reboot




                                  [oracle@rs1pre92dvdbsa01 ~]$ cat /etc/oratab
                                  #Backup file is /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/oratab.bak.r
                                  s1pre92dvdbsa01 line added by Agent
                                  #
                                  # This file is used by ORACLE utilities. It is created by root.sh
                                  # and updated by the Database Configuration Assistant when creating
                                  # a database.

                                  # A colon, ':', is used as the field terminator. A new line terminates
                                  # the entry. Lines beginning with a pound sign, '#', are comments.
                                  #
                                  # Entries are of the form:
                                  # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
                                  #
                                  # The first and second fields are the system identifier and home
                                  # directory of the database respectively. The third filed indicates
                                  # to the dbstart utility that the database should , "Y", or should not,
                                  # "N", be brought up at system boot time.
                                  #
                                  # Multiple entries with the same $ORACLE_SID are not allowed.
                                  #
                                  #
                                  +ASM:/u01/app/11.2.0/grid:N             # line added by Agent
                                  MDM2:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
                                  [oracle@rs1pre92dvdbsa01 ~]$ uptime
                                  14:02:28 up 3 min, 1 user, load average: 0.41, 0.75, 0.35
                                  [oracle@rs1pre92dvdbsa01 ~]$ ps -ef | grep pmon
                                  oracle 4314 1 0 14:01 ? 00:00:00 asm_pmon_+ASM
                                  oracle 4378 3878 0 14:02 pts/0 00:00:00 grep pmon
                                  [oracle@rs1pre92dvdbsa01 ~]$


                                  After rebooting the server MDM2 is not started
                                  Is is because oratab flag is N
                                  • 14. Re: How to Install Oracle Restart
                                    772262
                                    Do I need use any crs or ocfs utility or dbora script to startup.
                                    1 2 Previous Next