新裝了個(gè)測(cè)試數(shù)據(jù)庫(kù)，啟動(dòng)的時(shí)候竟然報(bào)錯(cuò)了，

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/dbs/initTEST.ora'

?

看提示說(shuō)是初始化參數(shù)文件的問(wèn)題，于是查看初始化參數(shù)文件

[oracle@test dbs]$ ls
bakinitTEST.ora? hc_DBUA0.dat? hc_test.dat? init.ora? lkTEST? orapwtest? spfiletest.ora

[oracle@test dbs]$ strings spfiletest.ora
test.__db_cache_size=117440512
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__oracle_base='/oracle/app'#ORACLE_BASE set from environment
test.__pga_aggregate_target=146800640
test.__sga_target=272629760
test.__shared_io_pool_size=0
test.__shared_pool_size=134217728
test.__streams_pool_size=4194304
*.audit_file_dest='/oracle/app/admin/test/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/app/oradata/test/control01.ctl','/oracle/app/orad
ata/test/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='test'
*.diagnostic_dest='/oracle/app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.memory_target=419430400
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

?

參數(shù)文件沒(méi)有什么問(wèn)題，在查看下ORALCE環(huán)境變量的設(shè)置

[oracle@test app]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
??????? . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

ORACLE_BASE=/oracle/app
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=TEST
PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

?

發(fā)現(xiàn)環(huán)境變量中的ORACLE_SID的設(shè)置是TEST（大寫(xiě)的），初始化參數(shù)文件是spfiletest.ora，初始化參數(shù)文件的ORACLE_SID部分是小寫(xiě)的，想起貌似重新建過(guò)數(shù)據(jù)庫(kù)，建庫(kù)的時(shí)候ORACLE_SID是用的小寫(xiě)，修改環(huán)境變量，把環(huán)境變量中的ORACLE_SID改成小寫(xiě)，重新登錄或用下面命令把ORACLE_SID修改正確

export ORACLE_SID=test

在啟動(dòng)數(shù)據(jù)庫(kù)，正常！

SQL> startup
ORACLE instance started.

Total System Global Area? 417546240 bytes
Fixed Size????????????????? 2213936 bytes
Variable Size???????????? 293603280 bytes
Database Buffers????????? 117440512 bytes
Redo Buffers??????????????? 4288512 bytes
Database mounted.
Database opened.

轉(zhuǎn)載于:https://blog.51cto.com/260878993/954170

總結(jié)

以上是生活随笔為你收集整理的解决oracle ORA-01078，LRM-00109故障一例！的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。