ORA-12721 while executing csalter.plb


This topic contains 0 replies, has 1 voice, and was last updated by  Amit Bansal 6 years ago.

  • Author
  • #2556

    Amit Bansal

    I came across this error while executing csalter.plb to change db characterset. This was in one of test environment

    Elapsed: 00:00:08.43
    Alter the database character set...
    ERROR at line 1:
    ORA-12721: operation cannot execute when other sessions are active
    ORA-06512: at "SYS.DBMS_SQL", line 1199
    ORA-06512: at "SYS.CSM$RUNDML", line 6
    ORA-06512: at line 22

    I had restarted database in restrict mode and was the only user connected. Since this was dev environment, I did a small hack to fix this

    SQL> update csmig.CSM$PARAMETERS set value='FALSE' where name='CSALTER_FINISHED';

    Don’t try this in prod environment. I would recommend doing clean database shutdown and ensuring all jobs are disabled along with setting aq_tm_processes=0 (In case you are using AQ).

You must be logged in to reply to this topic.