2023.10.02 win7x64sp1下Navicat_Premium15_x86连接Oracle_10g(安装在win2003x86)

Oracle_10g安装在这个版本的系统里:

Microsoft Windows [版本 5.2.3790]

这个win2003_x86(分配内存1G)安装在vmware虚拟机里.

安装包文件名为:oracle 10g_win32.zip  大小约624 MB (655,025,354 字节)

安装完毕后,tcp1521端口应该开放:

Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
 
C:\Documents and Settings\Administrator>netstat -ano|findstr 1521
  TCP    192.168.50.145:1071    192.168.50.145:1521    ESTABLISHED     1824
  TCP    192.168.50.145:1073    192.168.50.145:1521    ESTABLISHED     3632
  TCP    192.168.50.145:1074    192.168.50.145:1521    ESTABLISHED     3632
  TCP    192.168.50.145:1075    192.168.50.145:1521    ESTABLISHED     3632
  TCP    192.168.50.145:1082    192.168.50.145:1521    ESTABLISHED     2144
  TCP    192.168.50.145:1521    0.0.0.0:0              LISTENING       1848
  TCP    192.168.50.145:1521    192.168.50.136:50110   ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.136:50111   ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.145:1071    ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.145:1073    ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.145:1074    ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.145:1075    ESTABLISHED     1848
  TCP    192.168.50.145:1521    192.168.50.145:1082    ESTABLISHED     1848
  TCP    192.168.50.145:2482    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2485    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2486    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2490    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2491    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2492    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2493    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2494    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2497    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2499    192.168.50.145:1521    TIME_WAIT       0
  TCP    192.168.50.145:2503    192.168.50.145:1521    TIME_WAIT       0
 
C:\Documents and Settings\Administrator>

接下来在虚拟机win7x64_sp1(分配内存2G)里安装Navicat_Premium15_x86,不能安装x64版,因为oracle的驱动程序(dll)是x86的.我使用的是PE_Study.exe(

PE_Study(PE查看器) v0.95 免费绿色版下载 - 比克尔下载http://www.bkill.com/download/18602.htmlhttp://11.bkillptdown.balanala.cn:8066/1208/PE_Study.zip)进行查看,发现oci.dll是x86的.

oci.dll我用的是从如下网址下的:

Instant Client for Windows 32-bithttp://www.oracle.com/technetwork/topics/winsoft-085727.html

Instant Client for Windows 32-bithttps://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.htmlinstantclient-basic-nt-12.2.0.1.0.zip  

68.5 MB (71,881,824 字节)

接下来还是在虚拟机win7x64_sp1,安装Navicat_Premium15_x86完毕后,我不需要注册(pojie),就用试用版(可以试一试虚拟机快照),

解压:instantclient-basic-nt-12.2.0.1.0.zip 到C:\Program Files (x86)\PremiumSoft\Navicat Premium 15目录下:

"C:\Program Files (x86)\PremiumSoft\Navicat Premium 15\instantclient_12_2\oci.dll"

如果之前有instantclient_12_2这个文件夹,建议给这个旧文件夹改名,以免冲突.

解压instantclient-basic-nt-12.2.0.1.0.zip 完毕后,还需要安装vcredist2013_x86.exe,

最后一步打开Navicat Premium 15,找到工具,选项,环境,OCI环境,指定dll:

"C:\Program Files (x86)\PremiumSoft\Navicat Premium 15\instantclient_12_2\oci.dll"

全程不用设置win7x64和win2003上的环境变量

如下这篇文章无参考价值:Navicat_Premium连接Oracle_10g-CSDN博客首先需要下载instantclient_11_2这个是我在CSDN下载的版本是可以用的，解压下来就可以用了。Navicat_Premium版本是10.0.11是可以使用的。打开工具->选项->OCI 1.选择解压后文件中的 oci.dll 2.选择oracle安装路径下的sqlplus.exe下一步配置环境变量1.右键https://blog.csdn.net/qq_20745827/article/details/49252975

参考资料:

https://www.cnblogs.com/ihappycat/p/14121046.htmlhttps://www.cnblogs.com/ihappycat/p/14121046.htmlNavicatPremium连接oracle10g_navicat oracle驱动-CSDN博客最近做一个项目需要从老系统抽取数据，因为平时用到的数据库连接工具是Navicat Premium，所以就尝试着用Navicat Premium连接oracle，具体操作步骤入下1.下载oracle10.2客户端（instantclient_10_2）放入本地文件夹（在oracle官网下载）2.打开Navicat Premium点击，工具—>选项—>环境，配置oracle驱动3.关闭Navicat Premium， 重新打开Navicat Premium，点击 文件.._navicat oracle驱动https://blog.csdn.net/qq_35744706/article/details/124094763

Navicat Premium 15连接不上Oracle 10g解决-CSDN博客①下载网盘分享的文件链接：https://pan.baidu.com/s/1ZOSKwGjS9QpV8404LCj9MQ提取码：g6le②下载好解压文件，并复制到Navicat Premium 15的安装路径下③打开 Navicat Premium 15的 工具—选项—环境—oci环境，把刚才复制到Navicat Premium 15安装路径下的文件的oci.dll导入④重启Navicat Premium 15，然后试着连接oracle 10g,此时成功连接...https://blog.csdn.net/qq_44760706/article/details/112755377

 x64的驱动下载页面,如下:

Oracle Instant Client Downloads | Oracle 中国https://www.oracle.com/cn/database/technologies/instant-client/downloads.html

Instant Client for Microsoft Windows (x64) 64-bit | Oracle 中国https://www.oracle.com/cn/database/technologies/instant-client/winx64-64-downloads.html 

instantclient-basic-windows.x64-12.2.0.1.0.zip

https://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-windows.x64-12.2.0.1.0.zip?AuthParam=1696257878_6341fdba2ddd355c8fef6590863e03da