oracle 11g tns和監聽配置

11g的監聽配置
[oracle@node3 admin]$ more listener.ora 


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


ADR_BASE_LISTENER = /u01/app/oracle


11g的tns配置


[oracle@node3 admin]$ more tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


PROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = prod)
    )
  )


test=
 (DESCRIPTION= 
  (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.10.101)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=test)
     (SERVER=dedicated)
   )
 )