Oracle Error:ORA-00119/ORA-00130

來源:互聯網
上載者:User

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

--------------------------------------分割線 --------------------------------------

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.