Modern Oracle DBA

When attempting to access E-Business Suite Forms on a Cloned and Upgrade E-Business Suite instance the following error occurs: ERROR: FRM-92102 A network Error has occurred. The Forms Client has attempted to reestablish its connection to the server 1 time(s) without success. Please check the network connection and try again later. SOLUTION: STEP 1: you can attempt to regenerate / relink the jar files and forms via the following steps A. Start adadmin: B. Select 1. Generate Applications File menu C. Select 4. Generate product JAR files (with no force generation) D. Select 2. Generate form files (with library files; with menu files; with forms executables; for all products; all forms and all languages) STEP 2: Retest Forms and confirm whether users can now successfully access forms based screens and functions. REFERENCE: Getting FRM-92102 Errors when Accessing a Forms Module on a Cloned Environment (Doc ID 2237225.1)

There could be several reasons for not starting the admin server. Here I will explain some simple sanity check if the admin server is not starting. Verify If any admin server process running/not. If anyting is running kill it and start the admin server Before restarting the Admin Server, it’s important to ensure no existing process is running that might be causing a conflict. You can check this by running the following command: ps -ef |grep -i adminserver If you find an active Admin Server process, kill it and then attempt to start the Admin Server again. Verify the adminserver log file cd $EBS_DOMAIN_HOME/servers/AdminServer/log/adminserver.log cd $EBS_DOMAIN_HOME/servers/AdminServer/log/adminserver.out Verify if any recent changes in config.xml file  cd $EBS_DOMAIN_HOME/config/config.xml Recently below is a sample error encountered in my environment. Log file Error : weblogic.store.PersistentStoreFatalException: [Store:280105]The persistent file store "WLS_DIAGNOSTICS" ...

Oracle database Release number format: Example of an Oracle Database Release Number 11.2.0.1.0 11->Major database release number The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality. 2->Database maintenance release number The second digit represents a maintenance release level. Some new features may also be included. 0->Fusion Middleware release number The third digit reflects the release level of the Oracle Application Server (OracleAS). 1->Component specific release number The fourth digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases. 0->Platform specific release number The fifth digit identifies a platform-specific release. Usually this is a patch set. When different platforms require the equivalent patch set, this di...

Alert Log file The alert log file keep record the following information: When DB start or down    List of all non default initialization parameter    The startup of background process    Information regarding a log switch    Creation of table space and Undo segments    Alter statement that have been issued    Information regarding error message Alert log location The Oracle alert log location of determined by the background dump destination and specified by the background_dump_dest parameter. SQL>  show parameter background NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------...

OPatch It is a java based utility used mainly for installing patches and interim patches (bug fixes). Opatch requires that OUI is installed     List of Database Patches One-off patches (e.g. a bug fix) Critical Patch Update (CPU) Upgrade patches (bug fix bundle) Patch Set Update (PSU) Bundled patches (For Windows and Exadata only) Upgrade OPatch version Upgrade your version of opatch search on Oracle Support for patch number 6880880 and click one of the results Download the latest OPatch p6880880_112000_Linux-x86-64.zip Make a backup of the actual OPatch and make sure there is no OPatch folder on $ORACLE_HOME folder (EX) cd $ORACLE_HOME mv OPatch OPatch_old Unzip the patch into $ORACLE_HOME unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME Apply steps Step 1:-Backup database Step 2:-Backup database Home path (Ex):- tar -cvf patch_bkp /u01/oracle/ STEP 3:-Check OPatch version (Ex):- opatch version STEP 4:- Shutdown database and ...

What is archive log:   Copy redo log files to a designated storage device after a log switch has occurred ARCHIVE processes are present only when the database is in ARCHIVELOG mode and automatic archiving is enabled. An archived redo log file is a copy of one of the filled members of a redo log group. It includes the redo entries and the unique log sequence number of the identical member of the redo log group.    Database Running in noarchivelog Mode: When you run your database in NOARCHIVELOG mode, you disable the archiving of the redo log The database control file indicates that filled groups are not required to be archived NOARCHIVELOG mode protects a database from instance failure but not from media failure Only the most recent changes made to the database, which are stored in the online redo log groups, are available for instance recovery. In NOARCHIVELOG mode you cannot perform online  backups Database  Runn...