Monday 5 April 2021

SLES 12 SP4 DNS configuration for RAC setup 12 R1

 SLES 12 SP4 DNS configuration for RAC setup 12 c


Operating System: SLES 12 SP4 64 bit

  •  zypper -n install bind-chrootenv
  • resolv.conf
  • forward.zone
  • named.rfc1912.zones
  • service named status
  • nslookup srv-scan
  • /etc/hosts



  • resolv.conf
srv1:/var/lib/named/etc # cat /etc/resolv.conf
### /etc/resolv.conf file autogenerated by netconfig!
#
# Before you change this file manually, consider to define the
# static DNS configuration using the following variables in the
# /etc/sysconfig/network/config file:
#     NETCONFIG_DNS_STATIC_SEARCHLIST
#     NETCONFIG_DNS_STATIC_SERVERS
#     NETCONFIG_DNS_FORWARDER
# or disable DNS configuration updates via netconfig by setting:
#     NETCONFIG_DNS_POLICY=''
#
# See also the netconfig(8) manual page and other documentation.
#
# Note: Manual change of this file disables netconfig too, but
# may get lost when this file contains comments or empty lines
# only, the netconfig settings are same with settings in this
# file and in case of a "netconfig update -f" call.
#
### Please remove (at least) this line when you modify the file!
search suse
search example.com
nameserver srv-scan.example.com
domain example.com

srv1:/var/lib/named/etc #

:~# chattr +i /etc/resolv.conf (to make permanent entry on resolv.conf entry)
  • forward.zone

srv1:/var/lib/named/etc # vi  forward.zone

; /var/lib/named/etc/forward.zone

$TTL 86400

@ IN SOA srv-scan.example.com. root.srv-scan.example.com. (

     0 ; serial

     1D ; refresh

     1H ; retry

     1W ; expire

     3H ) ; minimum

     IN NS srv-scan.example.com.

srv-scan A 192.168.56.91

srv-scan A 192.168.56.92

srv-scan A 192.168.56.93


  • named.rfc1912.zones

srv1:/var/lib/named/etc #vi named.rfc1912.zones

// See /usr/share/doc/bind*/sample/ for example named configuration files.

//

zone "." IN {

type hint;

file "named.ca";

};

zone "example.com" IN {

type master;

file "forward.zone";

allow-update { none; };

};

zone "localhost" IN {

type master;

file "localhost.zone";

allow-update { none; };

};

zone "56.168.192.in-addr.arpa" IN {

type master;

file "reverse.zone";

allow-update { none; };

};

#zone "0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa" IN {

#type master;

#file "named.ip6.local";

#allow-update { none; };

#};

zone "255.in-addr.arpa" IN {

type master;

file "named.broadcast";

allow-update { none; };

};

#zone "0.in-addr.arpa" IN {

#type master;Oracle 11gR2 RAC On VM - INSTALLATION

#www.reachdba.com | www.dbalounge.com | info@dbalounge.com | 011-40581394

#file "named.zero";

#allow-update { none; };

#};

  • reverse.zone

srv1:/var/lib/named/etc # vi  reverse.zone

;  /var/lib/named/etc/reverse.zone

$TTL 86400

@ IN SOA srv-scan.example.com. root.srv-scan.example.com. (

    0 ; serial

    1D ; refresh

    1H ; retry

    1W ; expire

    3H ) ; minimum

    NS srv-scan.example.com.

91 PTR srv-scan.example.com.

92 PTR srv-scan.example.com.

93 PTR srv-scan.example.com.

srv1:/var/lib/named/etc #


  • service named status
  • service named stop
  • service named start

srv1:/var/lib/named/etc # service named status

● named.service - LSB: Domain Name System (DNS) server, named

   Loaded: loaded (/etc/init.d/named; bad; vendor preset: disabled)

   Active: active (running) since Wed 2021-04-07 12:41:50 IST; 10min ago

     Docs: man:systemd-sysv-generator(8)

  Process: 11711 ExecStop=/etc/init.d/named stop (code=exited, status=0/SUCCESS)

  Process: 11738 ExecStart=/etc/init.d/named start (code=exited, status=0/SUCCESS)

    Tasks: 4 (limit: 512)

   CGroup: /system.slice/named.service

           └─11787 /usr/sbin/named -t /var/lib/named -u named


Apr 07 12:41:50 srv1 named[11787]: managed-keys-zone: loaded serial 0

Apr 07 12:41:50 srv1 named[11787]: zone example.com/IN: loaded serial 0

Apr 07 12:41:50 srv1 named[11787]: zone 0.0.127.in-addr.arpa/IN: loaded serial 42

Apr 07 12:41:50 srv1 named[11787]: zone 56.168.192.in-addr.arpa/IN: loaded serial 0

Apr 07 12:41:50 srv1 named[11787]: zone localhost/IN: loaded serial 42

Apr 07 12:41:50 srv1 named[11787]: zone 0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: loaded serial 42

Apr 07 12:41:50 srv1 named[11787]: all zones loaded

Apr 07 12:41:50 srv1 named[11738]: Starting name server BIND ..done

Apr 07 12:41:50 srv1 systemd[1]: Started LSB: Domain Name System (DNS) server, named.

Apr 07 12:41:50 srv1 named[11787]: running

srv1:/var/lib/named/etc #


  • /etc/named.conf
srv1:/var/lib/named/etc # vi  /etc/named.conf

# Copyright (c) 2001-2004 SuSE Linux AG, Nuernberg, Germany.

# All rights reserved.

#

# Author: Frank Bodammer, Lars Mueller <lmuelle@suse.de>

#

# /etc/named.conf

#

# This is a sample configuration file for the name server BIND 9.  It works as

# a caching only name server without modification.

#

# A sample configuration for setting up your own domain can be found in

# /usr/share/doc/packages/bind/sample-config.

#

# A description of all available options can be found in

# /usr/share/doc/packages/bind/misc/options.


options {


        # The directory statement defines the name server's working directory


        directory "/var/lib/named";


        # enable DNSSEC validation

        #

        # If BIND logs error messages about the root key being expired, you

        # will need to update your keys. See https://www.isc.org/bind-keys

        #

        # dnssec-enable yes (default), indicates that a secure DNS service

        # is being used which may be one, or more, of TSIG

        # (for securing zone transfers or DDNS updates), SIG(0)

        # (for securing DDNS updates) or DNSSEC.


        #dnssec-enable yes;


        # dnssec-validation yes (default), indicates that a resolver

        # (a caching or caching-only name server) will attempt to validate

        # replies from DNSSEC enabled (signed) zones. To perform this task

        # the server also needs either a valid trusted-keys clause

        # (containing one or more trusted-anchors or a managed-keys clause.


        #dnssec-validation auto;

        managed-keys-directory "/var/lib/named/dyn/";


        # Write dump and statistics file to the log subdirectory.  The

        # pathenames are relative to the chroot jail.


        dump-file "/var/log/named_dump.db";

        statistics-file "/var/log/named.stats";


        # The forwarders record contains a list of servers to which queries

        # should be forwarded.  Enable this line and modify the IP address to

        # your provider's name server.  Up to three servers may be listed.


        #forwarders { 192.0.2.1; 192.0.2.2; };


        # Enable the next entry to prefer usage of the name server declared in

        # the forwarders section.


        #forward first;


        # The listen-on record contains a list of local network interfaces to

        # listen on.  Optionally the port can be specified.  Default is to

        # listen on all interfaces found on your system.  The default port is

        # 53.


        #listen-on port 53 { 127.0.0.1; };


        # The listen-on-v6 record enables or disables listening on IPv6

        # interfaces.  Allowed values are 'any' and 'none' or a list of

        # addresses.


        listen-on-v6 { any; };


        # The next three statements may be needed if a firewall stands between

        # the local server and the internet.


        #query-source address * port 53;

        #transfer-source * port 53;

        #notify-source * port 53;


        # The allow-query record contains a list of networks or IP addresses

        # to accept and deny queries from. The default is to allow queries

        # from all hosts.


        #allow-query { 127.0.0.1; };


        # If notify is set to yes (default), notify messages are sent to other

        # name servers when the the zone data is changed.  Instead of setting

        # a global 'notify' statement in the 'options' section, a separate

        # 'notify' can be added to each zone definition.


        notify no;


    disable-empty-zone "1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.IP6.ARPA";

};


# To configure named's logging remove the leading '#' characters of the

# following examples.

#logging {

#       # Log queries to a file limited to a size of 100 MB.

#       channel query_logging {

#               file "/var/log/named_querylog"

#                       versions 3 size 100M;

#               print-time yes;                 // timestamp log entries

#       };

#       category queries {

#               query_logging;

#       };

#

#       # Or log this kind alternatively to syslog.

#       channel syslog_queries {

#               syslog user;

#               severity info;

#       };

#       category queries { syslog_queries; };

#

#       # Log general name server errors to syslog.

#       channel syslog_errors {

#               syslog user;

#               severity error;

#       };

#       category default { syslog_errors;  };

#

#       # Don't log lame server messages.

#       category lame-servers { null; };

#};


# The following zone definitions don't need any modification.  The first one

# is the definition of the root name servers.  The second one defines

# localhost while the third defines the reverse lookup for localhost.


zone "." in {

        type hint;

        file "root.hint";

};


zone "localhost" in {

        type master;

        file "localhost.zone";

};


zone "0.0.127.in-addr.arpa" in {

        type master;

        file "127.0.0.zone";

};


zone "0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa" IN {

    type master;

    file "127.0.0.zone";

};

zone "example.com" IN {

type master;

file "forward.zone";

allow-update { none; };

};

zone "56.168.192.in-addr.arpa" IN {

type master;

file "reverse.zone";

allow-update { none; };

};


# Include the meta include file generated by createNamedConfInclude.  This

# includes all files as configured in NAMED_CONF_INCLUDE_FILES from

# /etc/sysconfig/named


include "/etc/named.conf.include";


# You can insert further zone records for your own domains below or create

# single files in /etc/named.d/ and add the file names to

# NAMED_CONF_INCLUDE_FILES.

# See /usr/share/doc/packages/bind/README.SUSE for more details.

srv1:/var/lib/named/etc #


  • Check using nslookup 

srv1:/var/lib/named/etc # nslookup srv-scan

Server:         127.0.0.1

Address:        127.0.0.1#53


Name:   srv-scan.example.com

Address: 192.168.56.93

Name:   srv-scan.example.com

Address: 192.168.56.91

Name:   srv-scan.example.com

Address: 192.168.56.92


srv1:/var/lib/named/etc # nslookup srv-scan

Server:         127.0.0.1

Address:        127.0.0.1#53


Name:   srv-scan.example.com

Address: 192.168.56.92

Name:   srv-scan.example.com

Address: 192.168.56.93

Name:   srv-scan.example.com

Address: 192.168.56.91


srv1:/var/lib/named/etc # nslookup srv-scan

Server:         127.0.0.1

Address:        127.0.0.1#53


Name:   srv-scan.example.com

Address: 192.168.56.93

Name:   srv-scan.example.com

Address: 192.168.56.91

Name:   srv-scan.example.com

Address: 192.168.56.92



  • cat /etc/hosts
127.0.0.1   localhost.localdomain localhost
# Public
192.168.56.71   srv1.example.com        srv1
192.168.56.72   srv2.example.com        srv2

# Private
192.168.10.1    srv1-priv.example.com   srv1-priv
192.168.10.2    srv2-priv.example.com   srv2-priv

# Virtual
192.168.56.81   srv1-vip.example.com    srv1-vip
192.168.56.82   srv2-vip.example.com    srv2-vip

# SCAN (in production this should be configured in DNS)
192.168.56.91   srv-scan.example.com    srv-scan
192.168.56.92   srv-scan.example.com    srv-scan
192.168.56.93   srv-scan.example.com    srv-scan

Canva Pitchdeck presentation Setting

 

Web blog Link : Sineflex PPT example

Hi everyone this is the small tutorial for pitch deck presentation. After large request some small tutorial for making presentations in pdf format as well as video using zoom.


 Canva Pitchdeck  presentation Setting 


  • Create user and login canva website.


  • Type pitch deck presentations in search area



  • Choose presentations slide after completing it download slide in pdf format.



  • Login Zoom App





  • Go to setting option right side above.




  • Mention video recording option and location after completion.


  • These are audio and video recording settings



  • Change Background as per requirements.





  • Select share screen options

  • Choose power point for slide presentation . In my case I have prepared slide on power point.





  • Make PPT into slide view mode . It is right below.







  • Start recording option : 







  • End recording (End Recording also using ALT +R u can also close so video recording do not interrupt.)
  • End Meeting session  







  • After ending video it will automatically convert MP4 into AVI format



Using Cutter Edit video all the best !!!

Saturday 3 April 2021

Pre oracle and grid Requestors setting on Suse12 sp4 for RAC 12.1.0.2.0

 Pre oracle and grid  Requestors setting on Suse12 sp4 for RAC 12.1.0.2.0

  • Add the following Kernel parameters in /etc/sysctl.conf file.

vi /etc/sysctl.conf

####

#

# /etc/sysctl.conf is meant for local sysctl settings

#

# sysctl reads settings from the following locations:

#   /boot/sysctl.conf-<kernelversion>

#   /lib/sysctl.d/*.conf

#   /usr/lib/sysctl.d/*.conf

#   /usr/local/lib/sysctl.d/*.conf

#   /etc/sysctl.d/*.conf

#   /run/sysctl.d/*.conf

#   /etc/sysctl.conf

#

# To disable or override a distribution provided file just place a

# file with the same name in /etc/sysctl.d/

#

# See sysctl.conf(5), sysctl.d(5) and sysctl(8) for more information

#

####


# Disable response to broadcasts.

# You don't want yourself becoming a Smurf amplifier.

net.ipv4.icmp_echo_ignore_broadcasts = 1

# enable route verification on all interfaces

net.ipv4.conf.all.rp_filter = 1

# enable ipV6 forwarding

#net.ipv6.conf.all.forwarding = 1

# increase the number of possible inotify(7) watches

fs.inotify.max_user_watches = 65536

# avoid deleting secondary IPs on deleting the primary IP

net.ipv4.conf.default.promote_secondaries = 1

net.ipv4.conf.all.promote_secondaries = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 52920661

kernel.shmmax = 270953783296

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576



# net.ipv6.conf.all.disable_ipv6 = 1

# Recommended value for kernel.panic_on_oops

kernel.panic_on_oops = 1


  • load them by running the following command:

sysctl -p

  • set the resource limits in /etc/security/limits.conf file.

vi /etc/security/limits.conf

# /etc/security/limits.conf

#

#Each line describes a limit for a user in the form:

#

#<domain>        <type>  <item>  <value>

#

#Where:

#<domain> can be:

#        - a user name

#        - a group name, with @group syntax

#        - the wildcard *, for default entry

#        - the wildcard %, can be also used with %group syntax,

#                 for maxlogin limit

#

#<type> can have the two values:

#        - "soft" for enforcing the soft limits

#        - "hard" for enforcing hard limits

#

#<item> can be one of the following:

#        - core - limits the core file size (KB)

#        - data - max data size (KB)

#        - fsize - maximum filesize (KB)

#        - memlock - max locked-in-memory address space (KB)

#        - nofile - max number of open files

#        - rss - max resident set size (KB)

#        - stack - max stack size (KB)

#        - cpu - max CPU time (MIN)

#        - nproc - max number of processes

#        - as - address space limit (KB)

#        - maxlogins - max number of logins for this user

#        - maxsyslogins - max number of logins on the system

#        - priority - the priority to run user process with

#        - locks - max number of file locks the user can hold

#        - sigpending - max number of pending signals

#        - msgqueue - max memory used by POSIX message queues (bytes)

#        - nice - max nice priority allowed to raise to values: [-20, 19]

#        - rtprio - max realtime priority

#

#<domain>      <type>  <item>         <value>

#


#*               soft    core            0

#*               hard    rss             10000

#@student        hard    nproc           20

#@faculty        soft    nproc           20

#@faculty        hard    nproc           50

#ftp             hard    nproc           0

#@student        -       maxlogins       4


# End of file


oracle soft nproc 24756

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

oracle soft memlock unlimited

oracle hard memlock unlimited

grid soft nproc 24756

grid hard nproc 16384

grid soft nofile 1024

grid hard nofile 65536

grid soft stack 10240

grid hard stack 32768


  • Add the following in /etc/pam.d/login file.

vi /etc/pam.d/login

#%PAM-1.0

auth      requisite  pam_nologin.so

auth      include    common-auth

account   include    common-account

password  include    common-password

session   required   pam_loginuid.so

session   include    common-session

#session  optional   pam_lastlog.so nowtmp showfailed

session   optional   pam_mail.so standard

oracle@sgdcplm02:~>



  • Create oinstalldba and oper groups.

groupadd -g 54321 oinstall

groupadd  -g 503 dba

groupadd  -g 504 oper

groupadd -g 54329 asmadmin

groupadd -g 54327 asmdba

groupadd -g 54324 backupdba

groupadd -g 54325 dgdba

groupadd -g 54326 kmdba

groupadd asmadmin

groupadd asmdba


  •  Create oracle user and add it to following groups


useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle

useradd -u 54323 -g oinstall -G asmadmin,asmdba,oper,asmdba  -s /bin/bash -m grid


  • Example - If we wants to add group on existing user

usermod -a -G asmdba oracle

 passwd oracle

 passwd grid

grid@sg:~> id

uid=54323(grid) gid=54321(oinstall) groups=54321(oinstall),503(dba),54327(asmdba),54329(asmadmin)

grid@sg:~> id oracle

uid=502(oracle) gid=54321(oinstall) groups=54321(oinstall),503(dba),504(oper),54324(backupdba),54325(dgdba),54326(kmdba),54327(asmdba),54330(beoper)

  • Modify .bash_profile for oracle user.  directory : /home/oracle

 vi .bash_profile

# .bash_profile


# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

umask 022

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_2

export ORACLE_HOME_LISTNER=$ORACLE_HOME/network/admin

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=smrrac1

#NLS_DATE_FORMAT=Mon DD YYYY HH24:MI:SS; export NLS_DATE_FORMAT

ORATAB=/etc/oratab;export ORATAB


oracle@sgdcplm02:~>


  • Modify .bash_profile for gird user. Directory : /home/grid

 vi .bash_profile

# .bash_profile

# OS User: grid


if

[ -f ~/.bashrc ]; then

. ~/.bashrc

fi

ORACLE_SID=+ASM1; export ORACLE_SID

ORACLE_BASE=/u01/app/grid; export ORACLE_BASE

# it must not be under the ORACLE_BASE

ORACLE_HOME=/u01/app/12.1.0/grid; export ORACLE_HOME

ORACLE_TERM=xterm; export ORACLE_TERM

TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

PATH=.:${PATH}:$ORACLE_HOME/bin

PATH=${PATH}:/usr/bin:/bin:/usr/local/bin

export PATH

export TEMP=/tmp

export TMPDIR=/tmp

umask 022


  • Some oracle packages installation 

zypper install libstdc++46-devel libstdc++33 libstdc++33-devel libelf-devel gcc-c++ libaio-devel sysstat unixODBC unixODBC-devel xdpyinfo


  • Directory 

mkdir -p /u01/app/oracle/product
chown -R oracle:oinstall /u01
chmod -R 775 /u01
mkdir -p /u01/app/grid
mkdir -p /u01/app/12.1.0/grid
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/12.1.0/grid
chmod -R 775 /u01