HOW TO CREATE TKPROF FILE IN ORACLE APPS R12

 Step 1 :- To find Trace file location using Request id

SELECT
    req.request_id
    ,req.logfile_node_name node
    ,req.oracle_Process_id
    ,req.enable_trace
    ,dest.VALUE||'/'||LOWER(dbnm.VALUE)||'_ora_'||oracle_process_id||'.trc' trace_filename
    ,prog.user_concurrent_program_name
    ,execname.execution_file_name
    ,execname.subroutine_name
    ,phase_code
    ,status_code
    ,ses.SID
    ,ses.serial#
    ,ses.module
    ,ses.machine
    FROM
    fnd_concurrent_requests req
    ,v$session ses
    ,v$process proc
    ,v$parameter dest
    ,v$parameter dbnm
    ,fnd_concurrent_programs_vl prog
    ,fnd_executables execname
    WHERE 1=1
    AND req.request_id = &request --Request ID
    AND req.oracle_process_id=proc.spid(+)
    AND proc.addr = ses.paddr(+)
    AND dest.NAME='user_dump_dest'
    AND dbnm.NAME='db_name'
    AND req.concurrent_program_id = prog.concurrent_program_id
    AND req.program_application_id = prog.application_id
    AND prog.application_id = execname.application_id
    AND prog.executable_id=execname.executable_id;

Step2:- RUN TKPROF Command

tkprof PROD_ora_61669742_0132386_1001_172443.trc PROD_ora_61669742_0132386_1001_172443.out sys=no explain=apps/password sort=prsela,exeela,fchela

Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC

 Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC (Doc ID 2029173.1)

Step 1:- No active ADOP cycle

adop -status

Step 2:- Create Services (Database)

srvctl add service -db vis_a -service UATERP_OACORE_ONLINE -preferred "UATERP1,UATERP2" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

srvctl add service -db vis_a -service UATERP_PCP_BATCH1 -preferred "UATERP1" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

srvctl add service -db vis_a -service UATERP_PCP_BATCH2 -preferred "UATERP2" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

Step 3:- Check the configuration

select inst_id,service_name, count(*)

from gv$session

where service_name not like 'SYS%'

group by inst_id,service_name

order by 1

/

srvctl config service -d UATERP -s UATERP_OACORE_ONLINE 

srvctl config service -d UATERP -s UATERP_PCP_BATCH1

srvctl config service -d UATERP -s UATERP_PCP_BATCH2

Step 4:- Configure Net Services

lsnrctl status UATERP1

lsnrctl status UATERP2

lsnrctl status listener_scan1

lsnrctl status listener_scan2

lsnrctl status listener_scan3

Step 5:- Create a TNS alias for database service

UATERP_OACORE_ONLINE =(DESCRIPTION=(ADDRESS_LIST= (FAILOVER=YES) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP1>)(PORT=<SCAN PORT>)) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP2>)(PORT=<SCAN PORT>)) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP3>)(PORT=<SCAN PORT>)) (CONNECT_DATA= (SERVICE_NAME=UATERP_OACORE_ONLINE)))

"Create Service UATERP_OACORE_ONLINE a and add it to $TNS_ADMIN/<%s_dbSid%>_<%s_hostname%>_ifile.ora file Add tnsentry on both database node."

Step 6:- Copy the default database connection file

"Copy the default database connection file, which is normally $FND_SECURE/DB_NAME.dbc to the database service UATERP_OACORE_ONLINE.dbc"

Step 7:- Context File backup

Step 8:- Edit the context file on each application tier node

s_apps_jdbc_connect_descriptor = <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=exaa-scan3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=UATERP_OACORE_ONLINE )))</jdbc_url>  

s_jdbc_connect_descriptor_generation - false

s_tools_twotask - UATERP_OACORE_ONLINE

s_cp_twotask - UATERP_PCP_BATCH1

s_cp_twotask - UATERP_PCP_BATCH2

Step 9:- Run autoconfig primary and secondary node of application

Step 10:- Stop application services and database services

Step 11:- Start database services and application services

Step 12- HA testing

srvctl relocate service -d <db_name> -s <service_name> -i <instance1> -t <instance2>

srvctl modify service -d <db_name> -s <service_name> -n -i <preferred_list> -a <available_list>

srvctl modify service -d prod -s TestService1 -n -i prod2,prod4 -a prod1,prod3

FRM-92101:There was a failure in the Forms Server during startup" Error When Attempting to Launch Forms

To fix the issue, follow the steps below from your local desktop to clear your cache:

Clearing Java Cache (Part 1)

 1- Go to Control Panel, the Control Panel can be accessed by searching for the control panel using the search box at the bottom of your screen.

2- From the Control Panel Screen, select click the word Program. 

3- Select Java (32-Bit).

4- On the general tab, under temporary internet files, click settings. 

5- Click Delete Files

6- Make sure the Trace and Log Files, Cached Applications and Applets, ad Installed Applications and Applets boxes are checked.  Then click OK

Clearing Internet Explorer Cache (Part 2)

1- You may also want to clear your Internet Explorer Cache.  To do so, click on the gear icon on the top right-hand corner of your browser.

2- Place your cursor over Safety to populate a drop down box, then select Delete Browsing History.

3- Uncheck the box next to Preserve Favorites website data, and make sure the boxes next to Temporary Internet files and website files and Cookies and website data are checked.  Then click delete        

4- A box will appear at the bottom of your screen confirming that your browsing history has been deleted.

5- Log back into the R12 Environment

 

How To Change The Web Port in E-Business Suite R12.2

Change The Web Port {http port} in E-Business Suite R12.2 

In this post i will list out the steps to change the webport to 8009.

Defualt port - 8000

change port - 8009

Solution:-

1- Login to Em console - using http://hostname:port/em

2- make sure oracle apahce Server is up and running.

3- Select the webtier instance from the Web Tier drop down.

4- Select the Oracle HTTP server component and Advanced Configuration.

5- Choose httpd.conf for example.

6- Modify the Listen port value

7- Save the changes.

8-  Run Context File Synchronization $AD_TOP/bin/adSyncContext.pl :

perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE

9 - Bring down application services.

10- Run autoconfig at application.

11- Check the value for s_login_page in the context file.

 grep login $CONTEXT_FILE

 grep 8000 $CONTEXT_FILE

12- Start application services and perform sanity test.

How to Check the table Size in Oracle

• To check table name segment type, owner and table size in GB  

select owner,segment_name,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments  where owner='GL' and segment_type='TABLE' and segment_name in

('GL_LEDGERS',

'GL_JE_LINES',

'GL_CODE_COMBINATIONS',

'GL_CODE_COMBINATIONS_KFV',

'GL_PERIODS',

'GL_JE_HEADERS',

'RA_CUST_TRX_LINE_GL_DIST_ALL',

'GL_BUDGET_VERSIONS',

'GL_BUDGETS',

'GL_PERIOD_TYPES',

'GL_BALANCES',

'GL_JE_BATCHES')

group by owner,segment_name order by "SIZE in GB" desc;

• To check table name segment type table size in GB .

select owner,segment_name,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments where segment_type='TABLE' and segment_name in

('MTL_TRANSACTION_ACCOUNTS',

'MTL_SYSTEM_ITEMS_B',

'MTL_CATEGORIES_B',

'JTF_RS_GROUPS_B',

'JTF_RS_RESOURCE_EXTNS',

'IBY_PAYMENT_METHODS_TL',

'PO_LINES_ALL',

'PO_HEADERS_ALL',

'RA_CUST_TRX_LINE_GL_DIST_ALL',

'RA_CUSTOMER_TRX_ALL',

'RA_TERMS_B',

'XLA_AE_LINES',

'XLE_ENTITY_PROFILES',

'XLA_AE_HEADERS',

'XLA_DISTRIBUTION_LINKS',

'XLA_CONTROL_BALANCES',

'XLA_TRANSACTION_ENTITIES',

'XLA_AE_LINE_ACS',

'XLA_AC_BALANCES')

group by owner,segment_name order by "SIZE in GB" desc;