很久没有使用sqlplus创建
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
空间和用户了,需要的时候竟然忘记了密码,试了好多次都没连接上,进而用户也被锁定,在网上找了一些资料,问题解决了,希望对和我一样情况的朋友们有所帮助。1.安装时选择的自动安装,忘了用户名和密码导致现在试了几个默认的用户名密码後(表格中附带默认用户名及密码),都提示无效的用户名、密码,UsernamePass
word
word文档格式规范word作业纸小票打印word模板word简历模板免费word简历
DescriptionSeeAlsoCTXSYSCTXSYSTheOracleTextOracleaccountTextReferenceDBSNMPDBSNMPTheaccountusedOraclebyEnterprisetheManagementAgentManagerGridcomponentofControlOracleEnterpriseManagerInstallationtoandmonitorandmanageBasicthedatabaseConfigurationLBACSYSLBACSYSTheOracleLabelSecurityOracleLabeladministratorSecurityaccountAdministrator'sGuideMDDATAMDDATATheschemausedOraclebyOracleSpatialSpatialforstoringUser'sGuideandGeocoderandReferencerouterdataMDSYSMDSYSTheOracleSpatialOracleandSpatialOracleinterMediaLocatorUser'sGuideandadministratorReferenceaccountDMSYSDMSYSTheOracleDataOracleMiningDataMiningaccount.Administrator'sGuideOracleDataMiningConceptsOLAPSYSMANAGERTheaccountusedtocreateOracleOLAPOLAPmetadatastructures.ApplicationItownstheOLAPDeveloper'sCatalogGuide(CWMLite).ORDPLUGINSORDPLUGINSTheOracleinterMediaOracleinterMediauser.Plug-insUser'ssuppliedGuidebyOracleandthirdpartyformatplug-insareinstalledinthisschema.ORDSYSORDSYSTheOracleinterMediaOracleinterMediaadministratorUser'saccountGuideUsernamePasswordDescriptionSeeAlsoOUTLNOUTLNTheaccountthatsupportsOracleDatabaseplanstability.PerformancePlanTuningstabilityenablesGuideyoutomaintainthesameexecutionplansforthesameSQLstatements.OUTLNactsasaroletocentrallymanagemetadataassociatedwithstoredoutlines.SI_INFORMTN_SCHEMASI_INFORMTN_SCHEMATheaccountthatOraclestoresinterMediatheinformationviewsforUser'sGuidetheSQL/MMStillImageStandardSYSCHANGE_ON_INSTALLTheaccountusedOracletoDatabaseperformdatabaseAdministrator'sadministrationGuidetasksSYSMANCHANGE_ON_INSTALLTheaccountusedOracletoEnterpriseperformOracleEnterpriseManagerGridManagerdatabaseControladministrationInstallationtasks.andNotethatSYSBasicandSYSTEMcanalsoperformConfigurationthesetasks.SYSTEMMANAGERAnotheraccountOracleusedDatabasetoperformdatabaseAdministrator'sadministrationGuidetasks.这时候要找到一组用户名、密码提示被锁,才能进行下一步安装ORACLE时,若没有为下列用户重设密码,则其默认密码如下:用户名/密码登录身份说明sys/change_on_installSYSDBA或SYSOPER不能以NORMAL登录,可作为默认的系统管理员system/managerSYSDBA或NORMAL不能以SYSOPER登录,可作为默认的系统管理员sysman/oem_tempsysman为oms的用户名scott/tigerNORMAL普通用户aqadm/aqadmSYSDBA或NORMAL高级队列管理员Dbsnmp/dbsnmpSYSDBA或NORMAL复制管理员2,在CMD中启动SQLPLUS;用sqlplus/as登录,提示sysdba连接到:OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production3.执行ALTER你被锁的用户名USERACCOUNT;UNLOCK4.重新用SQL/PLUS登录,用你刚刚解锁的用户名、密码;重新修改密码就可以了!具体操作如下:1.运行->sqlplus/nolog2.输入conn/as管理员账户登录sysdba3.如果用户被锁定先解锁:alterusersystemaccountunlock;4.修改密码:alterusersystemidentifiedbywanglj;接下来可以用sqlplus登陆了。