Posts

Oracle 2 node RAC primary and standby installation and setup on Oracle Linux

-
Image
#################################################################################                            Oracle 2 node RAC primary and standby installation and setup .                                                  ################################################################################# Servers  Requirement : Server :  4-Nos( primary 2 server and standby 2 server ) Type   : Virtual/physical Ram   : 60GB each server ( chose as per your requirement) Core   : 16 each server         ( chose as per your requirement) Server Details : TESTRAC1N01- 10.100.70.80 -Primary-N1 TESTRAC1N02- 10.100.70.81- Primary-N2 TESTRAC2N01- 10.100.70.82- Standby-N1 TESTRAC2N02- 10.100.70.83- Standby-N2 Storage Requirement:  --For All 4 Machines . Storage as per your requirement. Name Total Size LUN Data 5TB 1T *5 Reco 300GB 100G  * 3 Redo 24GB 12G * 2 OCR/Voting
Post a Comment
Read more

Register listeners with the Clusterware to startup automatically

-
Register other listeners with the Clusterware to startup automatically with Oracle Restart startup : -- Mandatory info(listener name, port no) will get from Listener.ora file . # vi /u01/app/grid/product/12.2.0/grid/network/admin/listener.ora --Use the srvctl add listener command with the following syntax: --log in as grid user srvctl add listener [-l listener_name] [-p endpoints] [-s] [-o Oracle_home] Option Description : -l listener_name -p endpoints -s Skip checking for port conflicts with the supplied endpoints -o Oracle_home (Oracle home for the listener. If omitted, the Oracle Grid Infrastructure home is assumed) $ srvctl add listener -l <listener_name> -s -p <port no> --To Start the same listener: $ srvctl start listener -l <Listener_name> -- To config under crsctl status $ srvctl config listener -l <listener_name> --Now above listener will comes under crsctl status. $ crsctl status res -t
Post a Comment
Read more

How to Configure DB services to start by Automatically on cluster

-
How to Configure DB services to start by Automatically on cluster (oracle restart and cluster environments ) Services can be start with following Option : PRIMARY,PHYSICAL_STANDBY,LOGICAL_STANDBY,SNAPSHOT_STANDBY --If Service role option is "PRIMARY" then the service will not start automatically on a standby DB when clusterware/Oracle Restart start by "crsctl start has/crs" command, it need to be started manually. --With below option you can check the service configuration: $ srvctl config service -s <Service_Name> -d <database_name> --you can see what define on With Service role option, here below as mention Primary so it will auto restart on Primany only. Service role: PRIMARY --In order to get a service startup automatically when clusterware: $ srvctl modify service -d <DB_NAME> -s <service_name> -l 'PRIMARY,PHYSICAL_STANDBY' --Now will see that Service role cnfigured to startup automaticaly with "PRIMAR
1 comment
Read more