Oracle problem--The reason analysis of remote login failure

Remote machine:

Installing Oracle's computer;

Local machine:

A computer that accesses an Oracle database on a remote machine.

First, the problem description

Install the Oracle database on the remote computer.

On the local machine, after configuring Instantclient,

Log in to the Oracle database using PLSQL Developer to report Oracle errors.

Second, the solution of ideas

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

Third, the reason analysis

This is often a remote or local computer Configuration error.

Iv. Solutions

(1) First, make sure that you can access the Oracle database on the remote machine using PLSQL on the remote computer.

If you cannot access it, reconfigure the Oracle database on the remote computer;

(2), after installing the Oracle database, the connection configuration of the database is for the machine where the database resides.

Therefore, on other computers, you cannot log on to an Oracle database on another machine.

You need to change the configuration file on the remote computer (the computer on which the Oracle is installed);

(3), modify two files: Listener.ora and Tnsnames.ora

Can be retrieved from the Oracle installation directory.

--all the values of Sid_name, SID,

Change to the same value as service_name in Tnsnames.ora in instantclient;

--all host values are changed to the IP address of the computer where the Oracle database resides;

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

Start Plsql Developer on your local machine,

To 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

Oracle problem--The reason analysis of remote login failure