1 2 3 Previous Next 37 Replies Latest reply on Oct 1, 2011 6:44 PM by 880047 Go to original post
      • 30. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
        sb92075
        post
        ls -l for directory containing alert_{SID}.log file before attempting to start DB

        sqlplus
        / as sysdba
        startup
        exit
        ls -l for directory containing alert_{SID}.log file after attempting to start DB
        tail -100 alert_{SID}.log
        • 31. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
          880047
          Below are the details, and i observed that there is no difference in the alert log file content before and after DB startup.


          -bash-3.2$ ls -l alert_e16128.log
          -rw------- 1 oracle dba 6488 Aug 25 12:15 alert_e16128.log

          -bash-3.2$ sqlplus / as sysdba

          SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 26 19:47:11 2011

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

          Connected to an idle instance.

          SQL> startup
          ORA-10997: another startup/shutdown operation of this instance inprogress
          ORA-09968: unable to lock file
          Linux-x86_64 Error: 37: No locks available
          Additional information: 64
          SQL> exit


          -bash-3.2$ ls -l alert_e16128.log
          -rw------- 1 oracle dba 6488 Aug 25 12:15 alert_e16128.log


          -bash-3.2$ tail -100 alert_e16128.log

          VKTM running at (10)millisec precision with DBRM quantum (100)ms
          Tue Aug 23 16:47:20 2011
          GEN0 started with pid=4, OS id=19317
          Tue Aug 23 16:47:20 2011
          DIAG started with pid=5, OS id=19321
          Tue Aug 23 16:47:20 2011
          DBRM started with pid=6, OS id=19325
          Tue Aug 23 16:47:20 2011
          PSP0 started with pid=7, OS id=19329
          Tue Aug 23 16:47:20 2011
          DIA0 started with pid=8, OS id=19333
          Tue Aug 23 16:47:20 2011
          MMAN started with pid=9, OS id=19337
          Tue Aug 23 16:47:20 2011
          DBW0 started with pid=10, OS id=19341
          Tue Aug 23 16:47:20 2011
          LGWR started with pid=11, OS id=19345
          Tue Aug 23 16:47:20 2011
          CKPT started with pid=12, OS id=19349
          Tue Aug 23 16:47:20 2011
          SMON started with pid=13, OS id=19353
          Tue Aug 23 16:47:21 2011
          RECO started with pid=14, OS id=19357
          Tue Aug 23 16:47:21 2011
          MMON started with pid=15, OS id=19361
          ORACLE_BASE from environment = /u01/app/e16128/oracle
          Tue Aug 23 16:47:21 2011
          MMNL started with pid=16, OS id=19365
          Tue Aug 23 16:47:21 2011
          ALTER DATABASE MOUNT
          Direct NFS: channel id [0] path [10.156.250.16] to filer [10.156.250.16] via local [] is UP
          Direct NFS: channel id [1] path [10.156.250.16] to filer [10.156.250.16] via local [] is UP
          Successful mount of redo thread 1, with mount id 45350297
          Database mounted in Exclusive Mode
          Lost write protection disabled
          Completed: ALTER DATABASE MOUNT
          Tue Aug 23 16:47:25 2011
          ALTER DATABASE OPEN
          Thread 1 opened at log sequence 1
          Current log# 1 seq# 1 mem# 0: /u01/oradata/e16128/redo01a.log
          Current log# 1 seq# 1 mem# 1: /u02/oradata/e16128/redo01b.log
          Successful open of redo thread 1
          MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
          SMON: enabling cache recovery
          Successfully onlined Undo Tablespace 2.
          Verifying file header compatibility for 11g tablespace encryption..
          Verifying 11g file header compatibility for tablespace encryption completed
          SMON: enabling tx recovery
          Database Characterset is AL32UTF8
          No Resource Manager plan active
          replication_dependency_tracking turned off (no async multimaster replication found)
          Starting background process QMNC
          Tue Aug 23 16:47:26 2011
          QMNC started with pid=18, OS id=19389
          Completed: ALTER DATABASE OPEN
          Tue Aug 23 16:52:27 2011
          Starting background process SMCO
          Tue Aug 23 16:52:27 2011
          SMCO started with pid=20, OS id=19691
          Tue Aug 23 21:32:45 2011
          Starting background process CJQ0
          Tue Aug 23 21:32:45 2011
          CJQ0 started with pid=22, OS id=31121
          Tue Aug 23 22:00:00 2011
          Setting Resource Manager plan SCHEDULER[0x3004]:DEFAULT_MAINTENANCE_PLAN via scheduler window
          Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
          Tue Aug 23 22:00:00 2011
          Starting background process VKRM
          Tue Aug 23 22:00:00 2011
          VKRM started with pid=23, OS id=32218
          Tue Aug 23 22:00:08 2011
          Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
          End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
          Wed Aug 24 02:00:00 2011
          Clearing Resource Manager plan via parameter
          Wed Aug 24 03:14:01 2011
          Stopping background process CJQ0
          Wed Aug 24 21:34:25 2011
          Starting background process CJQ0
          Wed Aug 24 21:34:25 2011
          CJQ0 started with pid=22, OS id=27797
          Wed Aug 24 22:00:00 2011
          Setting Resource Manager plan SCHEDULER[0x3005]:DEFAULT_MAINTENANCE_PLAN via scheduler window
          Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
          Wed Aug 24 22:00:00 2011
          Starting background process VKRM
          Wed Aug 24 22:00:00 2011
          VKRM started with pid=23, OS id=28834
          Wed Aug 24 22:00:05 2011
          Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
          Wed Aug 24 22:00:23 2011
          End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
          Thu Aug 25 02:00:00 2011
          Clearing Resource Manager plan via parameter
          Thu Aug 25 03:15:43 2011
          Stopping background process CJQ0
          Thu Aug 25 12:15:33 2011
          Thread 1 advanced to log sequence 2 (LGWR switch)
          Current log# 2 seq# 2 mem# 0: /u01/oradata/e16128/redo02a.log
          Current log# 2 seq# 2 mem# 1: /u02/oradata/e16128/redo02b.log

          Please let me know.
          • 32. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
            sb92075
            user13162661 wrote:
            Below are the details, and i observed that there is no difference in the alert log file content before and after DB startup.


            -bash-3.2$ ls -l alert_e16128.log
            -rw------- 1 oracle dba 6488 Aug 25 12:15 alert_e16128.log

            -bash-3.2$ sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 26 19:47:11 2011

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

            Connected to an idle instance.

            SQL> startup
            ORA-10997: another startup/shutdown operation of this instance inprogress
            ORA-09968: unable to lock file
            Linux-x86_64 Error: 37: No locks available
            Additional information: 64
            SQL> exit


            -bash-3.2$ ls -l alert_e16128.log
            -rw------- 1 oracle dba 6488 Aug 25 12:15 alert_e16128.log
            This PROVES the point I have been trying to make.
            Since the timestamp on file above does NOT change, I conclude that ORACLE_SID=e16128 is not the instance being started!
            I challenge you to file the alert_{SID}.log file that does change when you issue STARTUP!

            find / -name alert\* -ls | grep log
            • 33. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
              880047
              I got your point. Is there any chance to resolve this issue. Please give some suggestions to overcome this issue. Please find the results below for that command.


              -bash-3.2$ find / -name alert\* -ls | grep log

              find: /opt/encase: Permission denied
              find: /opt/opsware/smopython2: Permission denied
              find: /opt/opsware/sm: Permission denied
              find: /opt/opsware/pylibs: Permission denied
              find: /opt/opsware/agent_tools: Permission denied
              find: /opt/opsware/smopylibs2: Permission denied
              find: /opt/quest/libexec/vgp/xlators: Permission denied
              find: /usr/lib64/audit: Permission denied
              find: /boot/lost+found: Permission denied
              find: /proc/tty/driver: Permission denied
              find: /proc/1/task/1/fd: Permission denied
              find: /proc/1/task/1/fdinfo: Permission denied
              find: /proc/1/fd: Permission denied
              find: /proc/1/fdinfo: Permission denied
              find: /proc/2/task/2/fd: Permission denied
              find: /proc/2/task/2/fdinfo: Permission denied
              find: /proc/2/fd: Permission denied
              find: /proc/2/fdinfo: Permission denied
              find: /proc/3/task/3/fd: Permission denied
              find: /proc/3/task/3/fdinfo: Permission denied
              find: /proc/3/fd: Permission denied
              find: /proc/3/fdinfo: Permission denied
              find: /proc/4/task/4/fd: Permission denied
              find: /proc/4/task/4/fdinfo: Permission denied
              find: /proc/4/fd: Permission denied
              find: /proc/4/fdinfo: Permission denied
              find: /proc/5/task/5/fd: Permission denied
              find: /proc/5/task/5/fdinfo: Permission denied
              find: /proc/5/fd: Permission denied
              find: /proc/5/fdinfo: Permission denied
              find: /proc/6/task/6/fd: Permission denied
              find: /proc/6/task/6/fdinfo: Permission denied
              find: /proc/6/fd: Permission denied
              find: /proc/6/fdinfo: Permission denied
              find: /proc/7/task/7/fd: Permission denied
              find: /proc/7/task/7/fdinfo: Permission denied
              find: /proc/7/fd: Permission denied
              find: /proc/7/fdinfo: Permission denied
              find: /proc/8/task/8/fd: Permission denied
              find: /proc/8/task/8/fdinfo: Permission denied
              find: /proc/8/fd: Permission denied
              find: /proc/8/fdinfo: Permission denied
              find: /proc/49/task/49/fd: Permission denied
              find: /proc/49/task/49/fdinfo: Permission denied
              find: /proc/49/fd: Permission denied
              find: /proc/49/fdinfo: Permission denied
              find: /proc/54/task/54/fd: Permission denied
              find: /proc/54/task/54/fdinfo: Permission denied
              find: /proc/54/fd: Permission denied
              find: /proc/54/fdinfo: Permission denied
              find: /proc/55/task/55/fd: Permission denied
              find: /proc/55/task/55/fdinfo: Permission denied
              find: /proc/55/fd: Permission denied
              find: /proc/55/fdinfo: Permission denied
              find: /proc/56/task/56/fd: Permission denied
              find: /proc/56/task/56/fdinfo: Permission denied
              find: /proc/56/fd: Permission denied
              find: /proc/56/fdinfo: Permission denied
              find: /proc/218/task/218/fd: Permission denied
              find: /proc/218/task/218/fdinfo: Permission denied
              find: /proc/218/fd: Permission denied
              find: /proc/218/fdinfo: Permission denied
              find: /proc/219/task/219/fd: Permission denied
              find: /proc/219/task/219/fdinfo: Permission denied
              find: /proc/219/fd: Permission denied
              find: /proc/219/fdinfo: Permission denied
              find: /proc/222/task/222/fd: Permission denied
              find: /proc/222/task/222/fdinfo: Permission denied
              find: /proc/222/fd: Permission denied
              find: /proc/222/fdinfo: Permission denied
              find: /proc/224/task/224/fd: Permission denied
              find: /proc/224/task/224/fdinfo: Permission denied
              find: /proc/224/fd: Permission denied
              find: /proc/224/fdinfo: Permission denied
              find: /proc/300/task/300/fd: Permission denied
              find: /proc/300/task/300/fdinfo: Permission denied
              find: /proc/300/fd: Permission denied
              find: /proc/300/fdinfo: Permission denied
              find: /proc/301/task/301/fd: Permission denied
              find: /proc/301/task/301/fdinfo: Permission denied
              find: /proc/301/fd: Permission denied
              find: /proc/301/fdinfo: Permission denied
              find: /proc/302/task/302/fd: Permission denied
              find: /proc/302/task/302/fdinfo: Permission denied
              find: /proc/302/fd: Permission denied
              find: /proc/302/fdinfo: Permission denied
              find: /proc/303/task/303/fd: Permission denied
              find: /proc/303/task/303/fdinfo: Permission denied
              find: /proc/303/fd: Permission denied
              find: /proc/303/fdinfo: Permission denied
              find: /proc/304/task/304/fd: Permission denied
              find: /proc/304/task/304/fdinfo: Permission denied
              find: /proc/304/fd: Permission denied
              find: /proc/304/fdinfo: Permission denied
              find: /proc/305/task/305/fd: Permission denied
              find: /proc/305/task/305/fdinfo: Permission denied
              find: /proc/305/fd: Permission denied
              find: /proc/305/fdinfo: Permission denied
              find: /proc/511/task/511/fd: Permission denied
              find: /proc/511/task/511/fdinfo: Permission denied
              find: /proc/511/fd: Permission denied
              find: /proc/511/fdinfo: Permission denied
              find: /proc/552/task/552/fd: Permission denied
              find: /proc/552/task/552/fdinfo: Permission denied
              find: /proc/552/fd: Permission denied
              find: /proc/552/fdinfo: Permission denied
              find: /proc/553/task/553/fd: Permission denied
              find: /proc/553/task/553/fdinfo: Permission denied
              find: /proc/553/fd: Permission denied
              find: /proc/553/fdinfo: Permission denied
              find: /proc/554/task/554/fd: Permission denied
              find: /proc/554/task/554/fdinfo: Permission denied
              find: /proc/554/fd: Permission denied
              find: /proc/554/fdinfo: Permission denied
              find: /proc/558/task/558/fd: Permission denied
              find: /proc/558/task/558/fdinfo: Permission denied
              find: /proc/558/fd: Permission denied
              find: /proc/558/fdinfo: Permission denied
              find: /proc/559/task/559/fd: Permission denied
              find: /proc/559/task/559/fdinfo: Permission denied
              find: /proc/559/fd: Permission denied
              find: /proc/559/fdinfo: Permission denied
              find: /proc/560/task/560/fd: Permission denied
              find: /proc/560/task/560/fdinfo: Permission denied
              find: /proc/560/fd: Permission denied
              find: /proc/560/fdinfo: Permission denied
              find: /proc/570/task/570/fd: Permission denied
              find: /proc/570/task/570/fdinfo: Permission denied
              find: /proc/570/fd: Permission denied
              find: /proc/570/fdinfo: Permission denied
              find: /proc/592/task/592/fd: Permission denied
              find: /proc/592/task/592/fdinfo: Permission denied
              find: /proc/592/fd: Permission denied
              find: /proc/592/fdinfo: Permission denied
              find: /proc/616/task/616/fd: Permission denied
              find: /proc/616/task/616/fdinfo: Permission denied
              find: /proc/616/fd: Permission denied
              find: /proc/616/fdinfo: Permission denied
              find: /proc/647/task/647/fd: Permission denied
              find: /proc/647/task/647/fdinfo: Permission denied
              find: /proc/647/fd: Permission denied
              find: /proc/647/fdinfo: Permission denied
              find: /proc/2035/task/2035/fd: Permission denied
              find: /proc/2035/task/2035/fdinfo: Permission denied
              find: /proc/2035/fd: Permission denied
              find: /proc/2035/fdinfo: Permission denied
              find: /proc/2036/task/2036/fd: Permission denied
              find: /proc/2036/task/2036/fdinfo: Permission denied
              find: /proc/2036/fd: Permission denied
              find: /proc/2036/fdinfo: Permission denied
              find: /proc/2037/task/2037/fd: Permission denied
              find: /proc/2037/task/2037/fdinfo: Permission denied
              find: /proc/2037/fd: Permission denied
              find: /proc/2037/fdinfo: Permission denied
              find: /proc/2059/task/2059/fd: Permission denied
              find: /proc/2059/task/2059/fdinfo: Permission denied
              find: /proc/2059/fd: Permission denied
              find: /proc/2059/fdinfo: Permission denied
              find: /proc/2912/task/2912/fd: Permission denied
              find: /proc/2912/task/2912/fdinfo: Permission denied
              find: /proc/2912/task/2913/fd: Permission denied
              find: /proc/2912/task/2913/fdinfo: Permission denied
              find: /proc/2912/fd: Permission denied
              find: /proc/2912/fdinfo: Permission denied
              find: /proc/2914/task/2914/fd: Permission denied
              find: /proc/2914/task/2914/fdinfo: Permission denied
              find: /proc/2914/task/2920/fd: Permission denied
              find: /proc/2914/task/2920/fdinfo: Permission denied
              find: /proc/2914/fd: Permission denied
              find: /proc/2914/fdinfo: Permission denied
              find: /proc/2936/task/2936/fd: Permission denied
              find: /proc/2936/task/2936/fdinfo: Permission denied
              find: /proc/2936/fd: Permission denied
              find: /proc/2936/fdinfo: Permission denied
              find: /proc/2952/task/2952/fd: Permission denied
              find: /proc/2952/task/2952/fdinfo: Permission denied
              find: /proc/2952/fd: Permission denied
              find: /proc/2952/fdinfo: Permission denied
              find: /proc/2961/task/2961/fd: Permission denied
              find: /proc/2961/task/2961/fdinfo: Permission denied
              find: /proc/2961/task/2964/fd: Permission denied
              find: /proc/2961/task/2964/fdinfo: Permission denied
              find: /proc/2961/fd: Permission denied
              find: /proc/2961/fdinfo: Permission denied
              find: /proc/2963/task/2963/fd: Permission denied
              find: /proc/2963/task/2963/fdinfo: Permission denied
              find: /proc/2963/task/2974/fd: Permission denied
              find: /proc/2963/task/2974/fdinfo: Permission denied
              find: /proc/2963/task/2975/fd: Permission denied
              find: /proc/2963/task/2975/fdinfo: Permission denied
              find: /proc/2963/task/2976/fd: Permission denied
              find: /proc/2963/task/2976/fdinfo: Permission denied
              find: /proc/2963/task/2977/fd: Permission denied
              find: /proc/2963/task/2977/fdinfo: Permission denied
              find: /proc/2963/task/3121/fd: Permission denied
              find: /proc/2963/task/3121/fdinfo: Permission denied
              find: /proc/2963/task/3122/fd: Permission denied
              find: /proc/2963/task/3122/fdinfo: Permission denied
              find: /proc/2963/task/3146/fd: Permission denied
              find: /proc/2963/task/3146/fdinfo: Permission denied
              find: /proc/2963/fd: Permission denied
              find: /proc/2963/fdinfo: Permission denied
              find: /proc/2981/task/2981/fd: Permission denied
              find: /proc/2981/task/2981/fdinfo: Permission denied
              find: /proc/2981/fd: Permission denied
              find: /proc/2981/fdinfo: Permission denied
              find: /proc/3010/task/3010/fd: Permission denied
              find: /proc/3010/task/3010/fdinfo: Permission denied
              find: /proc/3010/fd: Permission denied
              find: /proc/3010/fdinfo: Permission denied
              find: /proc/3011/task/3011/fd: Permission denied
              find: /proc/3011/task/3011/fdinfo: Permission denied
              find: /proc/3011/fd: Permission denied
              find: /proc/3011/fdinfo: Permission denied
              find: /proc/3022/task/3022/fd: Permission denied
              find: /proc/3022/task/3022/fdinfo: Permission denied
              find: /proc/3022/fd: Permission denied
              find: /proc/3022/fdinfo: Permission denied
              find: /proc/3023/task/3023/fd: Permission denied
              find: /proc/3023/task/3023/fdinfo: Permission denied
              find: /proc/3023/fd: Permission denied
              find: /proc/3023/fdinfo: Permission denied
              find: /proc/3045/task/3045/fd: Permission denied
              find: /proc/3045/task/3045/fdinfo: Permission denied
              find: /proc/3045/task/3048/fd: Permission denied
              find: /proc/3045/task/3048/fdinfo: Permission denied
              find: /proc/3045/task/3049/fd: Permission denied
              find: /proc/3045/task/3049/fdinfo: Permission denied
              find: /proc/3045/task/27539/fd: Permission denied
              find: /proc/3045/task/27539/fdinfo: Permission denied
              find: /proc/3045/fd: Permission denied
              find: /proc/3045/fdinfo: Permission denied
              find: /proc/3077/task/3077/fd: Permission denied
              find: /proc/3077/task/3077/fdinfo: Permission denied
              find: /proc/3077/fd: Permission denied
              find: /proc/3077/fdinfo: Permission denied
              find: /proc/3102/task/3102/fd: Permission denied
              find: /proc/3102/task/3102/fdinfo: Permission denied
              find: /proc/3102/fd: Permission denied
              find: /proc/3102/fdinfo: Permission denied
              find: /proc/3130/task/3130/fd: Permission denied
              find: /proc/3130/task/3130/fdinfo: Permission denied
              find: /proc/3130/fd: Permission denied
              find: /proc/3130/fdinfo: Permission denied
              find: /proc/3148/task/3148/fd: Permission denied
              find: /proc/3148/task/3148/fdinfo: Permission denied
              find: /proc/3148/task/3162/fd: Permission denied
              find: /proc/3148/task/3162/fdinfo: Permission denied
              find: /proc/3148/fd: Permission denied
              find: /proc/3148/fdinfo: Permission denied
              find: /proc/3174/task/3174/fd: Permission denied
              find: /proc/3174/task/3174/fdinfo: Permission denied
              find: /proc/3174/fd: Permission denied
              find: /proc/3174/fdinfo: Permission denied
              find: /proc/3199/task/3199/fd: Permission denied
              find: /proc/3199/task/3199/fdinfo: Permission denied
              find: /proc/3199/fd: Permission denied
              find: /proc/3199/fdinfo: Permission denied
              find: /proc/3210/task/3210/fd: Permission denied
              find: /proc/3210/task/3210/fdinfo: Permission denied
              find: /proc/3210/fd: Permission denied
              find: /proc/3210/fdinfo: Permission denied
              find: /proc/3229/task/3229/fd: Permission denied
              find: /proc/3229/task/3229/fdinfo: Permission denied
              find: /proc/3229/fd: Permission denied
              find: /proc/3229/fdinfo: Permission denied
              find: /proc/3254/task/3254/fd: Permission denied
              find: /proc/3254/task/3254/fdinfo: Permission denied
              find: /proc/3254/fd: Permission denied
              find: /proc/3254/fdinfo: Permission denied
              find: /proc/3255/task/3255/fd: Permission denied
              find: /proc/3255/task/3255/fdinfo: Permission denied
              find: /proc/3255/fd: Permission denied
              find: /proc/3255/fdinfo: Permission denied
              find: /proc/3418/task/3418/fd: Permission denied
              find: /proc/3418/task/3418/fdinfo: Permission denied
              find: /proc/3418/fd: Permission denied
              find: /proc/3418/fdinfo: Permission denied
              find: /proc/7451/task/7451/fd: Permission denied
              find: /proc/7451/task/7451/fdinfo: Permission denied
              find: /proc/7451/fd: Permission denied
              find: /proc/7451/fdinfo: Permission denied
              find: /proc/7632/task/7632/fd: Permission denied
              find: /proc/7632/task/7632/fdinfo: Permission denied
              find: /proc/7632/fd: Permission denied
              find: /proc/7632/fdinfo: Permission denied
              find: /proc/8119/task/8119/fd: Permission denied
              find: /proc/8119/task/8119/fdinfo: Permission denied
              find: /proc/8119/fd: Permission denied
              find: /proc/8119/fdinfo: Permission denied
              find: /proc/8120/task/8120/fd: Permission denied
              find: /proc/8120/task/8120/fdinfo: Permission denied
              find: /proc/8120/fd: Permission denied
              find: /proc/8120/fdinfo: Permission denied
              find: /proc/8121/task/8121/fd: Permission denied
              find: /proc/8121/task/8121/fdinfo: Permission denied
              find: /proc/8121/fd: Permission denied
              find: /proc/8121/fdinfo: Permission denied
              find: /proc/8122/task/8122/fd: Permission denied
              find: /proc/8122/task/8122/fdinfo: Permission denied
              find: /proc/8122/fd: Permission denied
              find: /proc/8122/fdinfo: Permission denied
              find: /proc/8123/task/8123/fd: Permission denied
              find: /proc/8123/task/8123/fdinfo: Permission denied
              find: /proc/8123/fd: Permission denied
              find: /proc/8123/fdinfo: Permission denied
              find: /proc/8124/task/8124/fd: Permission denied
              find: /proc/8124/task/8124/fdinfo: Permission denied
              find: /proc/8124/fd: Permission denied
              find: /proc/8124/fdinfo: Permission denied
              find: /proc/25429/task/25429/fd: Permission denied
              find: /proc/25429/task/25429/fdinfo: Permission denied
              find: /proc/25429/fd: Permission denied
              find: /proc/25429/fdinfo: Permission denied
              find: /proc/25436/task/25436/fd: Permission denied
              find: /proc/25436/task/25436/fdinfo: Permission denied
              find: /proc/25436/fd: Permission denied
              find: /proc/25436/fdinfo: Permission denied
              find: /lost+found: Permission denied
              find: /home/deploy: Permission denied
              find: /home/dist: Permission denied
              find: /home/ea: Permission denied
              find: /home/pharos_user: Permission denied
              find: /home/cisvscan: Permission denied
              find: /home/ccops: Permission denied
              find: /home/pharos_priv_user: Permission denied
              find: /home/ccqauser: Permission denied
              find: /etc/opt/opsware/pytwist: Permission denied
              find: /etc/cron.hourly-preCIS: Permission denied
              find: /etc/pki/CA: Permission denied
              find: /etc/cron.weekly: Permission denied
              find: /etc/selinux/targeted/modules/previous: Permission denied
              find: /etc/selinux/targeted/modules/active: Permission denied
              find: /etc/cron.weekly-preCIS: Permission denied
              find: /etc/cron.monthly: Permission denied
              find: /etc/cron.archive: Permission denied
              find: /etc/cron.d: Permission denied
              find: /etc/racoon/certs: Permission denied
              find: /etc/audisp: Permission denied
              find: /etc/cron.daily: Permission denied
              find: /etc/audit: Permission denied
              find: /etc/cron.hourly: Permission denied
              find: /etc/cron.daily-preCIS: Permission denied
              find: /etc/lvm/backup: Permission denied
              find: /etc/lvm/cache: Permission denied
              find: /etc/lvm/archive: Permission denied
              find: /etc/cron.d-preCIS: Permission denied
              find: /etc/cron.monthly-preCIS: Permission denied
              find: /etc/cron.archive-preCIS: Permission denied
              find: /var/opt/opsware/crypto: Permission denied
              find: /var/opt/opsware/extensible_discovery: Permission denied
              find: /var/opt/opsware/agent/ogsh.push: Permission denied
              find: /var/opt/opsware/zipregistry: Permission denied
              find: /var/opt/quest/vas/authcache: Permission denied
              find: /var/opt/quest/vgp: Permission denied
              find: /var/spool/clientmqueue: Permission denied
              find: /var/spool/cron-preCIS: Permission denied
              find: /var/spool/at: Permission denied
              find: /var/spool/mqueue: Permission denied
              find: /var/spool/up2date: Permission denied
              find: /var/spool/cron: Permission denied
              find: /var/log: Permission denied
              find: /var/cache/samba/winbindd_privileged: Permission denied
              find: /var/run/sudo: Permission denied
              find: /var/run/mdadm: Permission denied
              find: /var/run/lvm: Permission denied
              find: /var/run/mdmpd: Permission denied
              find: /var/empty/sshd: Permission denied
              find: /var/lib/mlocate: Permission denied
              find: /var/lib/dhcpv6: Permission denied
              find: /var/lib/nfs/statd: Permission denied
              find: /var/lock/lvm: Permission denied
              find: /var/net-snmp: Permission denied
              find: /root: Permission denied
              find: /lib/modules/2.6.18-238.12.1.el5/misc: Permission denied
              find: /lib/modules/2.6.18-238.el5/misc: Permission denied
              find: /lib/modules/2.6.18-274.3.1.el5/misc: Permission denied
              find: /pharos/core: Permission denied
              find: /pharos/lang_app: Permission denied
              find: /admin/INTU-Post-Baseline: Permission denied
              find: /admin/opsware: Permission denied
              find: /mnt/hgfs: Permission denied
              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              154374 4 -rw-r----- 1 oracle dba 3190 Aug 23 16:44 /app/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlogViewer.pl
              154375 4 -rw-r----- 1 oracle dba 1541 Aug 23 16:44 /app/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_find.pl
              154376 8 -rw-r----- 1 oracle dba 4247 Aug 23 16:44 /app/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_util.pl
              4550700 24 -rwxr-xr-x 1 oracle dba 24248 Dec 22 2008 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlog.pl
              4550716 12 -rwxr-xr-x 1 oracle dba 8361 Mar 12 2009 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr_util.pl
              9294898 20 -rwxr-xr-x 1 oracle dba 19559 Mar 5 2007 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr.pl
              9294906 8 -rwxr-xr-x 1 oracle dba 4247 Oct 28 2003 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlog_util.pl
              9210358 4 -rwxr-xr-x 1 oracle dba 3190 Jan 31 2005 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlogViewer.pl
              14235844 4 -rwxr-xr-x 1 oracle dba 1541 Dec 9 2004 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlog_find.pl
              14235852 4 -rwxr-xr-x 1 oracle dba 2851 Jun 3 2007 /app/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdrViewer.pl
              21177141 4 drwxr-xr-x 3 oracle dba 4096 Jan 7 2010 /app/oracle/product/11.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
              12744123 8 -rw------- 1 oracle dba 6488 Aug 25 12:15 /app/oracle/admin/e16128/diag/rdbms/e16128/e16128/trace/alert_e16128.log
              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/.snapshot/nightly.13/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.13/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/.snapshot/nightly.13/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              154374 4 -rw-r----- 1 oracle dba 3190 Aug 23 16:44 /app/.snapshot/nightly.13/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlogViewer.pl
              154375 4 -rw-r----- 1 oracle dba 1541 Aug 23 16:44 /app/.snapshot/nightly.13/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_find.pl
              154376 8 -rw-r----- 1 oracle dba 4247 Aug 23 16:44 /app/.snapshot/nightly.13/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_util.pl
              4550700 24 -rwxr-xr-x 1 oracle dba 24248 Dec 22 2008 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlog.pl
              4550716 12 -rwxr-xr-x 1 oracle dba 8361 Mar 12 2009 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr_util.pl
              9294898 20 -rwxr-xr-x 1 oracle dba 19559 Mar 5 2007 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr.pl
              9294906 8 -rwxr-xr-x 1 oracle dba 4247 Oct 28 2003 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlog_util.pl
              9210358 4 -rwxr-xr-x 1 oracle dba 3190 Jan 31 2005 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlogViewer.pl
              14235844 4 -rwxr-xr-x 1 oracle dba 1541 Dec 9 2004 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlog_find.pl
              14235852 4 -rwxr-xr-x 1 oracle dba 2851 Jun 3 2007 /app/.snapshot/nightly.13/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdrViewer.pl
              21177141 4 drwxr-xr-x 3 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.13/oracle/product/11.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
              12744123 8 -rw------- 1 oracle dba 6488 Aug 25 12:15 /app/.snapshot/nightly.13/oracle/admin/e16128/diag/rdbms/e16128/e16128/trace/alert_e16128.log
              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/.snapshot/nightly.12/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.12/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/.snapshot/nightly.12/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              154374 4 -rw-r----- 1 oracle dba 3190 Aug 23 16:44 /app/.snapshot/nightly.12/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlogViewer.pl
              154375 4 -rw-r----- 1 oracle dba 1541 Aug 23 16:44 /app/.snapshot/nightly.12/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_find.pl
              154376 8 -rw-r----- 1 oracle dba 4247 Aug 23 16:44 /app/.snapshot/nightly.12/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_util.pl
              4550700 24 -rwxr-xr-x 1 oracle dba 24248 Dec 22 2008 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlog.pl
              4550716 12 -rwxr-xr-x 1 oracle dba 8361 Mar 12 2009 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr_util.pl
              9294898 20 -rwxr-xr-x 1 oracle dba 19559 Mar 5 2007 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr.pl
              9294906 8 -rwxr-xr-x 1 oracle dba 4247 Oct 28 2003 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlog_util.pl
              9210358 4 -rwxr-xr-x 1 oracle dba 3190 Jan 31 2005 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlogViewer.pl
              14235844 4 -rwxr-xr-x 1 oracle dba 1541 Dec 9 2004 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlog_find.pl
              14235852 4 -rwxr-xr-x 1 oracle dba 2851 Jun 3 2007 /app/.snapshot/nightly.12/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdrViewer.pl
              21177141 4 drwxr-xr-x 3 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.12/oracle/product/11.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
              12744123 8 -rw------- 1 oracle dba 6488 Aug 25 12:15 /app/.snapshot/nightly.12/oracle/admin/e16128/diag/rdbms/e16128/e16128/trace/alert_e16128.log
              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/.snapshot/nightly.11/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.11/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/.snapshot/nightly.11/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              154374 4 -rw-r----- 1 oracle dba 3190 Aug 23 16:44 /app/.snapshot/nightly.11/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlogViewer.pl
              154375 4 -rw-r----- 1 oracle dba 1541 Aug 23 16:44 /app/.snapshot/nightly.11/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_find.pl
              154376 8 -rw-r----- 1 oracle dba 4247 Aug 23 16:44 /app/.snapshot/nightly.11/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_util.pl
              4550700 24 -rwxr-xr-x 1 oracle dba 24248 Dec 22 2008 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlog.pl
              4550716 12 -rwxr-xr-x 1 oracle dba 8361 Mar 12 2009 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr_util.pl
              9294898 20 -rwxr-xr-x 1 oracle dba 19559 Mar 5 2007 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr.pl
              9294906 8 -rwxr-xr-x 1 oracle dba 4247 Oct 28 2003 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlog_util.pl
              9210358 4 -rwxr-xr-x 1 oracle dba 3190 Jan 31 2005 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlogViewer.pl
              14235844 4 -rwxr-xr-x 1 oracle dba 1541 Dec 9 2004 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlog_find.pl
              14235852 4 -rwxr-xr-x 1 oracle dba 2851 Jun 3 2007 /app/.snapshot/nightly.11/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdrViewer.pl
              21177141 4 drwxr-xr-x 3 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.11/oracle/product/11.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
              12744123 8 -rw------- 1 oracle dba 6488 Aug 25 12:15 /app/.snapshot/nightly.11/oracle/admin/e16128/diag/rdbms/e16128/e16128/trace/alert_e16128.log
              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/.snapshot/nightly.0/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.0/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/.snapshot/nightly.0/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              154374 4 -rw-r----- 1 oracle dba 3190 Aug 23 16:44 /app/.snapshot/nightly.0/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlogViewer.pl
              154375 4 -rw-r----- 1 oracle dba 1541 Aug 23 16:44 /app/.snapshot/nightly.0/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_find.pl
              154376 8 -rw-r----- 1 oracle dba 4247 Aug 23 16:44 /app/.snapshot/nightly.0/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog_util.pl
              4550700 24 -rwxr-xr-x 1 oracle dba 24248 Dec 22 2008 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlog.pl
              4550716 12 -rwxr-xr-x 1 oracle dba 8361 Mar 12 2009 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr_util.pl
              9294898 20 -rwxr-xr-x 1 oracle dba 19559 Mar 5 2007 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdr.pl
              9294906 8 -rwxr-xr-x 1 oracle dba 4247 Oct 28 2003 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlog_util.pl
              9210358 4 -rwxr-xr-x 1 oracle dba 3190 Jan 31 2005 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlogViewer.pl
              14235844 4 -rwxr-xr-x 1 oracle dba 1541 Dec 9 2004 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlog_find.pl
              14235852 4 -rwxr-xr-x 1 oracle dba 2851 Jun 3 2007 /app/.snapshot/nightly.0/oracle/product/11.2.0/sysman/admin/scripts/alertlogAdrViewer.pl
              21177141 4 drwxr-xr-x 3 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.0/oracle/product/11.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
              12744123 8 -rw------- 1 oracle dba 6488 Aug 25 12:15 /app/.snapshot/nightly.0/oracle/admin/e16128/diag/rdbms/e16128/e16128/trace/alert_e16128.log

              6646002 16 -rw-r----- 1 oracle dba 14919 Jan 7 2010 /app/.snapshot/nightly.10/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
              22645060 4 drwxr-x--- 2 oracle dba 4096 Jan 7 2010 /app/.snapshot/nightly.10/oracle/product/11.2.0/log/diag/rdbms/dbua0/DBUA0/alert
              154373 24 -rw-r----- 1 oracle dba 22521 Aug 23 16:44 /app/.snapshot/nightly.10/oracle/product/11.2.0/ccr/sysman/admin/scripts/alertlog.pl
              • 34. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
                jgarry
                Run the ipcs command. That may give you a clue. If anything is owned by oracle, that would be a clue that something is taking up the memory that would be taken up by your new instance. Those funny numbers are a key that is generated by the instance name, and it is possible to collide namespaces (I think the E vs. e is one of those things, although I could be misremembering or out of date). So, did you reboot the machine? When you reboot the machine, is there a startup for Oracle? And if so, is there a system log of that? You can also clear up ipcs problems with the ipcrm commands.

                Linux-x86_64 Error: 37: No locks available may be telling you you haven't started the nfslock service. It may also be telling you there is some serious misconfiguration with your kernel - although, that could simply be you are already using up the resources for an instance. I think I've seen discussions around about having to restart nfs stuff to get rid of hanging lock issues, but don't really know anything about it.

                So do the Bill Gates thing, reboot everything the server touches.
                • 35. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
                  880047
                  Thanks for your reply with detailed message, sorry i didn't respond your message quickly, because lot of other work.
                  even it is thronging the same message after reboot also.
                  I don't see any process running under root or oracle when i ran ipcs command and below ar the reults.

                  -bash-3.2$ ipcs

                  ------ Shared Memory Segments --------
                  key shmid owner perms bytes nattch status

                  ------ Semaphore Arrays --------
                  key semid owner perms nsems

                  ------ Message Queues --------
                  key msqid owner perms used-bytes messages

                  -bash-3.2$ ipcs -a

                  ------ Shared Memory Segments --------
                  key shmid owner perms bytes nattch status

                  ------ Semaphore Arrays --------
                  key semid owner perms nsems

                  ------ Message Queues --------
                  key msqid owner perms used-bytes messages


                  I don't know how to check or start the nfslock service. Can you please let me know.

                  Again thanks for all your replies.
                  • 36. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
                    jgarry
                    [url http://lmgtfy.com/?q=start+nfslock+service+-site%3Adba-oracle.com]google it.

                    http://appsforbeginners.blogspot.com/2009/08/how-to-clear-stuck-nfs-locks-on-netapp.html
                    • 37. Re: Database is not able to start, due to error: ORA-01078 and ORA-27086
                      880047
                      Thanks for your all replies.
                      My prob is resolved, the prob is with nfslock service. when it is started everything working fine.


                      Thanks again for all.
                      1 2 3 Previous Next