| Upgrade Oracle10g to Oracle11g [message #631414] |
Tue, 13 January 2015 16:21  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
We recently upgraded from Oracle10g to Oracle 11.2.0.4. This is data guard database.
This is siebel database and upgrade went well and no issues.
Only issue is, we are not able open the standby database with READ ONLY WITH APPLY mode.
We opened the standby database with below command.
Quote:startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
The standby is in managed recovery mode. but it is not applying online redo replication.
The DB is in MOUNT mode now..
We found that we forgot to set the compatible ='11.1.0.7'.
Currently the compatible parameter is 10.2.0.0
Now to fix this issue, i guess, we need to change the compatible parameter to 11.1.0.7.
My question is, does it break any thing if we set the compatible parameter to 11.1.0.7?
Any input is highly appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
