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
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Sunday, December 27, 2015
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 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,
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 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
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.
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.