Cleared 1Z0-997 Oracle Cloud Infra. Certified Architect Professional…

Cleared following 3 Oracle Cloud Infrastructure exams in a row in three days. Thanks to great Oracle COVID offers. wish to attempt more exams but could not find more slots serially.. Oracle Cloud Infrastructure 2019 Certified Architect Professional https://www.youracclaim.com/badges/ba7f88e4-25a4-4b2e-92af-dd4c6dd081f1/public_url Oracle Autonomous Database Cloud 2019 Certified Specialist. https://www.youracclaim.com/badges/787ba425-6a23-495c-a2f3-ab6082f026fe/public_urlOracle Cloud Infrastructure 2019 Architect Associate https://www.youracclaim.com/badges/2b87f825-d1b8-4746-8745-40975ca49d7f/public_url Though i… Read More »

ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0

ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0 Here i am upgrading ODA from 12.1.2.12.0 to 18.3.0.0.0.Backup ODA_BASE before proceeding with ODA Bundle patch.For ODA_BASE backup refer to post “Backup ODA_BASE: Database Appliance ODA X5“.Above post applies to ODA X5 or higher versions. Login to ODA_BASE as root user.Download & Unpack the ODA bundle patch on… Read More »

Backup ODA_BASE: Database Appliance ODA X5

There are situations we may need to backup ODA_BASE, especially before patching ODA_BASE.This article applies only to virtual deployment of ODA.In this Article I’ve used ODA-X5-2 appliance to backup.The procedure is applicable for ODA X5 or higher versions.ODA_BASE is backed up from the DOM machines, i.e. the parent machine from where ODA_BASE was created.Login to… Read More »

RMAN backup details, Display last 5 days

Following query can be used to get rman backup job details for last 5 days.

CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address

Getting following error during CRS start. we had a server reboot post maintenance. CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address

Looking at the logs above this seems to be issue with network. Verify the same by comparing output of following two commands.

On output 1 the interface name for PRIVATE network is… Read More »

Single Instance to RACOne Node Conversion.

Convert single instance to RAC using rconfig utility. Verify the database is added to cluster and is SINGLE Instance.

Above output shows Type: SINGLE.

So here I’ve changed only following values i.e. SourceDBHome, TargetDBHome, SourceDBInfo, Password, Node name, RacOneNode servicename, InstancePrefix and following values are altered to blank (><) as we are not… Read More »

Configure unixODBC in Linux

Configuring unixODBC on Linux, can be  a general requirement for Peoplesoft or many Application to connect to Oracle database. Check whether all required RPMs present or Not…as follows.  

Result of above ccommand on Oracle Enterprise Linux is: /usr Now copy the unixODBC-2.2.14.tar to /u01 then extract it using tar -xvf unixODBC-2.2.14.tar which will create… Read More »