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-...

Querying V$ Views to Obtain Backup Information Before making a backup, you must identify all the files in your database and decide what to back up. Several V$ views can provide the necessary information. Listing Database Files Before a Backup select name from v$datafile union all select member from v$logfile union all select name from v$controlfile; Determining Datafile Status for Online Tablespace Backups You can check V$BACKUP views to determine datafile is part of backup or not. it is also usefull when you database startup after instance failure through this view you can know datafile is part of online backup when database is open. V$backup view is not useful when current controlfile is created from restored backup or RE-CREATE statment becuase it is not content information about backup datafile. Through below query we can know status of datafile backup status SELECT t.name AS "TB_NAME", d.file# as "DF#", d.name AS "DF_NAME", b.status FROM V$DATAFILE d,...

How to Enable ARCHIVELOG mode Benefits of ARCHIVELOG mode. 1. We can able to take database backup ONLINE. 2. No Need to Down Oracle DB Server 3. We can better Manage our Backup Policy through RMAN 4. Limited DBA task 5. We can able to RECOVER our database point-in-time How can enable ARCHIVELOG MODE in 9iR1. When we create new database then database is created NOARCHIVELOG mode by default. shutdown database SQL>shutdown immediate; Edit below parameters in pfile(init.ora) file. 1. LOG_ARCHIVE_START=TRUE Create New SPFILE from Modified pfile(init.ora) SQL> create SPFILE from PFILE; Startup Database in Mount Mode SQL> startup mount; Change Database log mode from NOARCHIVELOG to ARCHIVELOG SQL> alter database archivelog; Open DB for normal use SQL> alter database open; check archive log status Database log mode Archive Mode Automatic archival Enabled Archive destination C:\Oracle\product\...

Why I Choose Oracle as my Career ? Dear Friends, There are some question which asked frequently on forms from every oracle newbie. 1. Which Oracle Certification I choose ? Here I will explain in details. There types of Oracle Certification we can do. 1. Oracle DBA 2. Oracle Developer 3. Oracle Application DBA 1. Oracle DBA The person which maintain Oracle Database called Oracle Database Administrator. There are some frequent work for Oracle DBA 1. Database Backup Responsibity. 2. Database Performance Tunning 3. Database Basic Administration Like " user creation, database security" Above work is complete dedicated to Oracle DBA and every company which use Oracle Database they always need Oracle DBA. Certification: Oracle 9i http://dbataj.blogspot.com/2007/08/oracle-9i-certified-professional.html Certification: Oracle 10g http://dbataj.blogspot.com/2007/03/oracle-certified-professional.html2. Oracle Developer The person which create coding and design forms and report for front-...