Administration

How to Resolve ORA-00030: User session ID does not exist.

by Ed Chen
March 14, 2023March 16, 2023

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-27125: unable to create shared memory segment

by Ed Chen
February 10, 2023January 12, 2023

ORA-27125 We found error ORA-27125 when we create the second database by Database Configuration Assistant (DBCA). ORA-27125 means that oracle has been bound to the… Read More »

How to Resolve ORA-00439: feature not enabled

by Ed Chen
February 8, 2023January 8, 2023

ORA-00439 We saw error ORA-00439 when we tried to create an index online. SQL> create index erp.bill_hist_idx2 on erp.bill_hist (SQ_NO) online; create index erp.bill_hist_idx2 on… Read More »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

How to Resolve ORA-00026: missing or invalid session ID

by Ed Chen
January 16, 2023December 26, 2022

ORA-00026 Tried to kill a session in a database, but it failed with ORA-00026. Case 1 SQL> ALTER SYSTEM KILL SESSION ('391, 9220'); ALTER SYSTEM… Read More »

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… Read More »

Error Messages for All Releases of Oracle Database

by Ed Chen
December 21, 2022February 5, 2023

In this post, we collect error message entry pages for all database releases. You may press Ctrl + d to bookmark this page. Error Messages… Read More »

How to Resolve ORA-16000: database or pluggable database open for read-only access

by Ed Chen
December 6, 2022December 24, 2022

ORA-16000 Tried to update some rows, but it failed with ORA-16000. SQL> update employees set first_name = 'Ed' where last_name = 'Chen'; update employees set… Read More »

How Oracle Rename Database

by Ed Chen
October 14, 2022November 17, 2022

It depends on what name you want to change in the database. Usually, database name can be DB_NAME, DB_UNIQUE_NAME or both in Oracle. We have… Read More »

How to Install USER_LOCK Package

by Ed Chen
August 11, 2022July 31, 2022

USER_LOCK USER_LOCK is not a default package of SYS, you need to install it before using it. SQL> conn / as sysdba Connected. SQL> @?/rdbms/admin/userlock.sql… Read More »