Averify script run issue

I am getting Incorrect database error while trying to run averify.sh . We have application installed on the same system where the database resides.

Generally we run XXXenv.sh to set the environment before running any SQL scripts but I cant figure out how to accomodate the below values into the averify.sh or averify.properties files.

export ORACLE_HOME=/app/oracle/product/11.2.0/db_1
export ORACLE_SID=aglstg01
export PATH=$ORACLE_HOME/bin:$PATH

Add Comment
1 Answer(s)
Best answer

You would modify the following settings in averify.properties :
averify.dest.jdbc.url = jdbc:oracle:thin:@<server name>:<instance port>/aglstg01
averify.dest.tns.name = aglstg01
averify.dest.oracle.home = /app/oracle/product/11.2.0/db_1

 Note that you would still have to specify the server name and Oracle instance port number (usually 1521) in the above.  I don’t think you need to worry about the path, Averify knows how the Oracle directories are set up and uses the definition for averify.dest.oracle.home to run stuff. Also note that I am assuming that “aglstg01” is defined in tnsnames.ora so that the specification for “averify.dest.tns.name” will work, otherwise just leave it blank.

Agile Angel Answered on June 25, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.