Complete Initialization Parameters List in DBCA 19c
The complete list is shown during creating a 19c RAC database by DBCA.
Initialization Parameter
How to Resolve ORA-01000: maximum open cursors exceeded
ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »How to Resolve ORA-01000: maximum open cursors exceeded
How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link;… Read More »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
UNDO_RETENTION, How and Why
UNDO_RETENTION At times, you may find out or feel that UNDO_RETENTION is useless at all. Raising the number of seconds cannot resolve ORA-01555. This is… Read More »UNDO_RETENTION, How and Why
Timings to Set SESSIONS Explicitly
DBAs usually set PROCESSES when initializing a new database:SQL> alter system set processes=3000 scope=both;System altered.Another important parameter SESSIONS will be derived from PROCESSES automatically in this… Read More »Timings to Set SESSIONS Explicitly
How to Resolve ORA-00845: MEMORY_TARGET not supported on this system
If you are planning to install additional database by DBCA on a Linux server, you should notice not only the limitation of semaphores, but also… Read More »How to Resolve ORA-00845: MEMORY_TARGET not supported on this system
BYTE vs CHAR in NLS_LENGTH_SEMANTICS
BYTE vs CHAR in NLS_LENGTH_SEMANTICS Most of databases set NLS_LENGTH_SEMANTICS as BYTE by default, but there are some databases in Non-English country will take CHAR… Read More »BYTE vs CHAR in NLS_LENGTH_SEMANTICS
How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid
When you ALTER SYSTEM to modify an initialization parameter, it sometimes fails with ORA-02097 ORA-02097: parameter cannot be modified because specified value is invalid Reproduce… Read More »How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid
How to Archive Redo Logs to Respective Local Destinations of RAC
For a RAC database, we may want to archive the redo logs to local destinations of instances rather than ASM. That is, put instance #1,… Read More »How to Archive Redo Logs to Respective Local Destinations of RAC
How to Startup a Misconfigured Database ORA-00837
A misconfigured database is a database which was set with wrong values of initialization parameters in SPFILE, it will prevent the database from startup. Let's… Read More »How to Startup a Misconfigured Database ORA-00837