This error i was getting after changing my PC ip address. But i updated my changed ip address in tnsnames.ora file after that i was getting the above error. I fixed the above error very easily. I just renamed my datafile after that problem was fixed.
i had change my ip address after that i was raising the error on my old ip address. i just renamed that datafile to new ip address.
Step1:-alter database rename file 'E:\oradata/oracle10g/oradata/sde1.dbf'
to 'E:\oradata/oracle10g/oradata/sde1.dbf';
after executing this query the prob fixed.
No comments:
Post a Comment