No one would deny that Oracle is one of the most influential database products in the world. However, a large system always has various problems, and many inexperienced users are helpless in the face of error prompts. This article lists some common problems and solutions in the use of Oracle databases, hoping to provide some inspiration for beginners.
1. ORA-12541: TNS: No listener
Cause: the listener is not started or damaged. If it is the former, use the command Net start oracleorahome81tnslistener (the name may be different); if it is the latter, use the "net8 configuration assistant" tool Wizard to "ListenProgramAdd a listener (no need to write any information, all the way OK. You may need to delete all listeners before adding them !)
2. ORA-12500: TNS: The Listener cannot start a dedicated server process or ORA-12560: TNS: protocol adapter Error
Cause: Oracle Database Service is not started. Run the Net start oracleserviceoradb command (oradb is the database name.
3. If the database service fails to be started, the registry key value may be corrupted. The best practice is to perform the following two steps:
1) oradim-delete-Sid oradb deletes database service items
2) oradim-New-Sid oradb adds database service items
Note: if an error occurs during this process, restart the computer!
4, ORA-12154: TNS: can resolve the service name
Cause: the network service name of Oracle is not correctly configured. Use "Local Network Service name configuration" in the "net8 configuration assistant" tool Wizard to configure TNS. If the problem persists, proceed to the following section.
5. ORA-1034: TNS: Oracle unavailable
Cause: the Oracle Database Service is correctly started, but the database is not opened!
Solution:
Run the following command:
1) svrmgrl start the Service Manager
2) connect internal logs in as internal
3) Startup open the database
6. ORA-12560: TNS: protocol adapter error (stubborn)
Cause: unknown.
Solution: Be sure to activate the Windows Task Manager, kill oracle.exeand oradim.exe processes, write your own ora_startup.bat, and execute it!