Common Oracle Database Problems and Solutions

Common Oracle Database Problems and Solutions

In the process of using Oracle databases, we often encounter one or another problems. These problems often confuse us. In this article, we have summarized some problems in the use of Oracle databases, the solution is provided. Next we will analyze these problems.

1. Stop the oracle listener immediately after it is started.

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

TNS-12560: TNS: protocol adapter error.

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

32-bit Windows Error: 1004: Unknown error.

No listening anymore: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = //./pipe/EXTPROC0ipc ))).

The reason is that I have modified the host name after installing oracle.

Solution:

1. directly modify listener. ora

Path: oracle installation directory/product/10.2.0/db_1/NETWORK/ADMIN/listener. ora.

Change HOST to HOST name or IP address.

2. Use Net Manager to directly modify the host in the LISTENER/LISTENER.

Ii. Error Codes and Solutions

1. ORA:-12545: the connection fails because the target host and object do not exist.

The error code ORA-12545 indicates that the machine name and IP address used in the network connection string (that is, at the HOST in the tnsnames. ora file) do not exist. remodify and reconnect.

2. ORA-12651: TNS: No listener.

This information indicates that the listening process Listener is not started on the server to be connected (this process is an operating system process on the Oracle server. When the listening process is not started, the server can proceed normally, however, the client cannot connect to the server. At this time, you can use the operating system command lsnrctl on the server to start the listening process normally ).

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

Cause:This error is usually an internal ORACLE error and is only useful for OSS and ORACLE development. ORA-600 errors are often accompanied by a State dump of the trace file (system and process state) where system state storage will include information about the current object held by oracle rdbms, the Process status dump displays the objects held by the special process. When the process meets an error condition, it is often because some information is taken from a block held by the process, if we know the blocks held by these error processes, it is easy to track the source of the problem.

Solution:In general, this error cannot be solved. We only need to improve the system itself to solve this internal problem, such as adding hardware devices and adjusting system performance, using OPS (of course, OPS is not a good solution in a sense. 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), from the second to the fifth variables display additional information, tell the OSS code where an error occurs

4. ORA-12560 protocol adapter error:

Problems with ORA-12560: TNS: protocol adapter errors

①. Check the Terminal Service to see if the Remote Desktop is the cause.

②. Environment variable set oracle_sid = required service name.

③. Is the name or IP address of the machine in listener. ora, tnsnames. ora, etc. correct.

④. Netstat-a checks whether the port is occupied.

⑤. Check the Registry HKEY_LOCAL_MACHINE/Software/Oracle/Home0 to add the string USE_SHARED_SOCKET = TRUE and restart the service.

5. ORA-28595: Invalid DLL Path calling external DLL Error

Cause: 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 will be 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 shoshould have the following option associated with it:

(ENVS = "EXTPROC_DLLS = ANY ")

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

(4). Restart the Oracle Listener Service (or reboot the server which will 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. When you start the service on the control panel, the following error occurs:

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

Error 3: The specified path cannot be found.

Check the properties and find that the executable file path of OracleOraDb10g_home1TNSListener service is empty.

Solution:

Start --> Run REGEDIT --> go to the Registry and find HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/OracleOraDb10g_home1TNSListener.

The key value of ImagePath is missing. Create a New expandable string value named ImagePath and edit the value data of the string as follows: Oracle installation path/BIN/TNSLSNR

7. Error Description: The OracleOraDb10g_home1TNSListener service on the Local Computer stops again after it is started. Some services are automatically stopped if they have nothing to do, such as the "performance log and alarm" service.

Solution:C:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener. ora change the content in this file to HOST = your computer name.

Here we will introduce the Oracle database problems and solutions, and hope to help you.