How to update Application XML using Oracle Application Manager

How to update Application XML using Oracle Application Manager

Go to below navigation:

Step 1 :Log on to the Oracle Application Manager (OAM) & click  “Dashboard”

Step 3: Click  “Site Map”.

Step 2: Click AutoConfig from the list of System Configuration features in the Administration tab.

Step 3: Locate the Context XML there

Step 4: Edit Paremeters

Step 5: Search for “ALL”

Step 6: Search the value you want to replace like “_twotask”

Step 7: Update the value on Value field and Save it

Step 8 : Now Run Autoconfig

Thanks,
Searchinoracle

Invalid server name oacore_server1 ( Remove and Add Managed servers )

Issue: 

While starting using adstrtal.sh script we have encountered below error:

Invalid server name oacore_server1

Why:

Found this managed server some how not showing in Weblogic Admin Console.

Solution :

First removed that managed server oacore_server1

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl \
ebs-delete-managedserver \
-contextfile=$CONTEXT_FILE \
-managedsrvname=oacore_server1 \
-servicetype=oacore \
-logfile=/home/applmgr/oacore_server1_remove.log

Output:

Enter the APPS Schema password:
Enter the WebLogic AdminServer password:
ManagedServer oacore_server1 deleted successfully.
$


Second , add the managed server oacore_server1

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl \
ebs-create-managedserver -contextfile=$CONTEXT_FILE \
-managedsrvname=oacore_server1 -servicetype=oacore \
-managedsrvport=<PORT> -logfile=/home/applmgr/forms_server1_add.log

Third sync it with .conf file

perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE \
-configoption=addMS -oacore=oacore_server1:<PORT>

After that able to start oacore_server1

Thanks,
Searchinoracle

Application side autoconfig is failing txkSetConfig.pl

When:

During clone

What :

Autoconfig is failing

WARNING: [CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /app/applmgr/ttst/apps/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl  1

 No. of scripts failed in CVM phase: 1


Updating context Variable s_forms_module_prepend_env_var_identifier....
ERRORCODE = 1 ERRORCODE_END
.end std out.
*******FATAL ERROR*******
PROGRAM : (/app/applmgr/ttst/apps/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl)
TIME    : Sat Jun 23 13:37:55 2018
FUNCTION:  [ Level 1 ]
ERRORMSG: *******FATAL ERROR*******
PROGRAM : (/app/applmgr/ttst/apps/fs2/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetConfig.pl)
TIME    : Sat Jun 23 13:37:55 2018
FUNCTION: TXK::IO::open [ Level 3 ]
MESSAGES:
error = Unable to open file
errorno = No such file or directory
file = </app/ttst/appltmp/java_ver.txt  >>> Issue here

Why :

Directory is not available

Solution:

Created that directory and then able to fix the issue.
We might need to resource environment prior running autoconfig.


Thanks,
Searchinoracle

There is insufficient memory for the Java Runtime Environment to continue......

When:

During clone

What :

adcfgclone is failing

Why :

Lack of processes for application OS user

Solution:

For below error

#
# There is insufficient memory for the Java Runtime Environment to continue.
# Cannot create GC thread. Out of system resources.
# An error report file with more information is saved as:

Check with OS team if we can have more processes to be added to application OS user.


This might have many solutions , which we have faced documented here.

Thanks,
Searchinoracle

ORA-01920: user name ''XXXXXX' conflicts with another user or role name

When:-

During clone from non production to non production

Why:- 

Already this Schema exists in source so we are getting this alert in target.

Solution:-

Either we can drop and recreate that schema or if you want to keep the same schema and nothing you want to change then , NO action require.

Thanks,
Searchinoracle

While starting RAC database using srvctl .. Error ( CRS-5017 , ORA-00439 )

When:-

While starting database using srvctl

What:-

I got below error:
PRCR-1079 : Failed to start resource ora.ttrn.db
CRS-5017: The resource action "ora.ttrn.db start" encountered the following error:
ORA-00439: feature not enabled: Real Application Clusters

Why:-

RAC was not enabled in binary.

Solution:-

[oracle@del1os1  lib]$ srvctl start database -d ttrn
PRCR-1079 : Failed to start resource ora.ttrn.db
CRS-5017: The resource action "ora.ttrn.db start" encountered the following error:
ORA-00439: feature not enabled: Real Application Clusters
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/del1os2/crs/trace/crsd_oraagent_oracle.trc".

[oracle@del1os1 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@del1os1 ~]$ make -f ins_rdbms.mk rac_on
[oracle@del1os1 ~]$ make -f ins_rdbms.mk ioracle


[oracle@del1os1  lib]$ srvctl start database -d ttrn
[oracle@del1os1  lib]$ 

ORA-44311, ORA-44305, ORA-06512 during delete old services ....

When : -

Clone instance

What : -

ERROR at line 1:
ORA-44305: service EBS_PATCH is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 40
ORA-06512: at "SYS.DBMS_SERVICE", line 421
ORA-06512: at line 1

Why :-

In my enviornment , two RAC node I got this error when this service is running on any one of the rac instance.

Solution :-

On node1:

=========

[oracle@del1os1 ~]$ srvctl stop service -d ttrn -s EBS_PATCH

PRCR-1001 : Resource ora.ttrn.ttrn_ebs_patch.svc does not exist

On node1 and node2

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

[oracle@del1os2 ~]$ . ./ttrn.env

[oracle@del1os2 ~]$  sqlplus '/as sysdba'

SYS@TTRN2>exec DBMS_SERVICE.STOP_SERVICE('EBS_PATCH');

PL/SQL procedure successfully completed.

SYS@TTRN2>exec DBMS_SERVICE.DELETE_SERVICE('EBS_PATCH');

PL/SQL procedure successfully completed.

It worked for my enviornment. So if you face this issue we might have one of this solution.

Thanks,

searchinoracle

Find the weblogic version and what are the patches has been applied

Find the weblogic version :

[applmgr@tapps1 ~]$ cd $FMW_HOME/wlserver_10.3/server/bin
[applmgr@tapps1 bin]$ . ./setWLSEnv.sh
...
........
Your environment has been set.

[applmgr@tapps1 bin]$ java weblogic.version
WebLogic Server 10.3.6.0.180417 PSU Patch for BUG27395085 THU FEB 21 18:34:42 GMT 2018
WebLogic Server Temporary Patch for BUG13845626 Tue Mar 20 17:35:12 GMT 2012
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050

Check what all are patches applied in weblogic :

[applmgr@tapps1 ~]$ cd $FMW_HOME/utils/bsu/

[applmgr@tapps1 bsu]$ bsu.sh -view -status=applied -prod_dir=${FMW_HOME}/wlserver_10.3
ProductName:       WebLogic Server
ProductVersion:    10.3 MP6
Components:        WebLogic Server/Core Application Server,WebLogic Server/Admi
                   nistration Console,WebLogic Server/Configuration Wizard and
                   Upgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Serve
                   r,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBC
                    Drivers,WebLogic Server/Third Party JDBC Drivers,WebLogic S
                   erver/WebLogic Server Clients,WebLogic Server/WebLogic Web S
                   erver Plugins,WebLogic Server/UDDI and Xquery Support,WebLog
                   ic Server/Evaluation Database,WebLogic Server/Workshop Code
                   Completion Support
BEAHome:             $FMW_HOME
ProductHome:        $FMW_HOME/wlserver_10.3
PatchSystemDir:    $FMW_HOME/utils/bsu
PatchDir:                $FMW_HOME/patch_wls1036
Profile:                    Default
DownloadDir:         $FMW_HOME/utils/bsu/cache_dir
JavaVersion:           1.6.0_29
JavaVendor:            Sun


Patch ID:          32I2
Patch ID:          YHJK
Patch ID:          7FC9 (17893334)
Patch ID:          S8H6 (20474010)
Patch ID:          YVDZ (13964737)
Patch ID:          SUY4 (25333306)
Patch ID:          DI8E (22323006)


Thanks,
Searchinoracle

RAC node2 instance not coming up error - "ora-03113 end-of-file on communication channel while startup"

RAC node2 instance not coming up error - "ora-03113 end-of-file on communication channel while startup"

When:- 

During Clone

Issue:

SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel

Problem :-

SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-03113: end-of-file on communication channel

On node1 protocol correctly changed to rds , but on node2 it is udp

[oracle@del1os1 ~]$ . ./ttrn.env
[oracle@del1os1 trace]$ $ORACLE_HOME/bin/skgxpinfo
rds


[oracle@del1os2 ~]$ . ./ttrn.env
[oracle@del1os2 ~]$  $ORACLE_HOME/bin/skgxpinfo
udp      ---- >>>>>>   In our case issue is wrong protocol

Solution:-

On node2 execute below

[oracle@del1os2 ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@del1os2 lib]$ make -f ins_rdbms.mk ipc_rds ioracle
---
----
-----
[oracle@del1os2 lib]$  $ORACLE_HOME/bin/skgxpinfo
rds


Able to start now :

SYS@TTRN2>startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4856257425 bytes
Fixed Size                  54658762 bytes
Variable Size            5648524575 bytes
Database Buffers         6325487115 bytes
Redo Buffers               11476992 bytes
Database mounted.
Database opened.
SYS@TTRN2>

This error is very common and we might have different solution, it is one of the scenario which I faced so share here , might help someone.

Thanks,
searchinoracle