Oracle学习笔记

$dbca  //启动安装图形界面
1.选General Purpose
2.Name oradb
password aaa

3
storage mechanism：filesystem

file location variables：
ORACLE_BASE1 /u01
ORACLE_BASE2 /u02

在这两个目录下分别建 /u01/arch  /u02/arch

4 specify 不选
选 enable


5 Menory
选custom
选Manual
share pool：
全部改为M单位
256 48 150 150 20

6 character sets

choose：
ZHS16GBK

National Character set：
AL16UTF16-Unicode UTF-16 Universal Character set
default language ：simplified Chinese
DDF ： China


7 把文件分散在各个文件夹中
controlfile：
control01.ctl ORACLE_BASE1
control02.ctl ORACLE_BASE2
control03.ctl ORACLE_BASE1

datafiles：
sys ORACLE_BASE1
undo ORACLE_BASE2
sys ORACLE_BASE1

8 create database

redo log groups：
1 ORACLE_BASE1
2 ORACLE_BASE12
3 ORACLE_BASE1


创建监听：
$netca
next.....
配置监听
$netmgr

listener
listening->database service -> add database -> name:oradb sid:oradb

lsnrctl reload //重启监听
sqlplus '/ as sysdba'
SQL>shutdown immediate 关闭数据库

lsnrctl stop //关监听


oemapp dbastudio  //图形管理界面
这是9i 的命令
[oracle@localhost ~]$ oemapp dbastudio
bash: oemapp: command not found

[oracle@localhost ~]$ emctl start dbconsole
TZ set to Asia/Chungking
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://localhost.localdomain:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
[oracle@localhost ~]$

在浏览器中输入：
http://localhost.localdomain:1158/em/console/aboutApplication
接下来……还不懂。