Differences

This shows you the differences between two versions of the page.

--- dba:oracle:howtos:howto_change_sys_password [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1
+++ dba:oracle:howtos:howto_change_sys_password [2023/01/31 08:26] (current) – ↷ Page moved from dba:oracle:howto_change_sys_password to dba:oracle:howtos:howto_change_sys_password dodger
@@ Line 1: / Line 1: @@
+====== [HOWTO] Reset SYS password ======
+====== Description ======
+This is a very little document on howto reset the SYS password.
+====== steps ======
+  * verify the pwfile:
+<code>select * from v$pwfile_users;</code>
+  * if there's any additional user, you must reset its passwd too.
+  * Its a good practice to initalice the Oracle environment variables.
+  * As oracle, create the file:
+<code>orapwd file=$HOME/orapw${ORACLE_SID} password=<PASSWORD> entries=4</code>
+  * backup the actual pwd file:
+<code>cp $ORACLE_HOME/dbs/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}.BACKUP</code>
+  * And replace it:
+<code>cp -pfv $HOME/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}</code>
+  * Now you can add more users to the pwd file so they can login without having oracle avalaible:
+<code>create user DODGER identified by <PASSWORD>;
+grant sysdba to DODGER;
+</code>
+====== on ASM ======
+you must use the password copy tools:
+pwget
+pwcopy
+to know which passwordfile is using and for copying from/to asm to/from localdisks.
+<code bash>
+pwget --dbuniquename BAVEL12SGDN
+pwcopy --dbuniquename BAVEL12SGDN /home/oracle/orapwdBAVEL12SGDN +DG_DATA_01/BAVEL12SGDN
+</code>
+How to Restore ASM Password File if Lost ( ORA-01017 ORA-15077 ) (Doc ID 1644005.1)