Feed aggregator

database switch over using dgmgrl

Learn DB Concepts with me... - Thu, 2016-02-25 09:59
Perform a switch over test:


ON PRIMARY DB SERVER :

SQL> select name,open_mode,db_unique_name ,DATABASE_ROLE from v$database;

NAME  OPEN_MODE       DB_UNIQUE_NAME      DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
ORCL  READ WRITE       ORCL      PRIM

ON STANDBY DB SERVER :

SQL> select name,open_mode,db_unique_name ,DATABASE_ROLE from v$database;

NAME  OPEN_MODE       DB_UNIQUE_NAME      DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
ORCL  MOUNTED       ORCLSTB1      PHYSICAL STANDBY


LETS CONNECT TO DGMGRL AND SWITCH OVER ROLES

DGMGRL> switchover to 'ORCLSTB1';
Performing switchover NOW, please wait...
Operation requires a connection to instance "ORCLSTB1" on database "ORCLSTB1"
Connecting to instance "ORCLSTB1"...
Connected.
New primary database "ORCLSTB1" is opening...
Operation requires startup of instance "ORCLPRIM" on database "ORCL"
Starting instance "ORCLPRIM"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.
Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
start up and mount instance "ORCLPRIM" of database "ORCL"


ON OLD PRIMARY DB SERVER (ORCL) :

I have to start it manually coz dgmgrl was unable to connect to lsnr after role transfer.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  885211136 bytes
Fixed Size    2258320 bytes
Variable Size  566233712 bytes
Database Buffers  310378496 bytes
Redo Buffers    6340608 bytes
Database mounted

SQL> select name,open_mode,db_unique_name ,DATABASE_ROLE from v$database;

NAME  OPEN_MODE       DB_UNIQUE_NAME      DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
ORCL  MOUNTED       ORCL      PHYSICAL STANDBY


LETS CONFIRM THE DB_ROLE BY QUERYING STANDBY DATABASE

SQL> select name,open_mode,db_unique_name ,DATABASE_ROLE from v$database;

NAME  OPEN_MODE       DB_UNIQUE_NAME      DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
ORCL  READ WRITE       ORCLSTB1      PRIMARY

Categories: DBA Blogs

Partner Webcast: WebCenter Sites Automation Toolkit

WebCenter Team - Thu, 2016-02-25 07:09
You're Invited to attend Redstone's Live Webcast: 'WebCenter Sites Automation Toolkit'
When: Thursday, March 8th at 3:00 PM CDT

The WebCenter Sites Automation Toolkit is a set of tools and systems that enable WebCenter Sites administrators, developers and users to automate processes such as: asset import, asset creation, bulk updates and mirroring of environments with WebCenter Sites 11g and 12c versions. During this live webcast, Redstone will provide an overview and live demonstration of the WebCenter Sites Automation Toolkit. At the conclusion of the live demonstration, we'll field questions from the audience. 

Special Offer
All registered attendees interested in Redstone's WebCenter Sites Automation Toolkit will receive a limited time offer for discounted Toolkit licensing.  Redstone will also make a special announcement at the end of the Webcast regarding a new product offering coming soon!

Webcast Agenda
  1. Automation Toolkit Overview
  2. Solution Demo
  3. Q & A 

Sales Cloud Support Resources

Chris Warticki - Thu, 2016-02-25 06:44

Firstand ALWAYS – the #1 investment is made in the PRODUCT, PRODUCT, PRODUCT.

Remaina student of the product.

1. Sales Cloud ProductInformation Page

2. Modern CRM ProductInformation Page

3. Sales Cloud Documentation and Resources

1.

2.

3.

4. SalesCloud Release Readiness

5. Sales Cloud LearningLibrary

6. Sales Cloud LearningSubscription

7. Oracle University – FusionApplications Training

4.

5.

6.

7.

8. Cloud.Oracle.com – Oracle CloudPortal (Subscription and Services Admin)

8.

9.

10.

11.

Sales Cloud - Applications Customer Connect

Personalize My Oracle SupportExperience

· Setup ProactiveAlerts and Notifications

· StarFavorite: InformationCenter: Oracle Fusion Applications - Oracle Sales Cloud

· Customize your MOSDashboard

Collaborate. Communicate. Connect

· Subscribeto Cloud and SaaS, Newsletters

· Sales News

· Oracle Mobile App – News, Events,Mobile MOS, Videos etc

· Oracle Support's Sales Cloud Community

o Alerts

o Popular Documents

o Information Center: Oracle Fusion Sales

o Information Center:Fusion Applications ADFDI

o Information Center: Trading Community Model for Fusion CRMProduct V1.0

o Information Center: Installing Oracle Fusion Sales

o Information Center: Troubleshooting Oracle Fusion Sales Catalog

o Information Center: Oracle Fusion Sales Catalog

o Information Center: Troubleshooting Oracle Fusion SalesForecasting

o Information Center: Using Oracle Fusion Territory Management

o Information Center: Patching Oracle Fusion Territory Management

o Information Center: Overview - Oracle Fusion TerritoryManagement

SOCIAL Circles of Influence

· Oracle Sales Cloud - Twitter

· Cloud Solutions Blog

· Oracle ApplicationsBlog

· YouTube – Sales Cloud

· OracleCloud Zone

· OracleCloud Marketplace

· Cloud Café (Podcasts)

Engage with Oracle Support

1. Upload ALL reports if logging a Service Request

2. Leverage Oracle Collaborative Support (web conferencing)

3. Better Yet – Record your issueand upload it (why wait for a scheduled web conference?)

4. Request Management Attention as necessary

Sales Cloud Support Resources

Chris Warticki - Thu, 2016-02-25 06:44

First and ALWAYS – the #1 investment is made in the PRODUCT, PRODUCT, PRODUCT.

Remain a student of the product.

1. Sales Cloud Product Information Page

2. Modern CRM Product Information Page

3. Sales Cloud Documentation and Resources

1.

2.

3.

4. Sales Cloud Release Readiness

5. Sales Cloud Learning Library

6. Sales Cloud Learning Subscription

7. Oracle University – Fusion Applications Training

4.

5.

6.

7.

8. Cloud.Oracle.com – Oracle Cloud Portal (Subscription and Services Admin)

8.

9.

10.

11.

Sales Cloud - Applications Customer Connect

Personalize My Oracle Support Experience

· Setup Proactive Alerts and Notifications

· Star Favorite: Information Center: Oracle Fusion Applications - Oracle Sales Cloud

· Customize your MOS Dashboard

Collaborate. Communicate. Connect

· Subscribe to Cloud and SaaS, Newsletters

· Sales News

· Oracle Mobile App – News, Events, Mobile MOS, Videos etc

· Oracle Support's Sales Cloud Community

o Alerts

o Popular Documents

o Information Center: Oracle Fusion Sales

o Information Center:Fusion Applications ADFDI

o Information Center: Trading Community Model for Fusion CRM Product V1.0

o Information Center: Installing Oracle Fusion Sales

o Information Center: Troubleshooting Oracle Fusion Sales Catalog

o Information Center: Oracle Fusion Sales Catalog

o Information Center: Troubleshooting Oracle Fusion Sales Forecasting

o Information Center: Using Oracle Fusion Territory Management

o Information Center: Patching Oracle Fusion Territory Management

o Information Center: Overview - Oracle Fusion Territory Management

SOCIAL Circles of Influence

· Oracle Sales Cloud - Twitter

· Cloud Solutions Blog

· Oracle Applications Blog

· YouTube – Sales Cloud

· Oracle Cloud Zone

· Oracle Cloud Marketplace

· Cloud Café (Podcasts)

Engage with Oracle Support

1. Upload ALL reports if logging a Service Request

2. Leverage Oracle Collaborative Support (web conferencing)

3. Better Yet – Record your issue and upload it (why wait for a scheduled web conference?)

4. Request Management Attention as necessary

Normal 0 false false false EN-US X-NONE X-NONE /* 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:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif"; mso-bidi-font-family:"Times New Roman";}

First Steps with Oracle Application Builder Cloud Service

Shay Shmeltzer - Wed, 2016-02-24 19:22

Last week we released a new cloud service - the Oracle Application Builder Cloud Service.

(I'll refer to is as ABCS here to keep it short).

ABCS is built for the non-professional developer, what some call the citizen developer, giving them a solution to very quickly build and publish applications that can address immediate business needs. As you'll see in the demo below, a UI first approach makes development very simple.

I recorded a quick demo to show you just the basics of app development and wet your appetite.

As you'll see ABCS makes it dead simple to create Web apps, define business objects that you want to track (implemented as tables in an Oracle cloud database instance), and fine tune the UI creating multiple forms. The underlying UI technology of both ABCS and the apps that it creates is Oracle JET. 

Note that in this video I didn't cover the steps to actually stage and then publish your application so other users can access it - another thing that ABCS makes simple. On these and other capabilities in future blogs...

Categories: Development

SOUG Training Day May 2016 in Switzerland

Randolf Geist - Wed, 2016-02-24 12:27
I will be one of the speakers at the first SOUG performance training day, together with Christian Antognini, Franck Pachot and Clemens Bleile.

The event will take place in May this year in Switzerland at two different locations / days (one in German language, one in French, except mine, which will be in English).

My presentations will be:

- Analyzing and Troubleshooting Oracle Parallel Execution

- Advanced Oracle Troubleshooting

Hope to see you there!

Update: Here is the link to the official landing page of the event on the SOUG website.

Below is the official announcement published by SOUG with more details:


"Block the date ! SOUG performance training day the 18th and 19th of May exclusively in Switzerland"

In 2016 the Swiss Oracle User Group (SOUG) will introduce a new kind of event called the "SOUG training day".

During a whole day several world class speakers will teach the participants on a particular topic.

This year, Christian Antognini (Trivadis), Randolf Geist, Franck Pachot (dbi services) and Clemens Bleile (dbi services) will help the participant to manage the performances of their Oracle databases. The following topics will be addressed and explained in depth :

Strategies for Keeping Object Statistics Up-to-Date
Next-Generation Oracle Database - New Performance Features
Analyzing and Troubleshooting Oracle Parallel Execution
Advanced Oracle Troubleshooting
Interpreting AWR Reports - Straight to the Goal
All About Table Locks: DML, DDL, Foreign Key, Online Operations in regards to performance

The SOUG invites you to block the following dates to be sure that you do not miss such an incredible opportunity to meet the cracks :

- 18th of May in Olten - presentations in German
- 19th of May in Geneva - presentations in French (Mr Randolf Geist will present 2h in english)

This training day will be proposed to very attractive conditions :
- CHF 500.- for SOUG members
- CHF 1000.- for non-DOUG members

Webinar: Best Practices for Digital Experience Adoption

WebCenter Team - Wed, 2016-02-24 08:27


Digital experience strategies and technologies are ever-changing in this competitive ecosystem. How does your organization stack up against others in key practices like collaboration and business automation?

Join CMSWire with Oracle for a one-hour webinar to examine the results of a major digital experience and engagement survey. Discover how your industry peers create and manage their content through multiple channels and drive their digital efforts for greater connections with their customers, employees, partners and the general public.

Thursday, February 25th at 11:00am PT / 2:00pm ET / 19:00 GMT

This webinar will cover:
  • Survey results from over 100 respondents
  • Self-service and business automation practices
  • Social collaboration and content drivers
Register today!

Bundle Patch 3 Now Available for Application Management Pack 12.1.0.4

Steven Chan - Tue, 2016-02-23 14:53

Application Management Pack (AMP) 12.1.0.4.0 for Oracle E-Business Suite was released in June 2015. We have just released the third set of updates for AMP 12.1.0.4.0. These updates include enhancements as well as fixes for stability and performance issues.

We strongly recommend that you apply Bundle Patch 3 to your E-Business Suite environments and your Enterprise Manager server:

What's New in Bundle Patch 3?

  • Discover and monitor Oracle E-Business Suite targets hosted on Oracle Cloud.
  • Support is now enabled for discovering multiple instances with the same SID.
  • The naming convention of the Oracle E-Business Suite targets is changed. It no longer uses the DB SID as a prefix. The Database target name is used instead, which is passed for discovery.
  • The DB target name, which is passed to the EBS target discovery, can only contain alphanumeric characters and period ('.').
  • For a successful discovery, the preferred credentials must now be set for the host where the admin server is running. On Oracle E-Business Suite Release 12.2 or later, the preferred credentials setup must be completed on both the patch and run file system admin servers. If not, pre-validation will fail.
  • Host aliasing is now automated and will attempt to match the host name in the EBS context file and the discovered host name in Oracle Enterprise Manager. If this attempt fails, you will be prompted to perform the mapping manually.
  • Customization Manager and Patch Manager now support host aliasing.

References

Related Articles

Categories: APPS Blogs

@OracleSocial: Help! I Need To Provide Social Customer Service!

Linda Fishman Hoyle - Tue, 2016-02-23 10:35

A Guest Post by Maggie HustonSenior Content Manager, Oracle Social Cloud (pictured left)

“When people needed customer service, they used to send a letter or pick up the phone. Now, people use social media to get the attention of the company. It’s faster and easier to do. Nobody wants to wait on hold. Nobody likes smooth jazz.” — Jay Baer, New York Times and Amazon best-selling author and CEO of Convince & Convert


Apologies to smooth jazz lovers, but Jay Baer is right. More than 1 in 3 people prefer social media to traditional channels like email or call centers. Are you prepared? Could you handle a social media crisis? What about day-to-day customer service needs?

Don’t worrywe can help. Oracle Social Cloud will be at South by Southwest (SXSW) on Monday, March 14. SXSW is a “unique convergence of original music, independent films, and emerging technologies. Fostering creative and professional growth alike, SXSW is the premier destination for discovery.” If you’re interested in registering, click here

In a session entitled "Is Twitter the New Customer Call Center?" executives from General Motors (Rebecca Harris), Southwest Airlines (Ashley Mainz), Cummins Inc. (Michael Nagel), and Oracle (Angela Wells) will discuss how to provide excellent customer service over social media. It's on the schedule from 3.30 - 4.30 p.m. at the Hilton Austin Downtown, Salon J 500 E 4th Street.

Don’t miss the Official SXSW Party at Cedar Street Courtyard on Saturday, March 12. From 3.30 - 4.30 p.m., digital advertising executives from ZenithOptimedia, MediaMath, and Hewlett Packard will discuss how to deliver more relevant experiences in the face of disparate data points and aggressive ROI goals. The Spazmatics, the “Ultimate New Wave 80’s Show,” will play from 6.30 - 10.30 p.m. Beer and wine will be served alongside local food favorites and 1,400+ new friends. It’s a great way to #KnowYourPeeps!

This is going to be a great conference! If you can’t make it to SXSW March 11-15, follow us on Twitter, Instagram, the Social Spotlight blog, and Facebook for highlights and behind-the-scenes memories.

Service Cloud (RightNow) Support Resources

Chris Warticki - Tue, 2016-02-23 08:29

Firstand ALWAYS – the #1 investment is made in the PRODUCT, PRODUCT, PRODUCT.

Remaina student of the product.

1. Service Cloud Product Information Page

· Watch Service Cloud in action

· Quicktour

· Release Readiness

2. Trainingon the PRODUCT - Service Cloud (RightNow) Training

· ServiceCloud LearningCenter

· Oracle Cloud Learning Library

· Oracle Service Cloud (RightNow) Social ExperienceAdministration Collection

Service Cloud Learning Subscription - Thelearning subscription is organized into these channels:

· What's New

· Getting Started

· Administer and Implement

· Extensibility

· Use

· Analytics and Reports

· Coexist

· Collaborate

1.

2.

3. Oracle Cloud Portal (Subscription and ServicesAdmin)

· Demos & Videos

· Service Data Sheets

· White Papers

· Documentation

1.

2.

3.

4. Service Cloud(RightNow) Support Portal

  • Email Preferences

  • Support Notifications

  • Community Subscriptions

  • Expand your Network

5. Subscribeto Cloud,CX and SaaS, Newsletters

6. Service Cloud - Applications CustomerConnect

Oracle MobileApp – News, Events, Videos etc

SOCIAL Circles of Influence

· OracleService Cloud

· OracleService Cloud Support

· OracleCloud Zone

· Oracle CloudMarketplace

· Cloud Café (Podcasts)

· Oracle Customer Experience Blog

Engage with Oracle Support:

· Upload any necessary reports if logging a Service Request

· LeverageOracle Collaborative Support (web conferencing)

· BetterYet – Record your issue and upload it (why waitfor a scheduled web conference?)

Service Cloud (RightNow) Support Resources

Chris Warticki - Tue, 2016-02-23 08:29
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

First and ALWAYS – the #1 investment is made in the PRODUCT, PRODUCT, PRODUCT.

Remain a student of the product.

1. Service Cloud Product Information Page

· Watch Service Cloud in action

· Quick tour

· Release Readiness

2. Training on the PRODUCT - Service Cloud (RightNow) Training

· Service Cloud Learning Center

· Oracle Cloud Learning Library

· Oracle Service Cloud (RightNow) Social Experience Administration Collection

Service Cloud Learning Subscription - The learning subscription is organized into these channels:

· What's New

· Getting Started

· Administer and Implement

· Extensibility

· Use

· Analytics and Reports

· Coexist

· Collaborate

1.

2.

3. Oracle Cloud Portal (Subscription and Services Admin)

· Demos & Videos

· Service Data Sheets

· White Papers

· Documentation

1.

2.

3.

4. Service Cloud (RightNow) Support Portal

  • Email Preferences

  • Support Notifications

  • Community Subscriptions

  • Expand your Network

5. Subscribe to Cloud, CX and SaaS, Newsletters

6. Service Cloud - Applications Customer Connect

Oracle Mobile App – News, Events, Videos etc

SOCIAL Circles of Influence

· Oracle Service Cloud

· Oracle Service Cloud Support

· Oracle Cloud Zone

· Oracle Cloud Marketplace

· Cloud Café (Podcasts)

· Oracle Customer Experience Blog

Engage with Oracle Support:

· Upload any necessary reports if logging a Service Request

· Leverage Oracle Collaborative Support (web conferencing)

· Better Yet – Record your issue and upload it (why wait for a scheduled web conference?)

/* 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

Why Oracle Documents Presenter Should be Your New Favorite Mobile App?

WebCenter Team - Tue, 2016-02-23 06:00

Author: Mark Paterson, Director, Oracle Documents Cloud Service Product Management

If you work in marketing and are looking for better ways to mobilize your sales teams and to provide them with the right collateral you should consider Oracle Documents Cloud Service as part of your Sales Enablement solution.

The way in which Oracle Documents Cloud Service allows you to collect, collaborate, and share collateral through folders is a perfect way to work together as a team on the needed collateral, and an easy way to then share that collateral with the entire sales team. What was missing earlier was a tool that you could provide to each sales team member that would give them a way to effectively present the collateral and engage with the customer.

To solve this, we’ve introduced the Oracle Documents Presenter mobile app. It gives your sales reps a way to present content stored in Oracle Documents Cloud Service from their mobile tablet in a rich and visually appealing way and it ensures that they always have the right up to date collateral available to them.

Here’s how it works…

Build an Interactive presentation

Simply create a folder, add your content, and apply your branding.

Perhaps start with a top level folder called ‘Feature Collateral’ and then add sub folders for each of your company’s products and then sub folders for presentations, success stories, and data sheets.

The team responsible for the collateral can all have it synchronized to their desktop making it really easy to edit and collaborate on it until it is done.

The look and feel of how it will look when presented through Oracle Documents Presenter can be customized by the simple addition of background and folder icon images

Then Publish It

Easily share the folder with your team, your organization, your company. Now everyone has the latest collateral.

When changes are made in the future everyone continues to access the latest and greatest collateral.

You can even surface the folder through your company’s CRM system so that anyone using the CRM can view and download the contextual collateral they need.

Take It with You

Your curated content is always available to present and always up to date.

The sales reps get notified and can then choose to take it with them on their tablets by adding it to their Oracle Documents Presenter list of presentations.

Once they’ve downloaded the presentation to their tablet, they’re ready to go. Even if they’re not connected, the files are there, ready to present.

When changes are made in the future, Oracle Documents Presenter informs the user so they can make sure they always have the most up to date content no matter where they are.

Captivate Your Audience

Wow everyone with dynamic, visually stunning, interactive content that can be presented with customizable branding.

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

It’s that easy!

Oracle Documents Presenter can be your solution for more than just Sales Enablement.

Perhaps you work in in field service and need to empower your technicians ensuring they have up to date access to critical information, specifications, and training material. Oracle Documents Presenter can enable service organizations to automatically deliver to technician’s tablets the content, interactive forms, or knowledge they need to do their job.

For a quick peek at Oracle Documents Presenter, take a look at this brief product video.

Oracle Documents Presenter is currently available for the iPad (coming soon for Android devices).
Normal 0 false false false false EN-US X-NONE X-NONE /* 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:8.0pt; mso-para-margin-left:0in; line-height:107%; 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;} Normal 0 false false false EN-US X-NONE X-NONE /* 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:8.0pt; mso-para-margin-left:0in; line-height:107%; 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;} Normal 0 false false false EN-US X-NONE X-NONE /* 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:8.0pt; mso-para-margin-left:0in; line-height:107%; 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;}

Relocating OCR File and Voting Disk to new Diskgroup

VitalSoftTech - Tue, 2016-02-23 00:11
Are you moving you OCR and Voting disks from one storage to another? Read the step-by-step instructions on how to to move these files to a different diskgroup.
Categories: DBA Blogs

Running To Do Purge regularly, improves your performance

Anthony Shorten - Mon, 2016-02-22 16:44

One of the most common issues in implementations of Oracle Utilities Application Framework based products is the growth of To Do object.

The To Do object is to catch errors or events that need human intervention and cannot be addressed by the logic in the product. Basically something has to be done by someone to correct something as part of the process.

The To Do goes through various states and ends up Completed in its final state. There may be a few steps in between but eventually all To Do's should end up in a Completed state. Now when a To Do is in a completed state, the work associated is essentially completed so the retention of that To Do is a s long as your business wants to retain that data.

In terms of management there are a number of techniques that can be used to decide what to do with Completed To Do's:

  • You can use the ILM solution provided with most of the products to retain the To Do as long as your business requires to refer back to it.
  • You can use the To Do Purge batch job (F1-TDPG) to remove Completed To Do's. This job can be used globally or by To Do Type. This is the most common approach.

If you use the To Do Purge job then there are a few guidelines to optimize its use:

  • If there are a large number of completed To Do's to purge initially, then consider setting the noOfDays to a chunk of To Do's to efficiently to remove them.
  • You can set the scope of the job with a combination of isDeleteAll, deletedToDoTypes and excludedToDoTypes. This allows you to set different retention rates for each To Do Type.
  • You can copy the Batch control to implement different job conditions.
  • Schedule the purge jobs regularly to maintain a healthy balance between retention and storage costs.

Maintaining the To Do table has an impact on almost any part of the product as it is used by almost every process (directly or indirectly).

Rapid Install StartCD 51 for EBS 12.2 Now Available

Steven Chan - Mon, 2016-02-22 16:41

We are pleased to announce the availability of Oracle E-Business Suite StartCD 12.2.0.51 (often just called StartCD 51). As the fundamental installation medium for EBS, the startCD is what you begin with when installing or upgrading to Release 12.2.

This latest startCD includes many important updates and fixes, as described in the README for the patch by which it is supplied. Obtaining startCD 51 is highly recommended for all customers who will use Rapid Install to perform an installation or upgrade to Release 12.2.

startCD 51

How Can I Obtain startCD 12.2.0.51?
  • You can download startCD 51 as Patch 22066363.

What's New in this Update?

Among other enhancements, startCD version 12.2.0.51:

  • Includes important fixes for fresh install and upgrade scenarios
  • Introduces EBS use of Oracle Database 12cR1 (12.1.0.2)
  • Introduces EBS use of Oracle Fusion Middleware Web Tier Utilities 11.1.1.9.0
  • Installs additional technology stack patches for Oracle Database 11g and Fusion Middleware
Do I Need A New Stage Area For startCD 12.2.0.51?

Yes, you must create a new stage area to use startCD 12.2.0.51. A stage area created with an earlier startCD will not work. This is because (as noted above) startCD 12.2.0.51 uses Oracle Database 12cR1 (12.1.0.2), while earlier startCDs used 11gR1 (11.2.0.3). In addition, startCD 12.2.0.51 uses a later patch set (11.1.1.9.0)  of Oracle Fusion Middleware Web Tier Utilities than the 11.1.1.7.0 patch set used by earlier startCDs.

How Can I Obtain Oracle Database 12.1.0.2 and Oracle Web Tier Utilities 11.1.1.9.0?

You can download Oracle Database 12.1.0.2 and Oracle Web Tier Utilities 11.1.1.9.0 from the Oracle Software Delivery Cloud as part of the Release 12.2.5 media:

  • Go to the Oracle Software Delivery Cloud and search for Oracle Financials for your platform (EBS is not shown as a product option, so you need to choose a listed product such as Financials).
  • Under Release 12.2.5, download the Zip files for "Oracle Database 12.1.0.2" and "Oracle Web Tier Utilities 11.1.1.9.0".

startCD 51 extras

Where Can I Find More Information About Installing EBS?

Refer to the following Release 12.2 Web Library book for more information about creating the stage area, other installation prerequisites, and the various available installation actions and options:

  • Oracle E-Business Suite Installation Guide: Using Rapid Install (Part No. E22950) (PDF or HTML)
References

As well as the Installation Guide mentioned above, you should refer to the following My Oracle Support knowledge documents as applicable:

Related Articles

Categories: APPS Blogs

Performance Data Visualization for SLOB. The SLOB Expert Community is Vibrant!

Kevin Closson - Mon, 2016-02-22 13:58

Thanks to Nikolay Savvinov (@oradiag) for his excellent post on how to wrap his scripts around the SLOB test driver (runit.sh) to capture and produce performance data visualization graphs.  I recommend a visit to his post here:

Performance Data Visualization with SLOB

 

As always, the link for SLOB is: Obtain the SLOB Kit and Helpful Information Here


Filed under: oracle

Advanced SQL Webinar on February 23

Gerger Consulting - Mon, 2016-02-22 06:58
On February 23, Oracle ACE Kim Berg Hansen is hosting a free webinar about pattern matching with SQL in Oracle 12c. More than 140 developers have already signed up. Register at this link.


Categories: Development

Real Footy: Oracle Cloud UX and Rapid Development Kit Down Under

Usable Apps - Sun, 2016-02-21 01:11

Tales and Sales

I am just back from an awesome Oracle Applications User Experience (OAUX) communications and outreach event in Sydney, Australia. This was not my first time in Oz, but engaging with a regional audience eager for our Cloud UX message and PaaS4SaaS enablement, it was clear I wasn't in Kansas anymore.

Woah! A-Game time!

Over two days, customers, partners, and internal sales folks were treated to the best of Oracle Cloud user experience (UX) with a packed-solid, hands-on set of sessions that were all about the Oracle Cloud business.

Cloud UX RDK Released into the Wild in Australia!

Cloud UX PaaS4SaaS RDK released into the wild in Australia! 

My main focus was on the Oracle Cloud UX Rapid Development Kit (RDK) for PaaS4SaaS and on selling to win business using the Cloud UX message.

Selling Cloud UX: Real Footy

This is the age of storytelling and demonstrating empathy with your audience. User experience is about keeping it real and resonating with your users, so I opened the selling with UX session with the story of a fellow Dubliner who is also an Irish and Aussie Australian Football League (AFL) hero: Jim Stynes.

 Selling Cloud UX in Sydney

Blue Monday: Selling that Cloud UX 

Jim's contribution to Australia transcended mere footy team loyalty. His own empathy with an entire community was felt by lots of people in many walks of life, even if they had no interest in the AFL or football (apologies to Melbourne Demons fans).

Jim Stynes

Move beyond your demons: Jim Stynes (Image: Wikipedia Public Domain

 Jim kept it real.

I explained this importance of connecting with your sales audience on an emotional level to win business with the Cloud UX message, reinforced our Cloud UX strategy of Simplicity, Mobility, and Extensibility and our design philosophy of Glance, Scan, Commit, imparted best practices for engaging with customers using proven UX techniques, and closed out with some examples of how to do it all!

The Rapid Development Kit: Real Development

The Cloud UX RDK is now available for building Release 10 PaaS4SaaS solutions. Together, with Senior User Experience Architect and master of all things technical in the RDK, Lancy Silveira (@LancyS), we delivered a hands-on demo of what's in the RDK, how partners can use it to identify business opportunities for PaaS4SaaS, and then design and develop winning solutions.

A big emphasis was put on APIs as UX design, on how OAUX has made it easy for partners and customers to build web service integrations, and realizing the right simplified UI Cloud UX use cases that add value to decision-makers and end users.

Lancy demos the RDK live in Sydney

Lancy shows off how easy it is to build great simplified UIs for SaaS and PaaS using the RDK live in Sydney. 

Later we played tag-team with OAUX Director Greg Nerpouni (@gnerpouni) and his super-practical sessions on Cloud UX extensibility. We provided a deep-dive exploration of the RDK as Lancy stepped through the technical parts of the RDK, demoed the Oracle Applicatons Cloud Release 10 simplified UI page layouts, declarative components, SaaS task flows and services, and handled any technical questions about using the kit to accelerate the delivery of PaaS and SaaS solutions in productive, reusable ways.

I relayed more wisdom of the PaaS4SaaS crowd and RDK success stories, so nobody was in any doubt about the importance of PaaS and SaaS to customers, partners, and to Oracle. The cloud has changed everything about customer expectations about PaaS custom apps and SaaS extensions UX and their availability, and now we're giving the Oracle PartnerNetwork community a real enabler to meet those expectations: the RDK. 

We also used this opportunity to gauge interest in building solutions using the RDK so that we can plan additional OAUX outreach and communication events in the region, to hear audience feedback on our approach, and to find out what typical use cases are being encountered locally for SaaS and PaaS in the Oracle Cloud.

OAUX and Partner Team in Sydney

The OAUX and Oracle SaaS Applications Alliances and Channels, APAC teams collaborate in Sydney: (L-R) Nicole Giovanetti, Shy Meei Siow, Geet Singh (@geet_s), Lancy Silveira, and Greg Nerpouni

In all, this was one great event. I suspect you will be seeing OAUX boots on the ground in this region again shortly.

In the meantime, stay tuned to the OAUX channels.

Thank you, Sydney! 

More Information

glibc CVE re: getaddrinfo() and userspace ksplice

Wim Coekaerts - Sat, 2016-02-20 17:48
I have my own server with Oracle Linux 6 (of course) where I host a ton of personal stuff and this server was also affected by the nasty DNS bug from last week (see : CVE-2015-7547 ). Everyone really should update glibc and make sure their system is patched (any distribution) by the way - this is a very serious vulnerability... The nice thing, however, was that this is a perfect example for user space ksplice patching. A quick ksplice update for glibc on this box, and it was patched, no restarting the system no restarting sshd or any other app for that matter. A split microsecond and life goes on happily. Nothing affected, no downtime, no pauses, no hiccups. That's the way to patch these things.

userspace ksplice

Most awesomely cool stuff. Solving real world problems. Imagine running a few 100 docker instances or a couple of Linux containers and you have to update the host's glibc and bring all that down... talk about impact.

kernel patches ... check

critical OS libraries like SSL and GLIBC ... check.

Oracle Linux 6 and 7 support ... check

glibc CVE re: getaddrinfo() and userspace ksplice

Wim Coekaerts - Sat, 2016-02-20 17:48
I have my own server with Oracle Linux 6 (of course) where I host a ton of personal stuff and this server was also affected by the nasty DNS bug from last week (see : CVE-2015-7547 ). Everyone really should update glibc and make sure their system is patched (any distribution) by the way - this is a very serious vulnerability... The nice thing, however, was that this is a perfect example for user space ksplice patching. A quick ksplice update for glibc on this box, and it was patched, no restarting the system no restarting sshd or any other app for that matter. A split microsecond and life goes on happily. Nothing affected, no downtime, no pauses, no hiccups. That's the way to patch these things.

userspace ksplice

Most awesomely cool stuff. Solving real world problems. Imagine running a few 100 docker instances or a couple of Linux containers and you have to update the host's glibc and bring all that down... talk about impact.

kernel patches ... check

critical OS libraries like SSL and GLIBC ... check.

Oracle Linux 6 and 7 support ... check

Pages

Subscribe to Oracle FAQ aggregator