Storing password file in ASM diskgroup

Starting with Oracle Database 12c, we can now store a password file directly into ASM Diskgroup. Also, Oracle has made it default for a password to be case sensitive in the password file.

Read more

12c copy the password file from PRIMARY ASM to the STANDBY ASM.

When you create a RAC database in 12c with DBCA, the password file will be stored in an ASM. In this post i will demonstrate how to refresh/copy the password file from PRIMARY ASM to the STANDBY ASM.

Read more

Upgrade the Oracle 11.2.0.4 database to Oracle Database 12.1.0.2

Database SID: UPGR is database version 11.2.0.4 is running and ready for an upgrade.The new pre-upgrade check script preupgrd.sql which will examine UPGR database. This script is shipped with the new Oracle 12c home in /u01/app/oracle/product/12.1.0.2/rdbms/admin

Read more