About

Martin Klier

usn-it.de

ORATOP in Oracle 19c

In 19c , the useful utility “oratop” is shipped with the Oracle Home installation. It was linked to the recent libaries, and its command line syntax changed.

Error

This leads to errors when calling one of the old “download” binaries like oratop12c-64.bin in a 19c environment:

/home/oracle/bin/oratop12c-64.bin: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory

Reasons

The binary was dynamically linked against a 12c environment. libclntshcore.so.12.1 is not available in 19c.

Solution

Even though you could create a symlink to the 19c library, I’d recommend to use the 19c “onboard” version of oratop, instead of the “download” version. 19c is shipped with this very helpful utility in $ORACLE_HOME/suptools/oratop/oratop.

Heads up: Oracle changed the syntax a bit – check with “$ORACLE_HOME/suptools/oratop/oratop -h” and compare how you called it until today.

My new script for oratop looks like this, old call commented:

#!/bin/bash
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
# /home/oracle/bin/oratop12c-64.bin -dmfi1 / as sysdba $@
/u01/app/oracle/product/19/db_1/suptools/oratop/oratop -rmfi1 / as sysdba $@

Hope this helps
Martin

Oracle Database 18c changed MRP checkpointing from log boundary to time-based
Make Linux Disk IDs Visible for UDEV (in VMware)

One thought on “ORATOP in Oracle 19c

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.