Oracle Database Appliance software configuration defaults.
Locate 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 |
|
Grid base |
|
Oracle home |
|
Oracle base |
|
Oracle Inventory |
|
Log files are available for actions performed in the command-line interface and Web Console and are useful when you need to track and debug jobs.
You can also use the Oracle Appliance Manager Web Console to view job activity, including the tasks that make up the job. The status of each task appears in the Web Console 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
directory.
Patching Log Files
All patching-related information is logged in the dcs-agent
log file at /opt/oracle/dcs/log/dcs-agent.log
.
DCS Agent Log Directories
Agent-specific activities are logged in the dcs-agent
log.
The DCS Agent, controller, and command-line interface output appears in the /opt/oracle/dcs/log/dcs-agent.log
file.
If an error occurs in the command-line interface layer, then the output will show in the /opt/oracle/dcs/log/dcscli.log
file first.
Storage Logs
Storage-related activity is logged in the oakd
log file.
/opt/oracle/oak/log/hostname/oak/oakd.log
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
log file.
/opt/oracle/oak/log/hostname/oakdiag/file name.tar.gzFor example,
/opt/oracle/oak/log/myhost/oakdiag/oakStorage-myhost-20161120_2217.tar.gz
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.
Oracle Auto Service Request (Oracle ASR) Log Files
All log files for Oracle ASR are located in the /var/opt/asrmanager/log/
directory.
Review the groups and default users when you use the Web Console to deploy the appliance. All passwords are set to the Master 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 |
|
Oracle Database installation owner |
|
Oracle Database system administrator |
|
Oracle Database generic administrator |
|
Oracle Inventory system privileges group |
|
Oracle ASM Administrators system privileges |
|
Oracle ASM Users system privileges |
|
Oracle ASM Operator system privileges |
|
Oracle Database Administrators system privileges |
|
Oracle Database Operator system privileges |
|
Oracle Groups and User Configurations
You can use the Web Console 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
.
Review the system configuration for Oracle Database Appliance.
Table A-2 System Configuration for Oracle Database Appliance
Item | Value |
---|---|
Oracle Linux with the Red Hat-compatible kernel |
Oracle Linux 6.8 with 4.1.12-94.4.1.el6uek.x86_64 |
Oracle Database release |
12.2.0.1.170814, 12.1.0.2.170814 and 11.2.0.4.170814 Oracle Database Enterprise Edition, Oracle Database Standard Edition 2, Oracle Database Standard Edition 1, Oracle Database Standard Edition |
Oracle Enterprise Manager Express 12c (EM Express) |
Port 5500 is the first port that is used by EM Express. Each subsequent database configured with EM Express uses the next available port number. For example, port 5501. To access Oracle Enterprise Manager, enter the following URL string, where
|
Oracle Enterprise Manager 11.2 database console (EM DB Console) |
Port 1158 is the first port that is used by EM DB Console. Each subsequent database configured with EM DB Console uses the next available port number. For example, port 1159. To access Oracle Enterprise Manager, enter the following URL string, where
|
Change the administrative account passwords to secure your system.
During deployment, the root
and database users SYS
, SYSTEM
and PDBADMIN
are set to the master password. After deployment, the oracle
and grid
passwords are also set to the master password.
To log into the Web Console, the default user name is oda-admin and the default password is welcome1.
Note:
Change the passwords to comply with your enterprise user security protocols.
Refer to the Oracle Database Appliance Security Guide and Oracle Database Security Guide for information about the required configuration and best practices to secure database systems.