8 Getting Started with Oracle Database

Learn how to check the installed contents, start various tools, identify, and locate various files after completing Oracle Database installation.

• Checking the Installed Oracle Database Contents and Directory Location
  Use Oracle Universal Installer to check the contents and directory location of your Oracle Database installation.
• Logging In to Oracle Enterprise Manager Database Express 12c
  To start Oracle Enterprise Manager Database Express, use the EM Express URL provided by Oracle Database Configuration Assistant (Oracle DBCA) during the database installation and creation.
• Managing Oracle Automatic Storage Management
  Describes about starting and stopping Oracle Automatic Storage Management.
• Starting and Stopping an Oracle Database
  Describes about starting and stopping an Oracle database by using any of the following methods:
• Accessing Oracle Database with SQL*Plus
  You can use SQL*Plus to issue SQL and PL/SQL statements to the Oracle Database.
• Accessing Oracle Database with Oracle SQL Developer
  You can use SQL Developer to issue SQL and PL/SQL statements. All SQL and PL/SQL commands are supported as they are passed directly from the SQL Worksheet to the Oracle Database.
• Reviewing User Accounts and Passwords
  All databases created by the Oracle Database Configuration Assistant include the SYS, SYSTEM, and DBSNMP database accounts.
• Identifying Databases
  The Oracle Database software identifies a database by its global database name.
• Locating the Server Parameter File
  The starter database contains one database initialization response file. The initialization response file, init.ora.xxxxx, must exist for an instance to start.
• Identifying Tablespaces and Data Files
  An Oracle Database is divided into smaller logical areas of space known as tablespaces.
• Locating Redo Log Files
  The preconfigured database uses three redo log files. Redo log files record all changes made to data in the database buffer cache.
• Locating Control Files
  The preconfigured database contains two control files located in the ORACLE_BASE\oradata\DB_NAME directory.
• Understanding Oracle Database Services on Windows
  The following Oracle services are automatically started after installation when you create a database: