Since 1966 Oltchim has provided chemical products. Their products, either PVC (Polyvinyl Chloride), Caustic Soda, Propylene Oxide, Propylene Glycol and Polyether Polyols, Chlorosodics or construction materials, are highly appreciated in more than 80 countries.
Create a printer server and define printers on Oracle Applications
CHALLENGES
TECHNICAL APPROACH
Upgrade Oracle Applications from 11.0 to 11.5.9
Upgrade Oracle database from
8.0.5 to 9i
Create a printer server for new Applications and define printers
on it
Modify custom reports
Upgrade database Major steps
Install operating system
Apply the Applications consolidated export/import utility patch
Generate script for create new database and create the new one with this script
Export Old database
Import on new database
Create the second target database 9.2.0.1
Export from 8.1.7 and import on 9.2.0.1
Modify Oracle Applications to work on new database
Upgrade Oracle Applications Major steps
Install Operating system
Verify operating system prerequisites
Apply prerequisites patches
Apply patches for upgrade
Define a new X-server for reports
We used USA (Oracle E-Business 11i Upgrade Assistant Installation and Configuration Guide For Unix Systems) for upgrade process.
The new servers have an HP-UX Operating System with 8 CPU and 16GB RAM with active-passive cluster.
Create a “cluster” printer server, based on Linux Reh Hat, using CUPS
Install printers on CUPS server
Install printers on Oracle Applications
Modify custom reports: modify all custom reports for working on new applications and database
BENEFITS
This upgrade process allowed Oltchim to achieve the following goals:
Up to date Oracle Database and Applications
Better administration tools;
Better administration & monitoring for database and applications;
Robust command-line administration;
More stability, flexibility, scalability, reliability and security;
Printers defined on Oracle Applications
Load balancing and fail over solution for Printer Server
