Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forgot my SYS and SYSDBA password and used orapwd

921940Mar 6 2012 — edited Mar 6 2012

Hi all,

I have successfully installed Oracle 11g and was able to create the ORCL database as well. I also run a script to create another database but there were tables that were auto-generated by the system such as the APPLY$_CHANGE_HANDLERS with many other tables names with "$". I was trying to DROP these tables but ORA-00604 and ORA-00942 errors kept appearing.

I thought maybe I need to login as SYSDBA but I forgot the password during installation so I used the Oracle_Home\BIN\orapwd. CMD prompt appeared but quickly gone away.

I appreciate any help:
1. I need to change SYSDBA password
2. I need to drop the unwanted tables created by the system.

Thanks in advance

This post has been answered by Nikolay Ivankin on Mar 6 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2012

Added on Mar 6 2012

#general-database-discussions

11 comments

5,086 views