13 Replies Latest reply: Apr 14, 2014 11:02 AM by Srini Chavali-Oracle RSS

    upgradation failiure

    955912

      Hi all ;

       

      I  am  upgrading my database from 10.2.04.0 to 11.2.0.1.0 Suddenly the system hanged . still  i  am facing problem.

      This is testing local database. I  don't want to enable audit. how can i continue my upgradation  process.

       

      $ . oraenv

      ORACLE_SID = [oracle] ? orcl

      [oracle@oel5 ~]$ sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 13 14:01:14 2014

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

       

      ERROR:

      ORA-09817: Write to audit file failed.

      Linux Error: 28: No space left on device

      Additional information: 12

      ORA-09945: Unable to initialize the audit trail file

      Linux Error: 28: No space left on device

      Enter user-name:

       

      $ df -TH

      Filesystem    Type     Size   Used  Avail Use% Mounted on

      /dev/sda8     ext3      14G   4.1G   8.7G  32% /

      /dev/sda7     ext3     2.1G   349M   1.6G  19% /tmp

      /dev/sda6     ext3     2.6G   491M   2.0G  21% /u03

      /dev/sda3     ext3     5.1G   1.1G   3.8G  23% /u02

      /dev/sda2     ext3      16G    15G      0 100% /u01

      /dev/sda1     ext3     152M    12M   132M   9% /boot

      tmpfs        tmpfs     830M      0   830M   0% /dev/shm

      .host:/     vmhgfs      55G    38G    18G  69% /mnt/hgfs

      /dev/hdc   iso9660     3.1G   3.1G      0 100% /media/Enterprise Linux dvd 20100405

        • 1. Re: upgradation failiure
          Krishna-Oracle

          We should have enough free space at /u01 to continue the upgrade.

          You can delete the auditing file or move to different location and continue the upgrade (manual upgrade)

          catupgrd.sql

           

          or

           

          First shutdown the database

          change audit file location to different location through parameter where free space is available.

          Start the database and disable auditing and continue the upgrade.

           

          Thanks,

          Krishna

          • 2. Re: upgradation failiure
            955912

            Hi Krishna;

             

            >> In pfile , i cant edit anything .. I am getting following  , when trying to edit ..

             

            "initorcl.ora" E514: write error (file system full?)

             

            >> in database also i cant connect  ..

             

            $ . oraenv

            ORACLE_SID = [oracle] ? orcl

            [oracle@oel5 ~]$ sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 13 15:46:24 2014

             

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

             

             

            ERROR:

            ORA-09817: Write to audit file failed.

            Linux Error: 28: No space left on device

            Additional information: 12

            ORA-09945: Unable to initialize the audit trail file

            Linux Error: 28: No space left on device

             

            Enter user-name: sys

            Enter password:

            ERROR:

            ORA-01034: ORACLE not available

            ORA-27101: shared memory realm does not exist

            Linux Error: 2: No such file or directory

            Process ID: 0

            Session ID: 0 Serial number: 0

             

            Enter user-name:

            • 3. Re: upgradation failiure
              Srini Chavali-Oracle

              Linux Error: 28: No space left on device

              As noted above, one or more of your file systems is full.

              • 4. Re: upgradation failiure
                955912

                Hi Srini ;

                 

                $ df -TH

                Filesystem    Type     Size   Used  Avail Use% Mounted on

                /dev/sda8     ext3      14G   4.1G   8.7G  32% /

                /dev/sda7     ext3     2.1G   349M   1.6G  19% /tmp

                /dev/sda6     ext3     2.6G   491M   2.0G  21% /u03

                /dev/sda3     ext3     5.1G   1.1G   3.8G  23% /u02

                /dev/sda2     ext3      16G    12G   2.9G  81% /u01

                /dev/sda1     ext3     152M    12M   132M   9% /boot

                tmpfs        tmpfs     830M      0   830M   0% /dev/shm

                .host:/     vmhgfs      55G    38G    18G  69% /mnt/hgfs

                /dev/hdc   iso9660     3.1G   3.1G      0 100% /media/Enterprise Linux dvd 20100405

                 

                $ . oraenv

                ORACLE_SID = [oracle] ? orcl

                $ sqlplus / as sysdba

                SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 13 19:28:07 2014

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

                Connected to:

                Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                 

                SQL> alter database mount;

                Database altered.

                 

                SQL>! dbua

                 

                I am getting error   DBUA throwing error  ..

                 

                DBUA  thinks this is a rerun operation and is trying to connect  to the database with oracle home.

                /u01/app/oracle/product/11.2.0/db_1/. If you believe this is not a rerun operation , remove the below file and  invoke DBUA again.

                 

                /u01/app/oracle/cfgtoolslog/dbua/logs/Welcome_orcl.txt

                 

                >> but i dont find any files here ..

                $ cd /u01/app/oracle/cfgtoollogs/dbua/logs/

                [oracle@oel5 logs]$ ls -l

                total 76

                -rw-r----- 1 oracle oinstall 39584 Apr 13 19:32 sqls.log

                -rw-r----- 1 oracle oinstall 36025 Apr 13 19:32 trace.log

                • 5. Re: upgradation failiure
                  Srini Chavali-Oracle

                  Restore your database from backups, ensure that /etc/oratab file consists of a valid entry pointing to 10gR2 HOME, then re-run dbua from the 11gR2 HOME after setting appropriate environment variables as listed in the Upgrade Guide

                  • 6. Re: upgradation failiure
                    955912

                    Hi srini ;

                     

                    i got confused. already i updated /etc/oratab file. it is pointing 11g oracle home.

                    before executing  catupgrd.sql , i have updated /oratab file.

                     

                     

                    # Multiple entries with the same $ORACLE_SID are not allowed.

                    #

                    #

                    orcl:/u01/app/oracle/product/11.2.0/db_1:N

                     

                    >> what is the error here ?

                     

                    Please  elaborate little more

                    • 7. Re: upgradation failiure
                      Srini Chavali-Oracle

                      the /etc/oratab file needs to be set to point to the old ORACLE_HOME. DBUA will read this file to bring up the database from the old ORACLE_HOME and upgrade it. Please follow directions in the Upgrade Guide, rather than hacking your way thru the upgrade - the directions are explicitly clear

                      • 8. Re: upgradation failiure
                        955912

                        Hi srini ;

                         

                        For past 3 hours catupgrd.sql  is running. Manually i stoped  upgradation process.

                        When i quired dba_registry ,, it is showing

                         

                        COMP_NAME                                VERSION                        STATUS

                        ---------------------------------------- ------------------------------ -----------

                        Oracle Enterprise Manager                11.2.0.1.0                     VALID

                        Spatial                                  11.2.0.1.0                     VALID

                        Oracle Multimedia                        11.2.0.1.0                     VALID

                        OLAP Catalog                             11.2.0.1.0                     VALID

                        Oracle XML Database                      11.2.0.1.0                     VALID

                        Oracle Text                              11.2.0.1.0                     VALID

                        Oracle Expression Filter                 11.2.0.1.0                     VALID

                        Oracle Rule Manager                      11.2.0.1.0                     VALID

                        Oracle Workspace Manager                 11.2.0.1.0                     VALID

                        Oracle Data Mining                       11.2.0.1.0                     VALID

                        Oracle Database Catalog Views            11.2.0.1.0                     VALID

                         

                         

                        COMP_NAME                                VERSION                        STATUS

                        ---------------------------------------- ------------------------------ -----------

                        Oracle Database Packages and Types       11.2.0.1.0                     VALID

                        JServer JAVA Virtual Machine             11.2.0.1.0                     VALID

                        Oracle XDK                               11.2.0.1.0                     VALID

                        Oracle Database Java Packages            11.2.0.1.0                     VALID

                        OLAP Analytic Workspace                  11.2.0.1.0                     VALID

                        Oracle OLAP API                          11.2.0.1.0                     VALID

                        • 9. Re: upgradation failiure
                          Srini Chavali-Oracle

                          Pl elaborate on what you mean by "Manually i stoped  upgradation process." - why did you have to stop the process ? For the third time you should be using DBUA

                          • 10. Re: upgradation failiure
                            955912

                            Hi Srini

                            Srini Chavali-Oracle wrote:

                             

                            the /etc/oratab file needs to be set to point to the old ORACLE_HOME. DBUA will read this file to bring up the database from the old ORACLE_HOME and upgrade it. Please follow directions in the Upgrade Guide, rather than hacking your way thru the upgrade - the directions are explicitly clear

                             

                             

                            I have discussed with my lead he told me ..

                             

                            > if i upgrade my database using DBUA ..

                             

                            I should NOT update oratab file. Oracle 'll take care everything.

                             

                            > if i upgrade my database by MANUAL METHOD ,

                             

                            I MUST update  oratab file before execute catupgrd.sql

                             

                            I am getting bit confused. Are both valid ???

                             

                            Please reply. because always we are using manual upgrade only

                            • 11. Re: upgradation failiure
                              Srini Chavali-Oracle

                              Correct - DBUA will update the /etc/oratab automatically as part of the upgrade process - if you perform a manual upgrade, you will have to edit the file yourself

                              • 12. Re: upgradation failiure
                                955912

                                Hi Srini ;

                                 

                                Thanks. I got answer.

                                 

                                If  upgrade fails once , can i re execute  catupgrd.sql  without restoring  from backup ?

                                 

                                i mean on the same database , can i  re execute  catupgrd.sql ?

                                 

                                >>  I dont find any difference  ,to collect statistics for entire database but most of the peoples are recommending  to collect statistics.

                                 

                                      In your shared docs also not described fully. please provide some info why we need to collect statistics.

                                 

                                    How it will help to upgrade process ?

                                • 13. Re: upgradation failiure
                                  Srini Chavali-Oracle

                                  See MOS Doc 1352987.1 for answers