oracle 12C SYS,SYSTEM用户的密码都忘记或是丢失

密码

 conn / as sysdba

 alter user system identified by Abcd1234;

manual script first -->manual_script_before_install.sql

 -- must connect as sysdba to execute the following script

 -- this manual script is to minimize the configuration change on the Oracle database server

 -- we suggest you use the default SYSTEM user during the installation

 -- if you choose a user other than SYSTEM during installation, you need change SYSTEM in the script to that username

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT EXECUTE ON sys.DBMS_REPUTIL TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT SELECT ON sys.DBA_VIEWS TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT EXECUTE ON sys.DBMS_LOB TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT EXECUTE ON sys.DBMS_SQL TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT EXECUTE ON sys.DBMS_JOB TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:DBMS_JMS_PLSQL PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT EXECUTE ON sys.DBMS_RANDOM TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:V_$TRANSACTION PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT SELECT ON sys.V_$TRANSACTION TO SYSTEM with grant option

 /

 --METADATA TYPE:GRANT OBJECT:GV_$TRANSACTION PRIVILEGE:EXECUTE GRANTEE:SYSTEM

 GRANT SELECT ON sys.gv_$TRANSACTION TO SYSTEM with grant option

 /

 admuser

 privuser

 pubuser

 bgjobuser

 pxrptuser

 Abcd1234

更新 Oracle 主目录用户的口令

 @echo off

 @setlocal

 @set OH=C:\app\b\product\12.1.\dbhome_1

 @set JRE_LOCATION=jdk\jre

 @set JLIB_LOCATION=jlib

 @set JRE_DIR=%OH%\%JRE_LOCATION%

 @set JLIB_DIR=%OH%\%JLIB_LOCATION%

 @set JRE=%JRE_DIR%\bin\java

 @set JNDI_JAR=%JLIB_DIR%\jndi.jar

 @set SRVM_JAR=%JLIB_DIR%\srvm.jar

 @set SRVMHAS_JAR=%JLIB_DIR%\srvmhas.jar

 @set HOMEUSERCTL_JAR=%JLIB_DIR%\homeuserctl.jar

 @set CLASSPATH=%HOMEUSERCTL_JAR%;%JNDI_JAR%;%SRVM_JAR%;%SRVMHAS_JAR%

 @set PWD=%CD%

 cd %OH%\bin

 @set PATH=%OH%\bin;%PATH%

 if (%OHUC_TRACE%)==() (

    @set OHUC_TRACE=

 )

 @set OHUC_PROPERTY_DEFS=-DOHUC_TRACE=%OHUC_TRACE%

 %JRE% -DORACLE_HOME=%OH% -classpath "%CLASSPATH%" %OHUC_PROPERTY_DEFS% oracle.homeuserctl.orahomeuserctl %*

 @set ORAHOMEUSERCTL_EXIT_STATUS=%ERRORLEVEL%

 cd %PWD%

 exit /B %ORAHOMEUSERCTL_EXIT_STATUS%