开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4065-11g管理类OCM认证班第一期 › 第47, 48和49次：2014-11-07, 2014-11-09
返回列表 发新帖
查看: 1568|回复: 0

第47, 48和49次：2014-11-07, 2014-11-09

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2014-11-10 11:16:03 | 显示全部楼层 |阅读模式
listener.ora.station37
  1. # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.

  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON

  6. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON

  8. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

  10. SID_LIST_LISTENER =
  11.   (SID_LIST =
  12.     (SID_DESC =
  13.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  14.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  15.       (SID_NAME = RDBS1)
  16.     )
  17.     (SID_DESC =
  18.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  19.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  20.       (SID_NAME = RDBS2)
  21.     )
  22.   )

  24. SID_LIST_LISTENER_SCAN3 =
  25.   (SID_LIST =
  26.     (SID_DESC =
  27.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  28.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  29.       (SID_NAME = RDBS1)
  30.     )
  31.     (SID_DESC =
  32.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  33.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  34.       (SID_NAME = RDBS2)
  35.     )
  36.   )

  38. SID_LIST_LISTENER_SCAN2 =
  39.   (SID_LIST =
  40.     (SID_DESC =
  41.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  42.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  43.       (SID_NAME = RDBS1)
  44.     )
  45.     (SID_DESC =
  46.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  47.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  48.       (SID_NAME = RDBS2)
  49.     )
  50.   )

  52. SID_LIST_LISTENER_SCAN1 =
  53.   (SID_LIST =
  54.     (SID_DESC =
  55.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  56.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  57.       (SID_NAME = RDBS1)
  58.     )
  59.     (SID_DESC =
  60.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  61.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  62.       (SID_NAME = RDBS2)
  63.     )
  64.   )

  66. LISTENER =
  67.   (DESCRIPTION =
  68.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  69.   )

  71. ADR_BASE_LISTENER = /u01/app/grid

  73. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  75. LISTENER_SCAN3 =
  76.   (DESCRIPTION =
  77.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))
  78.   )

  80. LISTENER_SCAN2 =
  81.   (DESCRIPTION =
  82.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))
  83.   )

  85. ADR_BASE_LISTENER_SCAN3 = /u01/app/grid

  87. LISTENER_SCAN1 =
  88.   (DESCRIPTION =
  89.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  90.   )

  92. ADR_BASE_LISTENER_SCAN2 = /u01/app/grid

  94. ADR_BASE_LISTENER_SCAN1 = /u01/app/grid
复制代码

listener.ora.station38:

  1. # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.

  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON

  6. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON

  8. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

  10. SID_LIST_LISTENER =
  11.   (SID_LIST =
  12.     (SID_DESC =
  13.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  14.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  15.       (SID_NAME = RDBS1)
  16.     )
  17.     (SID_DESC =
  18.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  19.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  20.       (SID_NAME = RDBS2)
  21.     )
  22.   )

  24. SID_LIST_LISTENER_SCAN3 =
  25.   (SID_LIST =
  26.     (SID_DESC =
  27.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  28.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  29.       (SID_NAME = RDBS1)
  30.     )
  31.     (SID_DESC =
  32.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  33.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  34.       (SID_NAME = RDBS2)
  35.     )
  36.   )

  38. SID_LIST_LISTENER_SCAN2 =
  39.   (SID_LIST =
  40.     (SID_DESC =
  41.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  42.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  43.       (SID_NAME = RDBS1)
  44.     )
  45.     (SID_DESC =
  46.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  47.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  48.       (SID_NAME = RDBS2)
  49.     )
  50.   )

  52. SID_LIST_LISTENER_SCAN1 =
  53.   (SID_LIST =
  54.     (SID_DESC =
  55.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  56.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  57.       (SID_NAME = RDBS1)
  58.     )
  59.     (SID_DESC =
  60.       (GLOBAL_DBNAME = RDBS_DGMGRL)
  61.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  62.       (SID_NAME = RDBS2)
  63.     )
  64.   )

  66. LISTENER =
  67.   (DESCRIPTION =
  68.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  69.   )

  71. ADR_BASE_LISTENER = /u01/app/grid

  73. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  75. LISTENER_SCAN3 =
  76.   (DESCRIPTION =
  77.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))
  78.   )

  80. LISTENER_SCAN2 =
  81.   (DESCRIPTION =
  82.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))
  83.   )

  85. ADR_BASE_LISTENER_SCAN3 = /u01/app/grid

  87. LISTENER_SCAN1 =
  88.   (DESCRIPTION =
  89.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  90.   )

  92. ADR_BASE_LISTENER_SCAN2 = /u01/app/grid

  94. ADR_BASE_LISTENER_SCAN1 = /u01/app/grid
复制代码

listener.ora.station39:

  1. # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.

  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON

  6. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON

  8. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

  10. SID_LIST_LISTENER =
  11.   (SID_LIST =
  12.     (SID_DESC =
  13.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  14.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  15.       (SID_NAME = RDBT1)
  16.     )
  17.     (SID_DESC =
  18.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  19.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  20.       (SID_NAME = RDBT2)
  21.     )
  22.   )

  24. SID_LIST_LISTENER_SCAN3 =
  25.   (SID_LIST =
  26.     (SID_DESC =
  27.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  28.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  29.       (SID_NAME = RDBT1)
  30.     )
  31.     (SID_DESC =
  32.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  33.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  34.       (SID_NAME = RDBT2)
  35.     )
  36.   )

  38. SID_LIST_LISTENER_SCAN2 =
  39.   (SID_LIST =
  40.     (SID_DESC =
  41.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  42.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  43.       (SID_NAME = RDBT1)
  44.     )
  45.     (SID_DESC =
  46.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  47.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  48.       (SID_NAME = RDBT2)
  49.     )
  50.   )

  52. SID_LIST_LISTENER_SCAN1 =
  53.   (SID_LIST =
  54.     (SID_DESC =
  55.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  56.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  57.       (SID_NAME = RDBT1)
  58.     )
  59.     (SID_DESC =
  60.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  61.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  62.       (SID_NAME = RDBT2)
  63.     )
  64.   )

  66. LISTENER =
  67.   (DESCRIPTION =
  68.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  69.   )

  71. ADR_BASE_LISTENER = /u01/app/grid

  73. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  75. LISTENER_SCAN3 =
  76.   (DESCRIPTION =
  77.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))
  78.   )

  80. LISTENER_SCAN2 =
  81.   (DESCRIPTION =
  82.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))
  83.   )

  85. ADR_BASE_LISTENER_SCAN3 = /u01/app/grid

  87. LISTENER_SCAN1 =
  88.   (DESCRIPTION =
  89.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  90.   )

  92. ADR_BASE_LISTENER_SCAN2 = /u01/app/grid

  94. ADR_BASE_LISTENER_SCAN1 = /u01/app/grid
复制代码

listener.ora.station40
  1. # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.

  4. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON

  6. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON

  8. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

  10. SID_LIST_LISTENER =
  11.   (SID_LIST =
  12.     (SID_DESC =
  13.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  14.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  15.       (SID_NAME = RDBT1)
  16.     )
  17.     (SID_DESC =
  18.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  19.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  20.       (SID_NAME = RDBT2)
  21.     )
  22.   )

  24. SID_LIST_LISTENER_SCAN3 =
  25.   (SID_LIST =
  26.     (SID_DESC =
  27.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  28.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  29.       (SID_NAME = RDBT1)
  30.     )
  31.     (SID_DESC =
  32.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  33.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  34.       (SID_NAME = RDBT2)
  35.     )
  36.   )

  38. SID_LIST_LISTENER_SCAN2 =
  39.   (SID_LIST =
  40.     (SID_DESC =
  41.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  42.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  43.       (SID_NAME = RDBT1)
  44.     )
  45.     (SID_DESC =
  46.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  47.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  48.       (SID_NAME = RDBT2)
  49.     )
  50.   )

  52. SID_LIST_LISTENER_SCAN1 =
  53.   (SID_LIST =
  54.     (SID_DESC =
  55.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  56.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  57.       (SID_NAME = RDBT1)
  58.     )
  59.     (SID_DESC =
  60.       (GLOBAL_DBNAME = RDBT_DGMGRL)
  61.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  62.       (SID_NAME = RDBT2)
  63.     )
  64.   )




  69. LISTENER =
  70.   (DESCRIPTION =
  71.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  72.   )

  74. ADR_BASE_LISTENER = /u01/app/grid

  76. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  78. LISTENER_SCAN3 =
  79.   (DESCRIPTION =
  80.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))
  81.   )

  83. LISTENER_SCAN2 =
  84.   (DESCRIPTION =
  85.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))
  86.   )

  88. ADR_BASE_LISTENER_SCAN3 = /u01/app/grid

  90. LISTENER_SCAN1 =
  91.   (DESCRIPTION =
  92.     (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
  93.   )

  95. ADR_BASE_LISTENER_SCAN2 = /u01/app/grid

  97. ADR_BASE_LISTENER_SCAN1 = /u01/app/grid
复制代码

pfile.primary
  1. *.audit_file_dest='/u01/app/oracle/admin/RDBS/adump'
  2. *.audit_trail='db'
  3. *.cluster_database=true
  4. *.compatible='11.2.0.0.0'
  5. *.control_files='+DATA/rdbs/controlfile/current.260.827700851','+FRA/rdbs/controlfile/current.256.827700851'
  6. *.db_block_size=8192
  7. *.db_create_file_dest='+DATA'
  8. *.db_domain=''
  9. *.db_name='RDBS'
  10. *.db_unique_name='RDBS'
  11. *.db_recovery_file_dest='+FRA'
  12. *.db_recovery_file_dest_size=4039114752
  13. *.diagnostic_dest='/u01/app/oracle'
  14. *.dispatchers='(PROTOCOL=TCP) (SERVICE=RDBSXDB)'
  15. RDBS2.instance_number=2
  16. RDBS1.instance_number=1
  17. *.memory_target=700M
  18. *.open_cursors=300
  19. *.processes=1500
  20. *.remote_listener='scan37.example.com:1521'
  21. *.remote_login_passwordfile='exclusive'
  22. *.sessions=1655
  23. RDBS2.thread=2
  24. RDBS1.thread=1
  25. RDBS2.undo_tablespace='UNDOTBS2'
  26. RDBS1.undo_tablespace='UNDOTBS1'
  27. *.log_archive_config='dg_config=(RDBS,RDBT)'
  28. *.log_archive_dest_10='location=use_db_recovery_file_dest'
  29. *.log_archive_dest_1='service=RDBT valid_for=(online_logfiles,primary_role) db_unique_name=RDBT'
  30. *.standby_file_management=auto
  31. *.archive_lag_target=1800
  32. *.fal_server=RDBT
  33. *.fal_client=RDBS
  34. *.dg_broker_config_file1='+data/RDBS/dr1RDBS.dat'
  35. *.dg_broker_config_file2='+fra/RDBS/dr2RDBS.dat'
复制代码

pfile.standby
  1. *.audit_file_dest='/u01/app/oracle/admin/RDBT/adump'
  2. *.audit_trail='db'
  3. *.cluster_database=true
  4. *.compatible='11.2.0.0.0'
  5. *.control_files='+DATA','+FRA'
  6. *.db_block_size=8192
  7. *.db_create_file_dest='+DATA'
  8. *.db_domain=''
  9. *.db_name='RDBS'
  10. *.db_unique_name='RDBT'
  11. *.db_recovery_file_dest='+FRA'
  12. *.db_recovery_file_dest_size=4039114752
  13. *.diagnostic_dest='/u01/app/oracle'
  14. *.dispatchers='(PROTOCOL=TCP) (SERVICE=RDBTXDB)'
  15. RDBT2.instance_number=2
  16. RDBT1.instance_number=1
  17. *.memory_target=700M
  18. *.open_cursors=300
  19. *.processes=1500
  20. *.remote_listener='scan39.example.com:1521'
  21. *.remote_login_passwordfile='exclusive'
  22. *.sessions=1655
  23. RDBT2.thread=2
  24. RDBT1.thread=1
  25. RDBT2.undo_tablespace='UNDOTBS2'
  26. RDBT1.undo_tablespace='UNDOTBS1'
  27. *.log_archive_config='dg_config=(RDBS,RDBT)'
  28. *.log_archive_dest_10='location=use_db_recovery_file_dest'
  29. *.log_archive_dest_1='service=RDBS valid_for=(online_logfiles,primary_role) db_unique_name=RDBS'
  30. *.standby_file_management=auto
  31. *.archive_lag_target=1800
  32. *.fal_server=RDBS
  33. *.fal_client=RDBT
  34. *.dg_broker_config_file1='+data/RDBT/dr1RDBT.dat'
  35. *.dg_broker_config_file2='+fra/RDBT/dr2RDBT.dat'
复制代码

tnsnames.ora
  1. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
  2. # Generated by Oracle configuration tools.

  4. RDBS =
  5.   (DESCRIPTION =
  6.     (ADDRESS = (PROTOCOL = TCP)(HOST = scan37.example.com)(PORT = 1521))
  7.     (CONNECT_DATA =
  8.       (SERVER = DEDICATED)
  9.       (SERVICE_NAME = RDBS)
  10.     )
  11.   )


  14. RDBS1 =
  15.   (DESCRIPTION =
  16.     (ADDRESS = (PROTOCOL = TCP)(HOST = station37.example.com)(PORT = 1521))
  17.     (CONNECT_DATA =
  18.       (SERVER = DEDICATED)
  19.       (SERVICE_NAME = RDBS)
  20.     )
  21.   )


  24. RDBS2 =
  25.   (DESCRIPTION =
  26.     (ADDRESS = (PROTOCOL = TCP)(HOST = station38.example.com)(PORT = 1521))
  27.     (CONNECT_DATA =
  28.       (SERVER = DEDICATED)
  29.       (SERVICE_NAME = RDBS)
  30.     )
  31.   )


  34. RDBT =
  35.   (DESCRIPTION =
  36.     (ADDRESS = (PROTOCOL = TCP)(HOST = scan39.example.com)(PORT = 1521))
  37.     (CONNECT_DATA =
  38.       (SERVER = DEDICATED)
  39.       (SERVICE_NAME = RDBT)
  40.     )
  41.   )


  44. RDBT1 =
  45.   (DESCRIPTION =
  46.     (ADDRESS = (PROTOCOL = TCP)(HOST = station39.example.com)(PORT = 1521))
  47.     (CONNECT_DATA =
  48.       (SERVER = DEDICATED)
  49.       (SERVICE_NAME = RDBT)
  50.     )
  51.   )


  54. RDBT2 =
  55.   (DESCRIPTION =
  56.     (ADDRESS = (PROTOCOL = TCP)(HOST = station40.example.com)(PORT = 1521))
  57.     (CONNECT_DATA =
  58.       (SERVER = DEDICATED)
  59.       (SERVICE_NAME = RDBT)
  60.     )
  61.   )
复制代码



回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-5-5 22:35 , Processed in 0.125050 second(s), 24 queries .

快速回复 返回顶部 返回列表