8 Oracle Appliance Manager Web Console

Oracle Appliance Manager Web Console provides a user-friendly interface to view and create databases and view job activity.

Topics:

About the Oracle Appliance Manager Web Console

Use the Oracle Appliance Manager Web Console to view and create databases and to view job activity.

The Web Console assists you to deploy Oracle Databases that follow Optimal Flexible Architecture guidelines. The Optimal Flexible Architecture standard provides best practices configurations to help to ensure database deployments that are easier to support and maintain. Optimal Flexible Architecture includes the following:

  • Structured organization of directories and files, and consistent naming for critical database files, such as control files, redo log files, and other critical files, which simplifies database administration.

  • Separation of tablespace contents to minimize tablespace free space fragmentation, and maximize administrative flexibility

  • Stripe and Mirror Everything (SAME) deployment, which safeguards against database failures

The Web Console provides a user-friendly option to perform the following tasks:

  • Deploy the appliance

  • View existing databases

  • Create databases

  • View job activity

Note:

Create Oracle Databases using the Web Console or command-line interface to ensure that your database is configured optimally for Oracle Database Appliance.

Refer to Oracle Appliance Manager Command-Line Interface for the lifecycle tasks that you can perform with the command-line interface.

Refer to "Optimal Flexible Architecture" in Oracle Database Installation Guide for Linux for more information about Optimal Flexible Architecture.

Creating Databases with the Web Console

Use the Oracle Appliance Manager Web Console to create databases in Oracle Database Appliance.

You cannot use the Web Console to create a database on an existing (ORACLE_HOME). When you use the Web Console to create databases, a new database home is created for each database. To create a database using an existing Oracle Database Home (ORACLE_HOME), use the odacli create-database --dbhomeid command. See odacli create-database for more information about using the command-line to create a database.
  1. Open a browser and enter the following URL to launch the Web Console:
    https://ip-address:7093/mgmt/index.html
  2. Enter the following credentials:
    • User name: oda-admin
    • Password: welcome1
  3. Click the Databases tab.
  4. Click Create Database.
  5. Enter the following information to configure the database, then click Next:
    1. DB Name: Enter a name for the database.
      The name must contain alphanumeric characters and cannot exceed 8 characters. If you have multiple databases, the value of this parameter should match the Oracle instance identifier of each one to avoid confusion with other databases running on the system.
    2. DB Version: Select a version.
    3. CDB: Select Yes or No, depending on whether or not you want the database to be a container database (CDB).
    4. PDB Name: Enter a name for the pluggable database (PDB).
      The name must begin with an alphanumeric character. The following characters are valid: alphanumeric characters, and underscore (_).
    5. Configure EM Console: Select Yes or No.
      Select Yes to configure the Oracle Enterprise Manager Database Express (EM Express) console for Oracle Database 12.1.0.2 or the Database Control Console for Oracle Database 11.2.0.4. Selecting Yes enables you to use the console to manage the database.
    6. Characterset: Select a characterset.
    7. National Characterset: Select a national characterset.
    8. Language: Select the database language.
    9. Territory: Select a territory or location for the database from the list.
    10. Class: Select a database class from the list, OLTP, DSS, or IMDB.
    11. Shape: Select a database shape from the list.
    12. Storage Type: Select ACFS or ASM
    13. Password: Enter a password.
      The password must begin with an alpha character and cannot exceed 30 characters. Quotation marks are not allowed.
    14. Confirm Password: Enter the password again to confirm.
  6. Click Submit. When prompted, click Yes to confirm that you want to start the job to create the database.
The job is submitted and a confirmation page appears with a link to the job. Click the link to view the job progress, tasks, and status. Click the job number to view the tasks.
After you close the Job confirmation page, you can click the Activity tab to monitor the job progress. Click the job number to view the tasks and status details.

Viewing Job Activity

Use the Oracle Appliance Manager Web Console to view job activity, the status of tasks in a job, and job status.

  1. Open a browser and enter the following URL to launch the Web Console:
    https://ip-address:7093/mgmt/index.html
  2. Enter the following credentials:
    • User name: oda-admin
    • Password: welcome1
  3. Click Activity.
    The jobs page displays recent jobs, the job name, status, and details. Click the job name to display greater details about the job, including the tasks that make up the job.