Oracle数据库安装及使用

Haga clic para modificar el estilo de ttulo,Haga clic para modificar los estilos de texto del patrn,Segundo nivel,Tercer nivel,Cuarto nivel,Quinto nivel,*,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_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-ProductionWith the Partitioning,OLAP and Data Mining options,SQL 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.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 from salary,添加,insert into salary(张三,30),删除,delete from salary where name=王二,Name,salary,王二,20,End,day day UP!,good good Study!,