oracle连接字符串配置

oracle\ora92\network\admin目录下 打开tnsnames.ora

XXX（连接字符串名字） =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = XXX（连接主机）)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = XXX（服务名）)     )   )

保存后。。。运行CMD

1.tnsping XXX(连接字符串名字)

2.sqlplus XXX（用户名）@XXX（连接字符串名字）

OK