Oracle 12c missing GSMADMIN_INTERNAL

All we need is an easy explanation of the problem, so here it is.

Oracle 12c 12.2.0.1

The GSMADMIN_INTERNAL user was erroneously deleted apparently some weeks ago. Datapump no longer works for export (ORA39006 and 390065) as well as ORA-00942 table or view does not exist. And ultimately ORA-39097 Data Pump job encountered unexpected error -942

So, I’m wondering is there any practical way to restore the GSMADMIN_INTERNAL user and its objects? I do not have RMAN backups going back that far. I do have datapump dumps from before the deletion, but I suspect impdp.exe will be just as broken as expdp.exe. Is there a way to manually create the user and its objects?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

There are scripts for removing and creating this, but they are not well-documented on their own.

I would just create a backup of the database then rerun the catalog scripts.

startup upgrade
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql

GSMADMIN_INTERNAL and related objects are created in other scripts called by catalog.sql.

The above may finish without any error, but you may need to take care of others errors encountered during or after this.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply