The value of s_jdbc_connect_descriptor is NULL. while adop phase=prepare or fs_clone

Getting below error while adop phase=prepare or adop phase=fs_clone

==============================
Validating configuration on node: [hostname].
    Log: /apps/TEST/fs_ne/EBSapps/log/adop/10/fs_clone_20170810_121726/TEST_app1
        [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.
        [ERROR]: The value of s_jdbc_connect_descriptor is NULL.
    [UNEXPECTED]Error occurred running "perl /apps/TEST/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/apps/TEST/fs2/inst/apps/TEST_app1/appl/admin/TEST_app1.xml -patchctxfile=/apps/TEST/fs1/inst/apps/TEST_app1/appl/admin/TEST_app1.xml -phase=fs_clone -logloc=/apps/TEST/fs_ne/EBSapps/log/adop/10/fs_clone_20170810_121726/TEST_app1 -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on app1


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)

===============================

Parameter value of context file of patch should be same as run file system.

<jdbc_url oa_var="s_apps_jdbc_connect_descriptor">

and then try again.

Change weblogic password of EBS 12.2.5

Login to weblogic.

Click on Domain->security-advanced
Change Nodemanager password
Save it and Release Configuration

Goto Security Realms->myrealm->users and groups->weblogic->password
Give new password and confirm new password
Save it and Release Configuration


Login to Application server

goto $FMW_HOME/user_projects/domains/EBS_domain_SID/
find . -name 'boot.properties'
backup all the files.

vi one by one file and change the password value.
remove encrypted password and enter weblogic new password.

stopall service and startall services.

All services must start with 0 status.

Now weblogic password changed.

Enjoy :)

start and stop oracle secure backup (osb)

Start Oracle Secure Backup service :
/etc/init.d/observiced start

Stop Oracle Secure Backup service :
/etc/init.d/observiced stop

Unable to find 'kshell' in path while adcfgclone.sh dbTechStack

Problem : 

getting error while adcfgclone.sh dbTechStack

Checking for make...    found - /usr/bin/make
 Checking for ld...     found - /usr/bin/ld
 Checking for cc...     found - /usr/bin/cc
 Checking for ar...     found - /usr/bin/ar
 Checking for ksh...
 Unable to find 'kshell' in path
 Unable to locate all utilities with system path.
 PATH = /usr/ccs/bin:/usr/ccs/bin:/testdb/oracle/TEST/10.2.0/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/gnome/bin


WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above


Solution : 

vi /testdb/oracle/TEST/10.2.0/appsutil/clone/bin/adchkutl.sh

comment the below script.

# Verify for ksh if its a linux only platform
#

#if test $UNAME = "Linux"; then
#  printf "Checking for ksh...\t";
#  VERSN=`/bin/ksh -c 'echo $KSH_VERSION' | grep "PD KSH";`;
#  EC=$?
#  if test $EC != "0" ; then
#     printf "\nUnable to find 'kshell' in path\n";
#     SHOW_PATH=1
#  else
#     printf "found - $VERSN\n";
#  fi
#fi

Then retest.

find out row level block in oracle

Run the below query by apps :

select vs.audsid audsid,
 locks.sid sid,
 vs.serial# serial#,
 vs.username oracle_user,
 vs.osuser os_user,
 vs.program program,
 vs.module module,
 vs.action action,
 vs.process process,
 decode(locks.lmode,
       1, NULL,
       2, 'Row Share',
       3, 'Row Exclusive',
       4, 'Share',
       5, 'Share Row Exclusive',
       6, 'Exclusive', 'None') lock_mode_held,
 decode(locks.request,
       1, NULL,
       2, 'Row Share',
       3, 'Row Exclusive',
       4, 'Share',
       5, 'Share Row Exclusive',
       6, 'Exclusive', 'None') lock_mode_requested,
 decode(locks.type,
       'MR', 'Media Recovery',
       'RT', 'Redo Thread',
       'UN', 'User Name',
       'TX', 'Transaction',
       'TM', 'DML',
       'UL', 'PL/SQL User Lock',
       'DX', 'Distributed Xaction',
       'CF', 'Control File',
       'IS', 'Instance State',
       'FS', 'File Set',
       'IR', 'Instance Recovery',
       'ST', 'Disk Space Transaction',
       'TS', 'Temp Segment',
       'IV', 'Library Cache Invalidation',
       'LS', 'Log Start or Log Switch',
       'RW', 'Row Wait',
       'SQ', 'Sequence Number',
       'TE', 'Extend Table',
       'TT', 'Temp Table',
       locks.type) lock_type,
 objs.owner object_owner,
 objs.object_name object_name,
 objs.object_type object_type,
 round( locks.ctime/60, 2 ) lock_time_in_minutes
from v$session vs,
         v$lock locks,
         dba_objects objs,
         dba_tables tbls
where locks.id1 = objs.object_id
 and vs.sid = locks.sid
 and objs.owner = tbls.owner
 and objs.object_name =  tbls.table_name
 and objs.owner != 'SYS'
 and locks.type = 'TM'
 order by lock_time_in_minutes;



Kill :

alter system kill session 'SID,SERIAL#';

Formula to find out difference between two columns in MS Excel

Formula to find out difference between two columns in MS Excel.

=IF(COUNTIF($B:$B,A1)=0,"No Match in B", " ")

It will identify value which is available in column A but not in column B.

How to start ASM high availability service ?

How to start ASM high availability service ?


$.../12.1.0/bin> crsctl stat res -t
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Status failed, or completed with errors.
$.../12.1.0/bin> crsctl start resource -all
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Start failed, or completed with errors.

Solution :

$.../12.1.0/bin> crsctl start has
CRS-4123: Oracle High Availability Services has been started.

rpm list for install oracle ebs 12.2.5 on suse linux 11-64 bit

Command to list out rpms for install oracle ebs 12.2.5 on suse linux 11 64 bit.

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' \
binutils \
glibc \
ksh \
libaio \
libstdc++33 \
libstdc++43 \
libstdc++-devel \
make \
libaio-devel \
sysstat \
glibc-devel \
gcc \
gcc-c++

Unable to find 'kshell' in path.....Unable to locate all utilities with system path.

If you got below error just set KSH_VERSION as below and try again.

PROBLEM :

$perl adcfgclone.pl dbTechStack
Enter the APPS password [APPS]:
welcome123
Checking for make...    found - /usr/bin/make
 Checking for ld...     found - /usr/bin/ld
 Checking for cc...     found - /opt/gcc295/bin/cc
 Checking for ar...     found - /usr/bin/ar
 Checking for ksh...
 Unable to find 'kshell' in path
 Unable to locate all utilities with system path.
 PATH = /opt/gcc295/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/oracle/product/10.2/db_1/bin:/usr/lib/qt3/bin


WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above


SOLUTION :


$export KSH_VERSION='@(#)PD KSH v5.2.14 99/07/13.2'

Oracle History and ERP Versions their Release Dates

Oracle History and ERP Versions their Release Dates

Ellison co-founded Oracle Corporation in 1977 with Bob Miner and Ed Oates under the name Software Development Laboratories (SDL). In 1979 SDL changed its name to Relational Software, Inc. (RSI). In 1982, RSI renamed itself Oracle Systems Corporation to align itself more closely with its flagship product Oracle Database. At this stage Bob Miner served as the company's senior programmer. In 1995, Oracle Systems Corporation changed its name to Oracle Corporation. On March 12, 1986: Oracle gone public with revenues of $55 million USD.

ü  Oracle E-Business Suite started life as Oracle Financials in 1987. 

ü  August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software. Oracle Corporation acquires TCI for its project management software.

ü  October 1987: Oracle Applications Release 1

ü  Sometime in August 1988 they released their first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reason of having General ledger application_id is 101.

ü  November 1988: Release 3

ü  January 1989: Release 4

ü  May 1989: Release 5

ü  October 1989: Release 6

ü  May 1990: Release 7

ü  November 1990: Release 8

ü  June 1992: Release 9

ü  1995: Release 10

ü  Release 10 Sub versions are 10.7NCA, 10.7.16.1, 10.7

ü  April 1998: Release 11

ü  Release 11 sub versions are 11.0, 11.0.1, 11.0.2, 11.0.3, 11.0.28

ü  July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation.

ü  May 2000: Release 11i

ü  11i Sub Versions are 11.5, 11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.0, 11.5.10.1, 11.5.10.2.

ü  Feb 2006: 11.5.10.2

ü  31 Jan 2007: R12

ü  R12 Sub Versions are 12.0.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.0.7, 12.1, 12.1.1, 12.1.2, 12.1.3 and upcoming version is 12.2.

DATABASE VERSION LIST

• Oracle v5
• Oracle v6
• Oracle7: 7.0.16–7.3.4
• Oracle8 Database: 8.0.3–8.0.6
• Oracle8i Database Release 1: 8.1.5.0–8.1.5.1
• Oracle8i Database Release 2: 8.1.6.0–8.1.6.3
• Oracle8i Database Release 3: 8.1.7.0–8.1.7.4
• Oracle9i Database Release 1: 9.0.1.0–9.0.1.5 (patchset as of December 2003)
• Oracle9i Database Release 2: 9.2.0.1–9.2.0.8 (patchset as of April 2007)
• Oracle Database 10g Release 1: 10.1.0.2–10.1.0.5 (patchset as of February 2006)
• Oracle Database 10g Release 2: 10.2.0.1–10.2.0.5 (patchset as of April 2010)
• Oracle Database 11g Release 1: 11.1.0.6–11.1.0.7 (patchset as of September 2008)
• Oracle Database 11g Release 2: 11.2.0.1–11.2.0.3 (patchset as of September 2011)
• Oracle Database 12c Release 1: 12.1 (patchset as of June 2013)

MAJOR DIFFERENCE BETWEEN 11I AND R12

MAJOR DIFFERENCE BETWEEN 11I AND R12

11i	R12
Database version is 9i Rel-2	Database version in is 10g (10.2.0.2)
Tech stack in Application Tier consist of iAS & Developer 6i(Forms & Reports 8.0.6)	It is build on Fusion Middleware (10g web server and 10g Forms & Reports)
HTTP Server or Web server version 1.0.2.2.2 which is built in Apache Version 1.3.19	HTTP Server or Web server version 10.1.3 which is built in Apache Version 1.3.34
mod_Jserv	Mod_oc4j
Forms/Reports version is 6i	Forms/Reports version is 10.1.2.0.2 (10g)
In personalization level set_lov_property is not available	We can change the LOV
JDBC version is 9	JDBC version is 10.2.0
JDK/JRE version 1.3.1 or 1.4.2. Jinitiator at client side	JDK/JRE version 1.5.0. SUN JRE at client side
APPL_TOP path : $HOME/<SID>appl	$HOME/apps/apps_st/appl
COMMON_TOP path : $HOME/<SID>comn	$HOME/apps/apps_st/comn
ORACLE_HOME path : $HOME/<SID>ora/8.0.6	$HOME/apps/apps_st/10.1.2