Sunday, December 27, 2015

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

Friday, December 25, 2015

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 (MYDBSERVER is the hostname in this case) and I have a file /u01/oracle.tar on second host that I want to transfer to /u01 on my current host,

Sunday, December 13, 2015

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.

Tuesday, December 8, 2015

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 - 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

Wednesday, December 2, 2015

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.