FRM 93552

FRM 93552

I had to administer a new implementation n 11.1.2 version of forms and reports server.

I had a good chance to learn that there are a few fundamental differences in 10g and 11g version of forms.
It is best practice in 11g to make formweb.cfg and other config file changes by using the em console.  sometime it becomes an intermittent problem in case this thumb-rule is ignored.

Following forms error is a manifestation of a manual change made to formsweb.cfg on the forms server.

 

 In case the error is accompanied with the following errors, as is seen in the diagnostics log here :

 

There is a oracle support note that recommends a native library :

Getting FRM-93552 When Calling Forms (Doc ID 1345748.1)

here the recommendation is to include the actual path for ORACLE_HOME/jdk/jre/lib/amd64/native_threads LD_LIBRARY_PATH variable in the ******.env file. Again, it is best to update the *****.env file over the em console

 

This was a good lesson learned!!

Cheers, 

Arun

Volume check

In one project, We had a service provider supporting storage and infrastructure.

One fine morning we heard there would be a network outage impacting all services. This meant an overnight schedule involving :

• Prep work
• Prevention of autostart scripts/crons/batches and the enterprise scheduler
• Shutdown of the whole production stack prior to the outage
• Manual startup
• Validation of services
• Enable autostart, cron, batches and enterprise scheduler
• makeup lost schedule executions 
• Wrap up

This was a tedious schedule spanning several servers, several DBAs working through the night.

The service provider added that the storage may be drawn away from the servers during the outage and nfs volumes need to be validated before startup.

I put together a handy script to put to rest the possibility of manual errors in the wee hours of the morning
following is the script attached  :) --> enjoy

nfs volume check

Datacenter move and IP change

From another datacenter move project,

Several weblogic middleware servers were being moved from one datacenter to another. Weblogic is not touchy with IPs however, it stores hostnames at several different locations Oracle told us on one of the SRs we had open with them. Soon I realized that the Weblogic config files also store in them at several locations references to IPs. 

There were several weblogic servers being moved and time was of the essence in this situation. I had to design a quick and simple script to correct IPs in the config files to have the weblogic servers to start smooth after the move.

Please find the script attached from my repository attached here -->
IP Change script

Datacenter move and system check

I was working on a datacenter move project recently,

We had to create tons of servers needed to be created and infrastructure was to be moved from old outdated hardware to newer hardware at the new datacenter. I had the following procedure advised to the sysadmin team for preparing the servers.

• RDA was run with the HCVE option for middleware, database and EBS specifications.
• Corrections were accordingly implemented to nominated servers
• Templates were to be created from the corrected servers.
• All new servers were to be created from the templates that were created thus.

The images created hence were noticed to be a little different from the other one. These were SA configurable parameters. Thereby, I had to come up with a script that would check and identify miss-configurations that would come after the sysadmins. The sysadmins were then advised to run the script and hand over the server to the DBA team only after all errors were corrected.

Please find the script attached from my repository attached here -->
System check