Shulou(Shulou.com)06/01 Report--

1. Download address for oracle_client installation (brief):

12g: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.html

11g: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

After installing oracle_client, enter the installation directory: d:\ app\ administrator\ product\ 11.2.0\ client_1\ network\ admin

There is no tnsnames.orawe file in this directory. Create it manually or copy the tnsnames.ora in sample for editing, and add the following:

Custom naming =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST =) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = "customized naming consistent")

)

)

Edit the sqlnet.ora file in the same directory and add the following:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

II. PL/SQL installation (brief)

PL/SQL Settin

Open PL/SQL and click "cancel" on the login screen.

In preferences connections, add the client directory address. Click the drop-down menu to add, do not enter manually.

When the configuration is complete, close and reopen for connection testing.

There are two ways for PL/SQL to connect to oracle, the other is to use instantclient as a client, which requires configuring environment variables and creating a network/admin directory in the instantclient directory, and the other is the same as above. Please read the previous article.

III. Remote backup

If you use the instantclient method to connect the oracle,PL/SQL, you can connect normally, but this method cannot normally use the exp command to back up the data, because instantclient is a castrated version of dos. There is no exp command, and the prompt is not an internal command. So I can't back up the data.

You can use oracle_client to back up data remotely.

Backup scripts and scheduled tasks are not introduced here.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.