1. Note:362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
2. Note:362203.1 Interoperability Notes - Oracle Applications 11i with Oracle
Database 10g Release 2
3. Note 165195.1: Using AutoConfig to Manage System Configurations with Oracle E-
Business Suite 11i.
4. Note 230672.1: Cloning Oracle Applications Release 11i with Rapid Clone
5. Note 240575.1: RAC on Linux Best Practices
6. Note 265633.1: Automatic Storage Management Technical Best Practices
7. http://download.oracle.com/docs/cd/B16981_04/current/html/docset.html
Applications System Administrator's Guide, Release 11i
Saturday, 31 May 2008
Friday, 30 May 2008
HOW TO RESET SYSADMIN PASSWORD
How to Reset only the SYSADMIN Password
PROBLEM DESCRIPTION
-------------------
You have forgotten the SYSADMIN applications password and cannot login. You know the apps and applsys passwords but does not want to follow the steps to
reset all passwords since resetting applsys would require re-registering all applications user passwords.
How can you reset only the SYSADMIN password?
SOLUTION DESCRIPTION
--------------------
The applsys password provides the basis for all user passwords so resetting applsys will require re-registering all user passwords.
If there are any other users with System Administrator privileges, then they can reset the SYSADMIN user's password from within applications.
Otherwise SYSADMIN can be reset without affecting other users as follows:
1. Log in to SQL*Plus as applsys
2. Backup FND_USER and FND_ORACLE_USERID tables using
create table FND_USER_BAK as select * from FND_USER;
create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID;
3. update FND_USER
set ENCRYPTED_FOUNDATION_PASSWORD ='2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411',
ENCRYPTED_USER_PASSWORD='D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13'
where user_name='SYSADMIN';
sql>commit;
The SYSADMIN password is now set to WELCOME.
PROBLEM DESCRIPTION
-------------------
You have forgotten the SYSADMIN applications password and cannot login. You know the apps and applsys passwords but does not want to follow the steps to
reset all passwords since resetting applsys would require re-registering all applications user passwords.
How can you reset only the SYSADMIN password?
SOLUTION DESCRIPTION
--------------------
The applsys password provides the basis for all user passwords so resetting applsys will require re-registering all user passwords.
If there are any other users with System Administrator privileges, then they can reset the SYSADMIN user's password from within applications.
Otherwise SYSADMIN can be reset without affecting other users as follows:
1. Log in to SQL*Plus as applsys
2. Backup FND_USER and FND_ORACLE_USERID tables using
create table FND_USER_BAK as select * from FND_USER;
create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID;
3. update FND_USER
set ENCRYPTED_FOUNDATION_PASSWORD ='2DF3E509EB6A33F9607959C0976E25D997166FAB694ACDDAE466414791A44411',
ENCRYPTED_USER_PASSWORD='D2FCA9810D86BCA9BE944D3E2E7A4A9E6CDF89AAD633179B701774083F907C13'
where user_name='SYSADMIN';
sql>commit;
The SYSADMIN password is now set to WELCOME.
Thursday, 29 May 2008
10g GRID CONTROL ENTERPRISE MANAGER INSTALLATION.
Set the env for oracle user.
1. Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/oms; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:/opt/IBMJava2-131/bin:$ORACLE_HOME/bin:$PATH; export PATH
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin; export PATH
PATH=$PATH:$ORACLE_HOME/Apache/Apache/bin; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
2. DISPLAY=:0.0; export DISPLAY
3. ./runInstaller
4. The installation will automatically install an agent in the agent home.
5. Agent installation on another node to connect with this 10g enterprise manager.
6. start and stop services.
To stop all the Grid Control components on a host, follow these steps:
Stop the OMS.
$PROMPT> $ORACLE_HOME/bin/emctl stop oms
Stop the Application Server Control Console, which is used to manage the Oracle Application Server instance used to deploy the Management Service.
$PROMPT> $ORACLE_HOME/bin/emctl stop iasconsole
Stop all the application server components, such as Oracle HTTP Server, OracleAS Web Cache.
$PROMPT> $ORACLE_HOME/opmn/bin/opmnctl stopall
Wait for four to five minutes to ensure that all the OPMN processes are stopped and TCP ports are released.
Change directory to the home directory for the Oracle Management Agent and stop the Management Agent.
$PROMPT> AGENT_HOME/bin/emctl stop agent
----------------------------------------------------------------------------------
To start all the Grid Control components on a host, follow these steps:
$PROMPT> $ORACLE_HOME/bin/emctl start oms
$PROMPT> $ORACLE_HOME/bin/emctl start iasconsole
$PROMPT> $ORACLE_HOME/opmn/bin/opmnctl startall
$PROMPT> AGENT_HOME/bin/emctl start agent
-------------------------------------------------------------------------------------
1. Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/oms; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:/opt/IBMJava2-131/bin:$ORACLE_HOME/bin:$PATH; export PATH
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin; export PATH
PATH=$PATH:$ORACLE_HOME/Apache/Apache/bin; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
2. DISPLAY=
3. ./runInstaller
4. The installation will automatically install an agent in the agent home.
5. Agent installation on another node to connect with this 10g enterprise manager.
6. start and stop services.
To stop all the Grid Control components on a host, follow these steps:
Stop the OMS.
$PROMPT> $ORACLE_HOME/bin/emctl stop oms
Stop the Application Server Control Console, which is used to manage the Oracle Application Server instance used to deploy the Management Service.
$PROMPT> $ORACLE_HOME/bin/emctl stop iasconsole
Stop all the application server components, such as Oracle HTTP Server, OracleAS Web Cache.
$PROMPT> $ORACLE_HOME/opmn/bin/opmnctl stopall
Wait for four to five minutes to ensure that all the OPMN processes are stopped and TCP ports are released.
Change directory to the home directory for the Oracle Management Agent and stop the Management Agent.
$PROMPT> AGENT_HOME/bin/emctl stop agent
----------------------------------------------------------------------------------
To start all the Grid Control components on a host, follow these steps:
$PROMPT> $ORACLE_HOME/bin/emctl start oms
$PROMPT> $ORACLE_HOME/bin/emctl start iasconsole
$PROMPT> $ORACLE_HOME/opmn/bin/opmnctl startall
$PROMPT> AGENT_HOME/bin/emctl start agent
-------------------------------------------------------------------------------------
APPLICATION FORM METRIC SERVER CLIENT ADDITION IN 11i
NODE A DATABASE + CONCUR
NODE B DATABASE + CONCUR
NODE C PRIMARY WEB NODE
NODE D WEB NODE
NODE E ADD THIS NODE AS A NEW APPLICATION NODE
--------------------------------------------------------------
Put the entry of third node in /etc/hosts files of all the remaining current nodes.
2. /etc/services should have read permission.
3. Confirm the following to be present on third node OS :-
ld, ar, cc, make, Perl 5.0, Zip 2.3
4. Check the OS for asynchronous I/O mode.
5. Copy and extract “/oraprod” (APPL_TOP, COMMON_TOP, ORA_TOP) contents from second
application NODE D, to third NODE E mountpount. This node is selected for
cloning, since this node is “form metric server client”.
6. Create the clone context file on third node by using following commands :-
Set the environment
# cd /oraprod/oracle/finprdappl
# . ./APPSORA.env
Run adclonectx.pl
# perl $AD_TOP/bin/adclonectx.pl
contextfile=/oraprod/oracle/finprdappl/admin/SID_HOST.xml
It will generate context file in working directory which will be used for running Autoconfig.
7. Set s_methost to Form Metrics server NODE C.
8. Set s_leastloadedhost to %LeastLoadedHost%
9. Set the third node as Form server node only, i.e. Web server processes will not be running on third node. First application node NODE C is the web entry point for users.
10. Run Autoconfig
# sh $AD_TOP/bin/adconfig.sh contextfile=/oraprod/oracle/finprdappl/admin/
SID_HOST.xml
Start all applications on third NODE E.
-------------------------------------------------------------------------------
NODE B DATABASE + CONCUR
NODE C PRIMARY WEB NODE
NODE D WEB NODE
NODE E ADD THIS NODE AS A NEW APPLICATION NODE
--------------------------------------------------------------
Put the entry of third node in /etc/hosts files of all the remaining current nodes.
2. /etc/services should have read permission.
3. Confirm the following to be present on third node OS :-
ld, ar, cc, make, Perl 5.0, Zip 2.3
4. Check the OS for asynchronous I/O mode.
5. Copy and extract “/oraprod” (APPL_TOP, COMMON_TOP, ORA_TOP) contents from second
application NODE D, to third NODE E mountpount. This node is selected for
cloning, since this node is “form metric server client”.
6. Create the clone context file on third node by using following commands :-
Set the environment
# cd /oraprod/oracle/finprdappl
# . ./APPSORA.env
Run adclonectx.pl
# perl $AD_TOP/bin/adclonectx.pl
contextfile=/oraprod/oracle/finprdappl/admin/SID_HOST.xml
It will generate context file in working directory which will be used for running Autoconfig.
7. Set s_methost to Form Metrics server NODE C.
8. Set s_leastloadedhost to %LeastLoadedHost%
9. Set the third node as Form server node only, i.e. Web server processes will not be running on third node. First application node NODE C is the web entry point for users.
10. Run Autoconfig
# sh $AD_TOP/bin/adconfig.sh contextfile=/oraprod/oracle/finprdappl/admin/
SID_HOST.xml
Start all applications on third NODE E.
-------------------------------------------------------------------------------
SOME USEFUL APPS DBA COMMANDS
PLEASE RUN THESE COMMANDS ON TEST FIRST THEN USE ON PRODUCTION.
Performance Monitoring
----------------------
select sid,serial#,program,status,module,last_call_et from v$session
where last_call_et>18000
select sid,sql_hash_value from v$session where sid in (select sid from v$session_wait where event like 'global cache cr request') order by 2
select sum(blocks*8192)/1024/1024/1024 from v$tempseg_usage
select name , lockid from dbms_lock_allocated
select table_name from dict where table_name like 'HZ%'
select * from gv$resource_limit
select name, kind, partition_name, sum(xnc) from v$cache_transfer
group by name, kind, partition_name order by 4
select JOB,WHAT,NEXT_DATE,BROKEN,INTERVAL from dba_jobs
Temp usage : -- select sum(blocks*8192)/1024/1024/1024 from gv$tempseg_usage
Kill all inactive old sessions
------------------------------
Select 'alter system kill session '''||sid||','||serial#||''';'
from V$session
where
status='INACTIVE'
and type <> 'BACKGROUND'
and SID>100
and last_call_et>18000
killing snipped sessions
------------------------------
--get spid
select p.spid from v$process p,v$session s where s.paddr=p.addr and
s.status='SNIPED'
kill -9 p.spid
select 'kill -9 ' || p.spid from v$process p,v$session s where s.paddr=p.addr and s.status='SNIPED'
and s.username='BOLBOL'
select b1.inst_id, b2.value "GCS CR BLOCKS RECEIVED",
b1.value "GCS CR BLOCK RECEIVE TIME",
((b1.value / b2.value) * 10) "AVG CR BLOCK RECEIVE TIME (ms)"
from gv$sysstat b1, gv$sysstat b2
where b1.name = 'global cache cr block receive time' and
b2.name = 'global cache cr blocks received' and b1.inst_id = b2.inst_id
Kill inactive sessions which are more than 5 hrs old
----------------------------------------------------
select sid,serial#,program,status,module,last_call_et from v$session
where sid>50 and last_call_et>18000 and status='INACTIVE' and type <> 'BACKGROUND'
Long operations
-----------------
select inst_id,sid,serial#, (ELAPSED_SECONDS + TIME_REMAINING) TOTAL_TIME, TIME_REMAINING,
100 - ((TIME_REMAINING/(ELAPSED_SECONDS + TIME_REMAINING)) * 100) PERCENTAGE_COMPLETE
FROM gV$SESSION_LONGOPS WHERE TIME_REMAINING>0
Kill concurrent request processes
---------------------------------
Get oracle_session_id from FND_CONCURRENT_REQUESTS
get sid,serial# from v$session with ausid=oracle_session_id
alter system kill sid,serial#
Set SQL command prompt
-------------------------------------------------
SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
Kill processes
-----------------------------
kill -9 `ps -ef | grep 'LOCAL=NO' | awk '{ print $2 }'`
kill -9 `ps -ef | grep f60runm | awk '{ print $2 }'`
Waits
-----------------
select event,count(*) from v$session_wait group by event'
To see the applied patches
--------------------------
select count(*) from ad_bugs where BUG_NUMBER='&bug_no';
select count(*) from ad_applied_patches where PATCH_NAME='&patch_name';
To know the patch lebel of a product in APPS
==================================================
select a.application_name,decode(b.status,'I','Installed','S','Shared','N/A') STATUS,PATCH_LEVEL
from APPS.fnd_application_vl a,APPS.fnd_product_installations b
where a.application_id = b.application_id order by 2,1;
To see the free space in tablespaces
------------------------------------
select TABLESPACE_NAME,sum(BYTES)/1024/1024 from dba_free_space
group by TABLESPACE_NAME
To remove/move the file by date
----------------------------
ls -lrt *.gz |grep "Apr 20"|grep "Apr 21"| awk '{print "mv " $9 " copied" }'> mv.sh
ls -lrt *.gz |grep -v xxxxx | awk '{print "mv " $9 " /arch_prd1" }'> mv.sh
ls -l |grep "Jul 20" |awk '{print "rm "$9}' >rmglo.sh
ls -ltr|grep "Feb 7"|grep trc|awk '{print $9}'|xargs -I {} -t rm {}
ls -ltr|grep trc|awk '{print $9}'|xargs -I {} -t rm {}
To kill all FNDLIBR processes
-----------------------------
ps -ef|grep FNDLIBR|grep -v grep | awk '{print "kill -9 " $2}' > killfndlibr.sh
To get the list of files on size basis
--------------------------------------
ls -l |sort +4rn |more
TO copy the files remotely
----------------------------
nohup rcp -p -r oraprosp@kmc2prospsuncrege:/export/ora9.2.0.4_64/* . &
To find out the error in patch log file
------------------------------------------
egrep -i 'ORA-|FRM-|APP-|REP-|Err|Fail|Warn'
For Split
----------
$split -60 amt79_copy.sh amt79_x$ls -l amt79_xa? | awk '{print "nohup ./"$NF" > "$NF".out 2> "$NF".err &"}' > master_amt79_copy.sh$chmod a+x amt79_x*
$ls -l xa* | awk '{print "nohup ./"$NF" > "$NF".out 2> "$NF".err &"}' > master_frsbx_copy.sh
nohup ./xaa > xaa.out 2> xaa.err &
nohup ./xab > xab.out 2> xab.err &
To startup Workflow
--------------------
nohup /oracle/apps/R11isbx/sbxappl/fnd/11.5.0/bin apps/sysuat@uat 0 Y /oracle/apps/R11isbx/sbxappl/fnd/11.5.0/resource/wfmail.cfg &
To Check Work flow process
----------------------------
ps -ef |grep -i wfmail
To Check ULIMIT OutPut
-----------------------
/export/home/oracle: ulimit -a
To cancel running concurrent request
----------------------------------
sqltweof>update fnd_concurrent_requests set PHASE_CODE='C',STATUS_CODE='E' where request_id='3477766';
To find out port number which is in used
----------------------------------------
netstat -a
To test mailx
--------------
echo "Test mail" |mailx -s "test" mailid@mailserver.com
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" rupam.bora@airtel.in
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" rupam.bora@airtel.in
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" crm.dba@airtel.in
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" crm.dba@airtel.in
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" bpsingh@in.ibm.com
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" bpsingh@in.ibm.com
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" manmoha1@in.ibm.com
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" santkum2@in.ibm.com
If patch has been applied on DBTIER and u r getting prereq error on FOrms tier..
Then follow this command while applying patch
---------------------------------------------------
$adpatch options=novalidate,noprereq
To find Java Virtual Machine version :
--------------------------------------
$ java -version
To find OS Version
------------------
$ uname -a
To find Available disk space
-----------------------------
$ df -b
To find Number of CPUs
-----------------------------
$ uname -X
$lsdev -C |grep Process|wc -l
To find Physical RAM on server
-------------
$ prtconf |pg
----------------------------------------------------------
To find the O/S level packages which are installed
=========================================================
pkginfo | grep -i
=================================================================
=================================================================
To know the operating system ...32 bit or 64 bit
------------------------------------------------
/export/home/frcrp: isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
/export/home/frcrp: uname -a
SunOS gecmsn05 5.8 Generic_108528-15 sun4u sparc SUNW,Ultra-4
/export/home/frcrp: isainfo -vk
64-bit sparcv9 kernel modules
to extract CPIO file
-------------------------
cpio -idmcv <
In HP to know RAM details
=============================
vishnuvardhan_v: grep -i Physical /var/adm/syslog/syslog.log
vishnuvardhan_v: http://unixguide.net/cgi-bin/unixguide.cgi
# /usr/sbin/dmesg | grep "Physical:" (to know the RAM size on HP)
To know swap size in HP
=======================
# /usr/sbin/swapinfo -a
To know the O/S bit version
=============================
/bin/getconf KERNEL_BITS
prtdiag---location
---------------------------------
/usr/share/man/sman1m/prtdiag.1m
/usr/platform/SUNW,Sun-Fire-V240/sbin/prtdiag
/usr/platform/SUNW,Sun-Fire-V250/sbin/prtdiag
/usr/platform/sun4u/sbin/prtdiag
to know more about the printers
================================
/etc/lp/interfaces
/etc/lp/printers
to know the printer status
----------------------------
# lpstat -p
# lpstat -a
$ lp adstrtal.sh ....to test the pint from unix level
When multiple printers:
lp -d 2105nw_phaser text.out (note the space after the -d)
lpr -P2105nw_phaser text.out (note that there is no space after the -P)
To remove job 469 from the color printer, you would type:
cancel 2105nw_phaser-2241
lprm -P2105nw_phaser 2241
# lpstat -v ---to know the printer names and printer queue names
to know the particular user responsibilities
=============================================
select c.user_id,a.RESPONSIBILITY_ID, b.RESPONSIBILITY_NAME from FND_USER_RESPONSIBILITY a,FND_RESPONSIBILITY_TL b, fnd_user c where c.user_name='HACKLN' and c.user_id=a.user_id and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID ;
to check last issued commonds(with reboot comnds also)
=======================================================
last|more
To check the server reboot time from the last reboot
====================================================
uptime
To compile invalid objects in the database.
==============================================
exec utl_recomp.recomp_parallel(4)
TO Unset two task
=====================
unset two_task
CronTab values
===============
minute (0-59),
hour (0-23),
day of the month (1-31),
month of the year (1-12),
day of the week (0-6 with 0=Sunday).
To know Jserv status
======================
http://hostname.domainname:portnumber/servlets/IsItWorking
http://gecmsn05.cf.capital.ge.com:8010/servlets/IsItWorking
To check mailx command
===========================
applprod (PROD)$ mailx -v tejinder.singla@ge.com
Subject: Hello
.
EOT
applprod (PROD)$ tejinder.singla@ge.com... Connecting to smtpmail.corporate.ge.com via relay...
tejinder.singla@ge.com... Deferred: Connection refused by smtpmail.corporate.ge.com
applprod (PROD)$
-------------------------------------------------------
sendmail -V
To move Datafile to another location
========================================
Because of space problems moved '/vg03s1/edwdata/edwdata08.dbf to '/vg03s0/edwdata/edwdata08.dbf
alter tablespace EDWDATA rename datafile '/vg03s1/edwdata/edwdata08.dbf' to '/vg03s0/edwdata/edwdata08.dbf';
Add A Datafile To An Existing Tablespace
========================================
ALTER TABLESPACE ADD DATAFILE '' SIZE K|M;
e.g. ALTER TABLESPACE tools ADD DATAFILE 'c:\oracle\oradata\orabase\tools02.tom' SIZE 20M;
ALTER DATABASE CREATE DATAFILE '' SIZE K|M AS '';
e.g. ALTER DATABASE CREATE DATAFILE 'c:\oracle\oradata\orabase\uwdata03.dbf' AS 'UWDATA';
To add datafile in RAW DEVICES
==================================
to add a datafile in a tablesapce in O&G(for raw devices)
ls -ltr ---to check the datafiles which are existing ..
ls -altr free* ----to check the raw devices which we have in that instance
mv (follow the naming structure with existing datafiles)
go to sql and add a datafile to a tablespace using alter tablespace command with the size of rawdevice file size
To know the package body from a procedure
=============================================
SELECT TEXT FROM ALL_SOURCE WHERE NAME LIKE 'GCFEXT_AP_AUOR2AB1_PKG'
To find the table size
========================
first method----to calculate table size
select sum(bytes)/1024/1024
from dba_segments
where SEGMENT_NAME='TABLE_NAME';
------------------------------------
second method
analyze table my_table compute statistics;
or
analyze table my_table estimate statitics;
And then, execute the query
select blocks from user_tables where table_name='SIZE';
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
analyze table tabe_name compute statistics;
and then give
select num_rows,blocks ,empty_blocks as
empty,avg_space,chain_cnt,avg_row_len from dba_tables
where table_name='table_name';
now
blocks * db_block_size = table size
or
select segment_name Table_Name, sum(bytes) / 1024 / 1024 MB from user_segments
Where segment_type = 'TABLE' and Segment_Name like '&Table_search_string'
Group by segment_name;
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
To know particular user responsibility
=============================================
select c.user_id,a.RESPONSIBILITY_ID, b.RESPONSIBILITY_NAME from FND_USER_RESPONSIBILITY a,FND_RESPONSIBILITY_TL b, fnd_user c where c.user_name='HACKLN' and c.user_id=a.user_id and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID ;
To find the any object version like *.pll,fmb and etc
========================================================
- go to the corresponding directory
- execute one of the following commands to get the version of the file
on all platforms (beginning with Oracle Applications v. 11.x) :
adident Header
on Unix :
strings -a | grep Header
on Windows (DOS box) :
find "Header"
To find a file under subdirectorys
=================================
$ ls -R|grep " " (here finding the space in the file/dir name)
1. To determine the physical RAM size, enter one of the following commands:
==========================================================================
Platform Command
AIX #/usr/sbin/lsattr -E -l sys0 -a realmem
HP-UX # grep "Physical:" /var/adm/syslog/syslog.log
Linux # grep MemTotal /proc/meminfo
Solaris # /usr/sbin/prtconf | grep "Memory size"
Tru64 UNIX # /bin/vmstat -P | grep "Total Physical Memory"
2. To determine the size of the configured swap space, enter one of the following commands:
===========================================================================================
Platform Command
AIX # /usr/sbin/lsps -a
HP-UX # /usr/sbin/swapinfo -a
Linux # grep SwapTotal /proc/meminfo
Solaris # /usr/sbin/swap -s
Tru64 UNIX # /sbin/swapon -s
To determine whether the Oracle Inventory group exists, enter the following command:
====================================================================================
AIX, Linux x86, or Linux Itanium:
# more /etc/oraInst.loc
Other operating systems:
# more /var/opt/oracle/oraInst.loc
Remove archives by number , archive format: arch_prd2_2_54375.arc.gz
==========================================================
echo "Enter instance no [1 or 2 ? ] "
read instno
echo "Enter archive no : "
read archno
echo "Deleting archives of instance " $instno " , below seq no : " $archno
for name in `ls *.gz`
do
ino=`echo $name|cut -c9-9`
if [ $ino -eq $instno ]
then
no=`echo $name|cut -c13-17`
if [ $no -lt $archno ]
then
echo " Removing file : " $name
#rm $name
fi
fi
done
#################################################################################
ps -aefo pid,pcpu,vsz,args|awk '{if ($2>1) print $1,$2,$3,$4}'
Performance Monitoring
----------------------
select sid,serial#,program,status,module,last_call_et from v$session
where last_call_et>18000
select sid,sql_hash_value from v$session where sid in (select sid from v$session_wait where event like 'global cache cr request') order by 2
select sum(blocks*8192)/1024/1024/1024 from v$tempseg_usage
select name , lockid from dbms_lock_allocated
select table_name from dict where table_name like 'HZ%'
select * from gv$resource_limit
select name, kind, partition_name, sum(xnc) from v$cache_transfer
group by name, kind, partition_name order by 4
select JOB,WHAT,NEXT_DATE,BROKEN,INTERVAL from dba_jobs
Temp usage : -- select sum(blocks*8192)/1024/1024/1024 from gv$tempseg_usage
Kill all inactive old sessions
------------------------------
Select 'alter system kill session '''||sid||','||serial#||''';'
from V$session
where
status='INACTIVE'
and type <> 'BACKGROUND'
and SID>100
and last_call_et>18000
killing snipped sessions
------------------------------
--get spid
select p.spid from v$process p,v$session s where s.paddr=p.addr and
s.status='SNIPED'
kill -9 p.spid
select 'kill -9 ' || p.spid from v$process p,v$session s where s.paddr=p.addr and s.status='SNIPED'
and s.username='BOLBOL'
select b1.inst_id, b2.value "GCS CR BLOCKS RECEIVED",
b1.value "GCS CR BLOCK RECEIVE TIME",
((b1.value / b2.value) * 10) "AVG CR BLOCK RECEIVE TIME (ms)"
from gv$sysstat b1, gv$sysstat b2
where b1.name = 'global cache cr block receive time' and
b2.name = 'global cache cr blocks received' and b1.inst_id = b2.inst_id
Kill inactive sessions which are more than 5 hrs old
----------------------------------------------------
select sid,serial#,program,status,module,last_call_et from v$session
where sid>50 and last_call_et>18000 and status='INACTIVE' and type <> 'BACKGROUND'
Long operations
-----------------
select inst_id,sid,serial#, (ELAPSED_SECONDS + TIME_REMAINING) TOTAL_TIME, TIME_REMAINING,
100 - ((TIME_REMAINING/(ELAPSED_SECONDS + TIME_REMAINING)) * 100) PERCENTAGE_COMPLETE
FROM gV$SESSION_LONGOPS WHERE TIME_REMAINING>0
Kill concurrent request processes
---------------------------------
Get oracle_session_id from FND_CONCURRENT_REQUESTS
get sid,serial# from v$session with ausid=oracle_session_id
alter system kill sid,serial#
Set SQL command prompt
-------------------------------------------------
SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
Kill processes
-----------------------------
kill -9 `ps -ef | grep 'LOCAL=NO' | awk '{ print $2 }'`
kill -9 `ps -ef | grep f60runm | awk '{ print $2 }'`
Waits
-----------------
select event,count(*) from v$session_wait group by event'
To see the applied patches
--------------------------
select count(*) from ad_bugs where BUG_NUMBER='&bug_no';
select count(*) from ad_applied_patches where PATCH_NAME='&patch_name';
To know the patch lebel of a product in APPS
==================================================
select a.application_name,decode(b.status,'I','Installed','S','Shared','N/A') STATUS,PATCH_LEVEL
from APPS.fnd_application_vl a,APPS.fnd_product_installations b
where a.application_id = b.application_id order by 2,1;
To see the free space in tablespaces
------------------------------------
select TABLESPACE_NAME,sum(BYTES)/1024/1024 from dba_free_space
group by TABLESPACE_NAME
To remove/move the file by date
----------------------------
ls -lrt *.gz |grep "Apr 20"|grep "Apr 21"| awk '{print "mv " $9 " copied" }'> mv.sh
ls -lrt *.gz |grep -v xxxxx | awk '{print "mv " $9 " /arch_prd1" }'> mv.sh
ls -l |grep "Jul 20" |awk '{print "rm "$9}' >rmglo.sh
ls -ltr|grep "Feb 7"|grep trc|awk '{print $9}'|xargs -I {} -t rm {}
ls -ltr|grep trc|awk '{print $9}'|xargs -I {} -t rm {}
To kill all FNDLIBR processes
-----------------------------
ps -ef|grep FNDLIBR|grep -v grep | awk '{print "kill -9 " $2}' > killfndlibr.sh
To get the list of files on size basis
--------------------------------------
ls -l |sort +4rn |more
TO copy the files remotely
----------------------------
nohup rcp -p -r oraprosp@kmc2prospsuncrege:/export/ora9.2.0.4_64/* . &
To find out the error in patch log file
------------------------------------------
egrep -i 'ORA-|FRM-|APP-|REP-|Err|Fail|Warn'
For Split
----------
$split -60 amt79_copy.sh amt79_x$ls -l amt79_xa? | awk '{print "nohup ./"$NF" > "$NF".out 2> "$NF".err &"}' > master_amt79_copy.sh$chmod a+x amt79_x*
$ls -l xa* | awk '{print "nohup ./"$NF" > "$NF".out 2> "$NF".err &"}' > master_frsbx_copy.sh
nohup ./xaa > xaa.out 2> xaa.err &
nohup ./xab > xab.out 2> xab.err &
To startup Workflow
--------------------
nohup /oracle/apps/R11isbx/sbxappl/fnd/11.5.0/bin apps/sysuat@uat 0 Y /oracle/apps/R11isbx/sbxappl/fnd/11.5.0/resource/wfmail.cfg &
To Check Work flow process
----------------------------
ps -ef |grep -i wfmail
To Check ULIMIT OutPut
-----------------------
/export/home/oracle: ulimit -a
To cancel running concurrent request
----------------------------------
sqltweof>update fnd_concurrent_requests set PHASE_CODE='C',STATUS_CODE='E' where request_id='3477766';
To find out port number which is in used
----------------------------------------
netstat -a
To test mailx
--------------
echo "Test mail" |mailx -s "test" mailid@mailserver.com
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" rupam.bora@airtel.in
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" rupam.bora@airtel.in
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" crm.dba@airtel.in
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" crm.dba@airtel.in
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" bpsingh@in.ibm.com
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" bpsingh@in.ibm.com
echo "Test Mail from OLM using mailx db node 1 " |mailx -s "Test Mail from OLM using mailx db node 1" manmoha1@in.ibm.com
echo "Test Mail from OLM using mailx db node 2 " |mailx -s "Test Mail from OLM using mailx db node 2" santkum2@in.ibm.com
If patch has been applied on DBTIER and u r getting prereq error on FOrms tier..
Then follow this command while applying patch
---------------------------------------------------
$adpatch options=novalidate,noprereq
To find Java Virtual Machine version :
--------------------------------------
$ java -version
To find OS Version
------------------
$ uname -a
To find Available disk space
-----------------------------
$ df -b
To find Number of CPUs
-----------------------------
$ uname -X
$lsdev -C |grep Process|wc -l
To find Physical RAM on server
-------------
$ prtconf |pg
----------------------------------------------------------
To find the O/S level packages which are installed
=========================================================
pkginfo | grep -i
=================================================================
=================================================================
To know the operating system ...32 bit or 64 bit
------------------------------------------------
/export/home/frcrp: isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
/export/home/frcrp: uname -a
SunOS gecmsn05 5.8 Generic_108528-15 sun4u sparc SUNW,Ultra-4
/export/home/frcrp: isainfo -vk
64-bit sparcv9 kernel modules
to extract CPIO file
-------------------------
cpio -idmcv <
In HP to know RAM details
=============================
vishnuvardhan_v: grep -i Physical /var/adm/syslog/syslog.log
vishnuvardhan_v: http://unixguide.net/cgi-bin/unixguide.cgi
# /usr/sbin/dmesg | grep "Physical:" (to know the RAM size on HP)
To know swap size in HP
=======================
# /usr/sbin/swapinfo -a
To know the O/S bit version
=============================
/bin/getconf KERNEL_BITS
prtdiag---location
---------------------------------
/usr/share/man/sman1m/prtdiag.1m
/usr/platform/SUNW,Sun-Fire-V240/sbin/prtdiag
/usr/platform/SUNW,Sun-Fire-V250/sbin/prtdiag
/usr/platform/sun4u/sbin/prtdiag
to know more about the printers
================================
/etc/lp/interfaces
/etc/lp/printers
to know the printer status
----------------------------
# lpstat -p
# lpstat -a
$ lp adstrtal.sh ....to test the pint from unix level
When multiple printers:
lp -d 2105nw_phaser text.out (note the space after the -d)
lpr -P2105nw_phaser text.out (note that there is no space after the -P)
To remove job 469 from the color printer, you would type:
cancel 2105nw_phaser-2241
lprm -P2105nw_phaser 2241
# lpstat -v ---to know the printer names and printer queue names
to know the particular user responsibilities
=============================================
select c.user_id,a.RESPONSIBILITY_ID, b.RESPONSIBILITY_NAME from FND_USER_RESPONSIBILITY a,FND_RESPONSIBILITY_TL b, fnd_user c where c.user_name='HACKLN' and c.user_id=a.user_id and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID ;
to check last issued commonds(with reboot comnds also)
=======================================================
last|more
To check the server reboot time from the last reboot
====================================================
uptime
To compile invalid objects in the database.
==============================================
exec utl_recomp.recomp_parallel(4)
TO Unset two task
=====================
unset two_task
CronTab values
===============
minute (0-59),
hour (0-23),
day of the month (1-31),
month of the year (1-12),
day of the week (0-6 with 0=Sunday).
To know Jserv status
======================
http://hostname.domainname:portnumber/servlets/IsItWorking
http://gecmsn05.cf.capital.ge.com:8010/servlets/IsItWorking
To check mailx command
===========================
applprod (PROD)$ mailx -v tejinder.singla@ge.com
Subject: Hello
.
EOT
applprod (PROD)$ tejinder.singla@ge.com... Connecting to smtpmail.corporate.ge.com via relay...
tejinder.singla@ge.com... Deferred: Connection refused by smtpmail.corporate.ge.com
applprod (PROD)$
-------------------------------------------------------
sendmail -V
To move Datafile to another location
========================================
Because of space problems moved '/vg03s1/edwdata/edwdata08.dbf to '/vg03s0/edwdata/edwdata08.dbf
alter tablespace EDWDATA rename datafile '/vg03s1/edwdata/edwdata08.dbf' to '/vg03s0/edwdata/edwdata08.dbf';
Add A Datafile To An Existing Tablespace
========================================
ALTER TABLESPACE
e.g. ALTER TABLESPACE tools ADD DATAFILE 'c:\oracle\oradata\orabase\tools02.tom' SIZE 20M;
ALTER DATABASE CREATE DATAFILE '
e.g. ALTER DATABASE CREATE DATAFILE 'c:\oracle\oradata\orabase\uwdata03.dbf' AS 'UWDATA';
To add datafile in RAW DEVICES
==================================
to add a datafile in a tablesapce in O&G(for raw devices)
ls -ltr ---to check the datafiles which are existing ..
ls -altr free* ----to check the raw devices which we have in that instance
mv
go to sql and add a datafile to a tablespace using alter tablespace command with the size of rawdevice file size
To know the package body from a procedure
=============================================
SELECT TEXT FROM ALL_SOURCE WHERE NAME LIKE 'GCFEXT_AP_AUOR2AB1_PKG'
To find the table size
========================
first method----to calculate table size
select sum(bytes)/1024/1024
from dba_segments
where SEGMENT_NAME='TABLE_NAME';
------------------------------------
second method
analyze table my_table compute statistics;
or
analyze table my_table estimate statitics;
And then, execute the query
select blocks from user_tables where table_name='SIZE';
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
analyze table tabe_name compute statistics;
and then give
select num_rows,blocks ,empty_blocks as
empty,avg_space,chain_cnt,avg_row_len from dba_tables
where table_name='table_name';
now
blocks * db_block_size = table size
or
select segment_name Table_Name, sum(bytes) / 1024 / 1024 MB from user_segments
Where segment_type = 'TABLE' and Segment_Name like '&Table_search_string'
Group by segment_name;
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
To know particular user responsibility
=============================================
select c.user_id,a.RESPONSIBILITY_ID, b.RESPONSIBILITY_NAME from FND_USER_RESPONSIBILITY a,FND_RESPONSIBILITY_TL b, fnd_user c where c.user_name='HACKLN' and c.user_id=a.user_id and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID ;
To find the any object version like *.pll,fmb and etc
========================================================
- go to the corresponding directory
- execute one of the following commands to get the version of the file
on all platforms (beginning with Oracle Applications v. 11.x) :
adident Header
on Unix :
strings -a
on Windows (DOS box) :
find "Header"
To find a file under subdirectorys
=================================
$ ls -R|grep " " (here finding the space in the file/dir name)
1. To determine the physical RAM size, enter one of the following commands:
==========================================================================
Platform Command
AIX #/usr/sbin/lsattr -E -l sys0 -a realmem
HP-UX # grep "Physical:" /var/adm/syslog/syslog.log
Linux # grep MemTotal /proc/meminfo
Solaris # /usr/sbin/prtconf | grep "Memory size"
Tru64 UNIX # /bin/vmstat -P | grep "Total Physical Memory"
2. To determine the size of the configured swap space, enter one of the following commands:
===========================================================================================
Platform Command
AIX # /usr/sbin/lsps -a
HP-UX # /usr/sbin/swapinfo -a
Linux # grep SwapTotal /proc/meminfo
Solaris # /usr/sbin/swap -s
Tru64 UNIX # /sbin/swapon -s
To determine whether the Oracle Inventory group exists, enter the following command:
====================================================================================
AIX, Linux x86, or Linux Itanium:
# more /etc/oraInst.loc
Other operating systems:
# more /var/opt/oracle/oraInst.loc
Remove archives by number , archive format: arch_prd2_2_54375.arc.gz
==========================================================
echo "Enter instance no [1 or 2 ? ] "
read instno
echo "Enter archive no : "
read archno
echo "Deleting archives of instance " $instno " , below seq no : " $archno
for name in `ls *.gz`
do
ino=`echo $name|cut -c9-9`
if [ $ino -eq $instno ]
then
no=`echo $name|cut -c13-17`
if [ $no -lt $archno ]
then
echo " Removing file : " $name
#rm $name
fi
fi
done
#################################################################################
ps -aefo pid,pcpu,vsz,args|awk '{if ($2>1) print $1,$2,$3,$4}'
MULTI NODE TO SINGLE NODE CLONING.
NODE A : (FORM/WEB TIER) PRIMARY NODE Source
NODE B : (CONCURRENT+DB+ADMIN TIER) Source
NODE C : (CONCURRENT+DB+ADMIN TIER) Source
NODE E : FORM/WEB/CONCURRENT+DB+ADMIN TIER Target
SOURCE SYSTEM
1.Login as ora user NODE B
Prepare the source system database tier for cloning $cd/appsutil/scripts/ $perl adpreclone.pl dbTier
2.Login as ora user NODE C
Prepare the source system database tier for cloning
$cd/appsutil/scripts/
$perl adpreclone.pl dbTier
3.Login as appl user NODE A
cd $COMMON_TOP/admin/scripts/context_name1
$perl adpreclone.pl appsTier merge
It will create clone directort in common_top/clone/contextname1
4.Login as appl user NODE B
$cd $COMMON_TOP/admin/scripts/context_name2
$perl adpreclone.pl appltop merge
It will create APPL_TOPs direcory in common_top/clone/appl/contextname2
5.Login as appl user NODE C
$cd $COMMON_TOP/admin/scripts/context_name3
$perl adpreclone.pl appltop merge
It will create APPL_TOPs direcory in common_top/clone/appl/contextname3
6.Copy following from Node A(Primary Forms Tier) to Node E(Target Node)
APPL_TOP
COMMON_TOP
806 ORACLE_HOME
iAS ORACLE_HOME
7.Copy the required files from NODE B & C(SOURCE) to NODE E(TARGET)
$COMMON_TOP/clone/appl/contextname2 (NODE B) to $COMMON_TOP/clone/appl(NODE E)
$COMMON_TOP/clone/appl/contextname3 (NODE C) to $COMMON_TOP/clone/appl(NODE E)
8.From NODE B(Source) and NODE C(Source) to NODE E(TARGET)
Copy the database tier file system
Copy the database (DBF) files from the source to the target system Copy the source database ORACLE_HOME(9.2.0) to the target system
TARGET SYSTEM
1.On Node E (Login as ora user and run the following :- )
Use the following method if database was backup-ed using COLD BACKUP methology
$cd/appsutil/clone/bin
$perl adcfgclone.pl dbTier
Use this method if database was backup-ed using HOT BACKUP methology
$cd/appsutil/clone/bin
$perl adcfgclone.pl dbTechStack
Create the target database control files manually
Start the target system database in open mode
Run the library update script against the database
$cd/appsutil/install/
$sqlplus "/ as sysdba" @adupdlib.sql
where is "sl" for HP-UX, "so" for any other UNIX/LINUX platform
Configure the target database (the database must be open)
$cd/appsutil/clone/bin
$perl adcfgclone.pl dbconfig
Database and DB Listener should be up and running
2.Login as appl user (NODE E)
$cd $COMMON_TOP/clone/bin
$perl adcfgclone.pl appsTier
3.Finishing Task
* Run the following tasks in adadmin for all products:
* generate JAR files
* generate message files
* relink executables
* copy files to destination
* Depending on which tier you chose as the primary node, certain files may be missing. Run
adadmin to verify files required at runtime. If any files are listed as missing files, you must manually copy them to the merged APPL_TOP.
* Remove the temporary directory/clone/appl(NODE E) to reduce disk space usage.
NODE B : (CONCURRENT+DB+ADMIN TIER) Source
NODE C : (CONCURRENT+DB+ADMIN TIER) Source
NODE E : FORM/WEB/CONCURRENT+DB+ADMIN TIER Target
SOURCE SYSTEM
1.Login as ora user NODE B
Prepare the source system database tier for cloning $cd
2.Login as ora user NODE C
Prepare the source system database tier for cloning
$cd
$perl adpreclone.pl dbTier
3.Login as appl user NODE A
cd $COMMON_TOP/admin/scripts/context_name1
$perl adpreclone.pl appsTier merge
It will create clone directort in common_top/clone/contextname1
4.Login as appl user NODE B
$cd $COMMON_TOP/admin/scripts/context_name2
$perl adpreclone.pl appltop merge
It will create APPL_TOPs direcory in common_top/clone/appl/contextname2
5.Login as appl user NODE C
$cd $COMMON_TOP/admin/scripts/context_name3
$perl adpreclone.pl appltop merge
It will create APPL_TOPs direcory in common_top/clone/appl/contextname3
6.Copy following from Node A(Primary Forms Tier) to Node E(Target Node)
APPL_TOP
COMMON_TOP
806 ORACLE_HOME
iAS ORACLE_HOME
7.Copy the required files from NODE B & C(SOURCE) to NODE E(TARGET)
$COMMON_TOP/clone/appl/contextname2 (NODE B) to $COMMON_TOP/clone/appl(NODE E)
$COMMON_TOP/clone/appl/contextname3 (NODE C) to $COMMON_TOP/clone/appl(NODE E)
8.From NODE B(Source) and NODE C(Source) to NODE E(TARGET)
Copy the database tier file system
Copy the database (DBF) files from the source to the target system Copy the source database ORACLE_HOME(9.2.0) to the target system
TARGET SYSTEM
1.On Node E (Login as ora user and run the following :- )
Use the following method if database was backup-ed using COLD BACKUP methology
$cd
$perl adcfgclone.pl dbTier
Use this method if database was backup-ed using HOT BACKUP methology
$cd
$perl adcfgclone.pl dbTechStack
Create the target database control files manually
Start the target system database in open mode
Run the library update script against the database
$cd
$sqlplus "/ as sysdba" @adupdlib.sql
where
Configure the target database (the database must be open)
$cd
$perl adcfgclone.pl dbconfig
Database and DB Listener should be up and running
2.Login as appl user (NODE E)
$cd $COMMON_TOP/clone/bin
$perl adcfgclone.pl appsTier
3.Finishing Task
* Run the following tasks in adadmin for all products:
* generate JAR files
* generate message files
* relink executables
* copy files to destination
* Depending on which tier you chose as the primary node, certain files may be missing. Run
adadmin to verify files required at runtime. If any files are listed as missing files, you must manually copy them to the merged APPL_TOP.
* Remove the temporary directory
UPGRADE DATABASE 9.2.0.5 TO 10.1.0.3 WITH 11.5.9
Oracle Applications Release 11i with Oracle Database 10g Release 1 (10.1.0)
Doc ID: Note:282038.1
--------------------------------------------------------------------------------
Minimum Req:-
a.Oracle Applications 11.5.9 CU2.
b.Developer 6i Patch set 12.
c.AutoConfig Latest version
--------------------------------------------------------------------------------
Steps:-
1.Patch 3129264 INTEROP PATCH FOR 10.1.0 on 11.5.9 version of Apps.
2.P4337683_11i_TRU64
Minipack 11i.AD.I.2
3. Fresh installation of 10.1.0.2 and apply 10.1.0.3 patch.
4. Create nls/data/9idata directory
Install 10g Listener
5. Apply latest Oracle Patching Tool (OPatch) 2617419
6. Shut down Applications server processes and database listener
7. Database Upgrade Assistant (DBUA). Execute the Database Upgrade Assistant - $ORACLE_HOME/bin/dbua
8. Invalid object compilation ( Min 3 to 4 hours)
9. Modify initialization parameters
10. Run adgrants.sql
sys as sysdba
@$APPL_TOP/admin/adgrants.sql APPLSYS
11. Connect to sqlplus with apps
@$AD_TOP/patch/115/sql/adctxprv CTXSYS
12. perl $AD_TOP/bin/admkappsutil.pl
cp appsutil.zip to New Oracle_home
unzip -o appsutil.zip
perl adbldxml.pl tier=db appsuser=apps appspass=apps
run autoconfig
13. Gather sys statistics
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1264892 bytes
Variable Size 415236868 bytes
Database Buffers 645922816 bytes
Redo Buffers 11317248 bytes
Database mounted.
Database opened.
SQL> @/appl/prodappl/admin/adstats.sql
Connected.
-----------------------------------------------------
adstats.sql started at 2006-12-28 14:18:20
---
Checking for the DB version and collecting statistics ...
PL/SQL procedure successfully completed.
---------------------------------------------------
adstats.sql ended at 2006-12-28 15:10:41
---
Commit complete.
14.Re-create grants and synonyms using adadmin
15. Startup the services.
Doc ID: Note:282038.1
--------------------------------------------------------------------------------
Minimum Req:-
a.Oracle Applications 11.5.9 CU2.
b.Developer 6i Patch set 12.
c.AutoConfig Latest version
--------------------------------------------------------------------------------
Steps:-
1.Patch 3129264 INTEROP PATCH FOR 10.1.0 on 11.5.9 version of Apps.
2.P4337683_11i_TRU64
Minipack 11i.AD.I.2
3. Fresh installation of 10.1.0.2 and apply 10.1.0.3 patch.
4. Create nls/data/9idata directory
Install 10g Listener
5. Apply latest Oracle Patching Tool (OPatch) 2617419
6. Shut down Applications server processes and database listener
7. Database Upgrade Assistant (DBUA). Execute the Database Upgrade Assistant - $ORACLE_HOME/bin/dbua
8. Invalid object compilation ( Min 3 to 4 hours)
9. Modify initialization parameters
10. Run adgrants.sql
sys as sysdba
@$APPL_TOP/admin/adgrants.sql APPLSYS
11. Connect to sqlplus with apps
@$AD_TOP/patch/115/sql/adctxprv CTXSYS
12. perl $AD_TOP/bin/admkappsutil.pl
cp appsutil.zip to New Oracle_home
unzip -o appsutil.zip
perl adbldxml.pl tier=db appsuser=apps appspass=apps
run autoconfig
13. Gather sys statistics
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1264892 bytes
Variable Size 415236868 bytes
Database Buffers 645922816 bytes
Redo Buffers 11317248 bytes
Database mounted.
Database opened.
SQL> @/appl/prodappl/admin/adstats.sql
Connected.
-----------------------------------------------------
adstats.sql started at 2006-12-28 14:18:20
---
Checking for the DB version and collecting statistics ...
PL/SQL procedure successfully completed.
---------------------------------------------------
adstats.sql ended at 2006-12-28 15:10:41
---
Commit complete.
14.Re-create grants and synonyms using adadmin
15. Startup the services.
Oracle Discoverer Upgrade from release 4i(4.1.48.06.00) to 10g(10.1.2)
1.Discoverer 10.1.2 must be installed on a standalone server, accessing an Oracle E-Business Suite Release 11i database, or in a separate Oracle Business Intelligence Server 10g Release 2 (10.1.2) ORACLE_HOME on an existing application tier server node.
2.Discoverer 10.1.2 must be installed in a separate ORACLE_HOME on an existing application tier server node or on a stand-alone server, accessing an Oracle E-Business Suite Release 11i database.
3.The following components must be used on the stand alone instance.
Oracle application server 10g Release 2 10.1.2
Oracle Business Intelligence 10.1.2
Section 1: Installation Tasks
This section outlines steps required to install Oracle Business Intelligence Server 10g Release 2, Discoverer 10.1.2, and the Discoverer 10.1.2 End User Layer.
1.1. Install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1)
You must install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1) on a standalone server or in a separate ORACLE_HOME on an existing application tier server node.
1.2. Install Oracle Application Server 10g Release 2 (10.1.2.0.2) type Business Intelligence and Forms
"You must install Oracle Application Server 10g Release 2 (10.1.2.0.2) installation type Business Intelligence and Forms in a seperate ORACLE_HOME from the previously installed OracleAS Infrastructure. During installation of Oracle Application Server 10g Release 2 (10.1.2.0.2) type Business Intelligence and Forms you will be prompted for Oracle Internet Directory details. Please provide your Oracle Application Server 10g (10.1.4.0.1) Infrastructure hostname and port number as configured in step 1.1.
The OracleAS Infrastructure might be on the same machine as the Business Intelligence and Forms type installation or on a different machine. This installation type includes Discoverer Server 10g, Discoverer Plus 10g, and Discoverer Viewer 10g. You must install Oracle Application Server 10g Release 2 on a standalone server accessing an Oracle E-Business Suite Release 11i database or in a separate ORACLE_HOME on an existing application tier server node."
1.3. Copy Database Connection file
Discoverer 10.1.2 supports Single Sign-On functionality with Oracle E-Business Suite Release 11i. To support Single Sign-On, Discoverer needs access to the Database Connection (dbc) file for the database you wish to connect to. A dbc file is a text file which stores all the information required to connect to a particular database.
In the Discoverer10g $ORACLE_HOME/opmn/conf/opmn.xml file check the variable for FND_SECURE. This variable specifies the directory where Discoverer is trying to locate dbc files. By default this is set to $ORACLE_HOME/discoverer/secure.
Create the directory $ORACLE_HOME/discoverer/secure if it does not exist. Then copy the dbc file from the $FND_TOP/secure directory of the 11i instance you are setting up Discoverer with to the Discoverer 10.1.2 $ORACLE_HOME/discoverer/secure directory you just created.
1.4. Update tnsnames.ora file
On your standalone Oracle Business Intelligence Server 10g Release 2 node, update file $ORACLE_HOME/network/admin/tnsnames.ora and include the tnsnames entry to connect to your Oracle E-Business Suite Release 11i database. Use the same entry as exists in the tnsnames.ora file on your Oracle E-Business Suite Release 11i application tier server node. The database name must match the two_task entry in the dbc file. Verify you can establish a connection to your Oracle E-Business Suite Release 11i database using sqlplus.
2. Apply the latest certified Discoverer Plus and Viewer Patches
AIX Paltform(only for 10.1.2.0.0): Apply patchset 10.1.2.1.0 delivered via patch 4908436 available on Metalink for download.
3. Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.
Upgrade your existing Discoverer 4i or Discoverer 9.0.4 End User Layer to Discoverer 10.1.2 by using the following command on the standalone application server where Oracle Business Intelligence Server 10g Release 2 was installed in Step 1.
$ORACLE_HOME/bin/eulapi -CONNECT/@ -AUTO_UPGRADE
If you are migrating your Discoverer 4i End User Layer, the upgrade process creates a new Discoverer 10.1.2 End User Layer based the existing Discoverer 4i End User Layer. The existing Discoverer 4i End User Layer remains unchanged. A new schema containing the Discoverer 10.1.2 End User Layer will be created under the same Database User. After migration, the Database User contains functional End-User Layers for both Discoverer 4i and 10g. After verifying that the upgrade was successful, you may drop the 4i End-User Layer.
Section 2 : Postinstallation Tasks
This section describes steps for configuring Oracle E-Business Suite Release 11i to use Discoverer 10.1.2, and for loading the Applications-specific content and workbooks into the Discoverer 10.1.2 End User Layer.
1. Apply necessary Oracle Applications interoperability patches using AutoPatch
A) Apply AD patch 5765314
This patch contains utilities for Discoverer End User Layer maintainance.
B) Apply ICX patch 3133021
This patch contains support to invoke Discoverer from E-Business Suite functions.
2. Set Applications Profile Options for Discoverer using AutoConfig
By default, AutoConfig configures profile options for Oracle E-Business Suite Release 11i environments for Discoverer 4i. Proceed with the following steps to allow AutoConfig to switch profile options for your remote, standalone Oracle Business Intelligence 10g Release 2 server:
Edit the AutoConfig context file.
If you are currently using E-Business Suite level 11.5.9 or above, or have applied FND.G patchset (or above), you will use Oracle Applications Manager to edit your context file. For all previous versions, you will use the AutoConfig Context Editor tool.
To edit the context file using Oracle Applications Manager, login to Oracle Applications Manager and navigate to Site Map > AutoConfig > Edit Parameters.
3. Set Applications Profile Options for Discoverer using AutoConfig
By default, AutoConfig configures profile options for Oracle E-Business Suite Release 11i environments for Discoverer 4i. Proceed with the following steps to allow AutoConfig to switch profile options for your remote, standalone Oracle Business Intelligence 10g Release 2 server:
Edit the AutoConfig context file.
If you are currently using E-Business Suite level 11.5.9 or above, or have applied FND.G patchset (or above), you will use Oracle Applications Manager to edit your context file. For all previous versions, you will use the AutoConfig Context Editor tool.
To edit the context file using Oracle Applications Manager, login to Oracle Applications Manager and navigate to Site Map > AutoConfig > Edit Parameters.
Configure standalone discoverer, Discoverer Machine name, Discoverer port, Discoverer protocol,
Disco version comma discovery eul prefix.
4. After that you have to run autoconfig
-Verify Applications profile options in Oracle Applications
Log into Release 11i with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.
Verify the following ICX profile options in Oracle Applications
ICX_DISCOVERER_LAUNCHER=http://:/discoverer/plus?Connect=[APPS_SECURE]
ICX_DISCOVERER_VIEWER_LAUNCHER=http://:/discoverer/viewer?Connect=[APPS_SECURE]
ICX_DISCOVERER_RELEASE=10
ICX_DISCOVERER_USE_VIEWR=Y N
ICX_DEFAULT_EUL=EUL
ICX_DISCOVERER_EUL_LANGUAGE=US
ICX_DISCOVERER_PARAMETERS=exitURL=http://:/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE
Note:
When you open the discoverer EUL using the Discoverer 10g Desktop/Admin it will ask you if you want to upgrade your EUL and you have to choose yes.
To start/stop the new discoverer do the following:
$Disco_ORACLE_HOME/opmn/bin/opmnctl stopall (to stop).
$Disco_ORACLE_HOME/opmn/bin/opmnctl startall (to start).
2.Discoverer 10.1.2 must be installed in a separate ORACLE_HOME on an existing application tier server node or on a stand-alone server, accessing an Oracle E-Business Suite Release 11i database.
3.The following components must be used on the stand alone instance.
Oracle application server 10g Release 2 10.1.2
Oracle Business Intelligence 10.1.2
Section 1: Installation Tasks
This section outlines steps required to install Oracle Business Intelligence Server 10g Release 2, Discoverer 10.1.2, and the Discoverer 10.1.2 End User Layer.
1.1. Install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1)
You must install OracleAS Identity Management Infrastructure 10g (10.1.4.0.1) on a standalone server or in a separate ORACLE_HOME on an existing application tier server node.
1.2. Install Oracle Application Server 10g Release 2 (10.1.2.0.2) type Business Intelligence and Forms
"You must install Oracle Application Server 10g Release 2 (10.1.2.0.2) installation type Business Intelligence and Forms in a seperate ORACLE_HOME from the previously installed OracleAS Infrastructure. During installation of Oracle Application Server 10g Release 2 (10.1.2.0.2) type Business Intelligence and Forms you will be prompted for Oracle Internet Directory details. Please provide your Oracle Application Server 10g (10.1.4.0.1) Infrastructure hostname and port number as configured in step 1.1.
The OracleAS Infrastructure might be on the same machine as the Business Intelligence and Forms type installation or on a different machine. This installation type includes Discoverer Server 10g, Discoverer Plus 10g, and Discoverer Viewer 10g. You must install Oracle Application Server 10g Release 2 on a standalone server accessing an Oracle E-Business Suite Release 11i database or in a separate ORACLE_HOME on an existing application tier server node."
1.3. Copy Database Connection file
Discoverer 10.1.2 supports Single Sign-On functionality with Oracle E-Business Suite Release 11i. To support Single Sign-On, Discoverer needs access to the Database Connection (dbc) file for the database you wish to connect to. A dbc file is a text file which stores all the information required to connect to a particular database.
In the Discoverer10g $ORACLE_HOME/opmn/conf/opmn.xml file check the variable for FND_SECURE. This variable specifies the directory where Discoverer is trying to locate dbc files. By default this is set to $ORACLE_HOME/discoverer/secure.
Create the directory $ORACLE_HOME/discoverer/secure if it does not exist. Then copy the dbc file from the $FND_TOP/secure directory of the 11i instance you are setting up Discoverer with to the Discoverer 10.1.2 $ORACLE_HOME/discoverer/secure directory you just created.
1.4. Update tnsnames.ora file
On your standalone Oracle Business Intelligence Server 10g Release 2 node, update file $ORACLE_HOME/network/admin/tnsnames.ora and include the tnsnames entry to connect to your Oracle E-Business Suite Release 11i database. Use the same entry as exists in the tnsnames.ora file on your Oracle E-Business Suite Release 11i application tier server node. The database name must match the two_task entry in the dbc file. Verify you can establish a connection to your Oracle E-Business Suite Release 11i database using sqlplus.
2. Apply the latest certified Discoverer Plus and Viewer Patches
AIX Paltform(only for 10.1.2.0.0): Apply patchset 10.1.2.1.0 delivered via patch 4908436 available on Metalink for download.
3. Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.
Upgrade your existing Discoverer 4i or Discoverer 9.0.4 End User Layer to Discoverer 10.1.2 by using the following command on the standalone application server where Oracle Business Intelligence Server 10g Release 2 was installed in Step 1.
$ORACLE_HOME/bin/eulapi -CONNECT
If you are migrating your Discoverer 4i End User Layer, the upgrade process creates a new Discoverer 10.1.2 End User Layer based the existing Discoverer 4i End User Layer. The existing Discoverer 4i End User Layer remains unchanged. A new schema containing the Discoverer 10.1.2 End User Layer will be created under the same Database User. After migration, the Database User contains functional End-User Layers for both Discoverer 4i and 10g. After verifying that the upgrade was successful, you may drop the 4i End-User Layer.
Section 2 : Postinstallation Tasks
This section describes steps for configuring Oracle E-Business Suite Release 11i to use Discoverer 10.1.2, and for loading the Applications-specific content and workbooks into the Discoverer 10.1.2 End User Layer.
1. Apply necessary Oracle Applications interoperability patches using AutoPatch
A) Apply AD patch 5765314
This patch contains utilities for Discoverer End User Layer maintainance.
B) Apply ICX patch 3133021
This patch contains support to invoke Discoverer from E-Business Suite functions.
2. Set Applications Profile Options for Discoverer using AutoConfig
By default, AutoConfig configures profile options for Oracle E-Business Suite Release 11i environments for Discoverer 4i. Proceed with the following steps to allow AutoConfig to switch profile options for your remote, standalone Oracle Business Intelligence 10g Release 2 server:
Edit the AutoConfig context file.
If you are currently using E-Business Suite level 11.5.9 or above, or have applied FND.G patchset (or above), you will use Oracle Applications Manager to edit your context file. For all previous versions, you will use the AutoConfig Context Editor tool.
To edit the context file using Oracle Applications Manager, login to Oracle Applications Manager and navigate to Site Map > AutoConfig > Edit Parameters.
3. Set Applications Profile Options for Discoverer using AutoConfig
By default, AutoConfig configures profile options for Oracle E-Business Suite Release 11i environments for Discoverer 4i. Proceed with the following steps to allow AutoConfig to switch profile options for your remote, standalone Oracle Business Intelligence 10g Release 2 server:
Edit the AutoConfig context file.
If you are currently using E-Business Suite level 11.5.9 or above, or have applied FND.G patchset (or above), you will use Oracle Applications Manager to edit your context file. For all previous versions, you will use the AutoConfig Context Editor tool.
To edit the context file using Oracle Applications Manager, login to Oracle Applications Manager and navigate to Site Map > AutoConfig > Edit Parameters.
Configure standalone discoverer, Discoverer Machine name, Discoverer port, Discoverer protocol,
Disco version comma discovery eul prefix.
4. After that you have to run autoconfig
-Verify Applications profile options in Oracle Applications
Log into Release 11i with the System Administrator responsibility
Navigate to the Profile > System form
Query the %Discoverer% profile options.
Verify the following ICX profile options in Oracle Applications
ICX_DISCOVERER_LAUNCHER=http://:/discoverer/plus?Connect=[APPS_SECURE]
ICX_DISCOVERER_VIEWER_LAUNCHER=http://:/discoverer/viewer?Connect=[APPS_SECURE]
ICX_DISCOVERER_RELEASE=10
ICX_DISCOVERER_USE_VIEWR=Y N
ICX_DEFAULT_EUL=EUL
ICX_DISCOVERER_EUL_LANGUAGE=US
ICX_DISCOVERER_PARAMETERS=exitURL=http://:/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE
Note:
When you open the discoverer EUL using the Discoverer 10g Desktop/Admin it will ask you if you want to upgrade your EUL and you have to choose yes.
To start/stop the new discoverer do the following:
$Disco_ORACLE_HOME/opmn/bin/opmnctl stopall (to stop).
$Disco_ORACLE_HOME/opmn/bin/opmnctl startall (to start).
COMPANY LOGO IMAGE FILE REPLACED
1. The custom company logo image file replaced the $OA_MEDIA/FNDSSCORP.gif.
2. Take the backup of this file and replace with your company logo gif file to this
file.
3. Bonuce the application services.
2. Take the backup of this file and replace with your company logo gif file to this
file.
3. Bonuce the application services.
ADPATCH HELP
bash-2.04$ adpatch help=y
usage: adpatch [help=y]
adpatch Pre-Install Mode
[preinstall=y|n]
adpatch Test Mode
[apply=y|n]
adpatch Non-Interactive mode
[defaultsfile=<$APPL_TOP/admin/SID/defaultsfile>]
[logfile=][interactive=y|n][workers=]
[patchtop=][driver=][restart=y|n]
[abandon=y|n][wait_on_failed_job=y|n]
adpatch
[localworkers=][workers=]
[printdebug=y|n][parallel_index_threshold=]
[order=] [flags=][options=]
adpatch Upload Patch History From Filesystem
[uploadph=y|n]
where
* help=y - Prints help information about adpatch options.
* preinstall - To run adpatch in Pre-Install Mode.
Default - No.
* apply - To run adpatch in Test Mode.
Default - Yes.
* uploadph - To upload the patch history from the filesystem to the
database and exit. This feature can be used when the system
is not in maintenance mode.
Default - No.
* interactive - Invokes adpatch in Non-Interactive mode when
"interactive=no" is specified.
Default - Yes.
Following are usually specified in Non-Interactive Mode, however not all
are compulsory. Some are also valid for interactive mode.
* defaultsfile - Defaults file name.
Default - none. No default file read or written.
* logfile - Adpatch log file name.
Default - none. Adpatch prompts for this value.
* workers - Specifies the number of workers to run.
Default - none. Adpatch prompts for this value.
* patchtop - Top-level directory for the current patch.
Default - none. Adpatch prompts for this value.
* driver - Name of the patch driver file.
Default - none. Adpatch prompts for this value.
* restart - To restart an existing session.
Default - none. Adpatch prompts for this value.
* abandon - To abandon the previous failed session.
Default - No.
* wait_on_failed_job - To prevent adpatch from exiting, when all
workers have failed in Non-Interactive Mode.
Default - No.
* localworkers - Used in Distributed AD to specify the number of
workers to be run on the current machine.
Default - Value specified for workers.
* printdebug - To display extra debugging information.
Default - No.
* parallel_index_threshold - Threshold block count in each table, which when
exceeded for a table causes its indexes to be
created using parallel slaves.
Default - none. Adpatch does not create indexes
in parallel.
* order = To organize list of jobs to run in a phase. Default - forward.
* forward - The order in which jobs are listed in the
patch driver file.
* backward - Opposite to how the jobs are listed in the
patch driver file.
* flags = Generic flags passed to adpatch
* hidepw - To omit the "HIDEPW:" comments in the log file.
Default - hidepw.
* trace - To log all database operations to a trace file.
Default - notrace.
* logging - To create indexes in LOGGING or NOLOGGING mode.
Default - nologging.
* options = Generic options passed to adpatch.
* checkfile - To skip running exec, SQL, and exectier
commands if they are recorded as already run.
Default - checkfile.
* compiledb - To compile invalid objects in the database
after running actions in the database driver.
Default - compiledb.
* compilejsp - To compile out-of-date JSP files, if the patch
has copy actions for at least one JSP file.
Default - compilejsp.
* copyportion - To run commands found in a copy driver.
Default - copyportion.
* databaseportion - To run commands found in a database driver.
Default - databaseportion.
* generateportion - To run commands found in a generate driver.
Default - generateportion.
* integrity - To perform patch integrity checking.
Default - nointegrity.
* maintainmrc - To maintain the MRC schema after running
actions found in the database driver.
Default - maintainmrc.
* autoconfig - To run AutoConfig.
Default - autoconfig.
* actiondetails - To get the details of actions turned off.
Default - actiondetails.
* parallel - To run actions that update the database or
actions that generate files in parallel.
Default - parallel.
* prereq - To perform prerequisite patch checking prior
to running patch driver files.
Default - prereq.
* revcache - To load the package revision cache (if adpatch
determines it is needed).
Default - revcache.
* validate - To connect to all registered Oracle
Applications schemas at the start of the patch.
Default - novalidate.
* hotpatch - A patch which can be applied in Normal mode.
Default - hotpatch.
* phtofile - The patch history will be saved to files.
Default - nophtofile.
usage: adpatch [help=y]
adpatch Pre-Install Mode
[preinstall=y|n]
adpatch Test Mode
[apply=y|n]
adpatch Non-Interactive mode
[defaultsfile=<$APPL_TOP/admin/SID/defaultsfile>]
[logfile=
[patchtop=
[abandon=y|n][wait_on_failed_job=y|n]
adpatch
[localworkers=
[printdebug=y|n][parallel_index_threshold=
[order=
adpatch Upload Patch History From Filesystem
[uploadph=y|n]
where
* help=y - Prints help information about adpatch options.
* preinstall - To run adpatch in Pre-Install Mode.
Default - No.
* apply - To run adpatch in Test Mode.
Default - Yes.
* uploadph - To upload the patch history from the filesystem to the
database and exit. This feature can be used when the system
is not in maintenance mode.
Default - No.
* interactive - Invokes adpatch in Non-Interactive mode when
"interactive=no" is specified.
Default - Yes.
Following are usually specified in Non-Interactive Mode, however not all
are compulsory. Some are also valid for interactive mode.
* defaultsfile - Defaults file name.
Default - none. No default file read or written.
* logfile - Adpatch log file name.
Default - none. Adpatch prompts for this value.
* workers - Specifies the number of workers to run.
Default - none. Adpatch prompts for this value.
* patchtop - Top-level directory for the current patch.
Default - none. Adpatch prompts for this value.
* driver - Name of the patch driver file.
Default - none. Adpatch prompts for this value.
* restart - To restart an existing session.
Default - none. Adpatch prompts for this value.
* abandon - To abandon the previous failed session.
Default - No.
* wait_on_failed_job - To prevent adpatch from exiting, when all
workers have failed in Non-Interactive Mode.
Default - No.
* localworkers - Used in Distributed AD to specify the number of
workers to be run on the current machine.
Default - Value specified for workers.
* printdebug - To display extra debugging information.
Default - No.
* parallel_index_threshold - Threshold block count in each table, which when
exceeded for a table causes its indexes to be
created using parallel slaves.
Default - none. Adpatch does not create indexes
in parallel.
* order = To organize list of jobs to run in a phase. Default - forward.
* forward - The order in which jobs are listed in the
patch driver file.
* backward - Opposite to how the jobs are listed in the
patch driver file.
* flags = Generic flags passed to adpatch
* hidepw - To omit the "HIDEPW:" comments in the log file.
Default - hidepw.
* trace - To log all database operations to a trace file.
Default - notrace.
* logging - To create indexes in LOGGING or NOLOGGING mode.
Default - nologging.
* options = Generic options passed to adpatch.
* checkfile - To skip running exec, SQL, and exectier
commands if they are recorded as already run.
Default - checkfile.
* compiledb - To compile invalid objects in the database
after running actions in the database driver.
Default - compiledb.
* compilejsp - To compile out-of-date JSP files, if the patch
has copy actions for at least one JSP file.
Default - compilejsp.
* copyportion - To run commands found in a copy driver.
Default - copyportion.
* databaseportion - To run commands found in a database driver.
Default - databaseportion.
* generateportion - To run commands found in a generate driver.
Default - generateportion.
* integrity - To perform patch integrity checking.
Default - nointegrity.
* maintainmrc - To maintain the MRC schema after running
actions found in the database driver.
Default - maintainmrc.
* autoconfig - To run AutoConfig.
Default - autoconfig.
* actiondetails - To get the details of actions turned off.
Default - actiondetails.
* parallel - To run actions that update the database or
actions that generate files in parallel.
Default - parallel.
* prereq - To perform prerequisite patch checking prior
to running patch driver files.
Default - prereq.
* revcache - To load the package revision cache (if adpatch
determines it is needed).
Default - revcache.
* validate - To connect to all registered Oracle
Applications schemas at the start of the patch.
Default - novalidate.
* hotpatch - A patch which can be applied in Normal mode.
Default - hotpatch.
* phtofile - The patch history will be saved to files.
Default - nophtofile.
PATCHSETS.SH UTILITY.
Oracle Applications Current Patchset Comparison Utility -
patchsets.sh---> 139684.1 Metalink Good note for patchset utility.
patchsets.sh---> 139684.1 Metalink Good note for patchset utility.
APPLY PATCH IN BETWEEN ADPATCH RUNNING.
Note:175485.1 How to Apply an 11i Patch When adpatch is Already Running
1. Shutdown the workers.
2. Backup the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS
3. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
4. Drop the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS tables.
5. Apply the new patch.
6. Restore the backed up .rf9 files.
7. Restore the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS
9. Re-create synonyms for APPLSYS.AD_DEFERRED_JOBS and APPLSYS.FND_INSTALL_PROCESSES.
10. Start adpatch, it will resume where it stopped previously.
1. Shutdown the workers.
2. Backup the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS
3. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
4. Drop the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS tables.
5. Apply the new patch.
6. Restore the backed up .rf9 files.
7. Restore the FND_INSTALL_PROCESSES & AD_DEFERRED_JOBS
9. Re-create synonyms for APPLSYS.AD_DEFERRED_JOBS and APPLSYS.FND_INSTALL_PROCESSES.
10. Start adpatch, it will resume where it stopped previously.
DROP UNDO TABLESPACE ACTIVE ROLLBACK SEGMENT
1. SET UNDO_MANG= MANUAL ( INIT.ORA)
2. Comment the entries of the undo segments out of the init.ora file by using the following statement in the init.ora file:
_offline_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,.....)
3) Startup mount pfile='fullpath to pfile'
4) Than drop the datafiles,
sql>Alter Database datafile 'fullpath & filename' offline drop;
5) Alter Database Open;
6) Drop the undo segments,
sql>Drop Rollback Segment RB1;
" "
Drop.. RBn;
7) Drop Tablespace Including Contents;
8)Add the new undo tablespace.
9) Shutdown Immediate;
10) Change the init.ora parameters back to Undo_management = AUTO and modify the parameter Undo_tablespace= and remove the _offline_rollback_segments parameter.
11) Startup the Database
2. Comment the entries of the undo segments out of the init.ora file by using the following statement in the init.ora file:
_offline_rollback_segments=(_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,.....)
3) Startup mount pfile='fullpath to pfile'
4) Than drop the datafiles,
sql>Alter Database datafile 'fullpath & filename' offline drop;
5) Alter Database Open;
6) Drop the undo segments,
sql>Drop Rollback Segment RB1;
" "
Drop.. RBn;
7) Drop Tablespace
8)Add the new undo tablespace.
9) Shutdown Immediate;
10) Change the init.ora parameters back to Undo_management = AUTO and modify the parameter Undo_tablespace=
11) Startup the Database
11g new feature (Creating Pfile)
11g New Feature in case lost pfile or spfile.
Create pfile from your your memory (from alert.log)
when instance startup, all parameter setting goes to alert.log file.
Command for create pfile in 11g.
SQL> create pfile='ORACLE_HOME/dbs/initofdev.ora' from memory;
SQL> create pfile='ORACLE_HOME/dbs/spfileofdev.ora' from memory;
SQL> create spfile from pfile;
---------------------------------------------------------------------
Create pfile from your your memory (from alert.log)
when instance startup, all parameter setting goes to alert.log file.
Command for create pfile in 11g.
SQL> create pfile='ORACLE_HOME/dbs/initofdev.ora' from memory;
SQL> create pfile='ORACLE_HOME/dbs/spfileofdev.ora' from memory;
SQL> create spfile from pfile;
---------------------------------------------------------------------
SINGLE NODE TO MULTI NODE CLONING STEPS (11i)
Source Node :- NODE A
-----------------------------------------------
Target Node :- NODE B----> DB TIER
:- NODE C----> CON & ADMIN
:- NODE D----> WEB & FORMS
------------------------------------------------
On source system.
1. Perl adpreclone.pl dbTier
2. Perl adpreclone.pl appsTier
-------------------------------------------------
Next step
1. Copy the source rdbms home 9.2.0 and all source datafiles from node a to node b.
2. Copy the application tier file system from Node a to Node b & c.
----------------------------------------------------------------------------
Node B
1. Perl adcfgclone.pl dbTier
(If you are using hot backup then use this command)
1. Perl adcfgclone.pl dbTechStack
-----------------------------------------------------------------------------
Node C & D.
1. Perl adcfgclone.pl appsTier.
----------------------------------------------------------------------------
For finishing task Metalink note :- 230672.1
-----------------------------------------------
Target Node :- NODE B----> DB TIER
:- NODE C----> CON & ADMIN
:- NODE D----> WEB & FORMS
------------------------------------------------
On source system.
1. Perl adpreclone.pl dbTier
2. Perl adpreclone.pl appsTier
-------------------------------------------------
Next step
1. Copy the source rdbms home 9.2.0 and all source datafiles from node a to node b.
2. Copy the application tier file system from Node a to Node b & c.
Node B
1. Perl adcfgclone.pl dbTier
(If you are using hot backup then use this command)
1. Perl adcfgclone.pl dbTechStack
-----------------------------------------------------------------------------
Node C & D.
1. Perl adcfgclone.pl appsTier.
----------------------------------------------------------------------------
For finishing task Metalink note :- 230672.1
Subscribe to:
Posts (Atom)