CRS-4563: Insufficient user privileges

[grid@dbnode1 ~]$ crsctl start crs CRS-4563: Insufficient user privileges. CRS-4000: Command Start failed, or completed with errors.

CRS-4535: Cannot communicate with Cluster Ready Services

If checking status of CRS (and other RAC resources) returns you this error, it means that CRS is not running.

[grid@dbnode1 ]$ crsctl stat res -t CRS-4535: Cannot communicate with Cluster Ready Services CRS-4000: Command Status failed, or completed with errors.

OEM Database Control Configuration gets Stuck

I encountered a situation where I was trying to configure OEM Database Control (11.2.0.4) on Windows based system using command similar to the following

emca -config dbcontrol db -repos recreate

ORA-00221: error on write to controlfile

Reason of this error (and probably instance crash) is that some other process has locked the controlfile and oracle process is not able to get hold of a lock on the controlfile before it could write in it. Most probable reason for this is some third party backup solution that might be copying oracle related files in backup process and hence holding a lock while copying.

Running a Command or Script in the Background on Linux

Many times we (DBAs) are in a situation when we need to run some command or script from the command prompt on the Linux, and during command/script execution; we face disconnection of session and our process stops in the middle leaving a lot of mess for us to clear. To avoid this kind of situation, it is advised to execute long running scripts or commands in the background using Linux

Using scp command on Linux to copy Files and Directories

DBAs need to move files from one host to the other in Linux environment. In this article, I would explain how to use scp (secure copy) command to copy files or directories from one host to the other.

Currently I am on 192.168.20.20 (MYDBSERVER is the hostname in this case) and I have a file /u01/oracle.tar on second host 192.168.20.30 that I want to transfer to /u01 on my current host,

ORA-19909: datafile 1 belongs to an orphan incarnation

Your MRP (Managed Recovery Process) may stop on your standby database with ORA-19909 error as can be seen in bellow excerpt from alert log file

Warning: Recovery target destination is in a sibling branch of the controlfile checkpoint. Recovery will only recover changes to datafiles.

ORA-17627 and ORA-12154 Returned by RMAN Duplicate Command

During RMAN DUPLICATE command, you might face this error message returned by RMAN.

C:\Users\administrator>rman target sys/pass11g@pri auxiliary sys/pass11g@aux Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 9 12:35:18 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ORA-12154 and TNS-03505

You may receive error “ORA-12154: TNS: could not resolve the connect identifier specified” while trying to connect with the database, and also “TNS-03505: Failed to resolve name” while using TNSPING to test the connection. Reasons for both of these error is that you have not created TNS service correctly

Creating ASM Diskgroups

In this article I would explain how to create new ASM diskgroups. Process is same for Unix based platforms or Windows systems, and also for other Oracle versions.
Before we move forward, you may have a look at my articles related to stamping ASM disks on windows and creating ASM disks using ASMLib on Linux to know how we create disks which are used for ASM diskgroups.