Oracle 环境搭建

数据库下载：Oracle官网

数据库软件：PLsql

表结构查看软件：PowerDesigner

Oracle 软件安装完成后 安装PLsql 将 C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN 下tnsnames.ora文件 修改

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = weiguoyuanG)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
-----------------------------------------------------将此处修改
 IOMTEST = 
   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 133.24.22.8098787767)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = zhoracle)
    )
      )


EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

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

PLsql中设置

将Oracle的路径配置在PLsql中 以免报字符串解析错误

链接PLsql