How to connect PL/SQL tools to oralce database (zz)

1. Use the Oracle Net manager tool

1) Open Oracle Net Manager

2) Add "service name"

Step 1. net service name: enter any name

Step 2 Communication Protocol: If you connect to Oracle on a remote machine, select TCP/IP (Internet Protocol)

Step 3. Host Name: Enter the IP address and port number. The default value is 1521.

Step 4 Sid: generally the same name as the database

Step 5 Test

3) Start the PL/SQL connection

2. directly modify the configuration file:

1) Open Directory D: file tnsnames. ora in Oracle installation directory ora92networkadmin.

2) Add the followingCode:

Traffic_db = # net service name, which can be any

(Description =

(Address_list =

(Address = (Protocol = TCP) (host = 192.168.1.143) (Port = 1521) # host is the IP address of the connected database server, port is the terminal number of the connected database server, the default value is 1521.

)

(CONNECT_DATA =

(SID = carsys) # Database System ID, which is generally the same as the database name

)

)

3) Save the file. Start the PL/SQL tool to log on.