Oracle日常维护

OracleUTS.610G05.A0UTUTUT24UT24UTUT112310012(0571)88916789(0571)[e-mail]://support.utstar.com.cnUTUTStarcomPASWACOS,iAN,AIRSTAR,WLL,ISP,WICOPS,NGDLC,Intranode,Internode,Xtr-m-IP,UNITECH,UTUTOracle•9•9••\•ipasdb#root$Oracle•……•……Oracle1..............................................................12..........................................................13Oracle............................................13.1...................................................23.1.1Oracle................................................23.1.2Oracle..............................................33.1.3Oracle..............................................43.2SolarisOracle..........................................63.2.1..........................................63.2.2rootOracleemail.............................63.2.3Oracle..............................................73.2.4Oracle..........................................73.3Oracle...................................................83.3.1Oracle..........................................83.3.2Oracle..........................................83.3.3Oracle..........................................93.3.4Oracle.....................................103.3.5Oracle.......113.3.6Oracle.....................................123.4Oracle..........................................133.4.1Oracle.............................143.4.2Oracle.................................153.4.3.........................................173.4.4system.......................................173.4.5.........................18IOracle3.5..................................................193.5.1.......................................193.5.2...........................................214.............................................................304.1getinfo.sh........................................................304.2........................................................304.3........................................................304.4getinfo.sh:...................................................315.........................................................386.........................................................397.........................................................40IIOracle1iPAS/mSwitchiPAS/mSwitchOracle8iOracleiPAS/mSwitchOracle8i2iPAS/mSwitchOracle8iiPAS/mSwitch3Oracle12iPAS/mSwitchOracle8iSIDORCL,34CallCenter.1Oracle3.1OracleOracleOracle3.1.1Oracle$ps–ef|grep“ora_”|grep–vgreporacle658610May15?0:00ora_pmon_ORCLoracle659810May15?0:00ora_snp0_ORCLoracle660010May15?0:00ora_snp1_ORCLoracle659410May15?0:06ora_smon_ORCLoracle660410May15?0:00ora_snp3_ORCLoracle658810May15?6:50ora_dbw0_ORCLoracle659010May15?37:48ora_lgwr_ORCLoracle660210May15?0:00ora_snp2_ORCLoracle660610May15?5:19ora_arc0_ORCLoracle659210May15?0:45ora_ckpt_ORCLoracle659610May15?0:01ora_reco_ORCL…….Oracle•Oracleora_dbw0_ORCL•Oracleora_lgwr_ORCL•Oracleora_smon_ORCL2Oracle•Oracleora_pmon_ORCL•Oracleora_arc0_ORCL•Oracleora_ckpt_ORCL•Oracleora_reco_ORCLORCLORCL3.1.2Oracle$lsnrctlstatusLSNRCTLforSolaris:Version8.1.7.3.0-Productionon23-MAY-200313:12:09(c)Copyright1998OracleCorporation.Allrightsreserved.Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ipasdb)(PORT=1521)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforSolaris:Version8.1.7.3.0-ProductionStartDate15-MAY-200322:05:58Uptime7days15hr.6min.11secTraceLeveloffSecurityOFFSNMPOFFListenerParameterFile3Oracle/opt/oracle/db01/app/oracle/product/8.1.7/network/admin/listener.oraListenerLogFile/opt/oracle/db01/app/oracle/product/8.1.7/network/log/listener.logServicesSummary...ORCLhas1servicehandler(s)PLSExtProchas1servicehandler(s)ThecommandcompletedsuccessfullyServicesSummaryOracleORCL3.1.3Oracle$sqlplussystem/managersqlselectinstance_name,version,status,database_statusfromv$instance;INSTANCE_NAMEVERSIONSTATUSDATABASE_STATUS---------------------------------------------------------ORCL8.1.7.3.0OPENACTIVESTATUSOracleOPENDATABASE_STATUSOracleACTIVE4Oraclesqlselectname,log_mode,open_modefromv$database;sqlexitNAMELOG_MODEOPEN_MODE-------------------------------ORCLARCHIVELOGREADWRITELOG_MODEOracleARCHIVELOGNOARCHIVELOG5Oracle3.2SolarisOraclerootOracleemailOracleOracle3.2.1#cat/var/adm/messages|greporacleOracleOracle8iErrormessagesPartNo.A76999-013.2.2rootOracleemail#more/var/mail/root#more/var/mail/oracleOracleOracle8iErrormessagesPartNo.A76999-016Oracle3.2.3Oracle$cat$ORACLE_BASE/admin/ORCL/bdump/alert_ORCL.log|grep-iora-$cat$ORACLE_BASE/admin/ORCL/bdump/alert_ORCL.log|grep-ierr$cat$ORACLE_BASE/admin/ORCL/bdump/alert_ORCL.log|grep-ifailORA-ErrorFailedORA-07445:exceptionencountered:coredump[00000001015EF610][SIGSEGV][Addressnotmappedtoobject]OracleOracle8iErrormessagesPartNo.A76999-013.2.4Oracle$ls$ORACLE_BASE/admin/ORCL/cdump/*.trc|wc-l$ls$ORACLE_BASE/admin/ORCL/udump/*.trc|wc–l10Oracle7Oracle3.3OracleOracleOracleOracleOracleOracleOracleOracle3.3.1Oracle$sqlplussystem/managersqlselect*fromv$controlfile;sqlexitSTATUSNAME-------------------------