Open WhyNotRunning opened 7 years ago
http://gang-chen.iteye.com/blog/1990610
1.instantclient-basic文件 http://www.oracle.com/technetwork/topics/winx64soft-089540.html 2.plsql developer 官方下载地址:http://download.allroundautomations.com/plsqldev1100.exe http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-ea-42-3211401.html(oracle官网) 注册码: Product Code:4t46t6vydkvsxekkvf3fjnpzy5wbuhphqz serial Number:601769 password:xs374ca
oracle官网提供了instantclient,下载instantclient-basic包,将包解压存放到本地,本测试为 D:\STUDY\instantclient_10_2;
在这个目录下新建sqlnet.ora和tnsnames.ora两个文件
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.146.143 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl ) ) ) 注:斜体部分需要按需配置,如果端口是自定义的也需要相应变更。
变量名 变量值 TNS_ADMIN D:\STUDY\instantclient_10_2
注:这里变量值即为instantclient在本地的主目录;如果不配置该变量, 连接时会报错ORA-12154: TNS:could not resolve the connect identifier specified。
如果出现乱码问题,请点击:http://gang-chen.iteye.com/blog/2005546
http://gang-chen.iteye.com/blog/1990610
准备文件
1.instantclient-basic文件 http://www.oracle.com/technetwork/topics/winx64soft-089540.html 2.plsql developer 官方下载地址:http://download.allroundautomations.com/plsqldev1100.exe http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-ea-42-3211401.html(oracle官网) 注册码: Product Code:4t46t6vydkvsxekkvf3fjnpzy5wbuhphqz serial Number:601769 password:xs374ca
操作步骤
oracle官网提供了instantclient,下载instantclient-basic包,将包解压存放到本地,本测试为 D:\STUDY\instantclient_10_2;
在这个目录下新建sqlnet.ora和tnsnames.ora两个文件
sqlnet.ora文件内容
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora文件内容
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.146.143 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
) ) 注:斜体部分需要按需配置,如果端口是自定义的也需要相应变更。
变量名 变量值 TNS_ADMIN D:\STUDY\instantclient_10_2
注:这里变量值即为instantclient在本地的主目录;如果不配置该变量, 连接时会报错ORA-12154: TNS:could not resolve the connect identifier specified。
如果出现乱码问题,请点击:http://gang-chen.iteye.com/blog/2005546