Monday, June 27, 2011

How to implement a role for the BPEL console, which restricts the user's functionality

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
How to implement a role for the BPEL console, which restricts the user's functionality to the following:
1. the ability to view the BPEL Processes page
2. the ability to view the Instances page
3. the ability to view the Activities page
4. the ability to initiate a process, but not retire or undeploy it? Due to separation of duties on customer's site, they have a need for a way to allow developers to view process execution, but not change settings
Above can be done for for SOA Suite 11g but not for SOA 10g.
Currently for 10g, this functionality is not available but it is possible that users to build a separate BPEL console that would allow read only access to BPEL processes, instances and activities information. The following documents provide additional details:

http://forums.oracle.com/forums/thread.jspa?messageID=1849093
http://chintanblog.blogspot.com/2007/12/i-saw-numerous-people-asking-about-bpel_290.html
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-10388: parallel query server interrupt (failure) in Oracle Streams

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

- Problem Statement:
Streams has got the following error :

Errors in file /u01/app/oracle/admin/DPBIU/bdump/dpbiu_ora_6324.trc:
ORA-10388: parallel query server interrupt (failure)

Getting aborted with ORA-01280: Fatal LogMiner Error. in DBA_CAPTURE

It seems that the streams database got shutdown while a parallel query was 
running.

Starting the streams capture process again sounds solve the issue

SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps:


It seems that the streams database got shutdown while a parallel query was running.
I just started the streams capture process again and everything went fine.
Get Oracle Certifications for all Exams
Free Online Exams.com

Agent restarts frequently. draws alot of memory/VM on version 10.2.0.4

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description
Agent restarts frequently. draws alot of memory/VM
on version 10.2.0.4

Check AGENT_HOME/sysman/log

emagent.trc

2009-06-02 14:02:47,116 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,344 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,441 Thread-3020 ERROR engine: [oc4j,psoa.jdpuap02.dubaiworld.ae_home,oc4j_jms_raw] : nmeegd_GetMetricData failed : Result has repeating key value : jdpuap02.dubaiworld.ae/oc4j_soa:OC4J:12505//JMS
2009-06-02 14:02:47,441 Thread-3020 WARN collector: <nmecmc.c> Error exit. Error message: Result has repeating key value : jdpuap02.dubaiworld.ae/oc4j_soa:OC4J:12505//JMS
2009-06-02 14:02:47,562 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body
2009-06-02 14:02:47,685 Thread-3020 ERROR fetchlets.dms: Error allocating memory for response body

emagent.nohup

(pid=13735): emagent started successfully
URLTiming: Using SunX509
(pid=13735): signal handler called due to abnormal condition; dumping core due to signal SIGSEGV
----- Tue Jun 2 14:03:55 2009::Checking status of EMAgent : 13735 -----
----- Tue Jun 2 14:03:58 2009::Checking status of EMAgent : 13735 -----
----- Tue Jun 2 14:03:58 2009::EMAgent exited at Tue Jun 2 14:03:58 2009 with signal 6 -----
----- Tue Jun 2 14:03:58 2009::EMAgent has exited due to an internal error -----
----- Tue Jun 2 14:03:58 2009:: - checking for corefile at /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd -----
----- Tue Jun 2 14:03:58 2009::EMAgent coredump found at /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd/core
----- Tue Jun 2 14:03:58 2009::Core file moved to /u01/app/appsoau/product/grid_agent/agent10g/sysman/emd/core_EMAgent_1243937038
----- Tue Jun 2 14:04:00 2009::EMAgent will be restarted due to core dump(via signal 6). -----
----- Tue Jun 2 14:04:00 2009::Restarting EMAgent. -----
----- Tue Jun 2 14:04:00 2009::Agent Launched with PID 18989 at time Tue Jun 2 14:04:00 2009 -----
(pid=18989): starting emagent version 10.2.0.4.0
(pid=18989): emagent started successfully
URLTiming: Using SunX509

 Agent is leaking some memory, hence triggering an unstable state and restarting
The only workaround id to upgrade the agent to 10.2.0.5
Get Oracle Certifications for all Exams
Free Online Exams.com

RAC Troubleshooting: SERVICES ARE GETTING TERMINATED UNEXPECTEDLY

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

RAC Troubleshooting:  SERVICES ARE GETTING TERMINATED UNEXPECTEDLY on RAC Database

Here what you have to do to troubleshoot RAC services termination unexpectedly

- Check all logs under $ORACLE_HOME/log/<hostname>/racg/*

- /var/log/syslog.log

- Check  /tmp/node1status.txt ,/tmp/node2status.txt after running the following commands :

Node-1
-------
$script /tmp/node1status.txt
$hostname
$crsctl check crs
$crs_stat
$crs_stat -t
$crs_stat -ls
$crs_stat -p
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$olsnodes -n
$olsnodes -v
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$srvctl config nodeapps -n <nodename1> -a -g -s -l
$srvctl config nodeapps -n <nodename2> -a -g -s -l
$srvctl config database -d <db_name> -a
$srvctl config service -d <db_name> -a
$srvctl config asm -n <node name>
$ocrcheck
$crsctl query css votedisk
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$olsnodes -p 
$ocrdump run this as root user
$ifconfig -a 
$/etc/hosts 
$exit;

Node-2
--------
$hostname
$script /tmp/node2status.txt
$crsctl check crs
$ocrcheck
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$exit;
Get Oracle Certifications for all Exams
Free Online Exams.com