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)
)
)