plsql远程连接oracle数据库

1、客户机安装plsql

2、下载oracle32位客户端，将下载的文件解压后在里面新建NETWORKADMINtnsnames.ora，输入连接信息

# tnsnames.ora Network Configuration File: C:appAdministratorproduct11.2.0dbhome_1networkadmintnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

SKDAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.128)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orac)
)
)

201.128为远程数据库地址

3、在远程服务器上安装oracle数据库，dbca建库完成后新建用户
#sqlplus /nolog

SQL> conn / as sysdba;

SQL>create user username identified by password

SQL> grant dba to username;

SQL> conn username/password

SQL> select * from user_sys_privs;

4、用plsql远程连接oracle数据库

（编辑：鄂州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!