Oracle管理课程课件.ppt
- 文档编号:1400759
- 上传时间:2022-10-22
- 格式:PPT
- 页数:123
- 大小:4.07MB
Oracle管理课程课件.ppt
《Oracle管理课程课件.ppt》由会员分享,可在线阅读,更多相关《Oracle管理课程课件.ppt(123页珍藏版)》请在冰豆网上搜索。
Oracle11g数据库基础管理课程,SelfIntrodution,Over10yearsofexperienceinITTraining,OracleCertifiedDatabaseMaster10g,IBMcertifiedAIXSystemAdministrator,IBMcertifiedP/Iserial&storageProduct,OracleCertifiedProfessional8i,CISCOcertifiedNetworkProfessional,Over18yearsofexperienceinServer/DBtechnology,易剑,1972,master,systemAnalyst,Objective,1,Oracle软件安装和创建数据库,SettingEnvironment,#cd/oradisk#unziplinux_11gR2_database_1of2.zip#unziplinux_11gR2_database_2of2.zip#chown-Roracle:
oinstall/oradisk#chmod-R775/oradisk#xhost+#su-oracle$cd/oradisk/database$./runInstaller,OracleUniversalInstaller(OUI),InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,InstallingtheOracleSoftware,Usingthenetcatocreatealistener,#xhost+#su-oracle$netca,Usingthenetcatocreatealistener,Usingthenetcatocreatealistener,Usingthenetcatocreatealistener,UsingtheDBCAtoCreateaDatabase,$dbca,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,UsingtheDBCAtoCreateaDatabase,2,Oracle基础管理和基本操作,UsingSQL*Plus,$sqlplussys/yijian123assysdbaSQLshutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQLstartupORACLEinstancestarted.TotalSystemGlobalArea285212672bytesFixedSize1218472bytesVariableSize250177624bytesDatabaseBuffers33554432bytesRedoBuffers262144bytesDatabasemounted.Databaseopened.SQLselectstatusfromv$instance;,$sqlplussysassysdbaPassword:
SQL*Plus:
Release11.1.0.6.0-ProductiononTueAug502:
39:
202008Copyright(c)1982,2007,Oracle.Allrightsreserved.Connectedto:
OracleDatabase11gEnterpriseEditionRelease11.1.0.6.0-ProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsSQLselectenamefromscott.emp;ENAME-AbelAndeAtkinson,UsingSQL*PlustoViewData,UsingSQL*PlustoViewParameters,SQLshowparameter;NAMEVALUE-lock_name_space2processes150sessions247timed_statisticsTRUEtimed_os_statistics0SQLSHOWPARAMETERsga_targetNAMETYPEVALUE-Sga_targetinteger500MSQLshowparametersgaNAMETYPEVALUE-Lock_sgabooleanFALSEPre_page_sgabooleanFALSEsga_max_sizeinteger500Msga_targetinteger500M,InitializationParameterFiles,$lsl$ORACLE_HOME/dbs/spfileora12.ora$lsl$ORACLE_HOME/dbs/initora12.oraSQLcreatepfilefromspfile;SQLcreatespfilefrompfile;,ChangingParameterValues:
Examples,SQLaltersessionsetsga_target=450M;SQLaltersystemsetsga_target=450M;SQLshowparametersga_targetSQLaltersystemsetsga_target=550m;SQLaltersystemsetsga_max_size=550mscope=spfile;SQLshutdownimmediate;SQLstartupSQLshowparametersga_max_sizeSQLaltersystemsetsga_target=550m;,SQLselectsysdatefromdual;SQLaltersessionsetnls_date_format=YYYY-MM-DD;SQLselectsysdatefromdual;,DataDictionary:
Overview,Tables,Indexes,Views,Users,Schemas,Procedures,andsoon,SystemTablespace,Metadata,$sqlplussys/yijian123assysdbaSQLselecttable_namefromdba_tables;SQLselectuser_namefromdba_users;SQLselectfile_namefromdba_data_files;,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,UseOracleClientsoftwareinWindowsOS,ListenerManagement,$lsnrctlstatusLSNRCTLforLinux:
Version11.2.0.1.0Productionon30-DEC-201223:
04:
12Copyright(c)1991,2009,Oracle.Allrightsreserved.Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=AS5)(PORT=1521)STATUSoftheLISTENER-AliasLISTENERVersionTNSLSNRforLinux:
Version11.2.0.1.0ProductionStartDate29-DEC-201216:
49:
20Uptime1days6hr.14min.52secTraceLeveloffSecurityON:
LocalOSAuthenticationSNMPOFFListenerParaFile/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.oraListenerLogFile/u01/app/oracle/diag/tnslsnr/AS5/listener/alert/log.xmlListeningEndpointsSummary(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AS5)(PORT=1521)ServicesSummary.Service“ora11”has1instance(s),Instance“ora11”,statusREADY,has1handler(s)forthisservice.Service“ora11XDB”has1instance(s),Instance“ora11”,statusREADY,has1handler(s)forthisserivce.Thecommandcompletedsuccessfully$lsnrctlstop$lsnrctlstart,UseDeveloperClientTools,UseOracleClientsoftwarei
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 管理 课程 课件
![提示](https://static.bdocx.com/images/bang_tan.gif)