I created a instance manually and moved all datafiles over to a new server. When I issues startup mount pfile= option
I am getting Ora 01990 error opening password file.
can some one tell me how can I edit my pwd file or re-create without recreating the instance.
U can hash out the parameter remote_apssword_file(spelling may be wrong) in your init.ora file and bring up the database,just to check the database is ok.
then create the password file (actually first u should have a list of users who were part of that password file) using orapwd (orapwd -? for syntax).
Enable the parameter and restart the instance.
Click Here to Expand Forum to Full Width