Lorem Ipsum has been the industry's standard dummy
For deep understanding on CBC,please refer to below links:- http://www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to mention some useful queries to investigate or identify CBC latch Step 1:-You as user fire a sql query from client. select * from cbctest; Step 2:-Now oracle will search metadata and determine what is your file_id and block_id to locate […]
Problem 1.First I copied the private key generated by puttygen (The public key was provided during DB creation in oracle cloud).After that I tried to connect cloud database using below command:- cd /home/oracle chown oracle:oinstall course_priv.ppk chmod 0600 course_priv.ppk [oracle@gnssrv01 ~]$ ssh -i course_priv.ppk opc@144.21.83.108 Enter passphrase for key ‘course_priv.ppk’: Enter passphrase for key ‘course_priv.ppk’: Enter passphrase for key ‘course_priv.ppk’: Permission […]
This note describe how we can configure TDE encryption for RMAN backup in on-premise database to migrate to Oracle cloud. 1.First I need to update sqlnet.ora with proper location where my wallet will reside to enable TDE encryption. # sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) ENCRYPTION_WALLET_LOCATION= (SOURCE= (METHOD=FILE) (METHOD_DATA= (DIRECTORY=/var/opt/oracle/hdg/tde_wallet) ) […]
My on-premise database hostname:-gnssrv01 Database name:-orcl12c Cloud database hostname:-myclone A.Backup of on-premise database to cloud container Please create the empty container for holding backup of on-premise database using following link https://clouddba.co/oracle-dbaas-1z0-160-part-24-backup-in-single-instance-oracle-cloud/ 1.First I need to install backup module for cloud in on-premise database You need to download opc.cert and opc_install.jar mentioned in above metalink note (Doc ID 2360941.1) [oracle@myclone ~]$ […]
Data security In Oracle Database Cloud Service databases, data security is provided for data in transit and data at rest. Security of data in transit is achieved through network encryption. Data at rest security is achieved through encryption of data stored in database data files and backups.Data in Oracle Database files, including backups, is secured by the use of encryption […]
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 screen of Enterprise manager
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. When prompted for a user name […]
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 cloud in following location:- [oracle@pocracdemo1 ~]$ […]
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 updating the cloud tooling on a […]
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 After installation you will get following […]