Oracle数据库工具的使用_CentOS7

1.DBCA(Database Configuration Assistant)

Start DBCA

   ORACLE_HOME/bin/dbca

Create 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"

转载于:https://www.cnblogs.com/offgoing/p/6070228.html