Setting up AIA logging in cluster environment

This is applicable only when you are deploying AIA to SOA Cluster. Only those members in cluster that are up and running will be configured.

1. Login to the machine.
2. Navigate to the server folder and then go to the soa_server1 location under fmwconfig.

Eg

/u01/app/oracle/admin/uat_domain_aia/server/prod_domain_aia/config/fmwconfig/servers/WLS_SOA1

3. Add the below Log_Handler and loggers to logging.xml

</log_handlers>

<log_handler name='aia-log-error-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory' level='TRACE:32'>

<property name='format' value='ODL-XML'/>

<property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/aia-error.log'/>

<property name='maxFileSize' value='10485760'/>

<property name='maxLogSize' value='104857600'/>

</log_handler>

<log_handler name='aia-log-trace-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory' level='TRACE:32'>

<property name='format' value='ODL-XML'/>

<property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/aia-trace.log'/>

<property name='maxFileSize' value='10485760'/>

<property name='maxLogSize' value='104857600'/>

</log_handler>

<log_handler name='aia-log-debug-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory' level='TRACE:32'>

<property name='encoding' value='UTF-8'/>

<property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/aia-debug.log'/>

<property name='maxFileSize' value='10485760'/>

<property name='maxLogSize' value='104857600'/>

</log_handler>

</log_handlers>

<loggers>

<logger name='oracle.aia.logging.error' level='NOTIFICATION:1' useParentHandlers='false'>

<handler name='aia-log-error-handler'/>

</logger>

<logger name='oracle.aia.logging.trace' level='NOTIFICATION:1' useParentHandlers='false'>

<handler name='aia-log-trace-handler'/>

</logger>

<logger name='oracle.aia.logging.debug' level='NOTIFICATION:1' useParentHandlers='false'>

<handler name='aia-log-debug-handler'/>

</logger>

<loggers>

4. Repeat above steps for soa_server2

Eg:

/u01/app/oracle/admin/prod_domain_aia/server/prod_domain_aia/config/fmwconfig/servers/WLS_SOA2/logging.xml

5. Restart Admin Server and all Managed Servers.
6. After all the servers was successfully restarted, login to the prod machine and navigate to the following directories

/u01/app/oracle/admin/prod_domain_aia/mserver1/prod_domain_aia/servers/WLS_SOA1/logs

/u01/app/oracle/admin/prod_domain_aia/mserver2/prod_domain_aia/servers/WLS_SOA2/logs

The following files should be generated in the above mentioned directories:

• aia-debug.log
• aia-trace.log
• aia-error.log

Recover the Weblogic or Node Manager Password

Recover the Weblogic Admin Password

 This note will be helpful in situations where there is a domain which is locked out to the user to access the console. This can happen when one forgets the username or password or both. One can still start the server but don't know the password for admin console. The fact that one could still start the server is because the username and password are stored in the boot.properties under domain directory. But they are encrypted. They can be recovered using weblogic.security.internal.BootProperties. One can use the following code to get the username and password of the domain.

Link

• http://kennethxu.blogspot.com/2006/04/how-to-recover-weblogic-admin-password.html
• How to recover WebLogic admin password from boot.properties file (Doc ID 1070213.1

Recover the NodeManager Password

Using WLST commands node manager user name password can be retrieve. This will be very useful while configuring clustered environment using enterprise deployment guide.

Links

• How to check/verify/modify Node Manager username & password? (Doc ID 1146793.1)

How to preserve whitespace in a Db Adapter read operation

Oracle recommends that you use varchar instead of char for primary key columns, otherwise you will need to set the weblogic-ra.xml property shouldTrimStrings to false. The truncation of trailing spaces could cause the primary key to be read incorrectly, making it impossible to update read rows as processed.

To set shouldTrimStrings  to false

This property is not exposed by default. It need to be enabled by doing jar xvf DbAdapter.rar META-INF/ra.xml, adding it, then jar uvf DbAdapter.rar META-INF/ra.xml and restarting your server.