Database Archive

Oracle Cloud: Accessing the database services

In the last post, we have explored how to create a Oracle Database as a Service (DBaaS) in Oracle cloud. In this post, I will discuss about the methods of accessing the database service once it is

Create Oracle Database as a Service (DBaaS) in Oracle Cloud

Oracle Cloud is making a lot of news these days. With companies moving to cloud, it looks like Cloud is here to stay. Oracle provides a wide range of Cloud services in the areas of SaaS/DaaS, PaaS

Oracle Database 12c : Change in Listener Service Registration Architecture

Overview: While doing troubleshooting with service registration to Listener, I have come across a new Oracle Database background process in 12c called LREG (Listener Registration Process). Prior to Oracle Database 12c, PMON (Process Monitor) was responsible for

Oracle Database 12c : Additional User details are available

Introduction: Prior to Oracle database 12c, if the DBA has to query about the last login time of a database user, he has to query couple of tables and then merge the result. Apart from querying multiple

Oracle Database: Using a strong password

Using a strong password for the Database User’s account is a primary need to secure the database access.  A strong password requires a combination of letters, numbers, special characters, upper and lower case combination and a length of

Restructure an Oracle table online using DBMS_REDEFINITION

Introduction As a DBA you may have faced situations, where you need to change the column ordering of a particular table. We have different options to accomplish the task. However, most of the methods requires an outage. Here,

RMAN Backup fails with ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Issue Description: RMAN backup failed with ORA-27054 errors while NFS filesystem was used for backup destination RMAN> run 2> { 3> allocate channel c1 device type disk; 4> allocate channel c2 device type disk; 5> backup database

How to Un-Catalog Duplicate Backup piece

Use the RMAN,  CROSSCHECK command to find the duplicate entries for a backup file. RMAN> crosscheck backup [completed ] [after/before]  [time];   2.  If you use the backup piece name of the duplicate entries, you will get
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed