Wednesday, December 11, 2013

How to identify Machine manufacturer and model information

AIX

# prtconf

HP UX

# model
# /usr/bin/arch -k
#machineinfo

Linux

# dmidecode system-manufacturer
dmidecode 2.9
SMBIOS entry point at 0xcf52db98
SMBIOS 2.7 present.
88 structures occupying 3180 bytes.
Table at 0x000E8827.

Handle 0x0000, DMI type 0, 24 bytes
BIOS Information
        Vendor: Hewlett-Packard
        Version: J01 v02.15
        Release Date: 11/10/2011
        Address: 0xF0000
        Runtime Size: 64 kB
        ROM Size: 1024 kB
        Characteristics:
                PCI is supported
                PNP is supported
                BIOS is upgradeable
                BIOS shadowing is allowed
                Boot from CD is supported
                Selectable boot is supported
                EDD is supported
                Print screen service is supported (int 5h)
                8042 keyboard services are supported (int 9h)
                Serial services are supported (int 14h)
                Printer services are supported (int 17h)
                ACPI is supported
                USB legacy is supported
                BIOS boot specification is supported
                Function key-initiated network boot is supported
                Targeted content distribution is supported
        BIOS Revision: 2.15


Solaris

# prtdiag
System Configuration:  Sun Microsystems  sun4u Sun SPARC Enterprise M4000 Server
System clock frequency: 1012 MHz
Memory size: 16384 Megabytes



Tuesday, December 10, 2013

Oracle Database: Drop Database

$ sqlplus / as sysdba
SQL> select * from v$instance;
SQL> shutdown immediate;
SQL> startup mount exclusive restrict;
SQL> drop database;