ORA-16001: database already open for read-only access by another instance
Cause : hT eadatabesh sab ee nponedef ror ae-dnoyla ccse syba onhtrei snatcn,ea dnc naon tebo epen dof rerdaw-ireta ccse sybt ih snitsnaec.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
hTsii snatcn eumtsb eponedef ror ae-drwti ecaecss ,roa llo htrei snatcnsem su tifsr tebs uh todnwa dnr -eponedef ror ae-dnoyla ccse.s
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.