To change the NLS_DATE_FORMAT setting Use the below command, it will help to solve your problems for after restart database. Also, if you do not want to do this at the instance level, you can make session NLS_DATE_FORMAT based on sql queries. ALTER SESSION SET NLS_DATE_FORMAT=’DD-MM-YYYY’; [oraetkb@sp000dba01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 […]

In this post, Pluggable database ORA-01157 error we will examine.I encountered an error on when opening the database like below The data file may have been renamed at the operating system level, moved to a different directory or disk drive with or without awareness.In this case, restore and recover the data file or move the […]

I encountered an error on Exadata like below. Alert Summary Maintenance A memory component suspected of causing a fault Detailed Alert Information A memory component is suspected of causing a fault with a 100% certainty. Check Cellcli. cellcli > list alerthistory There is no error Check İlom -> show /SYS/MB/P0/D7 /SYS/MB/P0/D7 Targets: PRSNT SERVICE fault_state […]

When I wanted to change the password on the pluggable database user, I got an error like the one below. SQL> alter user test identified by test; alter user test identified by test ERROR at line 1:ORA-65066: The specified changes must apply to all containers View connection information. SQL> show con_nameCON_NAMEPLUG1 Login as sysdba SQL> […]