Oracle数据库安装及使用.ppt

Oracle 数据库安装及使用,Linux, 2008-09-23,测试运维部 郭渝锋,内容列表,数据库的概述 Oracle 数据库的安装（Suse) Oracle 数据库的使用,Oracle数据库的安装,系统所需最小 RAM 为 512MB，而所需最小交换空间为 1GB 安装Suse选择所需的软件包时，请勾选 Oracle Server Base C/C+ Compiler and Tools Logout系统用oracle登录 export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1 export ORACLE_SID=testo 安装目录及实例ID 运行runInstaller -ignoreSysPreReqs,Oracle数据库的安装,Basic installation,快速，缺省的选项 Advanced installation，灵活，自定义的选项 Enterprise Edition 数据库名称： SID：实例名称 选择数据库字符集 Simplified Chinese ZHS16GBK Recovery Area Location 输入并确认密码 sys用户, 普通用户,Oracle数据库的使用,oracleoracle: sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - 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 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL exit,Oracle数据库的使用,SQL startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 83888372 bytes Database Buffers 79691776 bytes Redo Buffers 2973696 bytes Database mounted. Database opened.,Oracle数据库的使用,oracleCMS:/product/10.2/db_1/network/admin more listener.ora # listener.ora Network Configuration File: /opt/oracle/product/10.2/db_1/network /admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/product/10.2/db_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1) (ADDRESS = (PROTOCOL = TCP)(HOST = CMS.temobi)(PORT = 1521) ) ),Oracle数据库的使用,oracleCMS:/product/10.2/db_1/network/admin more tnsname.ora TESTO = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.240) (PORT = 1521) ) ) (CONNECT_DATA = (SERVICE_NAME = testo) ) ),Oracle数据库的使用,Sqlplus user/passwordtesto lsnrctl start lsnrctl stop lsnrctl status,Oracle数据库的使用,数据库查询操作语言 SQL（Structured Query Language ） 查询 select * from salary select name fr