ORA-12721 while executing csalter.plb

Home Forums Database Administration ORA-12721 while executing csalter.plb

Tagged: 

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

  • Author
    Posts
  • #2556

    Amit Bansal
    Keymaster

    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...
    declare
    *
    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';
    commit;

    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.