Skip navigation.

APPS Blogs

Oracle E-Business Suite Critical Patch Update (CPU) Planning for 2016

With the start of the new year, it is now time to think about Oracle Critical Patch Updates for 2016.  Oracle releases security patches in the form of Critical Patch Updates (CPU) each quarter (January, April, July, and October).  These patches include important fixes for security vulnerabilities in the Oracle E-Business Suite and its technology stack.  The CPUs are only available for certain versions of the Oracle E-Business Suite and Oracle Database, therefore, advanced planning is required to ensure supported versions are being used and potentially mitigating controls may be required when the CPUs can not be applied in a timely manner.

For 2016, CPUs for Oracle E-Business Suite will become a significant focus as a large number of security vulnerabilities for the Oracle E-Business Suite will be fixed.  The January 2016 CPU for the Oracle E-Business Suite (EBS) will include 78 security fixes for a wide range of security bugs with many being high risk such as SQL injection in web facing self-service modules.  Integrigy anticipates the next few quarters will have an above average number of EBS security fixes (average is 7 per CPU since 2005).  This large number of security bugs puts Oracle EBS environments at significant risk as many of these bugs will be high risk and well publicized.

Supported Oracle E-Business Suite Versions

Starting with the April 2016 CPU, only 12.1 and 12.2 will be fully supported for CPUs moving forward.  11.5.10 CPU patches for April 2016, July 2016, and October 2016 will only be available to customers with an Advanced Customer Support (ACS) contract.  There will be no 11.5.10 CPU patches after October 2016.  CPU support for 12.0 ended as of October 2015.

11.5.10 Recommendations
  1. When possible, the recommendation is to upgrade to12.1 or 12.2.
  2. Obtaining an Advanced Customer Support (ACS) contract is a short term (until October 2016) solution, but is an expensive option.
  3. An alternative to applying CPU patches is to use Integrigy's AppDefend, an application firewall for Oracle EBS, in proxy mode which blocks EBS web security vulnerabilities.  AppDefend provides virtual patching and can effectively replace patching of EBS web security vulnerabilities.

In order to mitigate some mod_plsql security vulnerabilities, all Oracle EBS 11i environments should look at limiting the enabled mod_plsql web pages.  The script $FND_TOP/patch/115/sql/txkDisableModPLSQL.sql can be used to limit the allowed pages listed in FND_ENABLED_PLSQL.  This script was introduced in 11i.ATG_PF.H and the most recent version is in 11i.ATG_PF.H.RUP7.  This must be thoroughly tested as it may block a few mod_plsql pages used by your organization.  Review the Apache web logs for the pattern '/pls/' to see what mod_plsql pages are actively being used.  This fix is included and implemented as part of the January 2016 CPU.

12.0 Recommendations
  1. As no security patches are available for 12.0, the recommendation is to upgrade to 12.1 or 12.2 when possible.
  2. If upgrading is not feasible, Integrigy's AppDefend, an application firewall for Oracle EBS, provides virtual patching for EBS web security vulnerabilities as well as blocks common web vulnerabilities such as SQL injection and cross-site scripting (XSS).  AppDefend is a simple to implement and cost-effective solution when upgrading EBS is not feasible.
12.1 Recommendations
  1. 12.1 is supported for CPUs through October 2019 for implementations where the minimum baseline is maintained.  The current minimum baseline is the 12.1.3 Application Technology Stack (R12.ATG_PF.B.delta.3).  This minimum baseline should remain consistent until October 2019, unless a large number of functional module specific (i.e., GL, AR, AP, etc.) security vulnerabilities are discovered.
  2. For organizations where applying CPU patches is not feasible within 30 days of release or Internet facing self-service modules (i.e., iSupplier, iStore, etc.) are used, AppDefend should be used to provide virtual patching of known, not yet patched web security vulnerabilities and to block common web security vulnerabilities such as SQL injection and cross-site scripting (XSS).
12.2 Recommendations
  1. 12.2 is supported for CPUs through July 2021 as there will be no extended support for 12.2.  The current minimum baseline is 12.2.3 plus roll-up patches R12.AD.C.Delta.7 and R12.TXK.C.Delta.7.  Integrigy anticipates the minimum baseline will creep up as new RUPs (12.2.x) are released for 12.2.  Your planning should anticipate the minimum baseline will be 12.2.4 in 2017 and 12.2.5 in 2019 with the releases of 12.2.6 and 12.2.7.  With the potential release of 12.3, a minimum baseline of 12.2.7 may be required in the future.
  2. For organizations where applying CPU patches is not feasible within 30 days of release or Internet facing self-service modules (i.e., iSupplier, iStore, etc.) are used, AppDefend should be used to provide virtual patching of known, not yet patched web security vulnerabilities and to block common web security vulnerabilities such as SQL injection and cross-site scripting (XSS).
EBS Database Recommendations
  1. As of the October 2015 CPU, the only CPU supported database versions are 11.2.0.4, 12.1.0.1, and 12.1.0.2.  11.1.0.7 and 11.2.0.3 CPU support ended as of July 2015.  The final CPU for 12.1.0.1 will be July 2016.
  2. When possible, all EBS environments should be upgraded to 11.2.0.4 or 12.1.0.2, which are supported for all EBS versions including 11.5.10.2.
  3. If database security patches (SPU or PSU) can not be applied in a timely manner, the only effective mitigating control is to strictly limit direct database access.  In order to restrict database access, Integrigy recommends using the EBS feature Managed SQLNet Access, Oracle Connection Manager, network restrictions and firewall rules, and/or terminal servers and bastion hosts.
  4. Regardless if security patches are regularly applied or not, general database hardening such as changing database passwords, optimizing initialization parameters, and enabling auditing should be done for all EBS databases.
Tags: Oracle E-Business SuiteOracle Critical Patch Updates
Categories: APPS Blogs, Security Blogs

Oracle Access Manager (OAM 11g) Interview Questions.. Do you know enough about OAM ???

Online Apps DBA - Sat, 2016-01-16 19:47
This entry is part 3 of 5 in the series Oracle Access Manager

Oracle Access Manager (OAM) is Oracle’s recommended Single Sign-On (SSO) solution that not only provides heterogeneous platform support but is also Integrated with Oracle Fusion Applications . OAM is also recommended SSO solution for Oracle Fusion MiddleWare (Webcenter, OBIEE , SOA) and Oracle E-Business Suite, Peoplesoft  or Siebel CRM.

Lot of time in our Oracle Access Manager Training(next batch starts on 31st January, 2016 – Register now and get discount of 200 USD, Apply coupon code A2OFF) trainees ask about interview questions related to Oracle Identity and Access Management Suite.

These questions also help them to understand concepts and important things helpful in actual implementation of OAM

Can you answer these basic questions related to Oracle Identity & Access Manager ? (leave answers under comments to see how many you get right)

1) What is the name of main OAM Configuration File and where it is located (DB or File System)?

2) What is the name of main Weblogic Domain Configuration File and where it is located?

3) What is the location of OAM Admin Server logs?

4) What is the Oracle Instance in OID ?

5) Where the start/stop script for Admin and Managed servers are located?

6) What is difference between OPEN, SIMPLE, CERT communication mode in WebGate to OAM communication ?

7) What is Proxy Port in OAM Server and which component of OAM connect to Proxy Port of OAM ?

Click on the button below and get the Cheat Sheet on Oracle Access Manager including the answers for above questions.

The cheat sheet also contains the Basic information on Oracle Internet Directory (OID).

If you want to learn more or wish to discuss challenges you are hitting in Oracle Access Manager Implementation or OAM Integration with Oracle E-Business Suite (R12.1/12.2), register for our Oracle Access Manager Training (next batch starts on 31st January, 2016 – Register now and get discount of 200 USD,  Apply coupon code A2OFF, Discounts won’t stay longer and prices will go up soon).

We are so confident on quality and value of our training that We provide 100% Money back guarantee so in unlikely case of you being not happy after 2 sessions, just drop us a mail before third session and We’ll refund FULL money.

We provide dedicated machine on cloud to practice OAM Implementation including integration with E-Business Suite and recording of live interactive trainings for life time access.

 

Click Here to Subscribe with us to get OAM-OID Cheat Sheet

Stay tuned for more Interview Questions on OAM-EBS 12.2/12.1 Integration in our next post.

The post Oracle Access Manager (OAM 11g) Interview Questions.. Do you know enough about OAM ??? appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

OAM 11g SAML SSO Integration with AtTask

Online Apps DBA - Fri, 2016-01-15 12:19

WorkForce AtTask is a cloud based project management solution and it is capable of talking SAML.

Recently I had integrated AtTask application with Oracle Access Manager 11gR2 for SAML SSO integration where AtTask is SP and OAM is IDP.

AtTask uses its own repository for users. OAM uses AD LDAP for authentication store. Like any general SAML SSO integration, metadata has to be exported and imported into each provider.

The AtTask documentation details how to import metadata and configure mapping attributes.

In this post, I would like to detail what is different in this product for enabling SAML integration.

After enabling SAML SSO integration and importing metadata as per above documentation, we can test the SSO setup using Test the connection. During this process, the user is redirected to IDP and user submits credentials and SAML token is generated and passed onto SP (AtTask).

The test output page contains the $$NAMEID coming from IDP and typically it would be userid and this is the Federated ID. Federated ID is an attribute of AtTask user profile that is key for mapping user based on SAML assertion.

Login to AtTask as administrator. Goto user profile and update Federated ID with $$NAMEID output value. That’s it. You’re all set.

Note that regular login will not work when SAML SSO is enabled in AtTask. Hence it is recommended to update all user profiles with Federated ID value before enabling SAML SSO.

Hope this helps.

The post OAM 11g SAML SSO Integration with AtTask appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Extranet login redirects to intranet URL

Vikram Das - Thu, 2016-01-14 10:15
For an old 11.5.10.2 ERP, we are moving from the architecture of "EBS application server in DMZ" to the architecture of "Reverse Proxy in DMZ and EBS application server in intranet".  After doing all configurations, we hit the classic issue where, you login through extranet url visible on public internet which redirects to intranet url.

So https://extranet.example.com asks for SSO details and after keying in SSO username and password goes to http://intranet.example.com.
The support.oracle.com article DMZ Configuration with Oracle E-Business Suite 11i (Doc ID 287176.1) has listed 4 checks which could be the reason for this issue:
H6: Redirection to an Incorrect Server During LoginIf you are getting redirected to an incorrect server during the login process, check the following:
  • Whether the hirearchy type of the profile options mentioned in Section 5.1 is set to SERVRESP .
  • select PROFILE_OPTION_NAME,HIERARCHY_TYPE from fnd_profile_options where profile_option_name in 
    ('APPS_WEB_AGENT','APPS_SERVLET_AGENT','APPS_JSP_AGENT','APPS_FRAMEWORK_AGENT' ,'ICX_FORMS_LAUNCHER','ICX_DISCOVERER_LAUNCHER','ICX_DISCOVERER_VIEWER_LAUNCHER','HELP_WEB_AGENT','APPS_PORTAL','CZ_UIMGR_URL','ASO_CONFIGURATOR_URL','QP_PRICING_ENGINE_URL','TCF:HOST');
    PROFILE_OPTION_NAME                               HIERARCHY_TYPE
    ----------------------------------------                               --------------------------------
    APPS_FRAMEWORK_AGENT                         SERVRESP
    APPS_JSP_AGENT                                         SERVRESP
    APPS_PORTAL                                         SERVRESP
    APPS_SERVLET_AGENT                                 SERVRESP
    APPS_WEB_AGENT                                         SERVRESP
    ASO_CONFIGURATOR_URL                         SERVRESP
    CZ_UIMGR_URL                                         SERVRESP
    HELP_WEB_AGENT                                         SERVRESP
    ICX_DISCOVERER_LAUNCHER                 SERVRESP
    ICX_DISCOVERER_VIEWER_LAUNCHER SERVRESP
    ICX_FORMS_LAUNCHER                         SERVRESP
    QP_PRICING_ENGINE_URL                         SERVRESP
    TCF:HOST                                                 SERVRESP

    All good on this point
  • Whether the profile option values for the fnd profile options (APPS_FRAMEWORK_AGENT, APPS_WEB_AGENT, APPS_JSP_AGENT, APPS_SERVLET_AGENT) are pointing to the correct node. Replace the node_id with the node_id of the external and internal web tier. For example:
  • select fnd_profile.value_specific('APPS_FRAMEWORK_AGENT',null,null,null,null,) from dual;
    This query returned https://extranet.example.com

  • Whether the dbc file pointed to by the JVM parameter (JTFDBCFILE) in jserv.properties exists.
  • wrapper.bin.parameters=-DJTFDBCFILE=
    This was incorrect.  It was pointing to the intranet jdbc file location.

  • Whether the value of the parameter APPL_SERVER_ID set in the dbc file for the node is the same as the value of the server_id in the fnd_nodes table.
    select node_name,node_id,server_id from fnd_nodes;
    This was overwritten in the dbc file, with appl_server_id of intranet when autoconfig was done on intranet and overwritten with appl_server_id of extranet when autoconfig was done on extranet, as the DBC file location and name were same for both intranet and extranet.
I asked the DBA team to manually correct the dbc file name inside $IAS_CONFIG_HOME/Apache/Apache/Jserv/etc/jserv.propertiesand create a file of that name in $FND_SECURE/$CONTEXT_NAME.dbc on the extranet node and bounce services.  Once that was done, we tested and it worked. No more redirection to intranet URL.
Then I asked them to correct the s_dbc_file_name variable in the context file of extranet node. Run autoconfig on extranet, verify the value of dbcfile in jserv.properties DJTFDBCFILE parameter, verify that the DBC file had the server_id of the extranet node.  Restart all services.Checked again, and it worked again.
So apart from checking the values of context file variables like s_webentryhost, s_webentrydomain, s_active_port, you also need to check the value of s_dbc_file while verifying the setups for extranet configuration. This can happen in 11i , R12.1 and R12.2 also.
Categories: APPS Blogs

FREE Webinar : Oracle E-Business 12.2 New Features every Apps DBA must know : Friday 15th Jan

Online Apps DBA - Wed, 2016-01-13 07:26
This entry is part 1 of 1 in the series Oracle Apps DBA Training

Apps DBA Webinar

Last Month We held our Live Webinar on “E-Business Suite Architecture” and we had a very busy Q&A session. As we had more questions than we had time to tackle live, today we are bringing you the transcript and extra answers. Looking at kind of questions We realised there is still lot of doubt Oracle E-Business Suite 12.2 for Apps DBAs so we decided to have another FREE Webinar on New Features in Oracle E-Business Suite 12.2 this Friday 15th of Jan 9AM PST/ 12 PM EST/ 5 PM GMT / 10:30 PM IST

Q1. What new things I should learn to prepare for Oracle 12.2 as Apps DBA ?
Ans:
In 12.2 Weblogic is introduced so it is good to learn Oracle WebLogic Domain, Admin & Managed Servers Cluster etc . It is also good to understand Architecture in EBS 12.2 and new File System (Dual File System) including new patching tool ADOP and long list (Check course content we cover in our Training for Oracle Apps DBA 12.2)

Q2. Is there any downtime in Online Patching (ADOP)?
Ans: Oracle introduced new patching utility ADOP (Online Patching) and when you apply patch in 12.2 now there is a very short period of downtime when the application tier services are shut down and restarted. The database remains open all the time.

Q3. Are there any plans to make Online Patching available with pre-12.2 releases?
Ans: Nothing that we are aware of. As of now Online patching can only be used with Release 12.2.

and lot of other questions

Do you think you have such questions in mind or you think you know enough about the features of Oracle E-Business Suite  12.2 ?

Are you interested in becoming an Oracle Apps DBA ? 

We invite you to Join us on our live Apps DBA webinar on Friday (15th January,2016) at 10:30 – 11:30 PM IST/ 5:00-6:00 PM GMT to know about the New Features of  E-Business Suite 12.2. highlighting the New Features in   12.2 and the key points that everyone must know to become an Apps DBA.

To Open door for Career in Oracle Apps DBA Click on the button below to register for our FREE Webinar and Learn / Become an Oracle Apps DBA:

Click here to register for the FREE Webinar

The post FREE Webinar : Oracle E-Business 12.2 New Features every Apps DBA must know : Friday 15th Jan appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[FREE Live Webinar] Oracle Access Manager Live Webinar: Join k21 Team on 16 January

Online Apps DBA - Mon, 2016-01-11 11:59

image003 (1)

We’re so glad and excited to share that this year 2016, we got an amazing startup and noticed that you are also seeking the same. How?

A couple of days back, we launched our Oracle Fusion Middleware Live Webinar for FREE where Atul Kumar (an Oracle ACE and Fusion MiddleWare and Identity and Access Management Expert) taught Fusion MiddleWare Concepts, SSL, Q/A, etc. And you know what? 300+ registrations with attendance of 250 learners took place! Woah! This is incredible!

Now, since, We can see a hell lot of learners who either reads our blogs or attend events and even many of them registers for our paid trainings, so, we have decided to come up with Oracle Access Manager FREE Live Webinar to make sure that if Oracle Fusion MiddleWare Experts are learning and growing, then why you can’t? You know, this world is all about learning and growing carrier! Also, here, everything is all about results, so, why to miss it?

We’re officially inviting you to attend for our Oracle Access Manager FREE Live Webinar which is going to take place on 16th January Saturday, 2016 at 3:30 PM GMT / 7:30 AM PST / 9:00 PM IST where Atul kumar and Ganesh Kamble will be covering the following topics:

  • Architecture of Oracle Access Manager (OAM).
  • Oracle Access Manager And EBS(R12) Integration
  • Answer to challenges you are facing in your own projects.
  • Live Question / Answer

We would be glad if you take out a couple of hours to join the K21 Team in this FREE Live Online Event to learn something good to get a great carrier ahead!
Click the below button register for our webinar to grab your seat quickly!!

Click Here to Register For FREE Webinar

Please notice that we have limited number of seats for a limited time. So, grab it before it goes off!

The post [FREE Live Webinar] Oracle Access Manager Live Webinar: Join k21 Team on 16 January appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Legal Entity Document Sequencing in Receivables

OracleApps Epicenter - Thu, 2016-01-07 02:55
You need to consider these points when you are trying setup Legal Entity Document Sequencing in Receivables You can set up your primary ledger to allow document sequencing at the legal entity level instead of at the ledger level. This means if you have more than one legal entity assigned to the same ledger, you […]
Categories: APPS Blogs

Happy New Year 2016 , best wishes to all

OracleApps Epicenter - Sat, 2016-01-02 01:49
This the season to be jolly! Time truly flies when you are doing the things you love and with another year behind us, we can't help but feel a little nostalgic and look back at what the past twelve months have brought us. It was a busy year at personal and professional side .In terms […]
Categories: APPS Blogs

Oracle Management Cloud : The Next Generation Real-Time Monitoring and Analytics IT Tool

OracleApps Epicenter - Sat, 2016-01-02 01:21
Oracle Management Cloud (OMC) is a suite of next-generation integrated monitoring, management, and analytics cloud services built on a scalable big data platform that provides real-time analysis and deep technical and business insights. With OMC you can eliminate disparate silos across end-user and infrastructure data, troubleshoot problems quickly,and run IT like a business OCM meets […]
Categories: APPS Blogs

Multi-Element Arrangements

OracleApps Epicenter - Sat, 2015-11-07 07:10
Multi-element arrangement aka occurs when a vendor agrees to provide more than one product or a combination of products and services to a customer in an arrangement. Multi-element arrangements may include additional software products, rights to purchase additional software products at a significant incremental discount, specified upgrades or enhancements, hardware, PCS or other services. Multiple-element […]
Categories: APPS Blogs

Quiet Release MySQL Plugin 12.1.0.1.2 — bug fixes

Alex Gorbachev - Tue, 2012-12-11 12:30
This is just a small bug fix release of the plugin. It was actually quietly released for a while now of if you have downloaded the plugin recently, you have the latest version. To be sure — check the version in the Console or you will see it in the file name. There are two [...]
Categories: APPS Blogs

IOUG Big Data SIG — Kick-off Meeting at OOW12

Alex Gorbachev - Thu, 2012-09-27 16:47
Announcing the IOUG Big Data Special Interest Group (SIG)! We have the SIG meeting at Oracle Open World — come join us with you morning coffee. Nothing better than starting your Big morning with Big Data talks! Yes — we actually managed to get the room at this busy times at OOW thanks to IOUG. [...]
Categories: APPS Blogs

IOUG Collaborate 2013 — Call for Speakers Informational Webinar

Alex Gorbachev - Tue, 2012-09-11 04:28
As I’ve become Director of Communities for IOUG recently, I’m intimately involved in many aspects of leading IOUG community. One of the area the user group is pursuing all the time is finding the new speakers and that takes some part of convincing the community members to actually start presenting. There are many of you [...]
Categories: APPS Blogs

Oracle OpenWorld 2012 – Bloggers Meetup

Alex Gorbachev - Thu, 2012-09-06 13:40
Oracle OpenWorld 2012 is just over a month away and yes we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of the OpenWorld. What: Oracle Bloggers Meetup 2012 When: Wed, 3-Oct-2012, 5:30pm Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 (street view). [...]
Categories: APPS Blogs

Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control

Alex Gorbachev - Thu, 2012-08-30 12:00
MySQL management plugin for EM 12c has been long overdue. I’ve initially migrated the older plugin to EM 12c about 6 months ago and few dozen people received this as initial beta of the plugin. It worked OK but didn’t use any of the 12c new features and its home page was a bit of [...]
Categories: APPS Blogs

Advert: few Oracle Database Appliances at significant discount

Alex Gorbachev - Wed, 2012-08-29 16:19
This blog is a little bit self serving and I’d normally not post it but I think that it would be an awesome deal for those of you who are thinking of buying an Oracle Database Appliance now. We have several just two left brand new, unopened ODAs left in our inventory that we need [...]
Categories: APPS Blogs

How to Prevent Manual Entries to System Accounts

The Feature - Tue, 2012-08-07 23:21
There is a new feature in Oracle General Ledger R12 (12.1.3), which lets you define an additional qualifier called Third Party Control on your natural account values. You can set the Third Party Control qualifier for your accounts to be only used by Payables (Supplier) or Receivables (Customer), or prevent any manual entries (Restrict manual … Continue Reading
Categories: APPS Blogs

Two Newly Published White Papers for November 2011!

OracleContractors - Wed, 2011-11-16 03:45

Many thanks firstly to Ahmed Jassat, author of “Cloning from 20hrs to 20mins using Oracle Dataguard” & also to Alexander Reichman, author of “Interacting with BPEL/Workflow from Oracle Forms 11g”.

Ahmed is an Oracle Apps DBA based in South Africa & his White Paper focuses on a client site where he has worked & how implementing Oracle Dataguard has reduced the cloning time dramatically for them & the impact this has had on the business. A must-read for any DBA/Technical Managers, DBAs, Apps DBAs & disaster recovery teams.

Alexander is a certified Oracle DBA based in Canada & his White Paper focuses on integrating Oracle Forms 11g with Oracle BPEL/Workflow included in the Fusion Middleware 11g platform. A must-read for any Oracle Forms Developers, SOA Architects & Project Managers.

Many thanks for your contributions guys!

Categories: APPS Blogs

Is anyone actually using this database? - How to tell whether or not you can delete an old database

OracleContractors - Sat, 2011-08-27 04:07

When you log into a database server that has been running for several years, you will often find lots of files from databases that may not have been used for some time.

The people who created them probably left the company long ago and there is little documentation on the databases. Nobody is certain whether or not they are still being used, so they just sit around using up disk space.  If the databases are started up, then they’re also using memory, even though they may not be doing anything productive.

Rather than prolonging this situation, it’s a good idea to remove these databases - once you’ve confirmed that no-one uses them anymore.  Unfortunately, within a large business it may not be easy finding out who within the company is using which databases, if documentation has not been kept up to date.

As a starting point you can look in the following places:
(i) Database alert log
If the database is currently shut down, then what date was it shut down? If this was a long-time ago (i.e. more than 1 year), then the chances are that the database is no longer used, or is so out of date with current business data that it would need to be refreshed/updated before it could be of any use. 

Note: Just because things such as configuration changes (i.e. extending datafiles) are shown in the alert log, it doesn’t mean to say that it’s actually in use.  A DBA can carry out maintenance tasks on a database, whether or not there are any business users carrying out work.

Similarly, you may find that a backup tool such as RMAN regularly connects to the database.  This also doesn’t mean to say that the database is being used by the business - just that it’s being backed up.

(ii) Listener log
Search in the listener log for the last entries for that database. Even if the database is shutdown, this will let you know the last time that anyone was using it.  Be careful that you don’t think that someone is using the database just because there is an automated application process or reporting tool that connects to the database regularly.  If individual users are not connecting to the database, then it may not be in use anymore. 

Note: Double-check with any reports or application support teams as well, because the database may just be a repository, in which case individual user connections could be rare.

(iii) Datafile timestamps
If the database is shutdown, What is the last modified date shown in the filesystem for the datafiles?  I’ve come across situations where you can’t find any entries for the SID in the listener log and the alert log for the database has been removed, so this is a good way to find out when the database was last open.

Note: This is assuming that someone hasn’t just copied the files from another location, without preserving the original file timestamps.
(iv) Run AWR/ASH or Statspack reports
These will let you know if anyone has been using the database within the last week or longer - depending on the retention period configured for the database.  (If performance snapshots are not configured, then you may also find useful information on long-running transactions in V$SESSION_LONGOPS).

Note: Just because a database hasn’t been used in the last week, doesn’t mean to say it’s not required anymore.  It could be used for monthly, weekly or annual reporting, so you may not see regular activity.
 (v) Database Auditing
If database auditing has been enabled, it will give you an idea who has been accessing the database. (e.g. query views such as DBA_AUDIT_SESSION and DBA_AUDIT_TRAIL).
(vi) Standby databases
It’s worth running the query SELECT DATABASE_ROLE FROM V$DATABASE; If this returns “PHYSICAL STANDBY” or “LOGICAL STANDBY”, then it could mean that someone has deleted a primary database in the past, but neglected to remove the associated standby database. 
 

Before deleting any databases, it would be advisable to email anyone that may have an interest in the database and then ensure that a copy of the database files and configuration information is archived to tape or other storage for a pre-defined period of time.  Ensure that you have approval from all interested parties before carrying out any work like this, which could have an impact on the business.

Categories: APPS Blogs

Three New free of charge Oracle White Papers released for August!!!

OracleContractors - Mon, 2011-08-15 07:14

Hi all,

Many thanks to the following authors for their White Papers, your contributions are much appreciated & help to share Oracle knowledge on a global scale:

Martin Dvorak - “How to Plan & Deliver Oracle eBusiness Suite Training with UPK”

Claire Aukett - “Absence Management using R12 Oracle HCM & CRM”

Elwyn Lloyd Jones - “Upgrade Strategies for OWB Environments”

If you would like a copy of any of these papers, please register with the White Paper area of our website where you can gain access to our full White Paper library & if you are interested in becoming a White Paper author yourself, please contact me at: kirsten.campbell@oraclecontractors.com

New papers are also being released in September too so watch this space!

Categories: APPS Blogs