1 2 Previous Next 17 Replies Latest reply: Mar 21, 2014 10:39 AM by BPeaslandDBA RSS

    can not start database instance

    user4904817

      I am using 11gr2 on centos 5.10 in RAC

      i was getting target_memory error earlier but that went away after increasing tmpfs

      now i am getting following error

       

      i followed following documentation to install

      ORACLE-BASE - Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2

       

      SQL> startup;

      ORA-01078: failure in processing system parameters

      ORA-01565: error in identifying file '+DATA/rac/spfilerac.ora'

      ORA-17503: ksfdopn:2 Failed to open file +DATA/rac/spfilerac.ora

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

        • 1. Re: can not start database instance
          Baris Yildirim

          check your DATA diskgroup whether the diskgroup has been mounted or not

           

          Regards

          • 2. Re: can not start database instance
            user4904817

            [root@rac1 u01]# /etc/init.d/oracleasm start

            Initializing the Oracle ASMLib driver:                     [  OK  ]

            Scanning the system for Oracle ASMLib disks:               [  OK  ]

            [root@rac1 u01]# /usr/sbin/oracleasm init

            [root@rac1 u01]# /usr/sbin/oracleasm scandisks

            Reloading disk partitions: done

            Cleaning any stale ASM disks...

            Scanning system for ASM disks...

            [root@rac1 u01]# /usr/sbin/oracleasm listdisks

            DISK1

            DISK2

            DISK3

            DISK4

            DISK5

            [root@rac1 u01]# /usr/sbin/oracleasm init

            [root@rac1 u01]#

            [root@rac1 u01]#

            [root@rac1 u01]# su - oracle

            [oracle@rac1 ~]$ sqlplus '/as sysdba'

             

             

            SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 16:10:55 2014

             

             

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

             

             

            Connected to an idle instance.

             

             

            SQL> startup;

            ORA-01078: failure in processing system parameters

            ORA-01565: error in identifying file '+DATA/rac/spfilerac.ora'

            ORA-17503: ksfdopn:2 Failed to open file +DATA/rac/spfilerac.ora

            ORA-01034: ORACLE not available

            ORA-27101: shared memory realm does not exist

            Linux-x86_64 Error: 2: No such file or directory

            SQL>

            • 3. Re: can not start database instance
              Baris Yildirim

              from grid home by oracle user

               

              asmcmd

               

              lsdg

               

              if unmounted

               

              mount data

               

              Regards

              • 4. Re: can not start database instance
                user4904817

                [oracle@rac1 ~]$ grid_env

                [oracle@rac1 ~]$ asmcmd

                Connected to an idle instance.

                ASMCMD> lsdg

                ASMCMD-08102: no connection to ASM; command requires ASM to run

                ASMCMD> ^C[oracle@rac1 ~]$

                [oracle@rac1 ~]$ mount data

                mount: can't find data in /etc/fstab or /etc/mtab

                [oracle@rac1 ~]$ asmcmd

                Connected to an idle instance.

                ASMCMD> mount DATA

                ASMCMD-08102: no connection to ASM; command requires ASM to run

                ASMCMD> ^C[oracle@rac1 ~]$ cat grid_env

                ORACLE_SID=+ASM1; export ORACLE_SID

                ORACLE_HOME=$GRID_HOME; export ORACLE_HOME

                PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

                 

                 

                LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

                CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

                [oracle@rac1 ~]$

                • 5. Re: can not start database instance
                  Baris Yildirim

                  grid_env

                  export ORACLE_SID=+ASM1

                  sqlplus / as sysasm

                  startup;

                  exit

                   

                  asmcmd

                  lsdg

                  mount data

                   

                  Regards

                  • 6. Re: can not start database instance
                    user4904817

                    [oracle@rac1 ~]$ grid_env

                    [oracle@rac1 ~]$ echo $ORACLE_SID

                    +ASM1

                    [oracle@rac1 ~]$ sqlplus '/as sysdba'

                     

                     

                    SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 16:47:49 2014

                     

                     

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

                     

                     

                    Connected to an idle instance.

                     

                     

                    SQL> ^C

                     

                     

                    SQL> Disconnected

                    [oracle@rac1 ~]$ sqlplus '/as sysasm'

                     

                     

                    SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 16:48:05 2014

                     

                     

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

                     

                     

                    Connected to an idle instance.

                     

                     

                    SQL> startup;

                    ASM instance started

                     

                     

                    Total System Global Area  283930624 bytes

                    Fixed Size                  2212656 bytes

                    Variable Size             256552144 bytes

                    ASM Cache                  25165824 bytes

                    ASM diskgroups mounted

                    SQL> exit

                    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

                    With the Real Application Clusters and Automatic Storage Management options

                    [oracle@rac1 ~]$ asmcmd

                    ASMCMD> lsdg

                    State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

                    MOUNTED  EXTERN  N         512   4096  1048576    102395   100254                0          100254              0             N  DATA/

                    ASMCMD> mount DATA

                    ORA-15032: not all alterations performed

                    ORA-15017: diskgroup "DATA" cannot be mounted

                    ORA-15013: diskgroup "DATA" is already mounted (DBD ERROR: OCIStmtExecute)

                    ASMCMD>

                    • 7. Re: can not start database instance
                      Baris Yildirim

                      ok now try to open your database

                       

                      Regards

                      • 8. Re: can not start database instance
                        Baris Yildirim

                        but it's a rac, asm should have been started with crs stack(in 11g). I think there is a problem on crs. Check the crs logs

                         

                        Regards

                        • 9. Re: can not start database instance
                          user4904817

                          [oracle@rac1 ~]$ sqlplus '/as sysdba'

                           

                           

                          SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 10 16:57:13 2014

                           

                           

                          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 Real Application Clusters and Automatic Storage Management options

                           

                           

                          SQL> startup;

                          ORA-01031: insufficient privileges

                          SQL>

                           

                          thank you for your support.

                          how do i fix insufficient privileges error ?

                          where is crs log located?

                          • 10. Re: can not start database instance
                            Baris Yildirim

                            Did you set ORACLE_HOME to database home?

                            Did you set ORACLE_SID?

                             

                            Regards

                            • 11. Re: can not start database instance
                              user4904817

                              [oracle@rac1 ~]$ echo $ORACLE_HOME

                              /u01/app/oracle/product/11.2.0/db_1

                              [oracle@rac1 ~]$ echo $ORACLE_SID

                              RAC1

                              • 12. Re: can not start database instance
                                user4904817

                                interestingly, one file in following directory need to be renamed to upper case RAC1. i do not know why all files were created with lower case rac1 when system was expecting upper case rac1.

                                 

                                [root@rac1 u01]# cd ./app/oracle/product/11.2.0/db_1/dbs

                                [root@rac1 dbs]# ls -ltr

                                total 20

                                -rwxrwxr-x 1 oracle oinstall 2851 May 15  2009 init.ora

                                -rwxrwxr-x 1 oracle oinstall   33 Mar 10 13:18 initRAC1.ora

                                -rwxrwxr-x 1 oracle oinstall 1536 Mar 10 13:19 orapwrac1

                                -rwxrwxr-x 1 oracle oinstall   56 Mar 10 14:48 initrac1.ora

                                -rwxrwxr-x 1 oracle oinstall 1544 Mar 10 16:48 hc_rac1.dat

                                • 13. Re: can not start database instance
                                  Baris Yildirim

                                  Do you have a password file?

                                   

                                  /u01/app/oracle/product/11.2.0/db_1/dbs/orapwRAC1



                                  • 14. Re: can not start database instance
                                    user4904817

                                    [root@rac1 cifs]# ls -ltr /u01/app/oracle/product/11.2.0/db_1/dbs/orapwRAC1

                                    ls: /u01/app/oracle/product/11.2.0/db_1/dbs/orapwRAC1: No such file or directory

                                    You have new mail in /var/spool/mail/root

                                    [root@rac1 cifs]# ls -ltr /u01/app/oracle/product/11.2.0/db_1/dbs/orapwrac1

                                    -rwxrwxr-x 1 oracle oinstall 1536 Mar 10 13:19 /u01/app/oracle/product/11.2.0/db_1/dbs/orapwrac1

                                    [root@rac1 cifs]#

                                    1 2 Previous Next