Oracle Error:ORA-00119/ORA-00130
更換了伺服器的IP與主機名稱後啟動Oracle服務報錯:
SQL*Plus: Release 11.2.0.2.0 Production
on
Wed Nov 14 13:51:39 2012
Copyright (c) 1982, 2010, Oracle.
All
rights reserved.
SQL> conn /
as
sysdba
Connected
to
an idle instance.
SQL> startup
ORA-00119: invalid specification
for
system parameter LOCAL_LISTENER
ORA-00130: invalid listener address
'(ADDRESS=(PROTOCOL=TCP)(HOST=oracledbtest20)(PORT=1521))'
SQL>
解決方案如下:
1. 修改LOCAL_LISTENER參數
1.1 建立pfile
SQL> conn /
as
sysdba
Connected
to
an idle instance.
SQL>
create
pfile
from
spfile;
File created.
SQL> quit
Disconnected
1.2 修改pfile內容(如沒有相關內容則添加至檔案末尾)
*.local_listener=
'(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Your IP)))'
1.3 使用pfile啟動Oracle服務
SQL> conn /
as
sysdba
Connected
to
an idle instance.
SQL> startup pfile=
'$ORACLE_HOME/dbs/init$ORACLE_SID.ora'
;
ORACLE instance started.
……
Database
mounted.
Database
opened.
1.4 根據pfile建立新的spfile
SQL>
create
spfile
from
pfile;
File created.
SQL> quit
2. 重啟
SQL> shutdown immediate
Database
closed.
Database
dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
……
Database
mounted.
Database
opened.
SQL>
--------------------------------------分割線 --------------------------------------
Oracle Error:ORA-12514
在CentOS 6.4下安裝Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虛擬機器中安裝步驟
Debian 下 安裝 Oracle 11g XE R2
--------------------------------------分割線 --------------------------------------