| Discrepancy between NLS_RDBMS_VERSION and DBA_REGISTRY (merged) [message #384688] |
Wed, 04 February 2009 21:22  |
blazingrock4u
Messages: 30
Registered: March 2006
Location: India
|
Member |
|
|
Hi
We have got two databases PRODDB and TESTDB. Until last November, both were on 9.2.0.6
Later, 9.2.0.8 patch was applied by two different DBA teams.
The TESTDB was done by me and I had just followed the readme to successfully apply the patch.
When I check the NLS_RDBMS_VERSION in NLS_DATABASE_PARAMETERS and DBA_REGISTRY, they both rightly showed 9.2.0.8
Patch on PRODDB was applied by a separate team. When I queried on PRODDB, I've found that the NLS_RDBMS_VERSION was 9.2.0.6, whereas DBA_REGISTRY shows 9.2.0.8
Could you please advise:
(a) What could be the reason for this discrepancy?
(b) What is the prominence of NLS_RDBMS_VERSION?
(c) Will there be any issues in having this discrepancy?
(b) How can this be resolved?
Thanks,
Abby
|
|
|
|
|
|
| Re: Discrepancy in NLS_RDBMS_VERSION and DBA_REGSITRY [message #385080 is a reply to message #384701] |
Fri, 06 February 2009 06:28  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
@BlackSwan - I must ask: what is it that you think is missing from or incorrect in the opening post?
It can't have been anything important, or you'd surely have mentioned it explicitly, and yet presumably there was something important enough for you to feel the need to reply without actually offering any help?
The opening post strikes me as a concise and clearly written description of a problem, and it seems to me that your post adds precisely nothing except officious pedantry to the thread.
If was unpleasantly cynical, I'd say that you were making all these pro-forma back seat moderation posts in an attempt to get your posting count up to Moderator level without actually having to spend the time helping people solve their problems.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
