Feed aggregator

Update the table by getting the output from same table or Joining Tables

Tom Kyte - Wed, 2017-04-05 20:26
Hi, I need to update a column of table by getting the selected data from the same table using grouping function. Can you advise some sample query for this. For example: I've the data like below: <code>FOM_SAP_VKORG SDB_SAP_MATNR SDB_DATAB SDB_...
Categories: DBA Blogs

Sizes tables (INITIAL and COMPRESS)

Tom Kyte - Wed, 2017-04-05 20:26
Tom, if I create a table with the following characteristics in its partitions: <code>COMPRESS BASIC PCTFREE 0 STORAGE ( INITIAL 7748954362 --7.2 GB NEXT 1048576 --1 MB MINEXTENTS 1 MAXEXTENTS 2147483645 ...
Categories: DBA Blogs

Endless executing get_ddl

Tom Kyte - Wed, 2017-04-05 20:26
Hello, I have problem with executing dbms_metadata.get_ddl. You can find sqript with issue here: https://livesql.oracle.com/apex/livesql/file/content_ES4SXSIQNK2JLYFHH3V752UA6.html Why does get ddl procedure lasting for a long time(endless, mo...
Categories: DBA Blogs

Oracle Security Training Manuals For Sale

Pete Finnigan - Wed, 2017-04-05 20:26
I had a reason today to go to our company storage for something today and whilst moving other things around to find what I needed I discovered two A4 boxes with printed manuals for some of our recent training classes....[Read More]

Posted by Pete On 05/04/17 At 02:22 PM

Categories: Security Blogs

Jetpack 4.8 outage

Bobby Durrett's DBA Blog - Wed, 2017-04-05 17:18

I just got my bobbydurrettdba.com blog back online. It seems that an automatic update of Jetpack to version 4.8 took it down last night. I thought I would post a quick comment on how I resolved it because it is slightly different from what the Jetpack support site says.

When I tried to get into my blog today I just got a white screen saying there was a problem. I could not get into the wp-admin screen to do anything. Then I found out that Jetpack 4.8 had been pushed out and had brought down a lot of WordPress sites. Then I found out that Jetpack 4.8.1 had just come out today to fix it.

Here is the url for the 4.8.1 fix to this issue: fix

The fix points to the manual plugin install url which talks about deleting your /wp-content/plugins/jetpack folder and then manually installing by downloading the 4.8.1 jetpack zip, unzipping it, and ftping it up to /wp-content/plugins.

But all I had to do, after backing up /wp-content/plugins/jetpack was to rename it to /wp-content/plugins/jetpack.old. Then I was able to get into my site and to update the plugin to 4.8.1 through the normal web-based process.

Strangely enough the Jetpack plugin update removed my /wp-content/plugins/jetpack.old directory and replaced it with /wp-content/plugins/jetpack.

Here is what the directory looked like after I ran the update from my blogs admin page:

I never did ftp the 4.8.1 jetpack directory over though I had it unzipped and ready to go on my laptop.

Anyway, I didn’t delete my jetpack directory.  I just renamed it to jetpack.old. Then I ran the normal plugin update process.

Bobby

p.s. My site stats for today are not looking so good with the blog down all day:

Categories: DBA Blogs

Sharding with Oracle 12c R2 Part II : Scalability and Connections

Yann Neuhaus - Wed, 2017-04-05 12:12

In previous blog, we talked about system-managed sharding. We saw how it is possible to create shard databases with Oracle 12c R2. Below we remind the configuration we used.
VM sharddemo1: catalog
VM sharddemo2: shard
VM sharddemo3: shard
One of the characteristics of sharding is the scalability, and in this blog we are going to add a new shard on a new server. The new configuration will be like below
VM sharddemo1: catalog
VM sharddemo2: shard
VM sharddemo3: shard
VM sharddemo4: shard — New added shard
We supposed that you have already read the first part

After adding the new shard, we will see how we connect in a shard environment.

First let’s confirm that we have only two shards running now (one on server sharddemo2 and one on server sharddemo3):

GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ------ ------------
sh1 shgrp1 Ok Deployed region1 ONLINE
sh21 shgrp1 Ok Deployed region1 ONLINE

To add the new server sharddemo4 in the sharding environment, we first have to register remote scheduler agent on the newly added shard:

[oracle@sharddemo4 ~]$ which schagent
/u01/app/oracle/product/12.2.0.1/dbhome_1/bin/schagent


[oracle@sharddemo4 ~]$ echo welcome | schagent -registerdatabase sharddemo1 8080
Agent Registration Password ?
Oracle Scheduler Agent Registration for 12.2.0.1.2 Agent
Agent Registration Successful!
[oracle@sharddemo4 ~]$

After registration, let’s start the agent

[oracle@sharddemo4 ~]$ schagent -start
Scheduler agent started using port 16267

We must also create the corresponding directories for the database

[oracle@sharddemo4 ~]$ mkdir /u01/app/oracle/oradata
[oracle@sharddemo4 ~]$ mkdir /u01/app/oracle/fast_recovery_area

We can now launch gdsctl on sharddemo1 and connect with an administrator

[oracle@sharddemo1]$ gdsctl
GDSCTL: Version 12.2.0.1.0 - Production on Tue Mar 07 11:43:44 CET 2017
Copyright (c) 2011, 2016, Oracle. All rights reserved.
Welcome to GDSCTL, type "help" for information.
Current GSM is set to REGION1_DIRECTOR
GDSCTL>


GDSCTL>connect mygdsadmin/root
Catalog connection is established
GDSCTL>

As for existing shards, the new server sharddemo4 must be invited

GDSCTL>add invitednode sharddemo4

We also have to create the shard on sharddemo4. The shardgroup, destination and the credentials should be specified.

GDSCTL>create shard -shardgroup shgrp1 -destination sharddemo4 -credential oracle_cred
The operation completed successfully
DB Unique Name: sh41
GDSCTL>

And then now we can deploy

GDSCTL>deploy
deploy: examining configuration...
deploy: deploying primary shard 'sh41' ...
deploy: network listener configuration successful at destination 'sharddemo4'
deploy: starting DBCA at destination 'sharddemo4' to create primary shard 'sh41' ...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: waiting for 1 DBCA primary creation job(s) to complete...
deploy: DBCA primary creation job succeeded at destination 'sharddemo4' for shard 'sh41'
deploy: requesting Data Guard configuration on shards via GSM
deploy: shards configured; background operations in progress
The operation completed successfully
GDSCTL>

Running command config shard, we can verify that a new sharded database sh41 was created

GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ------ ------------
sh1 shgrp1 Ok Deployed region1 ONLINE
sh21 shgrp1 Ok Deployed region1 ONLINE
sh41 shgrp1 Ok Deployed region1 ONLINE

Now querying the 3 shards we can see that data for sharded tables are automatically balanced between the SH1, SH21 and SH41
For example we have a total of 15 rows in the catalog ORCLCAT for the sharded table CUSTOMERS that should be distributed between the 3 sharded instances

SQL> select name from v$database;
NAME
---------
ORCLCAT

SQL> select count(*) from customers;
COUNT(*)
----------
15

We have 3 rows for customer table in SH1

SQL> select name from v$database;
NAME
---------
SH1

SQL> select count(*) from customers;
COUNT(*)
----------
3

We have 3 rows for customer table in SH21

SQL> select name from v$database;
NAME
---------
SH21

SQL> select count(*) from customers;
COUNT(*)
----------
3

And 9 rows for customer table in SH41

SQL> select name from v$database;
NAME
---------
SH41

SQL> select count(*) from customers;
COUNT(*)
----------
9

Now that we have our sharded databases, how to connect? We have two ways to do it:
1- Connect to a shard by specifying a sharding_key
2- Connect to the shardcatalog via GDS$CATALOG service

For single-shard queries, we can connect to a shard with a given sharding_key using the shard director. For example let’s display data for table customers in SH41 database

SQL> select firstname,lastname,custid from customers;
FIRSTNAME LASTNAME CUSTID
--------------- --------------- ----------------------------
Seane Tuger Seane.Tuger@localdomain
Seaneis Tugeris Seaneis.Tugeris@localdomain
Seanae Tugera Seanea.Tugera@localdomain
Sophiea Moralesa Sophiea.Moralesa@localdomain
Mourada Habiba Mourada.Habiba@localdomain
Michel Robert Michel.Robert@localdomain
Sophie Morales Sophie.Morales@localdomain
Joe Dalton Joe.Dalton@localdomain
Mourad Habib Mourad.Habib@localdomain
9 rows selected.

If we want to retrieve information about customer Seane Tuger, we can connect directly to shard SH41.
For this we need first to create a global service that runs to all shard databases. This global service will be used with a sharding key

GDSCTL>add service -service my_service_shard_srvc
The operation completed successfully
GDSCTL>

Let’s start the service

GDSCTL>start service -service my_service_shard_srvc
The operation completed successfully


GDSCTL>config service
Name Network name Pool Started Preferred all
---- ------------ ---- ------- -------------
my_service_sha my_service_shard_srvc.cust_sd cust_sdb Yes Yes
rd_srvc b.oradbcloud
GDSCTL>

Now that the service is started, we can use the following connect string which will route us directly to the SH41 because of the SH4ARDING_KEY we specified.


[oracle@sharddemo2 admin]$ sqlplus user_shard/root@'(description=(address=(protocol=tcp)
(host=sharddemo1)(port=1571))(connect_data=(service_name=my_service_shard_srvc.cust_sdb.oradbcloud)
(region=region1)(SHARDING_KEY=Seane.Tuger@localdomain)))'
SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 7 14:34:48 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Mar 07 2017 13:41:56 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name from v$database;
NAME
---------
SH41

To perform cross-shard queries, we have to connect to the shardcatalog (coordinator database) using the GDS$CATALOG service (from any shard). GDS$CATALOG is a service automatically deployed in the shardcatalog.

[oracle@sharddemo1 ~]$ lsnrctl services
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-MAR-2017 14:45:14
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sharddemo1.localdomain)(PORT=1521)))
Services Summary...
Service "GDS$CATALOG.oradbcloud" has 1 instance(s).
Instance "ORCLCAT", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:604 refused:0 state:ready
LOCAL SERVER

Via sqlplus we can connect like

[oracle@sharddemo2 admin]$ sqlplus user_shard/root@sharddemo1:1521/GDS\$CATALOG.oradbcloud
SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 7 14:48:05 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Mar 07 2017 14:47:58 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name from v$database;
NAME
---------
ORCLCAT

Now that we saw how to connect, we can go further and see how oracle manage queries in a shard environment.
Let’s connect to ORCLCAT database and let’s run a query which does a SELECT query accessing multiple shards on a sharded table and let’s look the execution plan. Such queries are called cross-shard queries (CSQ)

SQL> SELECT FirstName,LastName, geo, class FROM Customers WHERE class like '%free%';

Execution Plan
----------------------------------------------------------
Plan hash value: 2953441084

--------------------------------------------------------------
| Id | Operation | Name | Cost (%CPU)| Inst |IN-OUT|
--------------------------------------------------------------
| 0 | SELECT STATEMENT | | 0 (0)| | |
| 1 | SHARD ITERATOR | | | | |
| 2 | REMOTE | | | ORA_S~ | R->S |
--------------------------------------------------------------

Remote SQL Information (identified by operation id):
----------------------------------------------------

2 - EXPLAIN PLAN SET STATEMENT_ID='PLUS470045' INTO PLAN_TABLE@! FOR
SELECT "A1"."FIRSTNAME","A1"."LASTNAME","A1"."GEO","A1"."CLASS" FROM
"CUSTOMERS" "A1" WHERE "A1"."CLASS" LIKE '%free%' /*
coord_sql_id=bkpy0tbjnqu3k */ (accessing
'ORA_SHARD_POOL@ORA_MULTI_TARGET' )

We can see above that the query is using a dblink ORA_MULTI_TARGET to perform CSQ on sharded tables. This dblink is created automatically when the gsm is configured to handle cross-shard querying.


SQL> select owner,DB_LINK,username,host from dba_db_links where owner='USER_SHARD';
OWNER DB_LINK USERNAME HOST
--------------- ----------------------------------- --------------- ---------------
USER_SHARD ORA_SHARD_POOL@ORA_MULTI_TARGET USER_SHARD GDS$CATALOG

Now let’s connect to SH1 and let’s query the duplicated table products and let’s look into the execution plan.

SQL> select * from products where productid>2;

Execution Plan
----------------------------------------------------------
Plan hash value: 1639127380

------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 158 | 0 (0)| 00:00:01 |
| 1 | MAT_VIEW ACCESS BY INDEX ROWID BATCHED| PRODUCTS | 1 | 158 | 0 (0)| 00:00:01 |
|* 2 | INDEX RANGE SCAN | SYS_C007361 | 1 | | 0 (0)| 00:00:01 |
------------------------------------------------------------------------------------------------------

We can see that a materialized view is being used. This means that for duplicated tables oracle is using materialized views to handle queries.

Conclusion

In this article we talked about sharding scalability and how to connect to shards. System-managed sharding was used. In coming articles, we will talk about other sharding methods like composite and user-defined sharding. We will also talk how it is possible to combine sharding and dataguard.

 

Cet article Sharding with Oracle 12c R2 Part II : Scalability and Connections est apparu en premier sur Blog dbi services.

OBIEE Component Status Notifications

Rittman Mead Consulting - Wed, 2017-04-05 09:00

At Rittman Mead, we often hear requests for features or solutions generally not provided by Oracle. These requests range from commentary functionality to custom javascript visualizations. There are many ways to implement these functionalities, but organizations often lack the in-house resources to engineer an acceptable solution.

Rittman Mead has the capability to engineer any solution desired, and in many cases, has already developed a solution. Many of our accelerators currently offered, such as Chit Chat or User Engagement, grew out of numerous requests for these features.

One of the more common requests we hear at Rittman Mead is for BI Administrators to receive notifications for the status of their OBIEE components. They want to be notified of the status of the system components throughout the day in a convenient manner, so any failures are recognized quickly.

This particular feature can easily be implemented with Rittman Mead's Performance Analytics service. However, Rittman Mead would like to publicly provide this capability independent of our accelerator. We have developed a small Python script to provide this functionality, and we would like to give this script to the community.

The provided script is available free of charge, and available under the MIT license. It has been tested on both OBIEE 11G and 12C environments, as well as on Windows and Linux operating systems. The rest of this blog will detail, at a high level, how the script works, and how to configure it correctly.

The script is available through our public Github repository here.

Script Output

First, let's clarify how we will gather the status of the components in the first place. Thankfully, OBIEE includes some scripts to display this information on both Linux and Windows. In 12C, the script is status.sh/status.cmd, and in 11G the primary command is opmnctl status.

When I execute this script on an OBIEE 12C OEL environment, I receive the following response:


The output includes some extra information we don't require, but we can ignore it for now. With some programming knowledge, we can trim what we don't need, organize it into a nice table, and then send the output to nearly anywhere desired. For portability and stability, I will use Python to organize the message contents and I will also use email as the channel of communication.

Sending the Output Through Email

If we are only concerned with notifying administrators of the current status, one of the better avenues to send this data is through email. An email destination will allow users to be able to receive the status of the components almost instantaneously, and be able to take the appropriate action as soon as possible.

Additionally, Python's standard set of modules includes functions to assist in sending SMTP messages, making the script even more portable and maintainable. The simplest method to generate the email is just by sending the complete output as the body of the message. An example of this output is below:

While this works, it's not exactly attractive. With some Python and HTML/CSS skills, we can style the email to look much nicer:


Now we have something nice we can send BI Administrators to show the status of the components.

Configuration and Use

To effectively utilize this script, you will have to change some of the configuration parameters, located at the top of the script. The parameters I am using are shown below (with sensitive information hidden, of course):

The sender and username fields should both be the user you are logging in as on the SMTP server to send the email. If you want the email address shown on a message to be different than the user configured on the SMTP server, then these can be set separately. The password field should be the password for the user being configured on the SMTP server.

The recipient field should be the address of the user who will be receiving the emails. For simple management, this should be a single user, who should then be configured to forward all incoming status emails to the responsible parties. This will allow easier maintenance, since modifying the list of users can take place in the email configuration, rather than the script configuration. In this example, I am just sending the emails to my Rittman Mead email address.

The SMTP settings should also be updated to reflect the SMTP server being utilized. If you are using Gmail as the SMTP server, then the configuration shown should work without modifications.

Finally, the python script requires the absolute path to the status command to execute to produce the output (the opmnctl or status commands). Environment variables may not be taken into consideration by this script, so it's best to not use a variable in this path.

NOTE: If the \ character is in the path, then you MUST use \\ instead. This is especially true on Windows environments. If this change is required but omitted, the script will not function properly.

Additionally, if you don't care about the HTML output (or if it doesn't render nicely in your email client), then it can be disabled by setting the value of render_html to False. If, for some reason, the nice HTML fails to render, then the email will just send the plain text output, instead of failing to deliver an email at all.

Once configured, try executing the script:
python email_component_status.py

If everything worked correctly, then you should have received an email with the status of the components. If you do not receive an email, then you should check both the configuration settings, and the internet connection of the machine (firewalls included). The script will also generate output that should assist you in troubleshooting the cause of the problem.

Additional Notifications or Destinations

The solution provided, while useful, is not perfect. What if you want to send this information to a destination other than an email address, such as a ticketing system like Atlassian JIRA? Or what if you want notifications based on other situations, such as slow running reports, or high CPU usage?

There may be many situations in which you would want one, or several, employees to receive different notifications based on events or circumstances that occur in your OBIEE environment. The script in this blog post only provides one of these notifications, but implementing many more will quickly become burdensome.

As part of Rittman Mead's Performance Analytics offering, we include custom software and code to fulfill this requirement. In addition to providing dashboards to explore the performance of your OBIEE systems, Performance Analytics can be configured to distribute alerts, based on any quantifiable condition, to any number of external systems.

The full Performance Analytics suite can not only alert users of down system components, but of any number of conditions that may occur in your BI environment.

If you have questions about this script, Performance Analytics, or anything else Contact Us here.

To find out more about Performance Analytics, contact us, visit the product page here, or read some of the fantastic blogs from Robin Moffatt.

Categories: BI & Warehousing

7-Eleven Mexico Deploys Oracle Retail to Streamline and Simplify Operations

Oracle Press Releases - Wed, 2017-04-05 07:00
Press Release
7-Eleven Mexico Deploys Oracle Retail to Streamline and Simplify Operations Mexican Convenience Store Empowers Associates with Better Information and Visibility

Redwood Shores, Calif.—Apr 5, 2017

Today, Oracle announced that 7-Eleven Mexico S.A. implemented Oracle Retail to simplify operations and facilitate the customer experience. In Mexico, today’s consumer demands access to brands and a differentiated experience. 7-Eleven Mexico embraced technology, empowering them to keep up with the changing demands of the market. 7-Eleven Mexico operates 1,950 convenience stores supported by 8 distribution centers and 18,000 collaborators across 15 states in Mexico.

7-Eleven Mexico has adopted best practices and deployed Oracle Retail Merchandise Operations Management solutions to support growth and transformation. The company implemented Oracle Retail Merchandising System, Oracle Retail Price Management, Oracle Retail Sales Audit and Oracle Retail Invoice Matching to automate best practices, improve communication among the stores and provide more complete data to empower associates with the help of Oracle Partner Network Gold Level Partner Logic Information Systems.

"The consumer is changing and we need to be more and more agile to anticipate these changes and inspire the shopping experience. In order to do this, we need to simplify and modernize our IT structure, eliminating limitations, increasing flexibility in offering products, targeting our business and promotion strategies, automating processes and obtaining information in real-time,” said Eduardo Trujillo Olguín, Chief Financial Officer of 7-Eleven Mexico. “We selected Oracle Retail because of its partner network, risk management, cost-effectiveness throughout the solution lifecycle and alignment to our business priorities.”

With the introduction of the new system, 7-Eleven Mexico has given teams the ability to adopt a more aggressive business strategy to retain and attract customers. The replacement of the technology platform has also addressed an important aspect of 7-Eleven's philosophy: empowering store managers to take decisions about the quantity and type of product at each point of sale, making each store a mix that fits the reality of their micro market, at every moment of the day and at special events.

"This is the largest enterprise implementation ever done by 7-Eleven Mexico. We chose Oracle Retail because we needed a platform that would empower us to adopt industry best in class practices. We have verified our gaps and made important changes in the way we do business to have the minimum customization of the solution" said Eduardo Trujillo Olguín, Chief Financial Officer of 7-Eleven Mexico.

“At Oracle Retail, we are focused on empowering retailers to align retail operations to attract and retain more customers with the right merchandise, promotions, the right price, at the right place. 7-Eleven Mexico has a smart strategy in place that focuses on engaging and understanding the consumer at the store level,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are honored to help simplify and streamline the 7-Eleven Mexico IT structure to allow them to adapt to the changing retail.”

"We are proud to work with 7-Eleven Mexico to drive additional revenue by properly localizing individual markets through enabling store leaders with seamless communication on pricing and product information. This will surely assist in acquiring and keeping loyal customers while saving store associate’s time automating critical processes,” said Amber Naqvi, President, Logic Information Systems.

 
Contact Info
Matt Torres
Oracle Corporation
+1 415-595-1584
matt.torres@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Matt Torres

  • +1 415-595-1584

University of Wyoming Uses Oracle Cloud to Drive Core Mission of Teaching, Research, and Service

Oracle Press Releases - Wed, 2017-04-05 07:00
Press Release
University of Wyoming Uses Oracle Cloud to Drive Core Mission of Teaching, Research, and Service Higher education institution’s initiative provides modern, sophisticated cloud solutions to align technology with strategic business planning

Redwood Shores Calif—Apr 5, 2017

Oracle today announced that the University of Wyoming (UW), has selected Oracle Cloud to transform the way UW does business at every level, by providing a modern and synchronized technology platform to further academic excellence. As Wyoming’s only provider of baccalaureate graduate education, research, and outreach services, UW decided it could no longer wait to redesign its 20-year-old systems. The initiative incorporates finance, human resources (HR), budgeting and planning, grant management, and supply chain management systems—all of which are core to the University’s operations.

The university’s strategic Oracle Cloud implementation, named WyoCloud, will help UW respond to today’s opportunities and challenges by enabling department staff to access timely, accurate information at the right time to run the institution more efficiently. Oracle’s complete and modern solutions will thus free employees to focus more time and effort on enhancing the student experience now and in the future.  

UW’s new cloud-based finance, HR, grant management, and supply chain solutions include seamless implementations of Oracle’s Enterprise Resource Planning  (ERP) Cloud, Enterprise Performance Management (EPM) Cloud, Supply Chain Management (SCM) Cloud, and Human Capital Management (HCM) Cloud.

The project has received tremendous support and interest from the UW community and the WyoCloud team has prioritized outreach, communication, and ongoing training efforts to help streamline the transition to the new systems. WyoCloud has also formed a network of Change Agents to provide additional channels for information and feedback on the project.

“We had a competitive proposal process where the selection committee unanimously chose the Oracle Cloud for its ability to help enable our university’s pursuit of excellence based on their history of success in supporting the specific needs of higher education,” said Jennifer Chavez, Director, Application and Database Services, at the University of Wyoming. “As a premier educational institution, it is our top priority to run our university in the most efficient manner to ensure our students succeed and compete.”

Oracle Cloud Applications’ unified interface and powerful reporting and analytics provide intuitive, real-time information for insightful decision making, allowing UW to leverage the solutions to help the university better configure the way they do business. UW’s systems will soon leverage the same Oracle ERP and EPM Cloud technology that helps thousands of companies integrate readily available data into reliable reports. This technology incorporates a modern user interface, embedded analytics, contextual social collaboration, and a device-independent mobile experience designed to make the solution familiar and easy to use.

Oracle SCM Cloud will help enable strategic sourcing and resource planning and better procurement processes so UW can more efficiently use state resources with the savings. Oracle HCM Cloud will allow UW’s HR department to leverage the proper information and technology to better attract and support students.

“By adopting the latest cloud technology, the University of Wyoming is establishing a path toward continued growth, academic innovation, and student success,” said Terrance Wampler, vice president of financials applications strategy at Oracle. “Oracle is committed to furthering the success of higher education institutions. Our next-generation cloud platform will help streamline and modernize processes to allow University of Wyoming’s faculty and staff to focus on education innovation and to better attract and support their students.”

Oracle delivers the industry’s broadest suite of enterprise-grade cloud services, including Software as a Service (SaaS), Platform as a Service (PaaS), Infrastructure as a Service (IaaS), and Data as a Service (DaaS).

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.com
Chad Baldwin
University of Wyoming
+1.307.766.2929
cbaldwin@uwyo.edu
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Joann Wardrip

  • +1.650.607.1343

Chad Baldwin

  • +1.307.766.2929

America’s Fastest-Growing Companies Forecast Rapid Expansion Yet Lack Technology Expertise to Keep Pace

Oracle Press Releases - Wed, 2017-04-05 07:00
Press Release
America’s Fastest-Growing Companies Forecast Rapid Expansion Yet Lack Technology Expertise to Keep Pace Study Reveals Companies are Highly Optimistic about Growth but Need Cloud Technology Innovation and Strategy to Overcome Challenges

Redwood Shores, Calif.—Apr 5, 2017

Leaders of the 5000 fastest growing private companies in America – known as the Inc. 5000—have an overwhelmingly optimistic outlook for 2017, according to Oracle’s The Talent and Tech Driving America’s Fastest Growing Companies survey, released today.

Nine out of 10 respondents (89 percent) describe themselves as either extremely confident or very confident about their prospects for the future. Backed by this confidence, the majority plan to expand their workforce (91 percent), offer new products (61 percent), move into new markets (65 percent) and do more business internationally (32 percent) in the coming year.

Realizing the Potential of the Cloud to Propel Growth

In order to support their expansion, the majority of the Inc. 5000 have adopted cloud technology.

  • Nearly 60 percent cite scalability and flexibility for growth as primary drivers of cloud adoption
  • Twenty-two percent see the primary benefit as increased internal communication and collaboration
  • More than 83 percent of respondents have at least two functions in the cloud

However, many of these businesses aren’t fully optimizing the potential of the cloud to aid in their growth and avoid plateauing.

  • Just over a third (36 percent) have their finances in the cloud
  • Only 29 percent have put their e-commerce functions into cloud solutions, compared to over half who have migrated sales and human resources to the cloud (51 and 62 percent, respectively)
  • Forty-four percent struggle to achieve integration across cloud products

Partnering for Cloud Success

Of the 41 percent who ranked investing in technology a top-three priority for 2017, only 23 percent cited maintaining a competitive edge as a reason to make the investment, pointing to the fact that companies lack the strategic direction to differentiate and avoid stagnation.

“Rapidly growing small and medium businesses have had the advantage of building on the cloud from day one,” said Reggie Bradford, senior vice president, Startup Ecosystem and Accelerator, Oracle. “But their fast growth, paired with the array of cloud solutions from different vendors, presents some challenges. To avoid stagnation, SMBs need a cloud vendor that guides them in addressing product integration issues, selecting the best fit—for budget and business purpose—and truly understanding future cloud opportunities.”

“With Oracle PaaS, we built our marketing operations solution in two months instead of six,” said John Yoho, vice president, Transformational Growth, Element Solutions, an Oracle customer. “This gave us an immediate return on investment and allowed us to focus on our client’s experience. As we continue to grow, Oracle will help us scale and add products from their integrated, complete suite to address new needs and opportunities. They handle the technical complexities so we can focus on accelerating our growth, backed by the cloud.”

Methodology and Resources

The Talent and Tech Driving America’s Fastest Growing Companies study, commissioned by Oracle and fielded by Inc. Media, surveyed leaders of companies that are current or recent Inc. 5000 honorees. The Inc. 5000 list ranks companies by three-year sales growth, among other factors. The average growth rate of the Inc. 5000 was 128 percent over three years, with average annual sales of $40 million. The Inc. 5000 companies created 640,127 new jobs during the previous three years.

View the complete story on the survey here.

For more information on how Oracle can help accelerate growth in small and midsize businesses, visit https://go.oracle.com/smb.

Contact Info
Julia Allyn
Oracle Corporate Communications
+1.650.607.1338
julia.allyn@oracle.com
About Inc. Media

Founded in 1979 and acquired in 2005 by Mansueto Ventures, Inc. is the only major brand dedicated exclusively to owners and managers of growing private companies, with the aim to deliver real solutions for today’s innovative company builders. Inc. was the winner of the National Magazine Award for General Excellence in both 2014 and 2012. Total monthly audience reach for the brand has grown significantly from 2,000,000 in 2010 to more than 13,000,000 today. For more information, visit www.inc.com.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Safe Harbor

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

Talk to a Press Contact

Julia Allyn

  • +1.650.607.1338

Oracle Listener Security New ORACLE 12.2 Firewall Feature

Service-Level ALCs is a new feature of the 12.2 Listener that allows every database service to have its own ACL. The ACL must be based on IP addresses and this feature allows multitenant pluggable databases (PDBs) to each have an ACL enforced by the Listener. This is because each PDB is a unique service registered in the Listener.

To implement this feature a new parameter FIREWALL must be used and has the following options:

  • (FIREWALL=ON) - This enables strict ACL validation (whitelist-based approach) of all connections based on the ACLs. If no ACLs are configured for a service, all connections are rejected.
  • FIREWALL is not set (defined for service) – This is a mixed mode. If an ACL is configured for a service, it will be enforced. If no ACL is defined, all connections will be accepted.
  • (FIREWALL=OFF) No validation (No ACLs enforced) and all connections are accepted

For more information refer to: http://docs.oracle.com/database/122/NETAG/configuring-and-administering-oracle-net-listener.htm#NETAG0102

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

-Michael Miller, CISSP-ISSMP, CCSP, CCSK

 
 
Security Strategy and Standards, Oracle Database
Categories: APPS Blogs, Security Blogs

12.2 Some Cool Partitioning New Features (Big Wheels)

Richard Foote - Wed, 2017-04-05 03:21
I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2. Thought I might run through a number of really cool new partitioning features and capabilities that were also introduced in 12.2. To start, I’m just going to create a basic range-partitioning table and populate […]
Categories: DBA Blogs

Limit the number of opening and closing oracle sessions.

Tom Kyte - Wed, 2017-04-05 02:06
Hi all, Issue: Large number of opening and closing Oracle database sessions (on average 100k per hour).App is loading files into database by using sqlldr and for each file creating a new session. After loading session is closed. Probably it has n...
Categories: DBA Blogs

How to use synonym to repoint the table

Tom Kyte - Wed, 2017-04-05 02:06
Hi, I am using 10g, other than renaming of table to swap the latest result from the data loading. Instead, this is not created as table, but Materialized view. How do we swap the latest result from materialized view but not interrupting the existi...
Categories: DBA Blogs

IGNORE_ROW_ON_DUPKEY_INDEX like hint for Foreign Key Constraint Violation.

Tom Kyte - Wed, 2017-04-05 02:06
Hi, Like we have IGNORE_ROW_ON_DUPKEY_INDEX hint which will say to ignore any duplicates that are there in my select query, do we have any hint to say ignore records which violated foreign key constraints and load them? For example: if I have ...
Categories: DBA Blogs

how to replace the line break with tab space in database in all the column of the database

Tom Kyte - Wed, 2017-04-05 02:06
We have one database which has 10 table contains 10 columns in each table, which contain Line break data(\n) in 5 Columns I Want all the 5 different columns data to be replaced with spaces if it contains line break. I want it in a single query at sch...
Categories: DBA Blogs

Extra line at the end of file while calculating checksum in oracle

Tom Kyte - Wed, 2017-04-05 02:06
Hi Tom, This is the file generated by my procedure: <code> "FV","3.0" "FH","20170404","001","1","loftpaypal@loft.com" "BH","1","USD","loftpaypal@loft.com" "1","RF","03F359879C231283P","USD","13.99","","591111895" "2","RF","0FA889952A037821...
Categories: DBA Blogs

Cannot "select *" table from other Server with schema name prefix

Tom Kyte - Wed, 2017-04-05 02:06
Hi Tom, My department has 2 Oracle database servers at different city, let's say db1 and db2. Data exchange between database is only using Oracle jobs which either refreshing materialized views or delete-insert tables. Few days ago there was ne...
Categories: DBA Blogs

ERR_CONNECTION_REFUSED Error.

Tom Kyte - Wed, 2017-04-05 02:06
Hi Friendz. I am unable to connect to localhost for apex 4.2 version. I am getting error "ERR_CONNECTION_REFUSED" when i ran local host on chrom. (http://localhost:8080/apex/apex_admin) [ This site can?t be reached localhost refused to ...
Categories: DBA Blogs

Literals with two single quotes unexpectedly working

Tom Kyte - Wed, 2017-04-05 02:06
Hi Tom, after many years using Oracle, I fortuitously found a amazing statement, with strange literals accepted in SQL and PL/SQL, although their syntax are incorrect. Test case is in LiveSQL link. I tested it on 10.2.0.4 and 12.1.0.2 versions...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator