1. Reviewing Listener Logs

    Submitted by dave on Wed, 03/04/2020 - 14:52

    Assumption is for a 4-node RAC with nodes named exadb01/exadb02/exadb03/exadb04.
    Gather all the logs

  2. Can GoldenGate replicate to previous versions of the same vendor?

    Submitted by dave on Mon, 11/25/2024 - 14:45

    I’ve seen it done on Oracle before like replicating 11 -> 10 or 11->9. The intermediate format for GoldenGate has been standard forever, so as long as you have GG binaries certified to connect to each database then theoretically it should be possible to get them to interact with these intermediate files and extract or replicate as needed.

    Tags: 
    GoldenGate
    mysql
    oracle

  4. SQL Developer New Direction - Installing in a secure environment...

    Submitted by dave on Mon, 09/30/2024 - 16:16

    I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports.
    Time for some shameless self promotion!


    • Here is a presentation I gave to East Coast OUG on 2014 - SQL Developer Reporting. It covers general SQL Developer reporting features and a deep dive into User Defined Reports.
    Tags: 
    SQL Developer
    VSCode

  5. GET PL/SQL Example (Retrieve)

    Submitted by dave on Wed, 09/18/2024 - 12:17

    Description : Basic GET example with option for subsstring search
    Method : GET
    Source Type : PL/SQL
    Returns : 200 for normal completion, ORDS generated messages if error

  6. POST PL/SQL Example (Creation)

    Submitted by dave on Wed, 09/18/2024 - 12:25

    Description : Basic POST creation example
    Method : POST
    Source Type : PL/SQL
    Returns : 201 for normal creation, 400 for caught exceptions, ORDS generated messages if other error

  7. PUT PL/SQL Example (Update)

    Submitted by dave on Wed, 09/18/2024 - 13:17

    Description : Basic PUT Update Example
    Method : PUT
    Source Type : PL/SQL
    Returns : 200 for normal update, 400 for caught exceptions, ORDS generated messages if other error

  8. SQL to help diagnose issues in a pinch...

    Submitted by dave on Fri, 10/03/2008 - 17:19

    My Session Info

    -- My Session Info
select username, sid, serial#, terminal, program, machine from v$session where sid=userenv('sid');

    List Blocking Sessions
    By: Natalka Roshak

  9. PL/SQL Rest APIs - Best Practices

    Submitted by dave on Thu, 02/29/2024 - 12:49

    Resource Handler PL/SQL

  10. The dreaded ORA-29024: Certificate validation failure... how to approach...

    Submitted by dave on Wed, 02/14/2024 - 16:10

    Certificates can be a pain.

    So if you're trying to use UTL_HTTP or APEX_WEB_SERVICE to reach https destinations you'll be on the hook for obtaining certificates for the target server.

    I had access to all the certificates separately and loaded them into a nice fresh new wallet. Unfortunately I couldn't get this to work. I'm working an SR with Oracle now but there doesn't seem to be much expertise on troubleshooting issues, even with

    Tags: 
    UTL_HTTP
    API

  11. AI Topics

    Submitted by dave on Tue, 01/30/2024 - 21:08

    Verifying tensorflow install
    python -c "import tensorflow as tf; print(tf.config.list_physical_devices('GPU'))"

  12. Recording query output in a self contained shell script...

    Submitted by dave on Fri, 12/22/2023 - 11:59

    General form

    #!/bin/bash
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_SID=orclcdb1
export PATH=$ORACLE_HOME/bin:$PATH

while [ true ]
do
  sqlplus -s / as sysdba  >> output.txt << EOF
SELECT * FROM DUAL;
EXIT
EOF
  sleep 10
done

    Session Serialization Example

    Tags: 
    shell scripting

  13. Intern Advice

    Submitted by dave on Mon, 10/02/2023 - 15:34

    [A]dvocacy - You can have the best ideas in the world but if you can't get advocacy from management and peers then it can't move forward.
    [B]ridging -
    [C]ontext - Where is your solution running? Local PC? Server in your building?
    [D]efinitions - Be clear with what you are saying. Reduce slang and acronynms depending on your audience.
    [E]
    [F]

    Tags: 
    mentoring

  14. Connection encryption is killing my performance! Help!

    Submitted by dave on Mon, 10/22/2018 - 23:11

    I find Encryption is blamed for a lot of performance issues so wanted to find out for myself how much of a performance hit we might be taking for common operations. There ain't no free lunch. Adding any extra processing or manipulation to an operation is going to add time to that operation.

    Tags: 
    ASO
    TDE
    encryption
    aes256
    3des168

  15. Querying the SQL Running During an ASH Sample

    Submitted by dave on Fri, 02/07/2014 - 10:50 
    -- 1) Survey the sampling activity near the interesting event 
SELECT DISTINCT SAMPLE_ID, SAMPLE_TIME 
  FROM DBA_HIST_ACTIVE_SESS_HISTORY 
WHERE INSTANCE_NUMBER=:INSTNUM
AND SAMPLE_TIME > TO_DATE('2014-02-07 08:00','YYYY-MM-DD HH24:MI')
AND SAMPLE_TIME < TO_DATE('2014-02-07 09:00','YYYY-MM-DD HH24:MI')
ORDER BY 2;

    -- 2) Get SQL running during the sample time
SELECT DHS.SQL_TEXT, 
       ASH.* 
  FROM DBA_HIST_ACTIVE_SESS_HISTORY ASH LEFT OUTER JOIN DBA_HIST_SQLTEXT DHS 
       ON ASH.SQL_ID=DHS.SQL_ID

  16. python-oracledb the easy way on Linux

    Submitted by dave on Mon, 09/11/2023 - 12:37 
    cd ~
mkdir pyenv
cd pyenv
python -m venv tutorial-env
source tutorial-env/bin/activate
pip install --upgrade pip
python -m pip list
python -m pip install oracledb --upgrade

    You can now test this. Below test is for Thick Client since I already had an Instant Client installed and configured:

  17. Oracle Enterprise Manager / Cloud Control

    Submitted by dave on Mon, 02/27/2012 - 15:43

    Environment Overview
    To show info about currently running OMS including URLS, ports, and paths: 

    cd $OMS_HOME/bin
./emctl status oms -details

    Reset Weblogic Admin Password
    12c , 13c Cloud Control: Steps for Modifying the Password for Weblogic and Nodemanager User Accounts in the Enterprise Manager Installation (Doc ID 1450798.1)
    Reset Weblogic Admin Server Password
    Querying the Management Repository

  18. Quick and dirty query timing script...

    Submitted by dave on Mon, 06/19/2023 - 12:43

    A script to check the query execution time as well as the time to retrieve all records via a FOR cur IN construct:

    Tags: 
    sql
    performance
    timing

  19. Environment Build - Testing

    Submitted by dave on Wed, 04/26/2023 - 13:25 

    sudo vi /etc/systemd/system/kubelet.service.d/10-kubeadm.conf

    Add:

  20. Kubernetes Common Commands

    Submitted by dave on Wed, 04/26/2023 - 13:11 
    kubectl get nodes
kubectl get nodes -o wide

kubectl get pods
kubectl describe pod [podname]


kubectl exec [podname] -it -- /bin/sh

  21. Kubernetes Topics

    Submitted by dave on Tue, 04/25/2023 - 14:52

  22. Streaming

    Submitted by dave on Fri, 05/08/2020 - 18:00

    Goals:

    • Live stream a class lesson with ability to show multiple camera shots and slides.
    • Provide interactivity to ensure participants are

    Why do people come to classes in person?

    • Learn new things
    • Community
    • Learn with Opportunity to ask questions
    • Have a great experience

    Proof of Concept Goals

    • Present Welcome screen
    • Present main camera
    • Present cutting table camera
    • Show slides
    • Accept chat questions from Zoom attendees
    • Present Goodbye Screen

    How can we accomplish this?

  23. Application Express Helpful Queries

    Submitted by dave on Thu, 01/26/2023 - 11:36

    Find Apex Installations

    SELECT * FROM ALL_USERS WHERE USERNAME LIKE 'APEX%';

    Find Apex Workspaces

    SELET WORKSPACE FROM APEX_nnnnnn.APEX_WORKSPACES;

    Find Apex Users

    SELECT USER_NAME FROM APEX_nnnnnn.WWV_FLOW_FND_USER;

  24. Operating System Monitoring

    Submitted by dave on Fri, 10/03/2008 - 17:20

    Solaris

    $ /usr/sbin/prtconf |grep -i "Memory size"
    $ swap -s
    $ df -k
    $ /usr/local/bin/top
    $ vmstat 5 100
    $ sar -u 2 100
    $ iostat -D 2 100
    $ mpstat 5 100

    #Solaris: Total Memory Size:
    /usr/sbin/prtconf 2>&1 | grep -i "Memory size" | awk '{print $3" mb"}'
    #Solaris: Free Memory size:
    vmstat 2 2 | tail -1 | awk '{print $5/1024" mb"}'

    ps -ef | grep smon | grep -v grep

    HP-UX 11.0

    $ grep Physical /var/adm/syslog/syslog.log
    $ df -k
    $ sar -w 2 100
    $ sar -u 2 100
    $ /bin/top
    $ vmstat -n 5 100
    $ iostat 2 100
    $ top

  25. Oracle XE 21c on Centos 8

    Submitted by dave on Mon, 04/25/2022 - 18:03

    Why XE 21c?
    For development or small sites, 21c is a great way to test the waters with Oracle. As per the press release - "You get an Oracle Database to use in any environment, plus the ability to embed and redistribute – all completely free!"

    Features:

    • 2 CPU threads
    • 2 GB of RAM
    • 12GB of user data
    • Supports Pluggable databases

    Resources: