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

Oracle數(shù)據(jù)庫安裝及使用Linux,2008-09-23測試運維部郭渝鋒Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第1頁!內(nèi)容列表數(shù)據(jù)庫的概述Oracle數(shù)據(jù)庫的安裝（Suse)Oracle數(shù)據(jù)庫的使用Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第2頁!Oracle數(shù)據(jù)庫的安裝系統(tǒng)所需最小RAM為512MB，而所需最小交換空間為1GB安裝Suse選擇所需的軟件包時，請勾選OracleServerBaseC/C++CompilerandToolsLogout系統(tǒng)用oracle登錄exportORACLE_HOME=/opt/oracle/product/10.2.0/db_1exportORACLE_SID=testo安裝目錄及實例ID運行runInstaller-ignoreSysPreReqsOracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第3頁!Oracle數(shù)據(jù)庫的安裝Basicinstallation,快速，缺省的選項Advancedinstallation，靈活，自定義的選項EnterpriseEdition數(shù)據(jù)庫名稱：SID：實例名稱選擇數(shù)據(jù)庫字符集SimplifiedChineseZHS16GBKRecoveryAreaLocation輸入并確認(rèn)密碼sys用戶,普通用戶Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第4頁!Oracle數(shù)據(jù)庫的使用SQL>startup

ORACLEinstancestarted.TotalSystemGlobalArea167772160bytes

FixedSize1218316bytes

VariableSize83888372bytes

DatabaseBuffers79691776bytes

RedoBuffers2973696bytes

Databasemounted.

Databaseopened.

Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第5頁!Oracle數(shù)據(jù)庫的使用oracle@CMS:~/product/10.2/db_1/network/admin>moretnsname.oraTESTO=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.240)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=testo)))Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第6頁!Oracle數(shù)據(jù)庫的使用數(shù)據(jù)庫查詢操作語言SQL（StructuredQueryLanguage）查詢select*fromsalaryselectnamefromsalary添加insertintosalary(‘張三’,30)刪除deletefromsalarywherename=‘王二’Namesalary王二20Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第7頁!Oracle數(shù)據(jù)庫的使用oracle@oracle:~>sqlplus/assysdbaSQL*Plus:Release10.2.0.1.0-ProductiononSatJul717:35:042007Copyright(c)1982,2005,Oracle.Allrightsreserved.

Connectedto:

OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production

WiththePartitioning,OLAPandDataMiningoptionsSQL>shutdownimmediate

Databaseclosed.

Databasedismounted.

ORACLEinstanceshutdown.

SQL>exit

Oracle數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第8頁!Oracle數(shù)據(jù)庫的使用oracle@CMS:~/product/10.2/db_1/network/admin>morelistener.ora#listener.oraNetworkConfigurationFile:/opt/oracle/product/10.2/db_1/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.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數(shù)據(jù)庫安裝及使用共11頁，您現(xiàn)在瀏覽的是第9頁!Oracle數(shù)據(jù)庫的使用Sqlplususer/password@testols