Feed aggregator

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

PeopleSoft – What Does The Future Hold?

Duncan Davies - Wed, 2016-09-14 09:00

In an earlier post titled Banishing PeopleSoft Myths I shared my perspective of the current state of the PeopleSoft product and marketplace. I thought it’d be an interesting exercise to try to look forwards and to define what I think the future might hold for the product line. Some of this might be a little off-target, some might be a mile off target and some I might have changed my mind on if you ask me next week, but hopefully it starts some discussions.

PeopleSoft Moves to The Cloud

An easy one first. There’s a strong push to move to The Cloud and that should be apparent to pretty much everyone. There are some compelling success stories for PeopleSoft in the Cloud, customers have gained huge performance oracle-public-cloudincreases and flexibility in infrastructure, as well as saving money. So far these success stories have been on AWS, and – to a lesser extent – on Azure, however Oracle wants a piece of that pie now. The Oracle Compute Cloud should be an option whenever there’s a discussion on Cloud hosting (and this discussion should be held before any hardware refresh or major upgrade/get current).

Oracle is also making it easier for customers to move to The Cloud. The PeopleSoft Cloud Architecture is a set of functionality and tools that eases the transition, and it will be enhanced in future PeopleTools versions.

The PeopleSoft Marketplace Remains Buoyant

Cedar’s current experience is that there is a lot of activity in the market. Through the coming years we shouldn’t expect a huge number of net-new clients buying PeopleSoft, however existing clients are very loyal to the product and will continue to take advantage of the new features that are added to the product. It’s easy to imagine that over the coming years there will be widescale adoption of Fluid and Cloud Architecture.

More PeopleSoft Hosting

It’s becoming easier for customers to outsource the care of their PeopleSoft systems to partners – or, in the future, maybe even Oracle themselves. The Cloud makes the infrastructure significantly cheaper, and the PeopleSoft Cloud Architecture will make the administration simpler too. The PeopleSoft application will simply be provided to the client as a service, with all the hardware, DBA services and patcsa-image-hosting-iconhing performed by the partner for a flat monthly fee. PeopleSoft updates could also be rolled into this as Selective Adoption forms a key piece of the application maintenance model and lends itself very well to the Cloud hosting model.

There have been other advances in PeopleTools too that make it easier to reduce customisations – thereby making it easier for organisations to host multiple customer environments. The new related content event mapping functionality enables you to replace (some) customised code, and I’m sure the PSAdmin.io guys mentioned a technique for adding fields to a page via config instead of customisation (but I can’t find a link for it). The closer you are to vanilla the easier it is keep your application updated with the latest security, product fixes and new features.

Will Oracle provide “PeopleSoft as a Service”? Currently the answer – at least publicly – is ‘No’ however that might change over time. Oracle are moving their OnDemand offering over from physical hardware to Cloud infrastructure so they will host the servers and provide maintenance resources for clients.

PeopleSoft and Containers

The next evolution on from Virtual Machines is the use of ‘container’ technology. The problem with having a server containing multiple VMs is that each VM needs to have its own Operating System installed, kept patched and kept in sync. This – and the other software that could be shared – introduces a lot of duplication. Containers are like cut-down VMs, there is no OS within the container, just the application itself. Each of the containers shares the OS that’s installed on the host. There’s adocker
good intro to containers here.

Vendors have started to adopt this container technology – Docker is by far the most widely known – and it’d be no surprise if PeopleSoft starts to do the same. It’d be great to be able to drop in another App Server container without having to mess around with building one. The DPKs get us part way there, but this could be the next progression. First we’ll need to wait for Oracle Compute Cloud support for Docker first (or whatever snappy name Oracle gives to their Docker equivalent … maybe the ‘Oracle Enterprise Container Management Service’?)

Greater Fluid Adoption

Somewhere between 50-60% of customers are on v9.2, which means they’re either using or preparing to use Selective Adoption. Once a customer starts on the Selective Adoption path, they’ll find that the Fluid UI is the interface that updates and fixes will be delivered on. This will drive Fluid adoption. This is good for Self Service users as they’d typically benefit the most from a Fluid roll-out.

Although there is some pain involved in getting Fluid up and running all of the feedback that we’ve heard to date is that those who’ve made the jump are very happy with the results. Self Service users stand to gain the most as Fluid really makes PeopleSoft a lot more accessible to infrequent users.

The role of SysAdmin is Changing

The role of the PeopleSoft SysAdmin is dramatically different than it was 5 years ago. The advent of PUM, Selective Adoption, DPKs, Puppet and SES, and the imminent adoption of the Cloud Delivery Architecture and Elasticsearch have all shifted the landscape significantly.

Much of this is good news. For instance, Selective Adoption and DPKs have both made the SysAdmin’s life easier (once the toolset has been learnt). The future sounds like this trend will continue as Cloud Manager will allow one-click provisioning and refreshes of environments, and Elasticsearch promises to alleviate some of the SES headaches.

This greater functionality does come at a cost for the SysAdmin, and that is that there is a wider breadth to the set of tools that they are required to master. The days where the SysAdmin just needed to do installs and tuning have passed. This increased automation brings the requirement for DevOps SysAdmins – i.e. SysAdmins who are able to cut some code.

The role of Developer is Changing

Developers too are finding that the goalposts are moving. Developers who’ve only just recovered from swapping out their FuncLibs for App Packages are now reeling from the news that there is even more to learn. Fluid brings a requirement to know much more HTML, CSS and some JavaScript. Having seen a recent demo where Jim Marion completely re-laid out a Fluid page using the Chrome Developer console rather than PeopleCode really brought this home. The next tech coming over the hill at Deve
lopers is Oracle JET – a collection of the most useful JavaScript frameworks.

LogStash for PeopleSoft

I felt I should end with a real ‘out there’ prediction. With Elasticsearch we can see that Oracle are open to including a new 3rd party product as part of the stack (previously it seemed like 3rd party tools were slowly being phased out) so what other new products or tools might be included? Elasticsearch is made by a company called Elastic, but they have other offerings in addition to their core Search product.logstash The one that looks the most appealing from a PeopleSoft point-of-view is LogStash. I’ve looked at it a number of times over the years but its lack of Windows support was always a barrier for me, however now it’s available on Windows. LogStash is a log file aggregation tool, it takes all of the entries in all of your log files spread across all of your servers and makes them available for searching in one central repository. It’s easy to see how that might be incredibly useful in a PeopleSoft context. There are alternative tools that perform a similar role – Splunk for example – however I think LogStash is the most obvious selection.

UPDATE: The PSAdmin.io guys discussed Splunk and LogStash in their latest Podcast.

So, there are 8 predictions for the coming years. Have I missed anything glaring? Have I got one of them wrong?

#OOW16: Content and Experience Management Customer & Partner Sessions

WebCenter Team - Wed, 2016-09-14 04:59

If you're attending Oracle OpenWorld next week, you won't want to miss these customer sessions! There is no better way to learn how Oracle's Content and Experience Management solutions could help in your organizations than hearing from your peers. We've got 9 sessions dedicated around Content Management, Digital Experience and Digital Experience Solutions that our customers and partners will be presenting in at #OOW16 this year. We hope you'll join us!

Content Management at OOW

Content Management in the Cloud: Strategy & Roadmap [CON7257]  WebCenter Content, Imaging, Capture & Forms Recognition: Roadmap & Strategy [CON7259]  Simplify and Extend the Management of WebCenter through PaaS and IaaS [CON7268]  Monday, Sep 19, 12:30 p.m. | Moscone West - 2014 Tuesday, Sep 20, 4:00 p.m. | Moscone West - 2014  Thursday, Sep 22, 1:15 p.m. | Moscone West - 2014 Learn How OMNI: 
  • Uses Oracle Documents Cloud Services to store customer documents used in the credit request process, managed by WebCenter Content.
Learn How McKesson: 
  • Uses the WebCenter Content & Imaging product line to integrate and automate AP invoice processing with their JD Edwards ERP system.
Learn How EMOTrans: 
  • Is implementing a new Oracle Compute Cloud based deployment of WebCenter Portal & Content for a transformational Portal project.

Digital Experience at OOW

WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]  Improve Marketing Content Velocity with Centralized Content and Collaboration [CON7263]  Digital Asset Management for Modern Enterprises [CON7267]  Tuesday, Sep 20, 5:15 p.m. | Moscone West - 2014  Wednesday, Sep 21, 11:00 a.m. | Moscone West - 2014  Thursday, Sep 22, 10:45 a.m. | Moscone West - 2014  Learn How TIAA-CREF: 
  • Uses WebCenter Sites and how they are approaching moving more of their deployment to the cloud.
Learn How CRUEL: 
  • Uses a Marketing platform-based on Oracle PaaS & WebCenter to digitally, collaboratively, and visually manage campaigns, and assess cost and ROI.
Learn How Macy's: 
  • Uses the Oracle Digital Asset Management solution to manage digital assets across multiple channels and improves collaboration.

Digital Experience Solutions at OOW

Empower your Employees and Drive Productivity with a Modern Intranet Experience [CON7261]  Cox Enterprises Reimagines the Digital Workplace with Oracle WebCenter [CAS4789]  Deep-Dive into Content, Collaboration and Digital Signatures in the Cloud [CON7266]  Wednesday, Sep 21, 12:15 p.m. | Moscone West - 2014  Wednesday, Sep 21, 3:00 p.m. | Marriott Marquis - Golden Gate C3  Thursday, Sep 22, 12:00 p.m. | Moscone West - 2014  Learn How IntraSee: 
  • Uses Oracle solutions to empower employees with meaningful collaboration, continuous enablement and effective customer engagement.
Learn How Cox Enterprises: 
  • Uses WebCenter Portal to provide a gateway to knowledge resources and collaboration.
  • Created a “one-stop shop” for information and single employee experience.
Learn How Hellosign: 
  • Prodvides an integration with Oracle Documents Cloud Service for e-signatures and collaboration with no printing invovled.

We recommend you add these sessions to your OpenWorld My Schedule to save your seat and plan and optimize your time during the conference by building personalized conference schedules beforehand. 

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

As always, we are asking you to please follow along and join the conversations on our social media channels! #OOW16 and #OracleDX

Links for 2016-09-13 [del.icio.us]

Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator