Oracle TNSNAMES. Ora configuration

In the installation directory, such as: E:\Oracle\Ora81\network\ADMIN under the use of WordPad or Notepad to open the Tnsname.ora file, the contents of the file may be as follows:
TEST. softone.com =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = zcb_8115) (PORT = 1521))
)
(Connect_data =
(service_name = test)
)
)
The blue section is the information that is entered during installation.

If the file is not configured successfully, the file can be configured with the following steps:
1), open NET8 CONFIGURATION in the program menu ASSISTANT

2), select Net8 Configuration Assistant, open, enter the "Net8 Configuration Assistant: Welcome" window

2, select "Local Network Service Name settings", click "Next", pop-up the following form;

3, in the "Net8 Configuration Assistant: Network Service name Configuration" window select "Add", click "Next", pop-up the following form;

4 in the "Net8 Configuration Assistant: Network Service name configuration, database Version" window select "ORACLE 8I database or service", click "Next", pop-up the following form;

5 in the "Net8 Configuration Assistant: Network Service name configuration, service name" window input service name, this service name with the installation of the service name (SID) is the same, after entry, click "Next", pop-up the following form;

6, in "Net8 Configuration Assistant: Network Service name configuration, please select the Protocol" window select "TCP" at this time can only select "TCP", click "Next", pop-up the following form;

7 in the "Net8 Configuration Assistant: Network Service name configuration, TCP/IP Protocol" window enter the hostname (if the local database is connected, input the local computer name, if connected to the remote database, input the remote computer name), select the default " Please use the standard port number 1521 "(recommended not to modify), click" Next ", pop-up the following form;

8, in "Net8 Configuration Assistant: Network Service name configuration, test" window select "Yes, Test", click "Next", pop-up the following form;

9), when "Net8 Configuration Assistant: Network Service name configuration, Connecting" Window dialog box appears prompt "Is connecting ... test success" information, indicating that the test passed. At this point click "Next" to enter the "Net8 Configuration Assistant: Network Service name configuration, Network Service name" window;

10, in the "Net8 Configuration Assistant: Network Service name configuration, Network Service name" window input Network service name, service name is Oracle connection string, can be entered arbitrarily, such as: Test, click "Next", pop-up the following form;

11, in "Net8 Configuration Assistant: Network Service name configuration, whether need another network service name" window select "No", click "Next", Into the "Network Service name Configuration Complete" window;

12, in the "Network Service name Configuration Complete" window click "Next", pop-up the following form;

13, in the "Welcome" window click "Finish", exit the configuration process

TNSNAMES. After the Ora configuration is complete, configure BDE (BDE how to configure it) to test Oracle connections correctly through BDE, Plsql, SQL Explorer, and tnsping commands. The following is a tnsping to test for connections.

Input at a command prompt: Tnsping TEST. Softone.com

trackback:http://tb.blog.csdn.net/trackback.aspx?postid=1472731