ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "APPS.WF_NOTIFICATION", line 5130 ORA-06512: at line 1

Appove Workflow Notification Mailer --

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "APPS.WF_NOTIFICATION", line 5130 ORA-06512: at line 1

Solution :

select do.owner,do.object_name,do.object_type,dl.session_id,vs.serial#, vs.program,vs.machine,vs.osuser
from dba_locks dl,dba_objects do,v$session vs
where do.object_name ='WF_NOTIFICATIONS' and do.object_type='TABLE' and dl.lock_id1 =do.object_id and vs.sid = dl.session_id;

Issue the command

sql > alter system kill sessions 'sid,serial#' immediate;

Viewing Memory Use for Each User Session

The following query lists all current sessions, showing the Oracle user and current User Global Area (UGA) memory use for each session:

SELECT USERNAME, VALUE || 'bytes' "Current UGA memory"
FROM V$SESSION sess, V$SESSTAT stat, V$STATNAME name
WHERE sess.SID = stat.SID
AND stat.STATISTIC# = name.STATISTIC#
AND name.NAME = 'session uga memory';


USERNAME            Current              UGA memory
---------------  -------------   ---------------------------------
                                   18636bytes
                                   17464bytes
                                   19180bytes
                                   18364bytes
                                   39384bytes
                                   35292bytes
                                   17696bytes
                                   15868bytes
USERSCOTT                          42244bytes
SYS                                98196bytes
SYSTEM                             30648bytes

Creating APPS READ ONLY schema in Oracle Applications

step 1: Connect as sysdba and create the database user to be used for apps read only schema.

bash $ sqlplus "/ as sysdba"

SQL > create user appsro identified by appsro default tablespace APPS_TS_TX_DATA;

SQL> grant connect, resource to appsro;

SQL> grant create synonym to appsro;

SQL> exit;

step 2: Connect as APPS user and run the SQL commands:

bash $ sqlplus apps/******

SQL>set head off

SQL> set newpage none

SQL> set pagesize 9999

SQL> spool create_synonyms.sql

SQL> select 'create synonym ' || OBJECT_NAME || ' for ' || OWNER ||'.' ||OBJECT_NAME || ';' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

SQL> spool off

SQL> spool grant_select.sql

SQL> select 'grant select on '|| OWNER ||'.' ||OBJECT_NAME || ' to appsro;' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

SQL> spool off

SQL> exit;

step 3:
- connect as sysdba :

bash $ sqlplus "/as sysdba"

SQL> @grant_select.sql

SQL> exit;

step 4:
- connect as appsro

bash $ sqlplus appsro/appsro

SQL> @create_synonyms.sql

SQL> exit;

You are done. Now your users can use “appsro” schema to have the read only access to Apps Data.

FRM-92101: There was a failure in the Forms Server during startup - R12.1.1 & R12.1.3

After successful completion of fresh installation of R12.1.1 on OEL(Oracle Eneterprise Linux 5.5), there was an error while accessing form server. All other services and application are working fine.

When we are trying to access form Server its giving error as below:




When we click on details:




This error message is because of the missing rpm openmotif21-2.1.30-11.EL5.i386.rpm on Linux OS.

You can download this rpm from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/

After Installing this rpm bounce the middle tiers and access form server.

Issue must be resolved.

Happy reading :)

error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory R12.1.1

Hello,

I was Installing Oracle E-Biz R12.1.1 on OEL 5.6 - 64 Bit for one of our customer. All OS pre-requisites has been configured as per the MOS tech note for Installation and all pre-req check from the rapidwiz Installer went fine.

At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.

When checked all services were up and running except web server.

checking status of OPMN managed processes...

Processes in Instance: VIS_oel.oel.WORLD.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   13617 | Alive
HTTP_Server                      | HTTP_Server        |   13560 | Down 

Http_server is shown as Down.

Error messages recorded in logfiles:

Installation logfile:

HTTP 
----- 

checking URL = http://oel.WORLD.com:8011

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 


Help Page 
---------- 

checking URL = http://oel.WORLD.com:8011/OA_HTML/help 

RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 


Virtual Directory 
------------------ 

RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 


JSP 
---- 

checking URL = http://oel.WORLD.com:8011/OA_HTML/jtfTestCookie.jsp 

RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 


Login Page 
----------- 

RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button. 
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing. 

Apache logfiles:

07/04/11-10:23:44 :: adapcctl.sh: starting OPMN managed OHS instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=OEL.WORLD.COM:6210
    0 of 1 processes started.

ias-instance id=VIS_oel.oel.WORLD.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
    HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=83499476,pid=12821)
    failed to start a managed process after the maximum retry limit
    Log:
    /u02/oracle/VIS/inst/apps/VIS_oel/logs/ora/10.1.3/opmn/HTTP_Server~1.log

/u02/oracle/VIS/inst/apps/VIS_oel/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u02/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Cause:

http web server unable to start due to missing library.

Solution:

1) Shutdown all application services.
2) create link for library file as below

ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2

3) Startup all application services.

Now you should be able to access the application.

Happy reading... :)