12c : PSU vs Database Proactive Bundle Patch [DBBP]

Toad installation

1) Download the commercial version of toad as below
Useful info while downloading
Toad for Oracle Xpert Edition
Add-Ons: DB Admin
License key: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Site Message:

2) From https://support.software.dell.com/kb/17322

To download:
1. Go to https://software.dell.com
2. At the top right, click on ‘Sign in’ to login with email and password. If not yet registered, the ‘Sign in’ window should have a ‘Register’ link available too).
3. On the Support page, Select the Self Service Tool “Download New Releases”
4. Type in the product name and click ‘GO’.

A list of search results will display. Use the “All Categories” drop down to filter the results further. Select the “DOWNLOAD” button to download the appropriate release. You will be offered additional downloads to add to your download folder.

NOTE: Choose “Download Now” and save locally or Select “Download Now” to keep looking for other items to download. When you are ready, you will see your “my downloads” cart in the upper right hand of the screen under the Search box.

3) After double clicking .exe file , accept the terms and enter the valid license information

toad1

4)

toad2

It will ask for the oracle client if it not there on your system. Asking you to pick the path of the downloaded oracle client zip file location and TNS_ADMIN patch as well.
TNS_ADMIN :This is the path where u will be storing the tnsnames.ora file which has database connection strings.

Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
instantclient-basic-windows.x64-12.1.0.2.0.zip (72,416,242 bytes) (cksum – 1751087003)

toad3

Follow the next button and it concludes the toad installation

Sample tnsnames.ora entry is as below

PD01FWD.IBM.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxx.0.0.1)
(PORT=1522)
)
(CONNECT_DATA=
(SERVICE_NAME=<dbname>)
)
)

Port forward setup in secure CRT.
=================================
Edit the ..ini file at the location C:\Users\\AppData\Roaming\VanDyke\Config\Sessions for port forwarding setting.
Like pd01.ibm.com

Database entries Something like this
Pd01|1521|1|pd01.xxxxx.com|1521||

Wish you a happ…

Wish you a happy and prosperous new year to all the folks…..Hope to see new year brings lots of Happy DBAing…. 🙂