在服务器端配置listener.ora和tnsnames.ora   
  修改lisnter.ora和tnsnames.ora文件,以增加listener. 
  这一部分,RAC环境和非RAC环境没有区别,可以参考oracle的文档.   
  可以一个listener给三个instance服务,也可以启动三个listener给三个instance服务. 
  我启动了三个listener.   
  Listener.ora 
  LSNR1 = 
  (ADDRESS_LIST= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1521))) 
  LSNR2 = 
  (ADDRESS_LIST= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1522))) 
  LSNR3 = 
  (ADDRESS_LIST= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1523)))   
  tnsnames.ora 
  lsnr1=(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1521))) 
  lsnr2=(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1522))) 
  lsnr3=(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=your_ip_or_name)(PORT=1523)))   
  将your_ip_or_name替换为你的IP地址或者hostname. 
  Rac.test.com替换为你init.ora文件中设置的db_name.db_domain   
  启动三个listener. 
  $ lsnrctl start lsnr1 
  $ lsnrctl start lsnr2 
  $ lsnrctl start lsnr3 
查看本文来源