Oracle數(shù)據(jù)庫安裝及使用ppt課件

1、Oracle 數(shù)據(jù)庫安裝及使用Linux, 2019-09-23測試運維部測試運維部 郭渝鋒郭渝鋒內(nèi)容列表l數(shù)據(jù)庫的概述lOracle 數(shù)據(jù)庫的安裝Suse)lOracle 數(shù)據(jù)庫的使用Oracle數(shù)據(jù)庫的安裝l系統(tǒng)所需最小 RAM 為 512MB，而所需最小交換空間為 1GB l安裝Suse選擇所需的軟件包時，請勾選l Oracle Server Basel C/C+ Compiler and ToolslLogout系統(tǒng)用oracle登錄lexport ORACLE_HOME=/opt/oracle/product/10.2.0/db_1l export ORACLE_SID=testol

2、 安裝目錄及實例IDl運行runInstaller -ignoreSysPreReqsOracle數(shù)據(jù)庫的安裝lBasic installation,快速，缺省的選項l Advanced installation，靈敏，自定義的選項lEnterprise Editionl數(shù)據(jù)庫名稱：l SID：實例名稱l選擇數(shù)據(jù)庫字符集l Simplified Chinese ZHS16GBKlRecovery Area Location l輸入并確認密碼l sys用戶, 普通用戶Oracle數(shù)據(jù)庫的使用loracleoracle: sqlplus / as sysdbal SQL*Plus: Release

3、 10.2.0.1.0 - Production on Sat Jul 7 17:35:04 2019l Copyright (c) 1982, 2019, Oracle. All rights reserved.l Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionslSQL shutdown immediateDatabase closed.Database dismounte

4、d.ORACLE instance shut down.lSQL exitOracle數(shù)據(jù)庫的使用lSQL startupORACLE instance started.l Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 83888372 bytesDatabase Buffers 79691776 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.Oracle數(shù)據(jù)庫的使用loracleCMS:/product

5、/10.2/db_1/network/admin more listener.oral# listener.ora Network Configuration File: /opt/oracle/product/10.2/db_1/networkl/admin/listener.oral# Generated by Oracle configuration tools.lSID_LIST_LISTENER =l (SID_LIST =l (SID_DESC =l (SID_NAME = PLSExtProc)l (ORACLE_HOME = /opt/oracle/product/10.2/d

6、b_1)l (PROGRAM = extproc)l )l )lLISTENER =l (DESCRIPTION_LIST =l (DESCRIPTION =l (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)l (ADDRESS = (PROTOCOL = TCP)(HOST = CMS.temobi)(PORT = 1521)l )l )Oracle數(shù)據(jù)庫的使用loracleCMS:/product/10.2/db_1/network/admin more tnsname.oralTESTO = l (DESCRIPTION = l (ADDRESS_

7、LIST = l (ADDRESS = l (PROTOCOL = TCP)l (HOST = 192.168.2.240)l (PORT = 1521)l )l )l (CONNECT_DATA = l (SERVICE_NAME = testo)l )l )Oracle數(shù)據(jù)庫的使用lSqlplus user/passwordtestollsnrctl startllsnrctl stopllsnrctl statusOracle數(shù)據(jù)庫的使用l數(shù)據(jù)庫查詢操作語言l SQLStructured Query Language ）l查詢l select * from salaryl select name from salaryl