Oracle-监听文件示例

Oracle-监听文件示例

条件允许下尽量使用netmgr（net manager）创建，防止出现格式或书写等类似低级错误。

#打开Xmanager - Passive（Windows）
#export结尾IP为操作机Windows IP
export DISPLAY=192.168.14.57:0.0

listener.ora

vim listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11G_R2/db/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11G_R2/db)
      (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.52)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle

#GLOBAL_DBNAME一般为service name
#HOST写主机名
#ADR_BASE_LISTENER一般为ORACLE_BASE

tnsnames.ora

vim tnsnames.ora

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

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

# tnsnames.ora Network Configuration File: /opt/oracle/product/11gR2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

FMPDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.217)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = fmpdb)
    )
  )

DSPDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.217)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = fmpdb)
    )
  )

 

ORCL_15.226 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.226)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
#racdb1 =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.207)(PORT = 1521))
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.208)(PORT = 1521))
#      (LOAD_BALANCE = NO)
#      (FAILOVER = on)
#    )
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = racdb)
#      (FAILOVER_MODE =
#                  (TYPE = select)
#                  (METHOD = basic)
#                  (RETRIES = 180)
#                  (DELAY = 5)
#                )
#
#    )
#  )

racdb1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (address = (protocol = tcp)(host = 192.168.15.207)(port = 1521))
      (address = (protocol = tcp)(host = 192.168.15.208)(port = 1521))
      (LOAD_BALANCE = NO)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = racdb)
#      (INSTANCE_NAME = racdb1)
      (failover_mode =
        (backup = racdb2)
        (type = select)
        (method = preconnect)
      )
    )
  )

racdb2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (address = (protocol = tcp)(host = 192.168.15.208)(port = 1521))
      (address = (protocol = tcp)(host = 192.168.15.207)(port = 1521))
      (LOAD_BALANCE = NO)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = racdb )
#      (INSTANCE_NAME = racdb2)
      (failover_mode =
        (backup = racdb1)
        (type = select)
        (method = preconnect)
      )
    )
 ) 
 
 
 
 
 XFF_T =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.22)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = devdb)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )