How to connect plsql to oracle

plsql 2 ways to connect to oracle database

Method 1: Configure tnsnames.ora

The file is in the instantclient folder, I directly Instantclient is copied to the root directory of plsql

The path of tnsnames.ora is under network > admin in the instantclient folder

Find it and modify it

#该文件用于配置数据库连接地址，配置好后，访问该数据库不再需要通过ip:port/instance，可以直接通过别名来访问该数据库
#数据库访问地址别名（随便起）
database-test=
(DESCRIPTION =
    (ADDRESS_LIST =
#通讯协议，主机，端口
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
数据库实例名称
      (SERVICE_NAME = orcl)
    )
)

Open plsql, The database appears

Method 2: Log in through ip/instance name

The above is the detailed content of How to connect plsql to oracle. For more information, please follow other related articles on the PHP Chinese website!