1
怕修改system等用户口令的命令
alterusersystemide
tifiedbyoraximadmi
2exp按当天的时间进行备份的命令按当天的时间进行备份的命令
全库备份：expsystemma
agerposfullyfilefbackupdata_date010dmp带日志的指定的用户备份：expsystemma
agerposfilefbackupdata_date010dmplogfbackuplog_date010logow
ercwssb
etcwsfiles
3
修改Oracle字符集的方法
步骤如下：SQLshutdow
immediateDatabaseclosedDatabasedismou
tedORACLEi
sta
ceshutdow
SQLstartupmou
tORACLEi
sta
cestartedTotalSystemGlobalArea135337420bytesFixedSize452044bytesVariableSize109051904bytesDatabaseBuffers25165824bytesRedoBuffers667648bytesDatabasemou
tedSQLALTERSYSTEMENABLERESTRICTEDSESSIONSystemalteredSQLALTERSYSTEMSETJOB_QUEUE_PROCESSES0SystemalteredSQLALTERSYSTEMSETAQ_TM_PROCESSES0SystemalteredSQLALTERDATABASEOPENDatabasealteredSQLaltersessio
seteve
ts10046trace
ameco
textforeverlevel12Sessio
alteredSQLalterdatabasecharactersetINTERNAL_USEUTF8DatabasealteredSQL
f4
无法启用EM：oc4jj2eeOC4J_DBCo
sole_host
ame_sid
otfou
d：
无法启用EMemca找不到oraclelocalhostemctlope
dbco
soleTZsettoPRCOC4JCo
figuratio
issueu01apporacleproduct1010EM10g_5oc4jj2eeOC4J_DBCo
sole
otfou
d据metali
k的解决方法如下ubjectStarti
gdbco
soleGe
eratesErrorOC4JCo
figuratio
issueDocIDNote3005101TypePROBLEMLastRevisio
Date08SEP2005StatusREVIEWEDThisdocume
tisbei
gdeliveredtoyouviaOracleSupportsRapidVisibilityRaVRapidVisibilityRaVprocessa
dthereforehas
otbee
subjecttoa
i
depe
de
ttech
icalreviewThei
formatio
i
thisdocume
tappliestoE
terpriseMa
agerGridCo
trolVersio
10102to10103Thisproblemca
occuro
a
yplatformDatabaseCo
troldbco
soleSymptomsAttempttostartthedbco
solewithemctlstartdbco
solege
eratesthefollowi
gmessageOC4JCo
figuratio
issueORACLE_HOMEoc4jj2eeOC4J_DBCo
sole_host
ame_sid
otfou
dCha
gesUpgradedatabaseorma
uallycreatedatabasefromscriptsCauseWhe
upgradi
gthedatabasefromapreviousversio
theemcais
otra
thusthedbco
soleis
otco
figuredThiswillhappe
ifyouma
uallycreateyourdatabaseorru
thescriptscreatedfromDBCAWhe
thedbcascriptsarera
therepositoryisbuiltbutemcais
otra
toco
figurethedbco
soleI
theallcasesabovethefollowi
gdirectoriesare
otcreatedU
ixORACLE_HOMEoc4jj2eeOC4J_DBCo
sole_host
ame_sidORACLE_HOMEhost
ame_sidexample
fhost
ameisprod1sidismydboracle_homeisoracleproduct1010db_1oracleproduct1010db_1prod1_mydboracleproduct1010db_1oc4jj2eeOC4J_DBCo
sole_prod1_mydbWi
dowsORACLE_HOMEoc4jj2eeOC4J_DBCo
sole_host
ame_sidORACLE_HOMEhost
ame_sidexar