更换了服务器的IP与主机名后启动Oracle服务报错：
|
1
2
3
4
5
6
7
8
9
10
|
SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 14 13:51:39 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle instance.SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oracledbtest20)(PORT=1521))'SQL> |
解决方法如下：
1. 修改LOCAL_LISTENER参数
1.1 创建pfile
|
1
2
3
4
5
6
|
SQL> conn / as sysdbaConnected to an idle instance.SQL> create pfile from spfile;File created.SQL> quitDisconnected |
1.2 修改pfile内容(如没有相关内容则添加至文件末尾)
|
1
|
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Your IP)))' |
1.3 使用pfile启动Oracle服务
|
1
2
3
4
5
6
7
|
SQL> conn / as sysdbaConnected 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
|
1
2
3
|
SQL> create spfile from pfile;File created.SQL> quit |
2. 重启
|
1
2
3
4
5
6
7
8
9
10
|
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.……Database mounted.Database opened.SQL> |
