Bo's Oracle Station

查看: 1526|回复: 0

课程第7/8次(2017-03-11星期六晚上和2017-03-12星期日晚上)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-3-13 10:58:11 | 显示全部楼层 |阅读模式
上完1Z0-052第3章:建库
1Z0-051共12章(上完0章),1Z0-052共19章(上完2章),1Z0-053共21章(上完0章)
总共上完全部52章中的2章

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

  3. ALLL =
  4.   (DESCRIPTION =
  5.     (ADDRESS_LIST =
  6.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
  7.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
  8.     )
  9.   )

  10. ORACLR_CONNECTION_DATA =
  11.   (DESCRIPTION =
  12.     (ADDRESS_LIST =
  13.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  14.     )
  15.     (CONNECT_DATA =
  16.       (SID = CLRExtProc)
  17.       (PRESENTATION = RO)
  18.     )
  19.   )

  20. BESTTNS =
  21.   (DESCRIPTION =
  22.     (ADDRESS_LIST =
  23.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
  24.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1522))
  25.       (LOAD_BALANCE = yes)
  26.     )
  27.     (CONNECT_DATA =
  28.       (SERVICE_NAME = orcl.example.com)
  29.     )
  30.   )

  31. RCAT =
  32.   (DESCRIPTION =
  33.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
  34.     (CONNECT_DATA =
  35.       (SERVER = DEDICATED)
  36.       (SERVICE_NAME = rcat.example.com)
  37.     )
  38.   )

  39. UTFORCL =
  40.   (DESCRIPTION =
  41.     (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
  42.     (CONNECT_DATA =
  43.       (SERVER = DEDICATED)
  44.       (SERVICE_NAME = utforcl.example.com)
  45.     )
  46.   )

  47. ORCL =
  48.   (DESCRIPTION =
  49.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
  50.     (CONNECT_DATA =
  51.       (SERVER = DEDICATED)
  52.       (SERVICE_NAME = orcl.example.com)
  53.     )
  54.   )

  55. ORCL199 =
  56.   (DESCRIPTION =
  57.     (ADDRESS = (PROTOCOL = TCP)(HOST = station199)(PORT = 1521))
  58.     (CONNECT_DATA =
  59.       (SERVER = DEDICATED)
  60.       (SERVICE_NAME = orcl.example.com)
  61.     )
  62.   )
复制代码

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

  3. L2 =
  4.   (DESCRIPTION =
  5.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1522))
  6.   )

  7. ADR_BASE_L2 = /u01/app/oracle

  8. SID_LIST_LISTENER =
  9.   (SID_LIST =
  10.     (SID_DESC =
  11.       (GLOBAL_DBNAME = orcl.example.com)
  12.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  13.       (SID_NAME = orcl)
  14.     )
  15.     (SID_DESC =
  16.       (GLOBAL_DBNAME = rcat.example.com)
  17.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  18.       (SID_NAME = rcat)
  19.     )
  20.   )

  21. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_L2 = ON

  22. LISTENER =
  23.   (DESCRIPTION =
  24.     (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
  25.   )

  26. ADR_BASE_LISTENER = /u01/app/oracle

  27. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

  28. SID_LIST_L2 =
  29.   (SID_LIST =
  30.     (SID_DESC =
  31.       (GLOBAL_DBNAME = orcl.example.com)
  32.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  33.       (SID_NAME = orcl)
  34.     )
  35.     (SID_DESC =
  36.       (GLOBAL_DBNAME = rcat.example.com)
  37.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  38.       (SID_NAME = rcat)
  39.     )
  40.   )
复制代码





回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 13:17 , Processed in 0.029994 second(s), 24 queries .

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