Sunday, December 23, 2018

OpenSSL - Installation under Windows

  1. Download the OpenSSL for Windows installation package.
  1. If the following error message appears, you should install Microsoft Visual C++ 2008 Redistributables. The installation file can be downloaded here.

clip_image001

  1. Double-click the installation file and click on Next

clip_image002

  1. Click on I accept the agreement, followed by Next.

clip_image003

  1. Leave the default installation path (C:\OpenSSL-Win32) and click on Next.

clip_image003[1]

  1. Leave the default Startmenu folder(OpenSSL) and click on Next.

clip_image004

  1. Leave the The Windows system directory and click on Next.

clip_image005

  1. Click on Install.

clip_image006

  1. Click on Finish once the installation has been completed.

OpenSSL for Windows has now been installed and can be found as OpenSSL.exe in C:\OpenSSL-Win32\bin\. Run as Administrator.

Note: The following error message might appear when running OpenSSL:

WARNING: can't open config file: /usr/local/ssl/openssl.cnf

Follow the steps to resolve this:

  1. Close OpenSSL.
  2. Open a Command Prompt (CMD) as Administrator
  3. Run the following command: SET OPENSSL_CONF=C:\OpenSSL-Win32\bin\openssl.cfg
  4. Reboot the computer.

Wednesday, December 19, 2018

Supermicro ipmi keyboard not working

IPMI console Keyboard and mouse is not working. And the console virtual keyboard also not working.

Goto > Maintainance > IKVM Reset

By resetting this Virtual media, IKVM keyboard and Mouse functionality will be reset.

clip_image001

You can also check Input settings in Preference.

clip_image002

Tuesday, December 18, 2018

Supermicro SuperDoctor 5 Installation steps guide

SD5 monitors target nodes hardware's system health or availability in data centers in real-time and provide alerts to administrators.

SuperDoctor® 5 Key Benefits and Features

Supports monitoring, control, and management functions.
- Hardware Monitoring: fan speed, temperature, voltage, chassis intrusion, redundant power failure, power consumption, disk health, raid health, and memory health.
- 20 Types of system information: BIOS, Baseboard, Chassis, Computer System, Disk Drives, Memory, Network, Printer, Processor, System Slot, IPMI, Power Supply, Account, Operating System, Process, Service, Share, Time Zone, OEM Strings, and System Cfg Options.

Download the setup from below link:

https://www.supermicro.com/products/nfo/SMS_SD5.cfm

clip_image001

Start the installer and proceed to next steps as per your requirements.

clip_image002

clip_image003

clip_image004

clip_image005

clip_image006

clip_image007

clip_image008

clip_image009

clip_image010

clip_image011

clip_image012

Login links : https://localhost:8444

Username : ADMIN

Password : ADMIN

clip_image013

clip_image014

Windows Server 2012 not booting on ESXi 5.0

clip_image001

Windows Server 2012 not booting on ESXi 5.0

  • Create a new VM over the vSphere Client.
  • As “Guest Operating System” use Microsoft Windows Server 2008 R2 (64-bit)”
  • After VM has been created but before first power on, download the following bios file(http://communities.vmware.com/servlet/JiveServlet/download/2139717-98102/bios.440.rom ) and upload it to your ESXi datastore into the folder of the VM
  • Now open the .vmx file of the new VM and add the follwing lines

bios440.filename = "bios.440.rom"

mce.enable = TRUE

cpuid.hypervisor.v0 = FALSE

vmGenCounter.enable = FALSE

Power on VM and Server 2012 will install and run

How to Enable SA Account in SQL Server 2014

    clip_image001

    backup failed for server (microsoft.sqlserver.smoextended)

    Enable the sa Login:

    1. Connect to the SQL Server instance using SSMS and go to Security. Expand Security, go to Logins.

    2.  You can see the sa account is disabled when you install SQL Server using Windows Authentication mode.

    clip_image002

    3. Right-click on the sa account and go to Login Properties

    clip_image003

    By default, the Enforce password policy is checked. (if you don’t want to provide a complex password for the sa account, you can uncheck this option. However, this is not recommended.)

    4. Click on the Status page. By default, the sa account will be disabled. Click on the Enabled button to enable the sa account. Click on Ok to close the sa Login Properties.

    clip_image004

    sa account is enabled and you will be able to login to the SQL instance using the sa account.

    Method 2:

    Enable SQL Server SA Account with Script

    1. Login into SQL Server using Windows Authentication mode and open Management Studio.

    2. Click "New Query" to create a query, and type followings:

    USE [master]

    GO

    ALTER LOGIN [sa] WITH PASSWORD='password'

    GO

    ALTER LOGIN [sa] ENABLE

    GO

    Method 3:

    1. In SQL Server Configuration Manager, in the left pane, select SQL Server Services. In the right-pane, find your instance of SQL Server. (The default instance of SQL Server includes (MSSQLSERVER) after the computer name. Named instances appear in upper case with the same name that they have in Registered Servers.) Right-click the instance of SQL Server, and then click Properties.
    2. On the Startup Parameters tab, in the Specify a startup parameter box, type -m and then click Add. (That's a dash then lower case letter m.)
    3. Click OK, and after the message to restart, right-click your server name, and then click Restart.
    4. After SQL Server has restarted your server will be in single-user mode. Make sure that that SQL Server Agent is not running. If started, it will take your only connection.
    5. On the Windows 8 start screen, right-click the icon for Management Studio. At the bottom of the screen, select Run as administrator. (This will pass your administrator credentials to SSMS.)

Sunday, December 16, 2018

Oracle Database 12 Release 2 Installation Step By Step on Window Server 2008

    If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Auto run feature opens the Select a Product to install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer.
    Download the setup Oracle 12C_(12.2) extract the file
    http://download.oracle.com/otn/nt/oracle12c/122010/winx64_12201_database.zip?AuthParam=1500618276_6bc47c2af4b28270b85c489742e6f3b5
    Link : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.html
    winx64_12201_database.zip
    Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software.
    clip_image001
    The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window.
    clip_image002
    clip_image003
    Select the yes if not given the email address
    clip_image004
    Select any of the following install options.
    I selected the
    • Create and configure a database
    Then Next ,
    clip_image005
    Now , Select the System Class and Next.
    clip_image006
    Select the type of database installation from the following.
    I selected
    • Single Instance database Installation
    Then Next,
    clip_image007
    The Select Install Type window appears. Select "Advanced install." Click Next.
    clip_image008
    Now Choose the Database Edition want to install.
    I Selected the * Enterprise Edition and Next.
    clip_image009
    On this screen specify the Oracle Home User
    I create New Windows User
    User Name: sys
    Password : ******
    Now Next it.
    And give Oracle base path browse where want to install.
    clip_image010
    Next,
    clip_image011
    Select Configuration Type
    I selected * General Purpose / Transaction Processing
    clip_image012
    Specify Database Identifiers
    Global Database name: orcl
    Oracle system identifier: orcl
    Choose Create as Container database or unselect this.
    Pluggable database name: orclpdb
    Then Next,
    On Next screen choose the Enable Automatic Memory Management
    clip_image013
    On Character sets choose the following option
    I selected * Use Unicode (AL32UTF8)
    clip_image014
    On next tab Sample schemas can be installed.
    clip_image015
    On Next screen Specify Database Storage options
    clip_image016
    clip_image017
    You can Enable Recovery and give File system location
    clip_image018
    On next screen enter the credentials for different accounts
    clip_image019
    On next screen Prerequisite Checks will run.
    clip_image020
    clip_image021
    Now select the “Install” to install the database.
    clip_image022
    Now it’s installed Oracle Database 12 Release 2.

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...