Oracle database dummy process (100 / 50 / 25 / 10 )

Hello Friends,

Here is a quick command to create multiple process in oracle database.


1) SQL Script - the script below will create session and hold for 10 minute

sqlplus -s / as sysdba <<EOF
select resource_name, current_utilization, max_utilization from v\$resource_limit where resource_name in ('processes','sessions');
exec DBMS_LOCK.Sleep( 600 );
EOF


2) Call SQL Script multiple time. (50 times)


nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh &

Could not launch application 'linc-cleanup-sockets.desktop':

Error in VNC log when starting

_XSERVTransmkdir: ERROR: euid != 0,directory /tmp/.X11-unix will not be created.

Xvnc TigerVNC 1.1.0 - built Mar 22 2017 04:35:07
Copyright (C) 1999-2011 TigerVNC Team and many others (see README.txt)
See http://www.tigervnc.org for information on TigerVNC.
Underlying X server release 11704000, The X.Org Foundation


Mon Jul 15 23:21:54 2019
 vncext:      VNC extension running!
 vncext:      Listening for VNC connections on all interface(s), port 5901
 vncext:      created VNC server for screen 0
gnome-session[3752]: WARNING: Unable to find provider 'nautilus' of required component 'filemanager'
GNOME_KEYRING_SOCKET=/tmp/keyring-PWAsGQ/socket
SSH_AUTH_SOCK=/tmp/keyring-PWAsGQ/socket.ssh
GNOME_KEYRING_PID=3766

** (gnome-settings-daemon:3765): WARNING **: Connection failed, reconnecting...
gnome-session[3752]: WARNING: Could not launch application 'linc-cleanup-sockets.desktop': Unable to start application: Failed to execute child process "/usr/bin/linc-cleanup-sockets" (No such file or directory)

(polkit-gnome-authentication-agent-1:3779): GLib-GObject-WARNING **: cannot register existing type `_PolkitError'

(polkit-gnome-authentication-agent-1:3779): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed
Failed to play sound: Not available

** (gnome-panel:3776): WARNING **: panel-applet-frame.c:1288: failed to load applet OAFIID:GnoteApplet:
(null)

** (gnome-panel:3776): WARNING **: panel-applet-frame.c:1288: failed to load applet OAFIID:GNOME_FastUserSwitchApplet:
(null)

** (gnome-settings-daemon:3765): WARNING **: Connection failed, reconnecting...

Solution:

If the packages need to be re-installed, use the below command:

# yum reinstall "@Desktop" "@Desktop Platform" "@General Purpose Desktop"

** Install xclock

yum install -y xorg-x11-apps

:

AutoConfig – txkGenADOPWrapper.pl

Issue:

The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/EBSSMK/fs1/FMW_Home/webtier/perl/bin/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/EBSSMK/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/EBSSMK/fs1/EBSapps/appl/au/12.0.0/perl -I /u01/EBSSMK/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u01/EBSSMK/fs1/inst/apps/EBSSMK_grcldm/admin/install
      txkGenADOPWrapper.pl    INSTE8_APPLY       1


Cause:

The SYS.DBMS_METADATA_UTIL object needs to be recompiled first before the APPS.AD_ZD_ADOP object can become valid.


Fix:

1. Check the status of the object APPS.AD_ZD_ADOP


$ sqlplus "/as sysdba"


SQL> select owner,object_name,object_type from dba_objects where status='INVALID' and object_name like'%ADOP%';

OWNER OBJECT_NAME OBJECT_TYPE
------ ----------- -----------
APPS AD_ZD_ADOP PACKAGE BODY


SQL> grant execute on DBMS_METADATA_UTIL to apps;

Grant succeeded.

SQL> alter package APPS.AD_ZD_ADOP compile body;

Package body altered.

SQL> show error
No errors.

Verify the Status of APPS.AD_ZD_ADOP package is valid.

Split linux file

0. Create a test file

[root@jmlab ~]# head -c 19MB /dev/urandom > jmtest1.txt
[root@jmlab ~]# pwd
/root

1.  check the size of current file

[root@jmlab ~]# ls jmtest1.txt
jmtest1.txt
[root@jmlab ~]# du -sh jmtest1.txt
19M     jmtest1.txt

2. check the file checksum

[root@jmlab ~]# md5sum jmtest1.txt
b06b3a95f8306b9a52390ede0e701e44  jmtest1.txt

3. split file into 5mb site

[root@jmlab ~]# split -b 5M  jmtest1.txt jmtest1_

4. check the files and upload



[root@jmlab ~]# ls -lrt jmtest1_*
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_aa
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_ab
-rw-r--r-- 1 root root 5242880 Apr 14 06:48 jmtest1_ac
-rw-r--r-- 1 root root 3271360 Apr 14 06:48 jmtest1_ad


 5. Marge file (Give this command to receiving person)

[root@jmlab ~]# cat jmtest1_* > jm1.txt


6. validate checksum

[root@jmlab ~]# md5sum jm1.txt
b06b3a95f8306b9a52390ede0e701e44  jm1.txt
[root@jmlab ~]#

Oracle Exadata - dcli

This is cheat sheet for Exadata command.

Exadata host inventory:

cat x6.txt 
excc01 
excc02 
excc03 
excc04 


#This command is get status of OEM agent:
dcli -l oracle -g ~/x6.txt '/u01/app/agent13/agent_inst/bin/emctl status agent'

#Loop in shell -  to get load in all server:
date; for i in {1..4} ; do ssh root@excc0${i} -i id_rsa.pub -C "hostname; uptime" ; done

Oracle Home Attach to inventory - attachHome

Issue: DBUA Unable to find ORACLE_HOME in Installer

Solution: ORACLE_HOME is missing and need to attech it with oracle inventory

[oracle@ebs121db1 11.2.0]$ export ORACLE_HOME=/u01/PROD/db/tech_st/11.2.0
[oracle@ebs121db1 11.2.0]$ cd $ORACLE_HOME/oui/bin
[oracle@ebs121db1 bin]$ pwd
/u01/PROD/db/tech_st/11.2.0/oui/bin
[oracle@ebs121db1 bin]$ ./runInstaller -invPtrLoc /u01/PROD/oraInventory/oraInst.loc -attachHome ORACLE_HOME=/u01/PROD/db/tech_st/11.2.0 ORACLE_HOME_NAME="oracle_11204"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 8191 MB    Passed
The inventory pointer is located at /u01/PROD/oraInventory/oraInst.loc
The inventory is located at /u01/PROD/oraInventory

'AttachHome' was successful.
[oracle@ebs121db1 bin]$
[oracle@ebs121db1 bin]$

Failed to execute adclone.pl

Failed to execute /u01/TEST/oracle/product/db/12.1.0.1/appsutil/clone/bin/adclone.pl

ERROR while running Apply...
Fri Jul 29 15:11:22 2017

 ERROR: Failed to execute /u01/TEST/oracle/product/db/12.1.0.1/appsutil/clone/bin/adclone.pl

 Please check logfile.

Solution
export PERL5LIB=$ORACLE_HOME/perl/lib/5.14.1:$ORACLE_HOME/perl/lib/site_perl/5.14.1:$ORACLE_HOME/appsutil/perl
and re-run Database techstack cloning

perl adcfgclone.pl dbTechStack /u01/TEST/oracle/product/db/12.1.0.1/appsutil/TEST_ebs121db1.xml