Showing posts with label 11g. Show all posts
Showing posts with label 11g. Show all posts

Saturday, March 1, 2014

TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA for 11g

PROBLEM:

i have problem (below) when run adstrtal.sh after  Perl adcfgclone.pl appsTier.

TNS-01101: Could not find service name libociei.so

TNS-01101: Could not find service name libociei.so
03/01/14-22:17:48 :: adalnctl.sh: Starting listener process APPS_SID.

LSNRCTL for Solaris: Version 10.1.0.5.0 - Production on 01-MAR-2014 22:17:48

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting $ORACLE_HOME/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.5.0 - Production
Log messages written to $ORACLE_HOME/network/log/apps_mesakl04.log
TNS-01151: Missing listener name, APPS_database-SID, in LISTENER.ORA

Listener failed to start. See the error message(s) above...


SOLUTION:

cd  $INST_TOP/ora/10.1.2/network/admin/

if listener.ora is not found under path

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh


it will solve.
go to $INST_TOP/ora/10.1.2/network/admin/ for test.

Could not find all the required OS utilities in the $PATH' Error for solaris when run perl adcfgclone.pl appsTier for R12

PROBLEM:

cd $COMMON_TOP/clone/bin  and  run perl adcfgclone.pl appsTier :

bash-3.2$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Checking for make...
 Unable to locate 'make' utility in path
 Checking for ld...
 Unable to locate 'ld' utility in path
 Checking for ar...
 Unable to locate 'ar' utility in path
 Unable to locate all utilities with system path.
 PATH = $COMMON_TOP/clone/bin/../jre/bin:/bin:/usr/bin:/usr/bin:/bin:/opt/openv/pdde/pdopensource/bin:/usr/X11/bin:/usr/openwin/bin


WARNING:  could not find all the required os utilities in the $path. please review the checks above                                                                                        w the checks above


SOLUTION:

To implement the solution, please execute the following steps:

1. Locate the missing utilities. On most releases of unix, they are in /usr/ccs/bin
2. Include a reference to the utilities path in the $PATH environment variable for the applmgr user used to manage the instance. Remember to export the PATH for changes to take effect.
3. Rerun the command 'perl adcfgclone.pl appsTier'

ref:   adcfgclone.pl is Unable to Locate All Utilities in the System Path - 'Could not find all the required OS utilities in the $PATH' Error (Doc ID 397742.1)

Friday, February 28, 2014

ERROR: OPatch failed during prerequisite check. Interim Patch yyyyyyy is holding the lock from this patch xxxxxxx for R12

PROBLEM:
i have problem when try to apply patch:9044638

ERROR:
bash-4.2$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home : /appdata/data_appl/apps/tech_st/10.1.2
Oracle Home Inventory : /appdata/data_appl/apps/tech_st/10.1.2/inventory
Central Inventory : /appdata/cloneap2/inst/apps/burklon_testburlaapp/admin/oraInventory
from : /etc/oraInst.loc
OUI location : /appdata/data_appl/apps/tech_st/10.1.2/oui
OUI shared library : /appdata/data_appl/apps/tech_st/10.1.2/oui/lib/ibm_aix/liboraInstaller.so
Java location : /appdata/data_appl/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location : /appdata/data_appl/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Problems with the lock file
Lock file exists, details are:
Interim Patch 9593176 is holding the lock from this patch 9044638,
probably due to previous unsuccessful operation

ERROR: OPatch failed during prerequisite check.

SOLUTION:

1.remove patch_locked file.
mv $ORACLE_HOME\.patch_storage\patch_locked $ORACLE_HOME\.patch_storage\patch_locked_backup
2. apply patch again.