Post-upgrade tasks

Perform the following steps:

1. Copy the following files from database server to application server in case of the distributed environment as a user oracle. Path of the files: /appl/oracle/product/12.1.0.2.0/db_1/network/admin/
   • listener.ora
   • tnsnames.ora
   • sqlnet.ora
2. Run the following command in the application server as user virtuo:

   ksh <package_location>/wireless_db_post_install.ksh
   ksh wireless_db_post_install.ksh
   This will perform SCHEMA UPGRADE do you want to continue? [Y]
   Y
   OK, continuing...
   Post-upgrade updates for TNPM Wireless Version 1.4.4
   Enter Oracle DB sys password:
   Adding Changes for Reenqueueing messages feature
   No errors.
   No errors.
   No errors.
   No errors.
   No errors.
   No errors.
   No errors.
   No errors.
   Post-upgrade updates for TNPM Wireless Version 1.4.4 completed

   Note: <package_location> is the directory where the Tivoli Netcool Performance Manager 1.4.4 Wireless packages are located.
3. Ensure that environment variable JAVA_TOOL_OPTIONS for virtuo user is correctly set as follows:

   env | grep JAVA_TOOL_OPTIONS
   JAVA_TOOL_OPTIONS=-Doracle.jdbc.autoCommitSpecCompliant=false

   If it is not set, run following as user virtuo and confirm that it is set correctly by using these commands:

   echo ’export JAVA_TOOL_OPTIONS=-Doracle.jdbc.autoCommitSpecCompliant=false’ >> 
   /export/home/virtuo/.profile
   

   source /export/home/virtuo/.profile as virtuo user

   Set JAVA_TOOL_OPTIONS in /appl/virtuo/conf/as/jvm-default.ini by adding the following line:

   -Doracle.jdbc.autoCommitSpecCompliant=false

   it must appear as follows:

   
   -Xcompressedrefs -Xms1024m -Xmx1024m -XX:+AggressiveHeap -XX:MaxPermSize=96m -Doracle.jdbc.autoCommitSpecCompliant=false