Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database is not able to start, due to error: ORA-01078 and ORA-27086

880047Sep 25 2011 — edited Oct 1 2011
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2011
Added on Sep 25 2011
37 comments
4,403 views