LRM-00109: could not open parameter file '/u01/.../dbs/initshdb.ora'
環境:
oralce 11g 11.2.0.3單節點
報錯資訊:
SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initshdb.ora'
無法啟動到nomount狀態:
找不到pfile檔案
到dbs目錄下面去找pfile檔案
[oracle@test dbs]$ mv initshdb1.ora initshdb.ora
[oracle@test dbs]$ ll
total 16
-rw-rw---- 1 oracle oinstall 1544 Dec 5 09:58 hc_shdb.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 1290 Nov 29 10:51 initshdb.ora
-rw-r----- 1 oracle oinstall 24 Nov 29 11:36 lkSHDB
[oracle@test dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 7 10:18:50 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 1107296424 bytes
Database Buffers 5284823040 bytes
Redo Buffers 19320832 bytes
SQL> alter database mount;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /mnt/data/archivelog/
Oldest online log sequence 109
Next log sequence to archive 113
Current log sequence 113
SQL> alter database open;
Database altered.
可以啟動。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2148392/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- What Is a Server Parameter File?Server
- Exporting the Server Parameter FileExportServer
- Errors and Recovery for the Server Parameter FileErrorServer
- su - root could not open sessionSession
- ORA-01110: data file 7: '/u01/app/oracle/product/11.2.0/db_1/dbs/MISSING00007'APPOracle
- Could not open command file '/usr/local/nagios/var/rw/nagios.cmd' for update!iOS
- nested exception is IncompleteElementException: Could not find parameter mapException
- Migrating to a Server Parameter FileServer
- Step 3: Create the Initialization Parameter File (61)
- su的時候報:could not open sessionSession
- What is the $ORACLE_HOME/dbs/hc_<ORACLE_SID>.dat fileOracle
- Could not find first log file name in binary log index fileIndex
- MySQL server PID file could not be found!MySqlServer
- WPF open image and print as pdf file
- Step 5: Create a Server Parameter File (Recommended) (63)Server
- vue3 Could not find a declaration file for moduleVue
- open_basedir() restrictijon in effect. FIle()REST
- ftp 報錯 550 Failed to open fileFTPAI
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- VueX Vue: Could not find a declaration file for module vuex.Vue
- Linux open file與 fs-maxLinux
- apr_file_open函式用法心得函式
- libmysqlclient.so.16: cannot open shared object file: No such file or directoryIBMMySqlclientObject
- libcap.so.1:cannot open shared object file: No such file or directoryObject
- libXext.so.6: cannot open shared object file: No such file or directoryObject
- libz.so.1: cannot open shared object file: No such file or directoryObject
- WebLogic啟動報Could not get the server file lockWebServer
- ImportError: libffi.so.7: cannot open shared object file: No such file or directoryImportErrorObject
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- go tool compile 報錯 could not import sync (file not found)GoCompileImport
- OGG-01453 Database login information not specified in parameter fileDatabaseORM
- ORA-31617 unable to open dump file for write
- 記錄 libldap-2.4.so.2: cannot open shared object file: No such file or directoryLDAObject
- 問題1.libXp.so.6: cannot open shared object file: No such file or directoryObject
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- Could not load file or assembly 'xxx' or one of its dependencies.
- ORA-15180: could not open dynamic library ASM LibraryASM
- vmwar出現Could not open...Please make sure that the kernel modul的問題