DB_CREATE_ONLINE_LOG_DEST_n is a set of server parameters which specify the default destination where new Oracle-managed redo log files (OMF) should be placed. More precisely, DB_CREATE_ONLINE_LOG_DEST_n… Read More »DB_CREATE_ONLINE_LOG_DEST_n, How and Why
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 Set NLS_LENGTH_SEMANTICS Temporarily
The complete list is shown during creating a 19c RAC database by DBCA.
ORA-01000 Saw an error ORA-01000 when executing a lot of statements. It seemed that the number of open cursors has reached the limitation. ORA-01000: maximum… 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