Database is not able to start, due to error: ORA-01078 and ORA-27086
880047Sep 25 2011 — edited Oct 1 2011I am working on the standalone database 11g and i need to manage the database on this server. But when i check it, the DB and Listener is not up & running and i have started the Listener, but not able to start the DB, getting following errors. i have already posted this question in this forums and i didn't get resolved. Can some on please help me.
Below are the some info:
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/u01/app/e16128/oracle/admin/e16128/pfile/spfilee16128.ora'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
SQL> startup pfile='/u01/app/e16128/oracle/admin/e16128/pfile/inite16128.ora';
ORA-01565: error in identifying file '/u01/app/e16128/oracle/admin/e16128/pfile/spfilee16128.ora'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/u01/app/e16128/oracle/admin/e16128/pfile/spfilee16128.ora'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10
--tnsping also working.
-bash-3.2$ id
uid=550(oracle) gid=551(dba) groups=551(dba)
-bash-3.2$ ps -ef | grep -i pmon
oracle 24383 23053 0 18:56 pts/1 00:00:00 grep -i pmon
-bash-3.2$ ls -ltr $ORACLE_HOME/dbs
total 32
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
-rw-rw---- 1 oracle dba 1544 Jan 7 2010 hc_orcl.dat
-rw-rw---- 1 oracle dba 1544 Jan 7 2010 hc_DBUA0.dat
-rw-rw---- 1 oracle dba 1544 Jan 7 2010 hc_ovm11gr2.dat
-rw-rw---- 1 oracle dba 1544 Aug 3 2010 hc_db1333.dat
-rw-r----- 1 oracle dba 24 Aug 3 2010 lkDB1333
-rw------- 1 oracle dba 24 Aug 23 16:45 lkE16128
-rw-rw---- 1 oracle dba 1544 Aug 23 16:47 hc_e16128.dat
-rw-r----- 1 oracle dba 3584 Sep 1 14:04 spfilee16128.ora
-rw-r--r-- 1 oracle dba 68 Sep 1 14:06 inite16128.ora
Lat 70 line of Alert log info:
-------------------------------------
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 help me to find out the way. I have searched so many things but not able to resolve the issue, I have postponed from last 2 weeks to fix this.
Thanks in advance.