Oracle Release/Version Number for Apps/ Forms/ Jinitiator/ OID/ SSO/ Portal/ iAS/ OC4J/ Unix/ xxxx ….
OPatch Apply In database Level
OPatch is a Database patch.
Please download latest OPatch Tool and extract the RDBMS Oracle home.
1. Check the OPatch already installed or not
cd $ORACLE_HOME/OPatch
$opatch -lsinventory
This is command will show existing patch
Then Export the following environmet file
$ export ORACLE_HOME=/UAT/app/oracle
$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
$ export OBJECT_MODE=32_64
$ cd patch/
Extract the Following OPatch.
p5246372_10203_LINUX.zip
p5965763_10203_LINUX.zip
5246372
5965763
Then Go to patch Directory and apply the Opatch.
$ cd 5965763/
$ opatch apply
Reference:
OPatch documentation list
Doc ID: 293369.1
Please download latest OPatch Tool and extract the RDBMS Oracle home.
1. Check the OPatch already installed or not
cd $ORACLE_HOME/OPatch
$opatch -lsinventory
This is command will show existing patch
Then Export the following environmet file
$ export ORACLE_HOME=/UAT/app/oracle
$ export PATH=$PATH:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
$ export OBJECT_MODE=32_64
$ cd patch/
Extract the Following OPatch.
p5246372_10203_LINUX.zip
p5965763_10203_LINUX.zip
5246372
5965763
Then Go to patch Directory and apply the Opatch.
$ cd 5965763/
$ opatch apply
Reference:
OPatch documentation list
Doc ID: 293369.1
How to Change the System Name in Workflow
After Cloning required to change workflow system name.
Change the service name in TEST:
In apps node
SQL> select NAME from wf_systems;
NAME
--------
PROD.DOYENSYS.COM
SQL> select GUID from wf_systems;
GUID
--------------------------------
3CA4A184BD2C99FFE040500A1F033CD9
SQL> select NAME, SYSTEM_GUID from wf_agents;
Go to bellow path and run the following scripts txkWfClone.sh .
$ cd /TEST/apps/testcomn/admin/install/TEST_oratest2
$ sh txkWfClone.sh apps apps
txkWfClone.sh started at Mon Dec 29 03:49:05 EST 2008
The environment settings are as follows ...
apps_HOME : /TEST/apps/testora/8.0.6
apps_SID :
TWO_TASK : TEST_806_BALANCE
PATH : /TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testappl/fnd/11.5.0/bin:/TEST/apps/testappl/ad/11.5.0/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50::/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50:/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/applmgr/bin
LD_LIBRARY_PATH : /TEST/apps/testora/8.0.6/network/jre11/lib/i686/native_threads:/TEST/apps/testora/8.0.6/network/jre11/lib/linux/native_threads:/TEST/apps/testappl/cz/11.5.0/bin:/TEST/apps/testora/8.0.6/lib:/usr/X11R6/lib:/usr/openwin/lib
Executable : /TEST/apps/testora/8.0.6/bin/sqlplus
SQL*Plus: Release 8.0.6.0.0 - Production on Mon Dec 29 03:49:05 2008
(c) Copyright 1999 apps Corporation. All rights reserved.
Connected.
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from apps Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ERRORCODE = 0 ERRORCODE_END
After completing this scripts, now check againg the following query.
Now its changed the service name PROD to TEST.
SQL> show parameter service
NAME TYPE VALUE
---------------------------
service_names string TEST
SQL> select NAME from wf_systems;
NAME
------------------------------
TEST.DOYENSYS.COM
SQL> select GUID from wf_systems;
GUID
--------------------------------
5F2BB84D418D8F79E040500A0B02363F
SQL> select NAME, SYSTEM_GUID from wf_agents;
Refered Notes:
The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1
How to Change the System Name in Workflow?
Doc ID: 387337.1
Change the service name in TEST:
In apps node
SQL> select NAME from wf_systems;
NAME
--------
PROD.DOYENSYS.COM
SQL> select GUID from wf_systems;
GUID
--------------------------------
3CA4A184BD2C99FFE040500A1F033CD9
SQL> select NAME, SYSTEM_GUID from wf_agents;
Go to bellow path and run the following scripts txkWfClone.sh .
$ cd /TEST/apps/testcomn/admin/install/TEST_oratest2
$ sh txkWfClone.sh apps apps
txkWfClone.sh started at Mon Dec 29 03:49:05 EST 2008
The environment settings are as follows ...
apps_HOME : /TEST/apps/testora/8.0.6
apps_SID :
TWO_TASK : TEST_806_BALANCE
PATH : /TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testappl/fnd/11.5.0/bin:/TEST/apps/testappl/ad/11.5.0/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50::/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50:/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/applmgr/bin
LD_LIBRARY_PATH : /TEST/apps/testora/8.0.6/network/jre11/lib/i686/native_threads:/TEST/apps/testora/8.0.6/network/jre11/lib/linux/native_threads:/TEST/apps/testappl/cz/11.5.0/bin:/TEST/apps/testora/8.0.6/lib:/usr/X11R6/lib:/usr/openwin/lib
Executable : /TEST/apps/testora/8.0.6/bin/sqlplus
SQL*Plus: Release 8.0.6.0.0 - Production on Mon Dec 29 03:49:05 2008
(c) Copyright 1999 apps Corporation. All rights reserved.
Connected.
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from apps Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ERRORCODE = 0 ERRORCODE_END
After completing this scripts, now check againg the following query.
Now its changed the service name PROD to TEST.
SQL> show parameter service
NAME TYPE VALUE
---------------------------
service_names string TEST
SQL> select NAME from wf_systems;
NAME
------------------------------
TEST.DOYENSYS.COM
SQL> select GUID from wf_systems;
GUID
--------------------------------
5F2BB84D418D8F79E040500A0B02363F
SQL> select NAME, SYSTEM_GUID from wf_agents;
Refered Notes:
The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1
How to Change the System Name in Workflow?
Doc ID: 387337.1
O/S-Error: (OS 8) Not enough storage is available to process this command
After increasing SGA_TARGET=2GB, We got following Error Message.
SQL> startup
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command
C:\boot.ini old value
Old File:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect
Solutions:
Modified Boot.ini File:
Note: In the boot.ini file we changed following parameter /3GB and /PAE
After Changing that parameter, we can able to increase UPTO 2.7GB sga target.
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /PAE
SQL> startup
ORACLE instance started.
Total System Global Area 2726297600 bytes
Fixed Size 1254760 bytes
Variable Size 553650840 bytes
Database Buffers 2164260864 bytes
Redo Buffers 7131136 bytes
Database mounted.
Database opened.
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 2784M
sga_target big integer 2784M
Reference:
Note 225349.1 - Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms
Note 46053.1 - Windows NT Memory Architecture Overview
SQL> startup
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command
C:\boot.ini old value
Old File:
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect
Solutions:
Modified Boot.ini File:
Note: In the boot.ini file we changed following parameter /3GB and /PAE
After Changing that parameter, we can able to increase UPTO 2.7GB sga target.
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /3GB /PAE
SQL> startup
ORACLE instance started.
Total System Global Area 2726297600 bytes
Fixed Size 1254760 bytes
Variable Size 553650840 bytes
Database Buffers 2164260864 bytes
Redo Buffers 7131136 bytes
Database mounted.
Database opened.
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 2784M
sga_target big integer 2784M
Reference:
Note 225349.1 - Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms
Note 46053.1 - Windows NT Memory Architecture Overview
ORA-00439: feature not enabled: Real Application Clusters
SQL> startup
ORA-00439: feature not enabled: Real Application Clusters
Turn on RAC (In All nodes)
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_on
If this step did not work, please go ahead below step.
make -f ins_rdbms.mk ioracle
Then Change cluster_name=true, and try to startup the both database.
Metalink Note ID : 211177.1
ORA-00439: feature not enabled: Real Application Clusters
Turn on RAC (In All nodes)
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_on
If this step did not work, please go ahead below step.
make -f ins_rdbms.mk ioracle
Then Change cluster_name=true, and try to startup the both database.
Metalink Note ID : 211177.1
Subscribe to:
Posts (Atom)
