EM 24ai: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

June 3, 2025 Leave a comment

Problem:

While checking the status of the agent, I received the following error:

$ /u03/em24/agent/agent_inst/bin/emctl status agent

Oracle Enterprise Manager 24ai Release 1
Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
/u03/em24/agent/agent_24.1.0.0.0/bin/emdctl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

Solution:

As root user, install libnsl package using yum

# yum install libnsl

Retry the command:

$ /u03/em24/agent/agent_inst/bin/emctl status agent

Oracle Enterprise Manager 24ai Release 1
Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent is Not Running

Filed under EM Tagged with , , , , ,

Oracle EM 24ai: Install the partitioning option on the EM repository database

May 30, 2025 Leave a comment

Problem:

While installing Oracle Enterprise Manager 24ai, the check “Ensure that the Oracle partitioning option is installed” failed.

Toubleshooting:

Check if the EM repository database (the database you selected for the EM repository) has partitioning enabled:

SQL> select value from v$option where parameter = 'Partitioning';

VALUE
----------------------------------------------------------------
FALSE

The output above indicates that the partitioning is disabled.

Solution:

Let’s not think about the licensing part yet, since we are currently using Oracle for learning.

If partitioning is disabled, enable it on the database as follows:

1. Shut down the database using srvctl or sqlplus:

    srvctl stop database -d orclasm

    2. Connect to the database server as RBDMS owner and run the following commands:

    $ su - oracle
    $ cd $ORACLE_HOME/bin
    $ chopt enable partitioning

    The output of the command would appear as follows:

      Writing to /u01/app/oracle/product/23ai/dbhome_1/install/enable_partitioning_2025-05-30_21-46-30PM.log...
      /usr/bin/make -f /u01/app/oracle/product/23ai/dbhome_1/rdbms/lib/ins_rdbms.mk part_on ORACLE_HOME=/u01/app/oracle/product/23ai/dbhome_1
      /usr/bin/make -f /u01/app/oracle/product/23ai/dbhome_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/23ai/dbhome_1

      3. Start the database using srvctl or sqlplus:

      srvctl start database -d orclasm

      4. Connect to the database using sqlplus and verify the option status again:

      SQL> select value from v$option where parameter = 'Partitioning';

      VALUE
      ----------------------------------------------------------------
      TRUE

        5. Rerun the check again

        It shows succeeded this time:

        Filed under EM Tagged with , , , , , ,