Archive for the ‘TEChNoLoGY’ Category

ORA-00704 Bootstrap Process Failure

June 24th, 2018, posted in Oracle Queries
Share

ORA-00704 bootstrap process failure

After Upgrading ORACLE_HOME (from 10.2.0.1 to 10.2.0.4), I was started my database by using startup command, then got below error.

 

ORA-01092 oracle instance terminated. Disconnection force.

After I saw my alert log and got ORA-00704 error,

Alert Log :

 

Errors in file /oracle/product/db/10.2.0/dbhome/admin/test/udump/test_ora_11338.trc:

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Wed Jun 19 11:43:30 2013

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 11338

ORA-1092 signalled during: ALTER DATABASE OPEN....


Solution:

I missed to run catupgrd.sql script after upgrade, so got above errors while starting the database.

 

Go to ORACLE_HOME/rdbms/admin

sqlplus / as sysdba

sql>startup upgrade

sql>@catupgrd.sql 

sql>@utlrp.sql

sql>shut immediate

sql>startup
Share

Other Ways To Take Trace in Oracle Application

June 16th, 2018, posted in Oracle Queries
Share

Problem sys@standby> startup mount; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 490735648 bytes Database Buffers 335544320 bytes Redo Buffers 6606848 bytes Database mounted. sys@standby> alter database recover managed standby database using current logfile disconnect; alter database recover managed standby database using current logfile disconnect * ERROR at line 1: ORA-01153: an incompatible media recovery is active Cause This indicates a currently running media recovery process. Action sys@standby> alter database recover managed standby database cancel; sys@standby> alter database recover managed standby database using current logfile disconnect; Note When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.

Other Ways To Take Trace in Oracle Application :

 

 

SQL> ALTER SESSION SET sql_trace=TRUE;
SQL> ALTER SESSION SET sql_trace=FALSE;

SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => TRUE);
SQL> EXEC DBMS_SESSION.set_sql_trace(sql_trace => FALSE);

SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';
SQL> ALTER SESSION SET EVENTS '10046 trace name context off';

SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE);
SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>FALSE);

SQL> EXEC DBMS_SYSTEM.set_ev(si=>123, se=>1234, ev=>10046, le=>8, nm=>' ');


Share

Workflow : Workflow Component wfcmp

June 9th, 2018, posted in Oracle Queries
Share

Oracle Applicaition,Oracle Database,Oracle DBA,Oracle Applicaition DBA,Oracle Database DBA,Applicaition DBA,Database DBA,Oracle EBS Applicaition DBA,Oracle EBS Database DBA,Oracle,Oracle Applicaition,Oracle Database,Workflow : Workflow Component wfcmp,Oracle Applicaition Workflow,Oracle Database Workflow,oracle ebs logo,oracle ebs logo,oracle e business suite logo,

Query :


select fsc.COMPONENT_NAME,fsc.STARTUP_MODE,fsc.COMPONENT_STATUS
from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc
where fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
order by COMPONENT_STATUS , STARTUP_MODE , COMPONENT_NAME;
Share

How To Compile Forms In Oracle Application R12

June 2nd, 2018, posted in Oracle
Share

oracle application,apps dba,oracle dba,application,oracle r12,oracle support,Application DBA in Oracle Application, ebs dba,in Oracle Application, Oracle Application DBA, Oracle DBA, Oracle Application,Compile form,Compile forms,Compile form fmb in oracle application,Compile form fmb, in oracle application,Compile form fmb in oracle application r12,

We have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.

1) Login to application server.

2) Go to the directory $AU_TOP/forms/US

3) Place “.fmb” file in binary mode

4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EXAMPLES:

frmcmp_batch userid=apps/apps module=RCVRCERC.fmboutput_file=$AU_TOP/forms/US/RCVRCERC.fmx module_type=form batch=no compile_all=special

 

R12 

frmcmp_batch userid=apps/apps 
module=/u01/apps/apps_st/appl/au/12.0.0/forms/US/XXXXXX.fmb 
output_file=/u01/apps/apps_st/appl/XX_CUSTOM/12.0.0/forms/US/XXXXXX.fmx 
module_type=form batch=no compile_all=yes 

R11 

f60gen Module= 
XXXXXX.fmb Userid=apps/apps Module_Type=FORM Module_Access=FILE 
Output_File=$XX_CUSTOM/forms/US/XX_CUSTOM.fmx Compile_All=special 

Share