Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/582427 (SAP Service marketplace login required)

Summary :
If Oracle scripts catalog.sql or catproc.sql are incorrectly executed or not used during upgrade or installation, various issues can emerge within SAP systems using Oracle databases. These include invalid identifiers, process failures, nonexistent tables/views, system errors, and unauthorized access issues. Proper initialization involves using SQL*Plus logged as 'SYSDBA', executing scripts from $ORACLE_HOME/rdbms/admin, and addressing duplicate objects or VERSION mismatches. Errors are logged in .log files, with specific ignore criteria for benign failures. Persistent errors like ORA-00600 require systematic troubleshooting to rectify the underlying issues before re-running the scripts. Consult SAP Support for persistent discrepancies.

Key words :
ora-00001 ora-00900 ora-00942 ora-00943 ora-00955 ora-01001ora-01418 ora-01430 ora-01432 ora-01434 ora-01435 ora-01451ora-01918 ora-01919 ora-01921 ora-02033 ora-02261 ora-02264ora-02275 ora-02289 ora-02303 ora-02443 ora-04043 ora-06512ora-24001 ora-24006 ora-29809, set pause offset heading offset pagesize 0set feedback offspool dropsys, upgrade option            ora-00604, internal error [56319]ora-06553, internal error [2603]ora-06553, 'n'ora-06512, [56319]ora-06544, [2603]ora-06554, log@catalogspool offspool catproc, followingconnect system/<pwd>@dropsys

Related Notes :

871455	Poor performance when accessing DBA and V$ views
839187	Oracle 10.2.0: Applying patch set/patches/patch collection
700548	FAQ: Oracle authorizations
662644	Composite SAP Note: ORA-00942
648203	Database objects with INVALID status
635974	Error when upgrading to Oracle 9.2.X - Windows
633914	Error when executing DBMS_STATS
619188	FAQ: Oracle wait events
618868	FAQ: Oracle performance
540021	Add. information on migrating/updating to Oracle 9.2.0: UNIX
539921	Current patch set for Oracle 9.2.0
12826	ORA-00904 or EXP-00037 during database export