{"id":972,"date":"2005-06-12T12:00:00","date_gmt":"2005-06-12T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=972"},"modified":"2005-06-12T12:00:00","modified_gmt":"2005-06-12T12:00:00","slug":"dba_registry","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/06\/12\/dba_registry\/","title":{"rendered":"dba_registry"},"content":{"rendered":"

It’s true I learn something new all the time. Is it just me? Did everyone know about this?<\/p>\n

I was talking to one of the other DBAs at work on Friday who was telling me that one of the dbs we’ve taken over looks like it wasn’t upgraded properly. I connected okay, v$version looked okay, so I asked him what he meant and he pointed me at dba_registry. (I’ve had to fake this slightly because it was 9i at work and I have 10g at home where I’m doing this – you’ll see what I mean in a minute)<\/p>\n

SQL> l  1* select comp_id, comp_name, version, status from dba_registrySQL> \/COMP_ID------------------------------COMP_NAME----------------------------------------------------------------------------------------------------VERSION                        STATUS------------------------------ -----------CATALOGOracle Database Catalog Views9.2.0.1.0                      VALIDCATPROCOracle Database Packages and Types9.2.0.1.0                      VALID<\/pre>\n
The database was using 9.2.0.4 binaries and other databases that were showed 9.2.0.4 in dba_registry.<\/p>\n
I have to be honest and say I didn’t know about this. He pointed out that I should from when I’ve applied patches, but I know I’ve upgraded plenty of dbs without checking this (although I always check the log files of dictionary scripts I’ve run).<\/p>\n
Anyway, it was good to learn something new. So when I applied the 10.1.0.4.0 patch to my home set-up this weekend, I thought I’d check this view out again.<\/p>\n
  1* select comp_id, comp_name, version, status from dba_registrySQL> \/COMP_ID------------------------------COMP_NAME----------------------------------------------------------------------------------------------------VERSION                        STATUS------------------------------ -----------CATALOGOracle Database Catalog Views10.1.0.2.0                     VALIDCATPROCOracle Database Packages and Types10.1.0.2.0                     VALIDOWMOracle Workspace Manager10.1.0.2.0                     VALIDJAVAVMJServer JAVA Virtual Machine10.1.0.2.0                     VALIDXMLOracle XDK10.1.0.2.0                     VALIDCATJAVAOracle Database Java Packages10.1.0.2.0                     VALIDEXFOracle Expression Filter10.1.0.2.0                     VALIDORDIMOracle interMedia10.1.0.2.0                     VALIDODMOracle Data Mining10.1.0.2.0                     VALIDCONTEXTOracle Text10.1.0.2.0                     VALIDXDBOracle XML Database10.1.0.2.0                     VALIDAPSOLAP Analytic Workspace10.1.0.2.0                     VALIDXOQOracle OLAP API10.1.0.2.0                     VALIDAMDOLAP Catalog10.1.0.2.0                     VALIDSDOSpatial10.1.0.2.0                     VALIDEMOracle Enterprise Manager10.1.0.2.0                     VALID
<\/p>
<\/p>
16 rows selected.<\/p><\/pre>\n
I obviously have a lot more stuff installed at home, or this view shows more information in 10g. However, the version numbers aren’t 10.1.0.4.0 which means that it’s obviously not a sure-fire way of checking an upgrade’s been applied correctly. I suppose the dictionary may not have changed.<\/p>\n
I’m intrigued – is this something that’s widely-known?<\/p>\n","protected":false},"excerpt":{"rendered":"
It’s true I learn something new all the time. Is it just me? Did everyone know about this? I was talking to one of the other DBAs at work on Friday who was telling me that one of the dbs we’ve taken over looks like it wasn’t upgraded properly. I connected okay, v$version looked okay,… Continue reading dba_registry<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-972","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":978,"url":"http:\/\/orcldoug.com\/blog\/2005\/04\/25\/and-theres-more-smu-again\/","url_meta":{"origin":972,"position":0},"title":"And there’s more … (SMU again)","date":"April 25, 2005","format":false,"excerpt":"Almost immediately after posting my last comment on SMU, I noticed that the TAR for the original corruption issue has been updated with a root causeOracle Development has found the root cause of the corruption problem which crippled your database. They have reproduced the problem on an in-house database, thereby\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1062,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/21\/resumable-storage-allocation\/","url_meta":{"origin":972,"position":1},"title":"Resumable Storage Allocation","date":"August 21, 2006","format":false,"excerpt":"At the moment I'm writing a short 9i\/10g New Features seminar for the developers at work. The idea is to run through lots of new features very quickly to see if anything lights their candle and they can then go off and investigate further afterwards.It occurred to me while I\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1264,"url":"http:\/\/orcldoug.com\/blog\/2007\/05\/06\/re-linking-oracle\/","url_meta":{"origin":972,"position":2},"title":"Re-linking oracle","date":"May 6, 2007","format":false,"excerpt":"Hooray! Something vaguely technical - at last.My new client is hot on software licence compliance and what seemed a minor issue to me reared it's slightly ugly head this week. When connecting to our 10.2.0.2 database instances using sqlplus, the version banner displays options that we aren't using, for example\u2026","rel":"","context":"With 21 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1191,"url":"http:\/\/orcldoug.com\/blog\/2007\/01\/27\/dba-documentation-catalogue\/","url_meta":{"origin":972,"position":3},"title":"DBA Documentation – Catalogue","date":"January 27, 2007","format":false,"excerpt":"Prompted by Linda's comment on a previous blog, I thought it might be worth writing a couple of postings on DBA documentation.The first thing you need is a Database Catalogue of some kind.Benefits1) Even an experienced DBA arriving on site won't know what servers exist, how to login to them,\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1002,"url":"http:\/\/orcldoug.com\/blog\/2006\/06\/20\/mysterious\/","url_meta":{"origin":972,"position":4},"title":"Mysterious …","date":"June 20, 2006","format":false,"excerpt":"... and quite funny. I followed an incoming link through Statcounter and arrived here.At the moment, the content is :-SQL> startup mountORACLE instance started.Total System Global Area 645922816 bytes Fixed Size 1250644 bytes Variable Size 184552108 bytes Database Buffers 457179136 bytes Redo Buffers 2940928 bytes Database mounted.SQL> alter database open;Database\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1044,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/04\/tracing-session-activity-over-a-remote-database-link\/","url_meta":{"origin":972,"position":5},"title":"Tracing session activity over a remote database link","date":"August 4, 2006","format":false,"excerpt":"Yesterday someone asked me how to trace a session that selects from a view in a remote database via a link. If they activated the trace on the local instance, they wouldn't see the bulk of the work which was happening on the remote instance - just a bunch of\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=972"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/972\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=972"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}