Solutions for Oracle ORA-00119 and ORA-00132

The following error was encountered today when starting Oracle on the server:

Sql> startup;

ORA-00119:INVALID specification for system parameter Local_listener
Ora-00132:syntax error or unresolved network name ' LISTENER_ORCL '

Then, I found some information on the internet to solve this problem.

The solution is as follows (this is a talent solution on the Internet, I follow his steps to solve the problem, but decided to make a note):

First step: Copying a copy of the Pfile parameter file (Note: Pfile in Oracle refers to the Init.ora file)

$./sqlplus/as Sysdba;

Sql> create Pfile from spfile= '/u01/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora ';

Step Two: Modify the Pfile parameter file (that is, modify the Init.ora file)

After the first step, you will find a file Init.ora in the $oracle_home/dbs directory, which is the file you created in the first step. Because my Oracle instance name is ORCL, my pfile file is Initorcl.ora.

Open with Gedit, locate the Local_listener line, and then modify its value to:

(Address_list= (address= (protocol=tcp) (Host=your_hostname) (port=1521)))

The your_hostname is your hostname, in fact the cause of ORA-00119 and ORA-00132 error is probably you modified your hostname, but I looked at my Tnsname.ora file inside the Listener_ ORCL (maybe you're not the name) and the Your_hostname in the back, I'm just going to do the Tnsname.ora file (address_list= (address= (protocol=tcp) (host=your_ hostname) (port=1521)) is copied to the Pfile file after the "local_listener=", and then the database has been successfully started, I do not know why directly with *.local_listener= ' LISTENER_ORCL ' Can not find, but must *.local_listener= ' (address_list= (address= (protocol=tcp) (host=your_hostname))) ' Only, This is a question to study later.

Here is a sample of my modifications:

This could be before the change.

*.local_listener= ' LISTENER_ORCL '

The modified value is probably what it looks like.

*.local_listener= ' (address_list= (address= (protocol=tcp) (host=your_hostname))) '

And then save the exit

Step three: Create SPFile with Pfile

Use the following command to create a spfile

Sql> create SPFile from pfile= '/u01/oracle/product/10.2.0/db_1/dbs/initorcl.ora ';

Fourth step: Start the database

Sql> startup;

ORACLE instance started.

Total System Global Area * * * bytes
Fixed Size * * * bytes
Variable Size * * * bytes
Database Buffers * * * bytes
Redo Buffers * * * bytes
Database mounted.
Database opened.

[Reference]http://blog.chinaunix.net/uid-24612962-id-3189342.html

Solutions for Oracle ORA-00119 and ORA-00132