[Oracle]服务器端64位Oracle安装两个数据库配置及远程访问

1. 服务器端主机A环境：

　　Windows Server 2008 64bit

　　Oracle 11gR2(11.2.0.1.0) 64bit服务器版。

　　IP：192.168.1.2

——Database Configuration Assistant数据库助手创建两个数据库。

——配置监听方案1：通过Net manager配置。一个监听程序，监听（本机的2个端口1521和1522，2个数据库Orcl和Demo），配置2个服务Orcl和Demo。

具体参考：http://wenku.baidu.com/view/e5e469233169a4517723a3c1.html

方案1生成的listener.ora文件：

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Orcl)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = Orcl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Demo)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = Demo)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    )
  )

ADR_BASE_LISTENER = D:\app\Administrator

——配置监听方案2，通过Net manager配置。一个监听程序，监听（1个端口1521，2个数据库Orcl和Demo），配置2个服务Orcl和Demo。

方案2生成的listener.ora文件：

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Orcl)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = Orcl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Demo)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = Demo)
    )
  )

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

ADR_BASE_LISTENER = D:\app\Administrator

方案2服务配置文件tnsnames.ora：

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

Orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Orcl)
    )
  )

Demo =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Demo)
    )
  )

LISTENER_Orcl =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER_Demo =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

服务器端测试连接成功。

2. 客户端PC机B环境：

　　Win7 64bit

　　Oracle 11gR2(11.2.0.1.0) 64bit服务器版（当作客户端来用）

　　PL/Sql Developer 9.0，PC端设置保证了PL/Sql Developer可访问。Net Manager默认的路径一般为E:\app\yang-PC\product\11.2.0\dbhome_1\NETWORK\ADMIN,此时的TNS_ADMIN环境变量已经改变，再通过Net Manager配置服务。

　　http://www.cnblogs.com/donetbaoxj320/archive/2011/11/24/2262412.html

　　http://www.cnblogs.com/yhlx125/archive/2013/04/19/3030189.html　　

——Net Manager配置服务，新建服务Server，主机名192.168.1.2，端口1521，服务名Orcl，测试连接。

——老是报“连接超时”错误：吐血，服务器端防火墙没有关闭。关闭防火墙后，连接测试成功。保存配置。

——PL/Sql Developer 可以访问服务器数据库。

3.配置监听和服务的相关知识：

　　监听程序和数据库配套，运行在服务器上。