Hi DBA gurus,
I have windows as Operating System and have Oracle 11g Release 2. i want to upgrade it to 126.96.36.199 . Everything has been done smoothly but my stand by database is not upgraded though all the logs are shipped and applied that were generated while running DBUA on primary .
On standby database sqlplus is being initiated by new ORACLE_HOME but the database is on 188.8.131.52 .
Any idea what i did wrong.
Thanks in advance.
Have you checked from primary database components status using DBA_REGISTRY?
Also can you check the applied patchset information from "registry$history" and if you have database opened/read only mode you can check from dba_registry whether all the components are upgraded or not.
Also ensure you have exported the new home and worth to check "C:\> echo %PATH%"