Solution to Oracle database configuration error information

Source: Internet
Author: User

Network Configuration of the Oracle client:

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 server to be connected has not started the listening process Listener. 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, when listener. ora is started using the service list, the following error message is displayed:

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: \ marshel \ 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, the HOST in the tnsnames. ora file, does 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.

(

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.