由 dawei
1、客户机安装plsql
2、下载oracle32位客户端，将下载的文件解压后在里面新建\NETWORK\ADMIN\tnsnames.ora，输入连接信息
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.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数据库