Tuesday, May 10, 2022

adbld.xml fails during upgrade step : Generate a new database context file as follows:

oraupg@TESTDB:/data/tech_st/19c/appsutil/bin$ perl adbldxml.pl Starting context file generation for db tier.. Using JVM from /data/tech_st/19c/appsutil/jre/bin/java to execute java programs.. APPS Password: The log file for this adbldxml session is located at: /data/tech_st/19c/appsutil/log/adbldxml_05101159.log Could not Connect to the Database : ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Additional information: 2852 Additional information: 1180227351 Connecting to the CRPPP database instance... Connection parameters values: Database server hostname ==> TESTDB.DOMAIN.COM Database listener port ==> 1571 Database SID ==> CRPPP Database schema name ==> apps Could not Connect to the Database : ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Additional information: 2852 Additional information: 1180227351 AC-40000: Error: Exception - java.sql.SQLRecoverableException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Additional information: 2852 Additional information: 1180227351 occurred while connecting to the database - CRPPP Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hostname of Database server[TESTDB.DOMAIN.COM]: Enter Port of Database server[1571]: Enter SID of Database server[CRPPP]: Could not Connect to the Database : ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory Additional information: 2852 Additional information: 1180227351 Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hostname of Database server[TESTDB.DOMAIN.COM]:^C^C Solution : Add parameter USE_SID_AS_SERVICE_LISTENER=ON in the listner.ora and repalce LISTENER with your listner name, relaod the listner and retry adbldxml.pl

Sunday, March 15, 2020

oracle.sysman.oip.oipc.oipcr.OipcrExecuteRuleException: Unable to execute rule 'CertifiedVersions' from ruleset 'OSChecks'.

ERROR: Failed to configure the target system,
please check the logfile in : /u01/DEV/fs1/inst/apps/hostname/admin/log/clone
Enter the APPS password : Enter the APPS password : Error while executing /u01/DEV/fs1/EBSapps/comn/clone/bin/alter_ebs_logon_trigger.sql
Failed to enable EBS_LOGON trigger

Logifle :

contextFile:/u01/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/prereq/oui/agent_prereq_context.xml
OiiolLogger.addFileHandler:Error while adding file handler - /u01/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log/prereq2020-03-15_07-16-48-AM.log
java.io.FileNotFoundException: /u01/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log/prereq2020-03-15_07-16-48-AM.log (Not a directory)
The entry point is: oracle.installType.all
Check Name:CertifiedVersions
Check Description:This is a prerequisite condition to test whether the Oracle software is certified on the current O/S or not.
/etc/inittab does not seem to contain default runlevel information.
oracle.sysman.oip.oipc.oipcr.OipcrExecuteRuleException: Unable to execute rule 'CertifiedVersions' from ruleset 'OSChecks'. The underlying test 'oracle.sysman.oip.oipc.oipcz.OipczOSChecks.checkCertifiedOSVersions' has thrown an unhandled exception [null]. If the exception results in a failure of the test and the exception needs to be propagated, then encapsulate the exception in the result object and return the result.
        at oracle.sysman.oip.oipc.oipcr.OipcrRulesEngine.executeRule(OipcrRulesEngine.java:375)
        at oracle.sysman.oip.oipc.oipcp.OipcpPrereqChecker.executeCheck(OipcpPrereqChecker.java:581)
        at oracle.sysman.oip.oipc.oipcp.OipcpPrereqChecker.runChecks(OipcpPrereqChecker.java:536)
        at oracle.sysman.oip.oipc.oipcp.OipcpPrereqChecker.executePrereqs(OipcpPrereqChecker.java:437)
        at oracle.as.install.engine.modules.prereq.action.PrereqLauncher.executePrereqs(PrereqLauncher.java:254)
        at oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck.executeFMWSysPrereqs(FMWOracleHomePreReqCheck.java:140)
        at oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck.main(FMWOracleHomePreReqCheck.java:343)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at oracle.sysman.oip.oipc.oipcr.OipcrRulesEngine.executeRule(OipcrRulesEngine.java:325)
        ... 6 more
Caused by: java.lang.NullPointerException
        at oracle.sysman.oip.oipc.oipch.OipchSolarisKernelReader.readSysdefKernelInfo(OipchSolarisKernelReader.java:360)
        at oracle.sysman.oip.oipc.oipch.OipchSolarisOSCreator.updateKernelInfo4(OipchSolarisOSCreator.java:357)
        at oracle.sysman.oip.oipc.oipch.OipchSolarisOSCreator.createOS(OipchSolarisOSCreator.java:159)
        at oracle.sysman.oip.oipc.oipch.OipchOSCreator.getOS(OipchOSCreator.java:114)
        at oracle.sysman.oip.oipc.oipch.OipchHostCreator.getOS(OipchHostCreator.java:84)
        at oracle.sysman.oip.oipc.oipch.OipchHostCreator.build(OipchHostCreator.java:57)
        at oracle.sysman.oip.oipc.oipck.OipckKnowledgeSourceFactory.getKnowledgeSourceImpl(OipckKnowledgeSourceFactory.java:239)
        at oracle.sysman.oip.oipc.oipck.OipckKnowledgeSourceFactory.getKnowledgeSource(OipckKnowledgeSourceFactory.java:60)
        at oracle.sysman.oip.oipc.oipck.OipckKnowledgeSourceLibrary.loadKnowledgeSource(OipckKnowledgeSourceLibrary.java:160)
        at oracle.sysman.oip.oipc.oipck.OipckKnowledgeSourceLibrary.getKnowledgeSource(OipckKnowledgeSourceLibrary.java:79)
        at oracle.sysman.oip.oipc.oipcr.OipcrRulesEngine.getKnowledgeSource(OipcrRulesEngine.java:611)
        at oracle.sysman.oip.oipc.oipcz.OipczOSChecks.checkCertifiedOSVersions(OipczOSChecks.java:74)
        ... 11 more
Check complete. The overall result of this check is: Not executed <<<<
Solution : Move this file to a new name '/usr/tmp/sysdef.txt' file
mv  /usr/tmp/sysdef.txt /usr/tmp/sysdef.txt.bkp

Monday, October 31, 2016

FRM-40733 PL/SQL SET_GROUP_CHAR_CELL , FRM-41084

This week was installing Arabic NLS on 12.2.4 and after the regular steps i faced a strange issue while opening arabic forms they error out in FRM-40733 and FRM-41084 and this happens across the board.




This issue can be solved by applying the below patches, apply them both in base language and arabic.

24839804
20135590

Hope this helps.
Thank you.

Tuesday, October 25, 2016

R12 ADOP patch session failing for form / report compilation

Error :
***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

While looking at the log file i could see lot of forms that were not compiled, to avoid this situation use restart=yes flags=autoskip in adop
==========================================================
Patch session with error:

appltest@tstsrv:/u25/TEST/fs_ne/EBSapps/patch$ adop phase=apply patches=24944395_AR:u24944395.drv restart=yes prompt=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u25/TEST/fs2/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
    Patch edition context: /u25/TEST/fs1/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
Reading driver file (up to 50000000 bytes).
    Patch file system free space: 120.47 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node tstsrv:
                  19791273
                  20588502
                  20825533
                  20936905
                  21091431
                  21153266
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
    Continuing with existing session [Session ID: 28].
        Session Id            :   28
        Prepare phase status  :   COMPLETED
        Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED
        Cutover  phase status :   NOT COMPLETED
        Abort phase status    :   NOT COMPLETED
        Session status        :   FAILED

===========================================================================
ADOP (C.Delta.7)
Session ID: 28
Node: tstsrv
Phase: apply
Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/adop_20161025_081029.log
===========================================================================

Applying patch 24944395_AR:u24944395.drv.
    Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100413/TEST_tstsrv/24944395_AR/log/u24944395.log

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

The patch has FAILED,
Please check the adpatch logs for more details.

You should check the file
/u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100413/TEST_tstsrv/24944395_AR/log/u24944395.log

for errors.

    [UNEXPECTED]Error occurred executing "adpatch  abandon=no restart=yes workers=24      console=no interactive=no  defaultsfile=/u25/TEST/fs1/EBSapps/appl/admin/TEST_patch/adalldefaults.txt patchtop=/u25/TEST/fs_ne/EBSapps/patch/24944395_AR driver=u24944395.drv logfile=u24944395.log"
    [UNEXPECTED]Refer to the log files for more information.
    [UNEXPECTED]Apply phase has failed.


[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)

===================================================================
Patch session post autoskip without erorrs :

applTEST@tstsrv:/u25/TEST/fs_ne/EBSapps/patch$ adop phase=apply patches=24944395_AR:u24944395.drv restart=yes flags=autoskip

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u25/TEST/fs2/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
    Patch edition context: /u25/TEST/fs1/inst/apps/TEST_tstsrv/appl/admin/TEST_tstsrv.xml
Reading driver file (up to 50000000 bytes).
    Patch file system free space: 120.47 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   ETCC: The following required database fixes have not been applied to node tstsrv:
                  19791273
                  20588502
                  20825533
                  20936905
                  21091431
                  21153266
                Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
    Continuing with existing session [Session ID: 28].
        Session Id            :   28
        Prepare phase status  :   COMPLETED
        Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED
        Cutover  phase status :   NOT COMPLETED
        Abort phase status    :   NOT COMPLETED
        Session status        :   FAILED

===========================================================================
ADOP (C.Delta.7)
Session ID: 28
Node: tstsrv
Phase: apply
Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/adop_20161025_081029.log
===========================================================================

Applying patch 24944395_AR:u24944395.drv.
    Log: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log/u24944395.log
    [WARNING]   Some patching actions failed and were skipped
    [WARNING]   Refer to the autoskip logfile for the list of skipped jobs
    [WARNING]   Logfile: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log/autoskip.log

Generating post apply reports.

Generating log report.
    Output: /u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/adzdshowlog.out

The apply phase completed successfully.


adop exiting with status = 0 (Success)

In addition to the above autoskip option creates a new logfile called asautoskip.log unfortunately it didnt catch any info on the missed file I had to go back to the log and lgi file to trace out the missing files.


applTEST@tstsrv:/u25/TEST/fs_ne/EBSapps/log/adop/28/apply_20161025_100857/TEST_tstsrv/24944395_AR/log$ cat autoskip.log

************* Start of AutoPatch session *************

AutoPatch started at: Tue Oct 25 2016 10:10:01


Autoskipped at Tue Oct 25 2016 10:11:24
[Session : 186984, Error while generating Oracle Forms files]



Autoskipped at Tue Oct 25 2016 10:15:16
[Session : 186984, Error while generating Oracle Reports files]


Wednesday, September 7, 2016

R12.2 why is my apps tier growing?

Recent observation that RUN file system is growing rapidly, on quick analysis its been found that logs in OHS,forms server and reports cache is not being cleaned and has to be done manually.

Below are the location for the above mentioned points.
Schedule a cronjob to delete old access and error log files from the first 2 location and the last location can be purged as and when required.



  1. /apps/PROD/fs2/FMW_Home/webtier/instances/EBS_web_PROD_OHS1/diagnostics/logs/OHS/EBS_web_PROD
  2. /apps/PROD/fs2/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/forms_server1/logs
  3. /apps/PROD/fs2/inst/apps/PROD_prdsrv/logs/ora/10.1.2/reports/cache


Thank you.

Tuesday, September 6, 2016

Configuring ILOM in Enterprise Manager 13c

How to configure ILOM in EM13c?

Please follow the steps below.
1) From the setup go to add traget --> add targets manually.


2) click on Add using guided process.

3) Select systems infrastructure server ILOM.


4) Give a desired target name, enter the ip address of the ILOM
    In monitoring agent URL select the agent that was installed for EM server.
    Enter credentails for the ILOM and click on test connection once the connetion is successful click       on add.


5) Go to target and look for the platform section and there you should see the configured ILOM. 

Thank you.

Uninstalling 12c EM agent

Go to the agent home directory and perform the below steps:

make sure oraInst.loc is pointing to the correct inventory.

/u27/AGENT/core/12.1.0.5.0/perl/bin$ /u27/AGENT/core/12.1.0.5.0/perl/bin/perl /u27/AGENT/core/12.1.0.5.0/sysman/install/AgentDeinstall.pl -agentHome /u27/AGENT/core/12.1.0.5.0


agent@tstsrv:/u27/AGENT/core/12.1.0.5.0/perl/bin$ /u27/AGENT/core/12.1.0.5.0/perl/bin/perl /u27/AGENT/core/12.1.0.5.0/sysman/install/AgentDeinstall.pl -agentHome /u27/AGENT/core/12.1.0.5.0


 Agent Oracle Home: /u27/AGENT/core/12.1.0.5.0

agentHome = /u27/AGENT/core/12.1.0.5.0

NOTE: The agent base directory: /u27/AGENT will be removed after successful deinstallation of agent home.


 DetachHome Command executed:/u27/AGENT/core/12.1.0.5.0/oui/bin/runInstaller -detachHome -force -depHomesOnly -silent ORACLE_HOME=/u27/AGENT/core/12.1.0.5.0 -waitForCompletion -invPtrLoc /u27/AGENT/core/12.1.0.5.0/oraInst.loc
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
The inventory pointer is located at /u27/AGENT/core/12.1.0.5.0/oraInst.loc
'DetachHome' was successful.
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
The inventory pointer is located at /u27/AGENT/core/12.1.0.5.0/oraInst.loc
The Oracle home '/u27/AGENT/sbin' could not be updated as it does not exist.


Deinstall Command executed:/u27/AGENT/core/12.1.0.5.0/oui/bin/runInstaller -deinstall -silent "REMOVE_HOMES={/u27/AGENT/core/12.1.0.5.0}" -waitForCompletion -removeAllFiles -invPtrLoc /u27/AGENT/core/12.1.0.5.0/oraInst.loc
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
Oracle Universal Installer, Version 11.1.0.13.0 Production
Copyright (C) 1999, 2015, Oracle. All rights reserved.

Starting deinstall


Deinstall in progress (Monday, September 5, 2016 2:13:30 PM AST)
Configuration assistant "Agent Deinstall Assistant" succeeded
............................................................... 100% Done.

Deinstall successful

End of install phases.(Monday, September 5, 2016 2:13:56 PM AST)
End of deinstallations
Please check '/u27/ORACLE/oraInventory/logs/silentInstall2016-09-05_02-13-26PM.log' for more details.
Can't locate Carp.pm in @INC (@INC contains: /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl .) at /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/File/Path.pm line 32.
agent@tstsrv:/u27/AGENT/core/12.1.0.5.0/perl/bin$