Oracle eBusiness Suite Product and Acronym Listing

Couldn't find anything like this anywhere, so here we go!

Oracle eBusiness Suite / Applications Products with Acronyms and comparison of Release 11i and Release 12.

Acronym Product Release Notes

ABM Activity Based Management R11i, R12 Obsolete R12
AD Applications DBA R11i, R12
ADS Applications Demonstration Services R11i, R12
ADS_DEV ADS Development R11i, R12
ADX Rapid Install n/a Psuedo Product
AGIS Advanced Global Intercompany System R12 Sub-product of FUN
AHL Complex Maintenance Repair and Overhaul R11i, R12
AHM Hosting Manager R11i, R12 Obsolete R12
AK Common Modules-AK R11i, R12
ALR Alert R11i, R12
AME Approvals Management R11i, R12
AMF Fulfillment Services R11i, R12 Obsolete R12
AML Leads Management n/a Psuedo Product
AMS Marketing R11i, R12
AMV Marketing Encyclopedia System R11i, R12
AMW Internal Controls Manager R11i, R12
AN Sales Analysis R11i, R12
APPLCSF Applications Common Support/Script Files R11i, R12
AR Receivables R11i, R12
AS Sales Foundation R11i, R12
ASF Sales Online R11i, R12
ASG CRM Gateway for Mobile Devices R11i, R12
ASL Sales Offline R11i, R12
ASN Sales R11i, R12
ASO Order Capture R11i, R12
ASP Oracle Sales for Handhelds R11i, R12 Renamed from Field Sales/Palm Devices
AST TeleSales R11i, R12
ATG Applications Technology n/a Psuedo Product
AU Application Utilities R11i, R12
AX Global Accounting Engine R11i, R12 Obsolete R12
AZ Application Implementation R11i, R12
BEN Advanced Benefits R11i, R12
BIC Customer Intelligence R11i, R12 Obsolete R12
BIE eCommerce Intelligence R11i, R12
BIL Sales Intelligence R11i, R12
BIM Marketing Intelligence R11i, R12
BIN Communications Intelligence R11i, R12
BIS Applications BIS R11i, R12 AKA Business Intelligence
BIV Service Intelligence R11i, R12
BIX Interaction Center Intelligence R11i, R12
BIY Systems Intelligence R11i, R12
BLC Utility Billing R11i, R12
BNE Web Applications Desktop Integrator R11i, R12
BOM Bills of Material R11i, R12
BPA Bill Presentment Architecture n/a Psuedo Product
BSC Balanced Scorecard R11i, R12
CAC Common Application Calendar n/a Psuedo Product
CC Interaction Center n/a Psuedo Product
CCT Telephony Manager R11i, R12
CDR Oracle Clinical Data Repository R12 AKA Life Sciences Data Hub
CE Cash Management R11i, R12
CHV Supplier Scheduling R11i, R12
CLA APAC Consulting Localizations R12
CLE EMEA Consulting Localizations R12
CLJ Japan Consulting Localizations R12
CLL LAD Consulting Localizations R12
CLN Supply Chain Trading Connector for RosettaNet R11i, R12
CLR Culinary Application R11i, R12
CN Incentive Compensation R11i, R12
COM Communications n/a Psuedo Product
CPGC CPG - CDOA R11i, R12
CRP Capacity R11i, R12
CS Service R11i, R12
CSC Customer Care R11i, R12
CSD Depot Repair R11i, R12
CSE Asset Tracking R11i, R12 Renamed from Enterprise Install Base
CSF Field Service R11i, R12
CSI Install Base R11i, R12
CSK Knowledge Base n/a Psuedo Product
CSL Field Service/Laptop R11i, R12
CSM Field Service/Palm R11i, R12
CSN Call Center R12
CSP Spares Management R11i, R12
CSR Scheduler R11i, R12
CSS Support R11i, R12 Obsolete R12
CST Cost Management R11i, R12
CSZ Customer Support n/a Psuedo Product
CTB Clinical Transaction Base R11i, R12
CUA Capital Resource Logistics - Assets R11i, R12
CUC Revenue Accounting R11i, R12
CUE Billing Connect R11i, R12 Obsolete R12
CUF Capital Resource Logistics - Financials R11i, R12
CUG Citizen Interaction Center R11i, R12
CUI Network Logistics - Inventory R11i, R12
CUN Network Logistics - NATS R11i, R12 Obsolete R12
CUP Network Logistics - Purchasing R11i, R12
CUR Mass Market Receivables for Comms R11i, R12
CUS Network Logistics R11i, R12
CUSTOM Custom Development R11i, R12
CZ Configurator R11i, R12
DDD CADView-3D R11i, R12
DDR Demand Signal Repository R12.1
DEM Demo Order Entry (AOL Class) R11i, R12
DEM01 Team 01 Order Entry Demo R12
DMF Discrete Manufacturing n/a Psuedo Product
DNA Development R11i, R12
DOM Document Managment and Collaboration R11i, R12
DPP Price Protection n/a Psuedo Product
DT DateTrack R11i, R12
DUMMY_GMO Obsolete Process Operations R12
EAA SEM Exchange R11i, R12 Obsolete R12
EAM Enterprise Asset Management R11i, R12
EC e-Commerce Gateway R11i, R12
ECX XML Gateway R11i, R12
EDR E-Records R11i, R12
EDW Enterprise Data Warehouse n/a Psuedo Product
EGO Advanced Product Catalog R11i, R12
EMS Environment Management System R11i, R12
ENG Engineering R11i, R12
ENI Product Development Intelligence R11i, R12
EVM Value Based Management R11i, R12
EWS Enterprise Warehouse Source n/a Psuedo Product
EXCHG Exchange n/a Psuedo Product
FEM Enterprise Performance Foundation R11i, R12 Renamed from Strategic Enterprise Management
FF FastFormula R11i, R12
FII Financial Intelligence R11i, R12
FIN Financials n/a Psuedo Product
FLM Flow Manufacturing R11i, R12
FND Application Object Library, FND=FouNDation R11i, R12
FPA Project Portfolio Analysis R11i, R12 Renamed from Portfolio Analyzer
FPT Banking Center R11i, R12 Obsolete R12
FRM Report Manager R11i, R12
FTE Transportation Execution R11i, R12
FTP Transfer Pricing R11i, R12
FUN Financials Common Modules R12
FV Federal Financials R11i, R12
FWK Applications Framework n/a Psuedo Product
GCS Financial Consolidation Hub R11i, R12 Renamed from Global Consolidation System
GIS Global Intercompany System R11i
GHR US Federal Human Resources R11i, R12
GMA Process Manufacturing Systems R11i, R12
GMD Process Manufacturing Product Development R11i, R12
GME Process Manufacturing Process Execution R11i, R12
GMF Process Manufacturing Financials R11i, R12
GMI Process Manufacturing Inventory R11i, R12
GML Process Manufacturing Logistics R11i, R12
GMO Manufacturing Execution System for Process Manufacturing R12
GMP Process Manufacturing Process Planning R11i, R12
GMS Grants Accounting R11i, R12
GMW Process Manufacturing Portal R11i, R12
GNI Genealogy Intelligence R11i, R12
GR Process Manufacturing Regulatory Management R11i, R12
HC Healthcare n/a Psuedo Product
HCA Healthcare R11i, R12
HCC iHCConnect R11i, R12
HCN iHCIntegrate R11i, R12
HCP Healthcare Intelligence R11i, R12 Renamed from Healthcare Portal
HCT Healthcare Terminology Server R11i, R12
HR Human Resources n/a Psuedo Product
HRI Human Resources Intelligence R11i, R12
HXC Time and Labor Engine R11i, R12
HXT Time and Labor R11i, R12
HZ Trading Community n/a Psuedo Product
IA iAssets R11i, R12
IAM Digital Asset Management R11i, R12
IBA iMarketing R11i, R12 Obsolete R12
IBC Content Manager R11i, R12
IBE iStore R11i, R12
IBP Bill Presentment & Payment R11i, R12
IBT iAuction R11i, R12
IBU iSupport R11i, R12
IBW Oracle Web Analytics R12
IBY Payments R11i, R12 Renamed from iPayments
ICX Oracle iProcurement R11i, R12 Renamed from Self_Service Web Applications
IEB Interaction Blending R11i, R12
IEC Advanced Outbound Telephony R11i, R12
IEM Email Center R11i, R12
IEO Interaction Center Technology R11i, R12
IEP Predictive R11i, R12
IES Scripting R11i, R12
IET Call Center Connectors R11i, R12
IEU Universal Work Queue R11i, R12
IEV IVR Integrator R11i, R12
IEX Collections R11i, R12
IGC Contract Commitment R11i, R12
IGF Financial Aid R11i, R12
IGI Public Sector Financials International R11i, R12
IGP Personal Portfolio n/a Psuedo Product
IGR Student Recruiting n/a Psuedo Product
IGS Student System R11i, R12 Renamed from Student Systems
IGW Grants Proposal R11i, R12
IMC Customers Online R11i, R12
IMT iMeeting R11i, R12 Obsolete R12
INV Inventory R11i, R12
INL Oracle Landed Cost Management R12.1
IPA Capital Resource Logistics - Projects R11i, R12
IPATCH Oracle.com iPatch n/a Psuedo Product
IPD Product Development R11i, R12 Obsolete R12
IPM Oracle Imaging Process Management R12
IRC iRecruitment R12
ISC Supply Chain Intelligence R11i, R12
ISX iSettlement R11i, R12
ITA Information Technology Audit R12
ITG Internet Procurement Enterprise Connector R11i, R12
ITM Item Master n/a Psuedo Product
IZU Diagnostics n/a Psuedo Product
JA Asia/Pacific Localizations R11i, R12
JAI Financials for India n/a Psuedo Product
JE European Localizations R11i, R12
JG Regional Localizations R11i, R12
JL Latin America Localizations R11i, R12
JMF Supply Chain Localizations R12
JTA CRM Applications Foundation n/a Psuedo Product
JTF CRM Foundation R11i, R12
JTH Interaction History n/a Psuedo Product
JTM Mobile Application Foundation R11i, R12
JTO One-to-one Fulfillment n/a Psuedo Product
JTS CRM Self Service Administration R11i, R12
JTT CRM Technology Foundation n/a Psuedo Product
JTU CRM Utilities n/a Psuedo Product
JTY Territories n/a Psuedo Product
LNS Loans R11i, R12
MAS Marketing and Sales n/a Psuedo Product
ME Controlled Availability Product R11i, R12 Obsolete R12
MFG Manufacturing R11i, R12
MIA Mobile Applications for Inventory Management R11i, R12
MIV Media Interactive R11i, R12
MKT Marketing n/a Psuedo Product
MQA Mobile Quality Applications R11i, R12
MRP Master Scheduling/MRP R11i, R12
MSC Advanced Supply Chain Planning R11i, R12
MSD Demand Planning R11i, R12
MSE Manufacturing Development Operations n/a Psuedo Product
MSO Constraint Based Optimization R11i, R12
MSR Inventory Optimization R11i, R12
MST Transportation Planning R11i, R12
MSX Supply Chain Exchange n/a Psuedo Product
MTH Manufacturing Development Operations n/a Psuedo Product
MWA Mobile Applications R11i, R12
OAM Oracle Applications Manager R11i, R12
OCM Credit Management n/a Psuedo Product
ODQ Data Query R11i, R12
OE Order Entry R11i, R12
OFA Assets R11i, R12 AKA FA
OIE iExpenses n/a Psuedo Product
OIR iReceivables n/a Psuedo Product
OIT Internet Time n/a Psuedo Product
OK Contracts Suite n/a Psuedo Product
OKB Contracts for Subscriptions R11i, R12 Obsolete R12
OKC Contracts Core R11i, R12
OKE Project Contracts R11i, R12
OKI Contracts Intelligence R11i, R12
OKL Lease Management R11i, R12
OKO Contracts for Sales R11i, R12 Obsolete R12
OKP Contracts for Procurement R11i, R12 Obsolete R12
OKR Contracts for Rights R11i, R12 Obsolete R12
OKS Service Contracts R11i, R12
OKT Royalty Management R11i, R12
OKX Contracts Integration R11i, R12
OM Order Management n/a Psuedo Product
ONT Order Management R11i, R12
OPI Operations Intelligence R11i, R12
OPM Process Manufacturing n/a Psuedo Product
OTA Learning Management R11i, R12
OUC University Curriculum R12
OWF Workflow n/a Psuedo Product
OZF Trade Management R11i, R12
OZP Trade Planning R11i, R12 Obsolete R12
OZS iClaims R11i, R12 Obsolete R12
PA Projects R11i, R12
PAY Payroll R11i, R12
PBR Budgeting and Planning R11i, R12
PER Human Resources R11i, R12
PFT Oracle Profitability Manager R11i, R12 Renamed from Performance Analyzer
PJ Projects n/a Psuedo Product
PJB Project Billing R11i, R12 Psuedo Product
PJC Project Costing R11i, R12 Psuedo Product
PJF Project Foundation R11i, R12 Psuedo Product
PJI Project Intelligence R11i, R12
PJL Project Collaboration R11i, R12 Psuedo Product
PJM Project Manufacturing R11i, R12
PJR Project Resource Management R11i, R12 Psuedo Product
PJT Project Management R11i, R12 Psuedo Product
PLM Product Lifecycle Management n/a Psuedo Product
PMI Process Manufacturing Intelligence R11i, R12
PN Property Manager R11i, R12
PO Purchasing R11i, R12
POA Purchasing Intelligence R11i, R12
POM Exchange R11i, R12
PON Sourcing R11i, R12
POS iSupplier Portal R11i, R12
POV Exchange Marketplace - Core n/a Psuedo Product
PQH Public Sector HR R11i, R12
PQP Public Sector Payroll R11i, R12
PRC Process Connect n/a Psuedo Product
PRGC Progress Custom R11i, R12
PRP Proposals R11i, R12
PSA Public Sector Financials R11i, R12
PSB Public Sector Budgeting R11i, R12
PSP Labor Distribution R11i, R12
PSR Public Sector Receivables R12
PTX Patch Tracking System R11i, R12
PV Partner Management R11i, R12
QA Quality R11i, R12
QOT Quoting R11i, R12
QP Advanced Pricing R11i, R12
QPR Oracle Deal Management R12.1
QRM Risk Management R11i, R12
RCI Regulatory Compliance Intelligence n/a Psuedo Product
RCM Regulatory Capital Manager R11i, R12 Obsolete R12
RG Application Report Generator R11i, R12
RHX Advanced Planning Foundation R11i, R12 Obsolete R12
RLA Release Management Integration Kit R11i, R12 Obsolete R12
RLM Release Management R11i, R12
RMG Risk Manager R11i, R12
RRC Retail Core R12
RRS Site Management R12
SCM Supply Chain Management n/a Psuedo Product
SCP Advanced Planning n/a Psuedo Product
SEM Financials Services Applications n/a Psuedo Product
SHT Applications Shared Technology R11i, R12
SLS Sales Suite n/a Psuedo Product
SQLAP Payables R11i, R12 AKA AP
SQLGL General Ledger R11i, R12 AKA GL
SRV Service Suite n/a Psuedo Product
SSP HRMS (UK) R11i, R12
SYSADMIN System Administration R11i, R12
TXK Teckstack n/a Psuedo Product
UMX User Management n/a Psuedo Product
UNV Student System n/a Psuedo Product
VEA Automotive R11i, R12
VEH Automotive Integration Kit R11i, R12 Obsolete R12
WIP Work in Process R11i, R12
WMA Manufacturing Mobile Applications R11i, R12
WMS Warehouse Management R11i, R12
WPS Manufacturing Scheduling R11i, R12
WSH Shipping Execution R11i, R12
WSM Shop Floor Management R11i, R12
XBOL Business Online R11i, R12
XDO XML Publisher / BI Publisher, XDO=eXtended Document Object R11i, R12
XDP Provisioning R11i, R12
XLA Subledger Accounting R12
XLE Legal Entity Configurator R12
XNA Service Assurance for Communications R11i, R12
XNB Oracle Telecommunications Billing Integrator R11i, R12 Renamed from eBusiness Billing
XNC Sales for Communications R11i, R12 Obsolete R12
XNI Install Base Intelligence R11i, R12 Obsolete R12
XNM Marketing for Communications R11i, R12 Obsolete R12
XNP Number Portability R11i, R12
XNS Service for Communications R11i, R12 Obsolete R12
XNT TeleBusiness for Telecom/Utilities R11i, R12
XTR Treasury R11i, R12
XXV8 Virtuate R11i, R12
ZFA Financial Analyzer R11i, R12
ZPB Enterprise Planning and Budgeting R11i, R12
ZSA Sales Analyzer R11i, R12
ZX E-Business Tax R12

Duplicate a Database Using RMAN

create duplicate database using rman

You want to use RMAN to create a duplicate database on the same server by using RMAN backups.

My Source Database Name is MYTEST

Target (duplicate) Database name is MYDB

Step 1: Configure Listener.ora and tnsnames.ora files

tnsnames.ora file

MYTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mytest)
)
)

MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydb)
)
)

listener.ora file

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mytest)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = mytest)
)
(SID_DESC =
(GLOBAL_DBNAME= mydb)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = mydb)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)

Step 2: create pfile for target database from source database

SQL> create pfile from spfile;

File created.

Step 3: modified parameter file for target database (duplicate) here log_file_name_convert and db_file_name_convert and control file location is important, further your choice.

*.audit_file_dest=’/home/oracle/oracle/product/10.2.0/db_1/admin/mydb/adump’
*.compatible=’10.2.0.1.0′
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_name=’mydb’
*.control_files=’/home/oracle/oracle/product/10.2.0/oradata/mydb/control01.ctl’,'/home/oracle/oracle/product/10.2.0/oradata/mydb/control02.ctl’,'/home/oracle/oracle/product/10.2.0/oradata/mydb/control03.ctl’
*.db_file_name_convert=’/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest’,'/home/oracle/oracle/product/10.2.0/oradata/mydb’
*.log_file_name_convert=’/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest’,'/home/oracle/oracle/product/10.2.0/oradata/mydb’
*.db_recovery_file_dest=’/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area’
*.db_recovery_file_dest_size=2147483648
*.dispatchers=’(PROTOCOL=TCP) (SERVICE=mydbXDB)’
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile=’EXCLUSIVE’
*.sga_target=285212672
*.undo_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′

Step 4: Create password file

[oracle@localhost ~]$orapwd file=orapwmydb password=oracle entries=5

Step 5: start your target database nomount stage

[oracle@localhost ~]$ export ORACLE_SID=mydb
[oracle@localhost ~]$ rlwrap sqlplus

SQL*Plus: Release 10.2.0.1.0 – Production on Tue May 25 18:22:09 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: sys/oracle@mydb as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL> startup nomount pfile=/home/oracle/oracle/product/10.2.0/db_1/dbs/initmydb.ora
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
SQL> exit

Step 6: From source database

SQL> alter system switch logfile;

System altered.

SQL>

Step 7: Backup database and archivelog Source database

[oracle@localhost root]$ rlwrap rman target sys/azar@mytest

Recovery Manager: Release 10.2.0.1.0 – Production on Tue May 25 19:56:10 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: MYTEST (DBID=2419076664)

RMAN> backup database plus archivelog;

Starting backup at 25-MAY-10
current log archived

input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest/system01.dbf
input datafile fno=00003 name=/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest/sysaux01.dbf
input datafile fno=00002 name=/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oracle/product/10.2.0/db_1/oradata/mytest/users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-MAY-10
channel ORA_DISK_1: finished piece 1 at 25-MAY-10

(skipped)

Starting Control File and SPFILE Autobackup at 25-MAY-10
piece handle=/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/MYTEST/autobackup/2010_05_25/o1_mf_s_719956316_5zr01f85_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 25-MAY-10

Step 8: Connect auxiliary database

RMAN> connect auxiliary sys/oracle@mydb;

connected to auxiliary database: MYDB (not mounted)

Step 9: Create duplicate database.

RMAN> duplicate target database to mydb;

Starting Duplicate Db at 25-MAY-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
set until scn 470310;
set newname for datafile 1 to
“/home/oracle/oracle/product/10.2.0/oradata/mydb/system01.dbf”;
set newname for datafile 2 to
“/home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf”;
set newname for datafile 3 to
“/home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf”;
set newname for datafile 4 to
“/home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf”;
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 25-MAY-10
using channel ORA_AUX_DISK_1

skipping datafile 1; already restored to file /home/oracle/oracle/product/10.2.0/oradata/mydb/system01.dbf
skipping datafile 2; already restored to file /home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf
skipping datafile 3; already restored to file /home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf
skipping datafile 4; already restored to file /home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 25-MAY-10
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “MYDB” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo01.log’ ) SIZE 50 M REUSE,
GROUP 2 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo02.log’ ) SIZE 50 M REUSE,
GROUP 3 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo03.log’ ) SIZE 50 M REUSE
DATAFILE
‘/home/oracle/oracle/product/10.2.0/oradata/mydb/system01.dbf’
CHARACTER SET WE8ISO8859P1

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=719956582 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=719956582 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=719956582 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf

contents of Memory Script:
{
set until scn 470310;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 25-MAY-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

starting media recovery

archive log thread 1 sequence 9 is already on disk as file /home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/MYTEST/archivelog/2010_05_25/o1_mf_1_9_5zr01bl8_.arc
archive log filename=/home/oracle/oracle/product/10.2.0/db_1/flash_recovery_area/MYTEST/archivelog/2010_05_25/o1_mf_1_9_5zr01bl8_.arc thread=1 sequence=9
media recovery complete, elapsed time: 00:00:02
Finished recover at 25-MAY-10

contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “MYDB” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo01.log’ ) SIZE 50 M REUSE,
GROUP 2 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo02.log’ ) SIZE 50 M REUSE,
GROUP 3 ( ‘/home/oracle/oracle/product/10.2.0/oradata/mydb/redo03.log’ ) SIZE 50 M REUSE
DATAFILE
‘/home/oracle/oracle/product/10.2.0/oradata/mydb/system01.dbf’
CHARACTER SET WE8ISO8859P1

contents of Memory Script:
{
set newname for tempfile 1 to
“/home/oracle/oracle/product/10.2.0/oradata/mydb/temp01.dbf”;
switch clone tempfile all;
catalog clone datafilecopy “/home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf”;
catalog clone datafilecopy “/home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf”;
catalog clone datafilecopy “/home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf”;
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /home/oracle/oracle/product/10.2.0/oradata/mydb/temp01.dbf in control file

cataloged datafile copy
datafile copy filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf recid=1 stamp=719956593

cataloged datafile copy
datafile copy filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf recid=2 stamp=719956593

cataloged datafile copy
datafile copy filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf recid=3 stamp=719956593

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=719956593 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=719956593 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=719956593 filename=/home/oracle/oracle/product/10.2.0/oradata/mydb/users01.dbf

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 25-MAY-10

RMAN>

Step 10: My duplicate database succesfully created.

Enter user-name: sys/oracle@mydb as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL> select status from v$instance;

STATUS
————
OPEN

SQL> select name from V$database;

NAME
———
MYDB

SQL>

Cloning Oracle Database - Cold Cloning, Hot Cloning

Cloning Oracle Database - Cold Cloning, Hot Cloning

Clone an Oracle Database using Cold Physical Backup
Database Name: troy Source Database side: (Troy database) Cold Backup

Steps: 1. Get the file path information using below query

Select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;

2. Parameter file backup If troy database running on spfile

Create pfile=’/u01/backup/inittroy.ora’ from spfile;
If database running in pfile using os command to copy the pfile and placed in backup path.

3.Taken the control file backup Alter database backup controlfile to trace as ‘/u01/backup/control01.ora’;

4.Shutdown immediate

5.Copy all the data files/log files using os command & placed in backup path.

6.Startup the database.

Clone Database side: (Clone database) Database Name: Clone

Clone Database Steps:

1.Create the appropriate folder in corresponding path & placed the backup files in corresponding folder.(bdump,udump,create,pfile,cdump,oradata)

2.Change the init.ora parameter like control file path, dbname, instance name etc...

3.Create the password file using orapwd utility. (Database in windows we need to create the service id using oradim utility)

4.Startup the Database in NOMOUNT stage.

5.Create the control file for cloning database.

Using backup controlfile trace to generate the create controlfile scripts.

Change the Database name & files path, also change 'REUSE' needs to be changed to 'SET'.

CREATE CONTROLFILE SET DATABASE "clone" RESETLOGS FORCE LOGGING NOARCHIVELOG MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 '/U01/oradata/clone/redo01.log' SIZE 200M, GROUP 2 '/U01/oradata/clone/redo02.log' SIZE 200M, GROUP 3 '/U01/oradata/clone/redo03.log' SIZE 200M DATAFILE '/U01/oradata/clone/system01.dbf', '/U01/oradata/clone/undotbs01.dbf', '/U01/oradata/clone/users01.dbf', CHARACTER SET WE8ISO8859P1; Note: placed the script in sql prompt. Now controlfile created. 6.Now open the database. Alter database open resetlogs; Note: Check the logfile, datafiles & instance status **********************************************************************************
Clone an Oracle Database using Hot Physical Backup

Database Name: troy Database must be in Archive log mode.

Source Database side: (Troy database)

Hot Backup Steps:

1.Get the file path information using below query.

Select tablespace_name, file_name from dba_data_files order by 1;

2. Parameter file backup
If troy database running on spfile Create pfile

Create file=’/u01/backup/inittroy.ora’ from spfile;

If database running in pfile using os command to copy the pfile and placed in backup path.

3.Put the tablespace in begin backup mode Using os command to copy the datafiles belongs to begin backup mode tablespace & placed in backup path. (Refer below example)

4.Once copied the datafile, release the tablespace from begin backup mode to end backup

5.Repeat the steps 1-3 for all your tablespaces.

6.Taken the controlfile backup
Alter database backup controlfile to trace as ‘/u01/backup/control01.ora’;

7.Backup all your archive log files between the previous backup and the new backup as well.

Example: steps: 2.Alter tablespace system begin backup;

To ensure the begin backup mode tablespace using below query

Select * from v$backup; (refer the Change#, Time column)

3. Host cp /u01/oracle/raja/system1.DBF /u01/backup/system01.dbf à using os command to copy the datafile.

4. Alter tablespace system end backup;

To ensure the begin backup mode tablespace using below query

Select * from v$backup; Clone Database side: (Clone database)

Database Name: Clone

Clone Database Steps:

1.Create the appropriate folder in corresponding path & placed the backup files in corresponding folder.(bdump,udump,create,pfile,cdump,oradata)

2.Change the init.ora parameter like control file path, dbname, instance name etc...

3.Create the password file using orapwd utility.Database in windows we need to create the service id using oradim utility)

4.Startup the Database in NOMOUNT stage.

5.Create the control file for cloning database. Using backup controlfile trace to generate the create controlfile scripts. Change the Database name & files path, also change 'REUSE' needs to be changed to 'SET'.

CREATE CONTROLFILE SET DATABASE "clone" RESETLOGS FORCE LOGGING NOARCHIVELOG MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 453 LOGFILE GROUP 1 '/U01/oradata/clone/redo01.log' SIZE 200M, GROUP
2 '/U01/oradata/clone/redo02.log' SIZE 200M, GROUP 3 '/U01/oradata/clone/redo03.log' SIZE 200M DATAFILE '/U01/oradata/clone/system01.dbf', '/U01/oradata/clone/undotbs01.dbf', '/U01/oradata/clone/users01.dbf', CHARACTER SET WE8ISO8859P1;

Note: placed the script in sql prompt. Now controlfile created.

6.Recover the database using controlfile.

Recover database using backup controlfile until cancel;

7.Now open the database. Alter database open resetlogs;

Note: Check the logfile, datafiles status.

Check Versions of Oracle Applications Components

Check Versions of Oracle Applications Components

Help-> About Oracle Applications from any of the forms sessions.

Or

Connect as apps user
select release_name from apps.fnd_product_Groups;

Version of Applications Forms (fmb,fmx) or reports (rdf)

To find the version of any oracle applications files
strings -a ICQTYED.fmx | grep Header

Alternatively you can also use the adident command
adident Header ICQTYED.fmx

Version of a Java class File
To find the version of a java class file
$ strings | grep '$Header'

Version of JDBC

In your middle tier, edit the jserv.properties file located in the iAS_ ORACLE_HOME/Apache/Jserv/etc directory
Locate the wrapper.classpath that is pointing to the jdbc zip file
/d01/oracle/viscomn/java/jdbc14.zip

Or
http://.:port/OA_HTML/jsp/fnd/aoljtest.jsp
Look for String ” JDBC driver version” under Connection String


Version of Apache
Go to the $iAS/Apache/Apache/bin directory and enter the following command:
$ httpd -version

Version Of The OA Framework
To find out the version of your Oracle appplication Framework
Option 1
http://.:port/OA_HTML/OAInfo.jsp

Option 2
adident Header %FND_TOP%/html/OA.jsp
adident Header %OA_HTML%/OA.jsp

Note: OA.jsp should be of the same version in both the places


Version of Application Product or Patch Set Level.

One of the most common things you will asked by your support engineer is the version or commonly known as the patch set level of your Oracle Applications product, while or after raising your service request. You can query this by logging on to your application database as the apps user.

select patch_level from fnd_product_installations where patch_level like '%AD%';
Version of Discoverer
cd $APPL_TOP/admin
grep -I s_disco_ver_comma **xml

Version of OJSP

Log in to the application server as the applmgr user
cd $OA_HTML
edit the jtflogin.jsp file to add the following line
OJSP Version: <%= application.getAttribute("oracle.jsp.versionNumber") %>
clear your cache and bounce your apache server
soruce the jtflogin.jsp from your browser

http://[your web server]:[your port]/OA_HTML/jtflogin.jsp
OJSP Version: 1.1.3.5.2


Version of JSP
Log on to your HTTP Server node, and change to the OA_HTML directory.
Using a text editor, create a file called test.jsp with only the following line:
<%= application.getAttribute("oracle.jsp.versionNumber") %>

Access this JSP from a web browser, using the URL:
http://[your web server]:[your port]/OA_HTML/test.jsp

Version of Portal
select fnd_oracle_schema.getouvalue(’PORTAL’) from dual;

FND_ORACLE_SCHEMA.GETOUVALUE(’PORTAL’)
——————————————————————————–
PORTAL30 <= to retrieve the portal user select version from PORTAL30.wwc_version$; VERSION ——————————————————————————– 3.0.9.8.1 or begin execute immediate 'select fnd_oracle_schema.getouvalue(''PORTAL'') from dual' into portal_user; begin execute immediate 'select user_name from fnd_user where user_name like upper('''||portal_user||''')' into portal_user_name; if portal_user is not null then execute immediate 'select version from '||portal_user||'.wwc_version$' into portal_ver; check_message := ' [PASS] Your Applications database contains Portal version: '||portal_ver; dbms_output.put_line(check_message); end if; exception when no_data_found then null; end; exception when others then null ; end; Version of XML Parser You can find out the version of your XML Parser using the following query SQL> select WF_EVENT_XML.XMLVersion() XML_VERSION
2 from sys.dual;
XML_VERSION
--------------------------------------------------------------------------------
Oracle XDK Java 9.0.4.0.0 Production

Version of XML Publisher

To check weather XML publisher is installed or not you can query the FND_PRODUCT_INSTALLATIONS table or you can lookup the
reports in Oracle Applications Manager. You can find out the version for your XML publisher from the output of your report or from MetaInfo.class file.

$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class.

Version of WorkFlow

You can find out the version of your workflow using the following query
SQL> select TEXT Version from WF_RESOURCES
2 where TYPE = 'WFTKN' and NAME = 'WF_VERSION';
VERSION
--------------------------------------------------------------------------------
2.6.0

Version of Oracle Login Server

begin
execute immediate 'select fnd_oracle_schema.getouvalue(''LOGINSERVER'') from
dual' into sso_user;
begin
execute immediate 'select user_name from fnd_user where user_name like
upper('''||sso_user||''')' into
sso_user_name;
if sso_user is not null then
execute immediate 'select version from '||sso_user||'.wwc_version$' into
sso_ver;
check_message := ' [PASS] Your Applications database contains Login
Server version: '||sso_ver;
dbms_output.put_line(check_message);
end if;
exception
when no_data_found then
null;
end;
exception
when others then
null ;
end;

Windows 7 Activation Crack 100% Working in all Laptops

Windows 7 Activation Crack Bypasses Windows Activation Technologies (WAT)
by Hemanth ERP (Enterprise Resource Planning) DBA

Microsoft has been trying to minimize the impact of piracy of their software by introducing new activation technologies. With the introduction of Windows 7, it became compulsory for users to activate their installation. However, hackers have been able to circumnavigate Microsoft lockdowns in the past and continue to do so.



A new software called Windows 7 loader claims to provide a Windows 7 Activation Crack to bypass the Windows Activation Technologies (WAT) which requires users to activate their copies after a trial period.

Though the new Windows Activation Crack is still untested, it claims to be able to crack even Windows 7 Service Pack 1. However, Microsoft still has time to release the SP1 to users and the new WAT might kill the new Windows 7 Activation hacks too.

Step by step approach to Activate your windows 7 on 32/64 bit Architechture

Step 1: Copy and Paste the below Mentioned URL in your browser
http://www.mediafire.com/?v8tk4hw3hz5j333#1

Step 2: Download the exe File and save this to your computer

Step 3: Execute the loader setup file on your PC.

Step 4: After the installation click RESTART button

Step 5: The final step is restarting your system.

Now the Windows 7 Activated.! Enjoy !

To ensure this Windows 7 Activation

* Go to my computer icon and right click
* Then select the Properties menu from the popup.



Note : Turn off your Windows Automatic updates.
Turn off your Windows Defender.

RMAN CLONING

RMAN CLONING
Applies to:
Oracle Server - Enterprise Edition - Version: 9.0.1.4 to 11.2.0.0
Information in this document applies to any platform.
Checked for relevance on 06-AUG-2009

Goal
The following note will guide a user in creating a duplicate database on a new host (non ASM). The scenario refers to a recovery catalog however a catalog is not mandatory. The following example has been completed on a linux operating system.

The note is applicable for 9i, 10g and 11g. However 11g has new features related to the DUPLICATE.
See for more details on the 11g DUPLICATE new features : Note 452868.1 RMAN 'Duplicate Database' Feature in 11G

Solution
Duplicate database from server A to server B (Non ASM)

Assumed database names:
Primary Database SID: PROD
Duplicate Database SID: AUX
RMAN Catalog SID: RMAN

====================================================================================
Steps

1. Backup the primary database.

2. Determine how much disk space will be required.

3. Ensuring you have enough space on your target server.

4. Making the backup available for the duplicate process.

5. Creating the init.ora & administration directories for the duplicate database.

6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.

7. Prepare RMAN duplicate script.

8. Execute the RMAN script.

=====================================================================================



1. Backup of the primary database.

Host A (Target)

Prior to creating a duplicate database you must have a backup of the target database. In this example we assume the backup media is disk. Find appropriate disk space on host A and take a full backup including archive logs and current controlfile (Figure 1a). If you are planning to duplicate a subset of the database refer to (Figure 1b) this illustrates the RMAN command to backing up certain tablespaces.


[oracle@linux] export ORACLE_SID=PROD

[oracle@linux] rman target=/ catalog=rman/rman@RMAN

RMAN> run {
allocate channel d1 type disk;
backup format '/backups/PROD/df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format '/backups/PROD/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
Figure 1a - This command will perform a full database backup including archivelogs and the current controlfile.


[oracle@linux] export ORACLE_SID=PROD

[oracle@linux] rman target=/ catalog=rman/rman@RMAN

RMAN> run {
allocate channel d1 type disk;
backup format '/backups/PROD/df_t%t_s%s_p%p'
tablespace SYSTEM, SYSAUX, UNDO, USERS;
sql 'alter system archive log current';
backup format '/backups/PROD/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
Figure 1b- This command will perform a tablespace backup ( SYSTEM, SYSAUX, UNDO & USERS) including archive logs and the current controlfile.


2. Determine how much disk space will be required.

Host A(Target) -

After deciding what you will be duplicating, calculate the entire space this will require on the new host. The full database calculation (Figure 2a) will calculate the entire space required whereas (figure 2b) allows you to enter the tablespace names in order to calculate the space required. Figure 2c provides a sample output.

Note: sql valid for version 10g only.
SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb"
from dual,
(select sum(a.bytes) TOTAL from dba_data_files a) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL; Figure 2a - Calculate total space for all datafiles within database.

SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb" from dual,
(select sum(a.bytes) TOTAL from dba_data_files a
where tablespace_name in('SYSTEM','UNDOTBS1', 'SYSAUX', 'USERS')) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL; Figure 2b - Calculate space for list of tablespaces within primary database.

DataFile Size Mb Redo Log Size Mb Control File Size Mb Total Size Mb
---------------- ---------------- -------------------- -------------
900 150 20.34375 1070.34375 Figure 2c - Sample output of space calculation.


3. Ensuring you have enough space on your target server.

Host B (Aux)

Prior to starting the duplicate process you must ensure you have enough disk space within file system to hold the database.

[oracle@linux] df -kh
Filesystem Size Used Avail Use% Mounted on
/dev/vg01/root 9.9G 2.8G 6.6G 30% /
/dev/sda1 145M 16M 122M 12% /boot
none 999M 0 999M 0% /dev/shm
/dev/vg01/tmp 2.0G 383M 1.5G 20% /tmp
/dev/vg01/u01 20G 12G 7.0G 62% /u01
/dev/vg01/u02 4.9G 1010M 3.6G 22% /u02
/dev/vg01/backups 5.9G 1.2G 4.4G 22% /backups
/dev/vg01/oradata 15G 13G 2.0G 87% /oradata Figure 3a - Sample output showing the space available on your filesystem.

Compare the results received from this query with the output from 2a or 2b and ensure you have enough diskspace for your duplicate database.



4. Making the backup available for the duplicate process.

If your backup resides on disk you will need to copy this back up from host A to host B. Ensure you place it in the same directory as where it was created. In the example below (figure 4a) the backup piece resides in ‘/backups/PROD’ these files need to be copied into the same directory on host B.

Furthermore also ensure than all archive log backups have also been moved and any archive logs in the archive log directory that may be require for the recovery. The archive logs required will depend on the point in time of the recovery.

RMAN> list backup;

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
22 Full 529M DISK 00:00:51 2006/05/16 11:12:54
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20060516T111203
Piece Name: /backups/PROD/df_t590584323_s23_p1
List of Datafiles in backup set 22
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1393845 2006/05/16 11:12:03 /oradata/PROD/system01.dbf
2 Full 1393845 2006/05/16 11:12:03 /oradata/PROD/undotbs01.dbf
3 Full 1393845 2006/05/16 11:12:03 /oradata/PROD/sysaux01.dbf
4 Full 1393845 2006/05/16 11:12:03 /oradata/PROD/users01.dbf


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
24 48M DISK 00:00:06 2006/05/16 11:13:07
BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20060516T111301
Piece Name: /backups/PROD/al_t590584381_s25_p1

List of Archived Logs in backup set 24
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 78 1344750 2006/05/15 04:55:34 1353208 2006/05/15 10:00:19
1 79 1353208 2006/05/15 10:00:19 1353213 2006/05/15 10:00:20
1 80 1353213 2006/05/15 10:00:20 1371564 2006/05/15 22:00:11
1 81 1371564 2006/05/15 22:00:11 1373291 2006/05/15 22:00:59
1 82 1373291 2006/05/15 22:00:59 1381066 2006/05/16 03:00:05
1 83 1381066 2006/05/16 03:00:05 1390685 2006/05/16 09:03:00
1 84 1390685 2006/05/16 09:03:00 1393870 2006/05/16 11:13:00
1 85 1393870 2006/05/16 11:13:00 1393929 2006/05/16 11:13:00 Figure 4a - A list backup showing the backup pieces that need to be copied across Host B


5. Creating the init.ora & administration directories for the duplicate database.

Host B(AUX)

Create the pfile [initAUX.ora] parameter file in the $ORACLE_HOME/dbs directory for the auxiliary database. An example is shown below (figure 5a) with bare minimum settings. Note you may require to set parameters which are the same as your production database (refer to you primary init.ora)

# +----------------------------------------+
# | FILE : initAUX.ora |
# | DATABASE NAME : AUX |
# +----------------------------------------+
# Set the below to location of the clone Duplicate database / name of
# clone database.

audit_file_dest =/oradata/AUX/adump
background_dump_dest =/oradata/AUX/bdump
core_dump_dest =/oradata/AUX/cdump
user_dump_dest =/oradata/AUX/udump
db_name ="AUX"
instance_name =AUX
cluster_database=false (in case the production is a rac environment)


# Set the below to the location of the duplicate clone control file.

control_files =('/oradata/AUX/control01.ctl','/oradata/AUX/control02.ctl','/oradata/AUX/control03.ctl')



# Set the below for the from and to location for all data files / redo
# logs to be cloned.

db_file_name_convert =("/oradata/PROD/", "/oradata/AUX/")
log_file_name_convert =("/oradata/PROD/", "/oradata/AUX/")
#Set the below to the same as the production target

undo_management =AUTO
undo_retention =10800
undo_tablespace =UNDOTBS1
db_block_size = 8192
compatible = 10.2.0.1.0 Figure 5a - Sample initAUX.ora with minimal settings

Following the creation of the initAUX.ora startup nomount the auxiliary instance.

[oracle@linux]export ORACLE_SID=AUX

[oracle@linux] sqlplus '/as sysdba'

SQLPLUS> startup nomount;Figure 5b - startup nomount the AUX instance.



6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.

Host B(AUX)

Ensure the production target database is open or at least mounted. If using a catalog database this must also be open. Test your SQL*NET connections: From Host B you must be able to connect to the primary DB as sysdba and make an rman connection to RMAN. Perform a basic test using sqlplus. When you have successfully connected exit sqlplus and move onto the next step.

[oracle@linux]% sqlplus ‘sys/oracle@PROD as sysdba’

[oracle@linux]% sqlplus rman/rman@RMAN (not mandatory) Figure 6a - SQL*NET connections


7. Prepare RMAN duplicate script.

In a working directory on Host B create an RMAN script file duplicate.rcv. The example below (figure 7a) shows the command for a complete duplicate (figure 7b) skips the tablespaces which are not required in the duplicate and (figure 7b) provide the syntax required for a point in time duplicate.

run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
} Figure 7a - Sample duplicate command.

run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX skip tablespace ABC, XYZ;
} Figure 7b- Sample duplicate script omitting optional tablespaces;

run {
set until time "to_date('Jan 01 2000 12:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
} Figure 7c- Sample duplicate script to a point in time.


8. Execute the RMAN script.

Start RMAN, connect to the production target, the catalog instance and also the auxiliary clone. Run the RMAN duplicate script as shown below. Before doing this ensure that the Oracle SID environment variable is set to the duplicate clone database.

[oracle@linux] export ORACLE_SID=AUX

[oracle@linux] rman target sys/sys@PROD catalog rman/rman@rman auxiliary /

RMAN> @duplicate.rcv

R12 Log Files Locations.

Concurrent Reqeust related logs

$LOG_HOME/appl/conc -> location for concurrent requests log and out files
$LOG_HOME/appl/admin -> location for mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home)

$LOG_HOME/ora/10.1.3/Apache -> Location for Apache Error and Access log files
$LOG_HOME/ora/10.1.3/j2ee -> location for j2ee related log files
$LOG_HOME/ora/10.1.3/opmn -> location for opmn related log files

Forms & Reports related logs (10.1.2 Oracle home which is equivalent to 806 Oracle Home)

$LOG_HOME/ora/10.1.2/forms
$LOG_HOME/ora/10.1.2/reports

Log files are useful in troubleshooting issues in Oracle Applications. Here is the list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DB & Apps Listener and various components in Apps R12/12i:

A. Startup/Shutdown Log files for Application Tier in R12

Instance Top is new TOP added in R12 (to read more click here)

–Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

–Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)$INST_TOP/apps/

$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

B. Log files related to cloning in R12

Preclone log files in source instancei)
Database Tier - /$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

ii) Application Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)
Clone log files in target instance

Database Tier - $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log

Apps Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log
—–
If your clone on DB Tier fails while running txkConfigDBOcm.pl (Check metalink note - 415020.1)

During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0
—–

C. Patching related log files in R12
i) Application Tier adpatch log - $APPL_TOP/admin/$SID/log/
ii) Developer (Developer/Forms & Reports 10.1.2) Patch - $ORACLE_HOME/.patch_storage
iii) Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage
iv) Database Tier opatch log - $ORACLE_HOME/.patch_storage

D. Autoconfig related log files in R12
i) Database Tier Autoconfig log :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log
ii) Application Tier Autoconfig log - $INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log

Autoconfig context file location in R12 - $INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml

E. R12 Installation Logs

Database Tier Installation
RDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.logRDBMS $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.logRDBMS

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.logRDBMS $ORACLE_HOME/appsutil/log/

$CONTEXT_NAME/make_.logRDBMS

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.logRDBMS $ORACLE_HOME/appsutil/log/

$CONTEXT_NAME/adcrdb_.log RDBMS

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.logRDBMS

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log RDBMS

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Application Tier Installation

$INST_TOP/logs/.log

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log

$INST_TOP/logs/ora/10.1.2/install/make_.log

$INST_TOP/logs/ora/10.1.3/install/make_.log

$INST_TOP/admin/log/ApplyAppsTechStack.log

$INST_TOP/admin/log/ohclone.log

$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log

$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log

$APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log

$APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log
Inventory Registration:

$Global Inventory/logs/cloneActions.log

$Global Inventory/logs/oraInstall.log

$Global Inventory/logs/silentInstall.log

F. Other log files in R12
1) Database Tier
1.1) Relink Log files :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
1.2) Alert Log Files :
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
1.3) Network Logs :
$ORACLE_HOME/network/admin/$SID.log
1.4) OUI Logs :
OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs
2) Application Tier
$ORACLE_HOME/j2ee/DevSuite/log
$ORACLE_HOME/opmn/logs
$ORACLE_HOME/network/logs
Tech Stack Patch 10.1.3 (Web/HTTP Server)
$IAS_ORACLE_HOME/j2ee/forms/logs
$IAS_ORACLE_HOME/j2ee/oafm/logs
$IAS_ORACLE_HOME/j2ee/oacore/logs
$IAS_ORACLE_HOME/opmn/logs
$IAS_ORACLE_HOME/network/log
$INST_TOP/logs/ora/10.1.2
$INST_TOP/logs/ora/10.1.3
$INST_TOP/logs/appl/conc/log
$INST_TOP/logs/appl/admin/log

How to Copy files from ext3 fs type externel hard disk drive to sun solaris server. (Alternate Method)

1. Download this file explore2fs.exe from the below link.
http://www.chrysocome.net/explore2fs
2. Install the exe software in windows pc.
3. Now you can see the Linux file systems in windows machine.
4. Now you can export the files to other NTFS/FAT drives.

How to mount linux filesystems partion in windows pcs

How to mount linux filesystems partion in windows pcs
1. Download this file explore2fs.exe from the below link.
http://www.chrysocome.net/explore2fs
2. Install the exe software in windows pc.
3. Now you can see the Linux file systems in windows machine.
4. Now you can export the files to other NTFS/FAT drives.

Enjoy..........

ssh: connection to host erp port 22: connection refused

Copying Files using non standard ssh ports on linux OS / Running SSH on Non standard Ports?

Type below command in your Linux Command Line.....

To Connect Linux Machine Remotely from Another Machine using non standard SSH ports.

Ssh –p port_number root@erp.chainsys.com

To Copy files from Linux Machine to other Linux Machine using non standard SSH ports.

Scp –prP port_number file_name root@erp.chainsys.com

Note : Use Caps P to specify port.

Windows XP Command Line Tool

Windows XP Command Line Tools

ADDUSERS Add or list users to/from a CSV file
ARP Address Resolution Protocol
ASSOC Change file extension associations
ASSOCIAT One step file association
AT Schedule a command to run at a later time
ATTRIB Change file attributes

BROWSTAT Get domain, browser and PDC info

CACLS Change file permissions
CALL Call one batch program from another
CD Change Directory - move to a specific Folder
CHANGE Change Terminal Server Session properties
CHKDSK Check Disk - check and repair disk problems
CHKNTFS Check the NTFS file system
CHOICE Accept keyboard input to a batch file
CIPHER Encrypt or Decrypt files/folders
CleanMgr Automated cleanup of Temp files, recycle bin
CLEARMEM Clear memory leaks
CLIP Copy STDIN to the Windows clipboard.
CLS Clear the screen
CLUSTER Windows Clustering
CMD Start a new CMD shell
COLOR Change colours of the CMD window
COMP Compare the contents of two files or sets of files
COMPACT Compress files or folders on an NTFS partition
COMPRESS Compress individual files on an NTFS partition
CON2PRT Connect or disconnect a Printer
CONVERT Convert a FAT drive to NTFS.
COPY Copy one or more files to another location
CSVDE Import or Export Active Directory data

DATE Display or set the date
Dcomcnfg DCOM Configuration Utility
DEFRAG Defragment hard drive
DEL Delete one or more files
DELPROF Delete NT user profiles
DELTREE Delete a folder and all subfolders
DevCon Device Manager Command Line Utility
DIR Display a list of files and folders
DIRUSE Display disk usage
DISKCOMP Compare the contents of two floppy disks
DISKCOPY Copy the contents of one floppy disk to another
DNSSTAT DNS Statistics
DOSKEY Edit command line, recall commands, and create macros
DSADD Add user (computer, group..) to active directoryDSQUERY List items in active directory
DSMOD Modify user (computer, group..) in active directory

ECHO Display message on screen
ENDLOCAL End localisation of environment changes in a batch file
ERASE Delete one or more files
EXIT Quit the CMD shell
EXPAND Uncompress files
EXTRACT Uncompress CAB files

FC Compare two files
FDISK Disk Format and partition
FIND Search for a text string in a file
FINDSTR Search for strings in files
FOR Conditionally perform a command several times
FORFILES Batch process multiple files
FORMAT Format a disk
FREEDISK Check free disk space (in bytes)
FSUTIL File and Volume utilities
FTP File Transfer Protocol
FTYPE Display or modify file types used in file extension associations

GLOBAL Display membership of global groups
GOTO Direct a batch program to jump to a labelled line

HELP Online Help
HFNETCHK Network Security Hotfix Checker

IF Conditionally perform a command
IFMEMBER Is the current user in an NT Workgroup
IPCONFIG Configure IP

KILL Remove a program from memory

LABEL Edit a disk label
LOCAL Display membership of local groups
LOGEVENT Write text to the NT event viewer.
LOGOFF Log a user off
LOGTIME Log the date and time in a file

MAPISEND Send email from the command line
MEM Display memory usage
MD Create new folders
MODE Configure a system device
MORE Display output, one screen at a time
MOUNTVOL Manage a volume mount point
MOVE Move files from one folder to another
MOVEUSER Move a user from one domain to another
MSG Send a message
MSIEXEC Microsoft Windows Installer
MSINFO Windows NT diagnostics
MSTSC Terminal Server Connection (Remote Desktop Protocol)
MUNGE Find and Replace text within file(s)
MV Copy in-use files

NET Manage network resources
NETDOM Domain Manager
NETSH Configure network protocols
NETSVC Command-line Service Controller
NBTSTAT Display networking statistics (NetBIOS over TCP/IP)
NETSTAT Display networking statistics (TCP/IP)
NOW Display the current Date and Time
NSLOOKUP Name server lookup
NTBACKUP Backup folders to tape
NTRIGHTS Edit user account rights

PATH Display or set a search path for executable files
PATHPING Trace route plus network latency and packet loss
PAUSE Suspend processing of a batch file and display a message
PERMS Show permissions for a user
PERFMON Performance Monitor
PING Test a network connection
POPD Restore the previous value of the current directory saved by PUSHD
PORTQRY Display the status of ports and services
PRINT Print a text file
PRNCNFG Display, configure or rename a printer
PRNMNGR Add, delete, list printers set the default printer
PROMPT Change the command prompt
PUSHD Save and then change the current directory

QGREP Search file(s) for lines that match a given pattern.

RASDIAL Manage RAS connections
RASPHONE Manage RAS connections
RECOVER Recover a damaged file from a defective disk.
REG Read, Set or Delete registry keys and values
REGEDIT Import or export registry settings
REGSVR32 Register or unregister a DLL
REGINI Change Registry Permissions
REM Record comments (remarks) in a batch file
REN Rename a file or files.
REPLACE Replace or update one file with another
RD Delete folder(s)
RDISK Create a Recovery Disk
RMTSHARE Share a folder or a printer
ROBOCOPY Robust File and Folder Copy
ROUTE Manipulate network routing tables
RUNAS Execute a program under a different user account
RUNDLL32 Run a DLL command (add/remove print connections)

SC Service Control
SCHTASKS Create or Edit Scheduled Tasks
SCLIST Display NT Services
ScriptIt Control GUI applications
SET Display, set, or remove environment variables
SETLOCAL Begin localisation of environment changes in a batch file
SETX Set environment variables permanently
SHARE List or edit a file share or print share
SHIFT Shift the position of replaceable parameters in a batch file
SHORTCUT Create a windows shortcut (.LNK file)
SHOWGRPS List the NT Workgroups a user has joined
SHOWMBRS List the Users who are members of a Workgroup
SHUTDOWN Shutdown the computer
SLEEP Wait for x seconds
SOON Schedule a command to run in the near future
SORT Sort input
START Start a separate window to run a specified program or command
SU Switch User
SUBINACL Edit file and folder Permissions, Ownership and Domain
SUBST Associate a path with a drive letter

TASKLIST List running applications and services
TIME Display or set the system time
TIMEOUT Delay processing of a batch file
TITLE Set the window title for a CMD.EXE session
TOUCH Change file timestamps
TRACERT Trace route to a remote host
TREE Graphical display of folder structure
TYPE Display the contents of a text file

USRSTAT List domain usernames and last login

VER Display version information
VERIFY Verify that files have been saved
VOL Display a disk label

WHERE Locate and display files in a directory tree
WHOAMI Output the current UserName and domain
WINDIFF Compare the contents of two files or sets of files
WINMSD Windows system diagnostics
WINMSDP Windows system diagnostics IIWMIC WMI Commands

XCACLS Change file permissions
XCOPY Copy files and folders



WINDOWS RESOURCE KIT FILES

* Acctinfo.dll (documented in Readme.htm)
* Adlb.exe: Active Directory Load Balancing Tool
* Admx.msi: ADM File Parser
* Atmarp.exe: Windows ATM ARP Server Information Tool
* Atmlane.exe: Windows ATM LAN Emulation Client Information
* Autoexnt.exe: AutoExNT Service
* Cdburn.exe: ISO CD-ROM Burner Tool
* Checkrepl.vbs: Check Replication
* Chklnks.exe: Link Check Wizard
* Chknic.exe: Network Interface Card Compliance Tool for Network Load Balancing
* Cleanspl.exe: Spooler Cleaner
* Clearmem.exe: Clear Memory
* Clusdiag.msi: Cluster Diagnostics and Verification Tool
* Clusfileport.dll: Cluster Print File Port
* Clusterrecovery.exe: Server Cluster Recovery Utility
* Cmdhere.inf: Command Here
* Cmgetcer.dll: Connection Manager Certificate Deployment Tool
* Compress.exe: Compress Files
* Confdisk.exe: Disk Configuration Tool
* Consume.exe: Memory Consumers Tool
* Creatfil.exe: Create File
* Csccmd.exe: Client-Side Caching Command-Line Options
* Custreasonedit.exe: Custom Reason Editor (documented in Readme.htm)
* Delprof.exe: User Profile Deletion Utility
* Dh.exe: Display Heap
* Diskraid.exe: RAID Configuration Tool
* Diskuse.exe: User Disk Usage Tool
* Dnsdiag.exe: SMTP DNS Diagnostic Tool (documented in Readme.htm)
* Dumpfsmos.cmd: Dump FSMO Roles
* Dvdburn.exe: ISO DVD Burner Tool
* Empty.exe: Free Working Set Tool
* Eventcombmt.exe: Check Replication
* fciv.exe: Fciv is a command line utility that computes and verifies hashes of files
* Fcopy.exe: File Copy Utility for Message Queuing
* Frsflags.vbs
* Getcm.exe: Connection Manager Profile Update
* Gpmonitor.exe: Group Policy Monitor
* Gpotool.exe: Group Policy Objects
* Hlscan.exe: Hard Link Display Tool
* Ifilttst.exe: IFilter Test Suite
* Ifmember.exe: User Membership Tool
* Inetesc.adm: Internet Explorer Enhanced Security Configuration
* Iniman.exe: Initialization Files Manipulation Tool
* Instcm.exe: Install Connection Manager Profile
* Instsrv.exe: Service Installer
* Intfiltr.exe: Interrupt Affinity Tool
* Kerbtray.exe: Kerberos Tray
* Kernrate.exe: Kernel Profiling Tool
* Klist.exe: Kerberos List
* Krt.exe: Certification Authority Key Recovery
* Lbridge.cmd: L-Bridge
* Linkd.exe
* Linkspeed.exe: Link Speed
* List.exe: List Text File Tool
* Lockoutstatus.exe: Account Lockout Status (documented in Readme.htm)
* Logtime.exe
* Lsreport.exe: Terminal Services Licensing Reporter
* Lsview.exe: Terminal Services License Server Viewer
* Mcast.exe: Multicast Packet Tool
* Memmonitor.exe: Memory Monitor
* Memtriage.exe: Resource Leak Triage Tool
* Mibcc.exe: SNMP MIB Compiler
* Moveuser.exe: Move Users
* Mscep.dll: Certificate Services Add-on for Simple Certificate Enrollment Protocol
* Nlsinfo.exe: Locale Information Tool
* Now.exe: STDOUT Current Date and Time
* Ntimer.exe: Windows Program Timer
* Ntrights.exe
* Oh.exe: Open Handles
* Oleview.exe: OLE/COM Object Viewer
* Pathman.exe: Path Manager
* Permcopy.exe: Share Permissions Copy
* Perms.exe: User File Permissions Tool
* Pfmon.exe: Page Fault Monitor
* Pkiview.msc: PKI Health Tool
* Pmon.exe: Process Resource Monitor
* Printdriverinfo.exe: Drivers Source
* Prnadmin.dll: Printer Administration Objects
* Qgrep.exe
* Qtcp.exe: QoS Time Stamp
* Queryad.vbs: Query Active Directory
* Rassrvmon.exe: RAS Server Monitor
* Rcontrolad.exe: Active Directory Remote Control Add-On
* Regini.exe: Registry Change by Script
* Regview.exe (documented in Readme.htm)
* Remapkey.exe: Remap Windows Keyboard Layout
* Robocopy.exe: Robust File Copy Utility
* Rpccfg.exe: RPC Configuration Tool
* Rpcdump.exe
* Rpcping.exe
* RPing: RPC Connectivity Verification Tool
* Rqc.exe: Remote Access Quarantine Client
* Rqs.exe: Remote Access Quarantine Agent
* Setprinter.exe: Spooler Configuration Tool
* Showacls.exe
* Showperf.exe: Performance Data Block Dump Utility
* Showpriv.exe: Show Privilege
* Sleep.exe: Batch File Wait
* Sonar.exe: FRS Status Viewer
* Splinfo.exe: Print Spooler Information
* Srvany.exe: Applications as Services Utility
* Srvcheck.exe: Server Share Check
* Srvinfo.exe: Remote Server Information
* Srvmgr.exe: Server Manager
* Ssdformat.exe: System State Data Formatter
* Subinacl.exe
* Tail.exe
* Tcmon.exe: Traffic Control Monitor
* Timeit.exe (documented in Readme.htm)
* Timezone.exe: Daylight Saving Time Update Utility
* Tsctst.exe: Terminal Server Client License Dump Tool
* Tsscalling.exe: Terminal Services Scalability Planning Tools
* Uddicatschemeeditor.exe: UDDI Services Categorization Scheme Editor
* Uddiconfig.exe: UDDI Services Command-line Configuration Utility
* Uddidataexport.exe: UDDI Data Export Wizard
* Usrmgr.exe: User Manager for Domains
* Vadump.exe: Virtual Address Dump
* Vfi.exe: Visual File Information
* Volperf.exe: Shadow Copy Performance Counters
* Volrest.exe: Shadow Copies for Shared Folders Restore Tool
* Vrfydsk.exe: Verify Disk
* Winexit.scr: Windows Exit Screen Saver
* Winhttpcertcfg.exe: WinHTTP Certificate Configuration Tool
* Winhttptracecfg.exe: WinHTTP Tracing Facility Configuration Tool
* Winpolicies.exe: Policy Spy
* Wins.dll: WINS Replication Network Monitor Parser
* Wlbs_hb.dll & Wlbs_rc.dll: Windows Load Balancing Server Network Monitor Parsers

Oracle Service request escalating procedure

For Critical Needs of any kind, please follow the escalation process to help expedite resolution.

Dial 800-223-1711, use your CSI number, tell the dispatcher that you already have a SR and provide it to them. They will notify the appropriate Duty Manager immediately for callback.

Escalating Issues - The Oracle Support Services Escalation Process
Frequently Asked Questions (FAQ)
1. When should you escalate a Service Request?
2. How do you request a Service Request Escalation?
3. What can you expect after you request a Service Request Escalation?
4. What are the benefits of using the Service Request escalation process?
5. De-escalating a Service Request
1. When should you escalate a Service Request?
Use the Oracle Support Services Escalation Process when your business critical issue requires a higher level of attention from Oracle Support Services Management.
This process should be utilized when you:
• encounter a critical roadblock or showstopper to implementation or upgrade plans
• urgently need to communicate important business issues to managers in Oracle Support Services
• are dissatisfied with the resolution or response to a Service Request
If a critical problem is encountered, consider the timing of when to escalate an issue. Waiting to escalate may leave little time to research the root cause of the problem and develop the most effective solution. Large, complex problems take time to resolve. Advise Support of the target dates and deadlines you have for critical issues. Document the deadlines in the Service Request, along with a statement of its impact on your business or the risk it poses to your implementation plans.
Requesting escalation will ensure attention on your issue but may not change resolution time depending on the complexity of the issue at hand – support management will be engaged.
This process should not be utilized when
• the business impact of the issue has increased
• the business impact of the issue was incorrectly stated initially
If the business impact has changed – or was incorrectly set – you should consider requesting a change of severity rather than escalation of the Service Request. While an escalated Service Request will require both your own management and managers at Oracle to become engaged, resetting the severity can be negotiated directly with the owning Support Analyst.
Raising the severity will ensure increased global focus and co-operation within support, to solve the issue in an appropriate timeframe – Additional technical resources may be engaged.
Please see the section Severity Definitions in Technical Support Policies.
2. How do I request a Service Request Escalation?
Before calling Oracle Support, review your Service Request and update it if necessary.
• Is the problem statement correct?
• Does the Service Request describe the impact to your business or the risk to your implementation plans?
• Is the Service Request severity level appropriate?
• If there is a workaround, is the workaround impractical or inappropriate?
• If there is a business milestone date or an implementation milestone date, is the actual calendar date identified in the Service Request?
Once you have completed the review, should you still need to escalate your Service Request, simply telephone Oracle Support as if you were going to log a new technical issue. When you reach a Dispatcher, provide the Service Request number and ask for the Service Request to be escalated.
You will be asked for a business justification for the Service Request escalation and for yours and your manager’s contact information.
The Support Analyst will then engage the Service Request Escalation Owner who will be responsible for managing your escalation.
Requesting a Service Request escalation via Metalink is also an option; however, the same escalation information must be provided in the Service Request. Please be aware that Service Request updates may not be reviewed immediately and may contribute to delays in acknowledging and handling your escalation request. To avoid delays in handling and acknowledging your escalation request, telephone Support and ask to escalate your critical Service Request.
If you do choose to request escalation via MetaLink please complete and insert the template below – including all ”*-lines”. This will ensure correct visibility and content.
******************* Escalation Request *******************
Reason for escalation, including business impact of the problem that requires escalation
Business or implementation milestone, critical date(s) (milestone date or resolve by date), along with the type of business or implementation milestone
Name of the person requesting the escalation, contact information: phone number, pager, email address
Customer manager escalation contact and contact information: phone number, pager, email address
******************* Escalation Request *******************
3. What can you expect after you request a Service Request Escalation?
If you have telephoned to request a Service Request escalation, the Service Request Escalation Owner will make every effort to call you back within 30 minutes. While it is our intention to call back in approximately 30 minutes, there may be occasions when the call back may be delayed. This guideline is provided to help you plan your availability for a call back rather than to guarantee the actual call back time.
The Service Request Escalation Owner is a manager who will work with the Support Analyst owning the Service Request, to review your escalation request. The Escalation Owner will then develop an action plan with you and allocate the appropriate Oracle resources. The action plan will be recorded in the Service Request. The Service Request Escalation Owner will also ensure that the appropriate resources are assigned and all actions are completed. The Action Plan may include tasks for both you and Oracle. Before leaving the call, make sure you know who owns the next action and that you have identified a communication plan. Most escalations are successfully resolved at this level. If the action plan fails to deliver expected results, please contact the Service Request Escalation Owner to review or to escalate the Service Request to the next level if required.
As work on the issue progresses, continue to make sure that your Service Request is a complete record of your actions and concerns. Save time by keeping it up-to-date and ensuring it reflects changes in frequency or urgency. If changes or additions to the Action Plan are made, document these in the Service Request. Documenting each escalation within the Service Request ensures a clear history of the issue and what actions have failed to address it. This documented history assists in evaluating the resources required to resolve this problem.
4. What are the benefits of using the Service Request escalation process?
Use the Service Request Escalation process to ensure Oracle Management attention to your issue, and to facilitate the creation of an Action Plan to resolve the issue with your deadline clearly stated. It also allows Oracle management to effectively and promptly assign the required resources to resolve your problem.
Consider that routinely escalating non-critical issues or consistently overstating the criticality of escalated Service Requests may result in a misunderstanding of the importance or critical impact of a future escalation. Prudent use of the Service Request Escalation process enables Oracle to accurately prioritize your critical issue.
5. De-escalating a Service Request
When a Service Request meets the de-escalation criteria or is no longer critical, it should be de-escalated by contacting the Escalation Owner.
Before de-escalating a Service Request, the Escalation Owner will:
• confirm with you that the action plan has been completed or the request cannot be fulfilled (i.e., specific functionality is not and will not be available in the Oracle product).
• document your agreement to de-escalate the Service Request.

Download and Installation steps for Setup loader Utility

Download and install the Setup Loader Utility: Before the official kick-off of the Implementer Workshop, your Oracle Accelerators trained DBA needs to complete the installation of the Setup Loader utility. This is a 3 step process:

Step 1: Enter a Service Request (SR) for Setup Loader utility
• Log a Service Request in My Oracle Support requesting the Setup Loader Utility (SLU) download.
• This service request triggers the generation of a Request Identification Number (RIN).
• Plan a lead time of three business days for this request to be fulfilled.

Step 2: Download & install Setup Loader Utility
• Go to E-Delivery area on Accelerators Online and paste the RIN.
• You will be presented with links to download the Setup Loader Utility.
• Download all the disks (using a Download Manager) and install on your hardware.

Step 3: Download and run the Oracle Business Accelerator Diagnostic Utility (OBADU)
• An Accelerator trained DBA must read My Oracle Support Note 549683.1 and download the OBADU.
• The OBADU gathers and reports E-Business Suite environment information to help the implementer DBA assess whether the install is successful.
• DBA must run the OBADU to verify the installation. The OBADU output will inform the DBA of appropriate actions to take if any steps have errored out.
• If unable to resolve issues, the DBA may raise a My Oracle Support Service Request and attach the output of this utility.

Step 4: Full Backup of OBA Installation
• After validating the installation execute a full instance backup.
• This back up will be used to refresh the installed E-Business Suite quickly as required.
Further reading:
• My Oracle Support Note 456200.1: Leading Practice: Setup Loader Utility install
• My Oracle Support Note 471411.1: Accelerator Project Tasks and Times
• My Oracle Support Note 430777.1: Release 12 Installation FAQ
• My Oracle Support Note 554318.1: Using Download Manager for OBA Setup Loader Utility
• My Oracle Support Note 549683.1: MANDATORY DOWNLOAD: OBA Diagnostic Utility for e-Business Suite Available
• 'Install Related' section in the Accelerator Knowledge Browse Area on My Oracle Support


Applies to:
Oracle Accelerators
Linux x86
Linux x86-64
What is being announced?
Oracle Business Accelerator Diagnostic Utility (OBA DU) for eBusiness Suite is available for download.
The Diagnostic Utility is a set of command line diagnostic scripts used to gather and report information about an Oracle Business Accelerator for E-Business Suite environment. The utility generates formatted output displaying useful system information for the implementer DBA to assess whether the install is successful. The output also informs the DBA on the appropriate actions to be taken, if necessary, on various steps that have errored out.
Who should download the Diagnostic Utility?
An approved DBA MUST download and run the Diagnostic utility to verify that the install is successful. This is mandatory before running the Configuration Tool. In case the DBA is unable to fix the issues as per the suggestion(s) noted in the Diagnostic Utility report, then the DBA must raise a Service Request on My Oracle Support against Oracle Accelerator product (Product ID: 1690) with the Diagnostics report output to expedite the resolution of install issues.

What do you need to do?
Steps to download the Diagnostic Utility are as follows:
1. Log in to Accelerators Online with your SSO Login ID.
2. Click on the Oracle logo under section E-Delivery. Click on Continue button.
3. Check two check-boxes for Customer License Agreement and Click Proceed button
4. Enter the Request Identification Number provided below and click proceed (while you copy-paste the Request Identification Number make sure you DO NOT have any spaces, it should be one continuous number from the start to he end)
Request Identification Number for Linux:
DC24713F486F631F0B6A989DAAB1035640B20DF8E2B6882774E6211724A8A9335B27719DCB8FE88B44DB5F0F8001D2D7D1402064CA1FDFBE7C4D5833DCE7BB027E2695BDB799EFAA1F5F43C4B4FB8EA1637C20A128F99F7CE69C2B5B648345B5A1D87FB738D82629294D3B4A2C4CCEF93A804EBCF8F3399021ED2C8B1328288F628912AB3D982445BD601EEC73BF424A674F264335750DAE6B7104F3D2DC0F12BB097128B2593683
Request Identification Number for Sun Solaris:
DC24713F486F631F0B6A989DAAB1035640B20DF8E2B6882774E6211724A8A9335B27719DCB8FE88B44DB5F0F8001D2D7D1402064CA1FDFBE98C7140AA52CA756554A6CD4B92355B15FC93B60539D524609916829440987C687607C56B323F025C3E775EE5C60D9DA70B04CFC854F178850B24CB3123749B26E577F9397A3DDF091283CBBB660A7798FE53C4E95468A1DE9B50A06A2E62608AB6AB54D70066775E181503DBEC90E4F8C904236CA4ECED9
Notes:
1. The Accelerator Diagnostic Utility is NOT part of Oracle Support Diagnostics (see E-Business Support Diagnostics Overview)
2. The Utility has been designed for use by Oracle Application DBAs on Oracle Business Accelerator environments only
3. The utility does not alter any data or configuration in your system
4. For accurate diagnostic information, the utility needs to be executed on both Application and Database tiers.
5. OBA DU must be run every time a new instance is created, or when an instance is refreshed with a previous backup that was taken after installing the Setup Loader Utility. This is a MANDATORY step prior to requesting a Pre-Project Review and should constitute as the sign-off step for the DBA before handing over the instance to the Project Manager.
6. OBA DU output must be verified by the DBA and checked for any errors (navigate to the Instance Information link in the file index.html.) Any error must be corrected as per the instructions.
IMPORTANT: You MUST upload the OBA DU output to a pre-project review for every OBA project.
---------------------------------------------------------------------------------------------------------
Common Errors: Following are the common errors seen in OBADU output
1. Display Variable set incorrectly - ensure that the DISPLAY (“s_display”) value in $CONTEXT_FILE is updated to a valid working VNC or to an Xserver console value and run AUTOCONFIG. (Example: :10.0). VNC should not be started on port 0:0
2. SWAP memory is less than the size of the Physical memory on the server - Although this is shown as an alert, please note that this will impact your performance, so ensure that minimum SWAP is twice the size of the Physical memory.
3. UTF8 characterset is not used - by default OBA installer selects UTF8 characterset, and if this is overriden then install errors will occur.
Who to contact for more information?
If you are unable to resolve any errors, then log an SR on My Oracle Support against Oracle Accelerator product (id: 1690) and upload the output for verification.

Big patch failure because of prerequisite patch

When you are applying a Big patch which will take around 10 hrs. Now 5 hrs of the patch has been completed and now errored out due to some pre req patch. So now we can follow the steps given below and the resume the remaining part of the patch.

Solution:

1. Using the adctrl utility, shutdown the workers.

a. adctrl

b. Select option "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/restart directory.

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//restart_back 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/passwd

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.

How to type password securely while we accessing online shoping & Banking sites

As we know that spyware can log all key stroke and sent out. I wonder to enter the password through on-screen keyboard to prevent key strokes logged by spyware when using internet banking service.

1. Start
2. Go to RUN
3. Type OSK in Run prompt
4. Finally type your password securely

Service Tab On The Item Master Form Greyed Out

Solution

1) To check to see if Oracle Install Base is installed run the following:

SELECT APPLICATION_ID, STATUS, PRODUCT_VERSION, PATCH_LEVEL, LAST_UPDATE_DATE
FROM FND_PRODUCT_INSTALLATIONS
WHERE APPLICATION_ID = 542

2) If status is note 'I' then use License Manger to install Oracle Install Base.

License manager can be run 2 ways:

a. Log in through Oracle Application Manager (OAM) and select Site Map -> Administration tab -> License Manager

b. Run adlicmgr.sh from AD_TOP/bin

How to Unprotect a Protected Excel Worksheet

Ever come across an Excel file that you can open and view but if you wanted to edit it, you can’t, since it is has been protected? And when you try to unprotect, it asks for a password.

Here are a couple of ways to overcome the situation. While, you may not be able to make the original document editable without the password, you can create editable copies. Here’s how.

Situation 1: If the cells that you are interested in are selectable, then you can merely select the cells, copy the contents, and paste them into a new worksheet or file. The new worksheet would be perfectly editable. While, this may appear too simple, many people are not aware that this works.

Situation 2: There is a possibility that the creator of the file has disabled Cell selection while protecting the worksheet. Obviously you can’t use the first method to deal with such worksheets, because without the ability to select the cells you can’t possibly copy the contents.

Call Google Docs or Zoho Sheet to your rescue.

Just upload/import the excel file to either Google or Zoho and magically you are able to edit the file. Better still, export the file again into an .xls file and you can edit the file on your desktop using Excel. There is a slight difference between the way Google Docs and Zoho Sheet behave in this regard. While the exported file from Google is already unprotected, the file exported from Zoho Sheet, needs to be unprotected using the menu. But now you won’t be asked for password to unprotect.