CDH的oracle database配置.doc

Cloudera C Training Support Documentation Dev Center |Contact Us Downloads lt;pgt;JavaScript must be enabled in order to use this site.lt;/pgt;lt;pgt;Please enable JavaScript in your browser and refresh the page.lt;/pgt; This is the documentation for Cloudera聽5.3.x. Documentation for other versions is available at Cloudera Documentation. Oracle Database To use an Oracle database, follow these procedures. Collecting Oracle Database Information Configuring the Oracle Server Installing the Oracle JDBC Connector Creating Databases for the Cloudera Manager Server, Activity Monitor, Reports Manager, Hive Metastore Server, Sentry Server, Cloudera Navigator Audit Server, and Cloudera Navigator Metadata Server Collecting Oracle Database Information To configure Cloudera Manager to work with Oracle databases, get the following information from your Oracle DBA: Host name - The DNS name or the IP address of the host where the Oracle database is installed. SID - The name of the database that will store Cloudera Manager information. Username - A username for each schema that is storing information. You could have four unique usernames for the four schema. Password - A password corresponding to each user name. Configuring the Oracle Server Adjust Oracle Settings to Accommodate Larger Clusters Cloudera Management services require high write throughput. Depending on the size of your deployments, your DBA may need to modify Oracle settings for monitoring services. These guidelines are for larger clusters and do not apply to Cloudera Manager configuration database and to smaller clusters. Many factors help determine whether you need to change your database settings, but in most cases, if your cluster has more than 100 hosts, you should consider making the following changes: Enable direct and asynchronous I/O by setting the FILESYSTEMIO_OPTIONS parameter to SETALL. Increase the RAM available to Oracle by changing the MEMORY_TARGET parameter. The amount of memory to assign depends on