Oracle ora-12541,ora-12514 Error

1. The Tomcat was released yesterday, but after login error, unable to open hibernate session, check that the database cannot connect

2. Using PL/SQL to log in to the database, reported ora-12541,tns no listening program, Baidu found the need to configure monitoring, not its solution, because I have not moved the database, try to configure the method by

can refer to http://www.cnblogs.com/Venom/p/3953025.html

And then you keep rebooting.

3. It's still not working. Change the file configuration in the installation directory, and think that the two should work the same. Or find the file in the directory, open it.

My directory is: E:\app\albertfg\product\11.2.0\dbhome_1\NETWORK\ADMIN

There are 3 files in this directory: Listener.ora;sqlnet.ora;tnsnames.ora;

4. First file:

# Listener.ora Network Configuration file:e:\app\username\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools. Sid_list_listener=(Sid_list=(Sid_desc=(Global_dbname=ORCL) (Oracle_home= E:\app\username\product\11.2.0\dbhome_1) (Sid_name=ORCL)) (Sid_desc=(Sid_name=Clrextproc) (Oracle_home= E:\app\albertfg\product\11.2.0\dbhome_1) ( Program=Extproc) (Envs="Extproc_dlls=only:e:\app\username\product\11.2.0\dbhome_1\bin\oraclr11.dll")) LISTENER=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.1.101) (PORT =1521))) Adr_base_listener= E:\app\username

5: A third file:

# Tnsnames.ora Network Configuration file:e:\app\username\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools. Oraclr_connection_data=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1521)) ) (Connect_data=(SID=Clrextproc) (PRESENTATION=RO)) ) LISTENER_ORCL=(ADDRESS= (PROTOCOL = TCP) (HOST = localhost) (PORT =1521)) ORCL=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = TCP) (HOST =192.168.1.101) (PORT =1521)) ) (Connect_data=(service_name=ORCL)) )

6. It's still useless to change it, ora-12514.

Later, Baidu found restarting the Oracle server, helpless, restarted the computer, back to normal.

7. Summary: Later, mainly in the local area network IP address dynamic allocation, although I gave the server fixed IP, but yesterday due to come back late, roommate first opened the machine, coincidentally, and assigned the server IP address

Cause my configuration to expire. Remember before also appeared once, unfortunately did not have long memory, so still write some simple record.

Oracle ora-12541,ora-12514 Error