Oracle数据库安装及使用.ppt

Oracle 数据库安装及使用
Linux, 2008-09-23
测试运维部 郭渝锋
1
可编辑ppt
内容列表
数据库的概述
Oracle 数据库的安装（Suse)
Oracle 数据库的使用
2
可编辑ppt
Oracle数据库的安装
系统所需最小 RAM 为 512MB，而所需最小交换空间为 1GB
安装Suse选择所需的软件包时，请勾选
Oracle Server Base
C/C++ Compiler and Tools
Logout系统用oracle登录
export ORACLE_HOME=/opt/oracle/product/
export ORACLE_SID=testo
安装目录及实例ID
运行runInstaller -ignoreSysPreReqs
3
可编辑ppt
Oracle数据库的安装
Basic installation,快速，缺省的选项
Advanced installation，灵活，自定义的选项
Enterprise Edition
数据库名称：
SID：实例名称
选择数据库字符集
Simplified Chinese ZHS16GBK
Recovery Area Location
输入并确认密码
sys用户, 普通用户
4
可编辑ppt
Oracle数据库的使用
******@oracle:~> sqlplus / as sysdba
SQL*Plus: Release - Production on Sat Jul 7 17:35:04 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:Oracle Database 10g Enterprise Edition Release - ProductionWith the Partitioning, OLAP and Data Mining options
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.
SQL> exit
5
可编辑ppt
Oracle数据库的使用
SQL> startupORACLE instance started.
Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 83888372 bytesDatabase Buffers 79691776 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.
6
可编辑ppt
Oracle数据库的使用
******@CMS:~/product/> more
# Network Configuration File: /opt/oracle/product/
/admin/
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
)
7
可编辑ppt
Oracle数据库的使用
******@CMS:~/product/> more
TESTO =
(DESC