Solutions for Oracle ORA-00119 and ORA-00132

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

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.