By Franck Pachot
If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 220.127.116.11 only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the names have changed and can be misleading: PSU for 18.104.22.168 (no Proactive Bundle Patch except for Engineered Systems). 22.214.171.124 can have SPU, PSU, or Proactive BP but the latest is highly recommended, especially now that it includes the adaptive statistics patches. 126.96.36.199 introduce the new RUR and RU, the latest one being the one recommended.
To get things clear, there’s also the Master Note for Database Proactive Patch Program, with reference to one note per release. This blog post is my master note to link directly to the recommended updates for Oracle Database.
Master Note for Database Proactive Patch Program (Doc ID 756671.1)
188.8.131.52 – PSU
Database 184.108.40.206 Proactive Patch Information (Doc ID 2285559.1)
Paragraph -> 220.127.116.11 Database Patch Set Update
18.104.22.168 – ProactiveBP
Database 22.214.171.124 Proactive Patch Information (Doc ID 2285558.1)
Paragraph -> 126.96.36.199 Database Proactive Bundle Patches (DBBP)
Latest as of Q1 2018 -> 16-Jan-2018 188.8.131.52.180116 Database Proactive Bundle Patch (Jan 2018) 184.108.40.206.180116 27010930
220.127.116.11 – RU
Database 18.104.22.168 Proactive Patch Information (Doc ID 2285557.1)
Paragraph -> 22.214.171.124 Database Release Update (Update)
Don’t forget SQL Developer
In the 12c Oracle Home SQL Developer is installed, but you should update it to the latest version.
Download the following from http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
– The SQL Developer zip for ‘Other Platforms’, currently 17.4
– The SQLcl zip for ‘All Platforms’, currently 17.4
On the server, remove, or rename the original directory:
mv $ORACLE_HOME/sqldeveloper $ORACLE_HOME/sqldeveloper.orig
Unzip what you have downloaded:
unzip -d $ORACLE_HOME/ sqldeveloper-*-no-jre.zip
unzip -d $ORACLE_HOME/sqldeveloper sqlcl-*-no-jre.zip
I suggest to have a login.sql which sets the beautiful ansiconsole for SQLcl:
echo "set sqlformat ansiconsole" > $ORACLE_HOME/sqldeveloper/sqlcl/login.sql
On 12.2 you can run SQLcl just with ‘sql’ (and same arguments as sqlplus: / as sysdba or /nolog,…) because this is what is defined in $ORACLE_HOME/bin.
However, it sets the current working directory and i prefer to keep the current one as it is probably were I want to run scripts from.
Then I add the following aliases in .bashrc
alias sqlcl='JAVA_HOME=$ORACLE_HOME/jdk SQLPATH=$ORACLE_HOME/sqldeveloper/sqlcl bash $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql'
When running SQL Developer for the first time you can create automatically a ‘/ as sysdba’ connection (but remember this is not a good practice to connect like this) and a connection for each user declared in the database: Right click on Connections and Create Local Connections