How To Run An Empty Patching Cycle Without Applying A Patch

 

[applmgr@test scripts]$ adop phase=prepare,finalize,cutover,cleanup

How to apply language patches after the main patch has been applied EBS r12.2

1- Apply main patch using below command.

time adop phase=apply patches=31625670 

2- To apply language patches.

time adop phase=apply patches=31625670_D:u31625670.drv,31625670_DK:u31625670.drv,31625670_ESA:u31625670.drv,31625670_F:u31625670.drv,31625670_I:u31625670.drv,31625670_NL:u31625670.drv,31625670_ZHS:u31625670.drv,31625670_ZHT:u31625670.drv  workers=16 wait_on_failed_job=yes flags=autoskip

Presentation Catalog Permission Behavior When Same EBS User Logs Into OBIEE Using Different Responsibilities Back And Forth

What happens is the following:

• User selects a responsibility '<respA>' in EBS, which is mapped to an OBIEE Application Role '<respA>' and is logged in to OBIEE with SSO. The user gets the '<respA>' Application Role in OBIEE
• User logs off using the 'Sign Out' link which returns the user back to EBS
• User selects a different responsibility, '<respB>', but after login to OBIEE the Application Role of the previous session remains active '<respA>', instead of using the new application role '<respB>'

Disable connection pooling:

1- For each Connection Pool in the OBIEE rpd (repository) file, uncheck the "Enable connection pooling" option.

2- Save the rpd and distribute it to the server.

 

ADOP fails with [ERROR] ETCC not run in the database node DBHOSTNAME in R12.2

 Error:-

1- adop phase=prepare.

[ERROR]     ETCC not run in the database node prerptdb01
                The EBS Technology Codelevel Checker needs to be run on the database node.
                It is available as Patch 17537119.
    Encountered the above errors when performing database validations.
    Resolve the above errors and restart adop 

Solution:-

1- It might be due to mismatch in host name between APPS.FND_NODES and APPLSYS.TXK_TCC_RESULTS tables.

2-  Take backup of APPLSYS.TXK_TCC_RESULTS

create table APPS.TXK_TCC_RESULTS_backup as select * from APPLSYS.TXK_TCC_RESULTS;

3- Truncate APPLSYS.TXK_TCC_RESULTS table.

truncate table  APPLSYS.TXK_TCC_RESULTS

4-  UPDATE applsys.txk_tcc_results SET node_name ='<node name>';

Upgrade to Oracle Database 19c from 12c using autoupgrade

 1- Download the most recent version from MOS Note: 2485457.1 – AutoUpgrade Tool.

2- Create sample Auto-Upgrade config file.

java -jar $OH19/rdbms/admin/autoupgrade.jar -create_sample_file config

3- Edit Sample file.

[oracle@dbinstance ~]$ vi sample_config.cfg
[oracle@dbinstance ~]$ vi sample_config.cfg
[oracle@dbinstance ~]$ more sample_config.cfg
# $Header: rdbms/src/server/upgrade/autoupgrade/src/main/resources/autoupgrade/templates/sample_config_unix.properties /st_rdbms_pt-autoupgrade/7 2018/07/11 09:38:
27 frealvar Exp $
#
# Copyright (c) 2017, 2018, Oracle and/or its affiliates.
# All rights reserved.*/
#
#
# DESCRIPTION
# This is a template for config file to be used with autoupgrade tool.
#
# NOTES
# <other useful comments, qualifications, etc.>
#
# MODIFIED    (MM/DD/YY)
# frealvar    07/10/18 - code refactor due to AUPG-250
# frealvar    04/30/18 - AUPG-189 optionally run utlrp and timezone upgrades
# fvallin     04/06/17 - Creation
#
#
#Global configurations
#Autoupgrade's global directory, non-job logs generated,
#temp files created and other autoupgrade files will be
#send here
global.autoupg_log_dir=/home/oracle/upgrade_logs

#
# sample config file
#
#
 Database number 1
#
upg1.dbname=PROD
upg1.start_time=NOW
upg1.source_home=/u02/app/oracle/product/12.1.0/dbhome_1
upg1.target_home=/u01/app/oracle/product/12.1.0/dbhome_1
upg1.sid=PROD
upg1.log_dir=/home/oracle/logs
upg1.upgrade_node=localhost
upg1.target_version=19.3
#upg1.run_utlrp=yes
#upg1.timezone_upg=yes
#

4- Make one directory called upgrade_logs and logs which will hold all the config files, log files during this upgrade.

[oracle@dbinstance ~]$ mkdir -p /home/oracle/upgrade_logs

[oracle@dbinstance ~]$ mkdir -p /home/oracle/logs

[oracle@dbinstance ~]$ cp sample_config.cfg UPGR.cfg

5- Running AutoUpgrade.jar

ANALYZE mode.

[oracle@dbinstance ~]$ java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config /home/oracle/UPGR.cfg -mode analyze
Autoupgrade tool launched with default options
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be analyzed
Enter some command, type 'help' or 'exit' to quit
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
|JOB#|DB NAME|    STAGE|OPERATION| STATUS|    START TIME|END TIME| UPDATED|       MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
| 100|   PROD|PRECHECKS|PREPARING|RUNNING|20/05/18 15:11|     N/A|15:11:09|Remaining 0/75|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
Total jobs 1
upg>
Job 100 for PROD FINISHED
[oracle@dbinstance ~]$

upg> status -job 102

Progress

-----------------------------------

Start time:      20/05/18 15:13

Elapsed (min):   122

End time:        N/A

Last update:     2020-05-18T17:15:05.211

Stage:           POSTFIXUPS

Operation:       EXECUTING

Status:          RUNNING

Pending stages:  2

Job Logs Locations

-----------------------------------

Logs Base:    /home/oracle/logs

Job logs:     /home/oracle/logs/102

Stage logs:   /home/oracle/logs/102/postfixups

TimeZone:     /home/oracle/logs/temp

Additional information

-----------------------------------

Details:

Starting FIXUPS execution

Error Details:

None

upg>

Job 102 for PROD FINISHED

[oracle@dbinstance ~]$

6- Check below html file under /home/oracle/upgrade_logs and fix the errors.

7- Deploy mode.

[oracle@dbinstance ~]$ java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config /home/oracle/UPGR.cfg -mode deploy
Previous execution found
loading latest data
Total jobs recovered: 1
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
Enter some command, type 'help' or 'exit' to quit
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
|JOB#|DB NAME|    STAGE|OPERATION| STATUS|    START TIME|END TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
| 102|   PROD|PRECHECKS|PREPARING|RUNNING|20/05/18 15:13|     N/A|16:12:07|       |
+----+-------+---------+---------+-------+--------------+--------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
|JOB#|DB NAME|    STAGE|OPERATION| STATUS|    START TIME|END TIME| UPDATED|       MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
| 102|   PROD|PRECHECKS|PREPARING|RUNNING|20/05/18 15:13|     N/A|16:12:14|Remaining 1/75|
+----+-------+---------+---------+-------+--------------+--------+--------+--------------+
Total jobs 1
upg> lsj

upg> lsj

+----+-------+---------+---------+-------+--------------+--------+--------+-----------+

|JOB#|DB NAME|    STAGE|OPERATION| STATUS|    START TIME|END TIME| UPDATED|    MESSAGE|

+----+-------+---------+---------+-------+--------------+--------+--------+-----------+

| 102|   PROD|DBUPGRADE|EXECUTING|RUNNING|20/05/18 15:13|     N/A|16:35:28|0%Upgraded |

+----+-------+---------+---------+-------+--------------+--------+--------+-----------+

Total jobs 1

upg> status

---------------- Config -------------------

User configuration file    [/home/oracle/UPGR.cfg]

General logs location      [/home/oracle/upgrade_logs/cfgtoollogs/upgrade/auto]

Mode                       [DEPLOY]

DB upg fatal errors        ORA-00600,ORA-07445

DB Post upgrade abort time [60] minutes

DB upg abort time          [1440] minutes

DB restore abort time      [120] minutes

DB drop GRP abort time     [3] minutes

------------------- Jobs -------------------

Total databases in configuration file [1]

Total Non-CDB being processed         [1]

Total CDB being processed             [0]

Jobs finished successfully            [0]

Jobs finished/aborted                 [0]

jobs in progress                      [1]

------------ Resources ----------------

Threads in use                        [62]

JVM used memory                       [105] MB

CPU in use                            [13%]

Processes in use                      [18]

8- Completion Message.

upg>

Job 102 for PROD FINISHED

9- Check the database version

[oracle@dbinstance ~]$ export ORACLE_SID=PROD

[oracle@dbinstance ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 18 17:43:37 2020

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

 select name from v$database;

NAME

---------

PROD

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;

shrink Datafiles and Reclaim unused Space in Oracle

Space issue:-

Found space utilization at data file mount point on prod.

/dev/mapper/datavg-lvol0 404G  365G   19G  96% /saprod_data01   

Avail Use% Mounted on

/dev/mapper/datavg-lvol1 404G  372G   12G  97% /saprod_data02

Solution:-

Step1:- verify 

set linesize 400
col tablespace_name format a15
col file_size format 99999
col file_name format a50
col hwm format 99999
col can_save format 99999
SELECT tablespace_name, file_name, file_size, hwm, file_size-hwm can_save
FROM (SELECT /*+ RULE */ ddf.tablespace_name, ddf.file_name file_name,
ddf.bytes/1048576 file_size,(ebf.maximum + de.blocks-1)*dbs.db_block_size/1048576 hwm
FROM dba_data_files ddf,(SELECT file_id, MAX(block_id) maximum FROM dba_extents GROUP BY file_id) ebf,dba_extents de,
(SELECT value db_block_size FROM v$parameter WHERE name='db_block_size') dbs
WHERE ddf.file_id = ebf.file_id
AND de.file_id = ebf.file_id
AND de.block_id = ebf.maximum
ORDER BY 1,2);

Step 2:- Output of the script

--------------- -------------------------------------------------- --------- ------ --------
BIAPPS_BIACOMP  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_b       624    584       40
                iacomp.dbf
BIAPPS_BIA_ODIR /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_o     18704  17799      905
EPO             di.dbf
BIAPPS_BIPLATFO /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_b        64     16       48
RM              iplatform.dbf
BIAPPS_DW_DATA  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_d     32768  32768        0
                wdata.dbf
TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
BIAPPS_DW_DATA  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_d     10240  10177       63
                wdata5.dbf
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata1.dbf               32704  32697        7
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata2.dbf               32704  32641       63
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata3.dbf               32704  32704        0
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata4.dbf               20480  20480        0
BIAPPS_MDS      /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_m       100     18       82
                ds.dbf

TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
DACREP_PRODDATA /saprod_data01/oracle/base/oradata/SAPROD/dacrep_d      2048    878     1170
                ata01.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     32768  32767        1
                01.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                02.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                03.dbf
TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                04.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31593      151
                05.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                06.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     32767  32726       41
TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
                07.dbf
DWH_PRODDATA    /saprod_data02/saprod/dwh_data07.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data08.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data09.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data10.dbf                   20480  20480        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data11.dbf                   20480  20479        1
EXAMPLE         /saprod_data01/oracle/base/oradata/SAPROD/example0       100     81       19
                1.dbf
INFAREP_PRODDAT /saprod_data01/oracle/base/oradata/SAPROD/infarep_      3072   2120      952
TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
A               data01.dbf
PROD_BIPLATFORM /saprod_data01/oracle/base/oradata/SAPROD/PROD_bip        64      2       62
                latform.dbf
PROD_MDS        /saprod_data01/oracle/base/oradata/SAPROD/PROD_mds       100      6       94
                .dbf
SYSAUX          /saprod_data01/oracle/base/oradata/SAPROD/sysaux01      3072   1591     1481
                .dbf

TABLESPACE_NAME FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
SYSTEM          /saprod_data01/oracle/base/oradata/SAPROD/system01      5120   3264     1856
                .dbf
UNDOTBS1        /saprod_data01/oracle/base/oradata/SAPROD/undotbs0     23020  22273      747
                1.dbf
USERS           /saprod_data01/oracle/base/oradata/SAPROD/users01.         5      4        1
                dbf

31 rows selected.
SQL>

By the output i can reclaim space around  7.783g of space

Step3:-Run below query 

set linesize 1000 pagesize 0 feedback off trimspool on
with
 hwm as (
  -- get highest block id from each datafiles ( from x$ktfbue as we don't need all joins from dba_extents )
  select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1) hwm_blocks
  from sys.x$ktfbue group by ktfbuefno,ktfbuesegtsn
 ),
 hwmts as (
  -- join ts# with tablespace_name
  select name tablespace_name,relative_fno,hwm_blocks
  from hwm join v$tablespace using(ts#)
 ),
 hwmdf as (
  -- join with datafiles, put 5M minimum for datafiles with no extents
  select file_name,nvl(hwm_blocks*(bytes/blocks),5*1024*1024) hwm_bytes,bytes,autoextensible,maxbytes
  from hwmts right join dba_data_files using(tablespace_name,relative_fno)
 )
select
 case when autoextensible='YES' and maxbytes>=bytes
 then -- we generate resize statements only if autoextensible can grow back to current size
  '/* reclaim '||to_char(ceil((bytes-hwm_bytes)/1024/1024),999999)
   ||'M from '||to_char(ceil(bytes/1024/1024),999999)||'M */ '
   ||'alter database datafile '''||file_name||''' resize '||ceil(hwm_bytes/1024/1024)||'M;'
 else -- generate only a comment when autoextensible is off
  '/* reclaim '||to_char(ceil((bytes-hwm_bytes)/1024/1024),999999)
   ||'M from '||to_char(ceil(bytes/1024/1024),999999)
   ||'M after setting autoextensible maxsize higher than current size for file '
   || file_name||' */'
 end SQL
from hwmdf
where
 bytes-hwm_bytes>1024*1024 -- resize only if at least 1MB can be reclaimed
order by bytes-hwm_bytes desc
/

Step4:- Output

SQL

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/* reclaim    5115M from    5120M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_dwstage.dbf' resize 5M;

/* reclaim    5115M from    5120M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_dwindex.dbf' resize 5M;

/* reclaim    5115M from    5120M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/dwh_index02.dbf' resize 5M;

/* reclaim    2043M from    2048M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/dwh_index01.dbf' resize 5M;

/* reclaim    1857M from    5120M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/system01.dbf' resize 3264M;

/* reclaim    1482M from    3072M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/sysaux01.dbf' resize 1591M;

/* reclaim    1171M from    2048M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/dacrep_data01.dbf' resize 878M;

/* reclaim     953M from    3072M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/infarep_data01.dbf' resize 2120M;

/* reclaim     905M from   18704M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_odi.dbf' resize 17800M;

/* reclaim     748M from   23020M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/undotbs01.dbf' resize 22273M;

/* reclaim     152M from   31744M after setting autoextensible maxsize higher than current size for file /saprod_data01/oracle/base/oradata/SAPROD/dwh_data05.dbf */

SQL

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/* reclaim      95M from     100M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/PROD_mds.dbf' resize 6M;

/* reclaim      83M from     100M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_mds.dbf' resize 18M;

/* reclaim      64M from   10240M after setting autoextensible maxsize higher than current size for file /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_dwdata5.dbf */

/* reclaim      64M from   32704M */ alter database datafile '/saprod_data02/saprod/BIAPPS_dwdata2.dbf' resize 32641M;

/* reclaim      63M from      64M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/PROD_biplatform.dbf' resize 2M;

/* reclaim      48M from      64M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_biplatform.dbf' resize 17M;

/* reclaim      42M from   32767M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/dwh_data07.dbf' resize 32726M;

/* reclaim      41M from     624M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_biacomp.dbf' resize 584M;

/* reclaim      19M from     100M */ alter database datafile '/saprod_data01/oracle/base/oradata/SAPROD/example01.dbf' resize 82M;

/* reclaim       8M from   32704M */ alter database datafile '/saprod_data02/saprod/BIAPPS_dwdata1.dbf' resize 32697M;

21 rows selected.

SQL>

Step5:- Resize all datafile using above output.

Step6:-Execute step1 query to check changes after resizing of datafiles.

Tablespace      FILE_NAME                                          FILE_SIZE    HWM CAN_SAVE
--------------- -------------------------------------------------- --------- ------ --------
BIAPPS_BIACOMP  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_b       584    584        0
                iacomp.dbf
BIAPPS_BIA_ODIR /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_o     17800  17799        1
EPO             di.dbf
BIAPPS_BIPLATFO /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_b        17     16        1
RM              iplatform.dbf
BIAPPS_DW_DATA  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_d     32768  32768        0
                wdata.dbf
BIAPPS_DW_DATA  /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_d     10240  10177       63
                wdata5.dbf
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata1.dbf               32761  32697       64
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata2.dbf               32705  32641       64
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata3.dbf               32704  32704        0
BIAPPS_DW_DATA  /saprod_data02/saprod/BIAPPS_dwdata4.dbf               20480  20480        0
BIAPPS_MDS      /saprod_data01/oracle/base/oradata/SAPROD/BIAPPS_m        18     18        0
                ds.dbf
DACREP_PRODDATA /saprod_data01/oracle/base/oradata/SAPROD/dacrep_d       878    878        0
                ata01.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     32768  32767        1
                01.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                02.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                03.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                04.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31593      151
                05.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     31744  31744        0
                06.dbf
DWH_PRODDATA    /saprod_data01/oracle/base/oradata/SAPROD/dwh_data     32726  32726        0
                07.dbf
DWH_PRODDATA    /saprod_data02/saprod/dwh_data07.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data08.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data09.dbf                   32767  32767        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data10.dbf                   20480  20480        0
DWH_PRODDATA    /saprod_data02/saprod/dwh_data11.dbf                   20480  20479        1
EXAMPLE         /saprod_data01/oracle/base/oradata/SAPROD/example0        82     81        1
                1.dbf
INFAREP_PRODDAT /saprod_data01/oracle/base/oradata/SAPROD/infarep_      2120   2120        0
A               data01.dbf
PROD_BIPLATFORM /saprod_data01/oracle/base/oradata/SAPROD/PROD_bip         2      2        0
                latform.dbf
PROD_MDS        /saprod_data01/oracle/base/oradata/SAPROD/PROD_mds         6      6        0
                .dbf
SYSAUX          /saprod_data01/oracle/base/oradata/SAPROD/sysaux01      1731   1591      140
                .dbf
SYSTEM          /saprod_data01/oracle/base/oradata/SAPROD/system01      3264   3264        0
                .dbf
UNDOTBS1        /saprod_data01/oracle/base/oradata/SAPROD/undotbs0     22273  22273        0
                1.dbf
USERS           /saprod_data01/oracle/base/oradata/SAPROD/users01.         5      4        1
                dbf

31 rows selected.
SQL>

In earlier output possible savings is 7.783g , Now possible savings is 356mb, So we reclaimed 7gb of space at OS level

Step6:- check space at os level

/dev/mapper/datavg-lvol0

                      404G  341G   43G  89% /saprod_data01

/dev/mapper/datavg-lvol1

                      404G  360G   24G  94% /saprod_data02

/dev/mapper/datavg-lvol2

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized.

 Error:-

Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of _ASH_SIZE to a sufficiently large value. Currently, ASH size is 8388608 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:

 select total_size,awr_flush_emergency_count from v$ash_info;

Solution:-

The current ASH size is displayed in the message in the alert log, or can be found using the following SQL statement.

SQL>  select total_size,awr_flush_emergency_count from v$ash_info;
TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT
---------- -------------------------
   8388608                         1

Then increase the value for _ash_size by some value, like 50% more than what is currently allocated.  For example if total_size = 16MB, then an increase of 50% more would be (16MB + (16MB * 50%)) = 24MB.

SQL> alter system set "_ash_size"=12450000;

System altered.

SQL> select total_size,awr_flush_emergency_count from v$ash_info;

TOTAL_SIZE AWR_FLUSH_EMERGENCY_COUNT

---------- -------------------------

  12450000                         2

ADUTILITIES & AUTOCONFIG

 

OPATCH_JAVA_ERROR : An exception of type "OPatchException" has occurred - 10.1.2 Home in EBS R12

 Error:-

[applmgr@ebslearning appl]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home           : /u02/R12APP/fs1/EBSapps/10.1.2
Oracle Home Inventory : /u02/R12APP/fs1/EBSapps/10.1.2/inventory
Central Inventory     : /u01/clonedb/database/PROD/db/tech_st/11.2.0.4/oraInvent                                                      ory
   from               : /etc/oraInst.loc
OUI location          : /u02/R12APP/fs1/EBSapps/10.1.2/oui
OUI shared library    : /u02/R12APP/fs1/EBSapps/10.1.2/oui/lib/linux/liboraInsta                                                      ller.so
Java location         : /u02/R12APP/fs1/EBSapps/10.1.2/jdk/jre/bin/java
Log file location     : /u02/R12APP/fs1/EBSapps/10.1.2/.patch_storage/<patch ID>                                                      /*.log
Creating log file "/u02/R12APP/fs1/EBSapps/10.1.2/.patch_storage/LsInventory__07                                                      -01-2018_16-28-31.log"
Result:
LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
OPatch Exception:  OUI found no such ORACLE_HOME set in the environment
  Can not get details for given Oracle Home
  An exception occurs
  null

There is no Interim Patch
OPATCH_JAVA_ERROR  : An exception of type "OPatchException" has occurred:
Can not get a list of inventory on this home.
ERROR: OPatch failed because of Inventory problem.

Solution:-

[applmgr@ebslearning appl]$ cd $ORACLE_HOME

[applmgr@ebslearning 10.1.2]$ cat oraInst.loc

inventory_loc=/u01/clonedb/database/PROD/db/tech_st/11.2.0.4/oraInventory

inst_group=dba

[applmgr@ebslearning 10.1.2]$ ll /u01/clonedb/database/PROD/db/tech_st/11.2.0.4/oraInventory

total 8

drwxrwx--- 2 oracle dba 4096 Jul  1 16:19 ContentsXML

drwxrwx--- 2 oracle dba 4096 Jul  1 16:19 logs

[applmgr@ebslearning 10.1.2]$ cd oui/

[applmgr@ebslearning oui]$ ls

bin                   guide  oraparam.ini

clusterparam.ini      jlib   oraparam.ini.bak

clusterparam.ini.bak  lib    ouica.properties

[applmgr@ebslearning oui]$ cd bin/

[applmgr@ebslearning bin]$ ls

addNode.sh      attachHome.sh.bak  ouica.sh.bak  runInstaller.sh

addNode.sh.bak  lsnodes            resource      runInstaller.sh.bak

attachHome.sh   ouica.sh           runInstaller

[applmgr@ebslearning bin]$ ./attachHome.sh

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-07-01_04-32-19PM. 

Please wait ...

[applmgr@ebslearning bin]$ Java HotSpot(TM) Server VM warning: You have loaded library /tmp/OraInstall2018-07-01_04-32-19PM/oui/lib/liux/liboraInstaller.so which might have disabled stack guard. 

The VM will try tofix the stack guard now.

It's highly recommended that you fix the library with 'execstack -c <libfile>',or link it with '-z noexecstack'.

'AttachHome' was successful.

[applmgr@ebslearning bin]

Exception In Thread “Main” Java.Lang.OutOfMemoryError: GC Overhead Limit Exceeded With Bsu.sh

Error:-

[applmgr@ebslearning bsu]$ sh bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=QMJP -prod_dir=$FMW_HOME/wlserver_10.3

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

        at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.getProperties(SchemaTypeImpl.java:707)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:775)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)

        at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)

        at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)

        at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)

        at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)

        at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)

        at com.bea.plateng.patch.Patch.main(Patch.java:281)

Solution:-

[applmgr@ebslearning bsu]$ cat bsu.sh

#!/bin/sh

JAVA_HOME="/u02/R12APP/fs1/EBSapps/comn/util/jdk64"

MEM_ARGS="-Xms512m -Xmx1024m -XX:+UseParallelGC"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

[applmgr@ebslearning bsu]$ vi bsu.sh

[applmgr@ebslearning bsu]$ cat bsu.sh

#!/bin/sh

JAVA_HOME="/u02/R12APP/fs1/EBSapps/comn/util/jdk64"

MEM_ARGS="-Xms1024m -Xmx2048m -XX:+UseParallelGC"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

The Applications System names per the APPL_TOP and the database are different

 Adpatch Fails : 'The Applications System names per the APPL_TOP and the database are different.' (Doc ID 213339.1)

Unable to Patch a Cloned Environment Because of Wrong Applications System Names (Doc ID 202483.1)

Error:-

We recently faced an issue after development instance cloned from production.

adadmin Failed with the below errors.

The Applications System names per the APPL_TOP and the database

are different.

    Applications System name per the APPL_TOP: uaterp

    Applications System name per the database: THRMS

If you continue, the Applications System name per the APPL_TOP will

be ignored.

Do you wish to continue [No] ?

Solution:-

SQL> desc FND_PRODUCT_GROUPS
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
PRODUCT_GROUP_ID                          NOT NULL NUMBER(15)
LAST_UPDATE_DATE                          NOT NULL DATE
LAST_UPDATED_BY                           NOT NULL NUMBER(15)
CREATION_DATE                             NOT NULL DATE
CREATED_BY                                NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN                         NOT NULL NUMBER(15)
PRODUCT_GROUP_NAME                        NOT NULL VARCHAR2(60)
RELEASE_NAME                              NOT NULL VARCHAR2(50)
PRODUCT_GROUP_TYPE                        NOT NULL VARCHAR2(30)
ARGUMENT1                                          VARCHAR2(30)
MULTI_ORG_FLAG                                     VARCHAR2(1)
MULTI_LINGUAL_FLAG                                 VARCHAR2(1)
MULTI_CURRENCY_FLAG                                VARCHAR2(1)
APPLICATIONS_SYSTEM_NAME                  NOT NULL VARCHAR2(30)
IS_NEW_TS_MODE                                     VARCHAR2(1)
ARU_RELEASE_NAME                                   VARCHAR2(50)

SQL> select APPLICATIONS_SYSTEM_NAME from FND_PRODUCT_GROUPS;
APPLICATIONS_SYSTEM_NAME
------------------------------
THRMS

SQL> update FND_PRODUCT_GROUPS
  2  set APPLICATIONS_SYSTEM_NAME='uaterp'
  3  ;
1 row updated.

SQL> commit;

Commit complete.

SQL> select APPLICATIONS_SYSTEM_NAME from FND_PRODUCT_GROUPS;
APPLICATIONS_SYSTEM_NAME
------------------------------
uaterp
SQL>

oracle.apps.fnd.framework.OAException: No data found for region

 Issue-

When user  trying to login in application he is not able to see the home page and there is an error.

oracle.apps.fnd.framework.OAException: No data found for region (/oracle/apps/fnd/framework/navigate/webui/NewHomePG).         at oracle.apps.fnd.framework.webui.JRAD2AKMapper.loadPage(JRAD2AKMapper.java:784)         at oracle.apps.fnd.framework.webui.OAPageBean.initializeCustomizationsMDS(OAPageBean.java:7394)         at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2525)         at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2066)         at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:585)         at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:473)         at _pages.__oa._jspService(__oa.java:233)         at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)         at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)         at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)         at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)         at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)         at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)         at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:527)         at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)         at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)         at _pages.__oa._jspService(__oa.java:246)         Solution:- 1- check Personalization.  SELECT  jdr_mds_internal.getDocumentName(path_docid) as component       ,       path_type       ,       path_seq       ,       creation_date       ,       last_update_date       FROM  ( SELECT  path_docid               ,       path_type               ,       path_seq               ,       creation_date               ,       last_update_date               FROM    jdr_paths               START WITH path_owner_docid = jdr_mds_internal.getDocumentID(('/'))               CONNECT BY PRIOR path_docid = path_owner_docid) paths       WHERE ( path_type = 'DOCUMENT' AND path_seq = -1)         OR  ( path_type = 'PACKAGE'  AND path_seq = 0)         OR  ( path_type = 'PACKAGE'  AND path_seq = -1           AND NOT EXISTS (                 SELECT * FROM jdr_paths                 WHERE path_owner_docid = paths.path_docid))                 order by last_update_date desc; 2- Delete Personalization from user level, exec jdr_utils.deletedocument('/oracle/apps/fnd/framework/navigate/webui/customizations/user/7071/NewHomePG'); 3- User able to login

x

ORACLE HANG ANALYZE

 Below given are the steps to generate Hanganalyze and Systemstate 

Hanganalyze: 

===================== 

sqlplus '/ as sysdba' 

oradebug setmypid; 

oradebug unlimit; 

oradebug hanganalyze 3; 

-- Wait upto 1 minute before getting the second hanganalyze 

oradebug hanganalyze 3; 

-- Wait upto 1 minute before getting the second hanganalyze 

oradebug hanganalyze 3; 

oradebug tracefile_name; 

exit 

Systemstate Dump: 

================ 

sqlplus '/ as sysdba' 

oradebug setmypid; 

oradebug unlimit; 

oradebug dump systemstate 258; 

-- Wait upto 1 minute before getting the second system state 

oradebug dump systemstate 258; 

-- Wait upto 1 minute before getting the second system state 

oradebug dump systemstate 258; 

oradebug tracefile_name; 

exit 

Reset a Purchase Order From In Process To Incomplete

 How to Set to po incomplete - EBS.

SQL> @poxrespo.sql

Please enter the PO number to reset : 563407

Please enter the organization id to which the PO belongs (Default NULL) : 81

Do you want to delete the action history since the last approval ? (Y/N) Y

Processing STANDARD PO Number: 563407

......................................

Updating PO Status..

Done Approval Processing.

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[ebs@SOUL sql]$

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version

 

Control file version 11.2.0.1.0 incompatible with ORACLE version 10.2.0.3.0

 

SQL> startup;

ORACLE instance started.

Total System Global Area 2004340736 bytes

Fixed Size                  2256544 bytes

Variable Size            1006633312 bytes

Database Buffers          973078528 bytes

Redo Buffers               22372352 bytes

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version

10.2.0.0.0

ORA-00202: control file: 'D:\ORACLE\GPQ\ORIGLOGA\CNTRL\CNTRLGPQ.DBF'

SQL> show parameter compatible

NAME                                 TYPE

------------------------------------ ---------------------------------

VALUE

------------------------------

compatible                           string

10.2.0

SQL> alter system set compatible='11.2.0.0.0' scope=spfile;

System altered.

SQL> shut immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 2004340736 bytes

Fixed Size                  2256544 bytes

Variable Size            1006633312 bytes

Database Buffers          973078528 bytes

Redo Buffers               22372352 bytes

Database mounted.

 

SQL> show parameter compatible

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      11.2.0.0.0

SQL>