6 Errors and solutions most frequently encountered by Oracle installations

6 errors and solutions most frequently encountered by Oracle installations

[ take 8.1.6 as an example]:

1 , Ora-12541:tns: No listener

cause: There is no boot listener or the listener is corrupted. If the former, use the command net start Oracleorahome81tnslistener (the name may differ), and if the latter, use the"Net8 Configuration Assistant"of the tool wizard"Listener Configuration"Add a listener (basically do not write any information, all the way OK. You may need to remove all the listeners before adding them! )

2 , Ora-12500:tns: The listener cannot start the private server process or Ora-12560:tns: Protocol Adapter Error

Cause: Oracle's database service is not started. You can use the command net start oracleserviceoradb (oradb as the database name). If it's still not resolved, keep looking down.

3 , if the database service fails to start, it is most likely that its registry key value is corrupted, and the best practice is to do the following two steps:

1) Oradim-delete-sid oradb Delete database service item 2) Oradim-new-sid oradb New database service entry Note: If there is an error in this process, restart the computer!

4 , Ora-12154:tns: Can parse service name

Cause: The Network Service name for Oracle is not configured correctly. Please use"Net8 Configuration Assistant"of the tool wizard"Local Network Service name configuration"configure TNS. If it's still not resolved, keep looking down.

5 , ora-1034:tns:oracle not available

Cause: The Oracle database service started correctly, but the database is not open!

Use the command:

1) svrmgrl   start Service Manager 2) connect internal log in as internal 3) startup   Open database

6 , Ora-12560:tns: Protocol adapter error (stubborn)

Cause: Unknown.

solve: must kill skill--open " windows Task Manager "

PS :

1 , my ora_startup.bat:

net start Oracleorahome81tnslistener
net start oracleserviceoradb
SVRMGRL generally do not use, but sometimes it is necessary, the concrete steps to see the 5th step.

2 , my ora_shutdown.bat:

net stop Oracleorahome81tnslistener
net stop oracleserviceoradb

3, Oracle related service name, see"Management Tools"of"Service"the name of the service that begins with Oracle.  

6 Errors and solutions most frequently encountered by Oracle installations