Oracle Technology Village

Oracle Recovery Manager (RMAN) Oracle Recovery Manager satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats. A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. Oracle Recovery Manager (RMAN), a command-line and Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering your Oracle database. RMAN is designed to work intimately with the server, providing block-level corruption detection during backup and restore. RMAN optimizes performance and space consumption during backup with file multiplexing and backup set compression, and integrates with Oracle Secure Backup and third party media management products for tape backup. RMAN takes care of all underlying database procedures before and after backup or restore, freeing dependency on OS and SQL*Plus scripts. It provides a common interface for backup tasks acr...

Upgrading Oracle Server 9.2.0.6 to 10.1.0.4 in an 11.5.10.2 Applications Environment This document describes the steps necessary to upgrade the Database from 9.2.06 to 10.1.0.4.  The steps were verified on a Linux installation of the Vision Demo.  This note should be used as a supplement to Note: 282038.1 and the 10.1.0 Migration Guide.  The most current version of this document is in Note: 359483.1 on OracleMetaLink. This document contains the following sections: · Before the Database Installation · Database Installation · Prepare to upgrade · Upgrade the Database · Adjust the Database Parameters · After the Database Upgrade · Implement and run Autoconfig on the new Database Home · Recreate custom database links (Conditional) · Recreate Grants and synonyms · Restart Applications · Related Documents  Before the Database Installation 1.  Shutdown the Database and all processes running out of the 9.2.0.6 Oracle Home and perform      a cold backup of the entire 9.2.0.6 Oracle Home. 2....

DB Link to Oracle 11g: Written by Paweł Barut As you know in Oracle 11g passwords are case sensitive by default. This applies to connecting via SQL*Plus or other client tools. And it also applies to database links between databases. So when you link from Oracle 10g to Oracle 11g create database link like this: CREATE DATABASE LINK my_link CONNECT TO remote_user IDENTIFIED BY "CaSe_SeNsItIvE_PaSsWoRd" USING 'TNS_ID_11G'; Do not forget to enclose password by double-quote marks! When you do not set password this way, you will be getting: ORA-01017: invalid username/password; logon denied. Hope this small tip will be useful for someone.

Difference between Oracle Applications Release 12 and 11i. 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- com...

Create and Setup Test Organization (Environment) in Introduction This paper is meant as a guide to create a test environment or organization to model a customer environment or setup. It can also be used as a guide when you are creating a new organization in a multiorg environment when Recievables has already been set up. What setup steps should be completed when creating a new organization? To answer this question you need to understand that Oracle Applications is created to be flexible for companies that need to create several organizations. In 10.7, the introduction of an application that is multiorg compatible introduced a new partitioned table structure using a column called org_id. This new table structure is identified by the table name, i.e., name ends with a “_ALL”. Tables with the _ALL ending will separate information between the organizations. The intent of this paper is to go through all the setup steps necessary to create a fully functioning new organization. Why would you ...