To all who have joined the community I hope you have had occasions to post questions to others in the community. My purpose in creating this was to create a specific forum and meetinplace for those Oracle DBAs who have or wish to attain or improve their skills in OS, storage and networks. Whilst Harald van Bfreederode and myself continue to blog on our own blogs the Message of DBA 2.0 skills is still very important. Please help us all by sharing ideas and knowledge for members of this… Continue
Added by Joel Goodman on March 31, 2009 at 10:17am —
addbctl.sh - start or stop the database
addlnctl.sh - start or stop the database listener
adalnctl.sh - start or stop the APPS listener
adapcctl.sh - start or stop the Apache web listener
adcmctl.sh - start or stop the concurrent manager
adfmcctl.sh - start or stop Forms Metrics Server
adfmsctl.sh - start or stop Forms Metrics Server
adfrmctl.sh - start or stop the forms server
adrepctl.sh -… Continue
Added by Jiltin on March 31, 2009 at 7:36am —
Just run this sample sql changing the patch number (3061831) in sqlplus or Toad.
SELECT DISTINCT rpad(a.bug_number,11)|| rpad(e.patch_name,11)||rpad(trunc(c.end_date),12) ||rpad(b.applied_flag,4)
WHERE a.bug_id = b.bug_id
AND b.patch_run_id = c.patch_run_id
AND c.patch_driver_id = d.patch_driver_id
AND d.applied_patch_id =… Continue
Added by Jiltin on March 31, 2009 at 7:30am —
How do you check the profile option values using sql - Oracle Applications? -> profile option values
Profile Options provide flexibility to Oracle Apps. They are a key component of Oracle Applications, hence these much be understood properly. I will be taking multiple examples here to explain what profile options mean. I will also try to explain by stepping into Oracle shoes “How will you design a program that is flexible”, by using Profile… Continue
Added by Jiltin on March 30, 2009 at 8:00am —
I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities.
Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql.
SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id
Added by Jiltin on March 24, 2009 at 8:00am —
Whose log file is it, anyway?
I wrote a quick and dirty script to query FND_PROFILE tables to get information about a log file I found on an E-Business Suite app tier. Not particularly revolutionary, but on the off-chance that it helps someone, I'm sharing.
More fun with Grid Control and EBS
After two months of… Continue
Added by John Piwowar on March 23, 2009 at 7:44am —
This is just a thought about making our information more accessible. I've adopted a print.css on my main blog to expand all content on an entry and strip unnecessary header, footer, and sidebar information.
Aside from the striping the useless page stuff, a print.css let me unfold all my entries. This was important since I adopted JQuery folding on the pages based on feedback from readers. The folding forces me to reflect a bit more before I post something and hopefully avoids… Continue
Added by Michael McLaughlin on March 22, 2009 at 8:06am —
When I presented the concept at the Utah Oracle User’s Group (UTOUG) Training Days 3/12-3/13/2009 it became clear the community could benefit from more detail about table and pipelined table functions. I updated my old entry
, more or less rewrote it entirely, now there's a 16 page post. Hope you enjoy it.
Also, about a month or so ago I began tweeting. You can find me at MacLochlainn… Continue
Added by Michael McLaughlin on March 22, 2009 at 7:47am —
Securing sensitive data in database environments is only one piece of the compliance puzzle. Ensuring that you are alerted when unusual activity is occurring and keeping a secure and searchable audit log of database changes is critical to maintaining compliance with regulatory requirements as well as ensuring adherence to corporate information governance policies. Database audit
tools allow enterprises to mitigate security risks with real-time… Continue
Added by lorryins on March 17, 2009 at 9:53pm —
The need for migration of applications in enterprises arises from changes in business demands or technology challenges to improve operational efficiency and to manage risk. Addressing the growing need of enterprise application networks to migrate data across applications, protocols and proprietary data structures; enterprise data migration
solution enables seamless data migration across enterprise applications.
Added by lorryins on March 17, 2009 at 9:40pm —
In the interest of learning more about the architect community within the larger Oracle community, I've created a short survey on Survey Monkey.
Click Here to take survey
You'll notice that there's not a single question about what Oracle products you use, or when your company plans to make a purchase. I don't ask for your email address or telephone number, or anything more specific than city,… Continue
Added by Bob Rhubart on March 16, 2009 at 4:56am —
This time the subject is how Oracle evaluates NOT EXISTS and NOT IN clauses and hints that influence anti-join query optimization.
Below query had no respond for hours before I started to work on it, two table have some 100 millions of rows in this example;
-- original query
SELECT /*+ parallel (q1,16) */ count(*)
FROM party PARTITION(party_01) q1
WHERE party_id NOT IN (SELECT /*+ hash_aj */ party_id
FROM party_new… Continue
Added by Hossein Heidarpour on March 13, 2009 at 7:20am —
Data in production systems use highly available redundant Tier 1 storage systems. Enterprise data archiving is a proven strategy to relocate data to less expensive Tier 2 storage, reducing the need to continuously add to storage to production systems. Most experts conclude up to 80% of production data is no longer mission critical. Using data archiving
reduces overall storage costs while maintaining access through the native… Continue
Added by lorryins on March 10, 2009 at 5:12am —
Enterprise class business applications require multiple copies be made to support test data management processes such as patch, test, QA, and training. Most companies make 6-8 full size clones for every production application, not only wasting storage and time in cloning but potentially exposing sensitive application data to the test environment. Data masking
provides companies with a centralized solution to manage the test data… Continue
Added by lorryins on March 10, 2009 at 5:08am —
4. Verify the correct interface subnet is in use by re-running oifcfg with the 'getif' option:
% $ORA_CRS_HOME/bin/oifcfg getif
eth0 220.127.116.11 global public
eth1 192.168.1.0 global cluster_interconnect
Notes for Windows Systems
The syntax for changing the interfaces on Windows/RAC clusters is the same as on Unix or Linux, but the interface names will be slightly different. On Windows systems, the default names assigned to the interfaces are generally… Continue
Added by Hossein Heidarpour on March 9, 2009 at 5:03am —
Oracle Server - Enterprise Edition - Version:
Information in this document applies to any platform.
The purpose of this note is to describe how to change or update the interconnect and/or public interface IP that is stored in the OCR. This may be necessary if there is a network change affecting the servers, or if the original information that was input during the installation was incorrect. It may also be the case that for… Continue
Added by Hossein Heidarpour on March 9, 2009 at 5:00am —
The wireless technology, the Internet, the convergence of data, voice and media and industry consolidations driven by mergers and acquisitions has led to a major metamorphosis in the telecom
industry in the last fifteen years. This resulted in a number of challenges for the telecommunication industry like declining revenue, customer churn and growth in regulatory requirements.
Due to millions of subscribers and massive operations, data… Continue
Added by lorryins on March 5, 2009 at 12:39am —
Enterprise data management
solutions are ideal for large enterprise companies that manage voluminous business critical data. Data management tools enable companies to more efficiently classify, manage and secure applications, maintain information governance, implement tiered storage strategies and consolidate data.
Data management solutions provide organizations with the tools to mitigate risk, reduce storage costs, enforce consistent security… Continue
Added by lorryins on March 5, 2009 at 12:30am —
Newly certified in Oracle Demantra Demand planning product. I'm looking for an opportunity here in the US. If you are looking for a eager and qualified candidate please send me your requirements.
Added by Gary Salvadore on March 4, 2009 at 8:09am —
CREATE TABLE d_date AS
n AS Date_ID,
TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day') AS Full_Date,
TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'DD') AS Days,
TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'Mon') AS Month_Short,
TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') + NUMTODSINTERVAL(n,'day'),'MM') AS Month_Num,
TO_CHAR(TO_DATE('31/12/2007','DD/MM/YYYY') +… Continue
Added by uli on March 1, 2009 at 1:15am —