Oracle Consulting and Support Services
Oracle headquarters	Oracle is the world's largest enterprise software company, providing enterprise software to the world's largest and most successful businesses. Oracle is the first software company to develop and deploy 100 percent Internet-enabled enterprise software across its entire product line, including database, server, enterprise business applications, and application development, and decision support tools.    PALCO has invested a lot building teams and experience in Oracle technologies. We have an Oracle certified Solution provider since 1997. We have been actively helping Oracle customer by providing them with licenses, Installation , configuration , localization, tuning and other services. we have trained thousands of people over the past ten years. We also helped several customers to upgrade their Oracle database and Oracle applications to newer releases up to Oracle10g and Oracle application Server 10g. Our latest engagement with Mobilecom GIS operator (a France telecom company) exposed us to work in high availability environment with large  number of concurrent users utilizing almost all of the Oracle Application Server 10g components (SSO, Portal, Web Cache, FORMS OC4J, BI ... ) Our team has executed several project involving Data loading, data conversion , and data localization    Our reputation attracted customers from several countries.   For more information about our training activities please follow the link Oracle Training @PALCO For the available service plan plan see the side column PALCO Service Plans Short Customer List

Oracle Service Plans Description

1. Oracle Database Installation:                                                 (1 Day)
   1. Specifying minimum hardware requirements
   2. Specifying O/S version, packages and patches
   3. Onsite installation of Oracle Database on different platforms including LINUX, HP-UX, SOLARIS, AIX, MSWIN etc.
   4. Applying latest patches.
   5. Planning database creation, including tablespaces, block size,initial parameters, character set etc.
   6. Database creation.
   7. Setting up network configuration for two and three architecture

2. Internet Application Server (IAS) Installation 10g:         (1 Days)
   1. Specifying minimum hardware requirements.
   2. Specifying O/S version, packages and patches.
   3. Onsite installation.
   4. Applying latest patches.
   5. Configuring and testing components including:

                                                              i.      Forms server

                                                            ii.      Reports Server

                                                          iii.      Portal

                                                          iv.      Webcache

                                                            v.      Single Sign On (SSO) for custom products

                                                          vi.      Application server cluster configuration

                                                        vii.      Oracle Container for Java (J2EE) configuration and deployment

3. Internet Application Server (IAS) Wireless Edition

              Same as the above including Wireless Edition configuration

5. Real Application Cluster (RAC) Installation:                     (5 Days)
   1. Testing hardware certification for the specific platform 
   2. Specifying O/S version, packages and patches
   3. Onsite installation of Oracle server and RAC software
   4. Applying latest patches.
   5. Planning database creation, including tablespaces, block size and initial parameters
   6. Configuring Nods, testing hardware cluster
   7. Database creation
   8. Configuring and testing Transparent Application Fail over  (TAF)
   9. Configuring and testing Application load balancing (if required). 

6. Oracle Failsafe installation on windows cluster:                (2 Day)
   1. Specifying minimum hardware requirements
   2. Onsite installation of Oracle server
   3. Applying latest patches.
   4. Onsite installation of Oracle Failsafe
   5. Planning database creation, including tablespaces, block size and initial parameters
   6. Database creation
   7. Testing fail over

7. Backup and recovery strategy:                                              (3 Days)
   1. Specifying requirements based and type of backup (closed database backup, open database backups, incremental backups, export/import or mixed strategy)
   2. Setting up backup strategy
   3. Installing and configuring Legato storage Manager or utilizing available media management software (If required) 
   4. Setting up automated scripts for backup (user managed or using Oracle RMAN)
   5. Validating backup strategy based on different flayer scenarios 

8. Collaboration suite installation and configuration:                          (3 Days)
   1. Specifying minimum hardware requirements
   2. Specifying O/S version, packages and patches
   3. Onsite installation of Oracle Collaboration Suite Infrastructure
   4. Applying latest patches.
   5. Installing the Mail Database (on the same or different server)
   6. Installing the Files Databases (on the same or different server)
   7. Applying latest patches.
   8. Configuring Directory Usage
   9. Configuring Database Options in the Directory
   10. Installing the Oracle Collaboration Suite Applications
   11. Installing Oracle Email
   12. Configuring Email and enroll a few users
   13. Configuring Oracle files
   14. Configuring Calendar
   15. Configuring Ultra Search
   16. Configuring Portal
   17. Testing the environment with the client

9. Disaster Recovery using oracle data guard:                        (1 Day)
   1. Installing Oracle server on disaster recovery server (package 1)
   2. Installing and configuring data guar
   3. Specifying the required protection mode (Maximum Protection, Maximum Availability or Maximum performance)
   4. Configuring production Database Options
   5. Creating Standby database.
   6. Testing fail over between production and standby database

10. Migrating oracle database to newer versions:                                  (2 Days)
    1. Planning the migration
    2. Backup old oracle server and database
    3. Installing oracle Server (Package 1)
    4. Migrating oracle database
    5. Testing the migration

11. Configuring Oracle Replications                                                      (2 Days)
    1. Identifying business Requirements
    2. Specifying Replicated objects
    3. Specifying Replication Architecture (Multi master, Master-Snapshot or hybred configuration)
    4. Configuring master sites
    5. Configuring Snapshot (Materialized View) Sites
    6. Creating Master Groups
    7. Creating replication templates (if required)
    8. Create Snapshot (Materialized View) Groups
    9. Create Refresh groups
    10. Manage refresh schedules

12. Installing and configuring Oracle Enterprise Server (OEM):    (1 Day)
    1. Installing Oracle Enterprise Server
    2. Configuring Oracle Management Server
    3. Discovering database servers
    4. Configuring Jobs, events and credential for each server
    5. Test sample jobs, events on each database server
    6. Configure and test tuning pack, change pack and diagnostic pack etc…

13. Database tuning and Health check:                     (1 Day)
    1. Running scripts for database health check which includes:

1.      Data files, log files size and there distribution on hard disks.

2.      Tablespaces storage parameters

3.      Tabalespaces total size, total free space and frees space fragmentation.

4.      Database schemas and there distribution on tablespaces.

5.      Database segments initial parameters and fragmentation.

6.      Users with DBA grants

7.      Default tablespace and temporary tablespace fror each user.

8.      Rollback segments, size, storage parameters

2. Conducting corrective actions base on the results.
3. Running diagnostic tuning scripts which includes:

1.      Cache size (SGA).

2.      Load profile (No of transactions, No of physical reads, etc.).

3.      Hit ratios (buffer cache, library cache, etc).

4.      Wait events.

5.      Worst sql statements.

6.      Instance statistics.

7.      Tablespace and datafile I/O s.

8.      Rollback, Undo statistics.

9.      Latch statistics.

4. Analyze the results, identify bottlenecks and causes and provide recommendations and corrective actions.

14. Application Tuning                                          (5 Days)

·         Identifying Samples Forms or Reports that cause Performance problems

·         Identifying SQL statements that cause bottle neck

·         Deciding on particular statements to study in depth

·         Suggesting scenarios to remove bottle neck

·         Testing performance after implementing such suggestions

·         Tuning indexes

·         Utilizing Tuning Tools like AutoTrace, SQL TRACE etc

·         Testing the effect of  Cost vs Rule based optimizers.

·         Utilizing HINTS to improve performance

·         Asking the client to repeat the cycle again to solve performance problem of other statement under the supervision of the consultants.

·         Discussing SQL patterns that cause performance problems and documenting situation to be avoided in  SQL report writing

15. Database Security Assessment:                                  ( 3 Days  )
    1. Analyze the current security configuration
    2. Identify security holes.
    3. Provide recommendations, and suggest corrective actions based on the current situation and latest Oracle security features.
    4. Conduct the corrective actions.
    5. The security aspects that will be covered:

1.      Operating system authentication.

2.      Utilizing Oracle Password Management.

3.      Managing Oracle Default users.

4.      Managing Oracle System privileges and roles.

5.      Managing Oracle Object privileges and roles.

6.      Managing access to SQL*PLUS.

7.      Managing Database Links security.

8.      Restricting DBA privileges to specific tasks.

9.      Singe Sign On.

10.  Securing oracle on Unix or Windows

11.  Security over distributed locations: Privacy, non-repudiation and Integrity

12.  Label security

13.    Enterprise user management using Oracle Internet Directory (OID).

14.    Virtual Private Database

16. Oracle Warehouse Builder installation , configuration       (1 day)
17. Application Development  Using Oracle Designer, Oracle Report, Forms and J2EE

Upon request, we also provide excellent Designer and CDM/Headstart consulting services.