Six Common Errors in Oracle Database Service

No one would deny that Oracle is one of the most influential database products in the world; but good things do not seem to be so useful (it seems at first ), even a bit heartless-it always gives layman a heartless error number. The following is my personal summary, which is useful and I hope to give some inspiration to beginners.

A joke about "good things do not always look so useful (it seems so early)": before attending IBM DB2 512 and 513 training, I downloaded the installer on the campus network, however, for a few of us to study it for a long time, I do not know which file is the installation file, but it was not installed successfully. Finally, I agree that this training is really necessary! I learned later that we downloaded 4 Linux!

1. ORA-12541: TNS: No listener

Cause: the listener is not started or damaged. If it is the former, run the net start OracleOraHome81TNSListener command (the name may be different). If it is the latter, you can add a listener to "Listener Configuration" in the "Net8 Configuration Assistant" tool wizard. (no information is required. 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. If the problem persists, proceed to the following section.

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!

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!

PS:

1. My ora_startup.bat:
◆ Net start OracleOraHome81TNSListener
◆ Net start OracleSERVICEORADB
◆ Svrmgrl is generally not used, but sometimes it is indispensable. For detailed steps, see step 1.

2. My ora_shutdown.bat:
◆ Net stop OracleOraHome81TNSListener
◆ Net stop OracleSERVICEORADB

3. for Oracle service names, see service names starting with Oracle in "services" in "Administrative Tools"

1. Test connection to the Oracle Database Server
2. Oracle Database Service Details
3. Chatting with Oracle database servers
4. Analysis of Oracle Database Service on Windows
5. How to adjust the performance of the Oracle Database Server