1. Using Oracle Net Manager Tools
1) Open Oracle Net Manager
2) Add "service naming"
First step NET service name: arbitrary
Second Step Communication Protocol: If you connect Oracle on the remote machine, select TCP / IP (Internet Protocol)
The third step host name: Enter the IP address port number: generally default 1521
The fourth step SID: the same as the database name
Fifth step test
3) Start the PL / SQL connection
2, modify the configuration file directly:
1) Open the directory D: / Oracle installation directory / ORA92 / NETWORK / Admin to file TNSNames.ora.
2) Increase the following code:
Traffic_db = #NET service name, can be arbitrary
(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 of the database server, generally default 1521
)
(Connect_data =
(SID = CARSYS) # Database system identity, general and database the same name
)
)
3) Save the file. Start the PL / SQL tool to log in.
