Differences

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

--- dba:oracle:howto_change_sys_password [2022/02/11 11:12] – ↷ Page moved from oracle:howto_change_sys_password to dba:oracle:howto_change_sys_password dodger
+++ dba:oracle:howtos:howto_change_sys_password [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1
@@ 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)