Category: Client

Could not load program sqlplus:Dependent module libsqlplus.so could not be loaded. Could not load module libsqlplus.so

Trying to run sqlplus from Oracle 19c client on AIX, the following errors occur:

$ sqlplus

Could not load program sqlplus:

        Dependent module libsqlplus.so could not be loaded.

Could not load module libsqlplus.so.

System error: No such file or directory

SOLOTION

$ oslevel

7.1.0.0


$ export LIBPATH=$LIBPATH:/u01/oracle/product/19.0.0/client_1/lib

It seems AIX does not use LD_LIBRARY_PATH.

[FATAL] [INS-32042] The Installer has detected that the user (oracle) is not member of the central inventory group

Silent installation of Oracle client 19c gets the following fatal error:

[FATAL] [INS-32042] The Installer has detected that the user (oracle) is not member of the central inventory group:
   ACTION: Make sure that the user (oracle) is member of the central inventory group ().
INFO:  [Nov 26, 2023 12:08:20 PM] Advice is ABORT

CAUSE

Check oraInst.loc file, and found inst_group is empty for some reason.

$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=

SOLUTION

Gives inst_group variable in /etc/oraInventory the right value.

$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

How to Clone 11.2 Oracle Client Software

Client accidently uninstalled Oracle 11.2 Oracle client. Here is the quick way to clone 11.2 Oracle client from another server installations.

Make a tar or zip of the Oracle Client home from another server.

$ tar -cvf 11204.tar ./client_1

2. scp the tar file to the server

3. Untar the file to the location of the same directory path like the source server. 

$cd /u01/app/oracle/product/11.2.0.4

$tar -xvf 11204.tar

4. Clone the home

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/client_1

export PATH=$ORACLE_HOME/bin:$PATH:

The run the following command in one line:

$ORACLE_HOME/oui/bin/runInstaller -silent -clone ORACLE_BASE="/u01/app/oracle/"  ORACLE_HOME="/u01/app/oracle/product/11.2.0.4/client_1" ORACLE_HOME_NAME="Oracle11204_client" -invPtrLoc="/u01/app/oracle/oraInventory"

Oracle 19c deinstall fails with “ERROR:null” on RHEL 8

Trying to deinstall Oracle 19c client, the follow error occures: 

$ /u01/oracle/product/19.15/client_1/deinstall/deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinstall2023-08-15_12-46-41PM/logs/

############ ORACLE DECONFIG TOOL START ############


######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /u01/oracle/product/19.15/client_1
Oracle Home type selected for deinstall is: Oracle Database Client
Oracle Base selected for deinstall is: /u01/oracle/product
Checking for existence of central inventory location /u01/oracle/product/oraInventory
ERROR: null

SOLUTION

$ export CV_ASSUME_DISTID=OL7

Then deinstall works fine:

$ /u01/oracle/product/19.15/client_1/deinstall/deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinstall2023-08-15_12-50-44PM/logs/

############ ORACLE DECONFIG TOOL START ############


######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /u01/oracle/product/19.15/client_1
Oracle Home type selected for deinstall is: Oracle Database Client
Oracle Base selected for deinstall is: /u01/oracle/product
Checking for existence of central inventory location /u01/oracle/product/oraInventory

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /tmp/deinstall2023-08-15_12-50-44PM/logs/netdc_check2023-08-15_12-50-49PM.log

Network Configuration check config END


######################### DECONFIG CHECK OPERATION END #########################


####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/oracle/product/19.15/client_1
Inventory Location where the Oracle home registered is: /u01/oracle/product/oraInventory
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/tmp/deinstall2023-08-15_12-50-44PM/logs/deinstall_deconfig2023-08-15_12-50-49-PM.out'
Any error messages from this session will be written to: '/tmp/deinstall2023-08-15_12-50-44PM/logs/deinstall_deconfig2023-08-15_12-50-49-PM.err'

######################## DECONFIG CLEAN OPERATION START ########################

Network Configuration clean config START

Network de-configuration trace file location: /tmp/deinstall2023-08-15_12-50-44PM/logs/netdc_clean2023-08-15_12-50-49PM.log

De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END


######################### DECONFIG CLEAN OPERATION END #########################


####################### DECONFIG CLEAN OPERATION SUMMARY #######################
#######################################################################


############# ORACLE DECONFIG TOOL END #############

Using properties file /tmp/deinstall2023-08-15_12-50-44PM/response/deinstall_2023-08-15_12-50-49-PM.rsp
Location of logs /tmp/deinstall2023-08-15_12-50-44PM/logs/

############ ORACLE DEINSTALL TOOL START ############





####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/tmp/deinstall2023-08-15_12-50-44PM/logs/deinstall_deconfig2023-08-15_12-50-49-PM.out'
Any error messages from this session will be written to: '/tmp/deinstall2023-08-15_12-50-44PM/logs/deinstall_deconfig2023-08-15_12-50-49-PM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to testhost
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2023-08-15_12-50-44PM/oraInst.loc
Setting oracle.installer.local to false

## [END] Preparing for Deinstall ##

Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Detach Oracle home '/u01/oracle/product/19.15/client_1' from the central inventory on the local node : Done

Delete directory '/u01/oracle/product/19.15/client_1' on the local node : Done

Delete directory '/u01/oracle/product/oraInventory' on the local node : Done

Failed to delete the directory '/u01/oracle/product/11.2.0.4/client'. Either user has no permission to delete or it is in use.
The Oracle Base directory '/u01/oracle/product' will not be removed on local node. The directory is not empty. User needs to manually cleanup this directory.

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##


## [END] Oracle install clean ##


######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/oracle/product/19.15/client_1' from the central inventory on the local node.
Successfully deleted directory '/u01/oracle/product/19.15/client_1' on the local node.
Successfully deleted directory '/u01/oracle/product/oraInventory' on the local node.
Oracle Universal Installer cleanup was successful.


Run 'rm -r /etc/oraInst.loc' as root on node(s) 'testhost' at the end of the session.

Review the permissions and contents of '/u01/oracle/product' on nodes(s) 'testhost'.
If there are no Oracle home(s) associated with '/u01/oracle/product', manually delete '/u01/oracle/product' and its contents.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############