plsql连接oracle问题

在plsql目录下新建

plsql.bat 文件   //  启动文件--通过这个文件来启动 plsql

文件内容为：

@echo off

set path=C:\Usersl\oracle10g             
set ORACLE_HOME=C:\Users\oracle10g
set TNS_ADMIN=C:\Users\oracle10g

set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK           
start plsqldev.exe

再在oracel目录下的tnsnames.ora文件中加入连接地址

文件内容为：

# TNSNAMES.ORA Network Configuration File:C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

pnnict02, pnnict02.pw.ge.com =
  (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = PDMALQ04-scan.pw.ge.com)(PORT = 1521))
  (LOAD_BALANCE = yes) (FAILOVER = yes)
  (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pnnict02)
  (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 60) (DELAY = 1))))

这样就可以在plsql的连接列表中找到 pnnict02.pw.ge.com这个了