Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Backup Exec 12 Pre-Command PL/SQL Script

Created: 27 Jan 2011 | 6 comments

I am trying to run an Oracle pl/sql script in a pre-command. Everytime I run the job it will complete without error, but the pl/sql script does not execute its commands.

The pl/sql script successfully runs from the cmd line.

The pre-command is:  D:\cvs_home\COR\binaries\scripts\backup\arclog_precmd.cmd.

The script in the .cmd file is: SQLPLUS sys/***** as sysdba @D:\cvs_home\COR\binaries\scripts\backup\arclog_precmd.sql

The script's path is in the enviroment variables and I have tried to run it under the host system account, administrator account and Oracle system account with no success.

I have successfully run a test pre-command, that executed a simple batch delete from the same directory as the pl/sql script.

Backup Exec 12.0 rev.1364

Windows 2008

Oracle 11gR2

Thanks,

BBetancourt

Comments 6 CommentsJump to latest comment

pkh's picture

I have tried to run it under the host system account, administrator account and Oracle system account with no success

Before you can run a script as a pre-/post-command, it must run successfully by itself.  You got to trouble-shoot the script.

Colin Weaver's picture

Make sure that the script can manually run when logged into the server console as:-

a) the Backup Exec Servcie Account

b) the Backup Exec System Logon Account (they may not be the same)

c) the Account crendential used in the Backup Job

Also put a command in the start of the script that creates some text output (i.e. the time/date) inside a text file when it runs - as this will help you confirm that the .CMD file itself is trying to start.

BBetancourt's picture

The Backup Exec Service Account and the Backup Exec System Logon Account is the "LocalSystem account" as indicated in Symantec documentation.

The  LocalSystem account cannot be logged into under Windows.

Should I have tried to run the services under the Administrator account and the pre-command test job would fail.

pkh's picture

The Backup Exec Service Account and the Backup Exec System Logon Account is the "LocalSystem account" as indicated in Symantec documentation.

Which documentation are you refering to?  The Admin Guide says that if the server is part of a domain, you are to use a domain administrator for the BESA and the BESLA. Otherwise, you use a local administrator account.

Ignoring BE for the moment, have you ever successful run your script under any account?

Also, do note that Oracle 11g R2 is not supported by any version of BE.

itsmeaffinity's picture

Hi

Can you post the job log for  same 

Thank You

If this information helps you, please mark it as solution.

Thank You.

pkh's picture

What good would the job log do?  He is trying to trouble-shoot why his script does not run.