Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter User sys Error in Oracle 10 , but worked in Oracle 11 1

Status
Not open for further replies.

tekpr00

IS-IT--Management
Jan 22, 2008
186
CA
Hello All,
I logged into Oracle 10 using sqlplus / as sysdba
I am trying to alter user SYS or SYSMAN, and each time I am getting the following error:

SQL> alter user sys identified by password;
alter user sys identified by password
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of
OGGDEMO_ADMIN.DDLREPLICATION
ORA-04064: not executed, invalidated
ORA-04064: not executed, invalidated package body
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60
ORA-06508: PL/SQL: could not find program unit being called:
"OGGDEMO_ADMIN.DDLREPLICATION"
ORA-06512: at line 60

Please help, and thank you for your help in advance.
 
This issue was because there was a trigger that was enabled.
I have been able to resolve the issue by setting below to false
Alter system set "_system_trig_enabled"=FALSE
change the password and
Alter system set "_system_trig_enabled"=TRUE
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top