Skip navigation.

APPS Blogs

Basic OBIEE Enumeration Checklist

Several clients and partners have asked for this checklist lately. Posting it for those who may find it useful:

  1. If possible ask for the following:
    1. System diagram
    2. All URLs – WebLogic, Enterprise Manager and OBIEE
    3. Ask about load balancer and reverse proxy
    4. WebLogic accounts and passwords for both /EM and /Console
    5. TNSNAMES info and DB accounts and passwords for WebLogic repository database
    6. Ideally O/S accounts and passwords for server supporting WebLogic – will need for WLST scripts
    7. Request copy of config.xml file for each environment. If o/s accounts are surrendered these can be easily obtained.
  2. Network probe
    1. NMAP scan for WebLogic and OBIEE ports 7001, 9701 and 9703. Suggest scanning 9700 – 9710. Also NMAP scan for Oracle networking 1521 (default).  Suggest scanning 1520-1530
    2. Check WebLogic and OBIEE specific URLs. For public facing, use Google. For internal construct URLs using information gathered from NMAP:

Tool

URL

Administration Server Console

http://host:port/console

Enterprise Manager Console

http://host:port/em

Enterprise Manager Agent

http://host:port/emd/main

Oracle Portal

http://host:port/portal/pls/portal

Oracle Forms

http://host:port/forms/frmservlet

Oracle Reports

http://host:port/reports/rwservlet

Oracle Discoverer Viewer

http://host:port/discoverer/viewer

WebLogic

If external Google: intitle:"WebLogic Server" intitle:"Console Login" inurl:console –site:targetdomain.com

OBIEE

Look for: analytics/saw.dll

e.g. if external Google: Inurl: analytics/saw.dll –site:targetdomain.com

 

  1. Inventory the databases associated with WebLogic. Issue the following from the repository databases:
    1. SELECT * FROM SYSTEM.SCHEMA_VERSION_REGISTRY$;
    2. SELECT * FROM PRODUCT_COMPONENT_VERSION;
  2. Read and analyze the primary WebLogic configurations. The primary config file is the /domains/DOMAIN_NAME/config/config.xml 
  3. Get server information, suggest running WLST scripts for – Google several good examples: ‘wlst script list servers and information’
  4. Get WebLogic user information, suggest running WLST scripts for – Google several good examples: ‘wlst script list users’
  5. For OBIEE authentication will first be done by WebLogic. WebLogic will determine who can access OBIEE. WebLogic groups may or may not then drive authorization. Older OBIEE solutions also might internally authenticate within the repository (RDP).  Overall security authorization within OBIEE can be at control at various levels; Catalog/Presentation, RPD and within the data sources or a combination of everything. There can also be no security/authorization e.g. authentication by WebLogic to use OBIEE and then handoff to a PUBLIC / generic OBIEE report.
Tags: Oracle Fusion MiddlewareOracle Business Intelligence (OBIEE)
Categories: APPS Blogs, Security 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

FREE Live Webinar: Learn Oracle Access Manager (OAM) 11g R2 from team K21

Online Apps DBA - Wed, 2015-11-04 07:54
This entry is part 1 of 2 in the series Oracle Access Manager

k21_oam_webinar

Oracle Access Manager (OAM) is Oracle’s recommended Single Sign-On (SSO) solution and mandatory for Oracle Fusion Applications. Apps DBA’s and Fusion Middleware Administrator with OAM skills have better chances of any opportunities in to Oracle and are always paid higher.

 

Join team K21 Technologies for FREE Webinar on this Saturday (7th November,2015) at 9:00  AM PST/ 12:00 PM EST /10:30 PM IST / 5:00 PM GMT where OAM expert Ganesh Kamble will cover Overview, Architecture and the important components that are part of Oracle Access Manager (OAM).

This Webinar will cover the key points that are important for beginners and those who want to pursue your career in Oracle Identity & Access Management (OAM/OID/OIM).

Oracle Access Manager provides the centralized authentication, authorization and Single sign-on to secure access across enterprise applications.

Below you can see the architecture of Oracle Access Manager 11g R2

OAM

 

 

 

Oracle Access Manager 11g includes:

  • Database that contains OAM metadata and schemas
  • LDAP Server where identities of users and groups are stored
  • OHS /Apache as Web Server
  • Application resource which is protected by OAM
  • OAM Admin Server
  • OAM Managed server
  • WebGate which connects and transfer request from web server to OAM server

To know more about the components of Oracle Access Manager and detailed architecture. Click on the button below to register for our Webinar

 

Click Here to register for the free Webinar

 

If you have any Question related to OAM that you want us to cover in our FREE Webinar on OAM then post it below as comment or ask in our Private Facebook Group

The post FREE Live Webinar: Learn Oracle Access Manager (OAM) 11g R2 from team K21 appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

FREE live webinar : Learn Oracle Apps 12.2 for DBAs and Apps DBAs

Online Apps DBA - Tue, 2015-10-27 08:41

Learn Oracle Apps DBA R12.2 (4)

Do you know enough about the features of Oracle E-Business Suite from 11i to 12 ? Are you interested in becoming an Oracle Apps DBA ?

Join us on our live webinar on Thursday (29th October,2015) at 6:30 – 7:30 PM PST/ 9:30-10:30 PM EST or Friday (30th October,2015) at 7:00-8:00 AM IST to know about the architecture of E-Business Suite highlighting the updates from 11i to 12 and the key points that everyone must know to become an Apps DBA.

To become an Oracle Apps DBA the important thing is that you should be very well familiar with Oracle Applications/E-Business Suite Architecture.

Below you can see the changes in the architecture of EBS R12.2

ebs-122-con9021pdf90210001-8-638

  • Introduction of Fusion Middleware 11g
  • Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
  • Uses Oracle Application Server 10g R3 (10.1.2.3) for Forms & Reports
  • Default Database 11gR2 (11.2.0.3). Latest is 11.2.0.4 (11g Family)
  • Oracle JSP Compiler is replaced by WebLogic JSP Compiler 11.1.1.4 in R12 version 12.2.
  • Dual File System from R12.2
  • Online Patching – Almost zero Downtime

To know more about the Oracle Apps DBA profession. Click on the button below to register for our webinar

 

Click here to register for the FREE Webinar

The post FREE live webinar : Learn Oracle Apps 12.2 for DBAs and Apps DBAs appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracle Apps R12.2 Log Files Location every Apps DBA must know

Online Apps DBA - Sun, 2015-10-25 09:17

This post covers Log File Location in Oracle E-Business Suite  R12.2 that every Oracle Apps DBA must know. Log File helps in troubleshooting and is first thing you must look when looking at any issue .
This post is from our Oracle Apps DBA (R12.2) Training for E-Business Suite  (next batch starts on 31st October, 2015 and We cover Architecture, Installation, File System, WebLogic Concepts, Patching, Cloning , Common Tasks and difference in 12.2 from previous version. Register here for Oracle Apps DBA 12.2 Training )

One of the trainee from our previous batch asked for the Log File Locations in Oracle E-Business Suite 12.2 so here is the list of Log file locations for Oracle E-Business Suite 12.2 depending on task you are performing:

1. R12.2 Start/Stop Log Files:

a) Startup/Shutdown error message text files like adstrtal.txt, adstpall, adapcctl.txt, adcmctl.txt…for services like oacore, forms, apache, opmn, weblogic admin server/node manager etc

  • $INST_TOP/logs/appl/admin/log

Log files for start/stop of services from $ADMIN_SCRIPTS_HOME

Here is an image representing EBS R12.2 Service control (start/stop) logs:

Green colour boxes indicates location of log files 

4

 

 2. Patching Log files:

a) The Online Patching (ADOP) log files are located on the non-editioned file system (fs_ne), under :

  • $NE_BASE/ EBSapps/ log/adop/ <adop_session_id>/ <phase>_<date>_<time>/ <context_name>/ log

Notefs1 and fs2 are dual file system for software where as fs_ne contains non editioned objects 

This log directory will contain patch logs, patch worker logs and other patch related log files created for specific purposes.
Also, some patch tasks may create separate log files in the same directory from where patch executable is started

3. Log files for concurrent programs/managers

  • $NE_BASE/ inst/ <CONTEXT_NAME>/ logs/ appl/ conc/ log

 Output files for concurrent programs/managers

  • $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out

Here is an image representing EBS R12.2 Non-Editioned file system Logs:

1

Patching Log file Location:

2

4. Cloning related Log Files:

a) Pre-clone log files in source instance

     I. Database Tier

  • $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

    II. Application Tier

  • $INST_TOP/admin/log/ (StageAppsTier_MMDDHHMM.log)

b) Clone log files in target instance

    I. Database Tier

  • $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log

    II. Apps Tier

  •  $INST_TOP/admin/log/ApplyAppsTier_<time>.log

If your clone on DB Tier fails while running txkConfigDBOcm.pl (Check metalink note – 415020.1)
During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0

5. AutoConfig log file:

Autoconfig can be run on Application Tier or Database Tier

a) Autoconfig Log Location on Application tier :

  • $INST_TOP/admin/log/$MMDDHHMM/adconfig.log

b) Autoconfig Log Location on Database tier:

  • $ORACLE_HOME/ appsutil/ log/ $CONTEXT_NAME/ <MMDDHHMM>/  *.log

 

 

6.  Installation Related Logs:

There are four main phases (in context of logs) during R12.2 installation, here is log location of all four phases .

a) The Rapidwiz Configuration File is saved in below locations:

  • $TMP/<MMDDHHMM>/conf_<SID>.txt
  • $INST_TOP/conf_<SID>.txt
  • <RDBMS ORACLE_HOME>/ appsutil/ conf_<SID>.txt

b) Pre-install system check logs:

  • $TMP/<MMDDHHMM>/<MMDDHHMM>.log
  • $TMP/dbPreInstCheck.xxxxx.log
  • $TMP/wtprechk.xxxx/wtprechk.xxxx.log
  • <Global Inventory>/logs/installActions<timestamp>.log

c) Database tier

I. Main Installation log:

  • RDBMS $ORACLE_HOME/ appsutil/ log/ $CONTEXT_NAME/ <MMDDHHMM>.log

II. ORACLE HOME installation logs:

  • RDBMS $ORACLE_HOME/ temp/ $CONTEXT_NAME/ logs/ *.log
  • <Global Inventory>/logs/*.log

d) Application tier

Both primary(Run) and Secondary Edition (Patch) file systems will each contain these logs:

    I. Main Installation Log:

  • $INST_TOP/logs/<MMDDHHMM>.log

    II. FMW and OHS TechStack Installation/Patching logs:

  • $APPL_TOP/admin/$CONTEXT_NAME/log/*
  • <Global Inventory>/logs/*.log

    III. Forms Oracle Home installation logs:

  • $APPL_TOP/admin/$CONTEXT_NAME/log/*.log

 

Here is an image representing the R12.2 Installation logs

ebs_log1

 

6. Fusion Middleware (FMW_HOME) Log Files:

Oracle 12.2 includes Fusion Middleware (WebLogic & OHS) as new components and we cover these components in detail in our Apps DBA Training

 a) Log files for OPMN and OHS processes: Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log), HTTP Transaction logs (access.log), security settings related logs.

  • $IAS_ORACLE_HOME/ instances/ <ohs_instance>/ diagnostics/ logs

b) Log files for weblogic node manager: Log file is generated by Node Manager and contains data for all domains that are controlled by Node Manager on a given physical machine.

  • $FMW_HOME/ wlserver_10.3/ common/ nodemanager/ nmHome1/ nodemanager.log

c) Log files for weblogic Oracle Management Service log file: Initial settings AdminServer and Domain level information is written in this log file.

  • $EBS_DOMAIN_HOME/sysman/log

d) Log files for server processes initiated through weblogic: Stdout and stderr messages generated by the server instance (server instances like forms, oafm, oacore etc) at NOTICE severity level or higher are written by Weblogic Node Manager to below directory.

  • $EBS_DOMAIN_HOME/ servers/ <server_name>/ logs/ <server_name>.out

Here is an image representing EBS R12.2 Fusion Middleware Log files:

3

 

If you want to learn more about Oracle Apps DBA (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 then have a look at our  Oracle Apps DBA Training (next batch starts on 31st October, 2015 – Register now for early bird discount, limited time only).

Note: We are so confident on our workshops that we provide 100% Money back guarantee, 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 (or ask us from our 100s of happy trainees in our private Facebook Group)

The post Oracle Apps R12.2 Log Files Location every Apps DBA must know appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

So you know enough in Oracle AppsDBA (EBS) R12.2 – Answer these ? Queries from our Day1 Apps DBA Training

Online Apps DBA - Fri, 2015-10-23 14:14
This entry is part 6 of 6 in the series Oracle Apps 12.2

queries_qanda

This post is from our Oracle Apps DBA (R12.2) Training sharing some of the questions from our Apps DBA Trainees from Day1 (next batch starts on 31st October, 2015 and We cover Architecture, Installation, File System, WebLogic Concepts, Patching, Cloning , Common Tasks and difference in 12.2 from previous version). 

On Day1 of Apps DBA Training We cover Architecture of Oracle E-Business Suite, File System in R12.2 (and change in File System from 12.1 version) and Technology Stack . Here are some of the questions asked in our previous batches of Oracle Apps DBA. Reason for sharing here is so you can check how much you know or help others by answering under comments section (We’ll be answering these over next few days)

1. What is Jinitiator in Oracle Apps? 2. Where is Jinitiator being used in Oracle Apps ? 3. Why OC4J replaced with WebLogic server 11g? 4. Why we are still using Oracle Apps server 10g R3(10.1.2.3) for Forms & Reports 5. Why we used Dual File system in R12.2 ? Application Tier File System has changed in 12.2 to Dual File System to support ………. (answer this in comment) ?  Register here for Oracle Apps DBA 12.2 Training to learn more on Dual File System or Online Patching (ADOP). 6. How do we know Apps tier is using FS1 or FS2 (where FS1 and FS2 are two file system from Apps Dual File System in 12.2)? 7. FS1 or FS2 (dual file system) is independent to each other – TRUE / FALSE ? 8. What is role of Concurrent Manager ? 9. Why do Concurrent Manager Fail (some of the scenarios in which manager could fail) ?

10. What is Database Version that comes with EBS and Can we use any database version with EBS or are there any restrictions ? 11. What is the purpose of patching in Oracle Apps (E-Business Suite) and is it Compulsory to Patch (More Question on Patching on Day3 of Apps DBA Training) ? Well these are just handful of hundreds of questions we answer either in online class or in support ticket (all our trainings comes with 1 Year support for any queries) or in our Private Facebook Group To ask questions like these or learn more about Oracle Apps DBA in 30 Days, register for our Oracle Apps DBA (R12.2) Training (We are so confident on quality and post training support 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) Do you know answer to some of these question ? If yes, post answer under comments section or If you have question related to Oracle Apps DBA, Oracle Fusion Middleware or Oracle Identity & Access Management then ask them in our Private Facebook Group

The post So you know enough in Oracle AppsDBA (EBS) R12.2 – Answer these ? Queries from our Day1 Apps DBA Training appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Solution for OAM Error code OAM-02073 status fail is Excluded false

Online Apps DBA - Thu, 2015-10-22 09:21
When you have performed all the configuration required to protect your web application with Oracle Access Manager, the next thing you do is test if the set up works. In this post, we will see a common problem most of us encounter on trying to test the setup for the first time. On accessing a protection resource of your web application, OAM WebGate intercepts the request and forwards it to the OAM server to determine if the resource needs an authenticated access. If yes, the OAM server redirects the user to login page. Here you enter the login credentials, click on Login and you get a blue Oracle System Error Page. At this stage, you go to OAM Server logs folder and check diagnostic logs which provide you information about why you would have got the error. Here I will mention the error that I got on submitting the credentials in one of the environments: oracle.security.am.proxy.oam.requesthandler.OAMProxyException: Event Response status is STATUS_FAIL for GET_AUTHN_SCHEME event. Error code OAM-02073 status fail isExcluded false         at oracle.security.am.proxy.oam.requesthandler.NGProvider.checkProtected (NGProvider.java:4542)         at oracle.security.am.proxy.oam.requesthandler.NGProvider.getIsRescProtectedResponse (NGProvider.java:1401)         at oracle.security.am.proxy.oam.requesthandler.NGProvider.getResponse (NGProvider.java:369)         at oracle.security.am.proxy.oam.requesthandler.RequestHandler.handleRequest (RequestHandler.java:366)         at oracle.security.am.proxy.oam.requesthandler.RequestHandler.handleMessage (RequestHandler.java:170)         at oracle.security.am.proxy.oam.requesthandler.ControllerMessageBean.getResponseMessage (ControllerMessageBean.java:122)         at oracle.security.am.proxy.oam.requesthandler.ControllerMessageBean_eo7ylc_MDOImpl. __WL_invoke (Unknown Source)         at weblogic.ejb.container.internal.MDOMethodInvoker.invoke(MDOMethodInvoker.java:35)         at oracle.security.am.proxy.oam.requesthandler.ControllerMessageBean_eo7ylc_MDOImpl. getResponse Message (Unknown Source)         at oracle.security.am.proxy.oam.mina.ObClientToProxyHandler.messageReceived (ObClientToProxyHandler.java:223)         at org.apache.mina.common.DefaultIoFilterChain$TailFilter.messageReceived (DefaultIoFilterChain.java:743)         at org.apache.mina.common.DefaultIoFilterChain.callNextMessageReceived (DefaultIoFilterChain.java:405)         at org.apache.mina.common.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:40)         at org.apache.mina.common.DefaultIoFilterChain$EntryImpl$1.messageReceived (DefaultIoFilterChain.java:823)         at org.apache.mina.common.IoFilterEvent.fire(IoFilterEvent.java:54)         at org.apache.mina.common.IoEvent.run(IoEvent.java:62)         at oracle.security.am.proxy.oam.mina.CommonJWorkImpl.run(CommonJWorkImpl.java:41)         at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)         at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

OAM stores the web server host and port information in Host Identifiers configuration. You will get the above error message when the information provided in host identifiers is not correct. The host identifier entry need not be the same as the one you enter in the browser to access protected resource especially when you have multiple network interfaces on the web server machine. To get the exact host name that the OAM server expects, you can enable the OAM logs in Trace mode. It will give you the host name as well as the port number for which the error is logged. In order to fix this problem, you need to provide the correct host name and port number combination entry in Host Identifier for  the configured OAM Agent.

If you get this error from a non-browser based application such as a Java client application, you will need to make sure that you have correct entries in host identifier and resource string that you pass to oracle.security.am.asdk.ResourceRequest() object.

If you want to learn more issues like above or wish to discuss challenges you are hitting in Oracle Access Manager Implementation, register here for our Oracle Access Manager Training (next batch starts on 22nd Nov, 2015).

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.

Did you subscribe to our YouTube Channel (379 already subscribed) ?

The post Solution for OAM Error code OAM-02073 status fail is Excluded false appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

How To Install Latest Verisign G5 Root Certificates

Vikram Das - Wed, 2015-10-21 15:48
Dhananjay pinged me today and told me that for their Paypal integration, they had to upgrade to Verisign G5 root certificate.  This was the message from Paypal:

Global security threats are constantly changing, and the security of our merchants continues to be our highest priority. To guard against current and future threats, we are encouraging our merchants to make the following upgrades to their integrations:
  1. Update your integration to support certificates using the SHA-256 algorithm. PayPal is upgrading SSL certificates on all Live and Sandbox endpoints from SHA-1 to the stronger and more robust SHA-256 algorithm.
  2. Discontinue use of the VeriSign G2 Root Certificate. In accordance with industry standards, PayPal will no longer honor secure connections that require the VeriSign G2 Root Certificate for trust validation. Only secure connection requests that are expecting our certificate/trust chain to be signed by the G5 Root Certificate will result in successful secure connections.
For detailed information on these changes, please reference the Merchant Security System Upgrade Guide. For a basic introduction to internet security, we also recommend these short videos on SSL Certificates and Public Key Cryptography.
There is a support.oracle.com article published on October 16, 2015 which has detailed steps for 11i and R12.1:

How To Install Latest Verisign Root Certificates For Use With Paypal SDK 4.3.X (Doc ID 874433.1)

The Verisign G5 root certificate can be downloaded from:

Paypal Microsite about this change: https://www.paypal-knowledge.com/infocenter/index?page=content&id=FAQ1766&expand=true&locale=en_US

Useful Links
Categories: APPS Blogs

New Features in Oracle R 12.2.5 for Apps DBAs

Online Apps DBA - Wed, 2015-10-21 10:20
This entry is part 5 of 6 in the series Oracle Apps 12.2

Apps12.2

This post on New Features in Oracle Apps 12.2.5 for Apps DBAs is coming from our Oracle Apps DBA Training (next batch starts on 31st October, 2015) where we cover Installation, Patching, Cloning, AutoConfig and other maintenance tasks. We also cover overview of Oracle E-Business Suite upgrade from 12.2.0 to 12.2.4 (and now 12.2.5) to show how to apply patches and new patch tool ADOP  in Oracle Apps.

Register early here for Oracle Apps DBA 12.2 Training to get discounted price (Limited Time Offer)

As you all know Oracle announced release of 12.2.5 last week and this seems to be the most awaited release in 12.2 series as there were many features which were includes. We are managing R12.2 since beginning for our customers and and witness the changes in Oracle Application.

From 11i to R12.1 to R12.2 major technology changes were there, We can say that R12.2.5 is one more steps closer towards Mobile/Cloud

First most visible feature for Business is Look & Feel. Oracle R12.2.5 has come up with Cloud/Icon based UI. Now you will see icons in the login screen which is more comfortable to view from Tablets and Mobiles.

For Apps DBA’s & DBAs side there are few excellent features which I want to highlight (more to follow in upcoming weeks):

1- dualfs option: Standard cloning was easy in R12.1 and when R12.2 was releases cloning was two steps (second step was almost repetitive)

In 12.2 (prior to 12.2.5)
Step1 -> Clone the Source run file system to target run file system
Step2 ->Clone the target run file system to target patch file system.

Now with dualfs option You can do both the above steps in one shot. Yes, Oracle reduced cloning efforts to almost 50% now. In one go both the file system will be configured.

2- Central Inventory: Believe me I am having the feeling that Oracle has started his own listener to Lister my pains. When you are hosting multiple Oracle R12.2 instances on the same server inventory is always need to considered and specially when you are running fs_clone. Now with the introduction of this feature we will be in a comfortable position.

<BASE_PATH>/oraInventory/oraInst.loc
3- ADOP – Maintainance and Validation:  I was wandering till now that why there is no dedicated utility to monitor the Online Pathing and now oracle has introduced one – adopmon. This can be used for
-Overall monitoring
-Individual Phase

Last time when I applied patch I missed to run fs_clone which was post patch application. Now when I ran prepare phase for the next cycle it went into error. We need to abort and cleanup and then redo the stuff again.

Now adop -validate will save us from all this and will let us know our instance is ready for the patching or not.
4- Weblogic oacore Performance enhancement: Overall if you have observed basic memory requirement or usage of R12.2 it is bit on the higher end compared to other versions. Specially managed server if you see it starts Java Messaging services, deployed EJB’s.
Also reported issue related to oacore that it takes long time and alos when you do startall script last one which get start and takes more time is oacore only.
So now oracle has addressed the performance side and did 2 enhancement

a)  Paramter -DserverType=wlx -> This is startup parameter for all the managed server and prevent startup of EJB, JMS,JCA services
b)  Context Variable s_deploy_portlet -> This prevent Portlet Producer libraries to get deployed in EBS domain.

Also default value of s_forms-c4wsstatus is set to Disable as earlier it was enabled.

5- ADOP UI : Someone well said “more information mean more confusion“. Keeping that in mind now ADOP UI has become more selective, to the point information, also more refined information from 12.2.5 onwards.

If you need to learn more on Oracle Apps DBA R12 (Architecture, Installation, WebLogic, Patching, Cloning and other maintenance tasks with the upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 (now 12.2.5) then have a look at our  Oracle Apps DBA Training (next batch starts on 31st October, 2015).

Note: We are so confident on our workshops that we provide 100% Money back guarantee, 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 (or ask us from our 100s of happy trainees in our private Facebook Group)

 

Looking to get more information or FREE tips on Oracle Administration then join our newsletter or for just specific to Oracle Apps DBA topics then click enter leave you name & email here

The post New Features in Oracle R 12.2.5 for Apps DBAs appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Apple Logo

iAdvise - Wed, 2015-10-21 07:00
As simple as it is the story about the Apple Logo inspiration is quite true because there are very many people who have done research on the same and ended up with this result. This actually triggered some emotions from a number of people who said that the story was quite touching and they would have never thought of it in that way. There are still a few people however who still believe that it is a myth. This is probably because there are very many theories that have been made up on the topic.
Apple is arguably one of the best mobile phone brands that are found in the market today. The company is always rolling out new versions of the phone which come with better specs so that they can fit in the ever changing technology world. There are numerous versions that people have come up with as to the origin of the Logo inspiration. Below however you will find the real story behind it to know how it really came about.
Apple LogoApple LogoApple LogoApple LogoApple LogoApple Logo
A gentleman by the name John Kates claimed that the Apple Logo found on the back of the Mac or iPhone was done as a tribute to another gentleman who was known as Alan Turing. Turing was the made who laid the foundations that are used for modern day computers. He pioneered research into artificial intelligence and also unlocked the codes used for German wartime. He died ten years after the war had ended and provided the links with the brand. Facing jail being charged with indecency, unrecognized for his great work and humiliated by the estrogen injections he was given in a bid to "cure" his sexuality are some of the frustrations that made him bit into an apple that had been laced with cyanide.
Alan Turing dies on 7th June 1954 in obscurity exactly ten years and a day after Normady landings. These made copious use of the intelligence that has been gleaned by his methods. Before iOS7 was introduced to the market the story goes on about how two entrepreneurs in Stanford were searching for a logo that would be used for their new computer company. After some time they remembered the contribution that Turing had made to the industry and thus decided to work with an Apple. This was not a full one but one that had been bitten.
Some of the theories that have been advanced in regards to apple is that the founders used the theme of the first people (Adam and Eve) when eve bit the apple. Others refer to the fruit as the one that helped Sir Isaac Newton to develop the concept of gravity. Supporters of the latter believe that the logo was first known as the Newton before it changed its name. This can however be challenged because it happened more than ten years after the logo had already been created. The developer however does away with the two theories and tends to agree with the Turing version and says that it is an incredible urban legend.
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