Oracle problems-Cause Analysis of remote logon Failure and oracle failure

Oracle problems-Cause Analysis of remote logon Failure and oracle failure

Remote machine:

Install the Oracle computer;

Local Machine:

The computer that accesses the Oracle database on the remote machine.

I. Problem Description

Install the Oracle database on a remote computer.

On the local machine, After configuring InstantClient,

Use PLSql Developer to remotely log on to the Oracle database and report an Oracle error.

Ii. Solution

Analyzes the cause, such as ORA-1455, based on the Oracle error code.

Iii. Cause Analysis

It is often caused by remote or local computer configuration errors.

Iv. Solutions

(1) Ensure that the Oracle database on the remote computer can be accessed using PLSql.

If the database cannot be accessed, reconfigure the Oracle database on the remote computer;

(2) After the Oracle database is installed, the database connection configuration is for the machine where the database is located.

Therefore, you cannot log on to the Oracle database on another machine on another computer.

In this case, you need to change the configuration file on the remote computer (the computer where Oracle is installed;

(3) Modify two files: listener. ora and tnsnames. ora.

It can be retrieved from the Oracle installation directory.

-- All SID_NAME and SID values,

Changed to the value of SERVICE_NAME in tnsnames. ora of InstantClient;

-- Change the value of all hosts to the IP address of the computer where the Oracle database is located;

(4) restart the Oracle database on the remote machine,

Start PLSql Developer on the local machine,

You can successfully log on to the Oracle database on the remote machine.

Environment:

-- Remote machine environment:

 
Win7 SP1

 
Oracle 11g

-- Local machine environment:

 
Win7 SP1

 
PLSql Developer 8.0.4.1514 

 
 InstantClient 11.2