ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
Cause : A SHUTDOWN command was issued to an ASM instance that had one or more connected RDBMS instances.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Connect to each RDBMS instance and shut it down, and then reissue the SHUTDOWN command to the ASM instance. Alternatively, use the SHUTDOWN ABORT command. Note that issuing the SHUTDOWN ABORT command to an ASM instance results in abormal termination of all RDBMS instances connected to that ASM instance.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.