Wednesday, 24 July 2019

services in rac

srvctl stop service -d DWDB -s DWDB_SRI_ETLUSER



srvctl add service -d DWDB -s DWDB_SRI_ETLUSER -r DWDB1,DWDB2 -a DWDB1,DWDB2



srvctl add service -d DWDB -s DWDB_SRI_ETLUSER -r DWDB1 -a DWDB2



srvctl add service -d DWDB -s DWDB_export_import -r DWDB1 -a DWDB2



srvctl modify service -db DWDB -service DWDB_SRI_USER -n -preferred DWDB1,DWDB2





srvctl relocate service -s DWDB_SRI_USER -d DWDB -i DWDB1 -t DWDB2





srvctl modify service -db DWDB -service DWDB_SRI_USER -n -preferred DWDB1,DWDB2 -a DWDB1,DWDB2



srvctl config service -db DWDB





srvctl modify service -db DWDB -service DWDB_sri_user -modifyconfig -available DWDB1,DWDB2

No comments:

Post a Comment

Featured post

duplicate db from standy to other server

 Duplicate Testuat   $ export ORACLE_SID=Testuat3 $ sqlplus '/as sysdba' Testuat3 SQL> alter system set cluster_database=FALSE sc...