How to change ASM SYS Password and Creating SYSASM user 11g.

First we can try with normal method SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We cannot change the password for ASM databases via alter user command. Because passwords are […]

Read More