Hi Sir,

I am trying to run Gather Stats on a particular table. The gather stats works perfect when the script is run locally from the client or using some tools such as Sql Developer or Toad.
However, when trying to run the same script using Sqlplus from the Solaris server (login using putty), then getting below error.

Error : [SYS.SENSOR_DDL_TRIGGER_A] Caught a standard exception: aliasId=100413, error=-29260, message="ORA-29260: network error: TNS:no listener"


-----------SCRIPT START---------------------------------------------------------------------------------

Alter session set CURRENT_SCHEMA=MYSCHEMA;

Set heading on;
Set feedback on;
Set echo on;
Set linesize 9999;
Set trimspool on;
Set define off;
Set serveroutput on;
---------------------------------------------------------------------------

spool DML_gather_stats.log
timing start GatherStats
----------------------------------------------
EXEC dbms_stats.gather_table_stats(OWNNAME =>'MYSCHEMA',TABNAME=>'MY_TABLE',ESTIMATE_PERCENT => 10,DEGREE => 5,CASCADE => TRUE);
----------------------------------------------
timing stop

spool off;
exit;
/

-----------SCRIPT END---------------------------------------------------------------------------------

Additional Info:
- OS : Solaris 11.4
- Database : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- Tool to connect: Sqlplus (Using Putty, login to server.)