Sangram keshari's Oracle Blog

The Fusion Middleware Administration & Database Administration Blog

Disconnected: No supported authentication methods available (server sent publickey, gssapi-keyex gssapi-with-mic)

Posted by SangramKeshari on April 11, 2019

Error While trying to login to a newly created VM

DiscoonectCapture

 

 

Confirm if you have correct host entry in /etc/hosts

192.168.56.10 host-name

edit in /etc/ssh/sshd_config
PasswordAuthentication yes

Advertisements

Posted in Uncategorized | Leave a Comment »

Weblogic : Grep and Check STUCK Threads – 02

Posted by SangramKeshari on April 6, 2019

Finding the STUCK stack quickly

awk ‘/STUCK/ {print; for(i=0; i<=50; i++) { getline ; print }} ‘ /u01/Weblogic/Domain/servers/MangedServer1/logs/MangedServer1.out

— It is checking the STUCK keyword in the log file and and printing next 50 lines.

<Apr 5, 2019, 11:19:22,54 PM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’50’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “693” seconds working on the request “Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 693657 ms
[
POST /crmService/FoundationPartiesOrganizationService HTTP/1.1
User-Agent: Oracle HTTPClient Version 10h
SOAPAction:
<Output-Truncated>
Accept-Encoding: gzip, x-gzip, compress, x-compress
ECID-Context: 1.3330c29b-81c7-47ef-9dde-e769865900c3-055454b7;lXCEHTInl4jnmYigv0YLjITOZSPPi3VRXU8TmHROfPQRbUAHgVRT5MTPiKTI^PDCp8CDl5CEm4CWMVQSXJOR_UBSjHQBoITOZRPQiNQBJJHG5UOTdKTU9KQDl1FCs6CE0XNRmHROgLQBnVPOi4USXJRQdURPi6GRjNTI^PECm1DEp2ECk9CWUVQSXJOR_UBSjHQBoITOZRPQiNQB6SRRrJIS_HOTdVQRKPPR_KHCp5CDo9CDq1CCn3FD0_NRmHROgLQBnVPOi4USXJRQdURPi2LPoITU3VPTiKTCl0XOjITOZSPPi3VRXU8TmHROfPQRbUAHgVRTJJHGGHQSoPOTdVQR9KPCl0XPjITOZSPPi3VRXU8TmHROfPQRbU9IiJSTXURO_PGP3ITPXKTQjUOLdTPP4HDDp4DDk5DDo6FCn1CWQVQSXJOR_UBSjHQBoITOZRPQiNQB2LVSdUPPnJTHqLQRoPGP1HEDp9FCq3CCt9CWIVQSXJOR_UBSjHQBoITOZRPQiNQB6HPTgKTI^OECo1CDl4CEp0YOjITOZSPPi3VRXU8TmHROfPQRbUBGjTOSjJTQoLPIiJSTXURO_PGPt1CEm2DEq5ECr0ZOjITOZSPPi3VRXU8TmHROfPQRbUBGjTOSjJTQoLRK3HHHiKTQoPTI^MDCl3CEo3CWLVQSXJOR_UBSjHQBoITOZRPQiNQB9URSoHQRZLPI^PCEk3CDm2CDo3CWq6GRjNTI^PKCk0CCDIQQqCHQOHGQBJRNgOPD5PQMl3NIqFMJk1EHrIUG0ZJOoOTLkKPOoLRKlSODoITT_G
Content-Type: text/xml; charset=UTF-8
X-Advpf-Parse-Category: DEFAULT_ALLHTML
True-Client-IP: 160.34.31.52
Pragma: no-cache
X-Akamai-CONFIG-LOG-DETAIL: true
Akamai-Origin-Hop: 2
Via: 1.1 v1-akamaitech.net(ghost) (AkamaiGHost), 1.1 akamai.net(ghost) (AkamaiGHost)
Cache-Control: no-cache, max-age=0
<Output-Truncated>
<Output-Truncated>
<Output-Truncated>
<Output-Truncated>
IS_SSL: ssl
<Output-Truncated>
<Output-Truncated>

Content-Length: 5879
VIRTUAL_HOST_TYPE: external
Connection: Keep-Alive
X-Forwarded-For:
<Output-Truncated>
Proxy-Client-IP:
<Output-Truncated>
X-WebLogic-KeepAliveSecs: 30
X-WebLogic-Request-ClusterInfo: true
x-weblogic-cluster-hash: HL8eYU32I0QbF+G7Zc6gpZEbgXI

]”, which is more than the configured time (StuckThreadMaxTime) of “600” seconds in “server-failure-trigger”. Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:153)
java.net.SocketInputStream.read(SocketInputStream.java:122)
oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:731)
oracle.net.ns.Packet.receive(Packet.java:302)
oracle.net.ns.DataPacket.receive(DataPacket.java:108)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:325)
oracle.net.ns.NetInputStream.read(NetInputStream.java:269)
oracle.net.ns.NetInputStream.read(NetInputStream.java:191)
oracle.net.ns.NetInputStream.read(NetInputStream.java:108)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:369)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:236)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1282)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1439)

Posted in Uncategorized | Leave a Comment »

Weblogic : Grep and Check STUCK Threads – 01

Posted by SangramKeshari on April 5, 2019

Grep and Check STUCK Threads as of Today’s DATE.

 

grep STUCK /u01/Weblogic/Domain/servers/*/logs/*.out| grep “`date +”<%b %d, %Y,”`”

— This doesn’t work as date format in logs doesn’t have a prefix 0(zero)  in it.

<Apr 5, 2019, 8:30:28,28 AM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’51’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “693” seconds working on the request “Workmanager: WM-FAUI, Version: 0, Scheduled=true, Started=true, Started time: 693721 ms
<Apr 5, 2019, 8:30:28,31 AM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’57’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “693” seconds working on the request “Workmanager: WM-FAUI, Version: 0, Scheduled=true, Started=true, Started time: 693818 ms
<Apr 5, 2019, 9:38:28,348 AM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’53’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “651” seconds working on the request “Workmanager: WM-FAUI, Version: 0, Scheduled=true, Started=true, Started time: 651248 ms

 

[oracle@tsfar01122c09 eklb-dev1:ADMIN-APPS ~]$ echo “`date +”<%b %d, %Y,”`”
<Apr 05, 2019,

You need “<Apr 5, 2019, ”

$ grep STUCK /u01/Weblogic/Domain/servers/MangedServer1/logs/MangedServer1.out|grep “`date +”<%b%e, %Y,”`”

<Apr 5, 2019, 8:29:28,16 AM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’51’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “633” seconds working on the request “Workmanager: WM-FAUI, Version: 0, Scheduled=true, Started=true, Started time: 633707 ms
<Apr 5, 2019, 8:29:28,19 AM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: ’57’ for queue: ‘weblogic.kernel.Default (self-tuning)’ has been busy for “633” seconds working on the request “Workmanager: WM-FAUI, Version: 0, Scheduled=true, Started=true, Started time: 633804 ms

$ echo “`date +”<%b%e, %Y,”`”
<Apr 5, 2019,

$ grep STUCK /podscratch/logs/wlslogs/FADomain/servers/UIServer_1/logs/UIServer_1.out|grep “`date +”<%b%e, %Y,”`”
–This Works 🙂

Posted in Uncategorized | Leave a Comment »

How to Install and Configure GoldenGate 11.2 [CLASSIC CAPTURE]

Posted by SangramKeshari on May 6, 2014

Download Godengate from https://edelivery.oracle.com

ggdownload

[oracle@oradbasm11gbox01 ~]$mkdir -p /u01/app/oracle/goldengate/112100

[oracle@oradbasm11gbox01 ofm_gg_GoldenGate]$ cp fbo_ggs_Linux_x64_112100_ora11g_64bit.zip /u01/app/oracle/goldengate/112100
[oracle@oradbasm11gbox01 ofm_gg_GoldenGate]$ cd /u01/app/oracle/goldengate/112100
[oracle@oradbasm11gbox01 112100]$ ls -ltr
total 84472
-rwxr-x— 1 oracle oinstall 86406274 Feb 6 01:33 fbo_ggs_Linux_x64_112100_ora11g_64bit.zip

Read the rest of this entry »

Posted in GoldenGate, Uncategorized | Tagged: , , , , , , , | 1 Comment »

How to do Networking Configuration in Oracle Linux 6.5 on VirtualBox

Posted by SangramKeshari on May 6, 2014

This article is to understand the Oracle VirtualBox and Linux Networking basic configuration.
To configure Oracle DBA RAC LAB we need different type of network added to the virtual machine.

NAT — To Access Internet
Host Only Network — To Access the host
Internal Network — To Use in Interconnect
or/and
Bridged Network — To Use in Interconnect

Network Address Translation (NAT)
This is the process where a network device, usually a firewall, assigns a public address to a computer (or group of computers) inside a private network.
If all you want is to browse the Web, download files and view e-mail inside the guest, then this default mode should be sufficient for you.

Bridged networking
This is for more advanced networking needs such as network simulations and running servers in a guest. When enabled, VirtualBox connects to one of your installed network cards and exchanges network packets directly, circumventing your host operating system’s network stack.

Internal networking
This can be used to create a different kind of software-based network which is visible to selected virtual machines, but not to applications running on the host or to the outside world.

Host-only networking
This can be used to create a network containing the host and a set of virtual machines, without the need for the host’s physical network interface. Instead, a virtual network interface (similar to a loopback interface) is created on the host, providing connectivity among virtual machines and the host.

Once Your Virtual Machine is created. If not already created follow the sequence in https://sangramkeshari.wordpress.com/vm/
Go to Virtual Machine –> SETTINGS –> NETWORK

1> Choose NAT in Adapter 1. Click Next Tab Adapter 2.
l65netw11

2> Choose Host-Only Adapter in Adapter 2. Click Next Tab Adapter 3.
l65netw12

3> Choose Internal Network in Adapter 3. Click Next Tab Adapter 4.
l65netw13
4> Choose Bridged Adapter in Adapter 4.
l65netw14
5>
l65netw0
6> Go To SYSTEM –> PREFERENCE -> NETWORK CONNECTIONS
l65netw2-1
7> Choose eth0 and Click on EDIT
l65netw3-1
8> Choose eth1 and Click on EDIT. Go to IPV4 Setting Choose DHCP and Apply
l65netw5-1
9> Choose eth2 and Click on EDIT. Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw6-1
10> Choose eth2 and Click on EDIT. Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw7-1
11> Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw8-1
12>

Add Entry in – /etc/hosts file 192.168.56.65
Restart Network – service network restart

l65netw9-1

13> Check IP configurations details – ifconfig
l65netw10-1

Posted in Linux, OS, VM | Tagged: , , | 1 Comment »

VirtualBox Guest Addition and Configure Shared Folder with Guest OS

Posted by SangramKeshari on March 5, 2014

1. VirtualBox Guest Addition

Devices -> Click – Insert Guest Addition
vm-guest-add-438-0

Click OK
vm-guest-add-438-1

Click Run
vm-guest-add-438-2

vm-guest-add-438-4

System -> Shutdown or init 0
vm-guest-add-438-5

2. Configure Shared Folder with Guest OS

Edit Settings -> Select Shared Folders -> Click the + to add
vm-guest-add-438-6

vm-guest-add-438-7

To access shared folder by oracle user
/usr/sbin/usermod -u 54321 -g oinstall -G dba,vboxsf oracle

vm-guest-add-438-11

Posted in Linux, VM | Tagged: , , , , | Leave a Comment »

Oracle Linux 6.5 64 bit Installation on VirtualBox

Posted by SangramKeshari on March 5, 2014


Follow the sequence :

1) How to Install Oracle VM Virtual Box 4.3.8 http://wp.me/pLTxm-kp
2) How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack http://wp.me/pLTxm-kJ
3) How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit http://wp.me/pLTxm-kU
4) Making the Virtual Machine ready to Install Oracle Linux 6.5 64 bit http://wp.me/pLTxm-ls

5) Oracle Linux 6.5 64 bit Installation

Steps through screenshots
1
ol65-0
2
ol65-1
3
ol65-2
4
ol65-3
5
ol65-4
6
ol65-5
7
ol65-6
8
ol65-7
9
ol65-8
10
ol65-9
11
12
ol65-11
13 Creating a custom layout
ol65-12
14
ol65-13
15 Going to create a new partition
ol65-14
16 Steps 14, 15, 16 going to fail because we don’t have free space to create a new partition
ol65-15
17 Editing existing partitions to release free space
ol65-16
18 Editing the root partition logical volume to 20 GB. You can set it for as per your requirement.
ol65-17
19 Editing swap space logical volume to 6 GB. You can set it for as per your requirement.
ol65-18
20 Editing /home logical volume to 10 GB. This keeps the user data. You can set it for as per your requirement.
ol65-19

23 Double Click on free space
ol65-22
24 Creating /u01 of 30 GB
ol65-23
25 Creating /u02 of 20 GB
ol65-24
26 Creating /u03 of 10 GB
ol65-25
27 Creating /tmp of 2 GB
ol65-26
28
ol65-27
29
ol65-28
30
ol65-29
31
ol65-30
32
ol65-31
33
ol65-32
34
Base System -> Base -> Choose Everything from Optional Packages
Base System -> Compatibility Libraries
Base System -> Console Internet Tools
Base System -> Debugging Tools ->
Base System -> Directory Client
Base System -> Hardware Monitoring Utilities
Base System -> Java Platform
Base System -> Large Systems Performance
Base System -> Network File System Client
Base System -> Networking Tools -> Choose Everything from Optional Packages
Base System -> Performance Tools
Base System -> Perl Support

ol65-33
35 Base System -> Base -> Choose Everything
ol65-33-a
36 Base System -> Compatibility Libraries -> Choose Everything
ol65-34
37 Servers -> Server Administration tools -> Choose Everything
ol65-35
38 System Management -> System Management -> Choose Everything
ol65-35-a
39 Desktop -> Select Everything
ol65-36
40 Developement -> Additional Developement -> Choose Everything
ol65-37

UEK3 Kernel repo -> UEK3 Kernel repo -> Choose Everything

41
ol65-38
42
ol65-39
43
ol65-afterReboot-0
44
ol65-afterReboot-1
45
ol65-afterReboot-2
46
ol65-afterReboot-3
47
ol65-afterReboot-4
48
ol65-afterReboot-5
49
ol65-afterReboot-6
50
ol65-afterReboot-7
51
ol65-afterReboot-8
52
ol65-afterReboot-9
53
ol65-afterReboot-10
54
ol65-afterReboot-11

Posted in Linux, VM | Tagged: , , , | Leave a Comment »

Making the Virtual Machine ready to Install Oracle Linux 6.5 64 bit

Posted by SangramKeshari on March 4, 2014



1) How to Install Oracle VM Virtual Box 4.3.8 http://wp.me/pLTxm-kp
2) How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack http://wp.me/pLTxm-kJ
3) How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit http://wp.me/pLTxm-kU
4) Download the Oracle Linux 6.5 64 bit ISO from https://edelivery.oracle.com/linux

edel-0

edel-1

edel-2

edel-3

edel-4

edel-5

edel-6

5)

Click on the CD Icon in the attributes section and Choose the ISO Image.

Lin65-Install-0

Lin65-Install-1

Lin65-Install-2

Posted in Linux, VM | Tagged: , | Leave a Comment »

How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit

Posted by SangramKeshari on March 3, 2014

1) Virtual Machine Location Preference
2) Virtual Machine Creation
3) Virtual Machine CPU Allocation
4) Virtual Machine Network Configuration

1) Virtual Machine Location Preference

vm-pref-0

vm-pref-1

2) Virtual Machine Creation

vm-CreateNewVM-0

vm-CreateNewVM-1

vm-CreateNewVM-2

vm-CreateNewVM-3

vm-CreateNewVM-4

vm-CreateNewVM-5

vm-CreateNewVM-6

vm-CreateNewVM-7

vm-CreateNewVM-8

vm-CreateNewVM-9

3) Virtual Machine CPU Allocation

vm-CreateNewVM-11

vm-CreateNewVM-12

4) Virtual Machine Network Configuration

vmnet-0

vmnet-1

vmnet-2

vmnet-2

vmnet-3

vm-CreateNewVM-13

Posted in VM | Tagged: , , , | Leave a Comment »

How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack

Posted by SangramKeshari on March 3, 2014

Download Oracle VM VirtualBox Extension Pack Software from https://www.virtualbox.org/wiki/Downloads
click on “All supported platforms” to download Oracle_VM_VirtualBox_Extension_Pack-4.3.8-92456.vbox-extpack

vm438-ext-pck-0

Scroll down and click I Agree
vm438-ext-pck-1

vm438-ext-pck-2

vm438-ext-pck-3

vm438-ext-pck-4

Posted in VM | Tagged: , , | 2 Comments »