DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: what OS oracle is running on ?

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    what OS oracle is running on ?

    Hi,
    Is there any dictionary view/or any way by which i can find out whether my Oracle is running on which operating system.
    I have access to all the data dictionary tables; but not to the OS. I use some third party tool to connect to many remote servers.
    Could somebody tell me about this...

    Regards

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    try v$version

  3. #3
    Join Date
    Jun 2000
    Posts
    295
    pando,

    I could not see os from V$version:

    SQL> select * from V$version;

    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    PL/SQL Release 8.1.7.2.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for Solaris: Version 8.1.7.2.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production

    SQL>

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by sysdba
    pando,

    I could not see os from V$version:

    SQL> select * from V$version;

    BANNER
    ----------------------------------------------------------------
    Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    PL/SQL Release 8.1.7.2.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for Solaris: Version 8.1.7.2.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production

    SQL>
    Its Solaris.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Jun 2000
    Posts
    295
    I meant os vesion: Solaris 2.7 for example?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    just out of interest, if you dont haev access to the physical server - what does it matter?

  7. #7
    Join Date
    Aug 2002
    Posts
    10
    yes.You can get details of OS via saloris commands

  8. #8
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    Try this:


    SQL> SELECT DBMS_UTILITY.port_string FROM dual;

    PORT_STRING
    ---------------------------------------------
    DEC Alpha OSF/1, r1.1-8.1.0

    1 row selected.

    SQL>


    Cheers
    Last edited by TimHall; 09-24-2003 at 03:37 AM.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by TimHall
    Hi.

    Try this:


    SQL> SELECT DBMS_UTILITY.port_string FROM dual;

    PORT_STRING
    ---------------------------------------------
    DEC Alpha OSF/1, r1.1-8.1.0

    1 row selected.

    SQL>


    Cheers
    I am afraid, i aint getting it for WIN 2K, rather getting it as WIN_NT

    PS

    Code:
    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.
    
    C:\>sqlplus abhay/abhay
    
    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 24 13:49:20 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    
    
       USER_ID USER_NAME
    ---------- ------------------------------
            21 ABHAY
    
    
    DB_NAME
    --------------------------------------------------------------------------------
    TEST
    
    TEST:ABHAY> SELECT DBMS_UTILITY.port_string FROM dual;
    
    PORT_STRING
    ----------------------------------------------------------------------------------
    IBMPC/WIN_NT-8.1.0
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dont think thats very usefull

    Code:
    ttd$oracle7@E73GC04>!uname -a
    SunOS SSESMADT001 5.6 Generic_105181-26 sun4u sparc SUNW,Ultra-Enterprise
    
    ttd$oracle7@E73GC04>select dbms_utility.port_string OS from dual;
    
    OS
    ------------------------------
    SVR4-be-7.0.0
    doesnt say Solaris 5.6 anywhere

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