windows7远程连接oracle10g数据库

发布网友发布时间：2022-05-03 10:05

共2个回答

懂视网时间：2022-05-03 14:26

一、在windows安装Oracle客户端：

下载地址：https://www.oracle.com/database/technologies/112010-win64soft.html
** 选择第二项管理员安装**

问题1：版本错误
解决：
修改安装文件：clientstagecvu
编辑该目录下的两个xml文件：oracle.client_InstantClient.xml和cvu_prereq.xml
按规律添加以下内容：

<OPERATING_SYSTEM RELEASE="6.2">
 <VERSION VALUE="3"/>
 <ARCHITECTURE VALUE="64-bit"/>
 <NAME VALUE="Windows 10"/>
 <ENV_VAR_LIST>
 <ENV_VAR NAME="PATH" MAX_LENGTH="5119" />
 </ENV_VAR_LIST>
</OPERATING_SYSTEM>

二、安装PL/SQL Developer

下载地址：https://www.allroundautomations.com/try-it-free/

三、登录连接Orcle

问题一：没有监听
修改服务端Oracle的文件：
一定得备份！！！
解决办法简述：

1.修改/home/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora中的localhost改为192.168.8.13【服务器IP】；

2.修改/home/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/tnsnames.ora中的localhost改为192.168.8.13【服务器IP】；

3.修改后，重启oracle，监听，并注册，主win10上的plsql就可以远程连接虚拟机上的数据库了。

具体操作步骤如下：

1、修改数据库服务器中listener.ora文件内容
原始内容:

# listener.ora Network Configuration File:/home/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
 )
 )
ADR_BASE_LISTENER = /home/tools/oracle11g

修改后的内容如下：

# listener.ora Network Configuration File: /home/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (ORACLE_HOME = /home/tools/oracle11g/product/11.2.0/dbhome_1/)
  (SID_NAME = orcl)
 )
 )

LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.13)(PORT = 1521))
 )
 )

ADR_BASE_LISTENER = /home/tools/oracle11g

2、修改数据库服务器中tnsnames.ora文件内容
原始内容:

# tnsnames.ora Network Configuration File: /home/tools/oracle11g/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = orcl)
 )
 )

修改后的内容：

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.183.129)(PORT = 1521))

orcl =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.183.129)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = orcl)
 )
 )

添加服务器
管理员权限运行Net Mananger
按步骤添加：
技术图片
然后按内容添加：

修改windows客户端文件
使用管理员权限修改：
D:Oracle11g_Clientproduct11.2.0client_1 etworkadmin
修改内容为：【核对一下，一般不用修改】

# tnsnames.ora Network Configuration File: D:Oracle11g_Clientproduct11.2.0client_1NETWORKADMIN	nsnames.ora
# Generated by Oracle configuration tools.

ORCL =
 (DESCRIPTION =
 (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.183.129)(PORT = 1521))
 )
 (CONNECT_DATA =
 (SERVICE_NAME = orcl)
 )
 )

三、在数据库服务器中启动监听并更新注册

最后重启一下监听与数据库并更新注册

$ lsnrctl stop #先关闭监听服务
$ lsnrctl start #开启监听服务
$ sqlplus / as sysdba #登入
SQL> shutdown immediate #立即关闭数据库服务
SQL> startup #开启数据库服务
命令：SQL> alter system register; #注册
System altered.
SQL>
SQL> quit #登出
输出：
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

四、登录plsql

技术图片

windows连接远程Oracle数据库

标签：list sys 运行 admin reg protoc cti sof image

热心网友时间：2022-05-03 11:34

下面是oracle11g的内容，10g的参考：

服务器上：
1. 修改 SID_LIST_LISTENER 增加 SID
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\proct\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\proct\11.2.0\dbhome_1\bin\oraclr11.dll")
)
-- 下面是增加的，这段注释你要删掉
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\proct\11.2.0\dbhome_1)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\proct\11.2.0\dbhome_1\bin\oraclr11.dll")
)
------
)
2. 重启tns监听服务。

客户机上：
3. 修改tnsnames.ora，用sid进行连接(注意修改<servername or ip>）
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <servername or ip>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID= orcl)
)
)
4. 然后连接试试！

如果是64位机器：

使用PL/SQL Developer连接OracleX64版本：
•1. 下载32位Oracle InstantClient，并展开到某目录，例如C:\instantclient-basic-nt-11.2.0.2.0；
•2. 将系统的tnsnames.ora拷贝到该目录下；
•3. 在PLSQL Developer中设置Oracle_Home和OCI Library：
ToolsPreferencesOracleConnection：
Oracle_Home：C:\instantclient-basic-nt-11.2.0.2.0
OCI Library：C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
•4. 在PLSQL Developer目录下编辑如下bat文件，替换其快捷方式，启动PLSQL Developer：
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe