Monthly Archives: January 2013

How to set auto start resources in 11G RAC

Changing Resource Attributes in 11gR2 Grid Infrastructure In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed … Continue reading

Posted in Oracle RAC | 2 Comments

How To Resize the Online Redo Logfiles

How To Resize the Online Redo Logfiles Single Instance: 1. First see the size of the current logs: > sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 … Continue reading

Posted in Database administration | 1 Comment

How To Trap Attempts At Closing The Browser Running A Forms Application

Solution 1. If you are using Oracle Jinitiator, open basejini.htm for edit. If you use the Sun Java Plug-in (JRE), open basejpi.htm. These files can be found in the Oracle Home \forms\server directory. 2. Change the html code as follows: … Continue reading

Posted in Oracle Application server | Leave a comment

How to Warn The Users If They Try To Close The Browser When A Forms Session Is Running

There is some code (javascript) that can be used to add a warning for the usersĀ if they try to close the browser when a forms session is running and they can lose the unsaved changes. For this you have to … Continue reading

Posted in Oracle Application server | Leave a comment

Faulting application frmweb.exe

Symptoms The Application Server running Forms show numerous errors similar to the following: On Windows , in the event viewer: Faulting application frmweb.exe, version 10.1.2.2, faulting module kernel32.dll, version 5.2.3790.2756, fault address 0x00015e02. On Linux, in /var/log/messages : kernel: frmweb[16576]: … Continue reading

Posted in Oracle Application server | Leave a comment

signature check failed

  Cause The “archive” parameter was pointing to a jar file that was not signed with a valid certificate. OR The .jar file contained more than one signature. This could be seen by unzipping the .jar file. Within the META-INF … Continue reading

Posted in Oracle Application server | Leave a comment

HOW TO GENERATE ARCHIVE LOG FROM ASM TO LOCAL DISK

HOW TO GENERATE ARCHIVE LOG FROM ASM TO LOCAL DISK SQL> CREATE or replace DIRECTORY archdir AS ‘+ARCH/mscdxb/arch/’;SQL> Directory created.SQL> CREATE or replace DIRECTORY tempdir AS ‘/u01/starch/’;Directory created. spool archmove.sql set linesize 250 set pagesize 250 select ‘EXECUTE DBMS_FILE_TRANSFER.COPY_FILE(”ARCHDIR”,”’|| SUBSTR(NAME,INSTR(NAME,’/’,-1) … Continue reading

Posted in ASM | Leave a comment