9 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 19c
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 theSYS
,SYSTEM
, andDBSNMP
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 theORACLE_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: