Oracle Database Configuration Error message

oracle| Error | data | Database Oracle database configuration error message

Oralce database error messages often appear, we see the wrong code, as to what the wrong reason is still 1:30 will be difficult to answer, so put some common mistakes sorted out, to see what may be helpful to you.

1. Oracle Client Network configuration:

After the Oralce product is installed, you must have a network connection configuration in order to connect to the database server or to replicate data between the two databases.

Oracle9i Net Service Configuration method:

The connection configuration for the Oracle9i Net service can be oracle_sid using a database instance or a parameter service_names using Oracle9i. Configure the connection between the Oracle9i client and the Oracle9i server, and also generate the Oracle9i Net Service client network profile Tnsnames.ora, or edit the file.

Storage directory for Tnsnames.ora files under 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 message is recorded in the connection log information file, and the error message reads:

The error STRUTCT:

Nr Err code:0

Ns Main Err code:12560

TNS-12560:TNS: Protocol Adapter error occurred

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 configuring the Oracle9i connection configuration, its server side needs to configure the listener process configuration file Listener.ora, and if the server-side listener process does not start, the following error message appears:

ERROR:

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 using the operating system command lsnrctl on the server, as follows:

C:>lsnrctl start

Stop the Listener method:

C:>lsnrctl stop

After you modify the computer name, you need to modify the host in the listening process, or the listener will receive the following error:

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

Error:1001:unknow Error

The same error message appears in Window nt/2000 when you start the Listener.ora service with a list of services

(dialog box) to abort unexpectedly

At this point, you can modify the host name at host in the next column of information in Listener.ora:

(Address= (PROTOCOL=TCP) (host=sun4500) (port=1521))

The name must be in accordance with the actual, restart the listener. Attached: In the Listener.ora file, the host allows the use of an IP address, so that after modifying the machine name, the listener fails to start.

In addition, there is a file in the server and Listener.ora file consolidated directory: Tnsnames.ora file, which is used for the connection configuration between the two servers, that is, the network configuration in the Oracel distributed environment The directory of the file is as follows:

Window nt/2000 D:\oracel\ora90\network\admin\tnsnames.ora

UNIX:/home/app/oracle/product/9.0.1/network/admin/tnsnames.ora

In the server, Tnsnames.ora is configured by default using the server name, so if you modify the machine name, the file needs to be modified as well, or the following error occurs:

Error:

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.

The wizard tool for the Oracle9i Net service is configured:

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

oracle9i Net Manager:

You can define a simple name to represent the location of the service, such as a database, which maps to a connection descriptor. They contain the network identification and location of the service.

Error message ORA-12560 that the defined instance cannot be found in the operating system, and in oracle9i, if such an error occurs, there are generally two reasons for the error, one is the incorrect modification of the instance name, and the other is that the Oracle service does not start properly.

[1] [2] Next page