appsutil/bin/adcvm.sh[211]: AIX: 0403-012 A test command parameter is not valid.

Autoconfig fails with the below error on the dbtier

appsutil/bin/adcvm.sh[211]: AIX: 0403-012 A test command parameter is not valid.


Fix:

Backup your adcvm.sh. { appsutil/bin
Modify the file adcvm.sh as follows:

from:

if ((test "$pltform" = "Solaris") || (test "$pltform" = "Intel_Solaris"));

to:

if (test "$pltform" = "Solaris") || (test "$pltform" = "Intel_Solaris");

Save, and rerun the script.

To start Workflow components from back end.

SQL> select component_id,component_name, component_status FROM apps.fnd_svc_components WHERE component_type like '%WF%';

COMPONENT_ID COMPONENT_NAME                                                                   COMPONENT_STATUS

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

      10000 ECX Inbound Agent Listener                                                       STOPPED

      10001 ECX Transaction Agent Listener                                                   STOPPED

      10002 Workflow Deferred Agent Listener                                                 STOPPED

      10003 Workflow Deferred Notification Agent Listener                                    STOPPED

      10004 Workflow Error Agent Listener                                                    STOPPED

      10005 Workflow Inbound Notifications Agent Listener                                    STOPPED

      10006 Workflow Notification Mailer                                                     STOPPED

      10020 Workflow Java Deferred Agent Listener                                            STOPPED

      10021 Workflow Java Error Agent Listener                                               STOPPED

      10041 Workflow Inbound JMS Agent Listener                                              STOPPED

      10040 Web Services IN Agent                                                            STOPPED

      10042 Web Services OUT Agent                                                           STOPPED

      10043 WF_JMS_IN Listener(M4U)                                                          STOPPED

To start the WF components from back end:

SQL> declare

    retcode number(10);

    errbug varchar2(50);

    begin

    fnd_svc_component.start_component (10006,retcode,errbug);

    end;

    /

PL/SQL procedure successfully completed.

How to Open Ebiz 11i FORMS on Linux or Ubuntu or Mac

How to Open Ebiz 11i FORMS on Linux or Ubuntu or Mac


mkdir -p $HOME/.mozilla/plugins

shaiksameer@shaikslinux1:~/.mozilla/plugins$ ls -lrt
total 4
lrwxrwxrwx 1 shaiksameer XXXX 73 Nov 12 17:25 libnpjp2.so -> /usr/local/home/shaiksameer/stage/jre1.7.0_45/lib/i386/libnpjp2.so

if 64 bit then:
~/stage/jdk1.7.0_45/jre/lib/amd64/libnpjp2.so

How to change APPLSYSPUB password in EBS.

Change APPLSYSPUB password

Shutdown the apptier:

 

Backup and change PWD in the below files:

$CONTEXT_FILE

$FND_SECURE  → .dbc file

$IAS_CONFIG_HOME/Apache/Jserv/etc/formservlet.ini

appTier .env files ($APPL_TOP)

sqlplus / as sysadb

SQL> create table applsys.fnd_oracle_userid_02102016 as select * from applsys.fnd_oracle_userid;

Table created.

SQL> create table applsys.fnd_user_02102016 as select * from applsys.fnd_user;

Table created.

Change password:

FNDCPASS apps/xxxxxxxxxxxx 0 Y system/xxxxxxxxxxxx ORACLE APPLSYSPUB xxxxxxxxxxxx

Start the apptier:

EBS create adpatch defaults file

Lets create defaults file to make adpatch a little non-interactive:

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

Put addefaults.txt at a safe place and make sure it is not overwritten or deleted.

adpatch defaultsfile=/home/applmgr/SHAIK1/addefaults.env

When the adpatch asks for patch directory location then terminate the autopatch session using ctrl +c

Verify the addefaults.env is created 

To use the defaults file while applying the patches just pass the above file that we created ...

adpatch defaultsfile=/home/applmgr/SHAIK1/addefaults.env logfile=XXXXX.log patchtop=/u01/stage/patches/XXXXX driver=uabc.drv interactive=no

adpatch should automatically pick up APP_TOP, ORACLE_HOME, system password and apps password from defaults file.

EBS 11i: Fnd the ICM current logfile

--To find the ICM current logfile

SELECT 'LOG=' || cp.logfile_name LogFile
FROM fnd_concurrent_processes cp, fnd_concurrent_queues cq
WHERE cp.concurrent_queue_id = cq.concurrent_queue_id
AND cp.queue_application_id = cq.application_id
AND cq.manager_type = '0' AND cp.process_status_code = 'A';

Find the log file and output file from concurrent request

--to find the log file and output file from concurrent request

SELECT REQUEST_ID,logfile_name, outfile_name, outfile_node_name, last_update_date

FROM apps.FND_CONCURRENT_REQUESTS

WHERE REQUEST_ID =&Req_ID

EBS 11i Add resposibility api

Find the necessary details for a particular responsibility:

    

 SELECT fa.application_short_name,

                fr.responsibility_key,

                frg.security_group_key,                     

                frt.description

    FROM apps.fnd_responsibility fr,

                apps.fnd_application fa,

                apps.fnd_security_groups frg,

                apps.fnd_responsibility_tl frt

   WHERE fr.application_id = fa.application_id

     AND    fr.data_group_id = frg.security_group_id

     AND    fr.responsibility_id = frt.responsibility_id

     AND    frt.LANGUAGE = USERENV ('LANG')

     AND    frt.responsibility_name = 'RESP_NAME_HERE'

  fnd_user_pkg.addresp (username          => v_user_name,

                                             resp_app           => v_application_name,

                                             resp_key            => v_responsibility_key,

                                             security_group => v_security_group,

                                             description        => v_description,

                                             start_date          => SYSDATE,

                                             end_date            => NULL

                                            );

SQL> exec fnd_user_pkg.addresp('SHAIKS','XXSSHAIK','RESP_NAME_HERE,'STANDARD',null,sysdate,NULL);

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.

How to update EBS XML Publisher Temporary Directory

SQL> select value from apps.XDO_CONFIG_VALUES WHERE  property_code = 'SYSTEM_TEMP_DIR';

VALUE

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

/u1/appl/SHAIK1/wrongdir_tmp

SQL> update apps.XDO_CONFIG_VALUES set value='/u01/share/temp' WHERE  property_code = 'SYSTEM_TEMP_DIR';

1 row updated.

SQL> commit;

Commit complete.

SQL> select value from apps.XDO_CONFIG_VALUES WHERE  property_code = 'SYSTEM_TEMP_DIR';

VALUE

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

/u01/share/temp

Reference:-

How To Find the EBS XML Publisher Temporary Directory Via SQL? (Doc ID 1189723.1)

Oracle R12 Logs location

In Oracle Applications R12, the log files are located in $LOG_HOME ($INST_TOP/logs)

Concurrent Reqeust related logs

$LOG_HOME/appl/conc - > location for concurrent requests log and out files

$LOG_HOME/appl/admin - > location for mid tier startup scripts log files

Apache Logs (10.1.3 Oracle Home which is equivalent to iAS Oracle Home - Apache, OC4J and OPMN)

$LOG_HOME/ora/10.1.3/Apache - > Location for Apache Error and Access log files

$LOG_HOME/ora/10.1.3/j2ee - > location for j2ee related log files

$LOG_HOME/ora/10.1.3/opmn - > location for opmn related log files

Forms & Reports related logs (10.1.2 Oracle home)

$LOG_HOME/ora/10.1.2/forms

$LOG_HOME/ora/10.1.2/reports

Startup/Shutdown Log files location:

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

Patch log files location:

$APPL_TOP/admin/$SID/log/

Clone and AutoConfig log files location in Oracle E-Business Suite Release 12

Logs for the adpreclone.pl are located:

On the database tier:

RDBMS $ORACLE_HOME/appsutil/log/<context>/StageDBTier_< timestamp >.log

On the application tier:

$INST_TOP/admin/log/StageAppsTier_< timestamp >.log

Where the logs for the admkappsutil.pl are located?

On the application tier:

$INST_TOP/admin/log/MakeAppsUtil_< timestamp >.log

Oracle EBS 11i log file locations

Application Tier Logs

Start/Stop script log files location:

$COMMON_TOP/admin/log/CONTEXT_NAME/

OPMN log file location

$ORACLE_HOME/opmn/logs/ipm.log

Apache, Jserv, JVM log files locations:

$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log

$IAS_ORACLE_HOME/Apache/Apache/logs/ssl_request_log

$IAS_ORACLE_HOME/Apache/Apache/logs/access_log

$IAS_ORACLE_HOME/Apache/Apache/logs/error_log

$IAS_ORACLE_HOME/Apache/JServ/logs

Concurrent log file location:

$APPL_TOP/admin/PROD/log or $APPLLOG/$APPLCSF

Patch log file location:

$APPL_TOP/admin/PROD/log

Worker Log file location:

$APPL_TOP/admin/PROD/log

AutoConfig log files location:

Application Tier:

$APPL_TOP/admin/SID_Hostname/log//DDMMTime/adconfig.log

Database Tier:

$ORACLE_HOME/appsutil/log/SID_Hostname/DDMMTime/adconfig.log

Error log file location:

Application Tier:

$APPL_TOP/admin/PROD/log

Database Tier :

$ORACLE_HOME/appsutil/log/SID_Hostname

ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486 with ORA-15124: ASM file name contains an invalid alias name

If you use any of the below syntax you will get the below mentioned error, instead try the suggested fix.



Using dot here "."

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 .

or

Using just path here "+DATA/prod1/daatfile"

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/'

or

 Using just first two letters of the file name with no quotes here "+DATA2/prod1/datafile/tt"

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 +DATA2/prod1/datafile/tt*

or

Using just first two letters of the file name with quotes here "+DATA2/prod1/datafile/tt"

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt*'

or

Using complete file name with quotes here "+DATA2/prod1/datafile/tt_temp_sales.319.887131035'

 

cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales.319.887131035'

copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt*

ASMCMD-8016: copy source '/home/oracle/sshaik/tt_temp_sales.319.887131035' and target '+DATA2/prod1/datafile/tt*' failed

ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name

ORA-15124: ASM file name '+DATA2/prod1/datafile/tt*' contains an invalid alias name

ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486

ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

Workaround:

==========

ASMCMD> cp /home/oracle/sshaik/tt_temp_sales.319.887131035 '+DATA2/prod1/datafile/tt_temp_sales'

copying /home/oracle/sshaik/tt_temp_sales.319.887131035 -> +DATA2/prod1/datafile/tt_temp_sales

Since ASM will automatically append file/incarnation pair to ensure uniqueness, you will have give the name except the incarnation number….