Oracle Database listening service cannot be started. How can this problem be solved ?, Oracle Database

Oracle Database listening service cannot be started. How can this problem be solved ?, Oracle Database

1. IP address error.

URL setting error, for example: jdbc: oracle: thin: @ 192.168.0.36: 1521: sharp

Incorrect database server: ping the Server IP address. Incorrect. Change the URL to correct

Port Number error: it is normal.

Perform the following operations: Type sqlplus on DOS and check whether oracle is enabled.

1, but it is normal. Execute Step 1 below.

2. Firewall

If a firewall is installed on the machine, it may be caused by blocking the server port number. Close the firewall and try again.

Still not working. Execute step 1.

3. The ImagePath value in the Registry on the PC is not modified when the Database Listener is not started.

The following uses the current mainstream database ORACLE as an example.

Restart the Database Listener manually:

1: Start → run → Enter CMD → enter the DOS command prompt page

D:> lsnrctl

LSNRCTL> status

Or

LSNRCTL> start

For information similar to the image

Congratulations, Your problem has been found out because the Database Listener has not been started.

The following describes how to manually start a database:

Execute regedit at the runtime to enter the Registry

Start → run → regedit

Follow the path below

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ OracleOraHome90TNSListener

Locate OracleOraHome90TNSListener (I am using Oracle9i and other versions should be oracleorahomxxtnslistener)

After finding it, you will find that the key value of ImagePath does not exist. Create it: (if it exists, click Modify. The modification method is described below)

Right-click and choose new key (N)> string value (S) from the shortcut menu)

Name it ImagePath

Right-click ImagePath and select modify:

Enter your Oracle installation directory \ ora90 (other books correspond to the oraxxx directory) \ bin \ tnslsnr

For ORACLE 10 Gb, the installation directory is F: \ oracle \ product \ 10.1.0 \ Db_2 \ BIN \ tnslsnr.

Confirm and exit the registry:

In the doscommand, type start

If the following figure appears, congratulations, the listener is started successfully:

Close DOS and start your program for testing. It should be restored to normal.

The above is the common cause of The Network Adapter cocould not establish the connection exception in 3.

Main Cause: 1. The DataSource configuration of the server. xml file may be incorrect. (1 ). if data on the local machine is used, the configuration in the local data source is: username = "pcisv62" password = "11" url = "jdbc: oracle: thin: @ localhost: 1521: orcl"

(2 ). if the data on the server is used, the configuration in the data source is: username = "pcisv62" password = "11" url = "jdbc: oracle: thin: @ dbserver: 1521: corev6 "(dbserver is the server name and corev6 is the SID of Oracle on the server) 2. it may be oracle's tnsnames. an error occurred while configuring the ora file. Oracle installation directory E: \ oracle \ ora92 \ network \ admin tnsnames. ora:

Local Configuration:

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = HOST Name) (PORT = 1521 ))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

)

Or Server Configuration:

COREV6_DBSERVER =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = dbserver) (PORT = 1521 ))

)

(CONNECT_DATA =

(SID = COREV6)

(SERVER = DEDICATED)

)

)

About The Network Adapter cocould not establish the connection exception:

In practice, it is normal to use pl/SQL developer to connect.

Oracle listening problems:

First error: The registry used optimization software to delete related items;

Every system service will be saved in the registry;

Name of related items in the Registry: HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ OracleOraDb11g_home1TNSListener;

There is an imagePath: E: \ oracleInstall \ product \ 11.2.0 \ dbhome_1 \ BIN \ TNSLSNR in it. This option may be automatically deleted by the optimization software, use the following method to solve the problem:

Solution: Create a new registration item according to the format, and use the same

Second error: Network Environment Change (10g version): 11G version improved

;

Problem description: The computer name is changed:

When the network environment changes, the listening service cannot be started. To solve the problem, you must modify the network configuration file:

Configuration File Path: E: \ oracleInstall \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN;

There are two configuration files: listener. ora; tnsnames. ora; use NotePad to open the two files:

However, if you use a program to connect to oracle1G, you cannot access the database normally.

Part 2: Select Net Manager to go to the network configuration page;

After the configuration is complete, the problem is solved.