we encountered issue after linux team performed patching on the server , after server reboot is done , they requested to start the database services , we set the environment and tried starting the database. database did not start , gave error "ORA 01103 : Database name 'PUM2PIX' in control file is not 'HCMPRD1'" before going into mount.
we checked the file system accesses and control file permission , all looked good , we checked the value in pfile for the database name db_name='PUM2PIX'
we started the database using pfile and that worked,
after logging in using pfile , we created spfile and rebooted the database , that worked !!!
sometime even minor trick will help a big save. :)
No comments:
Post a Comment