Home » RDBMS Server » Server Administration » Alter user
Alter user [message #251861] Tue, 17 July 2007 00:27 Go to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
Hi

oracle 9i
windows platform

I am trying to change the password but i get the following error.

SQL> alter user system identified by manager;
alter user system identified by manager
*
ERROR at line 1:
ORA-04098: trigger 'SYS.CDC_ALTER_CTABLE_BEFORE' is invalid and failed
re-validation


SQL> show user
USER is "SYS"



Reply me soon

thanks
Re: Alter user [message #251869 is a reply to message #251861] Tue, 17 July 2007 01:03 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Changing password does not fulfill the requirement of the login trigger.. Disable trigger and change password and then enable it...
Re: Alter user [message #251876 is a reply to message #251869] Tue, 17 July 2007 01:11 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
hi

how would i disable the triger.


plz send me the steps

thanks
Re: Alter user [message #251878 is a reply to message #251861] Tue, 17 July 2007 01:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

USING sysdba coount,
ALTER TRIGGER SYS.CDC_ALTER_CTABLE_BEFORE DISABLE

then change password,
Then enable the trigger
Re: Alter user [message #251883 is a reply to message #251861] Tue, 17 July 2007 01:24 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should also investigate why this trigger is invalid.

First, try to recompile it but with the following conditions:
- put your instance in restricted session to avoid any user: "alter system enable restricted session" (or better "shutdown immediate" and "startup restrict")
- execute: alter system set "_system_trig_enabled"=true;
- execute: alter trigger SYS.CDC_ALTER_CTABLE_BEFORE compile;
- execute: alter system set "_system_trig_enabled"=false;
- execute: alter system disable restricted session;

Regards
Michel
Previous Topic: Upgrade Database
Next Topic: upgrading 9.2.0.6 to 9.2.0.7
Goto Forum:
  


Current Time: Thu Dec 08 04:17:27 CST 2016

Total time taken to generate the page: 0.13779 seconds