1.DBCA(Database Configuration Assistant)
Start DBCA
ORACLE_HOME/bin/dbcaCreate a Database
General purpose or transaction processing/Data warehouse/Custom Database
Database Identification Global Database Name = SID.domain_name
Configure Enterprise Manager
Register with Grid Control for centralized management
Configure Database Control for local management
Database Credentials specify the passwords for administrative accounts
Database File Locations
Use Database File Locations from Template
Use Common Location for All Database Files
Use Oracle Managed Files
Multiplex Redo Logs and Control Files
Recovery Configuration
Specify Fast Recovery Area
Enable Archiving
Database Content
Sample Schemas
Custom Scripts
Initialization Parameters
Memory
Typical
Custom
Automatic Shared Memory Management
Manual Shared Memory Management
Sizing
Block Size
Processes simultaneously Connect
Character Sets
Database Character Set
Use the Default
Use Unicode(AL32UTF8)
Choose from the list of character sets
National Character Set
Default Language
Default Territory decimal\currency\ISO
Connect Mode
Dedicated Server Mode
Shared Server Mode
Database Storage
Creation Options
Create Database
Save as a Database Template
Generate Database Creation Scripts
Changing the Configuration
Register the database with Grid Control
Configure Database Control alert notification via e-mail
Enable daily disk backups to the recovery area
Change default security settings
Change server mode from dedicated to shared, or the reverse
Add database options that were not previously configured (for example, Oracle Label Security or Oracle OLAP)
Deleting a Database
Managing Templates ORACLE_HOME/assistants/dbca/templates
Creating Templates
From an existing template
From an existing database (structure only)
From an existing database (structure as well as data)
Deleting Templates
2.Configuring the OS Environment Variables
use Terminal /usr/local/bin/oraenv
vim /etc/.bash_profile or /home/oracle/.bash_profile
set ORACLE_SID and ORACLE_HOME
add $ORACLE_HOME/bin to PATH
3.Starting and Stopping Database Control Console Process
set ORACLE_UNQNAME Database SID
emctl start/stop/status dbconsole
4.Accessing the Database Home Page
https://hostname:portnumber/em
Creating Database Control Administrative Users
Setting Database Contrl Preferences: Notification/Blackout Administration/Preferred Credentials
5.SQL-Based Management Tools
SQL
ORACLE_HOME/bin/SQL*Plus:sqlplus {username | /} [as sysdba]
SQL Developer
Oracle Net Listener Configuration
$ORACLE_HOME/network/admin/listener.ora
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521)))
(CONNECT_DATA= (SERVICE_NAME=mydb.example.com))
Naming Methods
Easy Connect Naming:TCP/IP
Local Naming: $ORACLE_HOME/network/admin/tnsnames.ora
Directory Naming:emsp;LDAP-compliant directory server
Tools for Network Configuration
NETCA(Net Configuration Assistant)
Oracle Enterprise Manager
Oracle Net Manager
lsnrctl status/start/stop&emsp启动停止监听器,查看状态
sqlplus
user:name@"host[:port][/service_name][:server][/instance_name]"
service_name=DB_NAME.DB_DOMAIN
server=dedicated/shared/pooled
instance_name=INSTANCE_NAME
nick@"192.0.2.1/orcl.example.com" nick@"[2001:0DB8:0:0::200C:417A]/orcl.example.com"