2006-11-21 22:48
pangyi
请问在互备的双机情况下,运行两个应用,Oracle应该如何配置呢?
现在是一个主备的双机模式,有一个svc ip,在跑一个应用。
可是客户说另一台机很浪费,说要加一个应用让那台备机跑。
需要启用两个svc ip
请问这种情况下,我再建多一个用户,安装多一个oracle软件,并多建一个库。这种做法是否可行呢?》
另外如果不多建一个用户,能否在现有的环境下多建一个库实现用户提出的需求呢?
2006-11-21 23:00
老农
都可以。
注意SID
2006-11-21 23:08
pangyi
哦!是啊~
如果用同一个用户建两个库,那么就有两个SID啦。
我现在试过可以建两个库,但是就是试不出在同一个监听里,监听两个地址。
看来还是多建一个用户比较安全。。。
2006-11-21 23:15
老农
监听多个地址,很常见啊:o
2006-11-21 23:27
pangyi
哦~试出了,可以监听两个地址。。。
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.8)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracleServer\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ora91)
(ORACLE_HOME = e:\oracleServer\ora92)
(SID_NAME = ora91)
)
(SID_DESC =
(GLOBAL_DBNAME = ora9011)
(ORACLE_HOME = e:\oracleServer\ora92)
(SID_NAME = ora9011)
)
)
2006-12-1 10:21
dongziming
hao d ~
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.