Saturday, June 21, 2025

ORA-28376: cannot find PKCS11 library

 Verify permission for 


cd /opt

find oracle -exec ls -ld {} \;

See if all the directories are owned by root and it takes read to world

If so fix it; by granting 0755 to all the sub directories from /opt/oracle/....

proper permission:


[oracle@vcentos79-oracle-ggtgt ~]$ find /opt/oracle -exec ls -ld {} \;

drwxr-xr-x. 3 root root 20 Sep  6  2024 /opt/oracle

drwxr-xr-x. 3 root root 16 Sep  6  2024 /opt/oracle/extapi

drwxr-xr-x. 3 root root 17 Sep  6  2024 /opt/oracle/extapi/64

drwxr-xr-x. 3 root root 20 Sep  6  2024 /opt/oracle/extapi/64/hsm

drwxr-xr-x. 3 root root 19 Sep  6  2024 /opt/oracle/extapi/64/hsm/oracle

drwxr-xr-x. 2 root root 27 Sep  6  2024 /opt/oracle/extapi/64/hsm/oracle/1.0.0

-rwxr-xr-x. 1 root root 8924633 Sep  6  2024 /opt/oracle/extapi/64/hsm/oracle/1.0.0/liborapkcs.so

[oracle@vcentos79-oracle-ggtgt ~]$


Friday, June 13, 2025

How to draw interactive diagram using draw.io

How to draw an interactive diagram in draw.io website

Objective: Use draw.io web tool to create an interactive diagram to demonstrate the technical solution to the teams

url: https://app.diagrams.net/ [aka draw.io]
custom code: https://jgraph.github.io/drawio-tools/tools/link.html

Our goal: Show data migration options for oracle db

About draw.io:
security first tool.
Always store your document or presentation or diagram on your local machine or your personal drive.
Downloadable desktop app is available on their website. So you can work offline.

The content is stored on draw.io server only when you convert the files to image, pdf etc...
But they will be deleted is what they claim as soon as the processing is done.

I still use it without any identity information documented in draw.io.

So steps for interactive diagram:

step1: hit to the url
step2: create your diagram
step3: make it interactive by creation actions using custom links (ctrl+k & json code)
step4: Publish the file for presentation by going to files menu

Enjoy an interactive diagram you were looking for and be smart.

Thanks

Flashback data archive steps

 Objective: Ways to track DML changes in a table Detailed objective: We should be able to track the changes in the table at any point in tim...