APEX Community

    Welcome to the ODTUG APEX community! Let this serve as your portal to all things Application Express – a blog feed, a glimpse at the latest tweets from the Twitterverse, and a look at the Application Express content located in the Technical Database.

    DelphixIf you’ve been keeping an eye on my Public Appearances page you’ll know that I am scheduled to go on line with Kyle Hailey for a second (more technical) discussion about Delphix and virtual databases on 19th June (tomorrow). If you haven’t registered, there’s still time to do so. It’s scheduled for 5:00 pm (BST), […]
    Sage Computing Services now on Google+I've recently created a Google+ page for Sage Computing Services, the wonderful company I work for that has just celebrated 20 years of consulting & training in Perth.


    We aim to use this social media presence to announce public training events, community involvement, and anything else we find relevant. No doubt it's usefulness will expand over time.

    Check us out!
    Two articles in one week...Last week I presented at the OUG Scotland conference. To my surprise, I received the latest, 50th edition (!), of Oracle Scene - the publication of the UK OUG during registration. And, less to my surprise, there was an article in there written by yours truly: "Building Mobile Web Applications with Oracle Application Express". 

    And when I got back home, I found the magazine of the Dutch Oracle User Group on the doorstep, with another article authored by me. Not really "another" as it is just a translated version (the English one was first...). 

    Nevertheless, quite proud of publishing not one, but even two articles in well known magazines in the same week!
    JDD PublisherJDD Spreadsheet Publisher enhances existing software application‘s cabilities by a flexible data export to Microsoft Excel. Design your templates in Microsoft Excel and use a simple placeholder syntax. The JDD Spreadsheet Publisher takes both, data and template and renders a ready-to-use Microsoft Excel© workbook in your design layout.

    Your benefits:

    - Flexibility

    Templates can be customized in a fast and straightforward way just by using Microsoft Excel. Eliminate discussions between IT and business about security, effort and delivery periods.

    - Process Reliability

    Your development environment is Microsoft Excel©. You specify the design of the Excel report. JDD Spreadsheet Publisher only cares about data and correctly adjusted relations inside the workbook. Use any of the Excel built-in functions and features to enhance your report.


    Remove packages with yumTo uninstall a package from the OS, you will simply pass the remove parameter to the yum command: [root@rac1 Packages]# yum remove rsync Loaded plugins: product-id, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. Setting up Remove Process Resolving Dependencies --> Running transaction check ---> [...]
    ORA-01115: IO error reading block from file (block # ) - a list of common causes
    There are situations when a single issue could arise for different reasons. Will list out some of the common causes of an 'ORA-01115: IO error reading block from file  (block # )' error over here.

    Typically, when Oracle failed to read a data block from an open data file, it throws an ORA-01115 error.  Before you suspect any database issue, it is advised to have a close look at the error message stack presented before and after the ORA-01115 error in the database alert.log file. As there could be a different reason for this error when comparing the same error over the net or previous occurrence, it is pretty important that you isolate the issue looking at the other error messages represented along with this error.

    One of the following would be the most common reasons for the error:
    • the datafile in the context is OFFLINE
    • database might have lost communication with the underlying ASM instance
    • caused by any hardware problems
    • physical data block corruption at the storage level
    • a Oracle BUG
    We have encountered similar issue in one of our RAC databases due to communication loss with the underlying ASM instance. Here is the alert.log entries:

    WARNING: ASM communication error: op 0 state 0x0 (15055)
    ERROR: direct connection failure with ASM
    ERROR: paging ASM fault extent map failed gn=28 fn=256 extet=715
    Errors in file /u00/app/oracle/diag/rdbms/xxxDB/xxxDB2/trace/xxxDB2D2_ora_21886.trc:
    ORA-00704: bootstrap process failure
    ORA-01115: IO error reading block from file  (block # )
    ORA-01110: data file 1: '+DG_DATA/xxxdb/datafile/system.256.680619545'
    ORA-15055: unable to connect to ASM instance
    ORA-15055: unable to connect to ASM instance
    ORA-00020: maximum number of processes (100) exceeded
    ORA-00704: bootstrap process failure
    ORA-01115: IO error reading block from file  (block # )
    ORA-15055: unable to connect to ASM instance
    ORA-15055: unable to connect to ASM instance
    ORA-00020: maximum number of processes (100) exceeded
    Error 704 happened during db open, shutting down database
    USER (ospid: 21886): terminating the instance due to error 704
    Instance terminated by USER, pid = 21886



    In a nutshell, you must examine the error stack message when you encounter similar issue to diagnose the real cause of the problem.

    NOTE: I welcome your inputs, additions and you want to share your experience on this issue.

    Training on Demand: Fusion Applications Extend Applications with ADFRecently we followed the training Fusion Applications: Extend Applications with ADF in Training on Demand format. What is Training on Demand? “You train online via an Internet connection, 24/7. Access streaming lectures, whiteboarding and lab activities, with the ability to search video,

    Continue reading

    A new era: Fusion ApplicationsFusion Applications is out there, that is a fact. ERP customers are starting to look more and more at Fusion Applications as a serious replacement or a coexistence with their current ERP systems and we have to answer to the

    Continue reading

    Install and Configure Red Hat 6.4 for Oracle DatabasesPosted by: Charles Kim, Oracle ACE Director and VMware vExpert We will review the basics of installing Red Hat Linux Enterprise 6 Update 4 for the Intel 64-bit platform in a virtualized infrastructure to prepare an environment to install an Oracle cluster and database(s). To simplify the process and to demonstrate package installation procedures, we [...]
    Apex Calendar

    ODTUG Job BoardAPEX BlogrollAdd Blog
    APEXABOUTblogButton.jpg

    Helpful Links


    Apex File Library

    We currently have 215 files in our file library.
    Our latest files added:

    • Using Oracle Application Express for Research - The Perfect Tool
    • All About The APEX Listener
    • Compelling, Dynamic, Graphical – And If We Are Lucky – USEFUL E-mail Generation
    • Upgrading the Fun Ships® with Oracle APEX
    • High Quality PDF Printing with APEX & PL/PDF


    • Click here to view all files

     

    Apex Twitter

     

    Sponsored by

    APEX Evangelists
    APEXblogs.net Created by
    Dimitri Gielis

    See More Blogs


    2520 Independence Blvd., Suite 201 | Wilmington, NC 28412 | Phone (855) 853-0491 | odtug@odtug.com | Copyright © 2013