##########################
## 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:
Post a Comment