Oracle 12C sys,system users ' passwords are forgotten or lost

Source: Internet
Author: User

Password

1  as SYSDBA 2 Alter user system identified by Abcd1234;

Manual script First-->manual_script_before_install.sql

1 --must connect as SYSDBA to execute the following script2 --This manual script was to minimize the "configuration change" on the Oracle database server3 4 --We suggest you use the default SYSTEM user during the installation5 --If you choose a user other than system during installation, you need change system in the script to that username 6 7 --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system8 GRANT EXECUTE  onSys. Dbms_reputil toSYSTEM with Grant option 9 /Ten --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system One GRANT SELECT  onSys. Dba_views toSYSTEM with Grant option A / - --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system - GRANT EXECUTE  onSys. Dbms_lob toSYSTEM with Grant option the / - --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system - GRANT EXECUTE  onSys. Dbms_sql toSYSTEM with Grant option - / + --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system - GRANT EXECUTE  onSys. Dbms_job toSYSTEM with Grant option + / A --METADATA type:grant object:dbms_jms_plsql privilege:execute grantee:system at GRANT EXECUTE  onSys. Dbms_random toSYSTEM with Grant option - / - --METADATA type:grant object:v_$transaction privilege:execute grantee:system - GRANT SELECT  onSys. v_$TRANSACTION  toSYSTEM with Grant option  - / - --METADATA type:grant object:gv_$transaction privilege:execute grantee:system in GRANT SELECT  onsys.gv_$TRANSACTION  toSYSTEM with Grant option  - /

1 Admuser 2 Privuser 3 Pubuser 4 Bgjobuser 5 Pxrptuser 6 7 Abcd1234

Update password for Oracle home directory user

1 @echo off2 3 @setlocal4 5@set oh=c:\app\b\product\12.1.0\dbhome_16@set jre_location=Jdk\jre7@set jlib_location=Jlib8 9@set jre_dir=%oh%\%jre_location%Ten@set jlib_dir=%oh%\%jlib_location% One  A@set jre=%jre_dir%\bin\java -  -@set jndi_jar=%jlib_dir%\jndi.jar the@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% ACD%oh%\ Bin at@set path=%oh%\bin;%path% -  - if(%ohuc_trace%) = =() ( -@set ohuc_trace=8 - ) -@set ohuc_property_defs=-dohuc_trace=%ohuc_trace% in  -%jre%-doracle_home=%oh%-classpath"%classpath%"%ohuc_property_defs% Oracle.homeuserctl.orahomeuserctl%* to@set orahomeuserctl_exit_status=%errorlevel% +CD%pwd% -Exit/b%orahomeuserctl_exit_status%

Oracle 12C sys,system users ' passwords are forgotten or lost

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.