Tuesday, February 4, 2014

rman: can't open target


##########################
## Error
##########################

 [/usr/oracle/siod/SCRIPTS] oracle@host01 $ rman target /
rman: can't open target

##########################
#  Error Occurred
##########################

Error occured while tried to connect rman in one of our server

##########################
## Command Executed
##########################

rman target /

**************************************** Step By Step Analysis ******************************************************

#########################################
# 1) Check Home
#########################################

I have cross checked whether correct Oracle Database Home and Environmental variable like PATH is correctly set. Everything is fine but still it produces error.

=====================================================================================================================

#########################################
# 2) Reason for Failure
#########################################

Upon Digging Further, found that whenever i type rman its not taking the binary from $ORACLE_HOME/bin

#########################################
# 3) Troubleshooting
#########################################

I need to find out which rman binary is getting kick started when i give rman target /

So i have given which rman command.

$ which rman
/usr/X11R6/bin/rman

From the above output we can see that whenever i type rman it tries to execute the binary from /usr/X11R6/bin/rman and not $ORACLE_HOME/bin/rman

And also checking the PATH environmental variable,

 /usr/oracle/product/11.2.0.2/bin] oracle@host01 $ echo $PATH
/usr/local/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/jvm/jre/bin:/siod/thishost/unix/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:.:/usr/oracle/product/11.2.0.2/bin
[/usr/oracle/product/11.2.0.2/bin] oracle@host01 $

=====================================================================================================================

##########################
## Solution
##########################

Three Solutions available for this Issue.

1) Run the rman prompt like below,

$ORACLE_HOME/bin/rman target /

2) Place $ORACLE_HOME/bin in the beginning of the PATH variable, such that when rman binary is searched it will look into $ORACLE_HOME/bin/rman

3) Remove /usr/X11R6/bin entry from $PATH

=====================================================================================================================
Thanks to my Wife for bringing up this error and helped me in troubleshooting & Resolving.
=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================



No comments: