《windows环境下配置连接oracle数据库的方法及步骤.docx》由会员分享，可在线阅读，更多相关《windows环境下配置连接oracle数据库的方法及步骤.docx（7页珍藏版）》请在三一办公上搜索。
1、配置oracle连接怎么在windows环境下配置连接oracle数据库？步骤如下：一、安装 PL/SQL：1、获取PL/SQL安装包；（PL/SQL是连接oracle的客户端）2、安装 PL/SQL；（1）双击PL/SQL安装程序，安装PL/SQL；WinZip Selif-Extractar - plsqFdev80S.exeExtracting files to temporary directory and executing setup program.CancelUnzipping Setup .ace（2）选择“I Agree”进行安装;LICENSE AGREEMENT （LA
2、） FOR ALLROUND AUTOMATIONS SOFTWARE PRODUCTSImportant: Read carefully - by installing, copying or otherwise using this Allround Automations software product you agree to be bound by the terms and conditions of this LA. If you do not agree to these terms and conditions, do not install copy or use thi
3、s software product.GeneralThe right to use the product underthe terms of this LA is granted only when:1. In case the software product was ordered by company Purchase Order, the appropriate invoice sent afterwards was paid within 30 days after invoice date.2. In case the software product was ordered
4、on-line and paid by credit card, no charge-back of the withdrawn amount is initiated.Rights and LimitationsYou may only reproduce, install and use the software product for use with only one developer. If you have multiple validly licensed copies of the software product you may reproduce, install and
5、 use the software product for use with a corresponding number of developers.Allround Automations retains all right title and interest in and to the software product. All rights not expressly granted are resen/ed by Allround Automations.If you have an unlimited user license for any Allround Automatio
6、ns software product you are entitled to use the software product with an unlimited user of developers only within the legal entity of the License holder.nic：trihi itinnI Agree I Dont Agree(3)选择安装路径(一般选择默认路径)；点击【Next】按钮;Select destination directorySelect the directory where you want to install the fi
7、lesC:Program FilesPLSQL DeveloperFree space on this system:C:16717MBD:35733 MBE:6566 MBF:36125 MB(4)默认选择，点击【Next】按钮;Shortcuts园 Create PL/SQL Developer shortcutsa for current userfor all usersPLSQL DeveloperE Create shortcut on Desktop旦 sickNext (5)默认选择，点击【Finish】按钮，开始安装;CancelCancelInstall options0
8、Template filesH Keyword filesCancel(6)安装进度显示Press the Finish button to start the installation.旦 ackFinish(7)窗口提示 “PL/SQL Developer installed successfully”，安装完成，点击【Close】按钮。Preparing install.Copying files.Creating desktop shortcutCreating menu shortcutsApplication registered successfully.ClosePL/SQL
9、Developer installed successfully.二、配置连接1、获取oci.dll文件（该文件是用来连接数据库的文件），将该文件及其所在的文件夹放置 在一个不含有中文的路径下（如：F:instantclient）;2、双击打开PL/SQL客户端，点击【Cancel】按钮；Oracle Logon3、跳转到PL/SQL页面，如下图所示。选择【Tool Preferences;PL/SQL Developer - (Not logged on)4、按下图进行选择，在“Oracle Home (enpty is autodetect)”栏中选择oci.dll文件所在的目 录；在“O
10、CI library(enpty is autodetect)”栏中选择 oci.dll 文件湿 PreferencesOracleQConnectionOptionsCompilerDebuggerOutputTraceProfilerLogon HistoryHintsUser Interface 工IOptions T oolbarObject Browser EditorFontsPL/SQL Beautifier Code Assistant Key Configuration Appearance NLS 0 ptionsWindow Types 二IProgram Window
11、SQLWindowT-DefaultJerry 11二|HelpKCancelApply5、点击【OK】按钮即可完成6、退出PL/SQL页面，重新登录。双击PL/SQL客户端，在Oracle Logon窗口中 填写数据库的用户名、密码、数据库名和连接方式；点击【OK】按钮即可查询数据库。完毕！谢谢!附：配置环境变量(1) Path :访问配置文件的路径。如：配置文件存放目录为：D:PL SQLinstantclient;Path: D:PL SQLinstantclient;的存(2) TNS_ADMIN :配置连接文件“ tnsnames.ora” 和监听文件“ listener.ora放路
12、径。若文件放置路径为D:PL SQLinstantclient0贝0：变量名：TNS_ADMIN；变量值：D:PL SQLinstantclient;(3) 配置数据库实例用记事本方式打开tnsnames.ora文件，配置实例名和连接，如：SDSF05 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.0.5)(PORT = 1521)(CONNECT_DATA =(SERVER = dedicated)(SERVICE_NAME = SDSF)ElOracle口令j数据库SDSF旧实例名连接为Normal年用户名 sddba(4)命令窗口查询是否已连接成功:sqlplus username/pwdip /databasenameIaE
