Always use SQL Develope connection database, as long as the write on IP, user name, password, sid and so on can connect, and later found that using PL/SQL connection to the remote Oracle database How to connect ah?
Here's how to modify the Oracle configuration file:
Configuration file path is D:\app\huyueyang\product\11.1.0\db_1\NETWORK\ADMIN
Modify the following tnsnames.ora, this is the configuration file you configure the connection, the installation time will typically have a default ORCL instance
Such as:
- Orcl=
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
- (Connect_data =
- (SERVER = dedicated)
- (service_name = ORCL)
- )
- )
We are connecting to a remote Oracle server today: We add the following configuration under the default configuration
- oracleback=
- ( description =
- (address = (PROTOCOL  = TCP) (host = 10.2.4.121) (Port = 1521 ))
- (connect_data =
- (server = dedicated)
- (SERVICE_NAME = ORCL)
- )
- )
- Host,port, Service_Name is the basic information for connecting to a database Service_Name is the SID of your remote database service, and the oracleback here is your own random. The
- is finally connected using PL/SQL
-
- Here we use the new configuration Oracleback This configuration, the user name and password can be connected.