Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables.
Each database should have one temporary tablespace that is created when the database is created. You can create, drop and manage tablespaces with create temporary tablespace, drop temporary tablespace and alter temporary tablespace commands.
Allocate temporary tablespace to each user in the daabase, so we can avoid from sort space in the System tablespace.
SQL> CREATE USER scott DEFAULT TABLESPACE data TEMPORARY TABLESPACE temp;
SQL> ALTER USER scott TEMPORARY TABLESPACE temp;
You can remove a TEMPFILE from a database.
SQL> ALTER DATABASE TEMPFILE '/db2/oradata/dev/data/temp02.dbf' DROP INCLUDING DATAFILES;
If you remove all tempfiles from a temporary tablespace, you may encounter error:
ORA-25153: Temporary Tablespace is Empty. So add a TEMPFILE to a temporary tablespace:
SQL>ALTER TABLESPACE temp ADD TEMPFILE '/db2/oradata/dev/data/temp002.dbf' SIZE 200M;
SQL> ALTER TABLESPACE temp OFFLINE
SQL> DROP TABLESPACE temp;
HOW TO create Temporary Tablespaces?
SQL> CREATE TEMPORARY TABLESPACE temp
TEMPFILE '/db2/oradata/dev/data/temp01.dbf' SIZE 3000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;
Add Temp Datafiles
SQL> ALTER TABLESPACE temp
ADD TEMPFILE '/db2/oradata/dev/data/temp02.dbf' SIZE 2000M REUSE;
How to Set Default Temporary Tablespaces
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
- The Default Temporary Tablespace must be of type TEMPORARY
- The DEFAULT TEMPORARY TABLESPACE cannot be taken off-line
- The DEFAULT TEMPORARY TABLESPACE cannot be dropped until you create another one.
SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';
Monitoring Temporary Tablespaces and Sorting
Ttempfiles are not listed in V$DATAFILE and DBA_DATA_FILES
Use V$TEMPFILE and DBA_TEMP_FILES.
One can monitor temporary segments from V$SORT_SEGMENT and V$SORT_USAGE
DBA_FREE_SPACE does not record free space for temporary tablespaces. Use V$TEMP_SPACE_HEADER instead:
SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;
TABLESPACE_NAME BYTES_USED BYTES_FREE
------------------------------ ---------- ----------
TEMP 328204288 1819279360
TEMP 332398592 1815085056
TEMP 317718528 1829765120
Concurrent Processing / APPS Reporting Scripts
Concurrent Manager Scripts
Non Destructive Script to Clean Concurrent Manager Tables
CMCLEAN.sql
This script re-sets the flags for requests to completed to allow the Managers to come up
(For all Releases of Apps.)
How To Re-create Concurrent Manager Views
This script details how to Re-create the Concurrent Manager Views
(For all Releases of Apps.)
Concurrent Manager Check Script
CCM.sql
This script will diagnose Concurrent Managers and Concurrent Requests
(For all Releases of Apps.)
Concurrent Manager Check Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Apps. 11.5.3 or higher)
Internal Manager Log Script
ICMLOG.sql
This script will provide the location for Retrieving the Internal Manager Log file
(For For all Releases of Apps.)
Concurrent Requests Scripts
Concurrent Request Log Script
CMLOGS.txt
Script for Retrieving Log Files Associated to a Concurrent Request
(For For all Releases of Apps.)
Concurrent Request Check Script
REQCHECK.sql
Script for diagnosing problematic Concurrent Requests
(For all Releases of Apps.)
Analyze Pending Requests Script
ANALYZEPENDING.sql
Script for diagnosing Pending Concurrent Requests
(For all Releases of Apps.)
Analyze Request Script
ANALYZEREQ.sql
Script for Providing a Detailed Analysis of One Concurrent Request
(For Applications Release 11 and up.)
Who Can Run which Requests
WHOCANRUN.sql
Script that lists Responsibilities that can Run a Given Concurrent Program
(For all Releases of Apps.)
Concurrent Request Diagnostic Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Applications Release 11.5.3 and up.)
Concurrent Request Diagnostic Script
bde_request.sql
Process and Session info for one Concurrent Request
(For Applications Release 11.5 and up.)
Printing Script
FNDPrinterValidation115.sh
This script checks a customer's Printer configuration/setup within Oracle Applications.
(For Applications Release 11.5.3 and up.)
Report Review Agent Script
FNDValidateFNDFS115.sh
This script checks basic setup of the concurrent processing tier report review agent.
(For Applications Release 11.5.3 and up.)
You can download the scripts from metalink.
Concurrent Processing (CP) / APPS Reporting Scripts Doc ID: Note:213021.1
Non Destructive Script to Clean Concurrent Manager Tables
CMCLEAN.sql
This script re-sets the flags for requests to completed to allow the Managers to come up
(For all Releases of Apps.)
How To Re-create Concurrent Manager Views
This script details how to Re-create the Concurrent Manager Views
(For all Releases of Apps.)
Concurrent Manager Check Script
CCM.sql
This script will diagnose Concurrent Managers and Concurrent Requests
(For all Releases of Apps.)
Concurrent Manager Check Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Apps. 11.5.3 or higher)
Internal Manager Log Script
ICMLOG.sql
This script will provide the location for Retrieving the Internal Manager Log file
(For For all Releases of Apps.)
Concurrent Requests Scripts
Concurrent Request Log Script
CMLOGS.txt
Script for Retrieving Log Files Associated to a Concurrent Request
(For For all Releases of Apps.)
Concurrent Request Check Script
REQCHECK.sql
Script for diagnosing problematic Concurrent Requests
(For all Releases of Apps.)
Analyze Pending Requests Script
ANALYZEPENDING.sql
Script for diagnosing Pending Concurrent Requests
(For all Releases of Apps.)
Analyze Request Script
ANALYZEREQ.sql
Script for Providing a Detailed Analysis of One Concurrent Request
(For Applications Release 11 and up.)
Who Can Run which Requests
WHOCANRUN.sql
Script that lists Responsibilities that can Run a Given Concurrent Program
(For all Releases of Apps.)
Concurrent Request Diagnostic Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Applications Release 11.5.3 and up.)
Concurrent Request Diagnostic Script
bde_request.sql
Process and Session info for one Concurrent Request
(For Applications Release 11.5 and up.)
Printing Script
FNDPrinterValidation115.sh
This script checks a customer's Printer configuration/setup within Oracle Applications.
(For Applications Release 11.5.3 and up.)
Report Review Agent Script
FNDValidateFNDFS115.sh
This script checks basic setup of the concurrent processing tier report review agent.
(For Applications Release 11.5.3 and up.)
You can download the scripts from metalink.
Concurrent Processing (CP) / APPS Reporting Scripts Doc ID: Note:213021.1
Configuring SSL with Oracle HTTP Server
Set ths following environment varibles
export SCRIPT_TOP=$COMMON_TOP/admin/scripts/sar_sys45
export APACHE_TOP=/oracle/app/apps/sarora/iAS/Apache
export OPENSSL_TOP=/oracle/app/apps/sarora/iAS/Apache/open_ssl
export OPENSSL_CONF=$OPENSSL_TOP/bin
==============================
Edit in XML file ===> APPL_TOP/admin
set the %s_url_protocol variable to https
set the %s_local_url_protocol variable to https
set the %s_webentryurlprotocol variable to https
set the %s_frmConnectMode variable to https
set the %s_webssl_port variable to the Apache SSL port required
set the %s_active_webport variable to the same value as that for the %s_webssl_port variable
set the %s_webport variable to the same value as that for the %s_webssl_port variable
set the %s_web_ssl_directory variable to point to the full directory path of the directory that is to contain the .crt and
.key files that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache
set %s_apps_portal_url variable to https
=============================
Using self signed certificate with Applications genereted by OpenSSL for WebSever
$APACHE_TOP/open_ssl/bin/openssl req -x509 -newkey rsa:1024 -keyout cakey.pem -out cacert.pem -days 10000 -config openssl.cnf
$APACHE_TOP/open_ssl/bin/openssl req -nodes -new -x509 -keyout apache.key -out apache_request.pem -days 3650 -config openssl.cnf
$APACHE_TOP/open_ssl/bin/openssl x509 -x509toreq -in apache_request.pem -signkey apache.key -out apache.csr
$APACHE_TOP/open_ssl/bin/openssl ca -config openssl.cnf -policy policy_anything -out apache.crt -infiles apache.csr
cp apache.crt $COMMON_TOP/admin/certs/apache/ssl.crt/server.crt
cp apache.key $COMMON_TOP/admin/certs/apache/ssl.key/server.key
cp cacert.pem $COMMON_TOP/admin/certs/apache/ssl.crt/ca.crt
cp $APACHE_TOP/Apache/conf/ssl.crt/ca-bundle.crt $COMMON_TOP/admin/certs/apache/ssl.crt
openssl s_client -connect sys45.doyen.in:443
===========================
FRM-92050 Failed to connect to the server
If you got above forms error, please run the below syntax
txkrun.pl -script=SetAdvCfg -appsuser=apps -appspass=apps -enable=FormsLsnrServlet
[applmgr@sys43 TEST_sys43]$ txkrun.pl -script=SetAdvCfg -appsuser=apps -appspass=apps -enable=FormsLsnrServlet
++++ Configuration has completed successfully!
For additional information, review the following output file:
/oracle/app/apps/testcomn/admin/out/TEST_sys43/txkSetAdvCfg.xml
Then after sucessfully completed txkrun.pl, run the autoconfig.
[applmgr@sys43 TEST_sys43]$ adautocfg.sh
==============================
After complete the autoconfig, bounce the apps server.
Now start the apps server and start this appache scripts from root user (adapcctl.sh start)
[root@sys43 ~]# sh /oracle/app/apps/testcomn/admin/scripts/TEST_sys43/adapcctl.sh start
adapcctl.sh version 115.54
Apache Web Server Listener is not running.
Starting Apache Web Server Listener (dedicated HTTP) ...
Apache Web Server Listener (PLSQL) is not running.
Starting Apache Web Server Listener (dedicated PLSQL) ...
adapcctl.sh: exiting with status 0
=============================
https://.
=============================
System: Connection reset by peer (errno: 104)
Comment SSLCertificateChainFile in httpd.conf.
=============================
Reference Documents ID
http://forums.oracle.com/forums/thread.jspa?messageID=2307995
Running Configuration Wizards from the Command Line in Oracle Applications 11i
Metalik id : 277574.1
Subject: Troubleshooting SSL with Oracle Applications 11i
Doc ID: Note:300969.1
================================
export SCRIPT_TOP=$COMMON_TOP/admin/scripts/sar_sys45
export APACHE_TOP=/oracle/app/apps/sarora/iAS/Apache
export OPENSSL_TOP=/oracle/app/apps/sarora/iAS/Apache/open_ssl
export OPENSSL_CONF=$OPENSSL_TOP/bin
==============================
Edit in XML file ===> APPL_TOP/admin
set the %s_url_protocol variable to https
set the %s_local_url_protocol variable to https
set the %s_webentryurlprotocol variable to https
set the %s_frmConnectMode variable to https
set the %s_webssl_port variable to the Apache SSL port required
set the %s_active_webport variable to the same value as that for the %s_webssl_port variable
set the %s_webport variable to the same value as that for the %s_webssl_port variable
set the %s_web_ssl_directory variable to point to the full directory path of the directory that is to contain the .crt and
.key files that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache
set %s_apps_portal_url variable to https
=============================
Using self signed certificate with Applications genereted by OpenSSL for WebSever
$APACHE_TOP/open_ssl/bin/openssl req -x509 -newkey rsa:1024 -keyout cakey.pem -out cacert.pem -days 10000 -config openssl.cnf
$APACHE_TOP/open_ssl/bin/openssl req -nodes -new -x509 -keyout apache.key -out apache_request.pem -days 3650 -config openssl.cnf
$APACHE_TOP/open_ssl/bin/openssl x509 -x509toreq -in apache_request.pem -signkey apache.key -out apache.csr
$APACHE_TOP/open_ssl/bin/openssl ca -config openssl.cnf -policy policy_anything -out apache.crt -infiles apache.csr
cp apache.crt $COMMON_TOP/admin/certs/apache/ssl.crt/server.crt
cp apache.key $COMMON_TOP/admin/certs/apache/ssl.key/server.key
cp cacert.pem $COMMON_TOP/admin/certs/apache/ssl.crt/ca.crt
cp $APACHE_TOP/Apache/conf/ssl.crt/ca-bundle.crt $COMMON_TOP/admin/certs/apache/ssl.crt
openssl s_client -connect sys45.doyen.in:443
===========================
FRM-92050 Failed to connect to the server
If you got above forms error, please run the below syntax
txkrun.pl -script=SetAdvCfg -appsuser=apps -appspass=apps -enable=FormsLsnrServlet
[applmgr@sys43 TEST_sys43]$ txkrun.pl -script=SetAdvCfg -appsuser=apps -appspass=apps -enable=FormsLsnrServlet
++++ Configuration has completed successfully!
For additional information, review the following output file:
/oracle/app/apps/testcomn/admin/out/TEST_sys43/txkSetAdvCfg.xml
Then after sucessfully completed txkrun.pl, run the autoconfig.
[applmgr@sys43 TEST_sys43]$ adautocfg.sh
==============================
After complete the autoconfig, bounce the apps server.
Now start the apps server and start this appache scripts from root user (adapcctl.sh start)
[root@sys43 ~]# sh /oracle/app/apps/testcomn/admin/scripts/TEST_sys43/adapcctl.sh start
adapcctl.sh version 115.54
Apache Web Server Listener is not running.
Starting Apache Web Server Listener (dedicated HTTP) ...
Apache Web Server Listener (PLSQL) is not running.
Starting Apache Web Server Listener (dedicated PLSQL) ...
adapcctl.sh: exiting with status 0
=============================
https://
=============================
System: Connection reset by peer (errno: 104)
Comment SSLCertificateChainFile in httpd.conf.
=============================
Reference Documents ID
http://forums.oracle.com/forums/thread.jspa?messageID=2307995
Running Configuration Wizards from the Command Line in Oracle Applications 11i
Metalik id : 277574.1
Subject: Troubleshooting SSL with Oracle Applications 11i
Doc ID: Note:300969.1
================================
How To Use AD Merge Patch
Create Source and destination directory
Copy all the patche to source directory
and run the below scripts
admrgpch -s /home/applmgr/patch10g/source -d /home/applmgr/patch10g/dest -merge_name ramesh
Executing the merge of the patch drivers -- Processing patch: /home/applmgr/patch10g/source/4888294 -- Done processing patch: /home/applmgr/patch10g/source/4888294
-- Processing patch: /home/applmgr/patch10g/source/4653225 -- Done processing patch: /home/applmgr/patch10g/source/4653225
-- Processing patch: /home/applmgr/patch10g/source/5985992 -- Done processing patch: /home/applmgr/patch10g/source/5985992
-- Processing patch: /home/applmgr/patch10g/source/6502082 -- Done processing patch: /home/applmgr/patch10g/source/6502082
Copying files...
5% complete. Copied 98 files of 1942...
10% complete. Copied 195 files of 1942...
15% complete. Copied 292 files of 1942...
20% complete. Copied 389 files of 1942...
25% complete. Copied 486 files of 1942...
30% complete. Copied 583 files of 1942...
35% complete. Copied 680 files of 1942...
40% complete. Copied 777 files of 1942...
45% complete. Copied 874 files of 1942...
50% complete. Copied 971 files of 1942...
55% complete. Copied 1069 files of 1942...
60% complete. Copied 1166 files of 1942...
65% complete. Copied 1263 files of 1942...
70% complete. Copied 1360 files of 1942...
75% complete. Copied 1457 files of 1942...
80% complete. Copied 1554 files of 1942...
85% complete. Copied 1651 files of 1942...
90% complete. Copied 1748 files of 1942...
95% complete. Copied 1845 files of 1942...
100% complete. Copied 1942 files of 1942...
Character-set converting files...
4 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
Copy all the patche to source directory
and run the below scripts
admrgpch -s /home/applmgr/patch10g/source -d /home/applmgr/patch10g/dest -merge_name ramesh
Executing the merge of the patch drivers -- Processing patch: /home/applmgr/patch10g/source/4888294 -- Done processing patch: /home/applmgr/patch10g/source/4888294
-- Processing patch: /home/applmgr/patch10g/source/4653225 -- Done processing patch: /home/applmgr/patch10g/source/4653225
-- Processing patch: /home/applmgr/patch10g/source/5985992 -- Done processing patch: /home/applmgr/patch10g/source/5985992
-- Processing patch: /home/applmgr/patch10g/source/6502082 -- Done processing patch: /home/applmgr/patch10g/source/6502082
Copying files...
5% complete. Copied 98 files of 1942...
10% complete. Copied 195 files of 1942...
15% complete. Copied 292 files of 1942...
20% complete. Copied 389 files of 1942...
25% complete. Copied 486 files of 1942...
30% complete. Copied 583 files of 1942...
35% complete. Copied 680 files of 1942...
40% complete. Copied 777 files of 1942...
45% complete. Copied 874 files of 1942...
50% complete. Copied 971 files of 1942...
55% complete. Copied 1069 files of 1942...
60% complete. Copied 1166 files of 1942...
65% complete. Copied 1263 files of 1942...
70% complete. Copied 1360 files of 1942...
75% complete. Copied 1457 files of 1942...
80% complete. Copied 1554 files of 1942...
85% complete. Copied 1651 files of 1942...
90% complete. Copied 1748 files of 1942...
95% complete. Copied 1845 files of 1942...
100% complete. Copied 1942 files of 1942...
Character-set converting files...
4 unified drivers merged.
Patch merge completed successfully
Please check the log file at ./admrgpch.log.
Developer 6i Patch Patch 18*
Download the below Patches for developer 6i Patch set.
===========================================================
6502082 - done - AD.I.6
5985992 - done - TXK AUTOCONFIG ROLLUP PATCH Q (JUL/AUG 2007)
3453499 - already applied
4653225 - done - 11.5.10 INTEROP PATCH FOR 10GR2
==============================================================
4948577 - done - Developer 6i Patch Patch 18*
4888294 - done - Apps Interop Patch
3830807 - done - APPLICATIONS INTEROPERABILITY PATCH
4586086 - done - UNABLE TO RELINK LIBIFJAPI60.SO IN RHAS3.0
Download Additional Developer 6i Patches
5713544 - done
4261542 - done
5216496 - done
5753922 - done
6195758 - done
5938515 - done
================================================================
Apply this patch 5985992
From the location where this patch was unzipped, change directory
to fnd/patch/115/bin .
on Unix:
./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
[applmgr@sys43 bin]$ ./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = /oracle/app/apps/testcomn/rgf/TEST_sys43/TXK/txkValidateRollup_Fri_Apr_11_21_21_24_2008_stdout.log
Reportfile /oracle/app/apps/testcomn/temp/txkValidateRollup.html generated successfully.
On the Application Tier (as the APPLMGR user):
Source the environment file.
Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip in $APPL_TOP/admin/out .
On the Database Tier (as the ORACLE user):
Copy or FTP the appsutil.zip file to the
cd
unzip -o appsutil.zip
Run AutoConfig by executing:
/appsutil/scripts//
adautocfg.sh
==================================================================
Forms & Reports 6i Patch 18 for Linux
Set your ORACLE_HOME.
If you are going to apply this patch on top of an iAS install:
Set ORACLE_HOME to/6iserver
Prepend/6iserver/bin to the *beginning* of PATH
Prepend/6iserver/lib to the *beginning* of LD_LIBRARY_PATH
==========================================================
[applmgr@sys43 patch10g]$ export ORACLE_HOME=/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 patch10g]$ export LD_LIBRARY_PATH=/oracle/app/apps/testora/iAS/6iserver/lib:$LD_LIBRARY_PATH
[applmgr@sys43 patch10g]$ export PATH=/oracle/app/apps/testora/iAS/6iserver/bin:$PATH
[applmgr@sys43 6iserver]$ pwd
/oracle/app/apps/testora/iAS/6iserver
=============================================
Copy the files in this patch to your $ORACLE_HOME
[applmgr@sys43 developer6i_patch18]$ echo $ORACLE_HOME
/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 6iserver]$ unzip p4948577_600_LINUX.zip
ls -ltr
drwxr-xr-x 6 applmgr oinstall 4096 Jan 13 2006 developer6i_patch18
[applmgr@sys43 developer6i_patch18]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18
Run the install script contained in the patch:
cd $ORACLE_HOME/developer6i_patch18
./patch_install.sh 2>&1 | tee patch_install_p18.log (ksh)
./patch_install.sh |& tee patch_install_p18.log (csh)
================================================================
[applmgr@sys43 developer6i_patch18]$ ./patch_install.sh 2>&1 | tee patch_install_p18.log
Patch can be deinstalled by using /oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/patch_deinstall.sh script
===============================================================
Check patch_install_p18.log for errors
Relink Procedure Builder, Forms, Graphics and Reports:
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
============================================================
[applmgr@sys43 developer6i_patch18]$ cd $ORACLE_HOME/procbuilder60/lib
[applmgr@sys43 lib]$ make -f ins_procbuilder.mk install
[applmgr@sys43 lib]$ cd $ORACLE_HOME/forms60/lib
[applmgr@sys43 lib]$ make -f ins_forms60w.mk install
[applmgr@sys43 lib]$ cd $ORACLE_HOME/graphics60/lib
[applmgr@sys43 lib]$ make -f ins_graphics60w.mk install
========================================================
Reports has both link-time and run-time dependency with libjava.so so you need to append either one of:
$ORACLE_HOME/network/jre11/lib/linux/native_threads
$ORACLE_HOME/network/jre11/lib/i686/native_threads
in $LD_LIBRARY_PATH before linking Reports.
Please check your files under $ORACLE_HOME/network/jre11/lib to see which one of the above is appropriate on your system. The same $LD_LIBRARY_PATH should be used at run-time.
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
======================================================
[applmgr@sys43 lib]$ cd $ORACLE_HOME/network/jre11/lib/i686/
[applmgr@sys43 i686]$ pwd
/oracle/app/apps/testora/iAS/6iserver/network/jre11/lib/i686
[applmgr@sys43 i686]$ ls -ls native_threads
total 4940
2552 -rwxr-xr-x 1 applmgr oinstall 2606042 Jun 20 2001 libawt.so
1376 -rwxr-xr-x 1 applmgr oinstall 1404357 Jun 20 2001 libjava.so
312 -rwxr-xr-x 1 applmgr oinstall 313893 Jun 20 2001 libjpeg_sun.so
164 -rwxr-xr-x 1 applmgr oinstall 160561 Jun 20 2001 libmath.so
88 -rwxr-xr-x 1 applmgr oinstall 84707 Jun 20 2001 libmmedia.so
156 -rwxr-xr-x 1 applmgr oinstall 151672 Jun 20 2001 libnet.so
88 -rwxr-xr-x 1 applmgr oinstall 85802 Jun 20 2001 libsysresource.so
204 -rwxr-xr-x 1 applmgr oinstall 203482 Jun 20 2001 libzip.so
[applmgr@sys43 i686]$ export LD_LIBRARY_PATH=$ORACLE_HOME/network/jre11/lib:$LD_LIBRARY_PATH
[applmgr@sys43 i686]$ cd $ORACLE_HOME/reports60/lib
[applmgr@sys43 lib]$ make -f ins_reports60w.mk install
=======================================================
[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/bin
-rwxr-xr-x 1 applmgr oinstall 2811 Dec 12 2005 genshlib
Copy this file genshlib to /oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp genshlib genshlib.bak_Apr12
[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp -b genshlib /oracle/app/apps/testora/iAS/6iserver/bin
============================================================
unzip p3830807_8063_LINUX.zip
cd 3830807
chmod u+x patch.sh
export LD_LIBRARY_PATH=/oracle/app/apps/testora/8.0.6/network/jre11/lib:$LD_LIBRARY_PATH
./patch.sh
================================================================================
cd $ORACLE_HOME
mkdir patch
cd patch
unzip p4586086_600_LINUX.zip
cd $ORACLE_HOME/forms60/lib
[applmgr@sys43 lib]$ ls -lrt env_forms60.mk
-rw-r--r-- 1 applmgr oinstall 28454 Dec 22 2005 env_forms60.mk
mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
cp $ORACLE_HOME/patch/bug4586086/env_forms60.mk $ORACLE_HOME/forms60/lib
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk libso_install
adrelink.sh force=y "fnd f60webmx"
=============================================================
cd 5713544
sh patch.sh
E.g. to relink f60webmx for Oracle Applications
adrelink.sh force=y "fnd f60webmx"
===============================================================
1. Stop your web listeners and Forms Server.
2. Make a patch directory within your 6i ORACLE_HOME and unzip
cd $ORACLE_HOME
[applmgr@sys43 6iserver]$ cp p4261542_600_GENERIC.zip $ORACLE_HOME
unzip p4261542_600_GENERIC.zip
[Part 2] Unzip the java class files and regenerate your JAR files
3. Backup the Forms class files, i.e.$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
[applmgr@sys43 4261542]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ ls -ls AlertDialog.class
8 -rw-rw-r-- 1 applmgr oinstall 6673 Dec 21 2005 AlertDialog.class
[applmgr@sys43 handler]$ mv AlertDialog.class AlertDialog.class.bak
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/engine/
[applmgr@sys43 engine]$ ls -ls Main.class
24 -rw-rw-r-- 1 applmgr oinstall 20545 Dec 21 2005 Main.class
[applmgr@sys43 engine]$ mv Main.class Main.class.bak
4. Inside folder 4261542 in step-2 has class files in oracle\forms\engine directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/engine
[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/engine
[applmgr@sys43 engine]$ cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/handler
[applmgr@sys43 handler]$ cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
5. Generate JAR Files use adadmin
=================================
cd 5216496
sh patch.sh
=================================
[applmgr@sys43 6iserver]$ cp p6195758_60827_GENERIC.zip $ORACLE_HOME
[applmgr@sys43 6iserver]$ unzip p6195758_60827_GENERIC.zip
Backup the Forms class files,
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv UICommon.class UICommon.class.bak
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv ComponentItem.class ComponentItem.class.bak
Inside folder 6195758 in step-2 has class files in oracle\forms\handler directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/handler
[applmgr@sys43 handler]$ cd $ORACLE_HOME/6195758/oracle/forms/handler
[applmgr@sys43 handler]$ cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
[applmgr@sys43 handler]$ cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
====================================
cd 5938515
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
========================================
cd 5753922
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
=======================================
How to find forms version in patch set
$ORACLE_HOME/bin/f60gen help=y
Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)
Metalik id :125767.1
6.0.8.27.0 ===> Patch 18
Pre-Upgrade Step:
select banner from v$version;
SELECT product_group_id GroupID, product_group_name GroupName,release_name Release,product_group_type GroupType, argument1 FROM fnd_product_groups;
select count(*) from ad_bugs where bug_number = '5985992';
patch 4653225
Check the developer 6i Patch set.
Metalink Note 125767.1
Developer 6i patchset 18 (4948577)
===========================================================
6502082 - done - AD.I.6
5985992 - done - TXK AUTOCONFIG ROLLUP PATCH Q (JUL/AUG 2007)
3453499 - already applied
4653225 - done - 11.5.10 INTEROP PATCH FOR 10GR2
==============================================================
4948577 - done - Developer 6i Patch Patch 18*
4888294 - done - Apps Interop Patch
3830807 - done - APPLICATIONS INTEROPERABILITY PATCH
4586086 - done - UNABLE TO RELINK LIBIFJAPI60.SO IN RHAS3.0
Download Additional Developer 6i Patches
5713544 - done
4261542 - done
5216496 - done
5753922 - done
6195758 - done
5938515 - done
================================================================
Apply this patch 5985992
From the location where this patch was unzipped, change directory
to fnd/patch/115/bin .
on Unix:
./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
[applmgr@sys43 bin]$ ./txkprepatchcheck.pl -script=ValidateRollup -outfile=$APPLTMP/txkValidateRollup.html -appspass=apps
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT = /oracle/app/apps/testcomn/rgf/TEST_sys43/TXK/txkValidateRollup_Fri_Apr_11_21_21_24_2008_stdout.log
Reportfile /oracle/app/apps/testcomn/temp/txkValidateRollup.html generated successfully.
On the Application Tier (as the APPLMGR user):
Source the environment file.
Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip in $APPL_TOP/admin/out .
On the Database Tier (as the ORACLE user):
Copy or FTP the appsutil.zip file to the
cd
unzip -o appsutil.zip
Run AutoConfig by executing:
adautocfg.sh
==================================================================
Forms & Reports 6i Patch 18 for Linux
Set your ORACLE_HOME.
If you are going to apply this patch on top of an iAS install:
Set ORACLE_HOME to
Prepend
Prepend
==========================================================
[applmgr@sys43 patch10g]$ export ORACLE_HOME=/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 patch10g]$ export LD_LIBRARY_PATH=/oracle/app/apps/testora/iAS/6iserver/lib:$LD_LIBRARY_PATH
[applmgr@sys43 patch10g]$ export PATH=/oracle/app/apps/testora/iAS/6iserver/bin:$PATH
[applmgr@sys43 6iserver]$ pwd
/oracle/app/apps/testora/iAS/6iserver
=============================================
Copy the files in this patch to your $ORACLE_HOME
[applmgr@sys43 developer6i_patch18]$ echo $ORACLE_HOME
/oracle/app/apps/testora/iAS/6iserver
[applmgr@sys43 6iserver]$ unzip p4948577_600_LINUX.zip
ls -ltr
drwxr-xr-x 6 applmgr oinstall 4096 Jan 13 2006 developer6i_patch18
[applmgr@sys43 developer6i_patch18]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18
Run the install script contained in the patch:
cd $ORACLE_HOME/developer6i_patch18
./patch_install.sh 2>&1 | tee patch_install_p18.log (ksh)
./patch_install.sh |& tee patch_install_p18.log (csh)
================================================================
[applmgr@sys43 developer6i_patch18]$ ./patch_install.sh 2>&1 | tee patch_install_p18.log
Patch can be deinstalled by using /oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/patch_deinstall.sh script
===============================================================
Check patch_install_p18.log for errors
Relink Procedure Builder, Forms, Graphics and Reports:
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
============================================================
[applmgr@sys43 developer6i_patch18]$ cd $ORACLE_HOME/procbuilder60/lib
[applmgr@sys43 lib]$ make -f ins_procbuilder.mk install
[applmgr@sys43 lib]$ cd $ORACLE_HOME/forms60/lib
[applmgr@sys43 lib]$ make -f ins_forms60w.mk install
[applmgr@sys43 lib]$ cd $ORACLE_HOME/graphics60/lib
[applmgr@sys43 lib]$ make -f ins_graphics60w.mk install
========================================================
Reports has both link-time and run-time dependency with libjava.so so you need to append either one of:
$ORACLE_HOME/network/jre11/lib/linux/native_threads
$ORACLE_HOME/network/jre11/lib/i686/native_threads
in $LD_LIBRARY_PATH before linking Reports.
Please check your files under $ORACLE_HOME/network/jre11/lib to see which one of the above is appropriate on your system. The same $LD_LIBRARY_PATH should be used at run-time.
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
======================================================
[applmgr@sys43 lib]$ cd $ORACLE_HOME/network/jre11/lib/i686/
[applmgr@sys43 i686]$ pwd
/oracle/app/apps/testora/iAS/6iserver/network/jre11/lib/i686
[applmgr@sys43 i686]$ ls -ls native_threads
total 4940
2552 -rwxr-xr-x 1 applmgr oinstall 2606042 Jun 20 2001 libawt.so
1376 -rwxr-xr-x 1 applmgr oinstall 1404357 Jun 20 2001 libjava.so
312 -rwxr-xr-x 1 applmgr oinstall 313893 Jun 20 2001 libjpeg_sun.so
164 -rwxr-xr-x 1 applmgr oinstall 160561 Jun 20 2001 libmath.so
88 -rwxr-xr-x 1 applmgr oinstall 84707 Jun 20 2001 libmmedia.so
156 -rwxr-xr-x 1 applmgr oinstall 151672 Jun 20 2001 libnet.so
88 -rwxr-xr-x 1 applmgr oinstall 85802 Jun 20 2001 libsysresource.so
204 -rwxr-xr-x 1 applmgr oinstall 203482 Jun 20 2001 libzip.so
[applmgr@sys43 i686]$ export LD_LIBRARY_PATH=$ORACLE_HOME/network/jre11/lib:$LD_LIBRARY_PATH
[applmgr@sys43 i686]$ cd $ORACLE_HOME/reports60/lib
[applmgr@sys43 lib]$ make -f ins_reports60w.mk install
=======================================================
[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/developer6i_patch18/bin
-rwxr-xr-x 1 applmgr oinstall 2811 Dec 12 2005 genshlib
Copy this file genshlib to /oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp genshlib genshlib.bak_Apr12
[applmgr@sys43 bin]$ pwd
/oracle/app/apps/testora/iAS/6iserver/bin
[applmgr@sys43 bin]$ cp -b genshlib /oracle/app/apps/testora/iAS/6iserver/bin
============================================================
unzip p3830807_8063_LINUX.zip
cd 3830807
chmod u+x patch.sh
export LD_LIBRARY_PATH=/oracle/app/apps/testora/8.0.6/network/jre11/lib:$LD_LIBRARY_PATH
./patch.sh
================================================================================
cd $ORACLE_HOME
mkdir patch
cd patch
unzip p4586086_600_LINUX.zip
cd $ORACLE_HOME/forms60/lib
[applmgr@sys43 lib]$ ls -lrt env_forms60.mk
-rw-r--r-- 1 applmgr oinstall 28454 Dec 22 2005 env_forms60.mk
mv env_forms60.mk env_forms60.mk.PRE_BUG4586086
cp $ORACLE_HOME/patch/bug4586086/env_forms60.mk $ORACLE_HOME/forms60/lib
cd $ORACLE_HOME/forms60/lib
make -f cus_forms60w.mk libso_install
adrelink.sh force=y "fnd f60webmx"
=============================================================
cd 5713544
sh patch.sh
E.g. to relink f60webmx for Oracle Applications
adrelink.sh force=y "fnd f60webmx"
===============================================================
1. Stop your web listeners and Forms Server.
2. Make a patch directory within your 6i ORACLE_HOME and unzip
cd $ORACLE_HOME
[applmgr@sys43 6iserver]$ cp p4261542_600_GENERIC.zip $ORACLE_HOME
unzip p4261542_600_GENERIC.zip
[Part 2] Unzip the java class files and regenerate your JAR files
3. Backup the Forms class files, i.e.$ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
[applmgr@sys43 4261542]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ ls -ls AlertDialog.class
8 -rw-rw-r-- 1 applmgr oinstall 6673 Dec 21 2005 AlertDialog.class
[applmgr@sys43 handler]$ mv AlertDialog.class AlertDialog.class.bak
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/engine/
[applmgr@sys43 engine]$ ls -ls Main.class
24 -rw-rw-r-- 1 applmgr oinstall 20545 Dec 21 2005 Main.class
[applmgr@sys43 engine]$ mv Main.class Main.class.bak
4. Inside folder 4261542 in step-2 has class files in oracle\forms\engine directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/engine
[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/engine
[applmgr@sys43 engine]$ cp Main.class $ORACLE_HOME/forms60/java/oracle/forms/engine/Main.class
[applmgr@sys43 engine]$ cd $ORACLE_HOME/4261542/oracle/forms/handler
[applmgr@sys43 handler]$ cp AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
5. Generate JAR Files use adadmin
=================================
cd 5216496
sh patch.sh
=================================
[applmgr@sys43 6iserver]$ cp p6195758_60827_GENERIC.zip $ORACLE_HOME
[applmgr@sys43 6iserver]$ unzip p6195758_60827_GENERIC.zip
Backup the Forms class files,
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv UICommon.class UICommon.class.bak
[applmgr@sys43 handler]$ cd $ORACLE_HOME/forms60/java/oracle/forms/handler/
[applmgr@sys43 handler]$ mv ComponentItem.class ComponentItem.class.bak
Inside folder 6195758 in step-2 has class files in oracle\forms\handler directory.
Copy this file into ORACLE_HOME/forms60/java/oracle/forms/handler
[applmgr@sys43 handler]$ cd $ORACLE_HOME/6195758/oracle/forms/handler
[applmgr@sys43 handler]$ cp UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
[applmgr@sys43 handler]$ cp ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
====================================
cd 5938515
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
========================================
cd 5753922
sh patch.sh
adrelink.sh force=y "fnd f60webmx"
=======================================
How to find forms version in patch set
$ORACLE_HOME/bin/f60gen help=y
Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)
Metalik id :125767.1
6.0.8.27.0 ===> Patch 18
Pre-Upgrade Step:
select banner from v$version;
SELECT product_group_id GroupID, product_group_name GroupName,release_name Release,product_group_type GroupType, argument1 FROM fnd_product_groups;
select count(*) from ad_bugs where bug_number = '5985992';
patch 4653225
Check the developer 6i Patch set.
Metalink Note 125767.1
Developer 6i patchset 18 (4948577)
How to Apply an 11i Patch When adpatch is Already Running
1. Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 "Tell worker to shutdown/quit"
2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema
a. sqlplus applsys/
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;
3. Backup the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS_back
as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
4. Backup the .rf9 files located in $APPL_TOP/admin/
At this point, the adpatch session should have ended and the cursor should
be back at the Unix prompt.
a. cd $APPL_TOP/admin/
b. mv restart restart_back
c. mkdir restart
5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;
6. Apply the new patch.
7. Restore the .rf9 files located in $APPL_TOP/admin/
directory.
a. cd $APPL_TOP/admin/
b. mv restart restart_
c. mv restart_back restart
8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema.
a. sqlplus applsys/
b. create table fnd_Install_processes
as select * from fnd_Install_processes_back;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;
9. Restore the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS
as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
10. Re-create synonyms
a. sqlplus apps/apps
b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;
11. Start adpatch, it will resume where it stopped previously.
Note:175485.1
PLS-00302: component 'IS_PATCH_APPLIED2' must be declared
while applying the patch 6502082
AutoPatch error:Error while executing statement
AutoPatch error:ORA-06550: line 3, column 10:
PLS-00302: component 'IS_PATCH_APPLIED2' must be declared
ORA-06550: line 3, column 1:PL/SQL: Statement ignored
AutoPatch error:--------adppdepIsPatchApplied() returned FALSE
See messages above for details.
Solutions
Go to Bellow path and compile the adphpchb.pls objects.
Connect Apps login
$AD_TOP/patch/115/sql/adphpchb.pls
After compile this objects, Then try to apply the patch.
AutoPatch error:Error while executing statement
AutoPatch error:ORA-06550: line 3, column 10:
PLS-00302: component 'IS_PATCH_APPLIED2' must be declared
ORA-06550: line 3, column 1:PL/SQL: Statement ignored
AutoPatch error:--------adppdepIsPatchApplied() returned FALSE
See messages above for details.
Solutions
Go to Bellow path and compile the adphpchb.pls objects.
Connect Apps login
$AD_TOP/patch/115/sql/adphpchb.pls
After compile this objects, Then try to apply the patch.
Subscribe to:
Posts (Atom)
