Monday, October 9, 2017

Silly mistake

As we move more one version of database to another I have a habit of updating the database name with 1,2,3,4 ...

in this case
qa1tst => 11.2.0.3
qa2tst => 12.1.2.0.2

I tired adding the password file and got a very sensible message and quickly realised that I am entering the wrong unique name



[oracle@testdbn01 (qa2tstp1) dbs]$ srvctl modify database -d qa1tstp -pwfile "+DATA/QA2TSTP/PASSWORD/pwdqa2tstp.9085.127745674"
PRCD-1229 : An attempt to access configuration of database qa1tstp was rejected because its version 11.2.0.3.0 differs from the program version 12.1.0.2.0. Instead run the program from /u01/app/oracle/product/11.2.0.3.
[oracle@testdbn01 (qa2tstp1) dbs]$
[oracle@testdbn01 (qa2tstp1) dbs]$ srvctl modify database -d qa2tstp -pwfile '+DATA/QA2TSTP/PASSWORD/pwdqa2tstp.9085.127745674'
[oracle@testdbn01 (qa2tstp1) dbs]$


By using the correct name fixed this error.


No comments: