After running the scm_prepare_database.sh
script, there is additional configuration required.
You must run the scm_prepare_database.sh
before
continuing with the following steps.
- Log in to the Cloudera Manager server host using
ssh.
- Edit the
/etc/cloudera-scm-server/db.properties
file and add
the following properties:
com.cloudera.cmf.orm.hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
com.cloudera.cmf.orm.hibernate.connection.username=[***Oracle username***]
com.cloudera.cmf.orm.hibernate.connection.password=[***Oracle password***]
com.cloudera.cmf.orm.hibernate.connection.url=jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=off)(FAILOVER=on)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(ADDRESS=(PROTOCOL=TCP)(HOST=[***Oracle hostname***])(PORT=[***Oracle host port number***]))(CONNECT_DATA=(SERVICE_NAME=JOL)))
- If you have configured Cloudera Manager for high availability
with active and passive instances of the Cloudera Manager server,
repeat the above steps for the other Cloudera Manager server instance.
- (Optional) If you do not want to expose the password in the
db.properties
file, you can create a script that
outputs the password of the database upon its execution. You can then
add this script to the
/etc/cloudera-scm-server/db.properties
file.
A sample script:
cat > /[***path***]/retrieve_db_password.sh
echo "[***my_database_password***]"
Add
the script to the
db.properties
file:
com.cloudera.cmf.db.password_script=/[***path***]/retrieve_db_password.sh
Continue with the CDP Private Cloud Base Production
Installation steps.