Feed aggregator

EBS 12.2 Upgrade Guides Updated and Streamlined

Steven Chan - Fri, 2017-09-22 02:15

A significant number of customers have successfully upgraded to Oracle E-Business Suite Release 12.2.  Along the way, they have given us a great deal of feedback on how we could improve our certified upgrade processes and documentation.

I'm pleased to announce that we have incorporated their feedback into the latest published upgrade guides available in the Oracle E-Business Suite Web Library and on the Oracle E-Business Suite Release 12.2.7 media.

What's New?

The following enhancements have been made to the Oracle E-Business Suite Release 12.0/12.1-to-12.2 and 11i-to-12.2 Upgrade Guides:

  • Reorganized and simplified chapters and steps
  • Provided clarity around the overall upgrade process and major steps using diagrams
  • Reduced the number of self references and external references and confirmed all remaining references
  • Created new documentation tags for actionable references and steps

If you are already working on your upgrade to Oracle E-Business Suite 12.2, there's no need to switch to the recently updated upgrade guide. If you are getting ready to start your upgrade, be sure to use the latest updated upgrade guide.

References

Related Articles

Categories: APPS Blogs

#GoldenGate sessions at #OOW17

DBASolved - Thu, 2017-09-21 14:52

We are a little over a week out from Oracle Open World 2017; hopefully you are filling out your schedules! This year there is a lot of items going on; so I figured I would help you out and point out where you can find the Oracle GoldenGate sessions this year! With the release of Oracle GoldenGate 12.3, there is a lot of new features and updates. So check them out (in no particular order)!

Sessions:

  • Oracle GoldenGate Product Update and Strategy
    • Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Moscone West – Room 3003
  • Maximizing Availability for Oracle GoldenGate Microservices
    • Tuesday, Oct 03, 4:45 p.m. – 5:30 p.m. | Moscone West – Room 3014
  • Oracle GoldenGate for Big Data
    • Wednesday, Oct 04, 4:30 p.m. – 5:15 p.m. | Moscone West – Room 3005
  • Deep Dive into Automating Oracle GoldenGate Using the New Microservices
    • Monday, Oct 02, 1:15 p.m. – 2:00 p.m. | Moscone West – Room 3010
  • Accelerate Cloud Onboarding Using Oracle GoldenGate Cloud Service
    • Tuesday, Oct 03, 3:45 p.m. – 4:30 p.m. | Moscone West – Room 3024
  • Oracle Data Integrator and Oracle GoldenGate for Big Data
    • Wednesday, Oct 04, 11:30 a.m. – 12:30 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental 4
  • Replicate Data Across Data Centers with Equinix and Oracle GoldenGate
    • Wednesday, Oct 04, 10:30 a.m. – 10:50 a.m. | The Exchange @ Moscone South – Showcase Theater 1
  • An Enterprise Databus: Oracle GoldenGate in the Cloud Working with Kafka and Spark
    • Wednesday, Oct 04, 3:30 p.m. – 4:15 p.m. | Moscone West – Room 3003
  • Oracle GoldenGate Cloud Service: Real-Time Data Replication in the Cloud
    • Monday, Oct 02, 6:00 p.m. – 7:00 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental 4
  • Best Practices and Deep Dive on Oracle GoldenGate 12.3 Microservices at Cloud
    • Wednesday, Oct 04, 3:30 p.m. – 4:15 p.m. | Moscone West – Room 3011
  • How to Replicate Data in the Cloud in Real Time
    • Wednesday, Oct 04, 11:00 a.m. – 1:00 p.m. | Hilton San Francisco Union Square (Lobby Level) – Golden Gate 2/3
  • Oracle Data Integration Platform Cloud Strategy and Roadmap
    • Monday, Oct 02, 12:15 p.m. – 1:00 p.m. | Moscone West – Room 3024
  • Oracle Data Integration Platform Empowers Enterprise-Grade Big Data Solutions
    • Monday, Oct 02, 4:45 p.m. – 5:30 p.m. | Marriott Marquis (Golden Gate Level) – Golden Gate C1/C2
  • Kafka’s Role in Implementing Oracle’s Big Data Reference Architecture  
    • Sunday, Oct 01, 1:45 p.m. – 2:30 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 12
  • Oracle Maximum Availability Architecture Best Practices: Oracle Database 12 c
    • Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Moscone West – Room 3006

As you can tell, there is a lot of information that is going to be helpful for your Oracle GoldenGate, BigData and various other areas. Make sure you check all these out.

Enjoy!!


Filed under: Golden Gate
Categories: DBA Blogs

List of “Dashboard” Startups and Products

Nilesh Jethwa - Thu, 2017-09-21 14:14

The idea of building a dashboard application has become synonymous to the idea of a developer thinking let us build a "To-do" application.

This is evident by the sheer amount of dashboard related applications that developers/founders have submitted to Hacker News over the past several years.

The dashboards range from wide spectrum, on one side to personal dashboards, project management dashboards, network dashboards to full blown social media dashboards.

If you are looking to build the next dashboard application or just shopping, it is very interesting to look at all the "Show HN" Dashboard submissions

Read more at http://www.infocaptor.com/dashboard/list-of-dashboard-startups

Oracle Announces Java SE 9 and Java EE 8

Oracle Press Releases - Thu, 2017-09-21 14:00
Press Release
Oracle Announces Java SE 9 and Java EE 8 Sets Stage for Faster Releases and More Open Source Engagement

Redwood Shores, Calif.—Sep 21, 2017

Oracle today announced the general availability of Java SE 9 (JDK 9), Java Platform Enterprise Edition 8 (Java EE 8) and the Java EE 8 Software Development Kit (SDK). JDK 9 is a production-ready implementation of the Java SE 9 Platform Specification, which was recently approved together with Java EE 8 in the Java Community Process (JCP). Java SE 9 provides more than 150 new features, including a new module system and improvements that bring more scalability, improved security, better performance management and easier development to the world’s most popular programming platform. Java EE 8 modernizes and simplifies the Java EE platform for the cloud and microservices with updates to eight major specifications.

Java SE 9

The defining feature of Java SE 9 is the Java Platform Module System, also known as Project Jigsaw, which makes it easier for developers to reliably assemble and maintain sophisticated applications. The module system also makes the JDK itself more flexible, allowing developers to bundle just those parts of the JDK that are needed to run an application when deploying to the cloud.

“Java SE 9 is the result of industry-wide development involving open review, weekly builds and extensive collaboration between Oracle engineers and members of the worldwide Java developer community via the OpenJDK Community and the JCP,” said Georges Saab, vice president of development for the Java Platform Group at Oracle. “This version of Java SE will provide millions of developers the updated tools they need to continue building next-generation applications with ease, performance and agility.”

The OpenJDK Community is where a diverse set of contributors have collaborated for more than ten years on an open-source implementation of the Java SE platform. Other key features in Java SE 9 include:

  • jshell, which delivers an interactive Read-Eval-Print-Loop tool that makes it easy for developers to explore APIs and try out language features.
  • Improved Javadoc, which makes it easier for developers to learn new APIs by including a search function within the API documentation itself, as well as information on which module defines each class or interface.
  • Streams API enhancements, which improve developer productivity by adding methods to conditionally take/drop items from a Stream, iterate over a Stream’s elements, and create a Stream from a nullable value while expanding the set of Java SE APIs that can serve as sources for Streams.

For the full list of features introduced in JDK 9, please visit this page.

Oracle has also announced several changes to how Java SE and Java EE will be developed and released going forward.

For Oracle Java SE, Oracle is planning to move to a 6-month release cadence using a time driven release model rather than a feature driven release model. With that change, Oracle will also be providing OpenJDK builds under the General Public License (GPL). Finally, Oracle will be contributing previously commercial features to OpenJDK such as Java Flight Recorder in Oracle JDK with the goal of making Oracle JDK and OpenJDK more aligned. 

Java EE 8

Oracle has also announced its intention to move Java EE technologies to the Eclipse Foundation, in collaboration with other vendors and the community. Oracle, Eclipse and other community members are now working out the details behind the technology transfer and ongoing governance and process within the Eclipse community.

"Today’s major release of the Java Platform Enterprise Edition is one we think developers are going to be excited to use and by open sourcing Java EE technologies to the Eclipse Foundation, we have set it up for ongoing success in the future," said Mike Lehmann, vice president of product management, Oracle. "Oracle is committed to working with the Java EE community and the Eclipse Foundation to continue enterprise Java innovation, support and evolution."

Key features in Java EE 8 include:

  • HTTP/2 support in Servlet 4.0
  • New JSON binding API and various enhancements in JSON-P 1.1
  • Expansion of JAX-RS to support Server-Sent Events and a new reactive client API
  • New security API for cloud and PaaS based applications
  • Multiple CDI enhancements including support for asynchronous events

For a full list of features included in Java EE 8, please visit this page.

Java is the world’s most popular programming language, with over 12 million developers running Java and more than 1 billion downloads each year. Java is also the #1 developer choice for cloud, with over 21 billion cloud-connected Java virtual machines.

Contact Info
Alex Shapiro
Oracle
4156085044
alex.shapiro@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Alex Shapiro

  • 4156085044

Schema - Objects - Internal Tables

Tom Kyte - Thu, 2017-09-21 13:46
In studying aspects of oracle a realize that the schema concept is quite elaborate and that they are many internal tables that I can reference. For example, I came across this code SELECT table_name from all_tables where owner = 'My_Schema_Na...
Categories: DBA Blogs

Modify an attribute to having GENERATED AS IDENTITY

Tom Kyte - Thu, 2017-09-21 13:46
I created a table x with PK x_key_id as NUMBER. I also created a sequence to be able to increment this key. Now, we have upgraded to 12C and I want to take advantage of oracle's embedded "sequence" Creating a new table y with the surrogate key ...
Categories: DBA Blogs

Time difference

Tom Kyte - Thu, 2017-09-21 13:46
Hi Tom, <code>select '21.00' - '21.30' from dual</code> I need the time difference as .5 instead of 0.30 for my calculation. Regards, Rajarajan.M
Categories: DBA Blogs

Removing # from the columns returned by regexp_substr

Tom Kyte - Thu, 2017-09-21 13:46
Hi, I have following sql query: <code>with texttab as ( SELECT ROOT_CAUSE as text from cust_bug_data where ROOT_CAUSE is not NULL ) SELECT regexp_substr(text,'\#[a-z0-9_]+',1,level,'i') as tag FROM texttab CONNECT BY regexp_substr(te...
Categories: DBA Blogs

extract numbers from varchar2 upto first occurrence of a non-numeric value

Tom Kyte - Thu, 2017-09-21 13:46
On Oracle12 database, we have this table tbl_house_number that has one column "house_number" which is a varchar2 and has data entries of all different combinations. And all I need is the numbers from left to the first occurrence of a non-numeric li...
Categories: DBA Blogs

How to Group Rows into Buckets Based on Chunk Size

Tom Kyte - Thu, 2017-09-21 13:46
Hi Chirs/Connor, LiveSQL: https://livesql.oracle.com/apex/livesql/s/flfiwlt4m3yqb6v2tync6gr4o I have a table test, from that i want to get the details as follows: Get the no of chunk having file size <= 2GB E.g. id = 1,2,3 sum of these three ...
Categories: DBA Blogs

Changing Select_Catalog_Role Privileges

Tom Kyte - Thu, 2017-09-21 13:46
Hello, I need to customize the Select_Catalog_Role taking out some Grants but don't have the necesary previledges. Can you please tell me what previledge I need? Thanks Patrick
Categories: DBA Blogs

How to track long running sql query

Tom Kyte - Thu, 2017-09-21 13:46
Using V$SESSION_LONGOPS View, How can DBA self check long running query and also help to find out most resources consume?
Categories: DBA Blogs

Joining multiple tables inside a UPDATE statement

Tom Kyte - Thu, 2017-09-21 13:46
Hello Tom, Need your feedback on joining multiple tables inside UPDATE statement Scenario: i want to update a column value of table 'a' based on the reference/key value in table 'd'. Below is my query. It's working good for small number of record...
Categories: DBA Blogs

Setting up Oracle Event Hub (Apache Kafka) Cloud Service and Pub & Sub from local Node Kafka client

Amis Blog - Thu, 2017-09-21 13:43

Oracle offers an Event Bus Cloud Service – an enterprise grade Apache Kafka instance – with large numbers of partitions and topics, (retained) messages and distributed nodes. Setting up this cloud service is simple enough – especially once you know what to do, as I will demonstrate in this article. In order to communicate with this Event Bus from a local client – in this case created with Node – we need to open up some ports for access from the public internet.

The steps I went through:

  • create Oracle Event Hub Cloud Service – Platform instance (the Kafka & Zookeeper instance)
  • create Oracle Event Hub Cloud Service – Service instance (a Topic)
  • create two network rules to allow access from the public internet to ports 2181 – Zookeeper – and 6667 – Kafka Server)
  • create two Node applications using the kafka-node package – one to produce and one to consume (based on the work done by Kunal Rupani of Oracle (GitHub: https://github.com/kunalrupani/OracleEventHubConsumer)

Note: the Event Hub Cloud Service is a metered service, billed per hour. The cost for the smallest shape is around $0,70 per hour (or $200/month for non metered).

Create Oracle Event Hub Cloud Service – Platform instance (the Kafka & Zookeeper instance)

image

image

image

imageimage

SNAGHTML23dbd55a


Create Oracle Event Hub Cloud Service – Service instance (a Topic)

Switch to the Big Data Compute CS and select the service category Oracle Event Hub Cloud Service –Topics.

SNAGHTML23dcc70d

image

image

image

image

Create two network rules to allow access from the public internet to ports 2181 – Zookeeper – and 6667 – Kafka Server)

SNAGHTML23de6174

image

SNAGHTML23ded01c

image

Create two Node applications using the kafka-node package

one to produce and one to consume (based on the work done by Kunal Rupani of Oracle (GitHub: https://github.com/kunalrupani/OracleEventHubConsumer)

    Note: the topic was created as microEventBus. The actual name under which it is accessed is partnercloud17-microEventBus (which is identity domain as prefix to the topic name)

    The package.json contains the dependency on kafka-node:

    image

    The straightforward code for producing to the Event Hub Kafka Topic:

    var EVENT_HUB_PUBLIC_IP = '129.xxxxxxxx';
    var TOPIC_NAME = 'partnercloud17-microEventBus';
    var ZOOKEEPER_PORT = 2181;
    
    var kafka = require('kafka-node');
    var Producer = kafka.Producer;
    var client = new kafka.Client(EVENT_HUB_PUBLIC_IP + ':'+ZOOKEEPER_PORT);
    var producer = new Producer(client);
    
    let payloads = [
      { topic: TOPIC_NAME, messages: '*', partition: 0 }
    ];
    
    console.log(payloads[0].messages);
    setInterval(function () {
      console.log('called about every 1 second');
      producer.send(payloads, function (err, data) {
        if (err) {
          console.error(err);
        }
        console.log(data);
      });
      if (payloads[0].messages.length < 10) {
        payloads[0].messages = payloads[0].messages + "*";
      }
      else {
        payloads[0].messages = "*";
      }
    }, 1000);
    
    

    And the similar code for consuming. Note that the producer talks to Zookeeper (port 2181) and the consumer to the Kafka Server itself (port 6667):

    var EVENT_HUB_PUBLIC_IP = '129xxxxxxx';
    var TOPIC_NAME = 'partnercloud17-microEventBus';
    var KAFKA_SERVER_PORT = 6667;
    
    var kafka = require('kafka-node'),
        Consumer = kafka.Consumer,
        client = new kafka.KafkaClient({ "kafkaHost": EVENT_HUB_PUBLIC_IP + ':' + KAFKA_SERVER_PORT }),
        consumer = new Consumer(
            client,
            [
                { topic: TOPIC_NAME, offset: 1 }
            ],
            {
                autoCommit: false,
                fromOffset: true
            }
        );
    
    consumer.on('message', function (message) {
        console.log(message.value)
    });
    

    Here is the output for producing:

    image

    and here for consuming:

    image

    The post Setting up Oracle Event Hub (Apache Kafka) Cloud Service and Pub & Sub from local Node Kafka client appeared first on AMIS Oracle and Java Blog.

    list targets

    Laurent Schneider - Thu, 2017-09-21 11:04

    $p=new XML::Parser;$p->setHandlers(Start=>&b);$p->parsefile("-");sub b{($i,$e,%a)=@_;if($e eq"Target"){print$a{"NAME"}.":".$a{"TYPE"}}}

    — laurentsch (@laurentsch) September 19, 2017

    As correctly pointed out by dhoogfr , the proper way to list targets on an agent is to use list target

    
    $ emctl config agent listtargets
    Oracle Enterprise Manager Cloud Control 13c Release 2
    Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
    [srv01.example.com, host]
    [srv01.example.com:3872, oracle_emd]
    [agent13c2_2_srv01.example.com_3830, oracle_home]
    [DB01.example.com, oracle_database]
    [OraDB12Home1_14_srv01.example.com_743, oracle_home]
    [DB01_srv01.example.com_CDBROOT, oracle_pdb]
    [DB01_srv01.example.com_PDB01, oracle_pdb]
    [LISTENER001_srv01.example.com, oracle_listener]
    

    Not really easy to parse, and it does not contain all information. Let’s imagine I want to get the TARGET_NAME out of my SID? hard…

    What is actually emctl doing ? It is parsing the targets.xml with perl. Oracle wrote a module, called ias::simpleXPath, that helps parsing the file.

    
    $AGENT_HOME/perl/bin/perl -l -I$AGENT_HOME/sysman/admin/scripts -Mias::simpleXPath -e '
      foreach $t(
        simpleXPathQueryForNodes(
          "targets.xml","Targets/Target")){
        print 
          "[".($t->{"attributes"}->{"NAME"}).
          ", ".($t->{"attributes"}->{"TYPE"}).
          "]"}'
    

    ias::simpleXPath is a wrapper for XML::Parser. XML::Parser is a supported perl that is included in the agent home. So no need to install your own perl modules for this purpose!

    back to by example, if I want to get the target name for my SID DB01

    
    $AGENT_HOME/perl/bin/perl -l -MXML::Parser -e '
      $xmlfile = "targets.xml";
      die "Cannot find file $xmlfile"
        unless -f $xmlfile;
      $parser = new XML::Parser;
      $parser->setHandlers(
        Start => \&startElement,
        End => \&endElement);
      $parser->parsefile($xmlfile);
      sub startElement {
        ( $parseinst, $element, %attrs ) = @_;
        if ($element eq "Target") {
          $tn=$attrs{"NAME"};
          $tt=$attrs{"TYPE"};
        }
        if ($element eq "Property" &&
            $attrs{"NAME"} eq "SID" ) {
          $sid=$attrs{"VALUE"};
        }
      }
      sub endElement {
        ( $parseinst, $element ) = @_;
        if ($element eq "Target"){
          if (
            lc $sid eq lc "DB01"
          ) {
            print $tn . ":" . $tt;
          }
          $sid="";
        }
      }
    '
    DB01.example.com:oracle_database
    

    This could be useful, for instance if you want to start a blackout

    
    emctl start blackout db01_black DB01.example.com:oracle_database
    

    For listener, you could retrieve the LsnrName for your listener LISTENER001

    
    $AGENT_HOME/perl/bin/perl -l -MXML::Parser -e '
      $xmlfile = "targets.xml";
      die "Cannot find file $xmlfile"
        unless -f $xmlfile;
      $parser = new XML::Parser;
      $parser->setHandlers(
        Start => \&startElement,
        End => \&endElement);
      $parser->parsefile($xmlfile);
      sub startElement {
        ( $parseinst, $element, %attrs ) = @_;
        if ($element eq "Target") {
          $tn=$attrs{"NAME"};
          $tt=$attrs{"TYPE"};
        }
        if ($element eq "Property" &&
            $attrs{"NAME"} eq "LsnrName" ) {
          $lsn=$attrs{"VALUE"};
        }
      }
      sub endElement {
        ( $parseinst, $element ) = @_;
        if ($element eq "Target"){
          if (
            lc $lsn eq lc "LISTENER001"
          ) {
            print $tn . ":" . $tt;
          }
          $lsn="";
        }
      }
    '
    LISTENER001_srv01.example.com:oracle_listener
    

    Which you could also blackout before rebooting.

    The parser is not limited to Entreprise Manager targets, you could use it for oraInventory/ContentsXML/inventory.xml or whatever files.

    There are plenty of other mean to read xml, from the database, xmllint, powershell.

    Oracle WebCenter Enterprise Capture Overview

    Oracle WebCenter Enterprise Capture can help resolve many frustrations companies experience. Questionable data integrity, lengthy check-in processes, wasting of resources (time, paper, etc.) are common day-to-day frustrations in many companies.  Oracle WebCenter Enterprise Capture strives to remove some of this headache and much more, all packaged in a user-friendly, web-based interface. I’ve helped several customers work through the process from design to go-live, and hope to share my experience on document capturing solutions.

    WebCenter Enterprise Capture is a document capturing tool that includes an initial review for the documents captured by the system. Images can be captured in four different ways: manual upload, scanner, shared directory, or email. All documents can then be automatically released to a commit process or enter a review state. When a document enters the review state, the user can go into the system and view the item and/or define metadata. Also, multiple metadata profiles can be configured so multiple document types can be scanned or uploaded.

    Once a document has been reviewed and released this will move to a defined commit processor. There are four different commit profiles. These four commit profiles are WebCenter Content, WebCenter Content Imaging, Oracle Document Cloud Service, or Text File. The defined commit profiles allow content to be easily linked to Oracle products. This helps alleviate issues associated with creating a custom commit driver that will have to be maintained for custom solutions.

    Government Use Case

    A scenario that a government company may run into is that they are drowning in paper. They will have file rooms filled floor to ceiling with paper documents because of retention policy. Storing large amount of paper documents introduces issues for space as well as time-to-access. Many companies will agree that rooms that are storing documents could have a better use, and that those who spend time digging through those rooms to find those document would likely prefer to be anywhere else.

    WebCenter Enterprise Capture can be a great solution for this issue. This allows incoming documents to be stored electronically, removing the necessity of storing a physical copy. In this scenario, WebCenter Enterprise Capture is used to capture all incoming documents. Documents can then be automatically checked into Oracle WebCenter Content, or another content management system. WebCenter Content server can be configured to meet retention policy standards. Also, this solution provides an easy search experience, so users can quickly search for and locate documents.  What once was a frustrating, time-consuming, and potentially sweat-inducing process is now done in the click of a button. 

    Now with this solution comes another major benefit. When documents are stored as paper, companies run the risk of disaster recovery. Paper documents are vulnerable to damage in many ways. When documents are stored electronically they can be recovered or restored from backups to minimize total loss.

    Construction Company Use Case

    Companies may also find frustration with a complicated process to check-in documents. Every company is always looking for the easiest way to get data into a content server. Along with the complexity to get content into the server comes an issue of associating the metadata to the document. WebCenter Enterprise Capture can help resolve this frustration by taking advantage of database lookups and an automated check-in process.

    In this scenario, all documents are associated to a unique reference number. This unique reference number is stored in a database that has all associated metadata values for that document. In this solution, an email profile is configured for WebCenter Enterprise Capture to watch for documents entering the system. The subject line will always contain the unique reference number. Once a document is pulled into WebCenter Enterprise Capture the database lookup is triggered to populate all metadata. If there are no errors, this document is released to the content server and checked-in.

    This provides two major benefits. The first is that metadata will remain consistent because users do not have to manually type in all the metadata. The other is that by simply sending an email the document is checked in. This reduces the amount of time spent on checking in documents.  Moral of the story: the metadata is now in alignment with the database, the document will be easier to find because of increased data integrity, and the users spent less time getting the document stored correctly. Win-win-win.

    Advantages Over Third Party Applications

    The first major benefit to using WebCenter Enterprise Capture is that the system is in an upgrade-able state. When using Third Party scanning applications, there is always a high risk of not being able to patch or upgrade other Oracle software because these applications have not been certified or integrated with the new application version. This can also increase the complexity of your solutions and make upgrades grueling or–potentially–fail completely.

    The second major benefit is being able to take advantage of Enterprise Capture commit profiles. These profiles are designed in a way to map all data within an interface. In a third-party application, this will need to be developed to be able to map all data. This will lead to customizations which take more effort/time to develop and maintain.

    Overall, the time, effort, development, and customization for a third-party application is not as effective as WebCenter Enterprise Capture. WebCenter Enterprise Capture provides more reliability than third party applications.

    Tips

    When configuring WebCenter Enterprise Capture, it is best practice to think about using database lookups and choice lists. This will provide two benefits. The first being that users will be able to reduce the time to populate metadata fields. The second being that metadata will have greater consistency.

    The email upload option in WebCenter Enterprise Capture is an option commonly used when data is being sent to a company externally. This currently only supports IMAP email configuration. If POP3 email configuration is being used, WebCenter Enterprise Capture will not be able to be configured with the email upload. This is an issue that Fishbowl Solutions has run into in the past. If it is not possible to change the email protocol, one option that can be configured is the directory upload. This will allow users to manually drop files off in a filesystem location, or if this was from a multifunctional scanner, a profile can be configured to drop off to the shared watch directory. These files are then ready for Capture.

    Conclusion

    Overall, WebCenter Enterprise Capture is a document capturing tool that can resolve business problems or help alleviate struggles with current configurations. This tool is very flexible on how documents can be captured and committed. By using an Oracle product, there is not a fear with patching or upgrading software compared to using third-party applications. When trying to resolve problems with document capture, metadata consistency, and easier check-in processes, this product should be considered as a viable solution.

    WebCenter Enterprise Capture Overview

    Oracle WebCenter Enterprise Capture can help resolve many frustrations companies are experiencing such as, removing unwanted paper, easier check-in process, data integrity, and many more. In my experience, I have found that WebCenter Enterprise Captures interface to be user friendly.

    WebCenter Enterprise Capture is a document capturing tool that includes an initial review for the documents being captured. Images can be captured in four different ways manual upload, scanner, shared directory, or email. All documents then can be automatically released to a commit process or enter a review state. When a user is in the review state the document can be viewed and metadata can be defined. Also, Multiple metadata profiles can be configured so multiple document types can be scanned or uploaded.

    Once a document has been reviewed and released this will move to a defined commit processor. There are four different commit profiles. These four commit profiles are WebCenter Content, WebCenter Content Imaging, Oracle Document Cloud Service, or Text File. The defined commit profiles allow content to be easily linked to Oracle Products. This helps alleviate issues associated with creating a custom commit driver that will have to be maintained in custom solutions.

    Government Use Case

    A scenario that a Government company may run into is that they are drowning in paper. They will have file rooms filled floor to ceiling with paper documents because of retention policy. Storing large amount of paper documents introduces issues for space. Many companies will agree that rooms that are storing documents could have a better use.

    WebCenter Enterprise Capture can be a great solution for this issue. This allows incoming documents to be stored electronically. This prevents the issue of having to store documents as paper. In this scenario WebCenter Enterprise Capture is used to capture all incoming documents. This then will check items directly into the Content server for storage. WebCenter Content server can be configured to meet retention policy standards. Also, this solution will provide a benefit that will allows users to use search capabilities to locate documents. This will help alleviate time searching in a file rooms for documents and allow the users to just click a button to search.

    Now with this solution comes another major benefit. When documents are stored as paper companies run the risk of disaster recovery. Paper documents are vulnerable to damage in many ways. When documents are stored electronically they can be recovered or restored from backups to minimize total loss.

    Construction Company Use Case

    Companies can run into a frustration with a complicated process to check in documents to the content server. Every company is always looking for the easiest way to get data into a content server. Along with the complexity to get content into the server comes an issue of associating the metadata to the document. WebCenter Enterprise Capture can help resolve this frustration by taking advantage of database lookups and an automated check-in process.

    In this scenario, all documents are associated to a unique reference number. This unique reference number is stored in a database that has all associated metadata values for that document. In this solution, an email profile was configured for WebCenter Enterprise Capture to watch for documents entering the system. The subject line will always contain the unique reference number. Once a document is pulled into WebCenter Enterprise Capture the database lookup is triggered to populate all data. If there are no errors this document is released to the content server and check-in.

    This provides two major benefits. The first is that data will remain very consistent because users do not have to manually type in all the metadata. The other is that simply by sending an email the document will be checked in. This reduces the amount of time spent on checking documents in. So, users reduce the time to check an item in and increases the ease-ability to find documents in the content server.

    Advantages Over Third Party Applications

    The first major benefit to using WebCenter Enterprise Capture is being in an upgradable state. When using Third Party scanning applications there is always a high risk of not being able to patch or upgrade other Oracle software because these applications have not been certified or integrated with the new application version. This can also increase the complexity of your solutions and make upgrades grueling and ultimately not work at all.

    The second major benefit is being able to take advantage of Enterprise Capture commit profiles. These profiles are designed in a way to map all data in an interface. In a third-party application, this will need to be developed to be able to map all data. This will lead to customizations and more effort/time to develop.

    Overall the time effort, development, and customization for a third-party application is not as effective as WebCenter Enterprise Capture. WebCenter Enterprise Capture provides more reliability than third party applications.

    Tips

    When configuring WebCenter Enterprise Capture it is always best practices to think about using Database Lookups and Choice Lists. This will provide two benefits. The first being the users will be able to reduce the time to populate metadata fields and the second being that metadata in a stored state will have improved consistency of data.

    The email upload option in WebCenter Enterprise Capture is an option commonly used when data is being sent to a company externally. This currently only supports IMAP email configuration. If POP3 email configuration is being used WebCenter Enterprise Capture will not be able to be configured with the email upload. This is an issue the Fishbowl Solutions has ran into in the past. If it is not possible to change the Email protocol one option that can be configured to be used is the directory upload. This will allow users to manually drop those files off or if this was from a multifunctional scanner a profile can be configured to drop off to the shared watch directory for upload.

    Conclusion

    Overall, WebCenter Enterprise Capture is a document capturing tool that can resolve business problems or help alleviate struggles with current configurations. This tool is very flexible on how documents can be captured and committed. By using an Oracle product there is not a fear with patching or upgrading software compared to using third-party applications. When trying to resolve problems with document capture, metadata consistency, and easier check-in processes this product should be considered as a possible solution.

    The post Oracle WebCenter Enterprise Capture Overview appeared first on Fishbowl Solutions.

    Categories: Fusion Middleware, Other

    Nextcloud configuration

    Frank van Bortel - Thu, 2017-09-21 10:42
    Nextcloud configuration issues on Debian 9 Stretch In an attempt to get email and storage fixed, I am trying to get dovecot, postfix and nextcloud to integrate. With varying levels of success - what else is new? Anyway, nextcloud greets with the fact I do not have OPcache enabled, and I should add to php.ini. WRONG NOT php.ini So, I did... I added opcache.enable=1 opcache.enable_cli=1 Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.com0

    Oracle to Hold Annual Project Portfolio Management Day in South Africa

    Oracle Press Releases - Thu, 2017-09-21 08:00
    Press Release
    Oracle to Hold Annual Project Portfolio Management Day in South Africa Customers, industry experts to share insights into improving project delivery

    Redwood Shores, Calif.—Sep 21, 2017

    Today Oracle Construction and Engineering will host its annual Project Portfolio Management Day event in Johannesburg. Project management community peers and thought leaders will gather at the exclusive event to share knowledge and best practices to improve project planning and delivery. The event will take place at Summer Place in Hyde Park.

    “The annual Project Portfolio Management Day provides a dynamic forum for a cross section of business and public organizations to come together and discuss the strategies and solutions they are applying to transform their organizations,” said Mike Sicilia, Senior Vice President and General Manager, Oracle Construction and Engineering.

    Moritz Botha, Director, eTendering at the National Treasury of South Africa, will deliver a keynote address. In addition, Mike Sicilia will discuss Oracle Construction and Engineering’s strategic vision to empower organizations to improve project and program management outcomes in a session called Building the World of Tomorrow.

    The program will feature sessions exploring the event theme of Business Modernization Through Digital Transformation and will also include the following speakers:

    • Rubin Boer, Senior Business Analyst, PetroSA
    • Vaughn Harris, Director, BIM Institute
    • Daniel Birch, Senior Consultant, PWC
    • Corli Janse Van Rensburg, General Manager, Transnet Group Capital

    For more information about the event, or to register to attend, please visit: Oracle's Annual Project Portfolio Management Day

    Oracle Construction and Engineering helps companies reimagine their businesses. With best-in-class project management solutions, organizations can proactively manage projects, gain complete visibility, improve collaboration, and manage change. Our cloud-based solutions for global project planning and execution can help improve strategy execution, operations, and financial performance. For more information, please visit www.oracle.com/construction-and-engineering.

    Contact Info
    Natassia Badenhorst
    Manager, Corporate Communications, South Africa & Sub Saharan Africa, Oracle
    +27 11 319 4753
    tash.badenhorst@oracle.com
    Judi Palmer
    Senior Manager, Oracle Industries, United States
    +1 650 506 0266
    judi.palmer@oracle.com
    About Oracle

    The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

    Trademarks

    Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

    Talk to a Press Contact

    Natassia Badenhorst

    • +27 11 319 4753

    Judi Palmer

    • +1 650 506 0266

    Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives

    Yann Neuhaus - Thu, 2017-09-21 07:09

    Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in that configuration but we did not had any other instance up and running at that time):

    This:

    ORA-00700: soft internal error, arguments: [dbgrfrbf_1], [/disk00/app/grid/diag/asm/+asm/+ASM2/metadata/INC_METER_SUMMARY.ams], [0], [4], [], [], [], [], [], [], [], []
    ORA-27072: File I/O error
    Linux-x86_64 Error: 22: Invalid argument
    Additional information: 4
    Additional information: 1
    Additional information: 4294967295
    

    … and this:

    ERROR: create the ADR schema in the specified ADR Base directory [/disk00/app/grid]
    ERROR: The ORA-48178 error is caused by the ORA-48101 error. 
    ORA-48101: error encountered when attempting to read a file [block] [/disk00/app/grid/diag/asm/+asm/+ASM1/metadata/ADR_INTERNAL.mif] [0]
    ORA-27072: File I/O error
    Linux-x86_64 Error: 22: Invalid argument
    Additional information: 4
    Additional information: 1
    Additional information: 4294967295
    

    As it turned out this was an issue with the xfs block size. In the configuration we had the block size was set to 4096 (this was chosen by default when the file system got created):

    $:/disk00/app/grid/diag/asm/+asm/+ASM1/metadata/ [+ASM1] xfs_info /disk00
    meta-data=/dev/mapper/vg_root-lv_disk00 isize=512    agcount=4, agsize=13107200 blks
             =                       sectsz=4096  attr=2, projid32bit=1
             =                       crc=1        finobt=0 spinodes=0
    data     =                       bsize=4096   blocks=52428800, imaxpct=25
             =                       sunit=0      swidth=0 blks
    naming   =version 2              bsize=4096   ascii-ci=0 ftype=1
    log      =internal               bsize=4096   blocks=25600, version=2
             =                       sectsz=4096  sunit=1 blks, lazy-count=1
    realtime =none                   extsz=4096   blocks=0, rtextents=0
    $:/disk00/app/grid/diag/asm/+asm/+ASM1/metadata/ [+ASM1] 
    

    After changing that to 512 all was fine again:

    $:/home/ [+ASM1] xfs_info /disk00/
    meta-data=/dev/mapper/disk00     isize=256    agcount=4, agsize=104857600 blks
             =                       sectsz=512   attr=2, projid32bit=1
             =                       crc=0        finobt=0 spinodes=0
    data     =                       bsize=512    blocks=419430400, imaxpct=25
             =                       sunit=0      swidth=0 blks
    naming   =version 2              bsize=4096   ascii-ci=0 ftype=1
    log      =internal               bsize=512    blocks=204800, version=2
             =                       sectsz=512   sunit=0 blks, lazy-count=1
    realtime =none                   extsz=4096   blocks=0, rtextents=0
    $:/home/ [+ASM1] 
    

    Indeed this was not so easy because the Cisco UCS systems we used for that came with internal disks that had a 4k sector size so we couldn’t even create a new xfs file system on that with the settings required.

    [root@xxxx ~]# mkfs.xfs -s size=512 -m crc=0 -b size=512
            /dev/mapper/vg_root-lv_disk00_test 
    
          illegal sector size 512; hwsector is 4096
    

    The solution was to get a LUN from the storage and use that instead. Another important note from the above linked data sheet:

    NOTE: 4K format drives are supported and qualified as bootable with Cisco UCS Manager Release 3.1(2b)and later versions. However, 4K sector format drives do not support VMware and require UEFI boot.

    Be careful …

     

    Cet article Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives est apparu en premier sur Blog dbi services.

    Oracle Named a Leader in 2017 Analyst Evaluation for Enterprise BI Platforms with Majority Cloud Deployments

    Oracle Press Releases - Thu, 2017-09-21 07:00
    Press Release
    Oracle Named a Leader in 2017 Analyst Evaluation for Enterprise BI Platforms with Majority Cloud Deployments Oracle positioned as a leader in Business Intelligence for a broad and deep large-enterprise-grade BI portfolio

    Redwood Shores, Calif.—Sep 21, 2017

    Oracle today announced that Forrester Research has named Oracle a leader in its “The Forrester Wave™: Enterprise BI Platforms with Majority Cloud Deployments, Q3 2017” report. This placement confirms Oracle Analytics Cloud as a leader in the analytics space.

    “By offering a single, integrated platform capable of serving all of an enterprises’ analytics needs, including self-service data visualization, data preparation, embedded machine learning and predictive analytics, Oracle Analytics Cloud helps businesses improve efficiencies and drive innovation,” said Rich Clayton, vice president product management, Oracle. “Our unique, comprehensive platform can address the needs of executives, analysts and data engineers while helping reduce the time and financial resources necessary to integrate and optimize a plethora of technologies for data-driven innovation.”

    In Forrester’s 22-criteria evaluation of enterprise business intelligence platforms with majority cloud-deployment providers, Forrester identified the 10 most significant vendors and researched, analyzed, and scored them.  

    Forrester notes: “With Oracle Analytics Cloud, Oracle supports the complete spectrum of BI needs at enterprise scale, ranging from self-service analytics to complex requirements leveraging Essbase’s powerful MOLAP engine. The vendor can also support hybrid scenarios. Comprehensive advanced analytics capabilities and natural language functions round out the offering. Customers of Oracle’s other applications (e.g., CRM or ERP) can gain additional benefits from the Common Enterprise Information Model, as the semantic layer extends across products. Existing Oracle customers will also welcome the increased licensing flexibility. With Oracle Day by Day, Oracle has made a fresh start on mobile, focusing on users’ information needs rather than on simple BI delivery.”

    Part of Oracle Cloud Platform, Oracle Analytics Cloud provides the industry’s most comprehensive cloud analytics in a single, unified platform, including everything from self-service visualization and powerful inline data preparation to enterprise reporting, advanced analytics, and self-learning analytics that deliver proactive insights. With support for more than 50 data sources and an extensible, open framework, Oracle Analytics Cloud gives customers a complete, connected, collaborative platform that brings the power of data and analytics to every process, interaction, and decision in any environment – cloud, on-premises, desktop and data center. Oracle Analytics Cloud has experienced significant growth in 2017, tripling adoption in the last 12 months. In addition, Oracle recently introduced two innovative mobile applications – that leverage machine learning and natural language processing – Oracle Analytics Cloud Day by Day and Oracle Analytics Cloud Synopsis. Respectively, these applications deliver proactive analytics and visual analysis to mobile devices, helping ensure the right information is always available and actionable.

    Contact Info
    Jesse Caputo
    Oracle
    +1.650.506.5967
    jesse.caputo@oracle.com
    Sarah Fraser
    Oracle
    +1.650.743.0660
    sarah.fraser@oracle.com
    About Oracle

    The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe, and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

    Trademarks

    Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

    Talk to a Press Contact

    Jesse Caputo

    • +1.650.506.5967

    Sarah Fraser

    • +1.650.743.0660

    Pages

    Subscribe to Oracle FAQ aggregator