When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure : RC-00118: Error occurred during creation of database

Error:

When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure :
...

getConnectionUsingAppsJDBCConnector() -->
  APPS_JDBC_URL='null'
  Trying to get connection using SID based connect descriptor
getConnection() -->
  sDbHost    :
  sDbDomain  :
  sDbPort    :
  sDbSid     :
  sDbUser    : APPS
  Trying to connect using SID...
getConnectionUsingSID() -->
  JDBC URL: jdbc:oracle:thin:@:
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
  JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=.)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Connection could not be obtained; returning null

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
...


Relevent env:

Oracle Applications Manager - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Cause:

DNS is not set properly.

Solutions:

Check that DNS is working properly as given below.

nslookup .

You can use the /etc/hosts also if you are using it for resolving the names.



Follow this document for more details.

' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' (Doc ID 1299429.1)

How to generate the XML Debug Logs (Output Post Processor) for 'Payment Register'.

How to generate the XML Debug Logs (Output Post Processor) for 'Payment Register'.


1. Create the temp directory in $XDO_TOP
On the applications tier move to $XDO_TOP
 - create a temp directory - mkdir temp
 - set the permissions - chmod 777 temp
 - Use pwd and copy this directory location - it will be used in step 2


[applmgr@hostname ~]$ cd $XDO_TOP
[applmgr@hostname 12.0.0]$ mkdir temp


2. Create the Debug Config file
On the Applications Tier - change to $OA_JRE_TOP/bin - cd $OA_JRE_TOP/bin
- Execute this command - ./java -verbose | grep jre | grep 'java.lang.Runtime '
   -In the results - the complete path is present showing where the rt.jar resides
   - change to this directory - this is where the xdedebug.cfg should be created
- Use vi to create a new file called xdodebug.cfg

Enter these two lines:
LogLevel=STATEMENT
LogDir=complete_path_to_$XDO_TOP/temp directory you created


[applmgr@hostname 12.0.0]$ cd $OA_JRE_TOP/bin
[applmgr@hostname bin]$ ./java -verbose | grep jre | grep 'java.lang.Runtime '
[Loaded java.lang.Runtime from /app/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar]
[applmgr@hostname bin]$ cd /app/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/
[applmgr@hostname lib]$ vi xdodebug.cfg
[applmgr@hostname lib]$ vi xdodebug.cfg
[applmgr@hostname lib]$ cat xdodebug.cfg
LogLevel=STATEMENT
LogDir=/app/apps/apps_st/appl/xdo/12.0.0/temp
[applmgr@hostname lib]$




3. Restart the Middle tier
cd $INST_TOP/admin/scripts
./adstopall.sh apps/apps
./adstrtall.sh apps/apps



4. Engage PO Output for Communication - using standard style sheet

Purchasing - Reports/Run
 - Pass in the parameters to print the purchase order
 - Leave the Debug parameter as the default
 - Submit the request

5. Retrieve the logs

Move to $XDO_TOP/temp
 - Here there are files crearted, please collect these and put into a zip file.

Running concurrent requests in Oracle Apps EBS (11i,R12)

Set Pages 1000
Set head on
Column Manager   Format A12
Column Request   Format 999999999
Column Program   Format A30
Column User_Name Format A15
Column Started   Format A15
Column OSprocess Format A9
Column SPID      Format A9
Column LocalProcess Format A9
prompt Managers that are currently running a request;
prompt ;
Select /*+ RULE */ substr(Concurrent_Queue_Name,1,12) Manager,
       Request_Id Request, User_name,
       Fpro.OS_PROCESS_ID OSprocess,
      fcr.oracle_process_id LocalProcess,
       substr(Concurrent_Program_Name,1,35) Program, Status_code,
       To_Char(Actual_Start_Date, 'DD-MON-YY HH24:MI') Started
  from apps.Fnd_Concurrent_Queues Fcq, apps.Fnd_Concurrent_Requests Fcr,
      apps.Fnd_Concurrent_Programs Fcp, apps.Fnd_User Fu, apps.Fnd_Concurrent_Processes Fpro
 where
       Phase_Code = 'R' And
       Status_Code <> 'W' And
       Fcr.Controlling_Manager = Concurrent_Process_Id       And
      (Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id    And
       Fcq.Application_Id      = Fpro.Queue_Application_Id ) And
      (Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id And
       Fcr.Program_Application_Id = Fcp.Application_Id )     And
       Fcr.Requested_By = User_Id
       order by Started
/

Concurrent request details

set line 300
set pages 200
select r.request_id, s.inst_id,s.sid, s.serial#, s.status,
 substr(r.oracle_process_id, 1, 13) "REQUEST OS",
 r.status_code,r.phase_code, substr(fp.OS_PROCESS_ID, 1, 13) "CM OS ID"
from apps.fnd_concurrent_requests r,
 apps.fnd_concurrent_processes fp,
 gv$session s,
 gv$process p
where r.controlling_manager = fp.concurrent_process_id and
 r.oracle_process_id = p.spid and
 s.inst_id = p.inst_id and
 p.addr = s.paddr and
 r.request_id in (&reqid) order by r.request_id;

Concurrent Manager monitoring scripts

set line 200
set pages 100
col "Concurrent Manager's Name" format a60
spool comcurrent_manger_status.lst
SELECT b.USER_CONCURRENT_QUEUE_NAME AS "Concurrent Manager's Name",
       a.max_processes AS "TARGET Processes",
       a.running_processes AS "ACTUAL Processes",
       'Mismatch' Status
FROM apps.fnd_concurrent_queues a,apps.FND_CONCURRENT_QUEUES_VL b
 WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME
 and a.max_processes <> a.running_processes;

SELECT b.Pending_Standby,
       b.Pending_Normal,
       b.name AS "Concurrent Manager's Name",
       a.max_processes AS "TARGET Processes",
       a.running_processes AS "ACTUAL Processes",
       b.Running_Normal
  FROM apps.fnd_concurrent_queues a,
       (  SELECT c.USER_CONCURRENT_QUEUE_NAME Name,
                 c.CONCURRENT_QUEUE_NAME,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'P', DECODE (d.STATUS_CODE, 'Q', 1, 0),
                            0))
                    Pending_Standby,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'P', DECODE (d.STATUS_CODE, 'I', 1, 0),
                            0))
                    Pending_Normal,
                 SUM (
                    DECODE (d.PHASE_CODE,
                            'R', DECODE (d.STATUS_CODE, 'R', 1, 0),
                            0))
                    Running_Normal
            FROM apps.FND_CONCURRENT_QUEUES_VL c, apps.FND_CONCURRENT_WORKER_REQUESTS d
           WHERE     c.concurrent_queue_id = d.concurrent_queue_id
                 AND d.Requested_Start_Date <= SYSDATE
        GROUP BY c.USER_CONCURRENT_QUEUE_NAME, c.CONCURRENT_QUEUE_NAME) b
 WHERE a.CONCURRENT_QUEUE_NAME = b.CONCURRENT_QUEUE_NAME;

Query to get user details with responsibility list in Oracle Apps EBS

select fu.user_name, frt.RESPONSIBILITY_NAME, furg.end_date

from

fnd_user_resp_groups furg,

FND_RESPONSIBILITY fr,

fnd_responsibility_tl frt,

fnd_user fu

where fu.user_id = furg.user_id

and furg.responsibility_id = fr.RESPONSIBILITY_ID

and frt.responsibility_id = fr.RESPONSIBILITY_ID

order by 1;

Above query is to list the user with responsibility in Oracle Apps

Query to find the Activity Status of the workflow

Title:	Query to find the Activity Status of the workflow
Description:	The following query is to determine the activity status of the workflow for which the item type(internal Workflow name) and item key(Particular instance) is known. Both are mandatory parameters and they are case sensitive.
Query:	SELECT TO_CHAR(WIAS.BEGIN_DATE, 'DD-MON-RR HH24:MI:SS') BEGIN_DATE, TO_CHAR(WIAS.END_DATE, 'DD-MON-RR HH24:MI:SS') END_DATE, WAP.NAME || '/' || WPA.INSTANCE_LABEL ACTIVITY, WIAS.ACTIVITY_STATUS STATUS, WIAS.ACTIVITY_RESULT_CODE RESULT, WIAS.ASSIGNED_USER ASSIGNED_USER, WIAS.NOTIFICATION_ID "Notification Id", WN.STATUS "Status", WIAS.ACTION, WIAS.PERFORMED_BY FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WAC, WF_ACTIVITIES WAP, WF_ITEMS WI, WF_NOTIFICATIONS WN WHERE WIAS.ITEM_TYPE = '&item_type' AND WIAS.ITEM_KEY = '&item_key' AND WI.ITEM_TYPE = '&item_type' AND WI.ITEM_KEY = WIAS.ITEM_KEY AND WI.BEGIN_DATE >= WAC.BEGIN_DATE AND WI.BEGIN_DATE < NVL(WAC.END_DATE, WI.BEGIN_DATE + 1) AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID AND WPA.ACTIVITY_NAME = WAC.NAME AND WPA.ACTIVITY_ITEM_TYPE = WAC.ITEM_TYPE AND WPA.PROCESS_NAME = WAP.NAME AND WPA.PROCESS_ITEM_TYPE = WAP.ITEM_TYPE AND WPA.PROCESS_VERSION = WAP.VERSION AND AND WN.NOTIFICATION_ID(+) = WIAS.NOTIFICATION_ID ORDER BY WIAS.BEGIN_DATE, WIAS.EXECUTION_TIME

Oracle EBS INVENTORY QUIZ.................. Part 1

INVENTORY QUIZ


1.Repeat any Japanese you may have learned and what does it mean?


2.When your cursor has highlighted a menu navigation choice, what two stroke key sequence will show a list of all 'executable forms'?


3.Why can't you perform a miscellaneous transaction (receipt or issue) against the item - GO GREEN BAY?


4.What are the Oracle Inventory attributes settings to correctly identify an item as a kanban item? Don't list the routine Inventory item attributes that are for normal items, i.e. stockable, transactable, etc.


5.Of the three - Discrete, Repetitive, or MRP/MPS - which never employs the usage of Kanbans?


6.What is the last time this kanban item saw transactional activity: TOMS CANNY KANBAN ITEM?

Oracle EBS INVENTORY QUIZ.................... Part 2

INVENTORY QUIZ


1.What Item has the two words GREEN BAY embedded in it?


2.What is the On Hand quantity for this item?


3.Which sub-inventory is holding this on hand quantity?


4.Can this item be built in WIP?


5.Is this item purchasable?


6.What are the digits of the second segment (account segment) of the material overhead account in the costing info tab of the organization parameters for the PET Modality?

IO error writing block to file %s (block # %s)

"IO error writing block to file %s (block # %s)"
// *Cause: Device on which the file resides is probably offline
// *Action: Restore access to the device



Solution : -


Disk is full

so remove log and out files from $APPLCSF/

Disastar recovery setup

Purpose : DC to DR Instance Change
TASK-1:- Workaround at DC
Shutdown Process:

To Shutdown the ERP at first you have to stop in the following order.
1. Application
2. Listener
3. Database

For Application Shutdown login on 1.1.1.13 server as applmgr user.

login as: applmgr
Password:
Last login: Tue May 12 16:24:09 2009 from 172.16.67.124
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
You have mail.
$ cd /u/inst/apps/PROD_erpapps/admin/scripts/
$ ./adstpall.sh USERNAME/PASSWORD

Check that Exiting with status is 0 always to ensure that everything is started Properly.



For Database and Listener shutdown login on 1.1.1.12 server with applmgr user.

login as: applmgr
Password:
Last login: Tue May 12 12:38:56 2009
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:18:25 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ lsnrctl stop ABC
LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 14-MAY-2009 19:19:50

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCABC))
The command completed successfully
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:20:00 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2049464 bytes
Variable Size 427821640 bytes
Database Buffers 633339904 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:20:28 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.

TASK 2:- Workaround at DR
Startup Process:
To Start the ERP at first you have to start in the following order.
1. Database
2. Listener
3. Application

For Database and Listener startup login on 1.1.1.36 server with applmgr user.

Screen Output:

login as: applmgr
Password:
Last login: Mon May 11 19:53:35 2009 from
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).

##########################################
Run ORA_NLS10_setup for DB Startup
##########################################
STARTING THE DATABASE

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 12 09:52:44 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2049464 bytes
Variable Size 427821640 bytes
Database Buffers 633339904 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

STARTING THE LISTENER

$ lsnrctl start ABC

LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 12-MAY-2009 09:53:30

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /ud/db/tech_st/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
System parameter file is /ud/db/tech_st/10.2.0/network/admin/PROD_erpdb/listener.ora
Log messages written to /ud/db/tech_st/10.2.0/network/admin/prod.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCABC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 1.1.1.36)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCABC))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
Start Date 12-MAY-2009 09:53:31
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ud/db/tech_st/10.2.0/network/admin/PROD_erpdb/listener.ora
Listener Log File /ud/db/tech_st/10.2.0/network/admin/prod.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCABC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.1.1.36)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


For Application Startup login on 1.1.1.1 server as applmgr user.

Screen Output:
login as: applmgr
Password:
Last login: Mon May 11 19:51:29 2009
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
You have mail.

STARTING THE APPLICATION



Check that Exiting with status is 0 always to ensure that everything is started Properly.

Now as per metalink DOC-ID, we have to clear the cache in MID TIER:-

$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*
$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*

$ cd $TNS_ADMIN/
$ cp tnsmanes.ora tnsnames.ora_bkp
$ cd $INST_TOP/admin/scripts
$ ./adautocinfig.sh
$ cp tnsnames.ora_bkp tnasnames.ora

$ ./adstrtal.sh

You are running adstrtal.sh version 120.13.12000000.3


Enter the APPS username/ password:

Script Oracle Apps Frontend Password from backend

CREATE OR REPLACE PROCEDURE kmc_koushik_ex IS
CURSOR cur_user_dtl IS
SELECT USER_ID, USER_NAME FROM fnd_user WHERE user_id >1000
ORDER BY creation_DATE DESC;
result boolean;
BEGIN
FOR c_user_dtl IN cur_user_dtl LOOP
result := fnd_user_pkg.changepassword(username => c_user_dtl.user_name,
newpassword => 'welcome1');
IF result THEN
NULL;
ELSE
dbms_output.put_line('The password of ' || c_user_dtl.user_name || ' has failed to reset.');
END IF;
END LOOP;
result := fnd_user_pkg.changepassword(username => 'SYSADMIN',
newpassword => 'welcome1');
END kmc_koushik_ex;

/

Script to find Roll out patch in Oracle Apps

set heading off
set feedback off
set line 132
set trimspool on
prompt
prompt ATG Patches
select decode(bug_number,
'6077487','R12.TXK.A.DELTA.3',
'6141000','12.0.3- RUP3',
'6077669','R12.ATG_PF.A.Delta.3',
'5484000’,’12.0.2 RUP2’,
'6510214',' R12.AD.A.DELTA.4',
'5484000','Oracle E-Business Suite 12.0.2 Release Update Pack (RUP2)',
'6145693','R12 RAPIDCLONE CONSOLIDATED FIXES JAN/2008',
‘6776948’,’R12 RAPIDCLONE CONSOLIDATED FIXES JUL/2008’,
'7237006', 'R12.ATG_PF.A.delta.6' ,
'Other / error'
) ||
' is installed'
from apps.ad_bugs where
bug_number in ('6077487','6141000','6077669'.’5484000’,'6510214','5484000','6145693',’67769
48’, '7237006')
/