A Oracle Database Appliance Software Configuration Defaults

Oracle Database Appliance software configuration defaults.

Directory Paths for Oracle Database Appliance

Understand the storage and mount configuration file paths for Oracle Database Appliance.

Directory Paths for Oracle Database Appliance

Oracle homes on Oracle Database Appliance follow Optimal Flexible Architecture guidelines.

Item Directory Path

Grid home

/u01/app/release-specific_name/gi owner

Grid base

/u01/app/gi owner

Oracle home

/u01/app/odaorahome/rdbms owner/product/rdbms_version/dbhome_home_sequence_number

Oracle base

/u01/app/odaorabase/rdbms owner

Oracle Inventory


Java Runtime Environment (JRE)


Java SDK


Oracle ACFS file system


Starting with Oracle Database Appliance release 19.12, a new Oracle ACFS file system is created to store the Oracle Database and Oracle Grid Infrastructure clone files. The DATA disk group provides a space of 150 GB for the file system.

Location of Log Files

Log files are available for actions performed in the command-line interface and Browser User Interface and are useful when you need to track and debug jobs.

You can also use the Oracle Appliance Manager Browser User Interface to view job activity, including the tasks that make up the job. The status of each task appears in the Browser User Interface and you can drill down to get greater details.

If you log a Service Request, upload all of the logs in the /opt/oracle/dcs/log and /opt/oracle/dcs/dcscli/log directories.

Patching Log Files

All patching-related information is logged in the dcs-agent log in the directory /opt/oracle/dcs/log/.

DCS Agent Log Directories

Agent-specific activities are logged in the dcs-agent log.

The DCS Agent, controller, and command-line interface output are stored in the directory /opt/oracle/dcs/log/.

If an error occurs in the command-line interface layer, then the output will show in the /opt/oracle/dcs/dcscli/log/dcscli.log file first.

DCS Components Log Directories

The Zookeeper logs are stored in the directory /opt/zookeeper/log/. The Zookeeper logs are zkMonitor.log, zookeeper.log, and zookeeper.out.

The MySQL logs are stored in the log /opt/oracle/dcs/mysql/log/mysqldb.log. The log contains information about MySQL such as startup, shutdown, connection transaction details, and errors encountered when running MySQL.

Storage Logs

Storage-related activity is logged in the oakd log file.


For example, /opt/oracle/oak/log/myhost/oak/oakd.log

Use the odaadmcli manage diagcollect command to collect diagnostic logs for storage components. The files are saved in the oakdiag directory.

/opt/oracle/oak/log/hostname/oakdiag/file name.tar.gz
For example, /opt/oracle/oak/log/myhost/oakdiag/oakStorage-myhost-20161120_2217.tar.gz

Upgrade using Data Preserving Reprovisioning Logs

The odaupgradeutil utility logs are stored at opt/oracle/oak/restore/log.

Database Logs

Online logs are stored in the /u03/app/db_user/redo/ directory.

Oracle Fast Recovery Area (FRA) is located in the /u03/app/db_user/fast_recovery_area directory.

Database alert logs are stored in the location $ORACLE_BASE/diag/rdbms/database_unique_name.

Oracle Auto Service Request (Oracle ASR) Log Files

All log files for Oracle ASR are located in the /var/opt/asrmanager/log/ directory.

Oracle Groups and User Configurations for Oracle Database Appliance

Review the groups and default users created when you deploy the appliance. All passwords are set to the password that you define during deployment.

Default Operating System Groups and User Configurations

Table A-1 Default Operating System Groups and Users Configuration for Oracle Database Appliance

Groups and Users Default Value

Oracle Grid Infrastructure installation owner

grid, UID 1001

Oracle Database installation owner

oracle, UID 1000

Oracle Database system administrator


Oracle Database generic administrator


Oracle Inventory system privileges group

oinstall, GID 1001

Oracle ASM Administrators system privileges

asmadmin, GID 1004

Oracle ASM Users system privileges

asmdba, GID 1006

Oracle ASM Operator system privileges

asmoper, GID 1005

Oracle Database Administrators system privileges

dba, GID 1003

Oracle Database Operator system privileges

dbaoper, GID 1002

Oracle Groups and User Configurations

You can use the Browser User Interface or the odacli create-appliance command and a JSON file to deploy the appliance. The following configurations are supported:

  • 2 Users with 6 groups (operating system role separation)

  • Single User with 6 groups (no operating system role separation)

  • Single user with 2 groups (no operating system role separation)

You can customize groupname, username, and UID.