Oracle's newcomer's most frequently encountered six errors and solutions (original)

xiaoxiao2021-03-06  71

No one will deny that Oracle is one of the most affected database products worldwide; but good things seem to be so easy (first looks so), even somewhat ruthless - always give Layman a ruthless error number. Below is my personal summary, the bar strip is useful, I hope to give beginners to reveal.

About "good things seem to be so easy to use (first looks like this)" before participating in IBM DB2 512, 513 training, downloaded the installer online before the training, but he studied for a half day, I don't know which file is installed, there is no successful installation. Finally, unanimously think: it seems that this training is too necessary! Afterwards, I know - we downloaded 4Linux!

[Take 8.1.6 as an example]:

1, ORA-12541: TNS: No listener reasons: No startup listener or listener is damaged. If the former, use the command NET Start OracleoraHome81TNSListener (the name may be available); if it is the latter, use the "Net8 Configuration Assistant" Tool Wizard to add a listener (basically no information , All the way OK. Maybe you may need to delete all the listeners before adding!)

2, ORA-12500: TNS: Listener Unable to start private server processes or ORA-12560: TNS: Protocol Adapter Error Cause: Oracle's database service is not started. Use the command NET Start OraclesErViceRadB (ORADB to the database name). If you still have not been resolved, please continue to look down.

3, if the database service failed, it is very likely that the registration item value is corrupted, the best practice is the following two steps: 1) ORADIM-DELETE -SID ORADB Delete Database Service Item 2) ORADIM -NEW -SID ORADB new Add database service item note: If you go wrong during this process, restart your computer!

4, ORA-12154: TNS: Can resolve service name: Oracle's network service name is not properly configured. Please use the "Net8 Configuration Assistant" Tool Wizard to configure TNS. If you still have not been resolved, please continue to look down.

5, ORA-1034: TNS: Oracle is not available: Oracle's database service is started correctly, but the database is not open! Use commands: 1) SVRMGRL Startup Service Manager 2) Connect Internal Log in in INTERNAL 3) Startup Open Database

6, ORA-12560: TNS: Protocol adapter error (refractory) Reason: Unknown. Solve: Killing - Open "Windows Task Manager", kill Oracle.exe and ORADIM.EXE processes, write your own Ora_Startup.bat, execute!

PS: 1, my Ora_Startup.bat: Net Start OracleoraHome81 TNSListenernet Start OracleserviceOrAdbsVRMGRL Normally, but sometimes it is less than it, see Step 5. 2, my Ora_Shutdown.bat: Net Stop OracleraHome81 TNSListenernet Stop OracleserviceOrAdb

3. Oracle Related Service Name See "Services" of the Administration Tools in Oracle's service name in Oracle.

转载请注明原文地址:https://www.9cbs.com/read-120391.html

New Post(0)