Return Code 127

[jbagley]

Hi All



Hopefully someone out there can help me with this



We are running Oracle 8.17.4 on AIX 4.3.3.



I have successfully installed, configured the TDP for Oracle version 2.2.1.



Rman has been configured and backup’s successfully when the scripts are run from the command line.



My problem is that when we schedule the backup we are getting the following error: -



05/09/03 09:38:38 Session established with server TSM: Windows

05/09/03 09:38:38 Server Version 5, Release 1, Level 5.4

05/09/03 09:38:38 Server date/time: 05/09/03 09:42:27 Last access: 05/097



05/09/03 09:38:38 Executing Operating System command or script: ./u01/app/oracle/admin/LIVE/backup/rmanlive_hotbu.sh



05/09/03 09:38:38 Finished command. Return code is: 127

05/09/03 09:38:38 ANS1909E The scheduled command failed.

05/09/03 09:38:38 ANS1512E Scheduled event 'SWIFT_LIVE_RMAN_BACKUP' failed. .

05/09/03 09:38:38 Sending results for scheduled event 'SWIFT_LIVE_RMAN_BACKUP.

05/09/03 09:38:38 Results sent to server for scheduled event 'SWIFT_LIVE_RMAN.



Any assistance would be appreciated



Thanks

John

E-mail [email protected]

 

[DavidWhite]

Hi



I believe some environmental variables are not set in your RMAN calling script - /u01/app/oracle/admin/LIVE/backup/rmanlive_hotbu.sh



Ensure that all environment variables are defined in the script and the user executing the script has permissions to run RMAN.



The error 127 returned from the script is "command not found".



Regards

David

 

[jbagley]

Hi David



Thanks for the info.

I have checked all the settings and all looks ok.

Our error has now changed, it it: -



05/16/03 11:02:05

Executing Operating System command or script:

/u01/app/oracle/admin/LIVE/backup/rmanlive_archbu.sh

05/16/03 11:02:07 Finished command. Return code is: 1

05/16/03 11:02:07 ANS1909E The scheduled command failed.

05/16/03 11:02:07 ANS1512E Scheduled event 'SWIFT_RMAN_LOGS' failed. Return code= 1.

05/16/03 11:02:07 Sending results for scheduled event 'SWIFT_RMAN_LOGS'.

05/16/03 11:02:09 Results sent to server for scheduled event 'SWIFT_RMAN_LOGS'

.





John

 

[DavidWhite]

Hi



Only suggest: Try a step by step approach.

The script runs at the command prompt, so try getting it to run from CRON as database owner.



Once that works, try running from command prompt as the TSM scheduler user. Than try from CRON as TSM scheduler user.



Hope this helps

David