Invalid Component of Spatial SDO
Description:-
In this article we are going to see about Invalid Component of Spatial SDO
Demo:-
Step:-1 Check invalid Invalid Component
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’;
COMP_NAME
——————–
Spatial
Step:-2 execute the below script
SQL> @$ORACLE_HOME/md/admin/sdopatch.sql
Session altered.
Session altered.
Procedure created.
No errors.
Session altered.
Session altered.
Upgrading mdprivs.sql
Session altered.
Grant succeeded.
User altered.
User altered.
Grant succeeded.
Grant succeeded.
PL/SQL procedure successfully completed.
Session altered.
Session altered.
PL/SQL procedure successfully completed.
Session altered.
Step:-3 shutdown the DB
SQL> conn / as sysdba
Connected.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Step:-4 startup the DB
SQL> startup
ORACLE instance started.
Total System Global Area 2650796144 bytes
Fixed Size 9166960 bytes
Variable Size 721420288 bytes
Database Buffers 1912602624 bytes
Redo Buffers 7606272 bytes
Database mounted.
Database opened.
Step:-5 Check the Invalid Component
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> SELECT COMP_NAME FROM DBA_REGISTRY WHERE STATUS=’INVALID’;
no rows selected
Connect with me on:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
