Oracle和PL/SQL环境变量配置

在Oracle配置方面折腾了好一阵,总结一下;

1) Oracle 的安装直接参考百度即可;

    Oracle 安装好之后,需要配置的环境变量:

    1. ORACLE_HOME  -->  D:\app\Oracle\product\11.2.0\dbhome_1

    2. TNS_ADMIN  -->  D:\app\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

    3. Path 中添加 : D:\app\Oracle\product\11.2.0\dbhome_1\bin

    4. NLS_LANG  -->  SIMPLIFIED CHINESE_CHINA.ZHS16GBK

2) PL/SQL 下载完之后,在不登录的情况下进行如下配置;

    

3) instantclient_11_2 中创建tnsnames.ora文件,编辑内容如下:

# tnsnames.ora Network Configuration File: D:\app\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )