Creating Oracle Database Using dbca for 12c R1

Database Configuration Assistant (dbca) is an Oracle provided tool to create a new database. In this document I would explain how to create a new 12c R1 database using dbca. For database creation steps for Oracle 12c R2, follow this document. Steps and screens are almost same for other Oracle database versions and different OS platforms.

Changing Listener and SCAN Listener Ports

In this article I will explain how we modify Listener and SCAN Listener ports in RAC environment. For this article, in a 2 nodes RAC on Windows, my database listeners are listening ports 1521 and scan listeners are running on port 1522. I will change listeners’ ports to 1531 and scan listeners’ ports to 1532.

ORA-01017: invalid username/password - While Starting Instance using srvctl

If you face ORA-01017, following could be the reasons of this error.

• Username has been specified wrongly – check the username.
• Password has been specified wrongly – check the password.
• If you see this error while logging in as user SYS, check if password file exists. If not, re-create the password file or enable OS authentication.