ORA-01078: failure in processing systemparameters LRM-00109: could not open parameter


[oracle@localhost dbs]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 08:58:08 2010

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

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing systemparameters
LRM-00109: could not open parameter file'/app/oracle/product/11.2.0/dbhome_1/dbs/initTESTDB.ora'
SQL> exit
Disconnected
[oracle@localhost dbs]$

[oracle@localhost pfile]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 09:08:29 2010

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

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup nomountpfile=/app/oracle/admin/TESTDB/pfile/init.ora
ORACLE instance started.

Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 209718360 bytes
Database Buffers 96468992 bytes
Redo Buffers 6336512 bytes
SQL> create spfile from pfile
2 ;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing systemparameters
LRM-00109: could not open parameter file
'/app/oracle/product/11.2.0/dbhome_1/dbs/initTESTDB.ora'

SQL> create spfile frompfile=/app/oracle/admin/TESTDB/pfile/init.ora;
create spfile frompfile=/app/oracle/admin/TESTDB/pfile/init.ora
*
ERROR at line 1:
ORA-02236: invalid file name

SQL> create spfile frompfile='/app/oracle/admin/TESTDB/pfile/init.ora';

File created.

SQL> create pfile from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 11g EnterpriseEdition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and RealApplication Testing options
[oracle@localhost pfile]$ pwd
/app/oracle/admin/TESTDB/pfile
[oracle@localhost pfile]$ ls
init.ora
[oracle@localhost pfile]$ ls -ltr $ORACLE_HOME/dbs
total 72
-rw-r--r-- 1 oracle dba 2851 May 15 2009 init.ora
drwx------ 2 oracle dba 4096 Jun 20 14:19peshm_DBUA0_0
-rw-rw---- 1 oracle dba 1544 Jun 20 14:19hc_DBUA0.dat
drwx------ 2 oracle dba 4096 Jun 20 22:52peshm_TESTDB_0
-rw-r----- 1 oracle dba 1536 Jun 20 22:52orapwTESTDB
-rw-rw---- 1 oracle dba 1544 Jun 20 22:52hc_TESTDB.dat
-rw-r----- 1 oracle dba 24 Jun 20 22:52 lkTESTDB
-rw-r----- 1 oracle dba 1536 Jun 21 09:14spfileTESTDB.ora
-rw-r--r-- 1 oracle dba 476 Jun 21 09:14 initTESTDB.ora
[oracle@localhost pfile]$/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun21 09:15:44 2010

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

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and RealApplication Testing options

SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> startup
ORA-01081: cannot start already-running ORACLE -shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 209718360 bytes
Database Buffers 96468992 bytes
Redo Buffers 6336512 bytes
Database mounted.
Database opened.
SQL> select name from v$database;

NAME
---------
TESTDB

SQL>
Advertisements

7 comments

  1. Çok güzel bir anlatım olmuş. Teşekkürler.

  2. Teshekkur ederim!!

  3. This was so helpful

  4. You are welcome !!1

  5. Just wanted to say thank you too for the solution.

  6. SQL> startup;
    ORACLE instance started.

    Total System Global Area 845348864 bytes
    Fixed Size 1339796 bytes
    Variable Size 494931564 bytes
    Database Buffers 343932928 bytes
    Redo Buffers 5144576 bytes
    ORA-01102: cannot mount database in EXCLUSIVE mode

    merhaba hocam. Bu hata hakkında yardımcı olabilir misiniz?
    ASM grid üzerinde 11gR2 kurmaya çalıştım. ilkerdb ve ilkerdb2 diye iki adet DB im var. sizin POST sonunda ORA-01102 hatasını aldım. teşekkür ederim şimdiden

  7. $ ps -ef |grep ora_|grep pc00sb ciktisi ne veriyor paylasha bilirmisin?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: