Autonomous Database with HammerDB

Summary of the basic steps to configure HammerDB with Oracle's Autonomous Database either shared or dedicated.

1. Download and install Oracle Database Client on client machine which is hosting HammerDB
   
2. Optionally it is recommended practice to patch the client to the latest version, today that is 19.7
3. set environment variable Oracle_HOME
4. Download the wallet for the database you will be using with HammerDB
5. Unzip the wallet , modify sqlnet.ora and set TNS_ADMIN to your wallet
6. Modify oracle.xml file in your hammerdb/config directory
7. Verify above settings

My Environment:

• Windows jump server
  
• Linux Compute VM to host hammerdb
• ADB on Dedicated Quarter Rack
• ADB on Shared Infrastructure
• all on same VCN
  

Steps:

#1   Download and install latest Oracle Database Client which currently is 19.3 onto your linux compute VM.

#2 Skipping this step

#3   Set the environment variable ORACLE_HOME to your client on .
       i.e.   export ORACLE_HOME=/home/opc/app/opc/product/19.0.0/client_1

#4   Download the wallet  for the database you will be using onto  your linux compute VM

  

#5  Unzip the wallet onto your linux compute VM and set TNS_ADMIN to this directory

        export TNS_ADMIN=/home/opc/wallet_phxhammer1

 

Also modify the sqlnet.ora to point to this directory.

#6  Either modify the oracle.xml in  the config directory within the hammer directory or use the GUI.   Make the following changes in config.xml:

• system_user = admin
• system_password = your_admin_password
• instance = use one of the defined services   i.e.  phxhammer1_tp
• tpcc_user = tpcc
• tpcc_pass = insert password for the tpcc user
• tpcc_def_tab = DATA
• tpcc_def_temp= TEMP 

Here is a portion of the config file:





#7 start HammerDB  and verify connection


    

Lots of cruise ships in Port Miami

Twelve cruise ships together

Twelve cruise ships partying together on the seas including three of 4 largest cruise ships.

Three Sisters Meet

Arnie's Rainbow

Shortly after the ceremony and the spreading of the ashes of Arnold Palmer at his Latrobe Country Club, something amazing happened. A rainbow appeared over Latrobe.



Very similar to his logo.     God Bless you Arnold Palmer.   

Roaming Catholics

Stations of the Cross

from Holy Love:

"I am your Jesus, born Incarnate.  It is My desire this Holy Thursday night to give to the world lessons on the Way of the Cross.  I suffered for all sins and for specific sins at each station.  Listen." 

1) "The first station commemorates My condemnation to death.  I suffered for all who are condemned falsely and all who are unrepentant."
2) "The second station represents My acceptance of My Cross.  How many refuse despite all their sins to carry their cross."
3) "The third station is My first fall.  So many slip into sin and become discouraged by one fall."
4) "The fourth station commemorates My encounter with My Mother.  How often souls have the opportunity to console those in need but never do it."
5) "The fifth station represents Simon's reluctance to assist Me.  So many souls desire to be close to Me but try to do so without carrying their cross."
6) "The sixth station remembers Veronica wiping My Face.  Think how she had to die to herself, setting aside her own safety and welfare in order to comfort Me.  Be self-effacing."
7) "This station represents another fall.  Do not fall into sinful habits."
8) "The eighth station remembers My consoling the women of Jerusalem.  Allow Me to be your consolation when others fail you."
9) "The ninth station recalls another fall.  Search your hearts and overcome recurrent sinful patterns."
10) "The tenth station recalls how I was stripped of My Garments.  Strip your hearts of all vanity."
11) "The eleventh station recalls how I was nailed to the cross.  It was My Father's Will that held Me to the cross though the nails pierced My Flesh.  Be devoted to the Will of My Father."
12) "The twelfth station commemorates My Death.  Do not worship this life which is passing.  Let your hearts ascend to Heaven."
13) "The thirteenth station sees Me taken down from the cross.  This death of Mine was a victory in disguise.  How many do not see the disguises Satan wears?"
14) "The fourteenth station - I am laid to rest in the sepulcher.  Do not rest in doing good and opposing evil until it is time for your eternal rest.  So many waste precious moments given to them to earn their salvation." 

A Great Justice

From Holy Love:

 "I am your Jesus, born Incarnate." "The Justice* that came to Me yesterday was a man of Truth and principle. He defended the constitution at every turn. He was unafraid of others opinions but called error as error. Now, this president has another opportunity to demoralize the fabric of this nation. The foundation of the constitution is at stake and will be challenged. Pray. Pray. Pray."

 * U.S. Supreme Court Justice Antonin Scalia (3/11/1936 - 2/13/2016)