Month: March 2014

Unix Technologies

Linux: finding System Hardware Information – Manufacturer, Model/Product Name, Serial Number and Physical Sockets, Processors/CPUs, Cores

Finding Hardware Manufacturer, Model/Product Name, Serial Number:   [root@ProdDB01 ~]# dmidecode -t system # dmidecode 2.7 SMBIOS 2.3 present. Handle 0x0100, DMI type 1, 25 bytes. System Information         Manufacturer: HP         Product Name: ProLiant DL385 G1         Version: Not Specified         Serial Number: UXXXXXXXXXX         UUID: 3xxxx1x1-3xx8-3xx3-4xx5-3xxxxxxxxx48         Wake-up Type: Power Switch Handle 0x2000, DMI type 32, 11 bytes. System Boot Information         Status: Firmware-detected hardware failure [root@ProdDB01 ~]#   Reference: Get Hardware Information using Dmidecode Command in Linux   Finding Physical Sockets, Processors, Model, Cores: You can find all of the details about system processor from below file […]

Read more
DataBase

Oracle DataBase licensing Options and queries

How to find the Edition of your Oracle Database: [root@ProdDB01 ~]# su – oracle -bash-3.1$ sqlplus ‘/ as sysdba’ SQL*Plus: Release 8.1.6.0.0 – Production on Tue Mar 25 12:32:46 2014 (c) Copyright 1999 Oracle Corporation.  All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production With the Partitioning option JServer Release 8.1.6.0.0 – Production SQL> select banner from v$version; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production PL/SQL Release 8.1.6.0.0 – Production CORE    8.1.6.0.0       Production TNS for Linux: Version 8.1.6.0.0 – Production NLSRTL Version 3.4.0.0.0 – Production SQL> No. of Users and CPU/Processors: SQL> select * from […]

Read more