Oracle plsqldev1106 安装及TNS配置

server/2024/12/16 8:27:04/

Oracle plsqldev1106 安装及TNS配置

下载好安装包，直接双击安装
在这里插入图片描述
点击 I Agree

在这里插入图片描述
默认是C盘的，我改了D盘，根据自己实际情况修改

这里用默认的for current user 也可以，我选了for all user

点Finish，等待安装完成即可

在这里插入图片描述
完成后，桌面就多了这个图标

准备好instantclient-basic-nt-11.2.0.4.0.zip包，解压之后是这样的：
在这里插入图片描述
新建D:\app\client_11\network\admin目录，从其他地方拷贝一个tnsnames.ora文件过来

tnsname.ora里面默认内容是这样的，没有从这里复制进去也行

# tnsnames.ora Network Configuration File.
# Generated by Oracle InstantClient tools.
# For more information, please visit: http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html# Sample:
#DatabaseName =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = ServiceName)
#      (INSTANCE_NAME = InstanceName)
#    )
#  )# Modify the following content to fit your own needs.
orcl155 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.38.155)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))cdb1@250 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.26.250)(PORT = 1539)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = cdb1)))upspy =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.45.157)(PORT = 1539)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora11g)))
FS_Test =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.32.146)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ora11g)))

打开plsql 客户端，首次打开，这里选Cancel
在这里插入图片描述

点击Tool, 选择第一个Preferences，把Oracle home ，和oci 库配置好，如下：

点击apply，再点OK即可
关闭软件，再次打开，这里就会出现我们tnsname.ora里面配置好的数据库

输入账号密码，登录，就可以操作数据库了
在这里插入图片描述