linux下oracle10g的安装教案解析.pptVIP

Typical User Privileges After the DBA creates a user, the DBA can assign privileges to that user. In the syntax: privilege is the system privilege to be granted user |role|PUBLIC is the name of the user, the name of the role, or PUBLIC designates that every user is granted the privilege Note: Current system privileges can be found in the SESSION_PRIVS dictionary view. Typical User Privileges After the DBA creates a user, the DBA can assign privileges to that user. In the syntax: privilege is the system privilege to be granted user |role|PUBLIC is the name of the user, the name of the role, or PUBLIC designates that every user is granted the privilege Note: Current system privileges can be found in the SESSION_PRIVS dictionary view. 1-* Copyright ? 2004, Oracle. All rights reserved. 1 Copyright ? 2004, Oracle. All rights reserved. Linux下Oracle的安装 学习目标 通过本次学习您将掌握如下内容: 了解oracle软件结构 了解oracle软件安装 了解oracle数据库结构 了解oracle手工建库步骤 Linux常用命令 df -h ifconfig free top cp ls cd vi 安装目录与文件命名规范(OFA) 挂载点命名: /u01 /disk01 目录命名: /u01/app/oracle /u01/app/oracle/admin /u01/app/oracle/product/db_1 文件命名: Control files: controln.ctl Redo log files: redon.log Data files: tn.dbf 设置环境变量 ORACLE_BASE: 部署oracle的根目录 ORACLE_HOME: oracle软件存放于此 ORACLE_SID: 实例名(ORCL by default) NLS_LANG: 语言字符集 Oracle实例管理 System Monitor SMON Database Writer DBW0 Log Writer LGWR Process Monitor PMON Archiver ARC0 SGA Java Pool Shared Pool Large Pool Streams Pool Database Buffer Cache Redo Log Buffer Check point CKPT Oracle内存结构 Java Pool Database Buffer Cache Redo Log Buffer Shared Pool Large Pool SGA Streams Pool Server Process 1 PGA Server Process 2 PGA Back- ground Process PGA Data files Online redo log files Password file Parameter file Archive log files Control files 数据库结构 创建一个数据库 orapwd file=orapwtest password=oracle entries=5 [oracle@testc dbs]$ more inittest.ora db_name=test db_block_size=8192 sga_target=300m SQL alter system set db_create_file_dest=/data/test; SQL alter system set