How Srvctl Disable ONS
Some vulnerability scanner may report Oracle Notification Service (ONS) against its listening port as a weakness. In such situation, you may solve the weakness on… Read More »How Srvctl Disable ONS
Database
Installation Guide on AIX for All Releases of Oracle Database
In this post, we collect installation guides on AIX for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »Installation Guide on AIX for All Releases of Oracle Database
Installation Guide on Solaris for All Releases of Oracle Database
In this post, we collect installation guides on Solaris for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »Installation Guide on Solaris for All Releases of Oracle Database
Installation Guide on Windows for All Releases of Oracle Database
In this post, we collect installation guides on Windows for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »Installation Guide on Windows for All Releases of Oracle Database
Installation Guide on Linux for All Releases of Oracle Database
In this post, we collect installation guides on Linux for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »Installation Guide on Linux for All Releases of Oracle Database
How to Resolve ORA-08186: invalid timestamp specified
ORA-08186 Tried to perform a flashback query, but it failed with ORA-08186. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('3023-02-20 00:53:08', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-08186: invalid timestamp specified
How to Resolve ORA-01466: unable to read data - table definition has changed
ORA-01466 Tried to perform a flashback query, but it failed with ORA-01466. SQL> select count(*) cnt from t1 as of timestamp to_timestamp('2023-02-19 22:15:00', 'yyyy-mm-dd hh24:mi:ss');… Read More »How to Resolve ORA-01466: unable to read data - table definition has changed
How to Resolve DBT-06006: Unable to create directory
DBT-06006 Saw error DBT-06006 when we tried to create a database by Database Configuration Assistant (DBCA). [FATAL] [DBT-06006] Unable to create directory: (/oradata/ORCLCDB/). CAUSE:… Read More »How to Resolve DBT-06006: Unable to create directory
How to Resolve ORA-00030: User session ID does not exist.
ORA-00030 Tried to kill a session, but it failed with ORA-00030. SQL> ALTER SYSTEM KILL SESSION '1821, 8545, @2'; ALTER SYSTEM KILL SESSION '1821, 8545,… Read More »How to Resolve ORA-00030: User session ID does not exist.
How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER