Author Archives: dba365

Standard

Posted by

Posted on

February 20, 2019

Posted under

linux, Uncategorized

Comments

Leave a comment

WebLogic/Node Manager Server startup is very slow on Linux

Started WebLogic (startWebLogic.sh) and it took close to 20 minutes to start and 15 minutes to start node manager. Came across below MOS document that helped resolve the issue. The slowness was due to depletion of the entropy pool provided by the OS. We need at least 500 for WebLogic.

Entropy is randomness from keyboard timings, mouse movements, and IDE timings and makes the random character data available to OS system processes through the /dev/random and /dev/urandom When there is not enough random bits left it will block and the process that are reading from it will hang until bits that are more random has been generated.

Monitoring entropy

The default size of the entropy pool is 4096 bits. You can see the size here.

[oracle@ussvr137 ~]$ cat /proc/sys/kernel/random/poolsize

4096

You can see how much entropy is available via:

[oracle@ussvr137 ~]$ cat /proc/sys/kernel/random/entropy_avail

2136

Or use watch if you want to display it every second:

watch -n 1 cat /proc/sys/kernel/random/entropy_avail

If you monitor with watch during WebLogic startup, you can check to see if entropy gets drained on the server for entropy.

Solution available in the following MOS notes.

How to diagnose a Linux entropy issue on WebLogic Server instances? (Doc ID 1574979.1)

Integrated WebLogic Server startup is very slow on Linux (Doc ID 1997349.1)

E1: OS: Linux Servers Hang or Have Delays on Any JAVA Process Affecting Performance (Doc ID 1525645.1

Standard

Posted by

Posted on

February 1, 2019

Posted under

Uncategorized

Comments

Leave a comment

Linux command line reference for common operations.

Command Description
  apropos whatis Show commands pertinent to string. See also threadsafe
  man -t ascii | ps2pdf – > ascii.pdf make a pdf of a manual page
  which command Show full path name of command
  time command See how long a command takes
  time cat Start stopwatch. Ctrl-d to stop. See also sw
dir navigation
  cd – Go to previous directory
  cd Go to $HOME directory
  (cd dir && command) Go to dir, execute command and return to current dir
  pushd . Put current dir on stack so you can popd back to it
  alias l=’ls -l –color=auto’ quick dir listing. See also l
  ls -lrt List files by date. See also newest and find_mm_yyyy
  ls /usr/bin | pr -T9 -W$COLUMNS Print in 9 columns to width of terminal
  find -name ‘*.[ch]’ | xargs grep -E ‘expr’ Search ‘expr’ in this dir and below. See also findrepo
  find -type f -print0 | xargs -r0 grep -F ‘example’ Search all regular files for ‘example’ in this dir and below
  find -maxdepth 1 -type f | xargs grep -F ‘example’ Search all regular files for ‘example’ in this dir
  find -maxdepth 1 -type d | while read dir; do echo $dir; echo cmd2; done Process each item with multiple commands (in while loop)
  find -type f ! -perm -444 Find files not readable by all (useful for web site)
  find -type d ! -perm -111 Find dirs not accessible by all (useful for web site)
  locate -r ‘file[^/]*\.txt’ Search cached index for names. This re is like glob *file*.txt
  look reference Quickly search (sorted) dictionary for prefix
  grep –color reference /usr/share/dict/words Highlight occurances of regular expression in dictionary
archives and compression
  gpg -c file Encrypt file
  gpg file.gpg Decrypt file
  tar -c dir/ | bzip2 > dir.tar.bz2 Make compressed archive of dir/
  bzip2 -dc dir.tar.bz2 | tar -x Extract archive (use gzip instead of bzip2 for tar.gz files)
  tar -c dir/ | gzip | gpg -c | ssh user@remote ‘dd of=dir.tar.gz.gpg’ Make encrypted archive of dir/ on remote machine
  find dir/ -name ‘*.txt’ | tar -c –files-from=- | bzip2 > dir_txt.tar.bz2 Make archive of subset of dir/ and below
  find dir/ -name ‘*.txt’ | xargs cp -a –target-directory=dir_txt/ –parents Make copy of subset of dir/ and below
  ( tar -c /dir/to/copy ) | ( cd /where/to/ && tar -x -p ) Copy (with permissions) copy/ dir to /where/to/ dir
  ( cd /dir/to/copy && tar -c . ) | ( cd /where/to/ && tar -x -p ) Copy (with permissions) contents of copy/ dir to /where/to/
  ( tar -c /dir/to/copy ) | ssh -C user@remote ‘cd /where/to/ && tar -x -p’ Copy (with permissions) copy/ dir to remote:/where/to/ dir
  dd bs=1M if=/dev/sda | gzip | ssh user@remote ‘dd of=sda.gz’ Backup harddisk to remote machine
rsync (Network efficient file copier: Use the –dry-run option for testing)
  rsync -P rsync://rsync.server.com/path/to/file file Only get diffs. Do multiple times for troublesome downloads
  rsync –bwlimit=1000 fromfile tofile Locally copy with rate limit. It’s like nice for I/O
  rsync -az -e ssh –delete ~/public_html/ remote.com:’~/public_html’ Mirror web site (using compression and encryption)
  rsync -auz -e ssh remote:/dir/ . && rsync -auz -e ssh . remote:/dir/ Synchronize current directory with remote one
ssh (Secure SHell)
  ssh $USER@$HOST command Run command on $HOST as $USER (default command=shell)
  ssh -f -Y $USER@$HOSTNAME xeyes Run GUI command on $HOSTNAME as $USER
  scp -p -r $USER@$HOST: file dir/ Copy with permissions to $USER’s home directory on $HOST
  scp -c arcfour $USER@$LANHOST: bigfile Use faster crypto for local LAN. This might saturate GigE
  ssh -g -L 8080:localhost:80 root@$HOST Forward connections to $HOSTNAME:8080 out to $HOST:80
  ssh -R 1434:imap:143 root@$HOST Forward connections from $HOST:1434 in to imap:143
  ssh-copy-id $USER@$HOST Install public key for $USER@$HOST for password-less log in
wget (multi purpose download tool)
  (cd dir/ && wget -nd -pHEKk http://www.example.com/file) Store local browsable version of a page to the current dir
  wget -c http://www.example.com/large.file Continue downloading a partially downloaded file
  wget -r -nd -np -l1 -A ‘*.jpg’ http://www.example.com/dir/ Download a set of files to the current directory
  wget ftp://remote/file[1-9].iso/ FTP supports globbing directly
  wget -q -O- http://www.example/file | grep ‘a href’ | head Process output directly
  echo ‘wget url’ | at 01:00 Download url at 1AM to current dir
  wget –limit-rate=20k url Do a low priority download (limit to 20KB/s in this case)
  wget -nv –spider –force-html -i bookmarks.html Check links in a file
  wget –mirror http://www.example.com/ Efficiently update a local copy of a site (handy from cron)
networking (Note ifconfig, route, mii-tool, nslookup commands are obsolete)
  ethtool eth0 Show status of ethernet interface eth0
  ethtool –change eth0 autoneg off speed 100 duplex full Manually set ethernet interface speed
  iw dev wlan0 link Show link status of wireless interface wlan0
  iw dev wlan0 set bitrates legacy-2.4 1 Manually set wireless interface speed
  iw dev wlan0 scan List wireless networks in range
  ip link show List network interfaces
  ip link set dev eth0 name wan Rename interface eth0 to wan
  ip link set dev eth0 up Bring interface eth0 up (or down)
  ip addr show List addresses for interfaces
  ip addr add 1.2.3.4/24 brd + dev eth0 Add (or del) ip and mask (255.255.255.0)
  ip route show List routing table
  ip route add default via 1.2.3.254 Set default gateway to 1.2.3.254
  ss -tupl List internet services on a system
  ss -tup List active connections to/from system
  host pixelbeat.org Lookup DNS ip address for name or vice versa
  hostname -i Lookup local ip address (equivalent to host `hostname`)
  whois pixelbeat.org Lookup whois info for hostname or ip address
windows networking (Note samba is the package that provides all this windows specific networking support)
  smbtree Find windows machines. See also findsmb
  nmblookup -A 1.2.3.4 Find the windows (netbios) name associated with ip address
  smbclient -L windows_box List shares on windows machine or samba server
  mount -t smbfs -o fmask=666,guest //windows_box/share /mnt/share Mount a windows share
  echo ‘message’ | smbclient -M windows_box Send popup to windows machine (off by default in XP sp2)
text manipulation (Note sed uses stdin and stdout. Newer versions support inplace editing with the -i option)
  sed ‘s/string1/string2/g’ Replace string1 with string2
  sed ‘s/\(.*\)1/\12/g’ Modify anystring1 to anystring2
  sed ‘/^ *#/d; /^ *$/d’ Remove comments and blank lines
  sed ‘:a; /\\$/N; s/\\\n//; ta’ Concatenate lines with trailing \
  sed ‘s/[ \t]*$//’ Remove trailing spaces from lines
  sed ‘s/\([`”$\]\)/\\\1/g’ Escape shell metacharacters active within double quotes
  seq 10 | sed “s/^/      /; s/ *\(.\{7,\}\)/\1/” Right align numbers
  seq 10 | sed p | paste – – Duplicate a column
  sed -n ‘1000{p;q}’ Print 1000th line
  sed -n ‘10,20p;20q’ Print lines 10 to 20
  sed -n ‘s/.*<title>\(.*\)<\/title>.*/\1/ip;T;q’ Extract title from HTML web page
  sed -i 42d ~/.ssh/known_hosts Delete a particular line
  sort -t. -k1,1n -k2,2n -k3,3n -k4,4n Sort IPV4 ip addresses
  echo ‘Test’ | tr ‘[:lower:]’ ‘[:upper:]’ Case conversion
  tr -dc ‘[:print:]’ < /dev/urandom Filter non printable characters
  tr -s ‘[:blank:]’ ‘\t’ </proc/diskstats | cut -f4 cut fields separated by blanks
  history | wc -l Count lines
  seq 10 | paste -s -d ‘ ‘ Concatenate and separate line items to a single line
set operations (Note you can export LANG=C for speed. Also these assume no duplicate lines within a file)
  sort -u file1 file2 Union of unsorted files
  sort file1 file2 | uniq -d Intersection of unsorted files
  sort file1 file1 file2 | uniq -u Difference of unsorted files
  sort file1 file2 | uniq -u Symmetric Difference of unsorted files
  join -t’\0′ -a1 -a2 file1 file2 Union of sorted files
  join -t’\0′ file1 file2 Intersection of sorted files
  join -t’\0′ -v2 file1 file2 Difference of sorted files
  join -t’\0′ -v1 -v2 file1 file2 Symmetric Difference of sorted files
math
  echo ‘(1 + sqrt(5))/2’ | bc -l Quick math (Calculate φ). See also bc
  seq -f ‘4/%g’ 1 2 99999 | paste -sd-+ | bc -l Calculate π the unix way
  echo ‘pad=20; min=64; (100*10^6)/((pad+min)*8)’ | bc More complex (int) e.g. This shows max FastE packet rate
  echo ‘pad=20; min=64; print (100E6)/((pad+min)*8)’ | python Python handles scientific notation
  echo ‘pad=20; plot [64:1518] (100*10**6)/((pad+x)*8)’ | gnuplot -persist Plot FastE packet rate vs packet size
  echo ‘obase=16; ibase=10; 64206’ | bc Base conversion (decimal to hexadecimal)
  echo $((0x2dec)) Base conversion (hex to dec) ((shell arithmetic expansion))
  units -t ‘100m/9.58s’ ‘miles/hour’ Unit conversion (metric to imperial)
  units -t ‘500GB’ ‘GiB’ Unit conversion (SI to IEC prefixes). See also numfmt
  units -t ‘1 googol’ Definition lookup
  seq 100 | paste -s -d+ | bc Add a column of numbers. See also add and funcpy
calendar
  cal -3 Display a calendar
  cal 9 1752 Display a calendar for a particular month year
  date -d fri What date is it this friday. See also day
  [ $(date -d ’12:00 today +1 day’ +%d) = ’01’ ] || exit exit a script unless it’s the last day of the month
  date –date=’25 Dec’ +%A What day does xmas fall on, this year
  date –date=’@2147483647′ Convert seconds since the epoch (1970-01-01 UTC) to date
  TZ=’America/Los_Angeles’ date What time is it on west coast of US (use tzselect to find TZ)
  date –date=’TZ=”America/Los_Angeles” 09:00 next Fri’ What’s the local time for 9AM next Friday on west coast US
locales
  printf “%’d\n” 1234 Print number with thousands grouping appropriate to locale
  BLOCK_SIZE=\’1 ls -l Use locale thousands grouping in ls. See also l
  echo “I live in `locale territory`” Extract info from locale database
  LANG=en_IE.utf8 locale int_prefix Lookup locale info for specific country. See also ccodes
  locale -kc $(locale | sed -n ‘s/\(LC_.\{4,\}\)=.*/\1/p’) | less List fields available in locale database
recode (Obsoletes iconv, dos2unix, unix2dos)
  recode -l | less Show available conversions (aliases on each line)
  recode windows-1252.. file_to_change.txt Windows “ansi” to local charset (auto does CRLF conversion)
  recode utf-8/CRLF.. file_to_change.txt Windows utf8 to local charset
  recode iso-8859-15..utf8 file_to_change.txt Latin9 (western europe) to utf8
  recode ../b64 < file.txt > file.b64 Base64 encode
  recode /qp.. < file.qp > file.txt Quoted printable decode
  recode ..HTML < file.txt > file.html Text to HTML
  recode -lf windows-1252 | grep euro Lookup table of characters
  echo -n 0x80 | recode latin-9/x1..dump Show what a code represents in latin-9 charmap
  echo -n 0x20AC | recode ucs-2/x2..latin-9/x Show latin-9 encoding
  echo -n 0x20AC | recode ucs-2/x2..utf-8/x Show utf-8 encoding
CDs
  gzip < /dev/cdrom > cdrom.iso.gz Save copy of data cdrom
  mkisofs -V LABEL -r dir | gzip > cdrom.iso.gz Create cdrom image from contents of dir
  mount -o loop cdrom.iso /mnt/dir Mount the cdrom image at /mnt/dir (read only)
  wodim dev=/dev/cdrom blank=fast Clear a CDRW
  gzip -dc cdrom.iso.gz | wodim -tao dev=/dev/cdrom -v -data – Burn cdrom image (use –prcap to confirm dev)
  cdparanoia -B Rip audio tracks from CD to wav files in current dir
  wodim -v dev=/dev/cdrom -audio -pad *.wav Make audio CD from all wavs in current dir (see also cdrdao)
  oggenc –tracknum=$track track.cdda.wav -o track.ogg Make ogg file from wav file
disk space (See also FSlint)
  ls -lSr Show files by size, biggest last
  du -s * | sort -k1,1rn | head Show top disk users in current dir. See also dutop
  du -hs /home/* | sort -k1,1h Sort paths by easy to interpret disk usage
  df -h Show free space on mounted filesystems
  df -i Show free inodes on mounted filesystems
  fdisk -l Show disks partitions sizes and types (run as root)
  rpm -q -a –qf ‘%10{SIZE}\t%{NAME}\n’ | sort -k1,1n List all packages by installed size (Bytes) on rpm distros
  dpkg-query -W -f=’${Installed-Size;10}\t${Package}\n’ | sort -k1,1n List all packages by installed size (KBytes) on deb distros
  dd bs=1 seek=2TB if=/dev/null of=ext3.test Create a large test file (taking no space). See also truncate
  > file truncate data of file or create an empty file
monitoring/debugging
  tail -f /var/log/messages Monitor messages in a log file
  strace -c ls >/dev/null Summarise/profile system calls made by command
  strace -f -e open ls >/dev/null List system calls made by command
  strace -f -e trace=write -e write=1,2 ls >/dev/null Monitor what’s written to stdout and stderr
  ltrace -f -e getenv ls >/dev/null List library calls made by command
  lsof -p $$ List paths that process id has open
  lsof ~ List processes that have specified path open
  tcpdump not port 22 Show network traffic except ssh. See also tcpdump_not_me
  ps -e -o pid,args –forest List processes in a hierarchy
  ps -e -o pcpu,cpu,nice,state,cputime,args –sort pcpu | sed ‘/^ 0.0 /d’ List processes by % cpu usage
  ps -e -orss=,args= | sort -b -k1,1n | pr -TW$COLUMNS List processes by mem (KB) usage. See also ps_mem.py
  ps -C firefox-bin -L -o pid,tid,pcpu,state List all threads for a particular process
  ps -p 1,$$ -o etime= List elapsed wall time for particular process IDs
  watch -n.1 pstree -Uacp $$ Display a changing process subtree
  last reboot Show system reboot history
  free -m Show amount of (remaining) RAM (-m displays in MB)
  watch -n.1 ‘cat /proc/interrupts’ Watch changeable data continuously
  udevadm monitor Monitor udev events to help configure rules
system information (see also sysinfo) (‘#’ means root access is required)
  uname -a Show kernel version and system architecture
  head -n1 /etc/issue Show name and version of distribution
  cat /proc/partitions Show all partitions registered on the system
  grep MemTotal /proc/meminfo Show RAM total seen by the system
  grep “model name” /proc/cpuinfo Show CPU(s) info
  lspci -tv Show PCI info
  lsusb -tv Show USB info
  mount | column -t List mounted filesystems on the system (and align output)
  grep -F capacity: /proc/acpi/battery/BAT0/info Show state of cells in laptop battery
  dmidecode -q | less Display SMBIOS/DMI information
  smartctl -A /dev/sda | grep Power_On_Hours How long has this disk (system) been powered on in total
  hdparm -i /dev/sda Show info about disk sda
  hdparm -tT /dev/sda Do a read speed test on disk sda
  badblocks -s /dev/sda Test for unreadable blocks on disk sda
interactive (see also linux keyboard shortcuts)
  readline Line editor used by bash, python, bc, gnuplot, …
  screen Virtual terminals with detach capability, …
  mc Powerful file manager that can browse rpm, tar, ftp, ssh, …
  gnuplot Interactive/scriptable graphing
  links Web browser
  xdg-open . open a file or url with the registered desktop application

 

Standard

Posted by

Posted on

July 10, 2017

Posted under

Tomcat, Uncategorized

Comments

Leave a comment

How to configure Tomcat to serve image files from custom folder or NFS Share.

You can use to Tomcat to serve images, PDF, xls, docx from the custom directory. In our case, we used centralized NFS share to serve images to our custom Apex Applications.

Here is the how

Add a <context> to the tomcat/conf/server.xml file.

Windows example:
<Context docBase=”c:\Documents and Settings\The User\images” path=”/images” />

Linux example:
<Context docBase=”/var/project/images” path=”/images” />

Example of Server.xml (trimmed):

<Server port=”8025″ shutdown=”SHUTDOWN”>
…
<Service name=”Catalina”>
…
<Engine name=”Catalina” defaultHost=”localhost”>
…
<Host appBase=”webapps”
autoDeploy=”false” name=”localhost” unpackWARs=”true”
xmlNamespaceAware=”false” xmlValidation=”false”>

<Host name=”localhost” appBase=”webapps”
unpackWARs=”true” autoDeploy=”true”>
…
<!–Custom Images Directory–>
<Context docBase=”/nfsshare/custom/images” path=”/images” />

</Host>
</Engine>
</Service>
</Server>

Now, you should be able to pull files (e.g. /nfsshare/custom/images/TestImage.jpg) as http://localhost:8080/custom/images/TestImage.jpg

test

Standard

Posted by

Posted on

June 12, 2017

Posted under

Uncategorized

Comments

Leave a comment

Goods and Services Tax (GST)

Goods and Services Tax (GST) – ORACLE FINANCIALS FOR INDIA (OFI) (INDIA LOCALIZATIONS)

GST is a destination-based tax that will replace the current Central taxes and duties such as Excise Duty, Service Tax, Counter Vailing Duty (CVD), Special Additional Duty of Customs (SAD), Central Charges & Cesses and Local State Taxes, like Value Added Tax (VAT), Central Sales Tax (CST), Octroi, Entry Tax, Purchase Tax, Luxury Tax, Taxes on lottery, betting and gambling, state cesses and surcharges and Entertainment tax (other than the tax levied by the local bodies).

It will be a dual levy with State/Union territory GST and Central GST. Moreover, inter–state supplies would attract an Integrated GST, which would be the sum total of CGST and SGST/UTGST.

Consensus between Central and state governments has been reached on four-tier rate structure as follows (published by GST Council):

rates

Following 3 new tax types got proposed in GST:

CGST (Central Goods and Services Tax)
SGST (State Goods and Services Tax)
IGST (Integrated Goods and Services Tax)

flow

GST Rates are based on Revenue Neutral Rates. Following are the proposed rate types and the rates are not yet finalized as on the blog posted date:

  1. Merit rate => For essential goods and services.
  2. Standard rate => For goods and services in general.
  3. Special rate => For precious metals and for specified goods and services.
  4. Zero rate => For exports, supply to EOU/SEZ etc.

Goods and Services outside the purview of GST:

  • Alcohol for Human consumption =>  will continue with State Excise and VAT
  • Electricity => will continue with Electricity Duty
  • Petroleum Products => will continue with the current tax structure, likely to be brought under GST regime later
  • Tobacco products expected to be taxed under the GST regime along with Excise dutyGoods and Service Tax
    flow2

As we nearing the implementation date of July 1st, 2017, it’s very critical for companies who have operations in India to accommodate GST changes in their Oracle ERP systems to be compliance.

Oracle provided phased approach for implementing GST

GST development execution is being phased to accelerate delivery and to enable early access

Phase 1 – GST infrastructure:  dev complete and available through early access program for customers and partners starting in November 2016.

Phase 2 – GST model law and transition capabilities: enhancements based on the draft GST Model Law published in June 2016 and updated in November 2016, and infrastructure to support the transition from the current tax regime to GST

Phase 3 – Final GST requirements: additional requirements that may come in final specifications published by the government that cannot be addressed by functionality delivered in phase 1 and 2. This phase may or may not be needed as it is entirely dependent on what late specification changes may or may not come from the Government of India.

The India GST patch will be available for EBS release version 12.1.1 onwards.  GST patch will work for all EBS versions that are on premier or extended support as of the date of the release of patch (e.g. 12.1.x and 12.2.x).  It will not be available for any release versions that are in sustaining support (e.g. 11.5.10).

There are major functional and design changes for the GST solution.  Some of that includes: unified regime to rate flow for every tax type with user configurable tax types, date effective tax computation logic, user configurable taxable events, tax defaulting logic based on user configurable rules, major process changes for input tax credit management, and unified tax repositories, etc.

Phase 3 (Final patches) – For DBA

GST: Phase 3 Approach to Final Release – Patch Details (Doc ID 2268465.1)

Strategy:

  1. India GST functional patch
  2. TDS migration patch(This patch will migrate the TDS setup to the new system) – Attached TDS Migration Steps Document(OFI-GST- TDS Migration.pdf)
  3. TCS Migration Patch
  4. GST Enablement  patch
  5. TDS Enablement patch + Concurrent Program for Migrating the TDS Transactions
  6. TCS Enablement patch
  7. RUP Patches

Steps to follow:

Step1 – Clone target environment from Prod
Step 2 – Apply India GST functional patch
Step 3 – Apply TDS Migration Patch
Step 4 – Apply TCS Migration Patch
Step 5 – Test for transaction with existing IL regime and do GST setups
Step 6 – Once Testing done, apply GST Enablement Patch
Step 7 – Apply TDS enablement Patch
Step 8) Apply TCS Enablement Patch
Step 9) Apply Rup7 -Note: GST: Oracle Financials for India (OFI) RUP Patches ( Doc ID 2253455.1 ).
Step 10 – Apply One – Off Patches

For Functional folks, below are GST Oracle Recordings which provides detailed step by step implementation details.

Knowledge Notes

Overview of India GST Knowledge Notes (Doc ID 2192611.1)
E-Business Suite Release 12: India Goods and Service Tax (GST) Info Center (Doc ID 2176820.2)
Oracle Financials for India (OFI) -Goods and Service Tax – Order to Cash Functional Flow (Doc ID 2169197.1)
Oracle Financials for India (OFI) -Goods and Service Tax -Regime to Rate Functional Flow (Doc ID 2189339.1)
India Localization – Oracle Financials for India (OFI) – Goods and Services Tax (GST) Configuration – EBS GST Infrastructure (Doc ID 2190026.1)
Oracle Financials for India (OFI) -Goods and Service Tax -Procure to Pay Functional Flow (Doc ID 2169236.1)
Overview of Tax Computation in Purchase to Pay Transactions with Goods & Service Regime – GST (Doc ID 2169321.1)
Overview of Tax Computation in Order To Cash Transactions with Goods & Service Regime – GST (Doc ID 2169215.1)
Oracle E-Business Suite Release 12: India Goods and Service Tax (GST), August 2016 (Doc ID 2170500.1)

 Oracle Roundtable Series: GST and Oracle E-Business Suite

 

Standard

Posted by

Posted on

May 1, 2017

Posted under

Uncategorized

Comments

Leave a comment

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred.

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred.

LsInventory: OPatch Exception while accessing O2O
OPATCH_JAVA_ERROR  : An exception of type “OPatchException” has occurred:
OPatch Exception:  OUI found no such ORACLE_HOME set in the environment
  Can not get details for given Oracle Home
  An exception occurs
  null
There is no Interim Patch
OPATCH_JAVA_ERROR  : An exception of type “OPatchException” has occurred:
Can not get a list of inventory on this home.
ERROR: OPatch failed because of Inventory problem.

You get the above error when you try to do “Opatch lsinventory” or Path for Oracle Home is not listed under the drop down when you try to install using OUI (Oracle Universal Installer).

Cause: ORACLE_HOME (10.1.2) or (10.1.3) not exists in the central Inventory.

Solution: Attach (10.1.2) and (10.1.3) ORACLE_HOME to Inventory.

[applmgr@uswodapp008 ~]$ cd $ORACLE_HOME/oui/bin
[applmgr@uswodapp008 bin]$ pwd
/ebprd/appl/product/10.1.2/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=/ebprd/appl/product/10.1.2/oui/bin ORACLE_HOME_NAME=prd_1012_home
…AttachHome’ was successful
For IAS_ORACLE_HOME
[applmgr@uswodapp008 ~]$ cd $IAS_ORACLE_HOME/oui/bin
[applmgr@uswodapp008 bin]$ pwd
/ebprd/appl/product/10.1.3/oui/bin
./runInstaller -silent -attachHome ORACLE_HOME=/ebprd/appl/product/10.1.3/oui/bin ORACLE_HOME_NAME=prd_1012_home
…AttachHome’ was successful

Now you should be able to run “Opatch lsinventory” or See the Oralce_Home installation path under OUI install.

Standard

Posted by

Posted on

April 10, 2017

Posted under

Uncategorized

Comments

1 Comment

Oracle EBS SOA Gateway testquery does not return “TEST RESPONSE” or get HTTP 404 Not Found error.

Oracle EBS SOA Gateway testquery does not return “TEST RESPONSE” or get HTTP 404 Not Found error.

soa1

Checking to see SOA gateway working as expected, Oracle document notes Test Web Service URL to check. (Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (Doc ID 556540.1)

http(s)://<hostname>:<port>/webservices/SOAProvider/?testquery

If it returns <testresponse>, then the setup is performed successfully and working as expected.

If you got no response page when testing with “http://server_name:port/webservices/SOAProvider/?testquery”, please check the following.

Verify ASADMIN application user is unlocked and password is working.

Check and confirm password of ASADMIN under $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml.

Example:

<user>
                                <name>ASADMIN</name>
                                <display-name>Default Apps SOA User</display-name>
                                <guid>51A6C7C035CA11E7BFAA8BE9754F2384</guid>
                                <description>Used by SOAProvider for DB connection</description>
                                <credentials>!asadminpw123</credentials>
                        </user>

 Note: The password should be preceded by a ‘!’ (Exclamation) so that when OAFM is started, it gets encrypted. For example, if your password is ‘welcome’, then you should write it in the above file as “!welcome”.

Verify that ASADMIN EBS User for ISG and XML Gateway JDBC Connections to the Database is Correctly Implemented. (Doc ID 1089197.1)

  • After correcting the password, bounce oc4j OACORE and OAFM process
$ADMIN_SCRIPTS_HOME/adoacorectl.sh stop
$ADMIN_SCRIPTS_HOME/adoacorectl.sh start
$ADMIN_SCRIPTS_HOME/adoafmctl.sh stop
$ADMIN_SCRIPTS_HOME/adoafmctl.sh start
  • Clear Global Cache

Login as sysadmin >Functional Admin responsibility> Core Service> Caching Framework>Global Config> Click on Clear Cache

 soa2

You won’t be able to see the password as it will be encrypted.

select user_name, ENCRYPTED_FOUNDATION_PASSWORD , ENCRYPTED_USER_PASSWORD from fnd_user where user_name = ‘ASADMIN’;

You can check to see if the password is working by executing below.

SQL> select fnd_web_sec.validate_login(‘ASADMIN’,’asadminpw123′) from dual;
FND_WEB_SEC.VALIDATE_LOGIN(‘ASADMIN’,’ASADM1NSOAPRD’)
——————————————————————————–
Y

Now try the Test Webservice URL. If still errors. Check the ASADMIN role using below query. 

SQL> select role_name from wf_user_roles where user_name=’ASADMIN’;

 ROLE_NAME
——————————————————————————–
ASADMIN
UMX|APPS_SCHEMA_CONNECT

 SQL> select role_name from wf_user_role_assignments where user_name=’ASADMIN’;

 ROLE_NAME
——————————————————————————–
ASADMIN
UMX|APPS_SCHEMA_CONNECT

If results missing for any of the queries above. Run the ‘Workflow Directory Services User/Role Validation‘ concurrent program to grant the role.

Batch Size : 10000
User Name : ASADMIN
Fix dangling users : Yes
Add missing user/role assignment : Yes
Update WHO Columns in WF Tables : No

Test Webservice URL.

soa3

Standard

Posted by

Posted on

November 1, 2016

Posted under

Uncategorized

Comments

Leave a comment

How to clear Middle Tier cache in R12

Go to “Functional Administrator” responsibility à Select “Core Services” (If missing, assign ‘Functional Administrator’ responsibility to your account)

c1.jpg

OR

c2.jpg
Select “Caching Framework”
Select “Global Configuration”
Now click on “Clear cache”
Click on “Yes” button to confirm
Click on “Apply” button to clear the cachec3.jpg

c4.jpg

 Source: How to Clear the Cache Using Functional Administrator? (Doc ID 759038.1)

 Note: If you have removed the _pages manually and are facing login issue that’s blank screen.
Use the ojspcompile.pl perl script to perform a manual pre-compilation of the JSP pages.The following command will compile all the JSP pages and build up the JSP cache again.
            perl $FND_TOP/patch/115/bin/ojspCompile.pl –compile –flush -p 2
This utility is also used by the AD utilities to perform this action such as when patches are applied that replace one or more JSP pages

See Note: JSP Pages Hanging in R12 After Removing Cached Class Files in _pages (Doc ID 433386.1)

Standard

Posted by

Posted on

October 28, 2016

Posted under

Uncategorized

Comments

Leave a comment

Passwordless SSH connection setup between Linux Nodes

What is SSH: Secure Shell (SSH) is an open source cryptographic network protocol for operating network services securely over an unsecured network. The best-known example application is for remote login to computer systems by users. SSH provides a secure channel over an unsecured network in a client-server architecture, connecting an SSH client application with an SSH server.

What is SSH-KEYGEN: ssh-keygen is a standard component of the Secure Shell (SSH) protocol suite found on Unix and Unix-like computer systems used to establish secure shell sessions between remote computers over insecure networks, through the use of various cryptographic techniques. The ssh-keygen utility is used to generate, manage, and convert authentication keys. ssh-keygen is able to generate a key using one of three different digital signature algorithms.

Test Case: In our example, we will setup SSH password-less automatic login from server user1@tstserver001 to server user2stserver002
SSH Client: user1@tstserver001
SSH Remote Host: user2stserver002

  1. Frist attempt to log in without setting up SSH keys, we will be prompted for the password.

ssh1

 

Now let’s create a SSH Key on user1@tstserver001

ssh2.jpg

 Now that our Public Key has been created (/home/user1/.ssh/id_rsa.pub), we can now upload that to any node to setup Password-less connection.

2. Create .SSH directory on user2@tstserver2 if it doesn’t exist.

ssh3.jpg

3. Upload and append the Public Key (id_rsa.pub) on server user2@tstserver2

ssh4.jpg

4. Set Permissions on Remote Host (user2@tstserver002)

ssh5.jpg

 

  • Alternate ways to do Step 3 and 4, you also Secure Copy the Public Key (id_rsa.pub) file and then append.ssh6.jpg

5. Test Logging in from [user1@tstserver001]$ to [user2@tstserver002]

From now, you can log in to [user2@tstserver002] from [user1@tstserver001] without the password.

ssh7.jpg

 

Standard

Posted by

Posted on

September 30, 2016

Posted under

Forms Runtime Diagnostics, Uncategorized

Comments

2 Comments

How to enable Diagnostics in Oracle Applications R12

Users may not able to able to see Help >Diagnostics option or get an error “Function Not Available to this Responsibility. Please check with your system administrator.”

These profiles need to be set at user level. So specific user can access this functionality (ex. Support folks/Developers)

Navigation: Go to System Administrator responsibility
Profile> System

Profile Option Name: Utilities:Diagnostics
User Level: Yes

diag2.jpg

Profile Option Name: Hide Diagnostics menu entry
User Level: NO

diag1.jpg
Save changes
Have user logout of Oracle Application and login again

User should be able to access Help >Diagnostics Menu

diag3.jpg

 

Standard

Posted by

Posted on

August 15, 2016

Posted under

Uncategorized

Comments

Leave a comment

Concurrent program to bounce Mobile Warehouse Applications (MWA)

Scope: Create a Concurrent program to bounce Mobile Warehouse Applications (MWA)

Shell Program for MWA Bounce on the Server

First, create a shell script on the Application server.

 #!/bin/bash
# mwa_bounce.sh 03/29/2016 RG

echo “Following are System Parameters”
echo “~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”
p0=$0
p1=$1
p2=$2
p3=$3
p4=$4
echo “1st System Parameter :”$p0
#echo “2nd System Parameter :”$p1
echo “3rd System Parameter :”$p2
echo “4th System Parameter :”$p3
echo “5th System Parameter :”$p4
echo “~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”
echo “~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”
echo “Following are User Parameters “
echo “~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”
#u1=$5
#echo “1st User Parameter :”$u1
echo “~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~”

echo “Stopping MWA Server via “$p0
echo
nohup $ADMIN_SCRIPTS_HOME/mwactlwrpr.sh stop $p1
echo $ADMIN_SCRIPTS_HOME/mwactlwrpr.sh stop APPS

mail -s “Concurrent Request “$p4” Submitted to Bounce MWA by “$p3 ramesh.ganesan@mycompany.com< /dev/null

sleep 30

# Kill MWADIS

for pids in `ps -fu appldev|grep MWADIS|grep -v “grep”|awk ‘{print $2}’`
do
echo “forcing kill on MWADIS PID ${pids}”
kill -9 ${pids}
done

# Kill telnet
for pids in `ps -fu appldev|grep telnet|grep -v “grep”|awk ‘{print $2}’`
do
#DTL=`ps -fu appldev|grep telnet|grep -v “grep”|awk ‘{print $15}’` # 11i
DTL=`ps -fu appldev|grep telnet|grep -v “grep”|awk ‘{print $17}’` # R12.2
echo “forcing kill on PID ${pids} for ${DTL}”
kill -9 ${pids}
done

sleep 30

echo “Starting MWA Server via “$p0
echo $ADMIN_SCRIPTS_HOME/mwactlwrpr.sh start APPS
echo
rm -rf /tmp/mwa_alert.txt
touch /tmp/mwa_alert.txt
nohup $ADMIN_SCRIPTS_HOME/mwactlwrpr.sh start $p1 |tee /tmp/mwa_alert.txt

# if the dispatcher isn’t free, email me

MWAERROR=`cat /tmp/mwa_alert.txt | grep “is not free to start the dispatcher”`

if [ ! -z “$MWAERROR” ]
then
echo $MWAERROR | mail -s “MWA Error” ramesh.ganesan@brakepartsinc.com
fi

Copy the program to $CUSTOM_TOP/bin and create Soft link

cd $XXBPI_TOP/bin
[appldev@uswodapp013 bin]$ ln -s /ua4001/appl/fnd/12.0.0/bin/fndcpesr mwa_bounce

Create Concurrent Program Executable

As SYSADMIN, define the Executable via Concurrent->Program->Executable

mwa1

Create Concurrent Program Definition

sysadmin, define the Executable via Concurrent->Program->Define

mwa2

Assign a Request Group

Security->Responsibility->Request

mwa3

Submit the Request and view Log file and verify Email

mwa4

 

Log file

mwa5

Email output

mwa6

Program Definition and Request Group can be downloaded and uploaded to other EBS instances with MWA

Program Definition Download

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct xxbpi_mwa_bounce_prgm.ldt PROGRAM APPLICATION_SHORT_NAME=”XXBPI_MWA_BOUNCE” CONCURRENT_PROGRAM_NAME=”XXBPI_MWA_BOUNCE”

Upload

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct xxbpi_mwa_bounce_prgm.ldt

Request Group Download

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct xxbpi_system_admin_reports_reqgrp.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”System Administrator Reports” APPLICATION_SHORT_NAME=”FND”

Upload

FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct xxbpi_system_admin_reports_reqgrp.ldt