topic rma script fails in Operating System - HP-UX

rma script fails

shabir_1 — Tue, 30 Mar 2010 13:44:00 GMT

Hi,

ORACLE=oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=cieho
export PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin

su - $ORACLE -c "rman catalog=rman/rman target=sys/redhat @incr.sql"
it fails ++ su - oracle -c 'rman catalog=rman/rman target=sys/redhat @incr.sql'

it fails with following error
-bash: rman: command not found

pls any input to resolve this issue

Thanks
(Shabir)

Re: rma script fails

Patrick Wallek — Tue, 30 Mar 2010 13:54:04 GMT

It's probably not carrying your path over when you do the 'su'.

Specify the full path to the 'rman' executable.

su - $ORACLE -c "/u01/app/oracle/product/10.2.0/db_1/bin/rman catalog=rman/rman target=sys/redhat @incr.sql"

Re: rma script fails

Dennis Handly — Tue, 30 Mar 2010 14:02:02 GMT

Since you are doing "su -", your $PATH setting isn't copied over, as Patrick said.

You could add $PATH to the oracle user or add it on that command:
su - $ORACLE -c "export PATH=$PATH; rman catalog=rman/rman target=sys/redhat @incr.sql"

Your other variables aren't copied either, do you need them?

Re: rma script fails

shabir_1 — Tue, 30 Mar 2010 14:03:01 GMT

Hi Patrik,

Thanks lot for your inputs

We try but it fails againg

++ su - oracle -c '/u01/app/oracle/product/10.2.0/db_1/bin/rman catalog=rman/rman target=sys/Janet12 @incr.sql'

Message file RMAN.msb not found

Verify that ORACLE_HOME is set properly

thanks
(Shabir)

Re: rma script fails

Dennis Handly — Tue, 30 Mar 2010 14:35:31 GMT

>Verify that ORACLE_HOME is set properly

That's what I cautioned you about:
su - $ORACLE -c "export PATH=$PATH ORACLE_HOME=$ORACLE_HOME ORACLE_SID=$ORACLE_SID; rman catalog=rman/rman target=sys/redhat @incr.sql"

Re: rma script fails

shabir_1 — Tue, 30 Mar 2010 14:59:44 GMT

Hi,
Thanks lot it works

Shabir

Re: rma script fails

Dennis Handly — Tue, 30 Mar 2010 15:07:04 GMT

>Thanks lot it works

If you are happy with the answers you got, please the following about how to assign points:
http://forums.itrc.hp.com/service/forums/helptips.do?#33