ORACLE课件 第1章 Oracle数据库基础

1OracleSQL2SELECTOracle3Oracle2.5ppt4•••••••••••5•–•–•3–––6Database7••8•–DBMSDatabaseManagementSystemDBMSDBMS–•E-RE-R9•–DBMS(NetworkDataModel)(HierarchicalDataModel)DBMS–•10•–DBMSDBMS•–––11•••••12••1•1•13•3–––•••••••14••––––1516•–1969IBMIMS–1970IBMEFCoddsysemRInges–17nl(IBMIMS)ll18nlll:(1:1)(1:M)12M:M)19•DatabaseManagementSystemDBMS):––Oracle,,•–1.DDL–2.DML–3.DBMS–4.20(DataBaseSystem)•–Database,DB–DatabaseManagementSystem,DBMS–)–DatabaseAdministrator,DBA–User21(DataBaseSystem)DBADBMS22•Oracle•DB2•Sybase•MicrosoftSQLServer•MySQL23Oracle•OracleOracleWindowsLinuxUnixOracle•Oracle11g8i9i10g24Oracle••24*7••SQL•••25Oracle197920052005oracle10g2002Oracle9iRelease22001Oracle9iRelease11998i1997199619961996199419941993GUI1991MPP19911990Client/Server1989OLTP1988Unix1987Case4GL1986Client/Server198419831979SQL26Oracle•oracle7.3oracle8oracle8ioracle9ioracle10g•IAS9i•ERP•FormReportDesignerJdeveloperOracle•DiscoverOWRExpress27OracleinstanceinstanceSGASGAPMONPMONSMONSMONDBWRDBWRLGWRLGWRCKPTCKPTOthersOthersSharedPoolSharedPoolLibraryCacheLibraryCacheDatadictionaryCacheDatadictionaryCacheDatabaseBufferCacheDatabaseBufferCacheRedoLogBufferRedoLogBufferJavaPoolJavaPoolLargePoolLargePoolDatabaseDatabaseDataFilesDataFilesControlFilesControlFilesRedoLogFilesRedoLogFilesArchivedLogFilesArchivedLogFilesPasswordFilePasswordFileParameterFileParameterFileUserProcessUserProcessServerProcessServerProcessPGAPGA28Oracle•UserProcess•ServerprocessOracle•(PGA):29Oracle•Instance–Oracle(SGA)–••(SGA)30Oracle•–(SGA):,Oracle•SQL–1SQLPL/SQLSharedPoolSQLPL/SQL–2•••–(UGA)–I/Oserver–•JavaJava–Java31Oracle•:Oracle–:•DBWN•LGWR•PMON•SMON•CKPT–:•ARCN32Oracle•–Datafiles:Oracletablespace–RedoLogFiles:,,“”–Controlfiles:•Parameterfile–33Oracle•1–“”DB_NAME–•SQLselectnamefromv$database•showshowparameterdb_name•init.ora•2(instance_name)–instance_nameoracleoracle–•SQLselectinstance_namefromv$instance•showshowparameterinstance_name;•init.ora•3SIDinstance_nameoracleinstance_nameSIDSIDORACLE_SIDinstance_name34Oracle•4–Db_domainDb_nameDb_domainDb_nameDb_domain‘.’Global_nameDb_name–•SQLselectvaluefromv$parameterwherename=‘db_domain’•showshowparameterdomain•35Oracle•5–oracle8i8iSIDOracleService_nameDb_name.Db_domainGlobal_name.–•SQLselectvaluefromv$parameterwherename=‘service_name’•showshowparameterservice_name••Oracle8ioracleORACLE_SID36Oracle•6–“ip::”172.17.0.1001521orcl•7–/@•8–•9(tablespace)–OracleOracle37Oracle•Oracle––DB_NAMEselectnamefromv$database–INSTANCE_NAMEselectinstance_namefromv$instance–ORACLE_SIDINSTANCE_NAME–DB_DOMAINselectvaluefromv$parameterwherename=‘db_domain’–GLOBAL_NAMEDB_NAME.DB_DOMAIN–SERVICE_NAMEselectvaluefromv$parameterwherename=‘service_name’–NET_SERVICE_NAMEtnsnames.ora383940•Oracle,:––––41••••42•UNIX–OracleDBA,Oracle•Windows–,administrator43•ORACLE_BASEoracleORACLE_BASEoracle•ORACLE_HOMEoracle•ORACLE_SID•PATH44Oracle45•Windows:–windows•UNIX:–,:/oracle/product/–Oracle46•UNIX–./runInstaller•Windows–setup.exe47••••SID••••4849505152535455565758••:Oracle9iEnterpriseEditionRelease9.2.0.1.0–ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0–ProductionSQL:Oracle9iEnterpriseEditionRelease9.2.0.1.0–ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0–ProductionSQLSqlplussystem/Sqlplussystem/59Oracle•–SQL*Plus•–OracleOracleEnterpriseManager•DBCA•NETCA/NETMGR60SQL*PLUS•SQL*PlusORACLE•Sql••SQL*Plus••SQL*Plussql•SQL61OEM••––OMSOracleManagermentServerOEM62•nomountmountopen–nomountstartupnomount•–mountalterdatabasemount–mountmountMount–alterdatabaseopen–63OracleClientServerListener.oraDBaddressresolvedUserUserListenerListenerServerServer11Sqlplususer/pw@DB22334464Oracle•Oracle•Oracle–NetConfigurationAssistantNetCA–NetManagerNetMgr65Oracle66Oracle•:–•lsnrctlstart•lsnrctlstop•lsnrctlstatus67Oracle•OracleOracleOracle•Oraclesqlnet.oratnsnames.ora$ORACLE_HOME\network\admin–Sqlnet.ora–tnsnames.ora68OracleNetCA69OracleNetCA70OracleNetCA71OracleNetCA72OracleNetCA73•Oracle,Oracle•Oracle9iwindows•Oracle—SqlplusOracle•oracle741.Oracle2.SQLPLUS3.4.DBCA5.NETCA/NETMGR6.7.Oracle75