I got ” ORA 28 your session has been killed | opiodr aborting process unknown ospid ()” error in Oracle.
ORA 28 your session has been killed
Details of error are as follows.
ORA 28: Your session has been killed. Cause: A privileged user killed the session and it is no longer logged in to the database. Action: Contact the DBA. The administrator may be attempting to perform an operation that requires users to be logged out. When the database administrator announces that the database is available, log in and resume work.
opiodr aborting process unknown ospid ()
This ORA-28 errors are related with the privileged user killed the session and it is no longer logged in to the database.
This is an informational message only, so there is no solution for this error. You should run your job or SQL Statement again.
Contact the DBA. The administrator may be attempting to perform an operation that requires users to be logged out. When the database administrator announces that the database is available, log in and resume work.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )