*************************************************************************************************************************************************************
Platform migration
================
> Go through all the platform migration spa documents
>
Cloning
=========
> Multi node to single node, single to Multi
> Dissect all steps of Rapid Clone - in depth.
> Database cloning steps : 1) single node cloning 2) RAC cloning
Patching
=========
> adpatch basics and how to reduce time
> opatch basics
Periodic maintenance activities
========================
> steps to stop-start the database and application
Oracle RAC :
=========
> Julian Dyke
> add new node
> remove new node
> RAC to RAC database cloning
> upgrade RAC database from 10.1.0 to 10.2.0
> upgrade 10.2.0 database from 10.2.0 to 11g
> change virtual ip
> Load balancer settings and minute details on how it works
> Run AWR on RAC and learn about RAC related parameters
RMAN
=====
> Setup rman
> RMAN configuration parameters and RAC database
> Database Recovery scenarios and execute and document steps for each scenarios
> try all kind of backups possible
ASM
====
> learn about all related ASM processes
> learn about all related tables,views
> add new disk to +RECOVERYDEST, remove this disk and create a new diskgroup +BACKUP and add new disk to it.
> upgrade software from 10.x to 11.x
> shift from normal redundancy to high redundancy - you must create another diskgroup with the desired redundancy, then move the datafiles (using Recovery Manager [RMAN] restore, ASMCMD copy command or DBMS_FILE_TRANSFER) from the original diskgroup to the newly created diskgroup.
> manually unmount a asm failure group and then mount it to see how asm do rebalancing
Database upgrade
===============
> Upgrade DB from 10g to 11g
> Learn basic differences between 10g and 11g
> Database parameters tuning
> Database performance monitoring - how to do and which tools
Data guard (Standby)
=================
> Basics
> Types
> setup (possibly)
Disaster Recovery
==============
> basic idea and scenarios
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
INSTALLATION of 11i and R12
=============================
> install 11i
> Install with 1 application tier, 2 db tier
> Move few services to 1 of the db node
> upgrade to R12
> learn R12 file system difference with 11i
> Create custom schema
> clone (possibly)
PCP
====
> set up PCP
> Important files
SHARED APPL_TOP and SHARED APPLICATION TIER
=============================================
> how to setup
> how to identify
> benefits
Oracle 10g Aplication Server
============================
> Basics
> Components
> Installation and Configuration of Oracle 10g Application servers
Forms server
===========
> Basic structure and flow of how forms server works
> Forms metric server and client, Forms server and forms runtime engine
> Forms CGI
> How is Forms load balancing accomplished?
Oracle Grid Control
===============
> Installation and configuration of OGC
> Learn all basic functions
> what and how to monitor
> how to set alerts
Discoverer
=========
> Set up discoverer services
> Important files
> Learn basics of windows tools used
> how to connect discoverer and 11i
SSO OID
========
> Learn the basics, types and installation steps
> possibly set up SSO
Interconnect Adapters
=================
> basics
> setup
Shell Scripting
===========
> basics
> cron details
PERFORMANCE TUNING
=====================
> basics
> AWR reports
> trace, tkprof
*************************************************************************************************************************************************************
WHAT NEEDS TO BE READ : -
=====================
> What is MWA, functioning, important files and all other related stuffs
> Discoverer basics , important files
> Error is coming in the alert log file
===========================================
Thread 1 cannot allocate new log, sequence 962
Private strand flush not complete
=======================================
steps to correct (Note:372557.1 has brief explanation of this message.)
>
Oracle
---
> running program level trace when program is running
> load balancer settings in RAC
> server memory? how much?
> RAC/RMAN cloning?
> RMAN . How many channel process? How to decide?
> How to do reorg? which table?
> normal outage process.How to up and down database? crs up down?
===============================================================
at&t
--
> adbldxml generates data from which DB tables?
> adadamin reads which file (or it reads fnd_nodes?) to see what is running on this node?
> PCP ( ICM got crash on primary node , what will happen)
> multi-node to single node cloning
> node a not running forms, can we generate fmb file?
> shared appl_top fnd_nodes entries?
Ibm
---
> FNDCPASS touches which all tables?
> FNDCPASS - how to change all oracle passwords at one go
> ADPATCH creates two tables. What are the contents of those tables.
> adworker is hanging during ADPATCH.. how to troubleshoot.. worker log file, patch log file and adctrl are showing it as running.
> We deleted 10k rows from a table yesterday and came to know today (24 hrs time diff.)...now how to get back rows, without missing a single transaction in that table that happened after deletion of data [ we take daily backup, if it helps] .
> custom schema creation steps
> product licensing
> adsplice uses which files?
> rapid clone hot backup cloning process
> all kind of users and their significance. applsyspub,guest,apps,applsys
> Forms server architecture, major files
> Number of users increased from 500 to 3000. From application perspective How and what to change and in which files?
> DB block level concepts, pctfree, pctused. At project start how to decide how to keep these parameters
> FNDSM?
> FNDFS?
> Application Listener significance?
> Tuning basic concepts, locking, latching
> how to know system is shared APPL_TOP? files?
> How to know system is PCP enabled? which files?
> Printer Installation?
> Concurrent program performance issue? how to troubleshoot? How to trace running concurrent program?
> Oradebug?
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
•Experience in designing databases, build and deployment of critical applications
•Experience in database administration of 8i/9i/10g databases on heterogeneous and complex DC environment
•Experience in installing and configuring 10g R2 RAC
•Experience in Migrating databases from file systems to ASM
•Experience in upgrading databases from one version of oracle to higher version
•Experience in configuring Disaster Recovery Site
•Capacity planning of critical production databases
•Experience in various scenarios of Database Recovery
•Cloning of production databases for creation of DEV/UAT environments
•Database performance monitoring, database parameters tuning.
•Installation and Configuration of Oracle 10g Application servers
•Installing and Configuration of Oracle Enterprise Manager Grid Control
•Deploying third party plug-ins for monitoring non-Oracle Products through enterprise grid control
•Trouble shooting 24*7 production environment issues.
•Configured Recovery Manager for Backup & Recovery of Development / Testing Environment.
=========================================================================================================
RMAN CONCEPTS & COMMANDS
PCP SETUP
SHARED APPL_TOP
PRINTER INSTALLATION AND TROUBLESHOTTING
NEW APPLICATION REGISTRATION/CUSTOM APPS SCHEMA
DB UPGRADE 9.2.0.7 TO 10gR2
GSM
ADADMIN COMMON MENU ITEMS
GATHER TABLE/SCHEMA STATISTICS FROM FRONT END AS WELLA S BACK END AND WHY?
FRAGMENTATION AND REORG?
INDEX ANALYZE/REBUILD? WHY?
FNDLOAD?
DATAPUMP?
THROUGHPUT?
STATSPACK/AWR? WHY?
RDBMS PATCHES/OPATCH?
DECOMMISSIONING OF EBS INSTANCE? STEPS?
ORACLE APPLICATION BASICS (FINANCE)?
=====================================================================================================