查看各版本号

悠悠 2023-06-17 07:59 15阅读 0赞

一、oracle服务器版本号

1 select\* from v$version;

![20191128104708289.png][]  
   2 select \* from product\_component\_version;

![20191128104722187.png][]

二、mysql服务器版本号

数据库中查询

1 select version();

![2019112810572337.png][]

2 服务器端查询

mysql --version

三、linux操作系统版本号

**1、查看当前操作系统内核信息**

**uname -a**

$ uname -a

Linux vm-web 3.10.0-693.21.1.el7.x86\_64 \#1 SMP Wed Mar 7 19:03:37 UTC 2018 x86\_64 x86\_64 x86\_64 GNU/Linux

**2、查看当前操作系统版本信息**

**cat /proc/version**

$ cat /proc/version

Linux version 3.10.0-693.21.1.el7.x86\_64 ([builder@kbuilder.dev.centos.org][builder_kbuilder.dev.centos.org]) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC) ) \#1 SMP Wed Mar 7 19:03:37 UTC 2018

**3、查看当前操作系统发行版信息**

**cat /etc/issue 或 cat /etc/redhat-release**

$ cat /etc/issue

\\S

Kernel \\r on an \\m

$ cat /etc/redhat-release

CentOS Linux release 7.4.1708 (Core)

**4、查看cpu相关信息，包括型号、主频、内核信息等**

**cat /proc/cpuinfo**

$ cat /proc/cpuinfo

**5、列出所有版本信息**

**lsb\_release -a**

$ lsb\_release -a

\-bash: lsb\_release: command not found

出现command not found说明没安装lsb\_realease，可以执行命令yum install -y redhat-lsb安装lsb\_realease，安装完成后，版本信息如下：

$ lsb\_release -a

LSB Version:    :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch

Distributor ID:    CentOS

Description:    CentOS Linux release 7.4.1708 (Core)

Release:    7.4.1708

Codename:    Core

[20191128104708289.png]: https://img-blog.csdnimg.cn/20191128104708289.png
[20191128104722187.png]: https://img-blog.csdnimg.cn/20191128104722187.png
[2019112810572337.png]: https://img-blog.csdnimg.cn/2019112810572337.png
[builder_kbuilder.dev.centos.org]: mailto:builder@kbuilder.dev.centos.org