oracle| Error | solution | original
No one will deny that Oracle is one of the world's most influential database products, but that good things don't always seem to be as useful (at first glance), or even ruthless--always give layman a ruthless error number. Here is my personal summary, all the useful, hope to give beginners a little enlightenment.
A joke about "the good things don't always seem to be so Easy" (at first glance): In the IBM DB2 512, 513 training before the campus download to the installation program, but let us a few students to study for a half-day, also do not know which file is the installation file, did not install successfully. Finally, agree: it seems that this training is really necessary! Afterwards, only then knew-we downloaded is 4linux!
[Take 8.1.6 as an example]:
1, Ora-12541:tns: No listener
Cause: The listener is not started or the listener is corrupted. If the former, use the command net start Oracleorahome81tnslistener (the name may not be the same), and if it is the latter, use the Net8 Configuration Assistant Tool Wizard's 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 dedicated server process
Or
ORA-12560:TNS: Protocol Adapter error
Reason: Oracle's database service is not started. Use the command net start oracleserviceoradb (ORADB is the database name). If it is still unresolved, continue 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 the following two steps:
1) Oradim-delete-sid oradb Delete database service items
2) Oradim-new-sid oradb New database service items
Note: If there is an error in this process, restart the computer!
4, Ora-12154:tns: can resolve service name
Reason: Oracle's Network service name is not configured correctly. Use the "Local Network Service name configuration" Net8 Configuration Assistant Tool Wizard to configure TNS. If it is still unresolved, continue looking down.
5, Ora-1034:tns:oracle is not available
Cause: Oracle's database service started correctly, but the database did not open!
To use the command:
1) SVRMGRL start Service Manager
2 Connect internal to internal identity landing
3) startup Open the database
6, Ora-12560:tns: Protocol adapter error (stubborn)
Reason: Unknown.
Solution: Must kill skill--opens "The Windows Task Manager", kills the ORACLE.exe and the ORADIM.exe process, writes own Ora_startup.bat, executes!
Ps:
1, my Ora_startup.bat:
net start Oracleorahome81tnslistener
net start oracleserviceoradb
SVRMGRL generally not, but sometimes it is not, the concrete steps see step 5th.
2, my Ora_shutdown.bat:
net stop Oracleorahome81tnslistener
net stop oracleserviceoradb
3, Oracle related service name see the service name that begins with Oracle in the services of administrative tools.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
