oracle11gr2在redhat63環(huán)境中搭建rac集群及簡單維護(hù)-資料下載頁
2025-04-07 06:22本頁面
【正文】 node node2 單個(gè)Oracle實(shí)例狀態(tài)srvctl status instance d oradb i rac1Instance rac1 is running on node node1 節(jié)點(diǎn)應(yīng)用程序狀態(tài)srvctl status nodeappsVIP node1vip is enabledVIP node1vip is running on node: node1VIP node2vip is enabledVIP node2vip is running on node: node2Network is enabledNetwork is running on node: node1Network is running on node: node2GSD is disabledGSD is not running on node: node1GSD is not running on node: node2ONS is enabledONS daemon is running on node: node1ONS daemon is running on node: node2 節(jié)點(diǎn)應(yīng)用程序配置srvctl config nodeappsNetwork exists: 1/, type staticVIP exists: /node1vip/, hosting node node1VIP exists: /node2vip/, hosting node node2GSD existsONS exists: Local port 6100, remote port 6200, EM port 2016 數(shù)據(jù)庫配置srvctl config database d oradb aDatabase unique name: oradbDatabase name: oradbOracle home: /u01/app/oracle/product/Oracle user: oracleSpfile: +DATADG/oradb/Domain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: oradbDatabase instances: rac1,rac2Disk Groups: DATADG,FRADGMount point paths:Services:Type: RACDatabase is enabledDatabase is administrator managed ASM狀態(tài)srvctl status asmASM is running on node2,node1 ASM配置srvctl config asm aASM home: /u01/app/ASM listener: LISTENERASM is enabled. TNS監(jiān)聽器狀態(tài)srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): node2,node1 TNS監(jiān)聽器配置srvctl config listener aName: LISTENERNetwork: 1, Owner: gridHome: CRS home/u01/app/(s) node2,node1End points: TCP:1521 SCAN狀態(tài)srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node node2SCAN VIP scan2 is enabledSCAN VIP scan2 is running on node node1SCAN VIP scan3 is enabledSCAN VIP scan3 is running on node node1 SCAN配置srvctl config scanSCAN name: , Network: 1/SCAN VIP name: scan1, IP: /SCAN VIP name: scan2, IP: /SCAN VIP name: scan3, IP: / 驗(yàn)證所有集群節(jié)點(diǎn)間的時(shí)鐘同步cluvfy p clocksync verboseResult: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful. 登陸數(shù)據(jù)庫sqlplus / as sysdbaset pagesize 999set linesize 200 查看實(shí)例狀態(tài)select instance_name,status from gv$instance。 檢查所有節(jié)點(diǎn)crscrsctl check cluster –allcrsctl check crssu gridsqlplsu / as sysasm startup 集群的啟停10 停止所有節(jié)點(diǎn)上的實(shí)例srvctl status database d oradb檢查所有的節(jié)點(diǎn)上的實(shí)例狀態(tài)srvctl status database –d oradb 啟動(dòng)所有節(jié)點(diǎn)上的實(shí)例srvctl start database d racdb58 / 58
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1