Sunday, 7 July 2019

TNS-12546: TNS:permission denied TNS-00516: Permission denied Incoming connection from ip address rejected


Error:

08-JUL-2019 10:09:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=badb1-t7-2)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * status * 0
Incoming connection from 10.212.1.134 rejected
08-JUL-2019 10:10:12 * 12546
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
 
  Incoming connection from xx.xx.xx.xx rejected>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Incoming connection from xx.xx.xx.xx rejected
 
Reason:

The issue is due to improper setting of tcp.invited_nodes in sqlnet.ora

The scan ip is missing tcp.invited_nodes.

tcp.invited_nodes = (,,, ............)<<<<<<<< 
Solution: 

  -bash-4.1$ cd /d01/app/12.1.0/grid/network/admin/
-bash-4.1$ cat sqlnet.ora
TCP.VALIDNODE_CHECKING = YES
TCP.INVITED_NODES = (10.11.1.134,10.11.1.126,10.11.208.167,10.11.208.115,10.11.208.70)
#TCP.EXCLUDED_NODES = (10.11.208.115,10.11.208.78)
-bash-4.1$


-bash-4.1$ vim sqlnet.ora

TCP.VALIDNODE_CHECKING = YES
#TCP.INVITED_NODES = (10.11.1.134,10.11.1.126,10.11.208.167,10.11.208.115,10.11.208.70)
#TCP.EXCLUDED_NODES = (10.11.208.115,10.11.208.78)
-bash-4.1$ 

Tuesday, 2 July 2019

step by step to apply patch in Oracle Weblogic Server

Step 1: set WL_HOME variable

/u01/oracle/middleware/wlserver_10.3/server/bin/setWLSEnv.sh

$ . $WL_HOME/server/bin/setWLSEnv.sh
  $ java weblogic.version

  [oracle@SAID-DR bin]$ . ./setDomainEnv.sh

CLASSPATH=/u01/oracle/middleware/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u01/oracle/middleware/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/usr/java/jdk1.6.0_34/lib/tools.jar:/u01/oracle/middleware/wlserver_10.3/server/lib/weblogic_sp.jar:/u01/oracle/middleware/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/middleware/modules/features/weblogic.server.modules_10.3.6.0.jar:/u01/oracle/middleware/wlserver_10.3/server/lib/webservices.jar:/u01/oracle/middleware/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/u01/oracle/middleware/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:

PATH=/u01/oracle/middleware/wlserver_10.3/server/bin:/u01/oracle/middleware/modules/org.apache.ant_1.7.1/bin:/usr/java/jdk1.6.0_34/jre/bin:/usr/java/jdk1.6.0_34/bin:/usr/lib64/qt-3.3/bin:/usr/NX/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

Your environment has been set.

Step 2: Check Weblogic Version

----Check Weblogic Version---

[oracle@SAID-DR ClassicDomain]$cd /u01/oracle/middleware/user_projects/domains/ClassicDomain/
[oracle@SAID-DR ClassicDomain]$ java weblogic.version

WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050

Use 'weblogic.version -verbose' to get subsystem information

Use 'weblogic.utils.Versions' to get version information for all modules

Step 3: Download required patch to apply

----Download Weblogic Patch ----

[oracle@SAID-DR ClassicDomain]$

[oracle@SAID-DR ClassicDomain]$ pwd
/u01/oracle/middleware/user_projects/domains/ClassicDomain
[oracle@SAID-DR ClassicDomain]$
root@SAID-DR ~]# cd /u01/patch/
[root@SAID-DR patch]# chown oracle:oinstall p28710912_1036_Generic.zip
[root@SAID-DR patch]# chmod 755 p28710912_1036_Generic.zip
[root@SAID-DR patch]#

Step 4: Apply patch

--------Apply Patch--------------
[oracle@SAID-DR ~]$ cd /u01/oracle/middleware/utils/bsu/
[oracle@SAID-DR bsu]$ ls -lrt
total 40
-rw-r--r-- 1 oracle oinstall 25214 Apr 24  2018 smartupdate.ico
-rw-r--r-- 1 oracle oinstall   516 Apr 24  2018 patch-client.jar
-rw-r--r-- 1 oracle oinstall   520 Apr 24  2018 bsu.jar
-rwxr-x--- 1 oracle oinstall   135 Apr 24  2018 bsu.sh
[oracle@SAID-DR bsu]$./bsu.sh

This is the syntax for the command to view the downloaded patches as below:

[oracle@SAID-DR bsu]$ ./bsu.sh -prod_dir=/u01/oracle/middleware/wlserver_10.3 -patch_download_dir=/u01/patch -status=downloaded -view -verbose
ProductName:       WebLogic Server
ProductVersion:    10.3 MP6
Components:        WebLogic Server/Core Application Server,WebLogic Server/Admi
                   nistration Console,WebLogic Server/Configuration Wizard and
                   Upgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Serve
                   r,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBC
                    Drivers,WebLogic Server/Third Party JDBC Drivers,WebLogic S
                   erver/WebLogic Server Clients,WebLogic Server/WebLogic Web S
                   erver Plugins,WebLogic Server/UDDI and Xquery Support,WebLog
                   ic Server/Evaluation Database,WebLogic Server/Workshop Code
                   Completion Support
BEAHome:           /u01/oracle/middleware
ProductHome:       /u01/oracle/middleware/wlserver_10.3
PatchSystemDir:    /u01/oracle/middleware/utils/bsu
PatchDir:          /u01/oracle/middleware/patch_wls1036
Profile:           Default
DownloadDir:       /u01/patch
JavaVersion:       1.6.0_29
JavaVendor:        Sun

[oracle@SAID-DR bsu]$

Install the patch:

[oracle@SAID-DR cache_dir]$ cp /u01/patch/p28710912_1036_Generic.zip /u01/oracle/middleware/utils/bsu/cache_dir/
[oracle@SAID-DR cache_dir]$ ls -lrt
total 98428
-rwxr-xr-x 1 oracle oinstall 100789655 Feb 14 03:39 p28710912_1036_Generic.zip
[oracle@SAID-DR cache_dir]$ unzip p28710912_1036_Generic.zip
Archive:  p28710912_1036_Generic.zip
  inflating: patch-catalog_26407.xml 
  inflating: 7HKN.jar               
  inflating: README.txt             
[oracle@SAID-DR cache_dir]$ pwd
/u01/oracle/middleware/utils/bsu/cache_dir
[oracle@SAID-DR cache_dir]$

./bsu.sh -install -patch_download_dir=/u01/oracle/middleware/utils/bsu/cache_dir -patchlist=7HKN -prod_dir=/u01/oracle/middleware/wlserver_10.3


3.25 PM 
[root@SAID-DR bsu]# cat bsu.sh
#!/bin/sh

JAVA_HOME="/usr/java/jdk1.6.0_34"

MEM_ARGS="-Xms1024m -Xmx4096m"            -----Modify the Memory parameter from 256 to 1024 and 512 to 4096

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*
[root@SAID-DR bsu]#

[oracle@SAID-DR bsu]$ ./bsu.sh -install -patch_download_dir=/u01/oracle/middleware/utils/bsu/cache_dir -patchlist=7HKN -prod_dir=/u01/oracle/middleware/wlserver_10.3
Checking for conflicts.....
.....
No conflict(s) detected

Installing Patch ID: 7HKN..
Result: Success

[oracle@SAID-DR bsu]$
[oracle@SAID-DR bsu]$

----check if the patch is installed-------
./bsu.sh -prod_dir=/u01/oracle/middleware/wlserver_10.3 -status=applied -verbose -view

[oracle@SAID-DR bsu]$ ./bsu.sh -prod_dir=/u01/oracle/middleware/wlserver_10.3 -status=applied -verbose -view
ProductName:       WebLogic Server
ProductVersion:    10.3 MP6
Components:        WebLogic Server/Core Application Server,WebLogic Server/Admi
                   nistration Console,WebLogic Server/Configuration Wizard and
                   Upgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Serve
                   r,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBC
                    Drivers,WebLogic Server/Third Party JDBC Drivers,WebLogic S
                   erver/WebLogic Server Clients,WebLogic Server/WebLogic Web S
                   erver Plugins,WebLogic Server/UDDI and Xquery Support,WebLog
                   ic Server/Evaluation Database,WebLogic Server/Workshop Code
                   Completion Support
BEAHome:           /u01/oracle/middleware
ProductHome:       /u01/oracle/middleware/wlserver_10.3
PatchSystemDir:    /u01/oracle/middleware/utils/bsu
PatchDir:          /u01/oracle/middleware/patch_wls1036
Profile:           Default
DownloadDir:       /u01/oracle/middleware/utils/bsu/cache_dir
JavaVersion:       1.6.0_29
JavaVendor:        Sun


Patch ID:          7HKN
PatchContainer:    7HKN.jar
Checksum:          -1767993263
Severity:          optional
Category:          General
CR/BUG:            28710912
Restart:           true
Description:       WLS PATCH SET UPDATE 10.3.6.0.190115
WLS PATCH SET UPDATE 10
                   .3.6.0.190115


[oracle@SAID-DR bsu]$




Monday, 18 March 2019

umount2: Device or resource busy in Linux

Error: We got the following error during umount one directory

root@said ~]# umount -f /u05/STPADDAPTER/input
umount2: Device or resource busy
umount: /u05/STPADDAPTER/input: device is busy.
        (In some cases useful info about processes that use
         the device is found by lsof(8) or fuser(1))
umount2: Device or resource busy

Solution


root@said ~]# umount -f /u05/STPADDAPTER/input
umount2: Device or resource busy
umount: /u05/STPADDAPTER/input: device is busy.
        (In some cases useful info about processes that use
         the device is found by lsof(8) or fuser(1))
umount2: Device or resource busy
[root@said ~]# umount -l /u05/STPADDAPTER/input 
[root@said ~]# mount //10.11.1.67/STPADDAPTER/input  /u05/STPADDAPTER/input -o username=administrator,password=bach@123,file_mode=0777,dir_mode=0777,sec=ntlm,uid=oracle,gid=oinstall
^C
You have mail in /var/spool/mail/root
[root@said ~]# umount -l /u05/STPADDAPTER/input
umount: /u05/STPADDAPTER/input: not mounted
[root@said ~]# mount -f //10.11.1.67/STPADDAPTER/input  /u05/STPADDAPTER/input -o username=administrator,password=,file_mode=0777,dir_mode=0777,sec=ntlm,uid=oracle,gid=oinstall

[root@said ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda7             481G  1.3G  456G   1% /
tmpfs                 252G   75G  178G  30% /dev/shm
/dev/sda2             197G   60M  187G   1% /tmp
/dev/sda3             197G  7.4G  180G   4% /usr
/dev/sda6              99G  2.1G   92G   3% /var
/dev/mapper/mpathhp1  493G  135G  333G  29% /u01
/dev/mapper/mpathfp1 1008G  886G   72G  93% /u02
/dev/mapper/mpathgp1  493G  329G  139G  71% /u03
/dev/mapper/mpathip1  591G   91G  470G  17% /u04
/dev/mapper/mpathjp1 1008G  386G  572G  41% /u05
/dev/mapper/mpathkp1  493G  252G  216G  54% /u06
/dev/mapper/mpathlp1  493G   15G  453G   4% /u07
/dev/mapper/mpathnp1  493G   48G  420G  11% /u09
/dev/mapper/mpathop1  2.0T  1.5T  450G  77% /BARMAN
/dev/sda1             477M  184M  265M  41% /boot
/dev/mapper/mpathpp1 1008G  187G  771G  20% /archivelog
//10.11.1.65/MICR/DATA
                      1.8T  306G  1.4T  19% /u05/MICR/DATA
//10.11.1.65/MICR/IMAGE
                      1.8T  306G  1.4T  19% /u05/MICR/IMAGE
//10.11.1.65/XML/ICE  1.8T  306G  1.4T  19% /u05/XML/ICE
//10.11.1.65/XML/IRE  1.8T  306G  1.4T  19% /u05/XML/IRE
//10.11.1.65/EFT_XML/ICE
                      1.8T  306G  1.4T  19% /u05/EFT_XML/ICE
//10.11.1.65/EFT_XML/IRE
                      1.8T  306G  1.4T  19% /u05/EFT_XML/IRE
//10.11.1.67/STPADDAPTER/input
                     1008G  386G  572G  41% /u05/STPADDAPTER/input
//10.11.1.67/STPADDAPTER/output
                     1008G  386G  572G  41% /u05/STPADDAPTER/output
[root@said ~]#

mount //10.11.1.67/STPADDAPTER/output  /u05/STPADDAPTER/output -o username=administrator,password=,file_mode=0777,dir_mode=0777,sec=ntlmssp,uid=oracle,gid=oinstall