Feed aggregator

real-time apply log in dataguard

Tom Kyte - Fri, 2017-03-31 12:06
Hi ,expert. I want to know i have created a dataguard in 11g. i start the standby database as below steps: 1)startup mount; 2) alter database recover managed standby database using current logfile disconnect from session; I shouldn't buy l...
Categories: DBA Blogs

Triggers

Tom Kyte - Fri, 2017-03-31 12:06
Hello Tom, I had an Issue with one of my Trigger pasted below with error message, Can you let me know for any other alternatives. CREATE TABLE TEST (ID NUMBER,NAME VARCHAR2(20),COMMENTS VARCHAR2(20)); INSERT INTO TEST(ID,NAME,COMMENTS) VALUE...
Categories: DBA Blogs

PLSQL calling SQL running slower in 12c (r2) than 11g (r1)

Tom Kyte - Fri, 2017-03-31 12:06
Hi there, I recently installed Oracle 12c release 2 on a Microsoft Windows 2012 R2 64bit server 16gb RAM and I created a database on this server, into which I imported data from a 11gR1 (11.1.0.6) database that's running on Microsoft Windows 2003 ...
Categories: DBA Blogs

Oracle On Linux vs Windows

Tom Kyte - Fri, 2017-03-31 12:06
Hi Tom I am a SQL Server DBA who recently found myself with a Oracle 11.2.0.4 database ruining on CentOS 6.7. Knowing very little Oracle I didn't yet realize that Oracle is not certified for use on CentOS, i now do having raised a service request ...
Categories: DBA Blogs

Materialized View Partitioned

Tom Kyte - Fri, 2017-03-31 12:06
Hi, I would like to know about two situations: 1)my base table is not partitioned and i have a materialized view on the same. Is it possible to partition the materialized view. If yes kindly provide steps for the same. 2)I have a table whic...
Categories: DBA Blogs

Is SQL Injection A WebSite Problem?

Pete Finnigan - Fri, 2017-03-31 12:06
I saw a post on RobLockards Facebook page this week where he said some people have suggested that his SQL Injection talk only shows calling a procedure from SQLCl and not a web page and he suggests that he may....[Read More]

Posted by Pete On 31/03/17 At 03:38 PM

Categories: Security Blogs

Big Announcement – New Job, New Country (A New Career In A New Town)

Richard Foote - Fri, 2017-03-31 08:45
After 5 1/2 years at Oracle Corporation, I’ve decided to leave and take on a very exciting new challenge !! President Trump’s office have accepted my nomination to head their IT department in Washington DC, where I’ll be responsible for ensuring all USA government data is stored in a extremely efficient and secure manner. So secure, that […]
Categories: DBA Blogs

Oracle GoldenGate 101 at IOUG 17 and GaOUG TechDays 17 within two month

DBASolved - Fri, 2017-03-31 08:00

Losts have changed for me since my last blog post. A new job and new responsibilities, which will include presenting more at conferences on the conference circuit and a few roadshows that are planned in the near future.

Back in the fall of 2016, when most of the Call for Papers open, I had a great idea for introducing people to Oracle GoldenGate. This idea is walk everyone through the progression of replication technology from CDC through Oracle GoldenGate, including some future road map items; that will ensure Oracle GoldenGate stays the number 1 replication tool on the market.

Over the next two months, I will be presenting this great idea/topic in a presentation called Oracle GoldenGate 101 – Replication from the beginning starting at IOUG Collaborate next week (April 2-6, 2017) and then at the best keep secret in the south – Georgia Oracle User Group (GaOUG) Tech Days 17 on May 9th-1th, 2017 (register here). This is going to be a session you will not want to miss, espeically if your organization uses Oracle GoldenGate for any architecture.

Additionally, the great guys who run the Georgia Oracle User Group (GaOUG) have done some amazing things since the planning of Tech Days 17 started. Just getting the key note speaker was a great addition to the already packed schedule of talks. This year, the keynote speaker is Maria Colgan, Master Product Manager for Oracle. She will be sharing some new and exciting items related to the Oracle Database and the direction Oracle is taking with new and exciting products.

GaOUG will also have dozens of Oracle ACE’s and ACE Director’s talking about topics accross multiple track (Database Development, Big Data, Applications, Middleteir). As an added bouns this year, GaOUG has added a half day Cloud track where you can learn all the items needed for your future Cloud deployments.

Hope to see everyone at both of these events, especially GaOUG in the coming months!

If you want to learn more about GaOUG Tech Days and the other impressive speakers, check out the blog hop posts below! What is a blog hop? It’s a group of bloggers who all get together to blog on a similar topic, giving you a lot of useful information from different perspectives, but in one stream. Enjoy your “hop” between blog posts and register for GaOUG Tech Days today!

Stewart Bryson
, RedPill Analytics
Jim Czuprynski, OnX Enterprise Solutions
Chris Lawless, Dbvisit Software
Danny Bryant, Accenture Enkitec Group
Eric Helmer, Mercury Technology Group


Filed under: GaOUG
Categories: DBA Blogs

Dalmatian Bandits, PaaS4SaaS, and Chatbot UX at PaaS Forum 2017

Usable Apps - Fri, 2017-03-31 07:57

Just back from an awesome PaaS Forum 2017 in Split, Croatia. Another superb community event organized by Oracle's Jürgen Kress (@soacommunity) and team; featuring the usual superb planning, marketing, and execution. It was Platform as a Service (PaaS) heaven on the Dalmatian coast.

PaaS

Forum

PaaSForum: Always well presented and marketed. And then it delivers.

There was great interest and energy generated from no less than three chatbot-related sessions, including a super one from partner Capgemini's Leon Smiers (@leonsmiers) on day one (a community award winner later!). Oracle wrapped up the second day's proceedings with a superb presentation and live demo of Oracle's chatbot enablement for cloud developers by Frank Nimphius (@fnimphiu). 

Frank Nimphius

Frank Nimphius steals the show with his chatbot session: Frank is always frank about what developers can do!

Showcase Show-off! 

The event featured a packed PaaS and Oracle Cloud service integration agenda with an emphasis on the "hands-on" and learning. So, I was thrilled to drive the UX contribution by bringing along the latest Oracle Applications User Experience (OAUX) greatness for cloud enterprise developers with a UX showcase. I showed off what we are doing with wearable tech  and conversational UI for SaaS, how our UI is evolving, and our free Rapid Development Kit (RDK) partner enablement for a mobility-first world, all built using Oracle Cloud technology. 

UX Showcaser

We build in the UX to our partner enablement and use Oracle technology to build solutions! Ultan O'Broin (@ultan) Explaining our RDKs.

It was great to catch up with old friends, and meet new people from the partner ecosystem across EMEA and APAC. Check out all that was on offer (including the bootcamps offered later in the week) and the lively commentary and 'interesting' images shared on Twitter with the #PaaSForum hashtag.

Bandit

Bandit the Cloud Expert. The real star of PaaS Forum 2017. Woof!

Rapid Development Kits

I also showed off our Rapid Development Kit enablement, beginning with a live mobile development and UX demo, sharing how to make a decision on tools, how to be part of a partner success story, and concluding with a great supporting comment from Certus Cloud's Debra Lilley (@debralilley).

Right Tools; Right Job

Making a decision about the right tool for the right job.

I was also pleased to hear how some SaaS partners are using the RDK to solve that innovation quandary of what should they should build and when; particularly how they can innovate quickly and show interested customers SaaS and PaaS possibilities without using up scare development resources allocated to other projects.

Partner Story

A partner success story from APAC. Quotes from our RDK PaaS4SaaS enablement event with DXC Technology in Australia. Read more about the event.

In all, this was a super event, priceless in terms of partner networking and platform for exploring UX needs and wants from the enterprise developer ecosystem, for learning new skills, and for coming up to date fast on what Oracle is offering the PaaS community.

See you next year! Hey, you might even win one of the community awards, just like our friends in eProseed!

More from Split?

SQL Server on Linux and experimental Flexible Architecture

Yann Neuhaus - Fri, 2017-03-31 06:28

In this blog post let’s talk a little bit about SQL Server optimal installation on the Linux file system. This is probably one of the first considerations we will have as a database administrator. Actually basic installation of SQL Server can be resumed to use yum command and let the SQL Server installer place all related files on the file system. But in a production environment, the story will be different and we will have to follow best practices. In fact, Microsoft guidelines already exist in Windows world and concern mainly placement of system / user database files and tempdb as well.

But what about Linux? In my opinion, the game is not so different and existing database file placement rules also apply on Linux. We don’t work with drive letters on Linux but it doesn’t matter because in some cases we already use the same mount point concept.

How to start and how to achieve an optimal placement were the questions in my head since the last meetup I attended about MongoDB and organized by my colleagues Medhi Bada and Eric Dusquesnoy.

During the meeting, they talked about MongoDB installation according the OFA architecture initiated by Oracle and which has many similar aspects with FHS on Unix system. Another interesting thing I’ve realized after discussing with my colleagues is that we also propose the same based-model for other SGBDs like MySQL or PostgreSQL (with some adjustments in the respect of their respective context).

In a nutshell, OFA architecture provides the following interesting things:

  • A logical layout for the databases that helps DBAs to manage their system. The idea here is to provide a predictable and consistent file naming structure to manage and to deal easily with issues such as adding hardware, installing new instance etc…
  • Preventing performance bottlenecks by distributing I/O across enough disks. For instance, we may separate group of entities that will contend for disk resources. We may think here about separating data and log files, data files in different filegroups or dedicated tempdb to its own storage path as well.
  • Maximizing database reliability in case of disk failure

But you may wonder why to scale the existing SQL Server best practices to the OFA standard?

First of all, let’s say that existing Microsoft best practices, in many respects, resembles to OFA. Then providing a uniform approach to customers (Oracle, MySQL, PostgreSQL, MongoDB and SQL Server) about best practices may help to contribute to a true immersion of SQL Server on Linux. From a customer perspective, we may provide guidelines on an already widely architecture standard known in Linux world. This is, at least, the way I see it.

So just to be clear, the next part of this blog is purely experimental and it doesn’t pretend to replace any future guideline that will be provided by Microsoft.

Before getting to the heart of the matter, let’s get the files associated to the mssql-server package. I continue to use the CentOS distribution for my demo but you may easy apply the same with other distributions.

[root@sql mssqlserver]# rpm -qpl mssql-server-14.0.405.200-1.x86_64.rpm
/opt/mssql/bin
/opt/mssql/bin/compress-dump.sh
/opt/mssql/bin/generate-core.sh
/opt/mssql/bin/mssql-conf
/opt/mssql/bin/paldumper
/opt/mssql/bin/sqlpackage
/opt/mssql/bin/sqlservr
/opt/mssql/lib
/opt/mssql/lib/libc++.so.1
/opt/mssql/lib/libc++abi.so.1
/opt/mssql/lib/libjemalloc.so.1
/opt/mssql/lib/libsqlvdi.so
/opt/mssql/lib/libunwind.so.8
/opt/mssql/lib/mssql-conf
/opt/mssql/lib/mssql-conf/checkinstall.sh
/opt/mssql/lib/mssql-conf/checkrunninginstance.sh
/opt/mssql/lib/mssql-conf/collations.txt
/opt/mssql/lib/mssql-conf/disableservice.sh
/opt/mssql/lib/mssql-conf/enableservice.sh
/opt/mssql/lib/mssql-conf/mssql-conf.py
/opt/mssql/lib/mssql-conf/mssqlconfhelper.py
/opt/mssql/lib/mssql-conf/mssqlsettings.py
/opt/mssql/lib/mssql-conf/mssqlsettingsmanager.py
/opt/mssql/lib/mssql-conf/sapassword.sh
/opt/mssql/lib/mssql-conf/set-collation.sh
/opt/mssql/lib/mssql-conf/startservice.sh
/opt/mssql/lib/mssql-conf/stopservice.sh
/opt/mssql/lib/sqlpackage.sfp
/opt/mssql/lib/sqlservr.sfp
/opt/mssql/lib/system.certificates.sfp
/opt/mssql/lib/system.common.sfp
/opt/mssql/lib/system.netfx.sfp
/opt/mssql/lib/system.sfp
/usr/lib/systemd/system/mssql-server.service
/usr/share/doc/mssql-server/LICENSE.TXT
/usr/share/doc/mssql-server/THIRDPARTYNOTICES.TXT
/usr/share/man/man1/mssql-conf.1.gz
/usr/share/man/man1/sqlpackage.1.gz
/usr/share/man/man1/sqlservr.1.gz

From the above output we may find out a bunch of files that are part of the proper functioning of SQL Server. For example, we may notice different script files (either bash and python scripts files), libraries and sfp files (which are part of the new drawbridge architecture?), man page files and finally the sqlservr binary.

Most of these files are installed in the main hierarchy /opt/mssql/ with the following specific items

  • /opt/mssql/bin/ (binary files and SQL Server crash dump generation scripts)
  • /opt/mssql/lib (sqlserver libraries and sfp files)
  • /opt/mssql/lib/mssql-conf (python and bash scripts)

In addition, installing a SQL Server instance reveals an additional hierarchy /var/opt/mssql with the followings items :

  • data folder = default folder for database data and transaction log files. By the way, system and tempdb database files are located here by default. At the moment of writing this blog, SQL Server is in CTP 1.4 and moving system databases are not supported but we may expect to see this limit removed in the future
  • log folder = log files are stored here. We may retrieve logs related to SQL Server engine (errorlog files), to the SQL Server agent (SQLAGENT.OUT), to the default SQL Server trace and HK engine extended event.
  • secret folder = contains the machine.key file used by the SQL Server engine or potential other files that come with high-availability architectures to store pacemaker credentials for example.
  • conf file = Stores the default location files for user database files and dump files as well.

The last one – mssql.conf – has drawn my attention. According to my tests, it is possible to modify this file manually without getting sides effects but maybe to take with a pinch of salt at this stage.

So here my flexible architecture version for SQL Server:

  • Binary structure
mkdir -p /u00/app/sqlserver
mkdir -p /u00/app/sqlserver/product/14/mssqlserver
mkdir -p /u00/app/sqlserver/local/dmk
mkdir -p /u00/app/sqlserver/local/mssqltools
mkdir -p /u00/app/sqlserver/admin/mssqlserver/etc
mkdir -p /u00/app/sqlserver/admin/mssqlserver/log
mkdir -p /u00/app/sqlserver/admin/mssqlserver/dump

ln -s /opt/mssql/bin /u00/app/sqlserver/product/14/mssqlserver
ln -s /var/opt/mssql/mssql.conf /u00/app/sqlserver/admin/mssqlserver/etc/
ln -s /var/opt/mssql/log/ /u00/app/sqlserver/admin/mssqlserver/log 

Products file consists of SQL Server software that are supplied on the media / package provided by Microsoft.

Administrative files are files containing data about the instance, including SQL Server and SQL Agent error log files, default traces or HK engine extended event files server process diagnostic and finally instance parameter files like mssql.conf file.

  • Database structure
mkdir -p /u01/sqlserverdata/mssqlserver
mkdir -p /u02/sqlserverlog/mssqlserver
mkdir -p /u03/sqlservertempdb/mssqlserver
mkdir -p /u98/sqlserver/backup/mssqlserver

Then let’s configure the correct permissions on the new hierarchy folders

chown -R mssql:mssql /u01/sqlserverdata/mssqlserver
chmod -R 750 /u01/sqlserverdata/mssqlserver
chown -R mssql:mssql /u02/sqlserverlog/mssqlserver
chmod -R 750 /u02/sqlserverlog/mssqlserver
chown -R mssql:mssql /u03/sqlservertempdb/mssqlserver
chmod -R 750 /u03/sqlservertempdb/mssqlserver
chown -R mssql:mssql /u98/sqlserver/backup/mssqlserver
chmod -R 750 /u98/sqlserver/backup/mssqlserver

After configuring the permissions let’s change default path parameters from the mssql-config utility

/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /u01/sqlserverdata/mssqlserver 
/opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /u02/sqlserverlog/mssqlserver 
/opt/mssql/bin/mssql-conf set filelocation.defaultbackupdir /u98/sqlserver/backup/mssqlserver
/opt/mssql/bin/mssql-conf set filelocation.defaultdumpdir /u00/app/sqlserver/admin/mssqlserver/dump

And let’s move tempdb database files by connecting to SQL Server (moving tempdb is supported since the CTP 1.4).

DECLARE @sql NVARCHAR(MAX) = N'';
DECLARE @path_name NVARCHAR(MAX) = N'/u03/sqlservertempdb/mssqlserver/';

USE tempdb;


SELECT 
	@sql += N'ALTER DATABASE [tempdb] MODIFY FILE (NAME = ' + name + ', FILENAME = ''' 
	        + @path_name + REVERSE(SUBSTRING(REVERSE(REPLACE(physical_name, 'C:\', '')), 1 , CHARINDEX('\', REVERSE(REPLACE(physical_name, 'C:\', ''))) - 1)) + ''
			+ ''')' + CHAR(13)
FROM sys.database_files;


--PRINT @sql

EXEC sp_executesql @sql;
GO

And finally let’s restart the SQL Server instance:

systemctl restart mssql-server

Moreover, we may also add to the system path the binary structure in place and then change it when a new product is installed

echo 'PATH=”$PATH:/u00/app/sqlserver/product/14/mssqlserver/bin”' >> ~/.bashrc
source ~/.bashrc

Invoking mssql-conf is pretty easy in this case as shown below:

[root@sql home]# mssql-conf [options]

Finally let’s have a look at the database files placement :

SELECT 
	DB_NAME(database_id) AS database_name,
	name AS logical_name,
	physical_name
FROM sys.master_files
ORDER BY database_id

blog 120 - SQL Server and Flexible architecture

Drive letters and Windows fashion paths are still present for system databases but no doubt this issue will disappear in a next release.

Bottom line

Keep in mind that OFA architecture is very flexible and provides only guidelines and best practices. Therefore, we will be able to make adjustments over time as the version evolves. Please feel free to comment. It always be appreciated!

See you

 

 

Cet article SQL Server on Linux and experimental Flexible Architecture est apparu en premier sur Blog dbi services.

Oracle E-Business Suite Mobile and Web Services Security Explained - Starting with URL Firewall

This is the sixth posting in a blog series summarizing the new Oracle E-Business Suite 12.2 Mobile and web services functionality and recommendations for securing them.

How are web services secured in Oracle 12.2? To start at the beginning, the “front door” of the Oracle E-Business Suite is its web server, the Apache server deployed within the WebLogic server that is installed with release 12.2. To secure an Apache web server largely requires setting various configurations in the Apache configuration file (httpd.conf). For the Oracle E-Business Suite, these critical settings are maintained by Oracle through the AutoConfig utility. 

URL Firewall

The most important setting for Internet-facing clients is the include for the Oracle E-Business Suite’s URL Firewall. When the URL Firewall is included in the httpd.conf, every web request is passed through the URL Firewall, both for forms and for web services. The URL Firewall is non-discretionary and mandatory requirement when the Oracle E-Business Suite is deployed on the Internet.

HTTPD.CONF include for the URL Firewall

The URL Firewall is a template maintained by Oracle that whitelists those forms (e.g. JSP pages) that Oracle Corporation has hardened for use on the Internet. If the JSP is not listed “whitelisted” in the file url_fw.conf it should NOT be used on the Internet. Be sure to use the latest version of the template as Oracle periodically updates the template.

In the template, Oracle comments out all lines which effectively “Denies All.” To use the url_fw.conf, DBAs at each client site need to manually uncomment (“open”) specific JSP pages appropriate to their site. This “opening” by the DBAs must be carefully done and routinely reviewed.

The mechanics of when the url_fw.conf is called or not is determined by the Node's trust level. Most large Oracle E-Business Suite implementations have multiple web servers (referred to as nodes). To deploy the Oracle E-Business Suite on the Internet, one ore more nodes are deployed in a DMZ. If the node making the request of the Apache web server is flagged as an "Internal" web node, the url_fw.conf is skipped. If however the Node's trust level is flagged as "External" because the node is deployed in the DMZ, the url_fw.conf is called.

When called, the url_fw.conf applies regular expressions to the web request to determine if the request is BOTH exists in the whitelist and has been uncommented “opened” by the DBAs. If no match is found, a default-deny result is returned. In security terms, this means all requests are rejected unless explicitly allowed. If a match is found, the web request continues and the WebLogic server will then proceed with authentication and authorization tasks.

Example of URL FW line uncommented

Enabling and configuring the URL Firewall is the first step in securing web services. Unfortunately, Oracle buries the documentation for the URL Firewall in Appendix E of DMZ configuration guide – see the reference section of this paper for more information on the documentation.

To secure web services, it gets more complicated in that a second whitelist is appended to the first. To secure Oracle E-Business Suite web services, the url_fw.conf calls the url_fw_ws.conf. Similar to the configuration of the url_fw.conf, the documentation is buried deep in Appendix E of the DMZ configuration guide.

Different than the url_fw.conf which is supplied as a static listing of JSP pages, a utility (txkGenWebServiceUrlFwConf.pl) is run to generate the file url_fw_ws.conf. After being generated, DBAs similarly need to manually uncomment only those lines for the web services being used. If a web service is not found to be whitelisted, a default-deny rule will be applied; all web services commented out will be denied.

Example of URL FW WS.conf

Errors in selecting a Node’s trust level and configuring either the url_fw.conf and/or the url_fw_ws.conf have serious security consequences and should be routinely reviewed as part of on-going security audits.

Web services can be publically deployed without using the URL Firewall. For example, clients can if they so choose route Internet traffic directly to the E-Business Suite without setting up an External node. Integrigy Corporation highly recommends against doing this. Integrigy Corporation highly recommends always using the URL Firewall when deployed on the Internet, both for forms and for web services.

URL Firewall called by Node Trust Level

httpd.conf calls the URL Firewall

If you have any questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP, CCSP, CCSK

 
 
 
 
 
Web Services, DMZ/External, Oracle E-Business Suite
Categories: APPS Blogs, Security Blogs

The value of the Oracle PaaS Partner Community Forum

Amis Blog - Fri, 2017-03-31 04:10

IMG_7692I have just returned home from the Oracle PaaS Partner Community Forum 2017 which took place in Split, Croatia. Filled with energy, inspiration, impressions, already fond memories, more understanding, longer term plans and shorter term action items and a warm feeling of being part of an international network of smart, open, helpful and fun people. Does that sound soft, a little over the top – slightly brainwashed even? Let me try to explain what this event entails and what it means to me.

IMG_7722200 Representatives from Oracle PaaS and Middleware partners in 25+ countries – primarily in Europe and including North America, Asia and Africa – flocked to Split, Croatia to meet with each other as well as with  a few dozen Oracle staff – from Vice President Product Management Fusion Middleware and PaaS Cloud to the Oracle A Team. The objectives of the event are to share real life experiences with Oracle technology and Oracle as a company to do business with. The partners share experience with each other – to learn and teach – as well as with Oracle – to enlighten them as to what works well and what is sorely lacking in products. Oracle staff lay out the product roadmaps for the next 6-18 months, share commercial opportunities, demonstrate new or hidden features in the products and in general enable attendees to make more successful use of their technology. The common goal is clear: become more successful in applying Oracle products for customers – by making the products better and by better understanding how the products can be best used.

IMG_7773The common ground for this community is strong and clear: a shared enthusiasm to work with technology and achieve business value for customers with it. We share a lot of history – even if this is the first time we meet – from working many years with the same technology, trying to achieve similar results for customers, facing the same challenges and probably unknowingly collaborating through discussion forums and blog articles. This shared history and common vocabulary make it very easy to strike up conversations – with just about anyone. Talking about a product, a technology, a wild plan at Oracle, the demo in the previous session. We speak the same language. And this common ground ground and shared history result in a warm, open atmosphere where conversations about sensitive topics and personal affairs can easily take place. With such a group of smart and very smart people, it seems easy to analyze the large problems of the world – and to overcome them as well (although that may have been the very agreeable local red wine speaking).

IMG_7770Some of the conversations I was part of included topics such as: Political situation in Brazil, economy of Portugal, president Trump, the Dutch elections, Oracle SaaS in Belgium, recent history and current relations in Slovenia, Croatia and Former Yugoslavia, politics and healthy food trends in Germany, history and culture in India, the Brexit and its consequences for Northern Ireland, raising children – especially at that tender age of 16 – in Slovenia, Portugal, Netherlands and the USA, regional differences within Spain, weather and seasons in Peru, absorbing the move from Mexico to Norway. 

I treasure the warm, open, positive, inquisitive, helpful attitude of the attendees – their willingness to share and help, to collaborate and appreciate. I am sure people have similar experiences with scientific communities and conferences, scouting jamborees, musical festivals and other gatherings of people with a shared passion. I am glad I have my own professional social community to be a part of.

Thanks Jürgen for building and facilitating that community – it does not just happen.IMG_7753

 

 

OMESA – the Open Modern Enterprise Software Architecture

imageStarting at the Community Day on Monday – but actually continuing an initiative that was started around Oracle OpenWorld 2016 – a small team of likeminded spirits with shared architectural interests, experiences and zeal gathered to work on OMESA – the Open Modern Enterprise Software Architecture initiative, initiated by Hajo Normann and especially Luis Weir. Taking into account many modern themes and upcoming technology patterns and trends – such as microservices, IoT, wearables and other devices, APIs, real time, big data, DevOps, scale out , stateless/server-less – the OMESA initiative tries to come up with good ways to describe, design and eventually implement enterprise software architecture patterns that actually work in real life. Drawing on the many decades experience across organizations, IT landscapes, corporate cultures as well as countries and continents, the OMESA discussions ran deep (more than 2 hours for about 20% of a single slide) and wide (from business objectives to infrastructure design, from fine grained component to end to end business flow). All in good spirit and at times quite passionate. Fun to do and very meaningful as well. image

 

 

Themes

Clearly, one community day, two conference days and two days of in depth handson workshops cover many topics and details. A number of subjects and themes kept reappearing and seemed to define the main scope for the conference and the imminent roadmaps. A prime example was: ChatBot which made an appearance in almost every presentation.

More far reaching themes included:

  • Integration – various solutions to create end to end integration flow across technology stacks, locations, cloud & on premises ;
  • SaaS Extension – Oracle focuses on various aspects of SaaS Extension (and SaaS enablement) and specific solutions for those. ABCS (Application Builder Cloud Service) is put forward as the primary solution for (simple) UI extensions of SaaS solutions. ABCS is rapidly evolving into a low code/no code/visual development environment for citizen developers and IT professionals to create cloud based user interfaces on top of local, custom business objects, SaaS APIs or custom REST APIs. Integration and Process & Workflow are other areas where through ICS with Cloud Adapters and PCS for human workflow and complex business processes the SaaS offerings can be extended and tailored. In terms of financial conditions – Oracle is offering these cloud services at very attractive price points for use with Oracle SaaS.
  • Machine Learning & AI – leveraging data to predict & recommend, based on statistical analysis of (big data) is rapidly becoming the holy grail for many organizations. The Big Data lakes are to be exploited and machine learning is one way of doing exactly that. IoT is leading to even more data and even more real time requirements. Machine Learning is popping up in various cloud services to provide them with predictive capabilities – for example in Dynamic Processes in PCS and Log and Infrastructure Analytics in OMC.
  • Processes – PCS will be extended and enriched with dynamic process (evolved from adaptive case management), business rules and more.
  • APIs – APIs – internal and external, generic business APIs and single purpose, consumer tailored APIs – API first design; API Platform/Catalog (design time) and API Gateway (runtime). apiary.io will always be free (promises Vikas Anand) – for API design and (design time) publication
  • PaaS orchestration – using the Oracle PaaS services together; having them talk to each other, share data, connections, information, logging, events, monitoring, IaaS resources. Oracle is working on that, and I getting better at it.
  • Containers & Microservices – another holy grail seems to be a definition of what a microservice is. It seems obvious that microservice is the next level in decoupling, ownership, stateless and flexible horizontal scale out and modern DevOps. In terms of implementation – containers including application contains and serverless functions – seem an obvious choice (to an extent where sometimes means and end get confused).
  • DevOps – taking ownership of a software component throughout its lifecycle (you build it, you run it, you fix it), using automated continuous delivery, automated (anti-)regression testing and automated monitoring/problem analysis as well as automated recovery/fail over and scaling. Containers at infra structure level, microservices as organization and architecture level and tooling such as Oracle Management Cloud for monitoring and analysis.

 

 

REAL – Red Expert Alliance

The partner community forum is a great opportunity for the partners who collaborate even more within the Red Expert Alliance (or REAL) to catch up with each other. With partners in Mexico, USA, Australia, Portugal, Norway, Germany, Spain, UK, The Netherlands – REAL network forms an international team of Oracle partners and over 400 Oracle Professionals, supporting customers on all continents. Split provided a good opportunity to exchange the latest developments, discuss new business propositions, better get to know each other and in general strengthen the mutual ties. Additionally, some conversations took place with new candidate members for REAL.

 

Soaring through the Clouds

IMG_7759One of the highlights for me of the community event was the Soaring through the Cloud Live Demonstration of integrating 15 cloud services – prepared by a team of seven Oracle ACEs spanning three countries and five companies. The preparation for this session started over two months before the actual performance – and in a way already started over a year ago with the first and decidedly more challenging (given the state of the PaaS Cloud services at that time) live demo at the community event in Valencia, Spain – March 2016.

In 1 hour and 20 minutes, we described an end to end business flow with many interaction points with things, social media, IT components and people including the audience. We managed to leverage 18 and demonstrate 15 cloud services, with only one or two minor hiccups around switching between Oracle Public Cloud identity domains. In doing so, we claim to have set the world record for integrating PaaaS Cloud Services.image

You can find the resources for this presentation at: http://tinyurl.com/SoaringSplit (live endpoints, UI and supporting resources including source code).

The presentation slide deck itself (including many screenshots from our live demo) is available from SlideShare:

The post The value of the Oracle PaaS Partner Community Forum appeared first on AMIS Oracle and Java Blog.

Links for 2017-03-30 [del.icio.us]

Categories: DBA Blogs

UX Can Make A Deal; Not Save One. APAC OAUX Strategy Update 2017

Usable Apps - Fri, 2017-03-31 02:00

We have been on the road with the Oracle Applications User Experience  (OAUX) strategy and resources for Oracle PartnerNetwork members again! In early March 2017, we were in Bengaluru (formerly Bangalore), India to tell our partners about the latest in the OAUX strategy, design and enablement roadmap.

OAUX & WWAC team photograph

With the regional Oracle Worldwide Alliances and Channels partner apps team

The OAUX team, led by Group Vice President, Jeremy Ashley (@jrwashley), provided insight into our UX strategy: the vision behind it, about enterprise mobility, our design philosophy, how Oracle's  SaaS UX is evolving, on extensibility, about what emerging tech offers for the enterprise and how to use the our enablement to win more deals and how to go about using our Rapid Development Kits to build great mobile cloud user experiences for SaaS using PaaS (or PaaS4SaaS, if you like).

 How it develops with OAUX

How the Oracle Applications User Experience vision develops.

Selling SaaS with User Experience Sizzle

At the Selling with UX session I outlined why SaaS UX participation was important not just to end users of SaaS, but to decision-makers. I showed some of the enterprise benefits of our great UX (we've thoughtfully designed for cross-generational use, for example) and why it's a competitive must-have and partner differentiator. I also emphasised that UX needs to be part of the entire sales approach from the outset. User Experience can make a deal, but it won't save one for you! This session also included best practices for partners demoing the SaaS UX to customers.

Cross-generational SaaS UX design

Our SaaS UX is designed for the millennial and perennial alike!

Stay tuned for an external recording of this event on the usual channels.

Rapid Design and Development Toolkits in the Cloud 

Our Rapid Development Kits enable partners to productively design and built SaaS and PaaS solutions using our innovation accelerator kits (the RDKs assembled from Oracle technology and design insight). I provided some orientation into how to go about making a decision about which tool is best; the process used; and where to get our design and build RDK resources.

Check out this recorded webinar about our Oracle ADF RDK on our Cloud Customer Connect (account required) for a typical example.

Live MAF RDK and mobile app demo

Our mobile-first Rapid Development Kit included a live demo of the kit's components and what you can do with the mobile app UX you can design and build with it.

Many thanks to the Oracle Worldwide Alliances and Channels team for working with OAUX and our partners to make this a great event!

More Bengaluru? 

  • Check out the coverage on the OAUXCloud Facebook page
  • The event will be covered in more details later on the usual OAUX channels. 

Removing duplicates in a parent child connect by path

Tom Kyte - Thu, 2017-03-30 17:46
Hi Tom, I have the code below which seems to do the job ok. I was wondering however if there's a more elegant way using analytics or other methods to come up with the same results in a more dynamic way that would factor in the level becoming 5 for...
Categories: DBA Blogs

SQL ERROR, ORA-00984: column not allowed here

Tom Kyte - Thu, 2017-03-30 17:46
I'm taking a course using SQL for the first time and while following my instructors instructions exactly as he told us to, I keep getting the error that a "column is not allowed here". I created a table called Employee like this: <code>CREATE T...
Categories: DBA Blogs

Kindly suggest how many modules in Oracle DBA and suggest best to become best DBA associate

Tom Kyte - Thu, 2017-03-30 17:46
Dear Colleague, I am manoj sai subbarao, from india hyderabad and currently working as trainee junior data analyst in data operations in production side having on hands experience on oracle database from one year and having sound knowledge in O...
Categories: DBA Blogs

Migration from 11g to 12c

Tom Kyte - Thu, 2017-03-30 17:46
We are migrating from 11g to 12c. We need to the object coverage (Oracle dependencies), as we external applications (mainly Java applications) calling our Oracle package, function procedures. So what is best way to find calling hierarchy whi...
Categories: DBA Blogs

rename datafile with dummy characters after .dbf

Tom Kyte - Thu, 2017-03-30 17:46
<i>Hi tom, i've run into an issue out of the ordinary. while adding datafile to an existing tablespace we had fews trailing characters inbedded (by mistake) at the end of the .dbf extension. We have dbvisit replication broken due to this since...
Categories: DBA Blogs

Webcast: "Online Patching with EBS 12.2"

Steven Chan - Thu, 2017-03-30 14:19

Online Patching webcastOracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for an overview of how Online Patching works in EBS 12.2, see:

The Online Patching feature of Oracle E-Business Suite 12.2 will reduce your Oracle E-Business Suite patching downtimes to however long it takes to bounce your application  server. Kevin Hudson, Senior Director Product Development, details how online patching works, with special attention to what’s happening at the database object level when patches are applied to an Oracle E-Business Suite environment that’s still running. Learn about the operational and system management implications for minimizing maintenance downtimes when applying Oracle E-Business Suite patches with this new technology and the related impact on customizations you might have built on top of Oracle E-Business Suite. This material was presented at Oracle OpenWorld 2016.

Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator