oracle10g数据库的启动和关闭.ppt

OracleDatabase10g数据库启动与关闭,数据库启动,Oracle10g数据库在Unix下的启动$sqlplus“sys/xxxassysdba”SQL*Plus:Release10.1.0.2.0-ProductiononMonMay314:17:122004Copyright(c)1982,2004,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.1.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptionsSQLstartupORACLEinstancestarted.TotalSystemGlobalArea61611980bytesFixedSize65484bytesVariableSize54919168bytesDatabaseBuffers6553600bytesRedoBuffers73728bytesDatabasemounted.Databaseopened.,Oracle10g数据库在WindowsNT下的启动,C:sqlplussys/xxxxassysdbaSQL*Plus:Release10.1.0.2.0-Productionon星期一5月314:20:572004Copyright(c)1982,2004,Oracle.Allrightsreserved.连接到:OracleDatabase10gEnterpriseEditionRelease10.1.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptionsSQLSQLstartupORACLE例程已经启动。TotalSystemGlobalArea51452388bytesFixedSize453092bytesVariableSize46137344bytesDatabaseBuffers4194304bytesRedoBuffers667648bytes数据库装载完毕。数据库已经打开。,启动监听进程Listener$lsnrctlstartLSNRCTLforWindows:Version10.1.0.2.0-Productionon03-MAY-200414:22:58Copyright(c)1991,2004,Oracle.Allrightsreserved.StartingSolaris:pleasewait.TNSLSNRfor32-bitWindows:Version10.1.0.2.0-ProductionSystemparameterfileisD:oracleproduct10.1.0db_1networkadminlistener.oraLogmessageswrittentoD:oracleproduct10.1.0db_1networkloglistener.logListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROCipc)Listeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)STATUSoftheLISTENER-AliasLISTENERVersionTNSLSNRSolaris:Version10.1.0.2.0-ProductionStartDate03-MAY-200414:23:00Uptime0days0hr.0min.2sec,Oracle启动过程,SHUTDOWN,NOMOUNT,MOUNT,OPEN,启动实例,数据库安装,数据库打开,0,1,2,3,数据库关闭,$sqlplus“/assysdba”SQL*Plus:Release10.1.0.2.0-ProductiononMonMay314:17:122004Copyright(c)1982,2004,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.1.0.2.0-ProductionWiththePartitioning,O