Summary of solutions for Oracle 10g listening listener failures

Oracle 10gListenersListener cannot be startedThere are many reasons for this. In this article, we will summarize the reasons that cause the listener to be disabled. Let's take a look at this part.

1. When the following prompt appears in Oracle: ora-01034: oracle not available, ora-27101: shared mermory realm does not exist.

Solution:

Method 1:

1. Input: connect/as sysdba;

2. restart the computer;

Method 2:

Enter the following command in the command line:

 
 

  
  
C:> svrmgrl
  
  
Oracle Server Manager Release 3.1.7.0.0-Production
  
  
Copyright (c) 2000, Oracle Corporation. All Rights Reserved.
  
  
Oracle8i Enterprise Edition Release 8.1.7.0.0-Production
  
  
With the Partitioning option
  
  
JServer Release 8.1.7.0.0-Production
  
  
 
  
  
SVRMGR> connect internal/oracle
  
  
Connection successful.
  
  
 
  
  
SVRMGR> startup
  
  
 
 
 

It should be okay to connect to the database after startup.

2. Oracle Listener cannot be started suddenly, and the error code is 1067.

Solution:

Enter dos

Enter lsnrctl start

Wait for the result to be displayed. My results are as follows:

Start tnslsnr: Please wait...

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0-Production

The system parameter file is E: oracleora92networkadminlistener. ora.

Log information written to E: oracleora92networkloglistener. log

An error occurred while listening to this object: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 123.118.1.39) (PORT = 1521 ))).

TNS-12545: the connection failed because the target host or object does not exist.

TNS-12560: TNS: protocol adapter error.

TNS-00515: the connection failed because the target host or object does not exist.

32-bit Windows Error: 49: Unknown error.

The listener failed to start. See the error message above...

Check carefully. The IP address was changed by yourself.

Method 1: the IP address can be modified.

Method 2: modify the configuration of the E: oracleora92networkadminlistener. ora file.

3. The AGENT service cannot be started.

Solution ︰

You can delete files such as. q and. ver under the networkagent directory, and then re-agentctl start.

If sqlnet. ora is incorrect, check the content of sqlnet. ora.

 
 

  
  
# SQLNET.ORA Network Configuration File: D:oracleora92networkadminsqlnet.ora  
  
  
# Generated by Oracle configuration tools.  
  
  
SQLNET.AUTHENTICATION_SERVICES= (NTS)  
  
  
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) 
 
 

Name of sqlnet. ora in a three-tier structure

 
 

  
  
# NAMES.PREFERRED_SERVERS =  
  
  
# (ADDRESS_LIST =  
  
  
# (ADDRESS = (PROTOCOL = TCP)(HOST = MICROSOF-3D9384)(PORT = 1575))  
  
  
# ) 
 
 

4. Oracle http server cannot be started

Stop the site that uses port 80 in IIS, or change the port number of the Oracle Http Server.

Here is a summary of the error solution that Oracle 10g listening listener cannot be started. I hope this introduction will be helpful to you!