Sanjay Forum

Upgrade Oracle database from 10.2.0.x to 10.2.0.4 Follow the simple steps to upgrade your database from 10.2.0.x to 10.2.0.4 Here are the Upgrade paths:- Upgrade 10.2.0.1. to 10.2.0.4 Upgrade 10.2.0.2. to 10.2.0.4 Upgrade 10.2.0.3. to 10.2.0.4 If you have updated your Oracle version then you must upgrade your database using any one of the below methods, otherwise you will get the following error during Database startup. ORA-01092: ORACLE instance terminated. ORA-39700: database must be opened with UPGRADE option 1. Database Upgrade assistant 2. Database Upgrade assistant in Noninteractive mode 3. Manual Upgrade Method 1. Upgrade Database using Database Upgrade assistant: Step 1: Set the ORACLE_HOME and ORACLE_SID and start DBUA $ ORACLE_SID=testdb; export ORACLE_SID $ ORACLE_HOME=/oracle/v10204; export ORACLE_HOME $ dbua Step 2: Follow the upgrade steps (i) Select the database that you want to upgrade (ii) On the Recompile Invalid Objects screen, select the Recompile the invalid object...

Oracle RAC load balancing and failover LOAD BALANCING: The Oracle RAC system can distribute the load over many nodes this feature called as load balancing. There are two methods of load balancing 1.Client load balancing 2.Server load balancing Client Load Balancing distributes new connections among Oracle RAC nodes so that no one server is overloaded with connection requests and it is configured at net service name level by providing multiple descriptions in a description list or multiple addresses in an address list. For example, if connection fails over to another node in case of failure, the client load balancing ensures that the redirected connections are distributed among the other nodes in the RAC. Configure Client-side connect-time load balancing by setting LOAD_BALANCE=ON in the corresponding client side TNS entry. TESTRAC = (DESCRIPTION = (ADDRESS_LIST= (LOAD_BALANCE = ON) (ADDRESS = (PROTOCOL = TCP)(HOST = TESTRAC1-VIP)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = TESTRA...

Database: Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2) Application Tier: Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports) Sub component in Application Tier A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19 B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j) C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12 D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12 E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12 F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* ) G) Java processes use JDK...

This is accomplished by the Shared APPL_TOP and Merging APPL_TOP features. In this post i am listing out the steps to perform a multi note to a single node cloning from scratch. The information mentioned here is the steps which i have used and found them to be successful for a more elaborate explanation you might want to refer to the metalink note Sharing the Application Tier File System in Oracle E-Business Suite 11i (233428.1). Source System here refers to the multi node system to be cloned Target System refers to the newly to be created single node system Applications Version 11.5.10 Operating System Linux ES 4 The following Steps are required to be performed on the source system 1. Apply application tier patches using adpatch Apply patch 4038964 Apply patch 4175764 Both the above patches are include in the consolidated update 2 or CU2 so in case you are on 11.5.10.2 or later you can ignore this step. 2. Maintain snapshot information Log in as the applications user on each applicati...

Disk space requirements: ------------------------ Application node(Fresh & Vision database)- 28GB Database node for Fresh database - 45GB Database node for Vision demo database - 133GB Stage area size - 33GB Total Space for fresh Install - 73GB Total Space for Vision - 161GB Operating System Name Supported Version --------------------- ------------------ Red Hat Enterprise Linux 4.0-Update 4/higher(32-bit) Kernel Requirements: -------------------- The following table lists the required minimum kernel versions. Operating System :RedHat Enterprise Linux AS/ES 4.0 Kernel Instructions:2.6.9-42.EL To determine version, $ uname - r Required Packages: ----------------- Check required rpms installed or not (Eg : rpm –q glibc-2.3.4-2.25 ) glibc-2.3.4-2.25 glibc-common-2.3.4-2.25 binutils-2.15.92.0.2-21 compat-libstdc++-296-2.96-132.7.2 gcc-3.4.6-3 gcc-c++-3.4.6-3 libgcc-3.4.6-3 libstdc++-3.4.6-3 libstdc++-devel-3.4.6-3 openmotif21-2.1.30-11.RHEL4.6 pdksh-5.2.14-30.3 setarch-1.6-1 make-3.80-...