Feed aggregator

Looking inside #OOW16 session: Empower the Mobile Workforce using Oracle Content and Experience Cloud (CON7271)

WebCenter Team - Thu, 2016-09-15 16:00
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Mobile is transforming every facet of modern society. As a result, companies are finding that with the changing digital landscape, user’s expectations have changed, not just as a consumers but as employees too. The pervasiveness of digital technology and the convenience of it has permeated into our work world making line of business users more technology savvy, expecting digital convenience in the workplace as well.

Along with this powerful trend Cloud is transforming every facet of the IT infrastructure so in a world where work is no longer dictated by location and spans not just geography but our ecosystem – employees, partners, suppliers and customers, as well as channels – web, mobile, social, how can you empower your users to drive effective mobile collaboration?

At Oracle OpenWorld this year, Oracle executive and the product management lead for Oracle solutions for Digital Experience, David le Strat, would be discussing mobile collaboration in his overarching product strategy session on Monday, September 19 at 11 a.m. in Moscone W 2014. Learn more about his session here.

From there, in this session, we will get into the detail roadmap and strategy on how we are focusing on empowering our millennial, mobile workforce with our content management and experience management solutions.

So, if you are heading to Oracle OpenWorld next week, don’t miss:

Empower the Mobile Workforce using Oracle Content and Experience Cloud [CON7271]

Wednesday, September 21, 3 pm
Moscone West—2018

We’ll discuss how the Oracle Content and Experience Cloud can help companies empower their mobile workforce.

Learn how Oracle Documents Cloud Service and Oracle Sites Cloud Service are providing you with a single platform to drive mobile content collaboration. We’ll be covering how our mobile features allow workers to carry out effective mobile collaboration and design mobile optimized experiences. The session will also cover our longer term roadmap and vison where our focus is on being a best-in-class Mobile App for all things related to Content Collaboration – ease of access, edit & review workflow and messaging.

You will also hear from one of our partners, Jason Stortz, Principal Consultant, from Redstone Content Solution who have been busy further extending the mobile collaborative capabilities of the Oracle Content and Experience Cloud. They will show you how to secure signatures on a contract right from your mobile device and discuss how they can help you build mobile optimized experiences using the Oracle Content and Experience Cloud.

And catch the live demos of the solution and engage with us on solution, roadmap, use cases discussions - this is your opportunity to connect with us and get your questions answered live.

Add to your My Schedule today:

Empower the Mobile Workforce using Oracle Content and Experience Cloud [CON7271]

Wednesday, September 21, 3 pm
Moscone West—2018

For a complete listing of all things Digital Experience don’t miss our recently launched website, https://sites.oracle.com/oowdx/, Btw, the site is built on Oracle Sites Cloud Service with Oracle Documents Cloud Service as its underlying content repository! Works great on mobile devices as well!

And join the conversation on twitter using #OOW16 and #OracleDX. Tweet along and you will see your tweets show up on the site too!

See you at OOW16 then!

HelloSign Now Integrates With Oracle Documents Cloud!

WebCenter Team - Thu, 2016-09-15 15:12

Just in time for Oracle OpenWorld, we recently announced that HelloSign now integrates with Oracle Documents Cloud!

You can integrate HelloSign with Oracle Documents Cloud to request signatures for your contracts, agreements, and waivers. You can check the signature status in real time, and the signed document is automatically saved in Documents Cloud for easy access. 

Want to learn more? Check out this blog post to learn how you can have a paperless future with Oracle Documents Cloud. Heading to Oracle OpenWorld? Be sure to add this session to My Schedule so you can see a demonstration and learn how you can now access important documents and agreements from the Documents Cloud interface and send them out for signature with a few clicks.

Deep-Dive into Content, Collaboration and Digital Signatures in the Cloud [CON7266] 
Thursday, Sep 22, 12:00 p.m. | Moscone West - 2014

For a complete listing of all things Digital Experience don’t miss our recently launched #OOW16 website: Content and Experience at Oracle Open World 2016.

And please follow along and join the conversations on our social media channels! #OOW16 and #OracleDX


Oracle Press Releases - Thu, 2016-09-15 15:05
Press Release
Q1 FY17 GAAP SAAS AND PAAS REVENUES WERE UP 77%, AND UP 79% IN CONSTANT CURRENCY Q1 FY17 Non-GAAP SaaS and PaaS Revenues grew 82% in Constant Currency

Redwood Shores, Calif.—Sep 15, 2016

Oracle Corporation (NYSE: ORCL) today announced fiscal 2017 Q1 results. Total Revenues were $8.6 billion, up 2% in U.S. dollars and up 3% in constant currency. Cloud plus On-Premise Software Revenues were $6.8 billion, up 5% in U.S. dollars and up 6% in constant currency. Cloud software as a service (SaaS) and platform as a service (PaaS) revenues were $798 million, up 77% in U.S. dollars and up 79% in constant currency. Total Cloud Revenues, including infrastructure as a service (IaaS), were $969 million, up 59% in U.S. dollars and up 61% in constant currency. Operating Income was $2.6 billion and Operating Margin was 31%. Non-GAAP Operating Income was $3.4 billion and non-GAAP Operating Margin was 39%. Net Income was $1.8 billion while non-GAAP Net Income was $2.3 billion. Earnings Per Share was up 10% to $0.43, while non-GAAP Earnings Per Share was up 4% to $0.55. GAAP and non-GAAP Earnings Per Share was negatively impacted by three factors: 1 cent because of a higher tax rate due to more cloud sales being in the U.S, half of one cent because of borrowing, and 1 cent due to strengthening of the U.S. dollar.

Short-term deferred revenues were $9.5 billion, up 4% in U.S. dollars and up 5% in constant currency compared with a year ago. Operating cash flow on a trailing twelve-month basis was $13.7 billion.

“Our Cloud business plus our On-Premise Software business grew 7% in constant currency in the first quarter, on a non-GAAP basis,” said Oracle CEO, Safra Catz. “The overall top-line growth of our two strategic businesses was driven by non-GAAP SaaS and PaaS revenue growing 82% in constant currency, substantially outperforming our guidance. As our SaaS and PaaS business continues its rapid growth, we expect its gross margins to climb from 62% this quarter toward our 80% target.”

“This year we are on track to sell more than $2 billion of SaaS and PaaS annually recurring revenue,” said Oracle CEO, Mark Hurd. “We believe this will be the second year in a row that Oracle has sold more SaaS and PaaS than any cloud services provider. In the first quarter alone, we added more than 750 new SaaS customers including 344 new SaaS Fusion ERP customers—that’s more ERP customers than Workday has sold in the history of their company.”

“Next week at Oracle OpenWorld, we will introduce the second generation of our Infrastructure as a Service,” said Larry Ellison, Oracle Chairman and CTO. “Our Generation2 IaaS delivers twice the compute, twice the memory, four times the storage and ten times more I/O at a 20% lower price than Amazon Web Services. IaaS represents a huge new cloud opportunity for Oracle to layer on top of our rapidly growing SaaS and PaaS businesses.”

The Board of Directors also declared a quarterly cash dividend of $0.15 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 12, 2016, with a payment date of October 26, 2016.

Q1 Fiscal 2017 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and Fiscal 2017 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 77971381.

Contact Info
Ken Bond
Oracle Investor Relations
Deborah Hellinger
Oracle Corporate Communciations
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE: ORCL), visit www.oracle.com or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.


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

"Safe Harbor" Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our expectations of future growth in our SaaS and PaaS gross margins and recurring revenues; our introduction of new products; and the opportunities to grow the IaaS business are all "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our software, hardware, services or Oracle Cloud offerings are compromised or if such offerings contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and financial exposure. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical and market conditions, including the continued slow economic recovery in the U.S. and other parts of the world, can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 15, 2016. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

Purpose of Unique constraint

Tom Kyte - Thu, 2016-09-15 13:26
Hi Tom, I am totally confused about unique constraint. I was reading Oracle Database Concepts 11g Release 2 (11.2), where its written about unique constraint that: <i> A unique key constraint requires that every value in a column or set of co...
Categories: DBA Blogs

divide data in database with specific login id

Tom Kyte - Thu, 2016-09-15 13:26
Hi we have five projects that their all data saved in some tables in database, is there any way so that each project end user should only be able to access only their own project data, and must not able able access any other projects data.
Categories: DBA Blogs

difference of update with rownum without rownum

Tom Kyte - Thu, 2016-09-15 13:26
Hi tom, I have some doubts with below update statement <code>1. UPDATE emp SET empno = rownum; 2. UPDATE emp SET empno = 1;</code> question no 1-- first one executing with out errors and populating column with unique values while s...
Categories: DBA Blogs

Oracle E-Business Suite 12.2.6 Now Available

Steven Chan - Thu, 2016-09-15 10:40
We are pleased to announce that Oracle E-Business Suite Release 12.2.6 is now available.

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:

What Does Release 12.2.6 Include?

As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

For a complete list of new features, refer to:

Common Questions and Answers About Upgrading

  • Q: Is there a direct upgrade path from Release 11i to Release 12.2.6?
    A: No. Release 11i customers must first upgrade to Release 12.2 before applying 12.2.6.
  • Q: Is there a direct upgrade path from EBS 12.0 to 12.2.6?
    A: No. Release 12.0 customers must first upgrade to Release 12.2 before applying 12.2.6.
  • Q: Is there a direct upgrade path from EBS 12.2 to 12.2.6?
  • A: Yes. Release 12.2 customers can apply 12.2.6 directly to their environments. EBS 12.2.6 is an online patch, so it can be applied while an existing Release 12.2 system is running.
Additional References Related Articles
Categories: APPS Blogs

Oracle DECOMPOSE Function with Examples

Complete IT Professional - Thu, 2016-09-15 06:00
The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article. Purpose of the Oracle DECOMPOSE Function The DECOMPOSE function is used to transform a string into a Unicode string. It will split a character with an accent into two separate characters. For example, […]
Categories: Development

#OOW16 Session: Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

WebCenter Team - Thu, 2016-09-15 05:00
Normal 0 false false false EN-US X-NONE X-NONE

Enterprise content is a core component of any organization’s infrastructure. As an Oracle WebCenter customer or a stakeholder you know that Oracle WebCenter Content is a proven unified repository to house unstructured content, enabling organizations to deliver it to business users in the proper format and within the context of familiar applications that fit the way they work. Its document imaging and capture product capabilities provide a streamlined platform for business solutions, leveraging image enablement, application extension, and long-term archiving.

If you are an existing Oracle WebCenter Content and Imaging customer, work with content or are looking at content management and cloud solutions then this is a session you definitely don’t want to miss:

Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

Tuesday, September 20, 2016 | 4:00 p.m. – 4:45 p.m.

Moscone West—2014

Get a complete 360-degree view of the Oracle WebCenter Content product portfolio roadmap, covering content, imaging, capture, and forms recognition and hear directly from the subject matter experts. Learn about the latest releases and product roadmap plans to see how you can leverage those to influence your enterprise strategy. Find out about key application, process and productivity suite integration that can help you drive work agility.

You will have a unique opportunity to hear from a customer organization, McKesson on how they use Oracle WebCenter Imaging product line to help automate their account payables and ordering processes.

This session also provides a great opportunity for you to learn from your peers, hear from experts and get your questions answered about Oracle enterprise content management & imaging suite of products.

Don’t miss:

Oracle WebCenter Content, Imaging, Capture, and Forms Recognition: Strategy and Roadmap [CON7259]

Tuesday, September 20, 2016 | 4:00 p.m. – 4:45 p.m.

Moscone West—2014

And, get all the latest info on all things Content and Experience at #OOW16 directly on your mobile devices from https://sites.oracle.com/oowdx. While there, check out Oracle Mobile Challenge! You may even get “rewarded” to attend this session!!!

And use #OOW16 and #OracleDX to tweet about your session experiences. See you there!

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

What’s the difference between SEMI-JOIN and ANTI-JOIN?

Bar Solutions - Thu, 2016-09-15 04:15

Dear Patrick,

What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN?

Lillian Sturdey

Dear Lillian,

First of all, both SEMI-JOIN and ANTI-JOIN are not in the SQL syntax but they are more a pattern. You might expect to be able to write something like:

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
               FROM dept d
               SEMI JOIN emp e ON (e.deptno = d.deptno)

to get all the departments that have at least one employee.

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
               FROM dept d
               ANTI JOIN emp e ON (e.deptno = d.deptno)

to get the departments with no employees. But all you get is an error saying your command is not properly ended, which can be read as a syntax error.

ERROR at line 3:
ORA-00933: ORA-00933 SQL command not properly ended.

Maybe your first idea would be to use a normal join to get all the departments with at least one employee:

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
               FROM dept d
               JOIN emp e ON (e.deptno = d.deptno)

But this results in a record for every row in the EMP table. And we only wanted every unique department.

    DEPTNO DNAME          LOC
---------- -------------- -------------
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        30 SALES          CHICAGO
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        30 SALES          CHICAGO
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        10 ACCOUNTING     NEW YORK
        30 SALES          CHICAGO
        20 RESEARCH       DALLAS

    DEPTNO DNAME          LOC
---------- -------------- -------------
        30 SALES          CHICAGO
        20 RESEARCH       DALLAS
        10 ACCOUNTING     NEW YORK

14 rows selected.

Well, that’s easy enough, you think, just add a DISTINCT to the statement:

[PATRICK]SQL>SELECT DISTINCT d.deptno, d.dname, d.loc
               FROM dept d
               JOIN emp e ON (e.deptno = d.deptno) 

Exactly the result we are looking for:

    DEPTNO DNAME          LOC
---------- -------------- -------------
        20 RESEARCH       DALLAS
        10 ACCOUNTING     NEW YORK
        30 SALES          CHICAGO

But what if the EMP table contains hundreds, thousands or maybe millions of rows. That would mean the database has to do a lot of work to filter out the distinct values.
A different, and probably better, approach would be to use the SEMI-JOIN pattern. You can use the IN operator like this:

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
              FROM dept d
              WHERE d.deptno IN (SELECT e.deptno
                                   FROM emp e)
    DEPTNO DNAME          LOC
---------- -------------- -------------
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        10 ACCOUNTING     NEW YORK

This is exactly what we want to see but for big tables this is not the correct way to go. For every record in the dept table all the records in the EMP table are checked. Again, if we have a lot of employees, this means a lot of work for the database.
A better SEMI-JOIN to use is the EXISTS operator:

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
               FROM dept d
              WHERE EXISTS (SELECT 1
                              FROM emp e
                             WHERE e.deptno = d.deptno)

Please note that with the current optimizer in the database Oracle will rewrite your query to use the best approach for the task. If the inner table (in our example EMP) is rather small, then the IN approach might be the best, in other cases it might be better to use the EXISTS approach. Where in earlier versions you had to think about which way to go (IN is better for small tables, EXISTS is better for big ones), you can now rely on the optimizer to make the correct choice.
If you would want to see exactly the opposite of this query, i.e. all departments with no employees, you use an ANTI-JOIN pattern, which is pretty much the same but in this case you use NOT IN or NOT EXISTS. A different approach, which I think is pretty nice is to use an OUTER JOIN and check for the non-existence of values in column for the OUTER JOINED table.

[PATRICK]SQL>SELECT d.deptno, d.dname, d.loc
               FROM dept d
               LEFT OUTER JOIN emp e ON (e.deptno = d.deptno)
              WHERE e.empno IS NULL
    DEPTNO DNAME          LOC
---------- -------------- -------------
        40 OPERATIONS     BOSTON

Hope this gives you a bit more insight in this subject and gives you a better understanding of the wonders of the SQL language. Notice there are many ways to reach the same result, but one approach might be more economical than the other.

Happy Oracle’ing,
Patrick Barel

Hope this answers your question.
Happy Oracle’ing,
Patrick Barel

If you have any comments on this subject or you have a question you want answered, please send an email to patrick[at]bar-solutions[dot]com. If I know the answer, or can find it for you, maybe I can help.

This question has been published in OTech Magazine of Winter 2014.

Upgrade yourself from DBA to DMA

Syed Jaffar - Thu, 2016-09-15 04:09
Be it any profession, learning never ends. From my very own personal perspective and exprience, I strongly beleinv in one who upgrade his skills always stays a step ahead from the rest. To stay competitive, it is necessary to upgrade our skills according to the market demand.

For DBA folks who aim and dream to learn and upgrade their knwoledge with Oracle Exadata technologies, I wrote a 5 series article to Toad, below are the links to the articles:

Below are few more Exadata related stuff.

Managing & Troubleshooting Exadata - Upgrading & Patching ExadataShrink/Grow Exadata diskgroups

Pass on the knolwedge to the community.

Happy reading.

Stats time

Jonathan Lewis - Thu, 2016-09-15 03:41

I don’t really remember how long it’s been since Oracle created an automatic log of how long a call to the dbms_stats package took, though it was probably some time in the 10g time-line. It wasn’t until it had been around for several years, though before I wrote little script (possibly prompted by a comment from Martin Widlake) that I’ve used occasionally since to see what’s been going on in the past, how variable stats collection times have been, and what unexpected dbms_stats call an application may have been making. Here’s what it currently looks like:

rem     Script:         optimizer_operations.sql
rem     Author:         Jonathan Lewis
rem     Dated:          May 2010
rem     Purpose:
rem     Last tested
rem     Not tested
rem     Notes:
rem     Simple script to list calls to dbms_stats showing
rem     what they did and how long it took.
rem     Notice that gather_database_stats and gather_schema_stats
rem     don't tell you anything about individual tables.

spool optimizer_operations

column start_time       format a35
column operation        format a28
column target           format a28

column duration         format a12
column max_duration     format a12

column utc_start_time   format a28
column first_utc_time   format a28

        cast(sys_extract_utc(min(start_time)) as timestamp(0))                  first_utc_time,
        to_char(extract(hour from max(end_time - start_time)),'FM00') ||
        ':' ||
        to_char(extract(minute from max(end_time - start_time)),'FM00') ||
        ':' ||
        to_char(round(extract(second from max(end_time - start_time)),2),'FM00.00')     max_duration,
        count(*)        Frequency
group by
order by

        -- start_time,
        cast(sys_extract_utc(start_time) as timestamp(0))                               utc_start_time,
        to_char(extract(hour from (end_time - start_time)),'FM00') ||
        ':' ||
        to_char(extract(minute from (end_time - start_time)),'FM00') ||
        ':' ||
        to_char(round(extract(second from (end_time - start_time)),2),'FM00.00')        duration
        end_time - start_time >= numtodsinterval(2,'SECOND')
and     target is not null
order by

spool off

This version of the script first prints a summary showing how many calls to which operation have occured, the worst case scenario for each, and when the first one happened – in case a recent change has introduced a problem – you might find it useful to include other bits of information, like the min(duration) in the first section, it’s not difficult modify the SQL. The second part of the report is then just a list of the individual calls, with a minimum interesting time included.

And here’s some (camouflagued) output

---------------------------- ---------------------------- ------------ ----------
copy_table_stats             14-JUL-16 11.12.55 PM        00:00:03.43         320
gather_database_stats(auto)  14-JUL-16 06.00.01 AM        01:13:17.25          67
gather_schema_stats          14-JUL-16 04.00.02 AM        05:16:01.22          35
gather_table_stats           14-JUL-16 01.15.59 AM        00:04:07.98         153

OPERATION                    TARGET                             UTC_START_TIME               DURATION
---------------------------- ---------------------------------- ---------------------------- ------------
gather_schema_stats          MY_SCHEMA                          01-AUG-16 04.00.02 AM        04:40:33.03
copy_table_stats             SYS.WRH$_SQLSTAT.WRH$_SQLSTA_24706 01-AUG-16 11.18.15 PM        00:00:02.04

gather_schema_stats          MY_SCHEMA                          02-AUG-16 04.00.02 AM        04:57:39.61
gather_schema_stats          MY_SCHEMA                          03-AUG-16 04.00.02 AM        04:40:10.88
gather_schema_stats          MY_SCHEMA                          04-AUG-16 04.00.02 AM        05:00:48.05
gather_schema_stats          MY_SCHEMA                          05-AUG-16 04.00.03 AM        05:07:42.33
gather_schema_stats          MY_SCHEMA                          06-AUG-16 04.00.02 AM        04:50:39.93
gather_table_stats           SYS.WRI$_ADV_ACTIONS               06-AUG-16 12.42.38 PM        00:00:03.01
gather_table_stats           SYS.WRI$_ADV_FINDINGS              06-AUG-16 12.42.41 PM        00:00:02.94
gather_table_stats           SYS.WRI$_ADV_RECOMMENDATIONS       06-AUG-16 12.42.46 PM        00:00:02.03
gather_table_stats           SYS.WRI$_ADV_SQLT_PLANS            06-AUG-16 12.42.49 PM        00:00:04.45
gather_schema_stats          MY_SCHEMA                          07-AUG-16 04.00.02 AM        04:48:57.23
gather_schema_stats          MY_SCHEMA                          08-AUG-16 04.00.01 AM        04:40:57.81
gather_table_stats           MY_SCHEMA.TABLE_A                  09-AUG-16 01.16.21 AM        00:00:03.61
gather_schema_stats          MY_SCHEMA                          09-AUG-16 04.00.03 AM        04:51:14.48
gather_table_stats           MY_SCHEMA.TABLE_A                  10-AUG-16 01.16.44 AM        00:00:02.07
gather_schema_stats          MY_SCHEMA                          10-AUG-16 04.00.02 AM        04:36:19.35
gather_schema_stats          MY_SCHEMA                          11-AUG-16 04.00.02 AM        04:43:30.77
copy_table_stats             SYS.WRH$_FILESTATXS.WRH$_FILEST_24 11-AUG-16 11.24.21 PM        00:00:02.65

gather_schema_stats          MY_SCHEMA                          12-AUG-16 04.00.02 AM        04:42:15.92
gather_schema_stats          MY_SCHEMA                          12-AUG-16 04.00.02 AM        04:42:15.89
gather_schema_stats          MY_SCHEMA                          13-AUG-16 04.00.02 AM        04:41:06.68
gather_table_stats           SYS.WRI$_ADV_PARAMETERS            13-AUG-16 10.31.35 AM        00:00:03.88
gather_table_stats           SYS.WRI$_ADV_RATIONALE             13-AUG-16 10.31.39 AM        00:00:03.03
gather_table_stats           MY_SCHEMA.TABLE_B                  13-AUG-16 01.24.33 PM        00:04:07.98
gather_table_stats           MY_SCHEMA.TABLE_C.SYS_P12423       13-AUG-16 02.06.34 PM        00:03:22.33
copy_table_stats             SYS.WRH$_ACTIVE_SESSION_HISTORY.WR 13-AUG-16 11.03.35 PM        00:00:02.11

There is an important limitation with this script – it’s all very well seeing that gather_schema_stats has been running at a fairly uniform 4.5 to 5 hours, but it doesn’t tell us where the time went inside that call and it’s a call that could have been covering a lot of tables. There’s not a lot you can do about that from this set of data, but there’s another script I wrote a long time ago (before I wrote this one) that tried to do something about that question, and I’ll be publishing that tomorrow.


Lessons Learned in 20 Years at Oracle

Joel Kallman - Wed, 2016-09-14 20:59
I've known Mark, a technical pre-sales consultant at Oracle, for a number of years.  I was bcc'd on the farewell email message that he sent out today, his last working day at Oracle.  As he said, he's learned a few things over his past 20 years at Oracle and thought he would share them.  They were quite simple and powerful reminders - and important enough that I shared them with our entire development and QA teams.

OWN IT —  Things sometimes go off track.   Whether it was something on your team that went sideways or it was another team's responsibility, step up, own the problem and deliver a resolution.  LEARN IT —  There are always new technologies, solutions, processes, and procedures.   Set aside time to learn and master what is new so that you are prepared when the time comes.   TEACH IT — When you master something new, find someone else with whom you can share it.  GROW IT — Your team is incredibly valuable.   Take the time to invest in your teammates and equip them with new capabilities. OVERLOOK IT — People can make poor decisions.   Fight the urge to gossip about them.   Look for the best and ignore the rest.  

ORA-00904 Invalid Identifier. Query works in 12c but not in 11g

Tom Kyte - Wed, 2016-09-14 19:06
Hi Team, I have a correlated query, trying to execute it on oracle 11g. The same query executes perfectly fine on 12c but it gives ORA-00904 Invalid Identifier u.col_1 on 11g. Can someone please explain what's causing the issue in 11g? SELEC...
Categories: DBA Blogs

MView refresh failing because of ORA-01858: a non-numeric character was found where a numeric was expected

Tom Kyte - Wed, 2016-09-14 19:06
Categories: DBA Blogs

Counting repeating values

Tom Kyte - Wed, 2016-09-14 19:06
Hello Sir I have a result set with 3 columns ( INCIDENT_DATE , unit & occurrence): say I have these values in the result set INC_DT UNIT OCCURRENCE 1/8/2015 17:00 24 144 1/14/2015 17:00 24 1489 3/17/2015 18:00 24 500 9/17/201...
Categories: DBA Blogs

It’s the little things that really matter!

Tim Hall - Wed, 2016-09-14 15:57

Companies keep adding features to their products. Some features are really sexy and will get a lot of press. Some features are not so sexy, but are really useful during the day-to-day grind.

I remember when Oracle added the ability to drop columns from a table. At the time I was writing loads of scripts to recreate tables in order to drop columns. Adding this feature changed my life!

You can see another example of this in MySQL 8. If you look at the new features list you will see a section called Account Management, that links to Using Roles. OMG! This is massive for me! I don’t really care about a bunch of the sexy stuff. The presence of roles is a game changer for me!


It’s interesting how sometimes it’s the little things that really matter!

Check out Giuseppe Maxia‘s post on MySQL 8.0 first impressions.



It’s the little things that really matter! was first posted on September 14, 2016 at 9:57 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Why Should You Attend #OOW16 Session: WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]?

WebCenter Team - Wed, 2016-09-14 12:53

Digital Experience solutions are critical to successfully growing your business. Your Digital Experience solution must provide your customers with a personalized experience on the right browser or device, at the right time and in the right context. Digital Experience solutions must also be flexible and unite lines of business and technical teams on a single platform to help keep pace with the ever-changing digital world. How do you choose the right Digital Experience foundation? If you are heading to Oracle OpenWorld, next week we’ll help you decide! Don’t miss:

WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]
Tuesday, September 20, 5:15 pm
Moscone West—2014

The Oracle WebCenter Digital Experience suite consists of Oracle WebCenter Sites for Web Content Management & Oracle WebCenter Portal. These products enable customers to address management and delivery of Digital Experiences for marketing and self-service use cases. This session will cover the vision and roadmap of both products including cloud deployment options, integrations with other PaaS and SaaS services to extend the capabilitity set, including Oracle Marketing Cloud and Oracle Process Cloud Service, in addition to core platform updates. 

The beauty of the Oracle WebCenter Digital Experience suite is flexibility. We offer WebCenter Sites and WebCenter Portal customers flexibility through a variety of deployment models – pure on-premise, WebCenter Sites and WebCenter Portal hosted in Oracle’s cloud, integration with PaaS and SaaS and most importantly WebCenter Portal Cloud Service. I’ll touch on a couple of these deployment models briefly, but you’ll definitely want to attend the session to learn more!

Deployment on the Oracle Cloud
Certified deployment on the Oracle Cloud means customers have a certified installation of Oracle WebCenter Sites on Oracle Java Cloud Service (JCS). This allows you to take advantage of JCS infrastructure such as automated Database and Domain backup and restore, and use JCS-based WebCenter Sites to develop, test, and deliver websites. This seamless experience for developing and maintaining websites across on-premises and the cloud gives customers the flexibility and management they desire.

WebCenter Portal Cloud Service
The WebCenter Portal Cloud Service offers quick provisioning to enterprise software. Subscription pricing enables customers to scale in/out based on the needs of their organizations. WebCenter Portal Cloud Service helps customers to focus on applications and service delivery and Oracle handles the hosting and technical support of your virtualized hardware environment. You can leverage JCS tools to cluster/backup/restore/update JCS and WebCenter Portal Cloud Service also integrates into other Cloud SaaS/PaaS apps. What are the benefits to you? Reduction in IT infrastructure and management cost and the subscription pricing give customers flexibility to scale based on their needs.

We’ll also be joined by Valbona LaChapelle, Director, Online Technology at TIAA-CREF as she shares her company’s implementation of WebCenter and how TIAA-CREF is approaching moving more of their deployment to cloud. Existing WebCenter and on-premise web content management system stakeholders may particularly find this use case insightful.

Add to your My Schedule today:

WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]
Tuesday, September 20, 5:15 pm
Moscone West—2014

For a complete listing of all things Digital Experience don’t miss our recently launched website, Content and Experience at Oracle OpenWorld 2016. This site is built on Oracle Sites Cloud Service with Oracle Documents Cloud Service as its underlying content repository and is your one stop shop for everything related to Content and Experience Management at #OOW16!

Attend this and the key DX, Mobile sessions and it may be a "rewarding" experience. Check out the details under the "mobile contest" section on our site: https://sites.oracle.com/oowdx

Btw, the site is built on Oracle Sites Cloud Service with Oracle Documents Cloud Service as its underlying content repository!

And join the conversation on twitter using #OOW16 and #OracleDX. You may find your tweet show up on the site too…

E-book: Discover the breakthrough innovations in Oracle Database 12c

Syed Jaffar - Wed, 2016-09-14 11:23
Download the eBook and read to learn about 12c (the next generation most popular database) :

  • Simplify database consolidation and manage them as cloud services
  • Accelerate analytical performance whilst achieving new levels of efficiency, security and availability
  • Lower cost and mitigate risk

Install OEM 13c Silent mode

Surachart Opun - Wed, 2016-09-14 09:15
How to install Oracle EM 13c? It's the first time that I have a chance to install Oracle EM 13c. I remember last time I installed Oracle EM 12c. I have to install weblogic first. On OEM 13c, I don't need to do something like that. It installs WLS - , JDK – 1.7.0_80.
In this post, I installed Oracle EM 13c Silent mode with "SMALL" deployment. I assume, I installed Oracle Database Software (Software Only), downloaded " DB Template for EM on Linux x86-64" template  and uncompressed it in $ORACLE_HOME/assistants/dbca/templates folder.
ip_local_port_range parameter is set between 11000 to 65000
soft nofiles = 30000
file max = 65536
optimizer_adaptive_features = FALSE
Then, created database by using template.
[oracle@em13c ~]$ diff /u01/app/oracle/product/12.1.0/dbhome_1/assistants/dbca/dbca.rsp  dbca-emrep.rsp
< GDBNAME = "orcl12c.us.oracle.com"
> GDBNAME = "emrep"
< SID = "orcl12c"
> SID = "emrep"
< TEMPLATENAME = "General_Purpose.dbc"
< #SYSPASSWORD = "password"
> SYSPASSWORD = "password1"
< #SYSTEMPASSWORD = "password"
> SYSTEMPASSWORD = "password1"
[oracle@em13c ~]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
[oracle@em13c ~]$ export ORACLE_BASE=/u01/app/oracle
[oracle@em13c ~]$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/dbca -silent -responseFile dbca-emrep.rsp
Copying database files
1% complete
3% complete
10% complete
16% complete
 23% complete
30% complete
33% complete
Creating and starting Oracle instance
35% complete
40% complete
44% complete
49% complete
50% complete
53% complete
55% complete
Completing Database Creation
58% complete
62% complete
65% complete
75% complete
85% complete
88% complete
Running Custom Scripts
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/emrep/emrep.log" for further details.
Checked database after installing.
[oracle@em13c ~]$ . oraenv
ORACLE_SID = [oracle] ? emrep
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@em13c ~]$ sqlplus  / as sysdba
SQL*Plus: Release Production on Wed Sep 14 14:39:32 2016
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select instance_name from v$instance;
SQL>  select name from v$datafile;
7 rows selected.
SQL> show parameter spfile
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/12.1.0
SQL> show parameter optimizer_adaptive_features
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features          boolean     FALSE
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch
Oldest online log sequence     1
Current log sequence           1
SQL> show parameter control_files
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      /u02/oradata/emrep/control01.c
                                                 tl, /u02/oradata/emrep/control02.ctlConfigured listener.
[oracle@em13c ~]$ diff /u01/app/oracle/product/12.1.0/dbhome_1/assistants/netca/netca.rsp  /home/oracle/netca.rsp
< #SHOW_GUI=false
> SHOW_GUI=false
< #LOG_FILE=""/oracle12cHome/network/tools/log/netca.log""
> LOG_FILE=""/u01/app/oracle/product/12.1.0/dbhome_1/network/tools/log/netca.log""
[oracle@em13c ~]$ netca -silent -orahome /u01/app/oracle/product/12.1.0/dbhome_1 -responsefile /home/oracle/netca.rsp
Wed Sep 14 15:26:52 ICT 2016 Oracle Net Configuration Assistant
Parsing command line arguments:
    Parameter "silent" = true
    Parameter "orahome" = /u01/app/oracle/product/12.1.0/dbhome_1
    Parameter "responsefile" = /home/oracle/netca.rsp
    Parameter "log" = /u01/app/oracle/product/12.1.0/dbhome_1/network/tools/log/netca.log
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control:
      /u01/app/oracle/product/12.1.0/dbhome_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@em13c ~]$ lsnrctl status
LSNRCTL for Linux: Version - Production on 14-SEP-2016 15:27:35
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=em13c.surachartopun.com)(PORT=1521)))
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version - Production
Start Date                14-SEP-2016 15:26:52
Uptime                    0 days 0 hr. 0 min. 42 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/em13c/listener/alert/log.xml
Listening Endpoints Summary...
Services Summary...
Service "emrep" has 1 instance(s).
  Instance "emrep", status READY, has 1 handler(s) for this service...
Service "emrepXDB" has 1 instance(s).
  Instance "emrep", status READY, has 1 handler(s) for this service...
The command completed successfully
It was time to install Oracle EM 13c Silent mode. 
  • Uncompressed software and created response file.
[oracle@em13c scratch]$ ls em13100*
em13100_linux64-2.zip  em13100_linux64-3.zip  em13100_linux64-4.zip  em13100_linux64-5.zip  em13100_linux64.bin
[oracle@em13c scratch]$ ./em13100_linux64.bin -getResponseFileTemplates -outputLoc /home/oracle/RSP
Launcher log file is /tmp/OraInstall2016-09-14_03-31-39PM/launcher2016-09-14_03-31-39PM.log.
Copying response file template(s)
to /home/oracle/RSP ...
  Copying response file template upgrade.rsp
  Copying response file template software_only.rsp
  Copying response file template new_install.rsp
Finished copying response file template(s)
  • Modified response file and installed OEM13c. (I chose to use new install)
[oracle@em13c scratch]$ diff /home/oracle/RSP/new_install.rsp  /home/oracle/RSP/my-new_install.rsp
< UNIX_GROUP_NAME=<string>
> INVENTORY_LOCATION=/u01/app/oraInventory
> #STAGE_LOCATION=<string>
< PROXY_USER=<string>
> #PROXY_USER=<string>
< PROXY_PWD=<string>
> #PROXY_PWD=<string>
< PROXY_HOST=<string>
> #PROXY_HOST=<string>
< PROXY_PORT=<string>
> #PROXY_PORT=<string>
> ORACLE_HOSTNAME=em13c.surachartopun.com
< AGENT_BASE_DIR=<string>
> AGENT_BASE_DIR=/u01/app/oracle/agent13c
> ORACLE_INSTANCE_HOME_LOCATION=/u01/app/oracle/gc_inst
> SOFTWARE_LIBRARY_LOCATION=/u01/app/oracle/swlib
> DATABASE_HOSTNAME=em13c.surachartopun.com
< LISTENER_PORT=<string>
< SYS_PASSWORD=<string>
> SYS_PASSWORD=password1
> #STATIC_PORTS_FILE=/u01/app/oracle/mw13c/install/portlist.ini
> #CLUSTER_LOCATION=<string>Note: As I created database from template. So. I didn't set *TABLESPACE_LOCATION variables. For variables, that didn't define. we should comment it.
[oracle@em13c scratch]$ ./em13100_linux64.bin -silent -ignoreSysPrereqs  -responseFile /home/oracle/RSP/my-new_install.rsp
Launcher log file is /tmp/OraInstall2016-09-14_05-56-59PM/launcher2016-09-14_05-56-59PM.log.
Starting Oracle Universal Installer
Checking if CPU speed is above 300 MHz.   Actual 2300.094 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 0 MB    Failed <<<<
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 32844 MB    Passed
>>> Ignoring failure(s) of required prerequisite checks.  Continuing...

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2016-09-14_05-56-59PM
====Prereq Config Location main===
EMGCInstaller args -scratchPath
EMGCInstaller args /tmp/OraInstall2016-09-14_05-56-59PM
EMGCInstaller args -sourceType
EMGCInstaller args network
EMGCInstaller args -timestamp
EMGCInstaller args 2016-09-14_05-56-59PM
EMGCInstaller args -paramFile
EMGCInstaller args /tmp/sfx_g7ViFx/Disk1/install/linux64/oraparam.ini
EMGCInstaller args -silent
EMGCInstaller args -ignoreSysPrereqs
EMGCInstaller args -responseFile
EMGCInstaller args /home/oracle/RSP/my-new_install.rsp
EMGCInstaller args -nocleanUpOnExit
DiskLoc inside SourceLoc/u02/SRC/EM13c/scratch
ScratchPathValue :/tmp/OraInstall2016-09-14_05-56-59PM
EMGCInstallUpdatesInfoOnNext:: calling actionOnClickofNext
Now in EMGCInstallUpdatesInfoOnNext.actionsOnClickofNext
EMGCInstallUpdatesInfoOnNext:: End of actionOnClickofNext
Session log file is /tmp/OraInstall2016-09-14_05-56-59PM/install2016-09-14_05-56-59PM.log
Setup in progress (Wednesday, September 14, 2016 6:03:38 PM ICT)
Setup successful
Saving inventory (Wednesday, September 14, 2016 6:03:38 PM ICT)
Saving inventory complete
End of install phases.(Wednesday, September 14, 2016 6:03:39 PM ICT)
&Decline License Agreement/u01/app/oracle/mw13c/sysman/install/plugins/oracle.sysman.si/
Session log file is /tmp/OraInstall2016-09-14_05-56-59PM/install2016-09-14_05-56-59PM.log
Installation in progress (Wednesday, September 14, 2016 6:03:40 PM ICT)
                                                        72% Done.
Install successful
Linking in progress (Wednesday, September 14, 2016 6:03:40 PM ICT)
Link successful
Setup in progress (Wednesday, September 14, 2016 6:03:40 PM ICT)
Setup successful
Saving inventory (Wednesday, September 14, 2016 6:03:40 PM ICT)
Saving inventory complete
End of install phases.(Wednesday, September 14, 2016 6:03:41 PM ICT)
OMS OracleHome :/u01/app/oracle/mw13c
Applying the required one-off patches.
13NGCHEKAGGREGATE  : oracle.sysman.top.agent
13NGCHEKAGGREGATE  : oracle.sysman.top.oms
13NGCHEKAGGREGATE  : encap_oms
13NGCHEKAGGREGATE  : OuiConfigVariables
13NGCHEKAGGREGATE  : OuiConfigVariables
2016-09-14_06-07-13PM: Configuration Assistant "Plugins Prerequisites Check" is in progress.
2016-09-14_06-07-32PM: Configuration Assistant "Plugins Prerequisites Check" has Succeeded.
2016-09-14_06-07-32PM: Configuration Assistant "Repository Out Of Box Configuration" is in progress.
2016-09-14_06-42-39PM: Configuration Assistant "Repository Out Of Box Configuration" has Succeeded.
2016-09-14_06-42-39PM: Configuration Assistant "OMS Configuration" is in progress.

 Executing the OMSCA command...
 Check the log files of the OMS Configuration Assistant at: /u01/app/oracle/mw13c/cfgtoollogs/omsca

 OMS Configuration Assistant completed successfully.

2016-09-14_06-51-03PM: Configuration Assistant "OMS Configuration" has Succeeded.
2016-09-14_06-51-03PM: Configuration Assistant "Plugins Deployment and Configuration" is in progress.

2016-09-14_06-59-48PM: Configuration Assistant "Plugins Deployment and Configuration" has Succeeded.
2016-09-14_06-59-48PM: Configuration Assistant "BI Publisher Configuration" is in progress.
2016-09-14_07-05-20PM: Configuration Assistant "BI Publisher Configuration" has Succeeded.
2016-09-14_07-05-20PM: Configuration Assistant "Start Oracle Management Service" is in progress.
Starting OMS ...
Executing the command: /u01/app/oracle/mw13c/bin/emctl start oms
Starting of OMS is successful.
Starting export oms config...
Executing command: /u01/app/oracle/mw13c/bin/emctl exportconfig oms -dir  /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup
Export config of OMS is successful.
2016-09-14_07-09-43PM: Configuration Assistant "Start Oracle Management Service" has Succeeded.
2016-09-14_07-09-43PM: Configuration Assistant "Agent Configuration Assistant" is in progress.
Getting Inet Addresses for host em13c.surachartopun.com
** Agent Port Check completed successfully.**
AgentConfiguration:agent configuration has been started
Performing free port detection..
AgentConfiguration: Executing emctl deploy agent command...
AgentConfiguration: Executing emctl config agent command...
AgentConfiguration:agent configuration finished with status = true
2016-09-14_07-12-12PM: Configuration Assistant "Agent Configuration Assistant" has Succeeded.
*** The Installation was Successful. ***

This information is also available at:
See the following for information pertaining to your Enterprise Manager installation:

Use the following URL to access:
        1. Enterprise Manager Cloud Control URL: https://em13c.surachartopun.com:7803/em
        2. Admin Server URL: https://em13c.surachartopun.com:7102/console
        3. BI Publisher URL: https://em13c.surachartopun.com:9803/xmlpserver
The following details need to be provided while installing an additional OMS:
        1. Admin Server Host Name: em13c.surachartopun.com
        2. Admin Server Port: 7102
You can find the details on ports used by this deployment at : /u01/app/oracle/mw13c/install/portlist.ini

 An encryption key has been generated to encrypt sensitive data in the Management Repository. If this key is lost, all encrypted data in the Repository becomes unusable.
 A backup of the OMS configuration is available in /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup on host em13c.surachartopun.com. See Cloud Control Administrators Guide for details on how to back up and recover an OMS.
 NOTE: This backup is valid only for the initial OMS configuration. For example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. Backups should be created on a regular basis to ensure they capture the current OMS configuration. Use the following command to backup the OMS configuration:
/u01/app/oracle/mw13c/bin/emctl exportconfig oms -dir <backup dir>
Logs successfully copied to /u01/app/oraInventory/logs.
Note: su to "root" and run /u01/app/oracle/mw13c/allroot.sh script.
Starting to execute allroot.sh .........
Starting to execute /u01/app/oracle/mw13c/root.sh ......
/etc exist
Creating /etc/oragchomelist file...
Finished product-specific root actions.
/etc exist
Finished execution of  /u01/app/oracle/mw13c/root.sh ......

Starting to execute /u01/app/oracle/agent13c/agent_13. ......
Finished product-specific root actions.
/etc exist
Finished execution of  /u01/app/oracle/agent13c/agent_13. ......

[root@em13c ~]# cat /etc/oragchomelist
[root@em13c ~]# find /etc/ -name ???gcstartup
[root@em13c ~]# cat /etc/oragchomelist
[root@em13c ~]# find /etc/ -name gcstartup
[root@em13c ~]# find /etc/ -name ???gcstartup
  • After installed, I was able to check OMS and agent status.
[oracle@em13c scratch]$  /u01/app/oracle/mw13c/bin/emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host        : em13c.surachartopun.com
HTTP Console Port          : 7788
HTTPS Console Port         : 7803
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /u01/app/oracle/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://em13c.surachartopun.com:7803/em
Upload URL: https://em13c.surachartopun.com:4903/empbs/upload
WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : em13c.surachartopun.com
Admin Server HTTPS Port: 7102
Admin Server is RUNNING
Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: em13c.surachartopun.com
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up
BI Publisher HTTP Managed Server Port   : 9701
BI Publisher HTTPS Managed Server Port  : 9803
BI Publisher HTTP OHS Port              : 9788
BI Publisher HTTPS OHS Port             : 9851
BI Publisher is locked.
BI Publisher Server named 'BIP' running at URL: https://em13c.surachartopun.com:9851/xmlpserver
BI Publisher Server Logs: /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log        : /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@em13c scratch]$  /u01/app/oracle/agent13c/agent_13. status agent
[Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Agent Version          :
OMS Version            :
Protocol Version       :
Agent Home             : /u01/app/oracle/agent13c/agent_inst
Agent Log Directory    : /u01/app/oracle/agent13c/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/agent13c/agent_13.
Core JAR Location      : /u01/app/oracle/agent13c/agent_13.
Agent Process ID       : 26632
Parent Process ID      : 26568
Agent URL              : https://em13c.surachartopun.com:3872/emd/main/
Local Agent URL in NAT : https://em13c.surachartopun.com:3872/emd/main/
Repository URL         : https://em13c.surachartopun.com:4903/empbs/upload
Started at             : 2016-09-14 19:11:49
Started by user        : oracle
Operating System       : Linux version 3.10.0-327.28.3.el7.x86_64 (amd64)
Number of Targets      : 32
Last Reload            : (none)
Last successful upload                       : 2016-09-14 20:03:22
Last attempted upload                        : 2016-09-14 20:03:22
Total Megabytes of XML files uploaded so far : 1.56
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 40.54%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2016-09-14 20:05:00
Last successful heartbeat to OMS             : 2016-09-14 20:05:00
Next scheduled heartbeat to OMS              : 2016-09-14 20:06:00
Agent is Running and Ready
  • Connected OEM 13c by browser.


Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator