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 4 of 5
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
This article will go through steps to create a wallet containing your server certificate and private key provided by your administrator.
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.
I upgraded the oracle golden gate to 12.2 version and during database initial load I faced the following error.
After Database upgrade to 12c, now getting errors during datapump import due to different version of time zone datafiles used for exisiting DP jobs.