oracle 连接

 

1.oracle 信息:

 

database:  qaprod

username:  michaelprod

password:  123456

 

 

database:  qaods

username:  michaelods

password:  123456

server:    119.119.117.73

 

2. 到oracle 客户端的 E:\oracle\product\10.2.0\client_1\NETWORK\ADMIN 目录下，

 

修改文件 tnsnames.ora

 

在其中加入相关链接信息：

 

QAPROD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 119.119.117.73)(PORT = 1521))

)

(CONNECT_DATA =

(SID = qaprod)

(SERVER = DEDICATED)

)

)

 

QAODS =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 119.119.117.73)(PORT = 1521))

)

(CONNECT_DATA =

(SID = qaods)

(SERVER = DEDICATED)

)

)

3.用PLSQL Developer连接即可使用。