Oracle turns on remote connection access

Method/Step

1. First, you should make sure that you have a server that has Oracle installed. And this server is on the same network as the computer that is connecting it (in general, in a local area network, if the server is in the public network, there is no problem).

2. Set the connection mode for Oracel to "shared server Mode".

   The step is: first "as Administrator" to open the database configuration Assistant.

   Such as:

3. Enter the configuration interface. Such as. Configure database options, delete database may not be available when you open with a non-administrator role (gray). If the option is unavailable, run with administrator.

   Select Configure database Options.

4. Select the DB instance. Such as:

5. 5

   Select the connection mode for Shared server mode.

6. 6

   After configuration, restart the Oracle service. Open the database link client (such as PL/SQL) on the client to enter the connection string and find that it is already able to connect.

Oracle turn on remote connection access