Oracle 12c – SYS/SYSTEM accounts are incorrectly listed in DBA_USERS_WITH_DEFPWD

After creation of a new 12c database, the SYS and SYSTEM accounts are listed in DBA_USERS_WITH_DEFPWD even though the accounts were created with non-default passwords. Setting the same passwords again with ALTER USER correctly recognises that the accounts do not have default passwords. Continue reading → Oracle 12c – SYS/SYSTEM accounts are incorrectly listed in DBA_USERS_WITH_DEFPWD

ODC Appreciation Day: Moving Datafiles Online

First of all, I would like to thanks OTN/ODC community for helping us to connect with like-minded people. Also thanks to Tim Hall for setting all of us for sharing some content with Oracle community.

Even though Oracle 12c brought a lot of new features and changes but online datafile movement is one of my favorite feature. For years, moving datafiles was a pain for DBA’s and involved other teams (OS and application) as well in completing the datafile re-location. But not anymore now. With Oracle 12c, we can move the datafiles online, without taking application downtime and tablespaces offline or read-only mode. Continue reading → ODC Appreciation Day: Moving Datafiles Online