Author Archives: pradeepvattem

I’m Speaking at Sangam18 (#sangam18) Tools & Utilities in Oracle Cloud for DBAs

There has been a lot of transformation in DBAs job role where automating tasks and working with REST APIs have become an essential part of DBAs day to day life. To know more about, how DBAs can adapt to the … Continue reading

Posted in Conferences/UserGroups | Leave a comment

ORA-16191: Primary log shipping client not logged on standby

Issue: While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. SQL> select DEST_ID, STATUS, DESTINATION, ERROR from V$ARCHIVE_DEST where dest_id=’2′; … Continue reading

Posted in Oracle Database | Leave a comment

Oracle Apps DBA Tech Day @ Hyderabad on 10Nov’18 (#Oracle #AppsDBA, #AIOUG)

We have come up with ‘Oracle Apps DBA tech day along with a one hour session on Weblogic internals’ in Hyderabad on 10Nov’18;. it’s a half day event and the registrations are limited. Please do hurry up and register for … Continue reading

Posted in Conferences/UserGroups, Oracle Applications/Apps DBA | Leave a comment

Excited to attend OOW’18 #Oracle #OOW18

  I’m feeling really excited to attend Oracle Open World for the first time after a 9 year journey with Oracle technologies. I really want to thank Sai Penumuru, AIOUG, Satyendra Pasalapudi for this opportunity, and making my ‘Dream Come … Continue reading

Posted in Conferences/UserGroups | Leave a comment

Password details in sys.user$ table in 11g & 12c

Scope: The scope of this blog post is to explain the way of capturing password values in 11g & in 12c. in 11g: We normally go with the syntax “select password from user$ where name=’TEST’; But, in 12c password column … Continue reading

Posted in Oracle Database | Leave a comment

Oracle Cloud Tech Day & Cloudathon @aioughyderabad@aioug@TechM in Hyderabad – Successful

Its been a fabulous journey being a co-organizer & speaker on the event of “Oracle Cloud Tech Day & Cloudathon” in Hyderabad. The event was kick started by Satyendra Pasalapudi (ACE Director Alumni) explaining the reasons of ‘Why Oracle the … Continue reading

Posted in Conferences/UserGroups, Oracle Cloud | Leave a comment

Point In Time Recovery using orec utility (#OracleCloud #orec #dbaascli)

Scope: The scope of this blog post is to understand the commands used to recover a database which is in Oracle Cloud to restore & recover till point in time. Steps Involved: When we are planning to recover a database, … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

The backup process failed RMAN-03009: failure of backup command,ORA-19506: failed to create sequential file, ORA-27028: skgfqcre: sbtbackup returned error, ORA-19511: non RMAN, but media manager or vendor specific failure(#OracleCloud #bkup_api)

Issue: I was trying to take a backup of a Database which is in Oracle Cloud (DBCS) using the bkup_api utility and couldn’t succeed with the below errors. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 08/23/2018 14:15:48 ORA-19506: … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

Bug in Oracle Cloud Console DBCS (#OracleCloud #DBCS #dbaascli)

This is just an informational message: Scope: I’ve noticed a bug with the console, where it doesn’t show the list of applied patches and still show the patches applicable, when the patch has been applied from CLI Description: I’ve applied … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment

Patching Database using dbaascli utility (#OracleCloud #dbaascli #dbpatchm)

Scope: The scope of this blogpost is to understand how a Database in Oracle Cloud (DBCS) can be patched using dbaascli utility. I will also share my 6 hours of patching experience with this utility. High Level Steps: Identify what … Continue reading

Posted in Oracle Cloud, Oracle Database | Leave a comment