Now we are going to create an instance in cloud. Create a VM instance. Click compute —>instance—>create instance. Give name to your instance and choose in which compartment you want…
Read More1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs template]$ ls -l adxdbctx.tmp -rwxrwxrwx 1 oracle oinstall 23871 Dec 29…
Read MoreGather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed due to ORA-20005:…
Read More1. Shutdown the Application Services using $ADMIN_SCRIPTS_HOME/adstpall.sh 2. Start the admin server on Primary node using $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start 3. Run the below command to create new password perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword…
Read MoreStep-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> select…
Read MoreERROR weblogic.store.PersistentStoreFatalException: [Store:280029]The store record 4 could not be found. Solution The issue can be caused by the corruption of the database, by .lok or .DAT files associated with the…
Read More–Create the tuning set EXEC DBMS_SQLTUNE.CREATE_SQLSET(‘HIGH_DISK_READS’); –Populate the tuning set from the cursor cache DECLARE cur DBMS_SQLTUNE.SQLSET_CURSOR; BEGIN OPEN cur FOR SELECT VALUE(x) FROM table( DBMS_SQLTUNE.SELECT_CURSOR_CACHE( ‘parsing_schema_name <> “SYS” AND…
Read MoreWhen trying to startup [nomount] an instance in 12.2.0.1.0 from sqlplus by using a pfile, (startup nomount pfile=’my_pfile’) the following messages are displayed: ORA-39510: CRS error performing start on instance ‘TESTDB’…
Read More12.2 ADOP Prepare Phase Fails with below error message, Error: Validating configuration on node: [apps]. Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps [UNEXPECTED]Error occurred running “perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/ebsdb_apps/appl/admin/ebsdb_apps.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/87/20210803_114127/prepare/validate/apps -promptmsg=hide” [UNEXPECTED]Error 1 occurred…
Read More