NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »How to Change NLS_LENGTH_SEMANTICS Temporarily
The complete list is shown during creating a 19c RAC database by DBCA.
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
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
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
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
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