In this DocumentPurposeQuestions and Answers Questions Which listener.ora should be used to start database listener ? How to know which listener.ora is used ? Problems Database Issues ORA-65064: system ts doesn't exist ORA-7445 [qkacco] when running a Complex Query with Nested Joins ORA-01034 while running txkPostPDBCreationTasks.pl script Invalid APPS database user credentials errors when running txkPostPDBCreationTasks.pl PDB services are not registering with database listener High "row cache mutex" waits are seen in AWR reports due to SQLs against v$session/v$process Running ADZDDBCC.sql in 19c database is taking time for Section 26. Concurrent programs are failing with ora-20100: Temporary file creation for FND_FILE failed errors. Running Materialized View refresh programs are running longer and locks are seen in the database Database alert.log reports parsing errors for FND_SESSION_MANAGEMENT package txkCreatePDB.pl Completes with PDB Plugged in with "Open No Master Key" Bug 33405295 - DBMS_STATS.IMPORT_DATABASE_STATS FAILING WITH ERROR OPERATION NOT ALLOWED FROM WITHIN A PLUGGABLE DATABASE OCI Database Issues Failure in opening the PDB, after renaming it during refresh ORA-65092: system privilege granted with a different scope to 'OEM_MONITOR' Forms Issues ORA-1017 when opening Forms and ORA-1017 Invalid username/password; logon denied FRM-41352 failed to create a new session APP-FND-00706: Routine Detected a data error ORA-04025: maximum allowed library object lock allocated for SELECT NLS_CHARSET_NAME FRM-40735: ON-ERROR Trigger raised unhandled exception ORA-01001 ORA-65011: when opening forms after upgrading EBS Apps database 19c Login Issues Intermittent login issues after 19c upgrade. Upgrade Issues Running noncdb_to_pdb.sql fails with ORA-01219 : DATABASE OR PLUGGABLE DATABASE NOT OPEN: QUERIES ALLOWED ON FIXED TABLES OR VIEWS ONLY. Autoconfig Run Fails With Error 'tackTrace: java.lang.NullPointerException at oracle.apps.ad.context.GenerateContext.getPDBCDB' Due To Missing 'SELECT_CATALOG_ROLE' In Adgrants.sql Autoconfig is running slower after 19c upgrade. Running Autoconfig errors after 19c upgrade on application tier - Unable to read UTL_FILE_DIR parameter Unable to call FND_LDAP_WRAPPER.CREATE USER - ORA-06508: PL/SQL: could not find program unit being called Change LogReferences My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
Oracle E-Business Suite R12 | SGA Vs PGA Vs NOT Being A DBA!
2ff7e9595c
Comments