Posts

Showing posts from April, 2017

ADOP patch session fail form / report compilation

Error log :-  An error occurred while generating Oracle Forms files. *** Continue as if it were successful : *** AutoPatch could not find a response to the above prompt in the defaults file. Solution:-   abandon=no restart=yes flags=autoskip example:  adop phase=apply patches= 25738975 abandon=no restart=yes flags=autoskip     In addition to the autoskip option creates a new logfile called asautoskip.log  Example:- [testora@vtebz1 patch]$ adop phase=apply patches=25738975 abandon=no restart=yes flags=autoskip Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing.           Run Edition context   : /u01/oracle/DEV/apps/fs1/inst/apps/DEV_vtebz1/appl/admin/DEV_vtebz1.xml     Patch edition context: /u01/oracle/DEV/apps/fs2/inst/apps/DEV_vtebz1/appl/admin/DEV_vtebz1.xml Reading driver file...

Frequently used Tablespace and datafile commands

Oracle database is divided into one are more logical storage unit called tablespace   Tablespaces are divided into logical unit of storage called segments Segments are divided into Extents Extents are a collection of blocks Tablespace Types: System tablespace Sysaux tablespace Temp tablespace Undo tablespace   System tablespace            System tablespace is first tablespace created at db creation           It’s required all databases           It’s containing data dictionary and the system rollback segments Sysaux tablespace Sysaux tablespace store the non-sys-related tables and indexes It’s contains all performance related operations like awr,ash report generation   Temp tablespace Temp tablespace are used to store the data with sorting operations Can’t contain any permanent objects Temp tbs need...