- 论坛徽章:
- 0
|
主服务器:HP 主机名:rmyyserver2 IP:168.168.0.2 镜像IP:10.1.1.1
备服务器:HP 主机名:rmyyserver IP:168.168.0.3 镜像IP:10.1.1.2
HUB对外提供的服务(也是虚拟IP):168.168.0.1
人民医院 主备机ORA程序装在C:\
主备机ORA库装在E:\,并且主备机E:\驱动器大小完全一致
★主安LAAM前的准备:
Oracle\ora90\network\admin下:
------------------------------------------------------------------------------------------------------------------
listener.ora:
# LISTENER.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.0.2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Oratest)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = Oratest)
)
)
------------------------------------------------------------------------------------------------------------------------
tnsnames.ora:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORATEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =168.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Oratest)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =168.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =
http://HRService
)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
---------------------------------------------------------------------------------------------------------------------------
★CMD 查Oracle9i数据库各个状态
lsnrctl start 查监听
登录sqlplus/nolog
conn as sysdba
SQL>archive loglist数据库状态,检查启动
★主备机修改Hosts
C:\windows\system32
不变并添加:
168.168.0.2 rmyyserver2
168.168.0.3. rmyyserver
保存关闭
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/70914/showart_727718.html |
|