Showing version number
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Showing version number

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    I just applied a patch to my version of Oracle (8.1.7.2.1) on a WinNT 4.0 machine. According to the patch:

    Note: All the products supplied in this patch may NOT display
    the version Number 8.1.7.2.5, because of cumulative patch.

    Oracle Server version number is displayed as 8.1.7.2.1.


    Is there a way to verify that the patch was actually installed? If I can't verify the version number through v$version, then how do I verify it is being used?

    Thanks.


  2. #2
    Join Date
    Jan 2001
    Posts
    3,131

    Lightbulb

    clear
    SET HEAD ON
    SET VERIFY OFF
    col instance_name form a8 Heading "Instance"
    col name form a8 Heading "DB Name"
    col host_name form a12 Heading "Hostname"
    select version
    ,name
    ,log_mode
    ,host_name
    ,created
    /* ,open_mode - v8i only */
    from v$database, v$instance;


    Try this script, I put it on all my boxes (Unix and NT) as a quick reference. I named it NAME.SQL this way all I have to do is type name at a SQL prompt and I will know what instance I am logged into. If you support multiple instance this is a real timesaver. Beats the heck out of ..
    SQL> select * from global_name;

    MH

    Ps. I think I stole this script from this webpage.

  3. #3
    Join Date
    Aug 2001
    Posts
    390
    opc2b,

    even after you apply the 8.1.7.2.5, you won't see the 5 and you still see 8.1.7.2.1. As long as you follow the instructions to aplly the 8.1.7.2.5 patchset , you should be ok


  4. #4
    Join Date
    Sep 2001
    Posts
    163
    Unfortunatly, it does show what I want. It does show version 8.1.7.2.1, but I'm still not able to verify that the patch was successfully installed. I guess I just have to go on faith that the patch was successful if my DB doesn't crash. (Which is a huge leap of faith being that we are talking about Oracle Corp.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width