I am a non-oracle person that has been pressed into service. I am trying to set up some backup software that requires an alteration to the database. We have two instances running on one Win2K server.
One instance the change took no problem. The other instance (which of course is the critical one) give me the ora-01991 error.
Specifically I am trying to modify the archivelog settings on this instance. From a shut down database i am supposed to type "startup nomount;" this command processes with no problem. The next command is "alter database mount exclusive". This is where i get the error "ora-01991: invalid password file 'd:\oracle\ora81\database\pwdsid01.ora".
I have created a new pwd file using orapwd with new passwords and I can connect to the database as a sysdba with the new passwords in both sqlplus worksheet and using the command line svrmgrl. Even with the new pwd file though I still get the error during the "alter db" command so I do not think it is really a pwd file issue. With the exception of the new passwords the users / rights are the same between the two instances. A couple of documents that I have read today make me think that it may be an an "oracle home" issue because of the two instances, but I am not smart enough to know. A couple of posts refered to an "Oracle Home Selector" but that does not seem to be an option that is available anywhere on the start menu.
Any assistance in resolving this would be greatly appreciated. Besides making my boss happy it has got the point of driving me batty now. Thanks in advance,
Jim
Jim
Elegant solutions are nice, but right now I'll settle for whatever works.
One instance the change took no problem. The other instance (which of course is the critical one) give me the ora-01991 error.
Specifically I am trying to modify the archivelog settings on this instance. From a shut down database i am supposed to type "startup nomount;" this command processes with no problem. The next command is "alter database mount exclusive". This is where i get the error "ora-01991: invalid password file 'd:\oracle\ora81\database\pwdsid01.ora".
I have created a new pwd file using orapwd with new passwords and I can connect to the database as a sysdba with the new passwords in both sqlplus worksheet and using the command line svrmgrl. Even with the new pwd file though I still get the error during the "alter db" command so I do not think it is really a pwd file issue. With the exception of the new passwords the users / rights are the same between the two instances. A couple of documents that I have read today make me think that it may be an an "oracle home" issue because of the two instances, but I am not smart enough to know. A couple of posts refered to an "Oracle Home Selector" but that does not seem to be an option that is available anywhere on the start menu.
Any assistance in resolving this would be greatly appreciated. Besides making my boss happy it has got the point of driving me batty now. Thanks in advance,
Jim
Jim
Elegant solutions are nice, but right now I'll settle for whatever works.