windows PLSQL 连接 linux oracle 10g

　　上面我们的Oracle已经可以正常用了，但是我的windows　XP 上也装有Oracle 10g,并且装有PL/SQL Developer ，想在Windows下访问Linux的Oracle 10g,可以用PL/SQL Developer连接！

1、sql>lsnrctl start

返回结果显示已经启动。

$cat /usr/oracle/10g/Network/admin/listener.ora

# listener.ora Network Configuration File: /usr/oracle/10g/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/oracle/10g)
      (PROGRAM = extproc)
    )
 

LISTENER
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )
得知监听端口在1521上，这台linux的IP是10.2.0.4

在windows下cmd->telnet 10.2.0.4 1521成功，说明监听正常！

在windows下cmd->tnsping 10.2.0.4 显示结果：

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 01-1月 -
2011 18:32:06

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:
D:/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.2.0.4))(ADDRES
S=(PROTOCOL=TCP)(HOST=10.2.0.4)(PORT=1521)))
OK (110 毫秒)

 

/****由此我们可以得出/usr/local/10g/network/admin/listener.ora是对监听的配置文件***

  *在windows 中是oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora*****/

修改linux下的配置:

listener.ora
# listener.ora Network Configuration File:/usr/local/10g/Network/admin/

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME =/usr/local/10g)
      (PROGRAM = extproc)
    )
     (SID_DESC =  //加的
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /usr/local/10g)
      (SID_NAME = orcl)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )

重启Oracle

sql>shutdown immediate

sql>sqlplus /nolog

sql>startup
然后在Windows下,打开Oracle Net Configuration Assistant工具，选择[本地Net服务名配置]－〉[添加]，填写完成后，打开工具Oracle Net Manager ,服务命名中找到你填写的，

[]服务标识]是指linux下的oracle的服务名orcl,即listener.ora中的GLOBAL_DBNAME 值orcl，

[地址配置]－〉[地址１]中　协议TCP/IP 主机名 10.2.0.4 端口号 1521

可以测试连接，用scott用户测试，连接正常！可以在windows下用PL/SQL Developer进行连接了！