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.
Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.
Tuesday, March 22, 2016
Monday, March 14, 2016
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.
Wednesday, March 2, 2016
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.