Personal Summary: Oracle Database Listener service failed to start

1.
IP error. Error in setting URL, for example: Jdbc:oracle:thin:@192.168.0.36:1521:sharp database server is incorrect: Ping server IP is correct.
Incorrect, change URL to correct port number error: generally not error.
To do this: type Sqlplus on DOS, check that Oracle is turned on, and perform step 2nd below. 2. Firewalls may be caused by a server port number shield If a fire wall is installed on the machine.
After you close the firewall, try to reconnect.
Still not, perform step 3rd. 3.
Database listener did not start modifying the ImagePath value in the registry on your PC. I'm going to start the database manually again with the current mainstream database Oracle: 1: Start → run → enter cmd→ enter DOS command prompt interface d:>lsnrctl lsnrctl> status or lsnrctl> start if class
Like the information in the picture congratulations, your problem has been found out, is the database listener did not start and caused. Here's how to manually start the database: Execute regedit at run place to start → run →regedit the following path hkey_local_machine\system\currentcontrolset\services\

Oracleorahome90tnslistener Find Oracleorahome90tnslistener (I use oracle9i other version should be Oracleorahomexxxtnslistener)
 
When you find it, you'll find that the ImagePath key value doesn't exist. Create it: (if present, click Modify, modify method described below) Right click, pop-up menu select New Key (N) → string value (S) to name it ImagePath Select the ImagePath point right-click, select Modify: Enter your Oracle installation directory \ora90 (other this corresponds to the oraxxx directory) in the value \bin\tnslsnr if Oracle 10G the installation directory is F:\oracle\product\10.1.0\Db_2\BIN\
Tnslsnr to exit the registry after the confirmation: then type start under DOS command if the following screen appears, congratulations, the listener started successfully: Shut down DOS, start your program for testing, should be back to normal. The above is the common trigger in 3 of the network Adapter could not establish theThe main reason for the connection exception is: 1. There may be an error in the DataSource configuration of the Server.xml file. (1). If you use the data on this computer, part of the local data source is configured to: Username= "pcisv62" password= "one" url= "Jdbc:oracle:thin: @localhost: 1521:orcl" (2). If the data on the server is used, the portion of the data source is configured to: Username= "pcisv62" password= "url=" Jdbc:oracle:thin: @dbserver: 1521:corev6 " (DBServer is the name of the server, COREV6 is the SID of Oracle on the server) 2. There may be an error in Oracle's Tnsnames.ora file configuration. Oracle's installation directory E:\oracle\ora92\network\admin Tnsnames.ora: Local configuration: ORCL = (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (host = hostname) (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 = Corev 6) (SERVER = dedicated)) A little description of the network Adapter could not establish the connection exception: encountered in practice through Pl/sql developer It's normal to go to the company.

-------------------------------------cut---------------line----------------------------------

Oracle Listener PROBLEM: First error: Registry uses optimized software to delete related items;
For each system service is actually saved in the registry;
Correlation item name in the registry: Hkey_local_machine\system\controlset001\services\oracleoradb11g_home1tnslistener;



There is a imagepath:e:\oracleinstall\product\11.2.0\dbhome_1\bin\tnslsnr in it; This option is likely to be automatically deleted by the optimization software, and if deleted, the following methods are used to determine the solution:
Solution method: To create a new relevant registration entry in accordance with the format;


Second error: Network environment change (10G version): 11g version improved
；
Problem Description: The main reason is that the name of the computer has been changed:

When the network environment changes, the listening service will not start; the solution to the problem is to modify the network configuration file:
Configuration file path: E:\oracleInstall\product\11.2.0\dbhome_1\NETWORK\ADMIN;
There are two profiles: Listener.ora;tnsnames.ora; Open two files through Notepad:




But after using the program to connect ORACLE1G, the database cannot be accessed properly.
The second part: choose Net Manager, enter the network configuration interface;




Configuration completed; This Yang on the solution to the problem;