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'