Skip navigation.

Development

APEX 5 - Opening and Closing Modal Window - Part Two

Denes Kubicek - Thu, 2016-03-03 02:34
In this blog post from 2015 I explained how to open a modal window from an item and pass the values back, display a sucess message, etc. This page also contains an item plugin to make it easier to do the whole stuff and avoid hardcoding. I have never published this plugin. Hopefully this functionality is going to be a standard part of 5.1. Now, I was asked to make this working with a file browse item as well. I extended that example and created a new one showing how to do that with changing and clicking on a file browse item. You can see this example here. If you have an account for my workspace, you can even download the plugin and make it working in your environment. Enjoy.

Categories: Development

Free Webinar on Oracle Database Monitoring with Zabbix

Gerger Consulting - Wed, 2016-03-02 01:04
You are kindly invited to attend the free webinar hosted by Oracle ACE and Oracle Certified Master Ronald Rood: Oracle Monitoring with Zabbix. Register at this link.
Enterprise IT is moving to the Cloud. With tens, hundreds even thousands of servers in the Cloud, monitoring the uptime, performance and quality of the Cloud infrastructure becomes a challenge that traditional monitoring tools struggle to solve. Enter Zabbix. Zabbix is a low footprint, low impact, open source monitoring tool that provides various notification types and integrates easily with your ticketing system.
During the webinar, we'll cover the following topics:
  • Installation and configuration of Zabbix in the Cloud
  • Monitoring Oracle databases using Zabbix
  • How to use Zabbix templates to increase the quality and efficiency of your monitoring setup
  • How to setup Zabbix for large and remote networks
  • How to trigger events in Zabbix
  • Graphing with Zabbix
Categories: Development

Change Item Position using jQuery

Denes Kubicek - Sun, 2016-02-28 07:51
See this example on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.

Categories: Development

React on Tab Change

Denes Kubicek - Sun, 2016-02-28 07:47
See this example on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks Christian Rokitta for your help.

Categories: Development

First Steps with Oracle Application Builder Cloud Service

Shay Shmeltzer - Wed, 2016-02-24 19:22

Last week we released a new cloud service - the Oracle Application Builder Cloud Service.

(I'll refer to is as ABCS here to keep it short).

ABCS is built for the non-professional developer, what some call the citizen developer, giving them a solution to very quickly build and publish applications that can address immediate business needs. As you'll see in the demo below, a UI first approach makes development very simple.

I recorded a quick demo to show you just the basics of app development and wet your appetite.

As you'll see ABCS makes it dead simple to create Web apps, define business objects that you want to track (implemented as tables in an Oracle cloud database instance), and fine tune the UI creating multiple forms. The underlying UI technology of both ABCS and the apps that it creates is Oracle JET. 

Note that in this video I didn't cover the steps to actually stage and then publish your application so other users can access it - another thing that ABCS makes simple. On these and other capabilities in future blogs...

Categories: Development

Advanced SQL Webinar on February 23

Gerger Consulting - Mon, 2016-02-22 06:58
On February 23, Oracle ACE Kim Berg Hansen is hosting a free webinar about pattern matching with SQL in Oracle 12c. More than 140 developers have already signed up. Register at this link.


Categories: Development

ASR Summary Cheat sheet for Exadata and Enterprise Manager12c

Arun Bavera - Wed, 2016-02-17 11:19
What is ASR:

Phone Home feature for Engineered System View the ASR Demo Video.
ASR resolves problems faster by automatically opening service requests for Oracle's qualified server,  storage, and Engineered Systems when specific faults occur.


Note: From EM13c  onwards ASR is integrated directly.
Refer: https://docs.oracle.com/cd/E63000_01/EMASR/intro.htm#EMASR108

How to use ASR 


Summary
1. ASR can be installed in External system Linux or Solaris. (Small RPM package) We can install it in our OMS box.
2. Requires communnication between ExaData Assets where ASR monitoring is valid.
     4.15.1 ASR Port Usage http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD193  
3. Requires Communication to transport.oracle.com:443
4. ASR can send same SR Creation info to Omnibus via SNMP Trap.
      4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:  
      http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD200

PRe-Requisite
ASR Manager systems require Oracle Java 7 - JDK 7 (JDK 1.7.0_13) or later JDK 7 updates or Oracle Java 8 (1.8.0_25 or later).
Oracle Linux 5.3 or later. Red Hat Enterprise Linux 6.3 or later.
For IPv6, the ASR Manager server needs to be enabled for dual stack IPv6/IPv4

Test from designated ASR Manager server below:
telnet transport.oracle.com 443
/usr/bin/wget https://transport.oracle.com/v1/
https://transport.oracle.com/v1/


transport.oracle.com (141.146.1.169).

STEPS
1. Set-up firewall rules to allow bi-directional SNMP/UDP traffic to traverse between ASR Assets and the ASR Manager.
2. Ensure that ASR assets can send SNMP telemetry data out on port 162 to the ASR Manager. ( test using OneCommand)
3. Ensure that the ASR Manager can communicate with Service Tags on ASR asset, via http, using port 6481.
4. If your environment requires SNMP v3 to use the Oracle ASR service, you will need to configure both ASR Manager and any ASR Assets. See  
   Configuring ASR Manager for SNMP v3 and Optional ILOM Setup: SNMP v3 for ASR Assets for more information in Chapter 2.http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#CHDBAEEA
   http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch3_asr_assets.htm#BABGCHID
 
5. Verify Telemetry on each component valid for ASR monitoring -http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch1_asr_overview.htm#CEGFGDBG
6. Verify MOS account: MOS accont and SupportIdentifier How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1):
7. Install ASR Manager - http://docs.oracle.com/cd/E37710_01/doc.41/e26747/toc.htm
          Install ASR Manager -
  Test connectivity:
  Register  ASR with Oracle Support:
                      asr> register
 asr> show_reg_status
 asr> test_connection ( /opt/asrmanager/bin/asr test_connection)
 asr> autoupdate
 asr> show_version
 /opt/asrmanager/util/check_asr_status.sh

 service asrm stop
 tar -cvf db.tar.bz /var/opt/asrmanager/db
 tar -cvf configuration.tar.bz /var/opt/asrmanager/configuration
 service asrm start
 asr> send_deactivations -a
 asr> send_activations -a
 asr> list_asset
 asr> disable_asr_manager <1 48="" hours="" to="">
 asr> enable_asr_manager
 asr> disable_asset -i IP_address
 asr> enable_asset -i IP_address
 asr> send_test -i IP_address
 asr> send_test -h host name
 asr> deactivate_asset -i IP_address
 rpm -e asrmanager;rm -rf /var/opt/asrmanager/

 asr>  set_property snmp.receiver.port 1162
 asr>  get_property snmp.receiver.port
 service asrm restart


8. Configure ASR Assets - http://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm
http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch3_asr_assets.htm#BEIGAFFG
Activate Exadata Assets.--http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch3_asr_assets.htm#BEIDCBAI

Check the Service Tag:  http://asr_system_hostname:6481/stv1/agent/

9. Pre-check Engineered Systems ASR Configuration Check via ASREXACHK (Doc ID 1450112.1) to verify the ASR deployment.
10. Approve ASR assets refer
How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1)
11. Audit log at /var/opt/asrmanager/log/auditlog
12. Check ASR Email
13. Create Test Alert - ILOM - Refer http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch4_asr_enviro_admin.htm#ASRUD171
14. Check Ports: -4.15.1 ASR Port Usage
15. Configure ASR to send SNMP traps to Command center: 4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:  
   
  asr> set_notification_trap [-i ipAddress -p port -c community] [-h hostname -p port -c community]
  asr> set_notification_trap -i 127.0.0.1 -p 162 -c public
  asr> show_notification_trap
  asr> delete_notification_trap -i 127.0.0.1
  asr> send_test [-i ipAddress] [-h hostname]
  The SUN-ASR-NOTIFICATION-MIB file is located at:
  /var/opt/asrmanager/configuration/mib/SUN-ASR-NOTIFICATION-MIB.mib
16. Troubleshooting:  http://docs.oracle.com/cd/E37710_01/install.41/e18475/ch5_troubleshooting.htm#ASRUD202

Documentation:
Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide 5.5.1
http://docs.oracle.com/cd/E37710_01/index.htm
http://docs.oracle.com/cd/E37710_01/doc.41/e23333/toc.htm

Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide
Release 5.5
E23333-17
http://docs.oracle.com/cd/E50790_01/doc/doc.121/e23333/toc.htm


Categories: Development

How to Do Pattern Recognition with SQL in Oracle 12c

Gerger Consulting - Tue, 2016-02-16 08:03
More than 120 developers have signed up for Kim Berg Hansen's webinar about pattern recognition with SQL in Oracle 12c. Sign up for this free webinar if you want to improve your SQL skills and learn from the best.
Categories: Development

Taking backup of AIA Middleware Domains Excluding log files

Arun Bavera - Wed, 2016-02-10 15:24

tar -zcvf /opt/app/oracle/BACKUP/AIA_MSERVER.tar.gz --exclude='core.*'  --exclude='*.log*'  --exclude='*.out*'  --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/mserver/aia01_domain

tar -zcvf /opt/app/oracle/BACKUP/AIA_ASERVER.tar.gz --exclude='core.*'  --exclude='*.log*'  --exclude='*.out*'  --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/aserver/aia01_domain

Refer:
https://www.gnu.org/software/tar/manual/html_section/tar_49.html

Categories: Development

How to get nfs info on 1000 or many hosts using Oracle Enterprise Manager

Arun Bavera - Fri, 2016-02-05 11:27
There was a requirement to get nfs info on all the hosts.
Here is the way to get it:

Create a OS JOB in EM12c with following text and execute on all interested hosts. Assuming you have common shared mount on all these hosts.
Otherwise you can create Metric Extension to collect this info and query repository using Configuration Manger or directly to get this info.
 echo -e `echo '\n';hostname --l;echo '\n=====================================\n';nfsstat -m;echo '\n=====================================\n';exit 0` >> /nfs_software/nfs_info_PROD.txt



Categories: Development

New Continuous Integration tutorial published

Lynn Munsinger - Mon, 2012-07-02 09:44
Hot off the press – a new continuous integration tutorial. It’s really not just about continuous integration, though! You’ll find it useful even if you aren’t using a continuous integration server like Hudson. It’s useful if you are doing any part of the scenario it documents: Setting up Team Productivity Center for your team and [...]

Advanced ADF eCourse, Part Deux

Lynn Munsinger - Tue, 2012-06-19 15:11
In February, we published the first in a series of FREE(!) online advanced ADF training: http://tinyurl.com/advadf-part1 The response to that course has been overwhelmingly positive as more and more people are moving past the evaluation/prototype stages with ADF and looking for more advanced topics. I’m pleased to relay the good news that the 2nd part [...]

Fun with Hudson, Part 1.1

Lynn Munsinger - Tue, 2012-06-05 09:19
Earlier I posted that I had used the following zip command in the ‘execute shell’ action for my Hudson build job: zip -r $WORKSPACE/builds/$JOB_NAME-$BUILD_NUMBER * -x ‘*/.svn/*’ -x ‘*builds/*’ This zips up the content of the exported source, so that I can send it on to team members who need the source of each build [...]

Hiring a Curriculum Developer

Lynn Munsinger - Tue, 2012-05-15 09:34
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

Hiring a Curriculum Developer

Lynn Munsinger - Tue, 2012-05-15 09:34
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

New ADF Insider on Layouts

Lynn Munsinger - Mon, 2012-03-26 13:22
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html

New ADF Insider on Layouts

Lynn Munsinger - Mon, 2012-03-26 13:22
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html

Wed, 1969-12-31 18:00