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
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.
