Platform Hosting - Database - Oracle
The California Department of Technology (CDT) provides services on a number of database management system (DBMS) technologies for various hardware and operating system platforms. CDT offers Oracle on leased equipment within the CDT Tier III data center.
Oracle is available as an add-on component to Customers that subscribe to the AIX, Linux, Solaris or Windows Platform Hosting services.
- Project agility and flexibility
- Significantly reduced cost and risk
- Fixed monthly rate for database management
- CDT manages database installation, upgrades, migrations and patching
- Access to the Oracle Enterprise Manager for control and overview of the database state
- 24/7 Service Desk support
The following are included in the Oracle service:
- Support of Oracle database versions in accordance with the CDT Software Version Support Policy
- Hosting on the Solaris, AIX, Linux, z Systems, and Windows platforms
- Management of the Oracle software licensing
- Oracle database installation, patching, maintenance and 24/7 on-call technical support
- Liaison service between the Customer and vendor for technical system-level DBMS issues
- Database backups on the following schedule:
|Transaction Log Backup||Daily|
|Backup Retention||28 days|
Oracle Database offers a wide range of features to help customers meet specific requirements in the areas of performance and scalability, high availability, security and compliance, data warehousing and big data, and manageability.
CDT assists Customers in formulating database designs that meet their business requirements. Customers should contact their Account Lead to engage architectural/engineering and design consulting services. Additional charges may be incurred.
|Maintain logical and physical database design diagram(s) and provide to CDT upon request||Customer|
|Update of logical and physical database design diagram(s) as database environment(s) are completed and accepted||Customer|
|Understand product lifecycles||Customer|
|Collaborate with CDT on upgrades, testing, and verification of database technologies before the end-of-life support date||Customer|
|Determine and submit details of hardware capacity needs and Oracle database software version||Customer|
|Identify and lead the resolution of application related problems||Customer|
|Review and approve of submitted request prior to beginning work||CDT|
|Notify customer of any submittal flaws||CDT|
|Installation, upgrade, patching and standard configuration of the Oracle database product(s)||CDT|
|Assist Customers in specifying design requirements in accordance with information provided in the Oracle Database Submittal||CDT|
|Design, develop, test and deploy the Oracle database(s) and maintain interactions with application(s)||Customer|
|Submit a complete Oracle Database Submittal||Customer|
|Identify and provide list of database users who will be assigned DBA role and inform CDT Oracle Database Support of changes||Customer|
|Assist Customers in restoring a database in accordance with the Oracle Database Submittal||CDT|
|Monitor table space usage and notify customer when additional storage is needed||CDT|
|Maintain database backups||CDT|
|Assist in resolution of database system problems||CDT|
|Create database DBA account(s) within Oracle instance||CDT|
|Assign permissions in accordance with Oracle Database Submittal||CDT|
|Monitor and tune Oracle database||CDT|
|Review and recommend optional configurations that may better meet capacity and performance requirements in accordance with the Oracle Database Submittal|
|Perform Oracle database migrations, upgrades and patches||CDT|
|Maintain non-client based Oracle database administration tools||CDT|
|Maintain Oracle database software and configurations||CDT|
|Resolve Oracle database problems||CDT|
|Contact CDT Oracle Database Support for Oracle database issues as needed||CDT|
|Define Oracle database availability requirements||Customer|
|Document database design and application architecture||Customer|
|Maintain Oracle database dictionaries||Customer|
|Respond to threshold limit notifications provided by CDT Oracle Database Support||Customer|
|Test new maintenance and software releases at user and application levels for compatibility and functionality to database||Customer|
|Submit Service Request to purchase Oracle database licenses and to renew maintenance||Customer|
|Create and maintain schema objects||Customer|
|Adhere to CDT Procedure 4000 – Software Version Support for application design, development, testing, migration and maintenance activities||Customer|
|Application design and maintenance adhering to supported Oracle software versions||Customer|
|Manage contract and licensing for Oracle database software||CDT|
|Serve as liaison between the customer and Oracle Corporation for technical database issues||CDT|
|Communicate database version end-of-support dates through Account Leads and Service Desk Bulletins||CDT|
|Formulate and implement database upgrade plans||CDT|
|Assist Customers with DBMS incident resolution subsequent to application configuration changes||CDT|
|Maintain application and database statistics||Customer|
|Maintain application development tools||Customer|
|Ongoing monitoring of database growth in relation to disk space||Customer|
|Monitor database use and promptly respond when action is needed||Customer|
|Assist in resolution of database system problems||Customer|
|Identify database application related problems or database problems||Customer|
|Identify and report database problems to the CDT Service Desk||Customer|
|Database capacity planing and ongoing monitoring of database growth in relation to disk space||Customer|
Oracle DBMS administration authority is restricted to CDT designated personnel.
Occasions arise when, during construction, customers may be granted temporary DBMS administration rights to their leased installations of Oracle database. This access is limited to a maximum of four (4) calendar weeks from the time access is provided and will be revoked thereafter. If a customer requires temporary DBMS administration rights, the customer must complete an Information Security Exception Request and adhere to CDT Standard 3132 – Midrange Database Security.
Follow the procedure outlined in Procedure 3502 – Information Security Exception Request.
- Oracle database support outside of core support hours is available upon receipt of an approved CDT Service Request. The request must be received a minimum of 10 days prior to the start of requested support.
- Oracle change requests follow the established CDT Change Management process. Oracle maintenance activities utilize the platform maintenance schedules; however, emergency changes may be scheduled. Changes require 2-week prior notification. Shorter periods may not always be accommodated. Security-related changes adhere to the Midrange Database Server Security Standard, which can be obtained upon request through your Account Lead.
- Configuration changes made outside the scope of the service request which requires intervention, correction, or troubleshooting by CDT staff may incur additional charges.
|Service Code||Service Description||Unit of Measurement||Rate||Notes|
|D101-Pass||CDT Processing Fee on Pass-through Products||% of Direct Pass-Through Costs - Per Purchase Order||Pass-through + 2.81% CDT Processing Fee|
|M622||Tier 2 Database Support (Oracle)||Instance/Month||$1,170.00|
|M623||Database Instance Installation Set-up Fee for Database Support - Tier 2 (Oracle, Informix*, Sybase*, and Cache*)||One-Time/Instance||$690.00||*Software is in containment & unavailable for new systems, upgrades or migrations of existing systems.|
Subscriptions to this service are available. Rates may also be referenced in the CDT Rate Schedule.
To submit a service request for a new database or database environment, please go to the Enterprise Services Delivery page.
A completed Oracle Database Submittal is required prior to the start of work. To aid in the preparation of providing this technology, a CDT Service Request form needs to be submitted and contain all pertinent information about the database build including local and physical database design diagrams.
Customers are encouraged to update the logical and physical database design diagram(s) as the database environment(s) are completed and accepted.
Service Requests are revised at appropriate intervals providing for expeditious and practical execution of the work performed.
Use the following method for work requests:
|To request a change to a current database or decommission, please submit a service request.||Request a Change to a Current Database or a Decommission Now|
|Modifications to Existing Systems||CDT Service Desk|
|Technical Problems||CDT Service Desk for an Incident|
|Security Related Issues/Incidents||CDT Service Desk|
|Temporary DBMS Administrator Privilege Request||Information Security Exception Request. Follow the procedure outlined in CDT Standard 3132 – Midrange Database Server Security Standard and Procedure 3502 – Information Security Exception Request|
|04.13.875||2012||Oracle Database Submittal|
|3132||2010||Midrange Database Server Security Standard|
|Website||NA||CDT Service Request|
|4000||2011||CDT Software Version Support Policy|
|4000||2011||CDT Procedure 4000 – Software Version Support|
|3138||2010||System Administrator Access Standard|
|3502||2010||Information Security Exception Request|