Brief analysis of common problems and solutions of Oracle database _oracle

Oracle database is often encountered in the use of such or such a problem, and these problems often confuse us, we summarized the Oracle database in the use of some of the problems, and the solution, we begin to analyze these issues.

First, after the Oracle listens to start, stops immediately.

TNS-12545: Connection failed because the target host or object does not exist.

TNS-12560:TNS: Protocol adapter error.

TNS-00515: Connection failed because the target host or object does not exist.

32-bit Windows Error:1004:unknown Error.

No more listening: (Description= (Address= (PROTOCOL=IPC) (PIPENAME=//./PIPE/EXTPROC0IPC)).

The reason is that after I installed Oracle, I also modified the host name.

Workaround:

1. Direct modification of Listener.ora

The path is: Oracle installation directory/product/10.2.0/db_1/network/admin/listener.ora.

Modify host name or IP.

2. Through Net Manager, under the Listener program/listener directly modify the host can

Two. Error codes and Solutions

1.ora:-12545: Connection failed because the target host and object do not exist.

Error code ORA-12545 indicates that the machine name and IP address used in the network connection string (that is, the host in the Tnsnames.ora file) do not exist, and can be modified and reconnected.

2.ora-12651:tns: No listeners.

This information indicates that the server to which you are connecting does not start the listener process listener (the process is an operating system process on an Oracle server, the server can perform properly when the listener process is not started, but the client cannot generate a connection to the server.) At this point, you can start the listening process normally with the operating system command lsnrctl on the server.

3.ora-00600:internal error code,arguments:[num],[?],[?],[?],[?].

Reason: This error is usually an internal error of Oracle and is only useful for OSS and Oracle development. ORA-600 errors are often accompanied by a state dump of the trace file (System State and process State), the system state store will include information about the current object held by the Oracle RDBMS, and the process state dump will show the objects held by the special process, and when the process conforms to an error condition, Often because some information is taken from a block that it holds, it is easy to trace the source of the problem if we know the block the error process holds.

Workaround: in general, this error can not be solved by itself, only by improving the system itself to solve this internal problem, such as adding hardware devices, adjusting system performance, using OPS (of course, OPS is not a good solution in a sense) and so on. The first variable of the ORA-600 error is used to mark the location of the error in the code (the first variable in each part of the code is different), displaying additional information from the second to fifth variable, telling the OSS code where the error occurred

4.ORA-12560 Protocol Adapter Error:

Questions about Ora-12560:tns: Protocol Adapter errors

①. Check terminal Service, Remote Desktop is not a cause.

②. Environment variable set oracle_sid= the service name required.

③.listener.ora, Tnsnames.ora and so on the machine name or IP address is correct.

④.netstat–a Check if the port is occupied.

⑤. Check registry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 new string use_shared_socket=true, restart the service.

Error 5.ora-28595:invalid DLL Path calling external DLL

Reason: A setting in Oracle ' s LISTENER. ORA file on the server hosting the RDBMS is missing.

Solution:

(1). Locate the active LISTENER.  ORA file on the server. By default, it is is on the Oracle RDBMS drive in the path. /ora92/network/admin.

(2).  Inspect the file and locate all entries associated with "Sid_desc". Each such entry should have the following option associated with it:

(Envs = "Extproc_dlls=any")

(3). Add the above line to no entry where it is missing.

(4). Restart the Oracle Listener Service (or reboot server which'll in turn restart Oracle).

Example:

The example LISTENER. ORA file below shows a valid configuration for the server named "WOODY" (using TCP/IP on Port 1521) with the correct Envs Entries highlighted:

# LISTENER. ORA Network Configuration File:c:/oracle/ora92/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER = 
 
(description_list = ( 
 
DESCRIPTION = 
 
(Address_list = 
 
(address = (PROTOCOL = IPC) (KEY = EXTPROC0 )) 
 
(address_list = (Address 
 
= (PROTOCOL = TCP) (HOST = Woody) (PORT = 1521) 
 
)) 
 
sid_ List_listener = 
 
(sid_list = ( 
 
Sid_desc = 
 
(sid_name = Plsextproc) 
 
(oracle_home = c:/oracle/ora92) 
 
(program = extproc) 
 
(Envs = "Extproc_dlls=any") 
 
) 
 
(Sid_desc = 
 
(Global_dbname = WOODY) 
 
(Oracle_home = c:/oracle/ora92) 
 
(Sid_name = WOODY) 
 
(Envs = "Extproc_dlls=any") 
 
) 
 
 

6. Starting the service in Control Panel, the following error occurred:

Service: The Oracleoradb10g_home1tnslistener service cannot be started on the local computer.

Error 3: The system could not find the specified path.

View properties found that the path to the executable file for the Oracleoradb10g_home1tnslistener service is empty.

Solution:

Start--> run regedit--> go to registry to find Hkey_local_machine/system/currentcontrolset/services/oracleoradb10g_ Home1tnslistener

Found ImagePath key values are not available, create a new expandable string value named ImagePath, edit the numeric data for the string as: Oracle installation path/bin/tnslsnr

7. Error Description: The Oracleoradb10g_home1tnslistener service on the local computer was started and stopped. Some services automatically stop if they have nothing to do, such as the Performance Logs and Alerts service.

Solution: C:/oracle/product/10.2.0/db_1/network/admin/listener.ora to change the contents of this document host= your computer name.

About Oracle database problems and solutions are introduced here, I hope to be helpful to you.