Oracle数据库安装及使用.ppt

Oracle 数据库安装及使用,Linux,2008-09-23,测试运维部 郭渝锋,内容列表,数据库的概述Oracle 数据库的安装（Suse)Oracle 数据库的使用,Oracle数据库的安装,系统所需最小 RAM 为 512MB，而所需最小交换空间为 1GB 安装Suse选择所需的软件包时，请勾选 Oracle Server Base C/C+Compiler and ToolsLogout系统用oracle登录 export ORACLE_SID=testo 安装目录及实例ID运行runInstaller-ignoreSysPreReqs,Oracle数据库的安装,Basic installation,快速，缺省的选项 Advanced installation，灵活，自定义的选项Enterprise Edition数据库名称：SID：实例名称选择数据库字符集 Simplified Chinese ZHS16GBKRecovery 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-ProductionWith the Partitioning,OLAP and Data Mining optionsSQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL exit,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.,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.oraTESTO=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.240)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=testo),Oracle数据库的使用,Sqlplus user/passwordtestolsnrctl startlsnrctl stoplsnrctl status,Oracle数据库的使用,数据库查询操作语言 SQL（Structured Query Language）查询 select*from salary select name from salary添加 insert into salary(张三,30)删除 delete from salary where name=王二,End,day day UP!good good Study!,