Oracle数据库安装及使用

Name 王二
salary 20
End
day day UP! good good Study!
测试运维部 郭渝锋
Oracle 数据库安装及使用
Linux, 2008-09-23
内容列表
数据库的概述 Oracle 数据库的安装（Suse) Oracle 数据库的使用
Oracle数据库的安装
系统所需最小 RAM 为 512MB，而所需最小交换空间 为 1GB
安装Suse选择所需的软件包时，请勾选 Oracle Server Base C/C++ Compiler and Tools
Basic installation,快速，缺省的选项 Advanced installation，灵活，自定义的选项
Enterprise Edition 数据库名称：
SID：实例名称 选择数据库字符集
Simplified Chinese ZHS16GBK Recovery Area Location 输入并确认密码
数据库查询操作语言 SQL（Structured Query Language ）
查询 select * from salary select name from salary
添加 insert into salary(‘张三’, 30)
删除 delete from salary where name=‘王二’
/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))
Logout系统用oracle登录 export
ORACLE_HOME=/opt/oracle/product/10.2.0/db_1 export ORACLE_SID=testo 安装目录及实例ID 运行runInstaller -ignoreSysPreReqs
Oracle数据库的安装
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.
sys用户, 普通用户
Oracle数据库的使用
oracle@oracle:~> 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.
Oracle数据库的使用
oracle@CMS:~/product/10.2/db_1/network/admin> more listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/10.2/db_1/network
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.
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = testo)
)
)
Oracle数据库的使用
Sqlplus user/password@testo lsnrctl start lsnrctl stop lsnrctl status
Oracle数据库的使用
)
)
Oracle数据库的使用
oracle@CMS:~/product/10.2/db_1/network/admin> more tnsname.ora
TESTO =
(DESCRIPTION =
(ADDREHale Waihona Puke BaiduS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.2.240)