-
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
-
-
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>
-
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."
-
I meant os vesion: Solaris 2.7 for example?
-
just out of interest, if you dont haev access to the physical server - what does it matter?
-
yes.You can get details of OS via saloris commands
-
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.
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|