Oracle SQL Developer+InstantClient客户端连接工具
Oracle SQL Developer+InstantClient客户端连接工具
工具下载
Oracle SQL Developer
SQL Developer 23.1.1 Download
https://www.oracle.com/database/sqldeveloper/technologies/download/
Oracle Instant Client
Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
连接配置
tnsnames.ora
打开 Oracle Instant Client 目录,在network目录下建立admin子目录,创建 tnsnames.ora 连接配置文件
XML 全选
# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.
# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that
# the listener(s) is(are) listening for a database or
# several databases.
# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.
CSFrameworkV6_Normal =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CSFrameworkV6_Normal)
)
)
CSFrameworkV6_System =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CSFrameworkV6_System)
)
)
AutoUpgraderV2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = AutoUpgraderV2)
)
)
CSFramework_WebAPI_V3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CSFramework_WebAPI_V3)
)
)
CSFramework_WebAPI_V3_Log =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CSFramework_WebAPI_V3_Log)
)
)
系统环境变量(参数配置)
我的电脑,右键,
新建两个系统环境变量,具体内容如下
变量名:NLS_LANG
变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
变量名:TNS_ADMIN
变量值:E:\Setup\Oracle\instantclient-basic-windows.x64-23.5.0.24.07\instantclient_23_5\network\admin
Oracle SQL Developer 连接
Oracle连接配置成功
版权声明:本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网