Development

My Demo Application

Denes Kubicek - Tue, 2016-03-29 00:34
If you experience a problem accessing My Demo Application (old and new version) at apex.oracle.com, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink the way of accessing the workspace. It happened for the second time within the last four months.

Categories: Development

Calling REST Services from Application Builder Cloud Service

Shay Shmeltzer - Mon, 2016-03-21 16:33

One of the frequent requests we get when we demo ABCS is - can I invoke some external functionality that is exposed as a REST service and pass parameters to it.

Well, with a minimal amount of JavaScript coding you can do it in the current version. 

I recorded the demo below that shows you how to do that.

I'm leveraging a public REST API that github exposes to get a list of repositories for a user. The service is available at https://api.github.com/users/oracle/repos

I then design an ABCS page that has a parameter field, a button that invokes the REST/JSON call, and a placeholder for results. It looks like this: 

In addition the video also shows some other techniques that are useful, including:

  • How to create a new blank data entry page
  • How to add custom component that renders HTML content
  • How to add a button that calls a REST service
  • How to pass a parameter to the JavaScript custom code
  • How to set a page to be the default page of the app
  • How to stage your application for external testing

<span id="XinhaEditingPostion"></span>

It seems that right now you are restricted to accessing REST services that are secured over HTTPS protocol (which is a good thing).

Note that you of course don't have to stage the app to see it run, you can just go into live mode, or run it to see it working. I just wanted to make sure I have a demo out there that shows how staging works.

The JavaScript snippet I'm using in the video is: 

$.getJSON("https://api.github.com/users/"+ +"/repos", function(result){

$.each(result, function(i, field){

$('[name="myOutput"]').append(field.name + " ");

});

        });

resolve(); 

If you'll actually add a

$('[name="results"]').empty(); 

as the first link, it will clear the field for you each time you re-press the button. 

Categories: Development

Monitor Oracle with Zabbix

Gerger Consulting - Mon, 2016-03-21 06:09
We've got a webinar tomorrow. Attend our webinar and learn how you can monitor your Oracle Database instances with the open source monitoring tool Zabbix. Sign up at this link. More than 125 people have already signed up!




Categories: Development

Something Amiss

Greg Pavlik - Thu, 2016-03-17 00:02
Looks like this curious non-review of the novel Laurus seems to have been referring to "Brahmins" as "Brahman" - I suppose republished to correct the mistake:
​Russian Brahman by Alan Jacobs | Articles | First Things
www.firstthings.com/article/2016/04/russian-brahman
First Things
Russian Brahman. by Alan Jacobs April 2016. Laurus by eugene vodolazkin translated by lisa hayden oneworld, 384 pages, $24.99. Eugene Vodolazkin's ...
​Russian Brahmin by Alan Jacobs | Articles | First Things
www.firstthings.com/article/2016/04/russian-brahmin
First Things
Russian Brahmin. by Alan Jacobs April 2016. Laurus by eugene vodolazkin translated by lisa hayden oneworld, 384 pages, $24.99. Eugene Vodolazkin's ...

Whatever his grasp of Hindu concepts, it's obvious Jacobs knows little to nothing about the tradition of Russian yurodivy, which makes this review overall kind of silly at best. Interested readers can refer to the hagiographies of Xenia of Petersburg or Feofil of the Kiev Caves Lavra to become acquainted with some of the conceptual background to the novel, both published by the monastery press in Jordanville, NY in English. As a complement the Pavel Lungin movie Ostrov is worth watching carefully - the film is based partly on Feofil, though like the life of St Xenia, it explores the theme of vicarious repentance. (It was not until the third time I saw the film that I fully grasped it - the visuals are stunning and in many respects a distraction.)

All of that aside, what continues to trouble me in general is the fact that most of the reviews of Laurus that I've seen have been oriented toward theological critiques - endorsements or arguments revolving around the reviewer's reading of what the author might want us to think about religion. And yet it is obvious that Vodolazkin did not write a religious apologetic (Jacobs invokes Karamazov, which is simultaneously a religious argument and a humanistic work - but Laurus is anything but the former). Laurus deserves a review as a work of notable - even great - world literature: which is to say first and foremost an exploration of what Vodolazkin is attempting to accomplish as a writer and what that has produced as a work of literature. The lack of serious analysis is particularly puzzling given the devices Vodolazkin uses to deal with language, identity, personality, relationship, and - yes - time. We could do with a few less sermons and a bit more thought.

OTN Interview about Application Development with Oracle

Shay Shmeltzer - Tue, 2016-03-15 14:34

A few weeks ago, I set down with Bob from OTN for an interview that covered some of the key products our group works on.

I covered the various frameworks (ADF, JET, MAF), what we are doing with cloud based development (DevCS) and our tools for citizen developers (ABCS).

In case you are interested in any of these acronyms here is the video:

Note that things move really fast at Oracle, and since this interview we already released a new version of Oracle JET and also made it open source, we released an update to Developer Cloud Service, and Application Builder Cloud Service has gone production.

Categories: Development

Monitoring Oracle Database with Zabbix

Gerger Consulting - Mon, 2016-03-14 08:14

Attend our free webinar and learn how you can use Zabbix, the open source monitoring solution, to monitor your Oracle Database instances? The webinar is presented by Oracle ACE and Certified Master Ronald Rood.


About the Webinar:

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

    WINDOW NOSORT STOPKEY + RANK()

    XTended Oracle SQL - Fri, 2016-03-11 18:23

    Recently I found that WINDOW NOSORT STOPKEY with RANK()OVER() works very inefficiently: http://www.freelists.org/post/oracle-l/RANKWINDOW-NOSORT-STOPKEY-stopkey-doesnt-work
    The root cause of this behaviour is that Oracle optimizes WINDOW NOSORT STOPKEY with RANK the same way as with DENSE_RANK:

    rnk1

    create table test(n not null) as 
      with gen as (select level n from dual connect by level<=100)
      select g2.n as n
      from gen g1, gen g2
      where g1.n<=10
    /
    create index ix_test on test(n)
    /
    exec dbms_stats.gather_table_stats('','TEST');
    select/*+ gather_plan_statistics */ n
    from (select rank()over(order by n) rnk
                ,n
          from test)
    where rnk<=3
    /
    select * from table(dbms_xplan.display_cursor('','','allstats last'));
    drop table test purge;
    

    [collapse]
    Output
             N
    ----------
             1
             1
             1
             1
             1
             1
             1
             1
             1
             1
    
    10 rows selected.
    
    PLAN_TABLE_OUTPUT
    -----------------------------------------------------------------------------------------------------------------------
    SQL_ID  8tbq95dpw0gw7, child number 0
    -------------------------------------
    select/*+ gather_plan_statistics */ n from (select rank()over(order by
    n) rnk             ,n       from test) where rnk<=3
    
    Plan hash value: 1892911073
    
    -----------------------------------------------------------------------------------------------------------------------
    | Id  | Operation              | Name    | Starts | E-Rows | A-Rows |   A-Time   | Buffers |  OMem |  1Mem | Used-Mem |
    -----------------------------------------------------------------------------------------------------------------------
    |   0 | SELECT STATEMENT       |         |      1 |        |     10 |00:00:00.01 |       3 |       |       |          |
    |*  1 |  VIEW                  |         |      1 |   1000 |     10 |00:00:00.01 |       3 |       |       |          |
    |*  2 |   WINDOW NOSORT STOPKEY|         |      1 |   1000 |     30 |00:00:00.01 |       3 | 73728 | 73728 |          |
    |   3 |    INDEX FULL SCAN     | IX_TEST |      1 |   1000 |     31 |00:00:00.01 |       3 |       |       |          |
    -----------------------------------------------------------------------------------------------------------------------
    
    Predicate Information (identified by operation id):
    ---------------------------------------------------
    
       1 - filter("RNK"<=3)
       2 - filter(RANK() OVER ( ORDER BY "N")<=3)
    

    [collapse]

    As you can see, A-Rows in plan step 2 = 30 – ie, that is the number of rows where

    DENSE_RANK<=3

    but not

    RANK<=3

    The more effective way will be to stop after first 10 rows, because 11th row already has RANK more than 3!
    But we can create own STOPKEY version with PL/SQL:

    PLSQL STOPKEY version
    create or replace type rowids_table is table of varchar2(18);
    /
    create or replace function get_rowids_by_rank(
          n          int
         ,max_rank   int
       ) 
       return rowids_table pipelined
    as
    begin
       for r in (
          select/*+ index_rs_asc(t (n))  */ rowidtochar(rowid) chr_rowid, rank()over(order by n) rnk
          from test t
          where t.n > get_rowids_by_rank.n
          order by n
       )
       loop
          if r.rnk <= max_rank then
             pipe row (r.chr_rowid);
          else
             exit;
          end if;
       end loop;
       return;
    end;
    /
    select/*+ leading(r t) use_nl(t) */
       t.*
    from table(get_rowids_by_rank(1, 3)) r
        ,test t
    where t.rowid = chartorowid(r.column_value)
    /
    

    [collapse]
    In that case the fetch from a table will stop when rnk will be larger than max_rank

    Categories: Development

    Free Oracle Database Monitoring Webinar by Oracle ACE Ronald Rood

    Gerger Consulting - Wed, 2016-03-09 05:19
    Attend our webinar and learn how you can monitor your Oracle Database and cloud infrastructure with Zabbix, the open source monitoring tool.

    The presentation is hosted by Oracle ACE and Certified Master Ronald Rood.

    Learn more about the webinar at this link.


    Categories: Development

    Side by Side comparison: ParalleNew+CMS vs G1GC Java Garbage Collector

    Arun Bavera - Fri, 2016-03-04 17:31
    Side by Side comparison: Left ParalleNew+CMS Right:G1GC
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.

    Here are test and result screens in ViisualVM and JMC.
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m"
    JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    JAVA_OPTIONS+=" -XX:+UnlockCommercialFeatures"
    JAVA_OPTIONS+=" -XX:+FlightRecorder"
    Note: All other values default:
    3.3Sec Pause 11.4 Sec Pause
    clip_image002[6]










    Three Grinder Tests with:
    Left ParalleNew+CMS Right:G1Gc
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    8.99Sec Pause 30.14Sec Pause
    clip_image002[10]

    Another three Grind Test:
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    JAVA_OPTIONS+=" -XX:NewRatio=2"
    Left: JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    Right:
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    clip_image002[12]
    Result:
    Left: 8.54 Sec Pause Right: 1m+ 19.9Sec
    JFR for 2 GrindTest:
    clip_image002[14]
    clip_image002[16]
    Memory Overview Left: PrallelNew_CMS Right:G1GC
    clip_image002[18]
    Garbage Collection
    clip_image002[20]
    gcPausetime:
    clip_image002[22]
    GC Configuration:
    clip_image002[24]
    Threads CPU Usage:
    clip_image002[26]
    Lock Instances:
    clip_image002[28]
    Socket Write:
    clip_image002[30]
    System:
    clip_image002[32]
    Code Exceptions:
    clip_image002[34]
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.






























































    Categories: Development

    Application Builder Cloud Service - Menus, Buttons and Validation

    Shay Shmeltzer - Fri, 2016-03-04 12:11

    Continuing with the exploration of Oracle Application Builder Cloud Service, I've picked up the application I created in the previous blog entry and added a few more things to demo how to:

    • Configure the logo and title
    • Modify and add menu items
    • Define field level validation
    • Add buttons and define their actions

    Check out this short demo:

    Categories: 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

    Pages

    Subscribe to Oracle FAQ aggregator - Development