Solution to Oracle database configuration error information

 

Oracle Database Configuration Error Message

Errors in the oralce database often occur. We see all the wrong code. As to the cause of the error, it is still difficult to answer at half past one, so we sorted out some common errors, it may be helpful to you.

 

1. Oracle client Network Configuration:

L after the oralce product is installed, you must configure the network connection to connect to the database server or to replicate data between the two databases.

L Oracle9i net service configuration method:

The connection configuration of Oracle9i net service can use oracle_sid of the database instance or service_names of Oracle9i. Configure the connection between the Oracle9i client and the Oracle9i server. You can also edit the network configuration file tnsnames. ora of the Oracle9i net service client.

The storage directory of the tnsnames. ora file in windows and Unix:

Window NT/2000: D:/Oracle/ora90/Network/admin/tnsnames. ora

UNIX:/home/APP/Oracle/product/9.0.1/Network/admin/tnsnames. ora

If the tnsnames. ora file is incorrectly configured, the error information is recorded in the connection log information file. The error information is as follows:

The error strutct:

NR err code: 0

NS main err code: 12560

TNS-12560: TNS: protocol adapter Error

NS secondary err code: 0

NT main err code: 530

Tns-00530: protocol adapter Error

NT secondary err code: 2

Nt OS err code: 0

In the connection configuration of Oracle9i, the server needs to configure the listener process configuration file listener. ora. If the server listening process is not started, the following error message is displayed:

Error:

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. In this case, you can run the operating system command LSNRCTL on the server to start the listening process normally. The specific method is as follows:

C:> LSNRCTL start

Method for stopping a listener:

C:> LSNRCTL stop

After modifying the computer name, you need to modify the host in the listening process. Otherwise, the listening program will encounter the following error:

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

Error: 1001: unknow Error

In window nt/2000, the same error message is displayed when listener. Ora service is started using the service list.

(Dialog box) Abort unexpectedly

In this case, you can modify the host name in the next column of information in listener. ora:

(Address = (Protocol = TCP) (host = sun4500) (Port = 1521 ))

The name must be consistent with the actual one. Restart the listener. Note: In the listener. ora file, IP addresses are allowed for the host. Therefore, modifying the host name will not cause the listener to fail to start.

In addition, in the server and listener. the ora file contains a file named tnsnames in the unified directory. ora file, which is used for the connection Configuration between two servers, that is, the network configuration in the distributed environment of El is as follows:

Window NT/2000 D:/Systel/ora90/Network/admin/tnsnames. ora

UNIX:/home/APP/Oracle/product/9.0.1/Network/admin/tnsnames. ora

On the server, tnsnames. ora is configured with the server name by default. If the machine name is modified, the file must be modified at the same time; otherwise, the following error occurs:

Error:

Ora:-12545: connection failed 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.

Configure the wizard tool of Oracle9i net service:

Select this option to create, modify, delete, or rename a listener. A listener is a process on the server that receives and responds to client connection requests to the database. A client with the same Protocol address configured with a connection descriptor can send a connection request to the listener.

Oracle9i net manager:

You can define simple names to indicate the service location, such as a database. These simple names are mapped to connection descriptors. They contain the network ID and location of the service.

The error message ORA-12560 indicates that the defined instance is not found in the operating system, and in Oracle9i, if such an error occurs, there are generally two causes, first, the Instance name is incorrectly modified, and second, the Oracle service is not started properly.

Analysis and Solution 2 of common Oracle error codes

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 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.

An example of an error is as follows:

ORA-00600: Internal error code, arguments: [1237], [], [], [], [], [], [], []

The corresponding English is as follows:

Cause: This is a catchall internal error message for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition. varous causes of this message include:

Time-outs (timeout)

File Upload uption (the file is too old)

Failed data checks in memory (memory retrieval failed)

Hardware, memory, or I/O errors (hardware, memory, or disk error)

Incorrectly restored files (incorrect reconstruction file)

ORA-03113: End-of-file on communication channel

Cause: the communication ends abnormally, resulting in the termination of the communication channel.

Solution: 1> check whether the server process is abnormal or not. You can learn from alert. Log

2>. Check whether the SQL * Net driver is connected to the Oracle executable program.

3>. Check whether the server network is normal, for example, the network is disconnected or unstable.

4>. check whether there are two nodes with the same name on the same network.

5>. Check whether duplicate IP addresses exist on the same network.

The corresponding English is as follows:

Cause: an unexpected end-of-file was processed on the communication channel. the problem cocould not be handled by the net8, two task, software. this message cocould occur if the shadow two-task process associated with a net8 connect has terminated abnormally, or if there is a physical failure of the InterProcess Communication hicle, that is, the network or server machine went down.

Action: If this message occurs during a commection attempt, check the setup files for the appropriate net8 driver and confirm net8 software is correctly installed on the server. if the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. existence of a trace file may suggest an oracle internal error that requires the balance of customer support.
ORA-00942: Table or view does not exist

Cause: this is because the mounted table or view does not exist. Most of the reason is that catexp. SQL is not running and the export view cannot be executed. If catexp. SQL is already running, it may be a version error.

Solution: because some views shared by import and export run catexp. SQL to load (they have the same view) and do not generate a separate catexp. so that the view and export code is not synchronized, it is difficult to maintain compatibility between each other, the user must establish their own export application, so as to avoid ORA-00942 errors.

The corresponding English is as follows:

Cause: the table or view entered does not exist, a synonym that is jnot allowed here was used, or a view was referenced where a table is required. existing user tables and views can be listed by querying the data dictionary. certain privileges may required to access the table. if an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

Action: check each of the following:

The spelling of the table or view name.

That a view is not specified where a table is required

That an existing table or view name exists.

Contact the database administrator if the table needs to be created or if user or application priviledes are required to access the table.

Also, if attempting to access a table or view in another schema, make certain thecorrect schema is referenced and that access to the object is granted.

 

ORA-12560 protocol adapter error:

Problems with ORA-12560: TNS: protocol adapter errors

1. 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 or tnsnames. ora correct?
④. Check whether the port is occupied by netstat-
⑤. Check the Registry HKEY_LOCAL_MACHINE/software/Oracle/home0 to add the string use_shared_socket = true and restart the service.

 

Error:

ORA-01031: insufficient privileges

If you have insufficient permissions, modify the corresponding permissions. (T126)