Oracle 18c-Checklist for upgrade
Oracle 18c – Complete checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1.x.x to 18.x.x.x (Doc ID 2422161.1) Oracle DB 18c – Complete Checklist for Manual Upgrades to…
Read Moreoracle 18c-Password file location
The default location for the Oracle Database 18c password file is now ORACLE_BASE instead of ORACLE_HOME/dbs. This change enables you to use Oracle Home as a static repository for database…
Read Moreoracle 18c-SQL Cancel
In past versions of Oracle whenever a database administrator needed to cancel a SQL query, the session that was running the SQL had to be killed. This meant the session…
Read MoreERRORMSG: appsborg2.zip not found after upgrade of iAS_ORACLE_HOME in Oracle EBS R12.1.3
Introduction : AutoConfig is a configuration tool that does the automation and the configuration of an Oracle E-Business Suite instance. The data required for configuring an Applications system is…
Read MoreHow to recover WebLogic Credentials
Introduction : Oracle WebLogic Server 12c R2 is one of industry’s noteable application servers for building and deploying enterprise Java EE applications with support for all the latest features…
Read MoreSteps to recover a corrupted datafile on the standby database
Introduction : There was an issue faced recently on one of the dataguard environments. One of the file systems(/u05/PROD/) in the dataguard environment got corrupted. Any files added to…
Read MoreSteps to run the EBS Technology Code Level Checker (ETCC) in EBS R12.2
Introduction : The Technology Codelevel Checker (ETCC) utility provides two scripts to ensure all the necessary database and application tier patches are installed on a 12.2 system. Oracle strongly recommends…
Read MoreInvalid or unexpected user name entered: when trying to change password with FNDCPASS
Introduction : FNDCPASS is an utility to change passwords of database schemas within the Oracle E-Business Suite. For example, you can change the APPS password using FNDCPASS.You can also change…
Read Morelsnrctl Commands are working very slowly and are getting hung on windows
Introduction : The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. When a request from the client…
Read MoreSwitchover of Standby to Primary : Error ORA-00333, ORA-15079, ORA-17611
Introduction : After configuring the dataguard, databases would be in primary role and standby database role. The above mentioned roles can be altered without the loss of data and…
Read More