System and Oracle

Tuesday, 19 February 2019

How to rescan and recover LUN paths in a host after modifying SLM reporting nodes

Microsoft Windows hosts:

Rescan after add-reporting-nodes and remove-reporting-nodes using Windows GUI.
1. Open Computer Management (Local)
2. In the console tree, click Computer Management (Local) >> Storage >> Disk Management
3. In the disk management page click Action >> Rescan Disks. This will rescan all the disks and update any path changes.
Rescan after add-reporting-nodes and remove-reporting-nodes using command line.
1. Open Command Prompt and enter the following text:
  # diskpart
2. At the DISKPART> prompt, enter the following text:
  DISKPART> rescan.
  This will rescan all the disks and updates any path changes. For more information, see Microsoft TechNet Updatedisk.
3. Linux hosts:
4. Rescan after add-reporting-nodes.
  1. Starting RHEL 6.5 & RHEL 7.0 onwards, run the following command to update active/optimized paths afteradd-reporting-nodes:
    # /usr/bin/rescan-scsi-bus.sh –a
  2. For RHEL 5 and RHEL 6.4 (including previous updates), run the following command to update active/optimized paths after add-reporting-nodes:
    # /usr/bin/rescan-scsi-bus.sh
    Note: Nothing additional has to be done in the multipath layer.
5. Rescan after remove-reporting-nodes
  1. Separate rescan steps are required for SCSI layer and Multipathing layer in Linux storage stack to clean up stale disk paths after remove-reporting-nodes in SLM.
  2. Run the following command to remove stale LUN paths in SCSI layer
    # /usr/bin/rescan-scsi-bus.sh –r
  3. Next run the following command to remove stale LUN paths in multipath layer:
    # multipath -r
    Solaris hosts:
  4. Rescan after add-reporting-nodes
    1. For iSCSI LUNs, run the following command:
      # devfsadm -i iscsi
    2. For FC/FCoE LUNs, perform the following steps:
      1. Run the following command to identify OS Device name of the HBA ports that are accessing NetApp LUNs:
        # cfgadm -al -o show_FCP_dev | grep fc-fabric c3 fc-fabric connected configured unknown c4 fc-fabric connected configured unknown
      2. Now run the following command for each <controller> to be rescanned:
        # cfgadm -c configure <controller>
        For example from Step1 c3 & c4 are the controller names and so the command would be: # cfgadm -c configure c3 # cfgadm -c configure c4
  5. Rescan after remove-reporting-nodes
    1. For iSCSI LUNs, run the following command:
      # devfsadm -i iscsi # devfsadm -Cv
    2. For FC/FCoE LUNs, perform the following steps:
      1. If the host is accessing NetApp LUNs using a single FC port, then it is advised to reboot the host. Run the following commands to reconfigure and reboot the host.
        # touch /reconfigure # init 6
      2. But if host is accessing NetApp LUNs with 2 or more FC ports, then run the following commands to identify OS Device names of the HBA ports:
        # cfgadm -al -o show_FCP_dev | grep fc-fabric c3 fc-fabric connected configured unknown c4 fc-fabric connected configured unknown
      3. Run the following command to reconfigure each port one after the other:
        # cfgadm -c unconfigure <controller> # cfgadm -c configure <controller>
        For example from above output c3 & c4 are the controller names and so the commands would be similar to the following:
        # cfgadm -c unconfigure c3 # cfgadm -c configure c3 # cfgadm -c unconfigure c4 # cfgadm -c configure c4
        Note: Above step should be peformed only for one port at a time.
      4. Run the following command to clean up the devices:
        # devfsadm -Cv
      5. To clear MPxIO entries, an OS reboot is needed and this can be performed during a planned downtime. Run the following command to reconfigure and reboot the host:
        # touch /reconfigure # init 6
      6. Once the host is back after reboot, run the following command :
        # devfsadm -Cv

Monday, 11 February 2019

HBA Debugging Fiber

mpathadm list LU

$ fcinfo hba-port -l 2100000e1eca86e1

$ fcinfo hba-port -l 2100000e1eca86e0

Sunday, 10 February 2019

SSH Passwordless Login Using SSH Keygen in 5 Easy Steps

SSH Client : 10.11.1.x
SSH Remote Host : 10.88.1.x

Step 1: Create Authentication SSH-Kegen Keys on –10.11.1.x

$ ssh-keygen -t rsa

Generating public/private rsa key pair.
Enter file in which to save the key (/home/tecmint/.ssh/id_rsa): [Press enter key]
Created directory '/home/tecmint/.ssh'.
Enter passphrase (empty for no passphrase): [Press enter key]
Enter same passphrase again: [Press enter key]
Your identification has been saved in /home/tecmint/.ssh/id_rsa.
Your public key has been saved in /home/tecmint/.ssh/id_rsa.pub.
The key fingerprint is:
5f:ad:40:00:8a:d1:9b:99:b3:b0:f8:08:99:c3:ed:d3 tecmint@tecmint.com
The key's randomart image is:
+--[ RSA 2048]----+
|        ..oooE.++|
|         o. o.o  |
|          ..   . |
|         o  . . o|
|        S .  . + |
|       . .    . o|
|      . o o    ..|
|       + +       |
|        +.       |
+-----------------+

Step 2: Create .ssh Directory on – 10.88.1.x

ssh oracle@10.88.1.X mkdir -p .ssh

The authenticity of host '10.88.1.X (10.88.1.X)' can't be established.
RSA key fingerprint is 45:0e:28:11:d6:81:62:16:04:3f:db:38:02:la:22:4e.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.88.1.X' (ECDSA) to the list of known hosts.
oracle@10.88.1.X's password: [Enter Your Password Here]

Step 3: Upload Generated Public Keys to –10.88.1.x

$ cat .ssh/id_rsa.pub | ssh oracle@10.88.1.X 'cat >> .ssh/authorized_keys'

oracle@10.88.1.X's password: [Enter Your Password Here]

Step 4: Set Permissions on –10.88.1.x

ssh oracle@10.88.1.X "chmod 700 .ssh; chmod 640 .ssh/authorized_keys"

oracle@10.88.1.X's password: [Enter Your Password Here]

Step 5: Login from 10.11.1.X to 10.88.1.x Server without Password

 ssh oracle@10.88.1.X

Wednesday, 6 February 2019

How to disable cleartext authentication mechanisms in the AMQP configuration.

Solutions:

To disable PLAIN authentication method can be done in two methods

1.By removing cyrus-sasl-plain package because for each mechanism corresponding package is required.

#yum remove cyrus-sasl-plain

#/etc/init.d/qpidd restart

Or

2. SASL is a framework that supports a variety of authentication methods like CRAM-MD5, DIGEST-MD5, or GSSAPI. Edit qpidd file and append this mech_list parameter and provide authentication method as below.

#vi etc/sasl2/qpidd.conf
mech_list: DIGEST-MD5

#/etc/init.d/qpidd restart  

Sunday, 27 January 2019

how to disable/enable firewalld for linux 7

# systemctl status firewalld

firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
   Active: active (running) since Thu 2014-09-04 19:18:47 EST; 3 months 28 days ago
 Main PID: 539 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─539 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

Sep 04 19:18:45 rhel7 systemd[1]: Starting firewalld - dynamic firewall daemon...
Sep 04 19:18:47 rhel7 systemd[1]: Started firewalld - dynamic firewall daemon.

# service firewalld stop

Redirecting to /bin/systemctl stop  firewalld.service

# service firewalld start

 Redirecting to /bin/systemctl start  firewalld.service

# systemctl disable firewalld
rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
rm '/etc/systemd/system/basic.target.wants/firewalld.service'

# systemctl enable firewalld
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
ln -s '/usr/lib/systemd/system/firewalld.service' '/etc/systemd/system/basic.target.wants/firewalld.service'

Thursday, 27 December 2018

report service kill command

kill -9 $(ps -ef | grep [N]odeManager | awk '{print $2}')

kill -9 $(ps -ef | grep oracle | grep report | awk '{print $2}')

Monday, 17 December 2018

NFS volume mount in solaris 11

svcs -a |grep nfs

On NFS server

# share -F nfs -o rw=[accesslist] /path/to/share

# share -F nfs -o rw=client1,client2 /export

# share -F nfs -o rw=@client1:/export /export

# showmount -e

On NFS client

# mount -F nfs -o [options] [NFS_server]:[mountpoint]

  # mount -F nfs  10.11.1.xxx:/BARMAN /BARMAN

  # mount -F nfs -o rsize=32768,wsize=32768  10.11.1.xxx:/BARMAN /BARMAN

NFS volume mount in RedHat linux 7.6

For Database server:

# groupadd nfs
# usermod -a -G nfs nfsnobody
# chmod 0770 /nfs
# chgrp nfs /nfs

vi /etc/exports

/nfs box1(rw,sync,sec=krb5,anongid=1004)

/u01 * (rw,sync,all_squash,anonuid=54321,anongid=54321)

# exportfs -arv

service nfs start/stop/restart/status

local directory: /hrm/PDF

For Application:

mount -t nfs 10.11.1.XXX:/hrm/PDF /u01/orbhrm/pdf/
mount -t nfs -O user=oracle,pass=oracle,file_mode=0777,dir_mode=0777,uid=oracle,gid=oinstall 10.11.1.XXX:/u05/test /u05/test

local Directory: /u01/orbhrm/pdf

entry /etc/fstab

server:/usr/local/pub    /pub   nfs    defaults 0 0

10.11.1.xxx:/hrm/PDF /u01/orbhrm/pdf nfs defaults 0 0