OracleDB12c New Feature: Misc Security Changes

Security in Oracle12c Database is enhanced, in this blog will try to identify few difference you would see compared with 11gR2. SELECT ANY DICTIONARY privilege in 12c excludes access to the following tables with authentication information: DEFAULT_PWD$ ENC$ LINK$ USER$ USER_HISTORY$ XS$VERIFIERS AUDIT_TRAIL initialization parameter is set to DB by DBUA and DBCA utilities when … Read more

OracleDB12c New Feature: Rename and Replace ASM Disk(s) in Diskgroup

As I have not set up 12c GI ASM yet, have not tested this feature… Rename clause is nice to have. Replace clause helps to avoid multiple steps when replacing disk (LUN) with new one [array migration, for example]. Information below is straight copy from Oracle Documentation… rename_disk_clause ALTER DISKGROUP diskgroup_name RENAME { DISK old_disk_name … Read more