Wednesday, July 1, 2015

Converting .ppk to OpenSSH

PuTTY Private Key (.ppk) could be exported to an OpenSSH key allowing it to be used with an OpenSSH client on linux terminal.
1. The private key contained within the ppk is exported to OpenSSH with the use of puttygen.exe
2. Run puttygen.exe and load the existing private key file

Same could be achieved on command line with
puttygen.exe puttykey.ppk  -O private-openssh
When the file is loading it will prompt for the passphrase.
3. Once the correct passphrase is entered the private key will be loaded.

4. Select "Export OpenSSH key" item under the conversions menu and save the key.

5. Copy the key file to linux server to be be used with the OpenSSH client.



6. Change the protection of the key file to 400. Without it ssh client will issue the following warning and will not connect.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@         WARNING: UNPROTECTED PRIVATE KEY FILE!          @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Permissions 0644 for 'myssh.key' are too open.
It is recommended that your private key files are NOT accessible by others.
This private key will be ignored.
bad permissions: ignore key: myssh.key
Once the file permission is changed, it could be used with the OpenSSH client.
chmod 400 myssh.key
$ ssh oracle@dbserver  -p 2356 -i myssh.key
Enter passphrase for key 'myssh.key':

Monday, June 22, 2015

Can't exec "/usr/bin/lsb_release": No such file or directory at GI_HOME/lib/osds_acfslib.pm line 564

Following was observed during the GI PSU 11.2.4.0.6 patch application
2015-06-15 11:19:01: acfs is supported
2015-06-15 11:19:01: Executing '/opt/app/oracle/product/11.2.0/grid_4/bin/acfsroot install'
2015-06-15 11:19:01: Executing cmd: /opt/app/oracle/product/11.2.0/grid_4/bin/acfsroot install
2015-06-15 11:23:00: Command output:
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9300: ADVM/ACFS distribution files found.
>  ACFS-9312: Existing ADVM/ACFS installation detected.
>  ACFS-9314: Removing previous ADVM/ACFS installation.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9315: Previous ADVM/ACFS components successfully removed.
>  ACFS-9307: Installing requested ADVM/ACFS software.
>  ACFS-9308: Loading installed ADVM/ACFS drivers.
>  ACFS-9321: Creating udev for ADVM/ACFS.
>  ACFS-9323: Creating module dependencies - this may take some time.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9154: Loading 'oracleoks.ko' driver.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9154: Loading 'oracleadvm.ko' driver.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9154: Loading 'oracleacfs.ko' driver.
>  Can't exec "/usr/bin/lsb_release": No such file or directory at /opt/app/oracle/product/11.2.0/grid_4/lib/osds_acfslib.pm line 564.
>  ACFS-9327: Verifying ADVM/ACFS devices.
>  ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
>  ACFS-9156: Detecting control device '/dev/ofsctl'.
>  ACFS-9309: ADVM/ACFS installation correctness verified.
>End Command output



The environment is OEL 6 (2.6.32-358.18.1.el6.x86_64).
Reason for this error is bug 17359415. Install redhat-lsb-core-4.0*.el6.x86_64 rpm to fix this problem.
# yum install redhat-lsb-core-4.0*.el6.x86_64
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package redhat-lsb-core.x86_64 0:4.0-7.0.1.el6 will be installed

Sunday, June 14, 2015

"Error: Multilib version problems found" When Installing Required RPMS on OEL 6

Following error could be seen while trying to install required RPMS as part of 12c pre-req task (1529864.1). OS is OEL 6 (2.6.32-358.18.1.el6.x86_64).
yum install libXi.i686
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXi.i686 0:1.7.2-2.2.el6 will be installed
--> Processing Dependency: libXext.so.6 for package: libXi-1.7.2-2.2.el6.i686
--> Running transaction check
---> Package libXext.x86_64 0:1.3.1-2.el6 will be updated
---> Package libXext.i686 0:1.3.2-2.1.el6 will be installed
---> Package libXext.x86_64 0:1.3.2-2.1.el6 will be an update
--> Finished Dependency Resolution
Error:  Multilib version problems found. This often means that the root
       cause is something else and multilib version checking is just
       pointing out that there is a problem. Eg.:

         1. You have an upgrade for libXi which is missing some
            dependency that another package requires. Yum is trying to
            solve this by installing an older version of libXi of the
            different architecture. If you exclude the bad architecture
            yum will tell you what the root cause is (which package
            requires what). You can try redoing the upgrade with
            --exclude libXi.otherarch ... this should give you an error
            message showing the root cause of the problem.

         2. You have multiple architectures of libXi installed, but
            yum can only see an upgrade for one of those arcitectures.
            If you don't want/need both architectures anymore then you
            can remove the one with the missing update and everything
            will work.

         3. You have duplicate versions of libXi installed already.
            You can use "yum check" to get yum show these errors.

       ...you can also use --setopt=protected_multilib=false to remove
       this checking, however this is almost never the correct thing to
       do as something else is very likely to go wrong (often causing
       much more problems).

       Protected multilib versions: libXi-1.7.2-2.2.el6.i686 != libXi-1.6.1-3.el6.x86_64
 You could try using --skip-broken to work around the problem
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64 has missing requires of kernel-uek
oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64 has missing requires of kernel-uek
In this case the root cause as the output suggested was that i686 version of the rpm was of higher version than already installed x86_64 version.


To resolve this update the currently installed x86_64 version and then install the i686 version.
yum update libXi
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package libXi.x86_64 0:1.6.1-3.el6 will be updated
...

yum install libXi.i686
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXi.i686 0:1.7.2-2.2.el6 will be installed
....
Useful metalink notes
Yum update command fails with error around multilib missmatch [ID 1670710.1]
Troubleshooting Common Issues While Registering RHEL Servers With ULN [ID 1984132.1]
Error "Transaction Check Error: file /etc/pki/rpm-gpg/RPM-GPG-KEY from ... " When Upgrading Oracle Linux Server [ID 1996064.1]