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 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 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 CDT
Design, develop, test and deploy the Oracle database(s) and maintain interactions with application(s) Customer
Submit a complete Oracle Service Request Customer
Identify and provide a list of database users who will be assigned DBA role and inform CDT Oracle Database Support of changes Customer
System-level administration CDT
Assist Customers in restoring a database 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 CDT
Monitor and tune Oracle database CDT
Review and recommend optional configurations that may better meet capacity and performance requirements 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
Data cleansing Customer
Identify and report database problems to the CDT Service Desk Customer
Database capacity planning and ongoing monitoring of database growth in relation to disk space Customer
- Oracle database support outside of core support hours is available upon receipt of an approved CDT Case/Request. The Case/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.
The rate schedule represents standard CDT services. If a Customer requires technology solutions that are not part of the standard, CDT will review the Customer’s request and provide customized pricing as necessary.
Service Description Service Identifier Product Name Unit of Measurement Rate Service Code Notes
CDT Processing Fee on Pass-through Products Pass-through Fee Dedicated Expenses % of Direct Pass-Through Costs - Per Purchase Order Pass-through + 2.71% CDT
D101 - Pass-Through The CDT Processing Fee of 2.71% on pass-through products includes the DGS 1.25% purchase order issuance fee.
Database Instance Installation Set-up Fee for Database Support - Tier 2 (Oracle, Informix*, Sybase*, and Cache*) Tier 2-Database Support Database Support One-Time/Per Instance $690.00 M623 *Software is in containment & unavailable for new systems, upgrades or migrations of existing systems.
Tier 2 Database Support (Oracle) Tier 2-Database Support Database Support Monthly/Per Instance $1,170.00 M622
To submit a Case/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 Case/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.
Cases/Requests are revised at appropriate intervals providing for the 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 Case/Request.||Request a Change to a Current Database or a Decommission|
|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 Case/Request|