Oracle error highlights: ORA-00119 & ORA-00132, oracleora-00119

[Oracle error highlights]: ORA-00119 & ORA-00132, oracleora-00119

Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is very strange, and no error code is prompted. Enter the user name and password. After clicking "Log on", the PL/SQL statement does not reflect the password.

I am so depressed that I don't even tell you how to solve the problem. Suddenly I thought that Oracle would certainly have a place to record logs. Check it out.

Oracle log location: D: \ app \ NiuNiu \ product \ 11.2.0 \ dbhome_1 \ database \ oradim. log

Two errors are found:

Tue Jun 23 15:32:41 2015
D: \ app \ NiuNiu \ product \ 11.2.0 \ dbhome_1 \ bin \ oradim.exe-startup-sid drp-usrpwd *-log oradim. log-nocheck 0
Tue Jun 23 15:32:48 2015
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'listener _ drp'

For example, the two errors shown in the log: ORA-00119 and ORA-00132, may be because these two errors cause PL/SQL to not log on properly. Find the root cause of the error and you can solve these two problems:

Solution 1: Check whether the tnsname. ora file contains this string. If not, add the string as needed.

LISTENER_DRP =  (ADDRESS = (PROTOCOL = TCP)(HOST = Niu)(PORT = 1521)) 

DRP is your database sid, and host is the host name.

Solution 2: If the tnsname. ora file is correct, this problem may also occur. You can only use solution 2.

I found a lot of information on the Internet. It mainly means to generate pfile with spfile, modify the local_listener parameter, and then generate the spfile file again. The steps are as follows:

1. Copy A pfile parameter file through spfile (Note: pfile in oracle refers to init. ora file. For example, the pfile File Created by the following command is "INITdrp. ORA "; spfile is SPFILEDRP. ORA)

SQL> create pfile from spfile='D:\app\NiuNiu\product\11.2.0\dbhome_1\database\SPFILEDRP.ORA';

2. Modify the pfile parameter file (that is, modify the init. ora file, that is, the INITdrp. ORA file in this article)

After step 1, The init. ora file will be generated in the $ ORACLE_HOME/database directory. Because my oracle instance is named drp, my pfile file is INITdrp. ORA. Open the file in notepad, find the line local_listener, and change its value:

(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))

Your_hostname indicates your host name.

3. regenerate the spfile file SPFILEDRP. ORA.

SQL> create spfile from pfile='D:\app\NiuNiu\product\11.2.0\dbhome_1\database\INITdrp.ORA';

4. Run the startup command to restart the database.

Entire Process:

When an error is reported, you must learn to view the information in the Oracle error log. Sometimes, the error is not shown on the surface. You need to seek root information.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.