Solution to Oracle 11g ORA-00119 ORA-00132

Solution to Oracle 11g ORA-00119 ORA-00132

When Oracle 11g is started in Linux, the following error is reported:

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address XIANGDE_LISTENER

There are also many people on the Internet who have encountered such problems. The solutions are basically the same, but there are some differences between oracle11g and oracle10g.

$./Sqlplus/as sysdba;

SQL> create pfile from spfil = 'd: \ app \ fy \ product \ 11.2.0 \ dbhome_1 \ database \ SPFILEXIANGDE. ORA ';

After this statement is executed, the INITxiangde. ORA file is generated under the database.

Change the *. local_listener value in the INITxiangde. ORA file to, for example:

*. Local_listener = '(ADDRESS_LIST = (Address = (Protocol = tcp) (Host = serverIP) (Port = 1521 )))'

Run again

SQL> create spfile from pfil = 'd: \ app \ fy \ product \ 11.2.0 \ dbhome_1 \ database \ INITxiangde. ORA ';

SQL> startup

In this way, it starts (xiangde is SID)

The difference between 11g and 10g is that the spfile is placed under dbs, while 11g is placed under the database.

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian