Shulou(Shulou.com)06/01 Report--

ORA 31626 error was triggered by the source database because the database was patched and the data dictionary was not updated.

solution：

1 sql>@?/ rdbms/admin/catalog.sql

2 sql>@?/ rdbms/admin/catproc.sql

3 Restart the database after executing the above script.

4 Query dba_registry Check database data dictionary version information

cd $ORACLE_HOME/Opatch/

opatch lsinventory

Error:

opatch cannot find a valid oraInst.loc file to locate central Inventory

opatch failed with error code 104

The default oraIn.loc is placed under/etc, which indicates the path between the user group and oraInventory:

inventory_loc=/oracle/app/oraInventory ---Usually $ORACLE_BASE directory

inst_group=oinstall

Sometimes oraInst.loc will be placed in the $ORACLE_HOME directory (check the details yourself), and then the command will be modified:

opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

oraInventory can be rebuilt, and the path of reconstruction depends on the inventory_loc value in oraInst.loc

cd $ORACLE_HOME/oui/bin/

./ attachHome.sh

Oracle, grid users all need to execute (a node)

Note:oracle, bird and other related users or oracle components have their corresponding home names, which need to be registered in the inventory.xml file under the inventory subdirectory ContentsXML.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.