About Oracle 11gR2 Configuration

I have been working with Oracle for the past two days, and various problems have been resolved... Mainly for various Oracle connection problems

1. PL/SQL connection to Oracle

After Oracle11gR2 is installed, you do not need to install the Oracle client. You only need the green version of instantclient, that is, you can use PL/SQL to directly connect to Oracle.

The settings are as follows:

0) download instantclient_11_2 (official: http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html)

1) Open PL/SQL, skip the logon interface, Click Tools-> Preferences, and configure the items in the red box (assuming instantclient_11_2 is placed under the root directory of drive D ):

2) re-open PL/SQL and fill in the information on the logon page.

In the database column, enter the name of the database instance to be connected after "/".

3) Click OK to connect

 

2. Configure Oracle remote connection

The remote connection has not been configured successfully. Later, I found a solution to solve the problem. It is not necessarily applicable in most cases.

1) Open the Net Manager tool in the Oracle configuration and porting tool and add an address to Listener.

Enter your IP address for the host, and the port number must not conflict with other addresses.

2) restart the listening service after the configuration is complete.

Lsnrctl stop

Lsnrctl start

3) The connection is successful with PL/SQL on a remote machine.

The IP address in the database column must be the IP address of the remote host, that is, the address added in Listener in step 1.

In step 2, you can also directly modify the Listener. ora file in the PATH % ORACLE_HOME % \ NETWORK \ ADMIN \ listener. ora.

Add the following information to Listener:

Restart the listening service...

After Oracle 10g is installed, restart the system. If PLSQL is used for connection, no listening is reported.

ORA-03114 PLSQL process compilation disconnection Error

Simple configuration of PLSQL connection to Oracle

Detailed description on Performance Improvement of PLSQL batch Forall operations

Use Oracle SQLDeveloper to connect to the database and create a user

Oracle PL/SQL Developer import and export data

Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7