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
Deploying Dell Toad for Oracle (64bit) Extract the MSI files from the EXE. If this link does not work, the short story is add /extract to the end of the EXE to get the MSI files I already had the licence key from our software team. These are the steps I created for Toad MST 1. Changed the Schema to 405 2.
The Site Message is typed in incorrectly. The a key not meant for Toad Data Point is beign used. Note, regular Toad for Oracle licenses are no longer accepted in Toad Data Point 3.2 and newer. Only older versions of Toad for Data Analysts will work with Toad for oracle keys. Both the key and site message need to be registered. Feb 20, 2019 The “Toad for Oracle Product Licensing Console” or easier said “License File” shows in the “site message” field the name of the end user organization that obtained the license key. If and when the site message reflects a name that is not referring to your end user organization (and typically includes a strange site message) then. Site Message: ELECTRONIC ARTS INC. Fath on Oracle SQLplus. Toad® for Oracle the leading Oracle developer and database. Including access to user community forums on Toad World directly from Toad. Toad Authorization Key Generator is a software used to generate Authorization Key according to Site Message for various Toad Software. Jun 28, 2019 Yes, you should be receiving an e-mail with a trial key; however, you can also simply start the Toad for Oracle trial version and that will get you started with an initial key. In the meantime, feel free to let us know if you have any questions.
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
4)
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)
Follow the next button and it concludes the toad installation
Download Toad For Oracle
Sample tnsnames.ora entry is as below
License Key Generator
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:UsersAppDataRoamingVanDykeConfigSessions for port forwarding setting.
Like pd01.ibm.com
Database entries Something like this
Pd01|1521|1|pd01.xxxxx.com|1521||