9 Replies Latest reply: Sep 19, 2011 1:06 AM by Hussein Sawwan-Oracle RSS

    unable to connect as sysdba

    888326
      Hi all,

      Initially I tried to shut down the database. So when I issued the command 'shutdown', it took abt 1 hr and still there was no response. So I aborted the operation.

      Now when I again try to connect to my database, it says,

      ERROR:
      ORA-01090: shutdown in progress - connection is not permitted

      I tried to connect as sysdba.. But it says,
      ERROR:
      ORA-09817: Write to audit file failed.
      Linux-x86_64 Error: 28: No space left on device
      ORA-09945: Unable to initialize the audit trail file
      Linux-x86_64 Error: 28: No space left on device

      Please help me in resolving this error..

      Thanks..
        • 1. Re: unable to connect as sysdba
          EBSDBA
          Hi,
          >ORA-01090: shutdown in progress - connection is not permitted

          You need to use shut abort
          ERROR:
          ORA-09817: Write to audit file failed.
          Linux-x86_64 Error: 28: No space left on device
          ORA-09945: Unable to initialize the audit trail file
          Linux-x86_64 Error: 28: No space left on device
          Please Free some files from Database, Then start the database. Disable auditing/ reduce the auditing level.

          Thanks
          • 2. Re: unable to connect as sysdba
            888326
            My database already has enough free space.. I chkd it using the 'df' command.

            Starting the database itself is not possible now.. Bcoz it says that 'ORA-01090: shutdown in progress - connection is not permitted'..

            Shud anythng else be done?
            • 3. Re: unable to connect as sysdba
              888326
              And when given shut abort, it says,

              ORA-01031: insufficient privileges
              • 4. Re: unable to connect as sysdba
                EBSDBA
                Hi,
                Log out of the SQL session and open a new terminal. MAKE sure you have exported all the necessary environment vaiables.

                Then have a new SQL session and issue shut abort., This should work


                Thanks
                • 5. Re: unable to connect as sysdba
                  888326
                  Hi,

                  I have logged out n logged in many times.. But still am unable to connect either my database nor as sysdba...

                  And the oracle_home and SID are all set properly...
                  • 6. Re: unable to connect as sysdba
                    EBSDBA
                    Hi,
                    Please post here the last 100 lines of alert log file. And df -h command outpuut please.

                    The worst thing we could do is killing pmon or any madatory process (As the final WORKAROUND).


                    Thanks

                    Edited by: EBSDBA on Sep 15, 2011 1:48 PM
                    • 7. Re: unable to connect as sysdba
                      888326
                      Hi, plz find the contents of the alert log file..

                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19502: write error on file "", blockno (blocksize=)
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 10:55:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 10:55:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 10:55:13 2011
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 10:55:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:00:13 2011
                      ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/shared/my_db/oradata/my_db/arch/ARC_file' (error 19502)
                      (my_db)
                      Fri Sep 9 11:00:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-19502: write error on file "/shared/my_db/oradata/my_db/arch/ARC_file", blockno 1 (blocksize=512)
                      ORA-27072: File I/O error
                      Linux-x86_64 Error: 9: Bad file descriptor
                      Additional information: 4
                      Additional information: 1
                      Additional information: 257536
                      ORA-19502: write error on file "/shared/my_db/oradata/my_db/arch/ARC_file", blockno 1 (blocksize=512)
                      Fri Sep 9 11:00:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:00:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:00:13 2011
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19502: write error on file "", blockno (blocksize=)
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:00:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19502: write error on file "", blockno (blocksize=)
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:01:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:01:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:01:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:06:13 2011
                      ARC0: Closing local archive destinatiFri Sep 9 11:06:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-19502: write error on file "/shared/my_db/oradata/my_db/arch/ARC_file", blockno 1 (blocksize=512)
                      ORA-27072: File I/O error
                      Linux-x86_64 Error: 9: Bad file descriptor
                      Additional information: 4
                      Additional information: 1
                      Additional information: 261632
                      ORA-19502: write error on file "/shared/my_db/oradata/my_db/arch/ARC_file", blockno 1 (blocksize=512)
                      Fri Sep 9 11:06:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:06:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:06:13 2011
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19502: write error on file "", blockno (blocksize=)
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:06:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19502: write error on file "", blockno (blocksize=)
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:07:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:07:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:07:13 2011
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:07:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:12:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:12:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:12:13 2011
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19504: failed to create file ""
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:12:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19504: failed to create file ""
                      ORA-00312: onlin
                      e log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:13:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:13:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:13:13 2011
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:13:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:18:13 2011
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:18:13 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:18:13 2011
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19504: failed to create file ""
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:18:13 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16038: log 3 sequence# 1071 cannot be archived
                      ORA-19504: failed to create file ""
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      ARCH: Archival stopped, error occurred. Will continue retrying
                      Fri Sep 9 11:18:21 2011
                      ORACLE Instance my_db - Archival Error
                      Fri Sep 9 11:18:21 2011
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:18:21 2011
                      Errors in file /shared/oracle/admin/my_db/bdump/my_db_arcfile.trc:
                      ORA-16014: log 3 sequence# 1071 not archived, no available destinations
                      ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                      Fri Sep 9 11:23:21 2011
                      ARCH


                      df -h
                      Filesystem Size Used Avail Use% Mounted on
                      /dev/mapper/rootvg-rootvol
                      3.9G 1.8G 2.0G 47% /
                      /dev/sda1 99M 15M 80M 16% /boot
                      none 3.8G 0 3.8G 0% /dev/shm
                      /dev/mapper/rootvg-homevol
                      2.0G 1.6G 264M 86% /home
                      /dev/mapper/rootvg-sharedvol
                      20G 19G 0 100% /shared
                      /dev/mapper/rootvg-varvol
                      2.0G 113M 1.8G 6% /var
                      • 8. Re: unable to connect as sysdba
                        888326
                        Hi,

                        Still couldnt solve this issue...

                        Can anybody help..??

                        Thanks....
                        • 9. Re: unable to connect as sysdba
                          Hussein Sawwan-Oracle
                          ORA-16038: log 3 sequence# 1071 cannot be archived
                          ORA-19502: write error on file "", blockno (blocksize=)
                          ORA-00312: online log 3 thread 1: '/shared/my_db/oradata/my_db/redo03.log'
                          Please see these docs.

                          Disk Full Error Causes Users To Unable To Receive In Specific Orgs [ID 337870.1]
                          Newly created Oracle database on Reiser filesystem - archiver reports I/O errors [ID 399764.1]
                          Production Server Is Hanging While Database Is Trying To Write On Archivelog File [ID 413194.1]

                          Thanks,
                          Hussein