adstrtal.sh failing with Exception in thread "main" java.lang.NullPointerException

You are running adstrtal.sh version 120.24.12020000.11
Enter the WebLogic Server password:
The logfile for this session is located at /u01/applmgr/fs1/inst/apps/vis1_server1/logs/appl/admin/log/adstrtal.log
Exception in thread "main" java.lang.NullPointerException
        at oracle.apps.ad.autoconfig.ServiceControl$ServiceGroup.administerServiceGroup(ServiceControl.java:2616)
        at oracle.apps.ad.autoconfig.ServiceControl$ServiceGroup.access$000(ServiceControl.java:2264)
        at oracle.apps.ad.autoconfig.ServiceControl.<init>(ServiceControl.java:686)
        at oracle.apps.ad.autoconfig.ServiceControl.main(ServiceControl.java:2161)
adstrtal.sh: Exiting with status 1


** Fixing s_oaeaname, s_oaea_managed_servers with value oaea_server1 and run autoconfig fixes the issue


Before change:
            <oa_service_name oa_var="s_oaeaname" type="managed_server"/>
            <oa_service_status oa_var="s_oaeastatus">enabled</oa_service_status>
            <oa_managed_server_name oa_var="s_oaea_managed_servers"/>


After change:
            <oa_service_name oa_var="s_oaeaname" type="managed_server">oaea_server1</oa_service_name>
            <oa_service_status oa_var="s_oaeastatus">enabled</oa_service_status>
            <oa_managed_server_name oa_var="s_oaea_managed_servers">oaea_server1</oa_managed_server_name>

Workflow Notification mailer failing with Unable to make a connection with the user and responsibility

Status Information
This automatic Service Component has been restarted the maximum of 10 times after stopping with error. Thus, it has been system deactivated -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {FRAMEWORK_USER=Unable to make a connection with the user and responsibility}.

SQL> select user_id,user_name from apps.fnd_user where user_name='SYSADMIN';
USER_ID USER_NAME

---------- -------------

  12345678 SYSADMIN


Someone have updated user_id of SYSADMIN to different value instead of 0. This is not allowed.


SQL> update apps.fnd_user set user_id=0 where user_name='SYSADMIN' and user_id='12345678';

1 row updated.

SQL> commit;

Commit complete.


SQL> select user_id,user_name from fnd_user_bkp where user_id=0;
USER_ID USER_NAME

---------- -------------

         0 SYSADMIN


Restart Workflow Notification mailer.

Do you know how to create a database link without full TNS connect string starting 11g ?

SQL> CREATE DATABASE LINK test
  2  CONNECT TO remoteschema IDENTIFIED BY password
  3  USING 'remoteserver:port/VIS1';
  
Database link created.

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

Useful Apache logging:

12.2 E-Business Suite - How To Enable FND: Debug / AF Logging When Login Is Not Possible (Doc ID 1563168.1)
12.2 Ebusiness Suite - Collecting Fusion Middleware Log Files (Doc ID 1362900.1)
Oracle Applications E-Business Suite 12.2 Fusion Middleware Log Files: Locate,View, and Control (Doc ID 1366187.1)
Troubleshooting the Self Service Framework with Oracle Applications (Doc ID 231137.1)
How to Gather HTTP Header Information From a Client PC (Doc ID 815734.1)

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

How to check locks on a particular table/object

set lines 400
col Object format a40
col Locker format a6
col Type format a9
SELECT
SESSION_ID "SID",
serial#,
c.status,
c.audsid "ora_sess_id",
OWNER||'.'||OBJECT_NAME "Object",
  ORACLE_USERNAME "Locker",
-- mysessf(lockwait) "Wait",
-- lockwait "Wait",
  DECODE(LOCKED_MODE,
    2, 'ROW SHARE',
    3, 'ROW EXCLUSIVE',
    4, 'SHARE',
    5, 'SHARE ROW EXCLUSIVE',
    6, 'EXCLUSIVE',  'UNKNOWN') "Lockmode",
  OBJECT_TYPE "Type",
  c.ROW_WAIT_ROW#,
  c.inst_id
-- PROGRAM "Program"
FROM
  SYS.gV_$LOCKED_OBJECT A,
  SYS.ALL_OBJECTS B,
  SYS.gV_$SESSION c
WHERE
  A.OBJECT_ID = B.OBJECT_ID AND
  C.SID = A.SESSION_ID
  and object_name in ('&object_name')
ORDER BY 1 ASC, 5 Desc
/

Provide table_name or object_name in question to check the locks on it. 

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

How to check progress of a long running job

For example:
Let say you are trying to rebuild a table ML_SYSTEM_ITEMS_B with move command

alter table INV.ML_SYSTEM_ITEMS_B move;

This session keep on running and you want to check the status.

select target, opname, totalwork, sofar,units, (sofar/totalwork)*100 PERCENTAGE,elapsed_seconds from v$session_longops where target like '%MTL%SYSTEM%' and totalwork <> sofar;

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

Comprehensive list of frequently-asked questions and answers about the Online Patching capability introduced with Oracle E-Business Suite Release 12.2.

Oracle E-Business Suite Release 12.2: Online Patching FAQ (Doc ID 1583902.1)

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

Here is the one place where you can get all 12.2 latest documentation.

Useful 12.2 Documents (Doc ID 1585889.1)

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

How to connect to database using jdbc connect string directly

$ sqlplus apps/apps@VISdbnode1:1521/VIS1

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Feb 22 22:22:08 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> 

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

In 12.2, adautocfg.sh fails with ORA-20001: Node name visnode1 not found in adop repository tables

Script Name    : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.2
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/erp/applmgr/fs1/inst/apps/vis1_visnode1/admin/install/txkGenADOPWrapper.pl)
TIME    : Mon Jan 11 09:11:15 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 11 09:11:15 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> Connected.    visnode1
SQL> SELECT ad_zd_adop.get_node_type('visnode1') FROM DUAL
       *
ERROR at line 1:
ORA-20001: Node name visnode1 not found in adop repository tables
ORA-06512: at "APPS.AD_ZD_ADOP", line 3055

Background:

As part of application tier configuration, ADOP tables got cleaned with fnd_conc_clone.setup_clean procedure.
exec FND_CONC_CLONE.SETUP_CLEAN;

Following query will result 0 records or no entries of the node 'visnode1'
select * from APPLSYS.ADOP_VALID_NODES;

Solution:

Add entry into APPLSYS.ADOP_VALID_NODES table manually and retry autoconfig.
Get value of DEFAULT_EDITION from DATABASE_PROPERTIES table which is needed to add entry manually in ADOP_VALID_NODES table.

select property_value from database_properties where property_name = 'DEFAULT_EDITION';
Result was - ORA$BASE.  This may change based on your patching cycles. Take whatever value returned by this query.

insert into APPLSYS.ADOP_VALID_NODES values('visnode1','vis1_visnode1','ORA$BASE');
commit;

Rerun autoconfig.


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