Author: debasis maity

This screen guide you how to open EM console You need to enable Access rule before OEM Console open You need to choose ora_p2_dbconsole to enable OEM port You need to enable ora_p2_dbconsole to open port 1158 OEM screen – you need to give user name and pass to login This is the opening screenContinue reading Oracle DBaaS 1z0-160 part 30 :- EM Monitor Console in Oracle cloud

How to access DBaaS monitor from console Please open port 443 (https) using “Access Rules” Please enable oar_p2_httpssl Now the port ora_p2_httpssl open now If you do not want to enable port 443 from console,you need to enable port forwarding. If you enable port forwarding,you need to open using localhost after enable putty session. WhenContinue reading Oracle DBaaS 1z0-160 part 29 :- DBaaS monitor in Oracle cloud

Backup and Recovery from DB Console You may face problem in taking backup to oracle container for oracle cloud RAC. Please follow below link to troubleshoot. https://clouddba.co/kbhs-00712-ora-29024-received-from-local-http-service-during-backup-in-rac-oracle-cloud/ Once you have resolved the issue,You can proceed with backup Please proceed to take backup Backup log location You can find backup of RMAN log for oracle cloudContinue reading Oracle DBaaS 1z0-160 part 28:- Backup and recovery in RAC in oracle cloud

1.Connect as the opc user to the compute node. 2.Execute the raccli update rdk subcommand: $ raccli update rdk -tag tag-number where tag-number is the version of tooling you want to update to, without the dots in the version number. For example, to update to 17.2.5 tooling you would enter 1725. If you are updatingContinue reading Oracle DBaaS 1z0-160 part 27 :-Updating cloud tooling using raccli

Please select create instance after selecting “Database” option Please select one of following options(I choose custom) Please select the option to create RAC Please provide SSH public key or create new key SSH key will be generated now Please provide other relevant information The instance will be now creating and will take 2-3 hours AfterContinue reading Oracle DBaaS 1z0-160 part 26 :- Install RAC from console in oracle database cloud

1.Recover database from console 2.Please select among below options 3.Please check the recovery progress now 4.Point in time recovery using PITR [root@MYTST ORCL]#  dbaascli orec –args -list [root@MYTST ORCL]#  dbaascli orec –args -pitr TAG20180409T051640 DBAAS CLI version 1.0.0 Executing command orec –args -pitr TAG20180409T051640 –args : -pitr TAG20180409T051640 OREC version: 16.0.0.0 Starting OREC Logfile isContinue reading Oracle DBaaS 1z0-160 part 25 :- Recover database in oracle database cloud

1.Please check status on primary dbaascli dataguard status –details yes 2.Please check status of dataguard in standby dbaascli dataguard status –details yes 3.Perform Switchover from primary to standby from console 4.Please note primary is standby and standby is now primary 5.Perform switchover from command line to switchover to primary again Use the password option toContinue reading Oracle DBaaS 1z0-160 part 23 :- Dataguard Administration in oracle cloud

login as: opc Authenticating with public key “rsa-key-20180316” [opc@ORCL ~]$ sudo su – [root@ORCL ~]# /var/opt/oracle/patch/dbpatchmsm -list_ospatches INFO: non async case INFO: cmd is: /var/opt/oracle/patch/dbpatchm -list_ospatches Starting DBPATCHM Logfile is /var/opt/oracle/log/dbpatchm/dbpatchm_2018-03-28_11:49:32.log Config file is /var/opt/oracle/patch/dbpatchm.cfg <json begin>{“available_ospatch”:”yes”,”severity_ospatch”:”Critical”,”packages_list”:””}<json end> [root@ORCL ~]#  /var/opt/oracle/patch/dbpatchmsm -apply_ospatch_async INFO: async case INFO: patch number given is : <start txn>4<end txn> INFO:Continue reading Oracle DBaaS 1z0-160 part 22 :- OS Patching in oracle cloud