Apps password Change for EBS 12.2:

All three schema's APPS, APPLSYS and APPS_NE password  will be changed while changing APPLSYS password.
steps to change apps password:

1. Shut down the application tier services
2. Change the APPLSYS password
FNDCPASS apps/<apps_pw> 0 Y SYSTEM/<system_pw> SYSTEM APPLSYS <new_password>
3.Run Autoconfig on Application Tier with newly changed password
4. Start the Adminserver
cd $ADMIN_SCRIPTS_HOME
./adadminsrvctl.sh start
5. Change the "apps" password in WLS Datasource as follows:
(i)Log in to WLS Administration Console.
(ii)Click Lock & Edit in Change Center
(iii)In the Domain Structure tree, expand Services, then select Data Sources
(iv)On the "Summary of JDBC Data Sources" page, select EBSDataSource
(v)On the "Settings for EBSDataSource" page, select the Connection Pool tab.
(vi)Enter the new password in the "Password" and "Confirm Password" field.
(vii)Click Save
(viii)Click Activate Changes in Change Center.

Oracle Doc ID 1674462.1 using FNDCPASS or AFPASSWD.

How to find Oracle EBS Weblogic Server Admin Port and URL:

There are two way to get this:

1.
grep -i s_wls_adminport $CONTEXTFILE

Check for the value 'WLS Admin Server Port'.

2.
grep -i AdminServer $CONTEXTFILE

Check for 'listen-port' value of the 'AdminServer'

Weblogic console URL
http://<server name>. <domain name> : <weblogic Admin Port>/console
Ex: http://oracle.test1.com:7001/console


Command to get Console url:

echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console"

How managed server works in weblogic:

How managed server works and  how the health status of weblogic managed servers are reported and what does  mean by all health status  in weblogic.

Health state is reported by the server’s self-health monitoring which is default each 60 seconds. Monitoring things is like memory conditions, work managers capacity and threads status among others gets evaluated.Usually Server health is closely related to the stuck thread definition.Server health information is returned by the class ServerRuntimeMBean.HealthState.

WebLogic Server automatically detects when a thread in an execute queue becomes “stuck”: if it is continually working (not in idle state) for a set period of time(Default 600secs=10mins).

As a stuck thread cannot complete its current work or accept new work, the server logs a message each time it diagnoses a stuck thread.

server states details in weblogic?

1. OK

State by default (healthy). All subsystem are working as expected.

2. WARNING

System could have problems in the future. If all threads in weblogic.admin.HTTP, weblogic.admin.RMI, or an user-defined execute queue become stuck, the server changes its health state to warning.

Example Log Entry:

<2/10/2009 03:17:17 PM IST> <Warning> <WebLogicServer> <BEA-000337> <ExecuteThread: ’14’ for queue: ‘weblogic.kernel.Default’ has been busy for “652” seconds working on the request “Http Request: /GeamWeb/jsp/createConfLoc1.jsp”, which is more than the configured time (StuckThreadMaxTime) of “600” seconds.>

3. CRITICAL

A subsystem is in critical state when a part of it is malfunctioning (e.g stuck threads.) and something has to be done to prevent service failure.

Example log Entry:

<aug 13, 2010 2:49:51 PM BST> <Critical> <WebLogicServer> <BEA-000386><Server subsystem failed. Reason: java.lang.NumberFormatException: null
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:417)
at java.lang.Integer.parseInt(Integer.java:499)
at weblogic.ldap.EmbeddedLDAP.validateVDEDirectories(EmbeddedLDAP.java:1035)
at weblogic.ldap.EmbeddedLDAP.start(EmbeddedLDAP.java:212)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
Truncated. see log file for complete stacktrace

4. FAILED

If an individual subsystem determines that it can no longer operate in a consistent and reliable manner, it registers its health state as failed with the host server and must be restarted. If a server finds one or more critical subsystems have reached this state, the server marks its own health state as failed.

<Sep 8, 2011 5:41:10 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Sep 8, 2011 5:41:10 PM IST> <Error> <WebLogicServer> <BEA-000383> <Sep 8, 2011 5:41:10 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

5. OVERLOADED

When system capacity is reached, when Work Manager capacity is exceeded or as a result of low memory.

Upon entering the overloaded state, server instances start rejecting requests from the Work Manager queue (if a Work Manager is configured), HTTP requests return a 503 Error (Service Unavailable), and RMI requests fail over to another server if clustered, otherwise, a remote exception is returned to the client.
Example Log Entry:

Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool AppsQAE to allocate to applications, please increase the size of the pool and retry..[[
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:555)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:332)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:438)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:93)

Basic Unix

To grep from alert log file:

grep -in ORA-1652 -B1 -A1  /alert_TEST.log | tail -20

To view port :

netstat -anlp|grep -i 3667(process id)
netstat -an|grep -i <port no>

find:

find -name "*.tr?" -mmin +120 -exec ls -lrt {} \;
find -name "*.tr?" -mmin +120 -exec gzip -f {} \;

find -name "*.tr?" -mtime +2 -exec ls -lrt {} \;
find -name "*.tr?" -mtime +2 -exec gzip -f {} \;

find *csv* -mtime +364 -exec mv  {} /interface/PPR/D201A/archive/csv_backup \;


cron commect:

crontab -l|awk '{ if(match($0,"P100A") == 0) {print $0} else {print "###Q1FY16_TS3_Refresh_P100A_contact_mdmraza##_#"$0}}' |crontab

cd /opt/oracle/pr/orapps/P100A/
tar cvzf /share/orapp/P100A/P100A_APPL_$DATE_STAMP.tar.gz appl common ora oraInventory
tar cvzf /share/orapp/P100A/P100A_CUSTOM_$DATE_STAMP.tar.gz CUSTOM