xterm: bad command line option "-eperl"

Issue: xterm: bad command line option

fix: 1) the adautostg.pl had a missing space in the xterm command - $cmd = "xterm "." -e". "perl ".$ENV{'TEMP'}.$dirsep."staging".$dirsep."adautostg.pl "; Changed this to: $cmd = "xterm "." -e". " perl ".$ENV{'TEMP'}.$dirsep."staging".$dirsep."adautostg.pl ";

Setup AWS account in Mac

1. Download the package manager from https://brew.sh site and install it in your mac.

once the installation is done run below command to verify the installation

command:
brew doctor

Output:
Jig12:~ jig$ brew doctor
Your system is ready to brew.
Jig12:~ jig$ 

2. Install atom text editor

command:
brew cask install atom

output:

Jig12:~ jig$ brew cask install atom
==> Tapping homebrew/cask
Cloning into '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-cask'...
remote: Enumerating objects: 4155, done.
remote: Counting objects: 100% (4155/4155), done.
remote: Compressing objects: 100% (4142/4142), done.
remote: Total 4155 (delta 26), reused 524 (delta 10), pack-reused 0
Receiving objects: 100% (4155/4155), 1.32 MiB | 1.17 MiB/s, done.
Resolving deltas: 100% (26/26), done.
Checking out files: 100% (4140/4140), done.
Tapped 1 command and 4057 casks (4,165 files, 4.2MB).
==> Satisfying dependencies
==> Downloading https://github.com/atom/atom/releases/download/v1.32.2/atom-mac.zip
==> Downloading from https://github-production-release-asset-2e65be.s3.amazonaws.com/3228505
######################################################################## 100.0%
==> Verifying SHA-256 checksum for Cask 'atom'.
==> Installing Cask atom
==> Moving App 'Atom.app' to '/Applications/Atom.app'.
==> Linking Binary 'apm' to '/usr/local/bin/apm'.
==> Linking Binary 'atom.sh' to '/usr/local/bin/atom'.
🍺  atom was successfully installed!
Jig12:~ jig$



3. Install Python3

command:
brew install python3

output:


Jig12:~ jig$ brew install python3
==> Installing dependencies for python: gdbm, openssl, readline, sqlite and xz
==> Installing python dependency: gdbm
==> Downloading https://homebrew.bintray.com/bottles/gdbm-1.18.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring gdbm-1.18.1.mojave.bottle.tar.gz
🍺  /usr/local/Cellar/gdbm/1.18.1: 20 files, 591.2KB
==> Installing python dependency: openssl
==> Downloading https://homebrew.bintray.com/bottles/openssl-1.0.2p.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring openssl-1.0.2p.mojave.bottle.tar.gz
==> Caveats
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
  /usr/local/etc/openssl/certs

and run
  /usr/local/opt/openssl/bin/c_rehash

openssl is keg-only, which means it was not symlinked into /usr/local,
because Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries.

If you need to have openssl first in your PATH run:
  echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.bash_profile

For compilers to find openssl you may need to set:
  export LDFLAGS="-L/usr/local/opt/openssl/lib"
  export CPPFLAGS="-I/usr/local/opt/openssl/include"

==> Summary
🍺  /usr/local/Cellar/openssl/1.0.2p: 1,793 files, 12MB
==> Installing python dependency: readline
==> Downloading https://homebrew.bintray.com/bottles/readline-7.0.5.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring readline-7.0.5.mojave.bottle.tar.gz
==> Caveats
readline is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD libedit library, which shadows libreadline.
In order to prevent conflicts when programs look for libreadline we are
defaulting this GNU Readline installation to keg-only.

For compilers to find readline you may need to set:
  export LDFLAGS="-L/usr/local/opt/readline/lib"
  export CPPFLAGS="-I/usr/local/opt/readline/include"

==> Summary
🍺  /usr/local/Cellar/readline/7.0.5: 46 files, 1.5MB
==> Installing python dependency: sqlite
==> Downloading https://homebrew.bintray.com/bottles/sqlite-3.25.3.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring sqlite-3.25.3.mojave.bottle.tar.gz
==> Caveats
sqlite is keg-only, which means it was not symlinked into /usr/local,
because macOS provides an older sqlite3.

If you need to have sqlite first in your PATH run:
  echo 'export PATH="/usr/local/opt/sqlite/bin:$PATH"' >> ~/.bash_profile

For compilers to find sqlite you may need to set:
  export LDFLAGS="-L/usr/local/opt/sqlite/lib"
  export CPPFLAGS="-I/usr/local/opt/sqlite/include"

==> Summary
🍺  /usr/local/Cellar/sqlite/3.25.3: 11 files, 3.7MB
==> Installing python dependency: xz
==> Downloading https://homebrew.bintray.com/bottles/xz-5.2.4.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring xz-5.2.4.mojave.bottle.tar.gz
🍺  /usr/local/Cellar/xz/5.2.4: 92 files, 1MB
==> Installing python
==> Downloading https://homebrew.bintray.com/bottles/python-3.7.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring python-3.7.1.mojave.bottle.tar.gz
==> /usr/local/Cellar/python/3.7.1/bin/python3 -s setup.py --no-user-cfg install --force --v
==> /usr/local/Cellar/python/3.7.1/bin/python3 -s setup.py --no-user-cfg install --force --v
==> /usr/local/Cellar/python/3.7.1/bin/python3 -s setup.py --no-user-cfg install --force --v
==> Caveats
Python has been installed as
  /usr/local/bin/python3

Unversioned symlinks `python`, `python-config`, `pip` etc. pointing to
`python3`, `python3-config`, `pip3` etc., respectively, have been installed into
  /usr/local/opt/python/libexec/bin

If you need Homebrew's Python 2.7 run
  brew install python@2

You can install Python packages with
  pip3 install <package>
They will install into the site-package directory
  /usr/local/lib/python3.7/site-packages

See: https://docs.brew.sh/Homebrew-and-Python
==> Summary
🍺  /usr/local/Cellar/python/3.7.1: 3,820 files, 59.2MB
==> Caveats
==> openssl
A CA file has been bootstrapped using certificates from the SystemRoots
keychain. To add additional certificates (e.g. the certificates added in
the System keychain), place .pem files in
  /usr/local/etc/openssl/certs

and run
  /usr/local/opt/openssl/bin/c_rehash

openssl is keg-only, which means it was not symlinked into /usr/local,
because Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries.

If you need to have openssl first in your PATH run:
  echo 'export PATH="/usr/local/opt/openssl/bin:$PATH"' >> ~/.bash_profile

For compilers to find openssl you may need to set:
  export LDFLAGS="-L/usr/local/opt/openssl/lib"
  export CPPFLAGS="-I/usr/local/opt/openssl/include"

==> readline
readline is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD libedit library, which shadows libreadline.
In order to prevent conflicts when programs look for libreadline we are
defaulting this GNU Readline installation to keg-only.

For compilers to find readline you may need to set:
  export LDFLAGS="-L/usr/local/opt/readline/lib"
  export CPPFLAGS="-I/usr/local/opt/readline/include"

==> sqlite
sqlite is keg-only, which means it was not symlinked into /usr/local,
because macOS provides an older sqlite3.

If you need to have sqlite first in your PATH run:
  echo 'export PATH="/usr/local/opt/sqlite/bin:$PATH"' >> ~/.bash_profile

For compilers to find sqlite you may need to set:
  export LDFLAGS="-L/usr/local/opt/sqlite/lib"
  export CPPFLAGS="-I/usr/local/opt/sqlite/include"

==> python
Python has been installed as
  /usr/local/bin/python3

Unversioned symlinks `python`, `python-config`, `pip` etc. pointing to
`python3`, `python3-config`, `pip3` etc., respectively, have been installed into
  /usr/local/opt/python/libexec/bin

If you need Homebrew's Python 2.7 run
  brew install python@2

You can install Python packages with
  pip3 install <package>
They will install into the site-package directory
  /usr/local/lib/python3.7/site-packages

See: https://docs.brew.sh/Homebrew-and-Python


4. Install pipenv

command :
pip3 install pipenv

output:
Jig12:~ jig$ pip3 install pipenv
Collecting pipenv
  Downloading https://files.pythonhosted.org/packages/7d/ed/526ea0c23f95cc431e67768718de91a69083c060118c5fcc79ece8f23141/pipenv-2018.11.14-py3-none-any.whl (5.2MB)
    100% |████████████████████████████████| 5.2MB 582kB/s
Collecting virtualenv (from pipenv)
  Downloading https://files.pythonhosted.org/packages/7c/17/9b7b6cddfd255388b58c61e25b091047f6814183e1d63741c8df8dcd65a2/virtualenv-16.1.0-py2.py3-none-any.whl (1.9MB)
    100% |████████████████████████████████| 1.9MB 289kB/s
Collecting certifi (from pipenv)
  Downloading https://files.pythonhosted.org/packages/56/9d/1d02dd80bc4cd955f98980f28c5ee2200e1209292d5f9e9cc8d030d18655/certifi-2018.10.15-py2.py3-none-any.whl (146kB)
    100% |████████████████████████████████| 153kB 192kB/s
Requirement already satisfied: pip>=9.0.1 in /usr/local/lib/python3.7/site-packages (from pipenv) (18.1)
Collecting virtualenv-clone>=0.2.5 (from pipenv)
  Downloading https://files.pythonhosted.org/packages/16/9d/6419a4f0fe4350db7fdc01e9d22e949779b6f2d2650e4884aa8aededc5ae/virtualenv_clone-0.4.0-py2.py3-none-any.whl
Requirement already satisfied: setuptools>=36.2.1 in /usr/local/lib/python3.7/site-packages (from pipenv) (40.5.0)
Installing collected packages: virtualenv, certifi, virtualenv-clone, pipenv
Successfully installed certifi-2018.10.15 pipenv-2018.11.14 virtualenv-16.1.0 virtualenv-clone-0.4.0
Jig12:~ jig$


5. Install Node

command:
brew install node


output:

Jig12:~ jig$ brew install node
==> Installing dependencies for node: icu4c
==> Installing node dependency: icu4c
==> Downloading https://homebrew.bintray.com/bottles/icu4c-62.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring icu4c-62.1.mojave.bottle.tar.gz
==> Caveats
icu4c is keg-only, which means it was not symlinked into /usr/local,
because macOS provides libicucore.dylib (but nothing else).

If you need to have icu4c first in your PATH run:
  echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile
  echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile

For compilers to find icu4c you may need to set:
  export LDFLAGS="-L/usr/local/opt/icu4c/lib"
  export CPPFLAGS="-I/usr/local/opt/icu4c/include"

==> Summary
🍺  /usr/local/Cellar/icu4c/62.1: 250 files, 67.3MB
==> Installing node
==> Downloading https://homebrew.bintray.com/bottles/node-11.2.0.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring node-11.2.0.mojave.bottle.tar.gz
==> Caveats
Bash completion has been installed to:
  /usr/local/etc/bash_completion.d
==> Summary
🍺  /usr/local/Cellar/node/11.2.0: 3,936 files, 47MB
==> Caveats
==> icu4c
icu4c is keg-only, which means it was not symlinked into /usr/local,
because macOS provides libicucore.dylib (but nothing else).

If you need to have icu4c first in your PATH run:
  echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile
  echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile

For compilers to find icu4c you may need to set:
  export LDFLAGS="-L/usr/local/opt/icu4c/lib"
  export CPPFLAGS="-I/usr/local/opt/icu4c/include"

==> node
Bash completion has been installed to:
  /usr/local/etc/bash_completion.d
Jig12:~ jig$


6. Install serverless framework

command
npm install -g serverless

output


Jig12:~ jig$ npm install -g serverless
/usr/local/bin/serverless -> /usr/local/lib/node_modules/serverless/bin/serverless
/usr/local/bin/sls -> /usr/local/lib/node_modules/serverless/bin/serverless
/usr/local/bin/slss -> /usr/local/lib/node_modules/serverless/bin/serverless

> spawn-sync@1.0.15 postinstall /usr/local/lib/node_modules/serverless/node_modules/spawn-sync
> node postinstall


> serverless@1.33.1 postinstall /usr/local/lib/node_modules/serverless
> node ./scripts/postinstall.js


[tabtab] Adding source line to load /usr/local/lib/node_modules/serverless/node_modules/tabtab/.completions/serverless.bash
in /Users/jig/.bashrc


[tabtab] Adding source line to load /usr/local/lib/node_modules/serverless/node_modules/tabtab/.completions/sls.bash
in /Users/jig/.bashrc

+ serverless@1.33.1
added 347 packages from 258 contributors in 50.758s
Jig12:~ jig$




7. Install AWS commandline cli

command:
brew install awscli

output:

Jig12:~ jig$ brew install awscli
==> Downloading https://homebrew.bintray.com/bottles/awscli-1.16.50.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring awscli-1.16.50.mojave.bottle.tar.gz
==> Caveats
The "examples" directory has been installed to:
  /usr/local/share/awscli/examples

Bash completion has been installed to:
  /usr/local/etc/bash_completion.d

zsh completions and functions have been installed to:
  /usr/local/share/zsh/site-functions
==> Summary
🍺  /usr/local/Cellar/awscli/1.16.50: 4,840 files, 44.3MB
Jig12:~ jig$


8. Install git

command
brew install git

output

Jig12:~ jig$ brew install git
==> Installing dependencies for git: gettext and pcre2
==> Installing git dependency: gettext
==> Downloading https://homebrew.bintray.com/bottles/gettext-0.19.8.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring gettext-0.19.8.1.mojave.bottle.tar.gz
==> Caveats
gettext is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD gettext library & some software gets confused if both are in the library path.

If you need to have gettext first in your PATH run:
  echo 'export PATH="/usr/local/opt/gettext/bin:$PATH"' >> ~/.bash_profile

For compilers to find gettext you may need to set:
  export LDFLAGS="-L/usr/local/opt/gettext/lib"
  export CPPFLAGS="-I/usr/local/opt/gettext/include"

==> Summary
🍺  /usr/local/Cellar/gettext/0.19.8.1: 1,935 files, 16.9MB
==> Installing git dependency: pcre2
==> Downloading https://homebrew.bintray.com/bottles/pcre2-10.32.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring pcre2-10.32.mojave.bottle.tar.gz
🍺  /usr/local/Cellar/pcre2/10.32: 224 files, 5.5MB
==> Installing git
==> Downloading https://homebrew.bintray.com/bottles/git-2.19.1.mojave.bottle.tar.gz
######################################################################## 100.0%
==> Pouring git-2.19.1.mojave.bottle.tar.gz
==> Caveats
Bash completion has been installed to:
  /usr/local/etc/bash_completion.d

zsh completions and functions have been installed to:
  /usr/local/share/zsh/site-functions

Emacs Lisp files have been installed to:
  /usr/local/share/emacs/site-lisp/git
==> Summary
🍺  /usr/local/Cellar/git/2.19.1: 1,518 files, 40.1MB
==> Caveats
==> gettext
gettext is keg-only, which means it was not symlinked into /usr/local,
because macOS provides the BSD gettext library & some software gets confused if both are in the library path.

If you need to have gettext first in your PATH run:
  echo 'export PATH="/usr/local/opt/gettext/bin:$PATH"' >> ~/.bash_profile

For compilers to find gettext you may need to set:
  export LDFLAGS="-L/usr/local/opt/gettext/lib"
  export CPPFLAGS="-I/usr/local/opt/gettext/include"

==> git
Bash completion has been installed to:
  /usr/local/etc/bash_completion.d

zsh completions and functions have been installed to:
  /usr/local/share/zsh/site-functions

Emacs Lisp files have been installed to:
  /usr/local/share/emacs/site-lisp/git
Jig12:~ jig$


10. generate ssh key

command
ssh-keygen -C makwana.jignesh@gmail.com
ssh-add id_rsa


output


Jig12:~ jig$ ssh-keygen -C makwana.jignesh@gmail.com
Generating public/private rsa key pair.
Enter file in which to save the key (/Users/jig/.ssh/id_rsa):
/Users/jig/.ssh/id_rsa already exists.
Overwrite (y/n)? y
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Passphrases do not match.  Try again.

Jig12:~ jig$ ssh-keygen -C makwana.jignesh@gmail.com
Generating public/private rsa key pair.
Enter file in which to save the key (/Users/jig/.ssh/id_rsa):
/Users/jig/.ssh/id_rsa already exists.
Overwrite (y/n)? y
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Passphrases do not match.  Try again.

11. configure aws account

aws configure --profile myp
aws s3 ls --profile myp


Output:


Jig12:~ jig$ aws configure --profile myp
AWS Access Key ID [None]: xxx
AWS Secret Access Key [None]: xxx
Default region name [None]: ap-southeast-1
Default output format [None]:


All in one Command

brew doctor
brew cask install atom
brew install python3
pip3 install pipenv
brew install node
npm install -g serverless
brew install awscli
brew install git
ssh-keygen -C makwana.jignesh@gmail.com
ssh-add id_rsa
aws configure --profile myp
aws s3 ls --profile myp

adcfgclone fails - Oracle Homes are already registered

Below Oracle Homes are already registered in the inventory:


/u01/EBSDEV/fs1/FMW_Home/Oracle_EBS-app1
/u01/EBSDEV/fs1/FMW_Home/webtier
/u01/EBSDEV/fs1/FMW_Home/oracle_common
/u01/EBSDEV/fs1/FMW_Home/Oracle_OAMWebGate1

Solution:

Option 1:

if you have a backup of Oracle inventory then you can restore it.

Option 2 (clean):

De-register oracle home from inventory.

cd /u01/EBSDEV/fs1/EBSapps/10.1.2/oui/bin

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/Oracle_EBS-app1"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/webtier"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/oracle_common"}

./runInstaller -silent -deinstall REMOVE_HOMES={"/u01/EBSDEV/fs1/FMW_Home/Oracle_OAMWebGate1"}

Oracle EBS Stop and start script

Oracle EBS Stop and start script


Database

cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts
touch stopdbTEST.sh ; touch startdbTEST.sh

cat >> stopdbTEST.sh << EOF
# soruce db env
. /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediate
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop $ORACLE_SID 
EOF


cat >> startdbTEST.sh << EOF
# soruce db env
. /u01/TEST/oracle/product/db/12.1.0.1/TEST_ebs121db1.env
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh start 
sh $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh start $ORACLE_SID 
EOF

Application

cd ~; mkdir -p /u01/scripts; ln -s /u01/scripts scripts; cd ~/scripts
touch stopapPROD.sh ; touch startapPROD.sh; chmod +x stopapPROD.sh startapPROD.sh

cat >> stopapPROD.sh << EOF
# soruce AP env
. /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env
sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps
EOF


cat >> startapPROD.sh << EOF
# soruce db env
. /u01/PROD/apps/apps_st/appl/APPSPROD_ebs121ap1.env
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps
EOF

How to Stop Firewall on Oracle Linux 7

How to Stop Firewall on Oracle Linux 7

[root@ebs121db1 ~]# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination
[root@ebs121db1 ~]#

Solution
systemctl | grep -i iptables systemctl | grep -i firewall systemctl status firewalld systemctl stop firewalld systemctl disable firewalld

[root@ebs121db1 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[root@ebs121db1 ~]#

script - invobjsq.

select count(*), object_type 
from dba_objects 
where STATUS='INVALID' 
group by object_type;

Oracle EBS Backup script

Oracle EBS Backup script



EBS Application
vim /u01/scripts/ebs-ap-backup.sh

cd /u01/PROD/
tar -czvf /u01/backup/inst.tz inst

cd /u01/PROD/apps/apps_st/
tar -czvf /u01/backup/apps_apps_st_appl.tz appl
tar -czvf /u01/backup/apps_apps_st_comn.tz comn

cd /u01/PROD/apps/tech_st/
tar -czvf /u01/backup/apps_tech_st_10.1.3.tz 10.1.3
tar -czvf /u01/backup/apps_tech_st_10.1.2.tz 10.1.2

nohup sh /u01/scripts/ebs-ap-backup.sh > /u01/scripts/ebs-ap-backup.log & 

EBS Database


vim /u01/scripts/ebs-db-backup.sh

cd /u01/PROD/db/tech_st
tar -czvf /u01/backup/db_tech_st_1117.tz 11.1.0

cd /u01/PROD/db/apps_st
tar -czvf /u01/backup/db_apps_st_data.tz data

nohup sh /u01/scripts/ebs-db-backup.sh > /u01/scripts/ebs-db-backup.log & 

Oracle EBS 12.1.1 unzip stage

Oracle EBS 12.1.1 unzip stage

vim /u01/scripts/unzip121.sh

cd /u01/stage121
echo "unzip B53824-01_1of4.zip"; unzip -o -q /u01/software/B53824-01_1of4.zip -d /u01/stage121
echo "unzip B53824-01_2of4.zip"; unzip -o -q /u01/software/B53824-01_2of4.zip -d /u01/stage121
echo "unzip B53824-01_3of4.zip"; unzip -o -q /u01/software/B53824-01_3of4.zip -d /u01/stage121
echo "unzip B53824-01_4of4.zip"; unzip -o -q /u01/software/B53824-01_4of4.zip -d /u01/stage121
echo "unzip V15680-01_1of3.zip"; unzip -o -q /u01/software/V15680-01_1of3.zip -d /u01/stage121
echo "unzip V15680-01_2of3.zip"; unzip -o -q /u01/software/V15680-01_2of3.zip -d /u01/stage121
echo "unzip V15680-01_3of3.zip"; unzip -o -q /u01/software/V15680-01_3of3.zip -d /u01/stage121
echo "unzip V15681-01_1of3.zip"; unzip -o -q /u01/software/V15681-01_1of3.zip -d /u01/stage121
echo "unzip V15681-01_2of3.zip"; unzip -o -q /u01/software/V15681-01_2of3.zip -d /u01/stage121
echo "unzip V15681-01_3of3.zip"; unzip -o -q /u01/software/V15681-01_3of3.zip -d /u01/stage121
echo "unzip V15682-01_1of3.zip"; unzip -o -q /u01/software/V15682-01_1of3.zip -d /u01/stage121
echo "unzip V15682-01_2of3.zip"; unzip -o -q /u01/software/V15682-01_2of3.zip -d /u01/stage121
echo "unzip V15682-01_3of3.zip"; unzip -o -q /u01/software/V15682-01_3of3.zip -d /u01/stage121
echo "unzip V15683-01_1of3.zip"; unzip -o -q /u01/software/V15683-01_1of3.zip -d /u01/stage121
echo "unzip V15683-01_2of3.zip"; unzip -o -q /u01/software/V15683-01_2of3.zip -d /u01/stage121
echo "unzip V15683-01_3of3.zip"; unzip -o -q /u01/software/V15683-01_3of3.zip -d /u01/stage121
echo "unzip V15684-01_1of3.zip"; unzip -o -q /u01/software/V15684-01_1of3.zip -d /u01/stage121
echo "unzip V15684-01_2of3.zip"; unzip -o -q /u01/software/V15684-01_2of3.zip -d /u01/stage121
echo "unzip V15684-01_3of3.zip"; unzip -o -q /u01/software/V15684-01_3of3.zip -d /u01/stage121
echo "unzip V15685-01_1of3.zip"; unzip -o -q /u01/software/V15685-01_1of3.zip -d /u01/stage121
echo "unzip V15685-01_2of3.zip"; unzip -o -q /u01/software/V15685-01_2of3.zip -d /u01/stage121
echo "unzip V15685-01_3of3.zip"; unzip -o -q /u01/software/V15685-01_3of3.zip -d /u01/stage121
echo "unzip V15686-01_1of3.zip"; unzip -o -q /u01/software/V15686-01_1of3.zip -d /u01/stage121
echo "unzip V15686-01_2of3.zip"; unzip -o -q /u01/software/V15686-01_2of3.zip -d /u01/stage121
echo "unzip V15686-01_3of3.zip"; unzip -o -q /u01/software/V15686-01_3of3.zip -d /u01/stage121
echo "unzip V15687-01_1of3.zip"; unzip -o -q /u01/software/V15687-01_1of3.zip -d /u01/stage121
echo "unzip V15687-01_2of3.zip"; unzip -o -q /u01/software/V15687-01_2of3.zip -d /u01/stage121
echo "unzip V15687-01_3of3.zip"; unzip -o -q /u01/software/V15687-01_3of3.zip -d /u01/stage121
echo "unzip V15688-01_1of2.zip"; unzip -o -q /u01/software/V15688-01_1of2.zip -d /u01/stage121
echo "unzip V15688-01_2of2.zip"; unzip -o -q /u01/software/V15688-01_2of2.zip -d /u01/stage121
echo "unzip V15689-01.zip"; unzip -o -q /u01/software/V15689-01.zip -d /u01/stage121
echo "unzip V15690-01_1of3.zip"; unzip -o -q /u01/software/V15690-01_1of3.zip -d /u01/stage121
echo "unzip V15690-01_2of3.zip"; unzip -o -q /u01/software/V15690-01_2of3.zip -d /u01/stage121
echo "unzip V15690-01_3of3.zip"; unzip -o -q /u01/software/V15690-01_3of3.zip -d /u01/stage121
echo "unzip V15691-01_1of3.zip"; unzip -o -q /u01/software/V15691-01_1of3.zip -d /u01/stage121
echo "unzip V15691-01_2of3.zip"; unzip -o -q /u01/software/V15691-01_2of3.zip -d /u01/stage121
echo "unzip V15691-01_3of3.zip"; unzip -o -q /u01/software/V15691-01_3of3.zip -d /u01/stage121
echo "unzip V35224-01_1of3.zip"; unzip -o -q /u01/software/V35224-01_1of3.zip -d /u01/stage121
echo "unzip V35224-01_2of3.zip"; unzip -o -q /u01/software/V35224-01_2of3.zip -d /u01/stage121
echo "unzip V35224-01_3of3.zip"; unzip -o -q /u01/software/V35224-01_3of3.zip -d /u01/stage121

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.