启动--清华大学计算中心ORACLE培训资料

Oracle9iDatabase数据库启动与关闭数据库启动Oracle9i数据库在Unix下的启动$SQLPLUS/NOLOGSQLCONNECTsys/change_on_installASSYSDBA$sqlplus/assysdbaSQL*Plus:Release9.2.0.1.0-ProductiononThuAug2220:04:192002Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-ProductionSQLstartupORACLEinstancestarted.TotalSystemGlobalArea61611980bytesFixedSize65484bytesVariableSize54919168bytesDatabaseBuffers6553600bytesRedoBuffers73728bytesDatabasemounted.Databaseopened.Oracle9i数据库在WindowsNT下的启动C:\sqlplus/assysdbaSQL*Plus:Release9.2.0.1.0-Productionon星期二10月816:35:072002Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.连接到:Oracle9iEnterpriseEditionRelease9.2.0.1.0–ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-ProductionSQLstartupORACLE例程已经启动。TotalSystemGlobalArea51452388bytesFixedSize453092bytesVariableSize46137344bytesDatabaseBuffers4194304bytesRedoBuffers667648bytes数据库装载完毕。数据库已经打开。启动监听进程Listener$lsnrctlstartTNSLSNRforSolaris:Version9.0.1.1.1-Productionon06-OCT-200112:27:54Copyright(c)1991,2001,OracleCorporation.Allrightsreserved.Startingtnslsnr:pleasewait…TNSLSNRforSolaris:Version9.0.1.1.1-ProductionSystemparameterfileis/home2/app/oracle/product/9.0.1/network/admin/listener.oraLogmessageswrittento/home2/app/oracle/product/9.0.1/network/log/listener.logListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))Listeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sun4500)(PORT=1521)))启动监听进程ListenerConnectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforSolaris:Version9.0.1.1.1-ProductionStartDate06-OCT-200112:27:56Uptime0days0hr.0min.2secTraceLeveloffSecurityOFFSNMPOFFListenerParameterFile/home2/app/oracle/product/9.0.1/network/admin/listener.oraListenerLogFile/home2/app/oracle/product/9.0.1/network/log/listener.logListeningEndpointsSummary…(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sun4500)(PORT=1521)))ServicesSummary…ServicePLSExtProchas1instance(s).InstancePLSExtProc,statusUNKNOWN,has1handler(s)forthisservice…Serviceora9ihas1instance(s).Instanceora9i,statusUNKNOWN,has1handler(s)forthisservice…ThecommandcompletedsuccessfullyOracle9i数据库启动要求Oracle9i引入了服务器参数文件spfile的概念，在数据库启动时，系统缺省使用spfile参数启动数据库。如果没有spfile参数文件，则使用pfile启动数据库。如果两个文件同时存在，则系统优先使用spfile。如果没有spfile、pfile则出现错误。Oracle启动过程SHUTDOWNNOMOUNTMOUNTOPEN启动实例数据库安装数据库打开0123数据库关闭$sqlplus/nologSQL*Plus:Release9.0.1.0.1-ProductiononSatOct612:19:202001(c)Copyright2001OracleCorporation.Allrightsreserved.SQLconnectsys/managerassysdbaConnected.SQLshutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL