Posted by Yury Velikanov on Nov 19, 2010
I just recently faced an issue on how to automate the Workflow Mailer override address for development and testing environments during the EBS cloning process. For the information of others, the “override address” is an email address you can set per EBS environment where WF Mailer will send ALL emails avoiding sending emails to real users during testing and development.
The problem is that the only official way to set the override address in the latest ATG releases is to go through the OAM portal and change the override email via the GUI interface. The GUI sends a verification code to the email address entered, asking to enter it on the next screen to confirm the change. The issue is that we as Apps DBAs do not always have access to the override address mail box. On top of that if we are looking to script whole EBS cloning process we need to find SQL-PL/SQL based solution.
Read the rest of this entry . . .
Posted by Yury Velikanov on Sep 30, 2010
As many of you know a cloning is one of the most DBA time consuming operations. For the first few times an Apps DBA may enjoy it. However, after the 20th cloning it becomes a boring routine.
For some time I have been interested to get the EBS cloning process 100% automated and I must admit that for many customers we have been quite successful with the process; saving them tons of DBA boring hours ;)
If you have tried to automate EBS cloning then you definitely know that you can’t get through without hacking and customizing the Oracle-provided Rapid Clone utility. One of the areas we should “hack” the code to make it running in batch scripts is the services startup bit. The problem is that by default straight after Rapid Clone is completed Oracle starts all the services on the Apps node and until now there wasn’t a way to change it. There are many reasons why you wouldn’t start Apps processes straight after Rapid Clone is completed. Among them are APPS user password change (this is typical operation for cloning), SSO integration, CM/CR disabling etc.
R12.1.2 brings on board a small but very nice feature. From now on, Rapid Clone will ask you if you would like to start services at the end of Rapid Clone call:
Do you want to startup the Application Services for EBSPRD? (y/n) [y] : n
How great is this? Now we can specify that we don’t want to starup services and run after cloning steps before we are ready to start the environment.
My best regards to all Apps DBAs around,
Yury
Posted by Yury Velikanov on Sep 8, 2010
Hello Apps DBA,
I’ve just come across an old known issue again today. Was working in the greatest and latest 12.1.2 Oracle e-Business Suite environment. Surprisingly, I face the old issue when WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES objects (among other objects) are set to NOLOGGING mode. Strictly speaking, the LOGGING attribute was set to YES at the table level, but several partitions of that table were set to LOGGING = NO! The SQL’s below will help you check if your environments are effected. Keep in mind that you should sound the alarm at your business if any other modules’ objects are in the list.
Read the rest of this entry . . .
Posted by Catherine Chow on Feb 4, 2010
A data file is considered unrecoverable if an unrecoverable operation has been performed on an object residing in the data file since the last backup of the data file. Operations will become unrecoverable if they are not logged in the redo log. These “nologging” operations that suppress the generation of redo log, include the following:
- direct load/SQL load
- direct-path inserts result from insert or merge statement
ALTER TABLE commandsCREATE and ALTER INDEX commandsINSERT /*+APPEND*/- partition manipulation
- database object that has explicitly set with nologging option
- Oracle eBusiness Suite concurrent job execution identified in Oracle metalink note: 216211.1
- Oracle eBusiness Suite patches activities that involve database object manipulation
The database recovery operations will look completed, but those data blocks used by the nologging objects in the data file will be marked corrupted when they are recovered. Accessing those nologging data objects in the recovered database instance will return a data block reading error such as ORA-1578 and ORA-26040, and the logical corruption in the data file will prevent the database object from being useful in the recovered database instance.
How do we detect unrecoverable operations?
Unrecoverable data files are those that involve nologging operations since the last successful backup took place. There are several ways to identify them. Read the rest of this entry . . .
Posted by Marc Fielding on Jan 12, 2010
Oracle has just released their January installment of their critical patch update (CPU). Vulnerability CVE-2010-0071 is particularly critical, with a CVSS score of 10, the highest possible. It’s a remotely-exploitable listener vulnerability that’s particularly severe on Windows platforms.
Full details are on Oracle’s security site.
Posted by Alex Gorbachev on Oct 22, 2009
Yes, it’s almost that time of the year when one of the best Oracle conferences in the world opens its doors to attendees in Birmingham — UKOUG Conference 2009: Technology & E-Business Suite. The lineup of speakers will be fantastic as usual and agenda is full of juicy bits — You will have usual troubles scheduling sessions to attend and hate to make compromises between presentations you want to see badly but that’s kind of problems you’d rather have at a good conference.
The past year was very eventful so I feel like I haven’t been at the UKOUG Conferences for years even though I did come to the UKOUG Conference 2008. This conference is something special for me — it’s the first conference I attended and presented on so it’s set the tone for the whole conferencing experience of my life and I’m very grateful for that! So far, I haven’t missed a single year since my first UKOUG conference and I hope I keep it this way for years to come.
Read the rest of this entry . . .
Posted by Alex Gorbachev on Sep 20, 2009
Oracle Open World 2009 is just few weeks away and I firmed up my presentation schedule now. I will present three “normal” presentations and couple unconference sessions. I’m arriving in San Francisco few days before the conference (7th of October) get to the Oracle ACE Directors briefing so I’ll spend the first few day in Redwood Shores and then off to Moscone Center.
Before I get to the schedule, if you want to catch up with me during OOW — tweet me @alexgorbachev. You are likely to see me in the OTN Lounge or in “The Cave” if you know what I’m talking about.
Here is a quick summary of my presentations:
Read the rest of this entry . . .
Posted by Alex Gorbachev on Sep 10, 2009
Update 9-Jul-10 Pythian has now announced our range of Oracle Exadata Services, along with successful implementations and reference customers.
Update 16-Sep-09: Apparently, all this was true and you can find more details after the announcement that posted here.
OK. It’s not often that I make predictions these days but this was on my mind for a while so here we go. Mind you, I don’t have any confirmed insider information so it’s based on some assumptions, my perspective on Oracle-Sun acquisition and some vibes I can feel in the air.
The rumors are that Oracle Exadata v2 and Oracle Database Machine v2 are going to be announced within few weeks and my take is that it’s going to happen at the Oracle Open World. I don’t think it comes as a surprise to anyone that it will be configured with Oracle Database 11g Release 2.
Moving on to predictions and speculations…
Read the rest of this entry . . .
Posted by Alex Gorbachev on Jun 22, 2009
What: Sydney Oracle Meetup #7 – Advanced Queuing in E-Business Suite
When:Tuesday, June 30, 2009 5:30 PM (please, make sure to RSVP yes/no/maybe)
Where: Our standard location in Sydney CBD
Welcome to our meetup #7! This meetup will be focused on Oracle Advanced Queuing (AQ) feature and its usage in Oracle E-Business Suite.
For inexperienced SOM members, we are starting with the meet & greet and pizza+drinks at 5:30 pm and move to smart things at 6:00 pm. We will be there until about 8:30pm (some are sticking around a bit longer while some might take off a bit earlier) and will have a break in the middle. The second half is generally more open-ended as most of you already know.
So what are the goodies at this meetup?
Read the rest of this entry . . .
