Ora Training Blog

ORA Training would like to bring to your notice that a lot of bloggers are copying our content AS IS without our permission and taking undue advantage of it. Please beware of such blogs and companies.

Update: We have identified so many other blogs copying our content that now it seems worthless listing them all since they use our images directly which show our logo as well but all they care is to copy as is.

One of the example fraud is appsdbatraining.com (and many more similar names). Please beware of this fraudulent company which has no content of their own and copy paste whatever good work ORATraining.com is doing. We seek legal advise to bring these frauds down. These are the people who seek free help from us on our blog and then sell the information outside for profit.

These novice bloggers keep copying our content WORD by WORD, not even changing the caps and highlighted content. We have already informed them that they have same content from our blog but they do not even respond and such people even hide their identity.

The whole Oracle community knows the quality content that ORA Training delivers and such people try to misuse our content for their petty advantages. Please refrain from such companies at all cost since they are not genuine and if they are not honest enough to admit this then they are not worth doing any business with.

We would really appreciate if you can report any such blogs to us whenever you encounter our blog content being copied by such unethical individuals who are ashamed of even disclosing their names to the Oracle community.

We DO allow a lot of people to use our content but they need to take our permission and mention the same on their page. There are  a lot of experts in our industry and we are more than glad to share our content with them as we all are focusing towards the betterment of Oracle community than any profits. This is the reason our knowledge is being shared for free as those who have calibre will not shy from talking directly to us and we are glad to work with them.

For example, have a look at following post. (at least as on while writing this, since they may change the content after reading this)

http://www.appsdbatraining.com/2014/03/18/oracle-fusion-applications-installation-11-1-8-step-step/

And here is what they have copied from our original post

http://www.oratraining.com/blog/2013/11/oracle-fusion-applications-installation-step-by-step-guide-11-1-7/

Memory:
Option 1. For single product (except Financials, CRM or SCM) : Minimum 64+ GB (Recommended 96+ GB)
Option 2: For Financials or CRM or SCM: Minimum 88+ GB (Recommended 128 GB)
Option 3: For all products selected: Minimum 144+ GB

Preparing for Oracle Fusion Applications installation

1. Downloading Oracle Fusion Applications 11.1.8 media from http://edelivery.oracle.com/
2. Creating Oracle Fusion Applications provisioning repository / Staging directory
3. Installing OS (here Oracle Linux x86-64) on physical machine or Virtual machine (here Oracle VirtualBox VM)

Preparing for Oracle Fusion Applications installation

1. Downloading Oracle Fusion Applications media

Login to http://edelivery.oracle.com to access the following screen.

Installing Oracle Fusion Applications 11.1.8 – steps

A. Setting up Identity and Access Management Node

1. Install Fusion Applications Provisioning Framework

2. Install Oracle 11g Database (Identity management database)

3. Run Repository Creation Utility (RCU) for Oracle Identity Management components

4. Install Identity Management Provisioning Wizard

5. Create IDM provisioning Response File

6. Provision Identity Management

7. Perform Post-Provisioning Configuration

B. Setting up Fusion Applications Node

1. Install Fusion Applications Provisioning Framework

2. Install Oracle 11g Database (Fusion Apps Database)

3. Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)

4. Create new Applications Provisioning Response File

5. Provision an Applications Environment

Often we encounter errors that a particular required port is already being used by another process.

The steps to find out which process is using a particular port number is relatively easy in Linux but it can be a bit tricky on Solaris.

Let us see how to find process PID from port number

1. For Linux Operating System

There are 3 ways to find this out depending on which package is installed in your OS.

i) fuser

The syntax of using fuser is
fuser <port>/<protocol>

For example, to find which process is using TCP port 23792,

root@dbhost1 etc]# fuser 23792/tcp
23792/tcp: 17006

ii) netstat

The syntax of using netstat to find process ID from port is
netstat -tulpn | grep <port>

For example, to find which process is using TCP port 23792,

[root@dbhost1 etc]# netstat -tulpn | grep 23792
tcp 0 0 :::23792 :::* LISTEN 17006/java

iii) lsof

The syntax of using lsof to find process ID from port is
lsof -i <protocol>:<port>

For example, to find which process is using TCP port 23792,

[root@dbhost1 etc]# lsof -i tcp:23792
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 17006 grid 170u IPv6 594633 0t0 TCP *:23792 (LISTEN)

2. For Solaris Operating System

Since these utilities are generally not installed or available by default on Solaris operating system, we use following easy script to find PID from port number.

Note: Save this script as check_port.sh and grant execute permissions using chmod +x to this script.

#!/bin/bash

# Get the process which listens on port

# $1 is the port we are looking for

if [ $# -lt 1 ]
then
echo “Please provide a port number parameter for this script”
echo “e.g. $0 22”
exit
fi

echo “Greping for your port, please be patient (CTRL+C breaks) … ”

for i in `ls /proc`
do
pfiles $i | grep AF_INET | grep $1
if [ $? -eq 0 ]
then
echo Is owned by pid $i
fi
done

Now the syntax of using this script is
./check_port.sh <port number>

For example, to find which process is using TCP port 1521,

root@hostname # ./check_port.sh 1521
Greping for your port, please be patient (CTRL+C breaks) …
sockname: AF_INET 10.21.26.24 port: 1521
Is owned by pid 10279
^C

That’s it. Please feel free to add/suggest any new utilities to other users in comment section below.

Happy learning !

For those who missed Larry’s yesterday’s fantastic presentation of Oracle In-Memory database option, please watch it here.

http://www.oracle.com/us/corporate/events/dbim/index.html

We are going to come up with a lot of articles, whitepapers, demos and guides on new features of 12c along with in-memory option once it is released in July 2014.

– ORA Training