Oracle Error: ORA-00119/ORA-00130

Oracle Error: ORA-00119/ORA-00130

When Oracle is started after the Server IP address and host name are changed, the following error occurs:

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>

The solution is as follows:
1. Modify the LOCAL_LISTENER Parameter
1.1 create pfile

SQL> conn / as sysdba Connected to an idle instance. SQL> create pfile from spfile; File created. SQL> quit Disconnected

1.2 modify the pfile content (if no relevant content exists, add it to the end of the file)

*.local_listener= '(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Your IP)))'

1.3 Use pfile to start the Oracle service

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 create a new spfile Based on pfile

SQL> create spfile from pfile; File created. SQL> quit

2. Restart

SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. …… Database mounted. Database opened. SQL>

-------------------------------------- Split line --------------------------------------

Oracle Error: ORA-12514

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------