morop.blogg.se

The above views are populated when catbundle.sql is executed. …and for pre-12c database versions: COL comments FOR A30 SELECT description, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time SELECT comments, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time To check the registered database version (12c upwards): COL comments FOR A70 (The first command above being for Linux) Conclusion: If you are checking what Oracle Version you are running then you can use above query which will show you the correct database version running on Linux or windows. $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'DATABASE PSU|DATABASE PATCH SET UPDATE'

To check the Oracle Home version: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i -E 'DATABASE PSU|DATABASE PATCH SET UPDATE' Unfortunately they do not change version numbers in the Oracle binaries, product banners and such though (see MOS 861152.1), so here’s how to identify which PSU your ORACLE_HOME is at… Oracle PSUs (Patch Set Updates) are referenced by their 5-place version number. When using a Linux service script to start Advanced Server, be sure LD_LIBRARY_PATH has been set within the service script so it is in effect when the script invokes the pg_ctl utility to start Advanced Server.įor Windows only: To set the oracle_home configuration parameter in the postgresql.How to check which PSU is installed…if any How to determine which Release version of Oracle is installed. The LD_LIBRARY_PATH environment variable on Linux ( PATH environment variable or oracle_home configuration parameter on Windows) must be set properly each time you start Advanced Server. How to check which release version of Oracle is running. The value specified in the oracle_home configuration parameter will override the Windows PATH environment variable. Set the LD_LIBRARY_PATH environment variable on Linux (or PATH on Windows) to the lib directory of the Oracle client installation directory.įor Windows only, you can instead set the value of the oracle_home configuration parameter in the nf file. Toggle Wrap Copy ln -s libclntsh.so.12.1 libclntsh.soīefore creating a link to an Oracle server, you must tell Advanced Server where to find the OCI driver.