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
Page 2 of 2
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
Could not able to add a 220.127.116.11 database when GI version 12.2 contained a 12.2 database. Database versions lower than 18.104.22.168 have no issues.
After Database upgrade to 12c, now getting errors during datapump import due to different version of time zone datafiles used for exisiting DP jobs.
This post will go through the steps to upgrade single database instance from 12.1 to 12.2 with ASM on CDB environment. Both GI and Oracle database software’s are installed under one user as oracle.
When we try to duplicate the oracle 22.214.171.124 database using RMAN , its corrupting temp files. The error is as below