Display the Database Version and Server Operating System Name:-
-----------------------------------------------------------------------------
The following query gives the version of the Oracle Database.
SELECT banner FROM v$version;
Example:-
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
From above information, we can say this is 10g Database and Server Operating system is Linux.
The following query can be used to get the version of the Server Operating system.
BEGIN
dbms_output.put_line('Port String: '||dbms_utility.port_string);
END;
Example:-
Port String: Linuxi386/Linux-2.0.34-8.1.0
From the above information, we can say this is Linux Operating system and version is 2.0.34-8.1.0
Note:- If you are login into the server with some ID then you can also know the name and version of the Server Operating system directly by typing
> uname
Subscribe to:
Post Comments (Atom)
3 comments:
Path Infotech is in the field of oracle training program from past several years.
For more info : Oracle Database Training
Sometime few educational blogs become very helpful while getting relevant and new information related to your targeted area. As I found this blog and appreciate the information delivered to my database.
HPE ProLiant DL560 Gen9
Learned a lot of new things from your post, It's amazing blog
Oracle SOA Online Training
Post a Comment