** Myself
#######################################################no.Create tablespace of OEM
######################################################
CREATE TABLESPACE "OEM_TS"
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\OMS\OEM_TS.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE USER "OEM" PROFILE "DEFAULT"
IDENTIFIED BY "OEM" DEFAULT TABLESPACE "OEM_TS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "OEM";
GRANT SYSDBA,DBA,CONNECT,RESOURCE TO "OEM";
#######################################################1.Create Repository of OEM (สร้าง repository ของ OEM)
######################################################
-Programs->Oracle-home->Configuration and migration tools->Enterprise manager configuration assistant (EMCA unix)
-configure local oms
-create new repository
-cutom
-in anothor existing db
-login sysdba
-user oem
-create repository
#######################################################2.start OEM and agent
######################################################
oemctl start oms
agentctl start
#######################################################3.config OEM
######################################################
-Programs->Oracle-home->Enterprise manager console
administrator:sysman
password:oem_temp
newpassword:sysman
-(สั่ง) Scan discover node
-configuration preference ทั้ง database,node ทั้ง 2 ฝั่ง primary & standby (for monitoring Standby Database)
Create configuration 'OEM_site' as
Primary site is 'hostA_site_a'
Resource is 'hostB_site_b'
Hostname is '127.0.0.1'
Instance name is 'SID'
Service name is 'SID'
Site is maintained as PHYSICAL;
step 1
dataguard
step 2
primarydb=A
primarysite=<host>_site1
step 3
add existing standby database
step 4
oms
standbysite=<host_standby>_site2
step 5
user:sys
pass:
0 comments:
Post a Comment