The social network for Oracle people
-
John Piwowar
- Male
- Vancouver, BC
- Canada
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts (12)
- Discussions (5)
- Events
- Groups (3)
- Featured Photos
- Photo Albums
- Featured Videos
John Piwowar's Groups
-
OTN Forum Regulars
97 members
-
Database Admins
308 members
-
E-Business Suite
491 members
John Piwowar's Discussions
Database schema object privialges
Replied Jul. 1, 2009
Hi there!
Gifts Received
John Piwowar has not received any gifts yet
Latest Activity
Hi Frank,
I do have some experience w/ EBS on VMware; I've run several test and development EBS instances in a VMware cluster. I was working in a DBA/Apps DBA role, however, and did not have regular administrative access to the VMware part of the s…
Hi Frank,
This is not the same as "Running Oracle on VMware is unsupported." Consider: VMware essentially provides a virtual hardware platform on which to run a guest OS. If you were running Oracle on HP or IBM hardware, and encountered a problem t…
Hi,
You can find the list of licensed components for Standard and Enterprise Edition in the Oracle 10g documentation. Here's a link, to spare you the search. :-)
Regards,
John P.
In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.
Hi Ali,
Two thoughts: First, I think you need to reverse the position of name1 and name2 in your query, for example:
SQL> create table tcase (name1 varchar2(20), name2 varchar2(20));
Table created.
SQL> insert into tcase values ('HAMID','HaMiDaBdU…
Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!
Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) on Twitter, and I found myself thinking, "hey, I bet I could actually answer that!" So I did. Then I thought about my answer a bit more, and…
Profile Information
- About Me:
- I work with Oracle products. Anyone else around here into that? ;-) OCP DBA (9i, 10g) and OCP Apps DBA (11.5.10, R12)
- My Blog:
- http://only4left.jpiwowar.com
Other places to find me
John Piwowar's Blog
How old is that E-Business Suite clone, really?
In this post, I explore some methods to determine when the data in an E-Business Suite database was copied from its source.
Posted on April 30, 2009 at 6:53pm —
Oracle 10gR2 RDBMS for Mac OS X (Intel) has arrived!
Oracle has, at long last, released a version of the RDBMS for Mac OS X Intel. Not all features are supported, but on the other hand, it will run natively even on a non-Server version of Leopard. Woohoo!
A quick note: I don't have any installation instructions in the post linked above, but here are some good resources:… Continue
A quick note: I don't have any installation instructions in the post linked above, but here are some good resources:… Continue
Posted on April 11, 2009 at 5:00pm —
Via Twitter, an interesting regexp_replace puzzle
Prolific and knowledgeable Oracle Ace LewisC asked a regular expression (more specifically, regexp_replace) question on Twitter, and I found myself thinking, "hey, I bet I could actually answer that!" So I did. Then I thought about my answer a bit more, and decided to write a blog post to expand upon my original 140-character response.
Posted on April 3, 2009 at 9:30am —
Two new(ish) blog posts: EBS log files and still more EBS and Grid Control
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 cheerfully monitoring yo… Continue
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 cheerfully monitoring yo… Continue
Posted on March 23, 2009 at 7:44am —
Retrieving Oracle patches with wget
While working from home this evening, I had to download some patches to a remote Linux system, and was struck, not for the the first time, by the inconvenience of it all. So I wrote a quick shell function that helps me grab patches using wget. And then, I decided to share with the world, or at least the really small portion of the world that visits my blog. ;-)
Posted on February 13, 2009 at 9:09pm —
Comment Wall (4 comments)
- At 7:24am on May 1, 2009,
abhishek singh said…
- hey john ,
welcome to the community
i am starter in oracle working for last 6-7 month.it was nice to read your blog .
but i'm really looking forward to asm technology .
would be great if you can comment on that
once again welcome to the community
thanks
- At 12:43pm on November 10, 2008,
Kiel Sanders said… - John
Hi my name is Kiel and I am a Sr Recruiter at CyberSearch out of Chicago, IL. I am currently looking for an Oracle Apps DBA for my client in Cincinnati, OH and Atlanta, GA. I attached the job description below for you to see if you or anyone you know are interested. If so, please feel free to contact me at kiel.sanders@cybsearch.com or (847) 879-2151 and I can give you a more details. If you are not interested, I would appreciate it if you could forward this message along to colleagues you have worked with in the past with similar qualifications. Also, please add me to your network so we stay in contact for future positions. Thank you and I look forward to hearing from you!
Kiel Sanders
(847) 879-2151
kiel.sanders@cybsearch.com
---------------------------------------
Oracle Apps DBA
Location : Atlanta, GA OR Cincinnati, OH
Duration : 1 - 3 years
Rate : $6k - 8k/month
Start: ASAP
Interview: phone
Please make a note we need US citizen & GC holder candidates only
Essential Functions (Responsibilities):
· APPSDBA support for Oracle application 11i
· Cloning & Patching of Oracle APPS and DB
· Database & ERP Tech Stack Upgrade, Apply Quarterly cumulative patch updates CPU
· Backup & Recovery
· Performance Tuning
· Familiarity with configuration & usage of 10g Grid.
· 7/24 Production Support, troubleshooting and Performance tuning.
· TAR Resolution for Bugs reported
· Support Oracle Applications upgrade
Qualifications/Requirements:
PRIMARY SKILLS:
· Oracle Apps DBA with over 3 years experience in 11i Oracle Apps.
· Worked on 24 x 7 Production Support or implementation both single node and dual node environments.
· Understanding of cluster configuration & load balancing configuration in ERP
· Be willing to stretch beyond the normal working hours
· Should have worked on Unix platforms preferably on Sun Solaris
· Good understanding of Oracle Apps cloning methodology
· Extensive Patch Application experience
· Participated in at least one upgrade project
· Oracle DBA experience of over 5 years experience
· Worked on all kinds of Database versions
· Worked on Databases of bigger sizes
· Worked on Backup & Recovery issues
· Good Performance tuning experience
· Good knowledge on all the database related issues
· Apache & Jserver trouble shooting
OTHER SKILLS:
· Experience in Oracle RAC
· Shell scripting
Desired:
· Ability to work in a professional manner, be flexible, and handle interactions with all levels of the organization and with external clients.
· Self-directed, organized, and motivated.
General:
· Good written and verbal communications skills are required
· Excellent Team Player
- At 10:39am on October 16, 2008,
Tony D'Amico said… - John, thanks! Good to hear from you. How are things at Vocollect?
- At 7:24pm on September 7, 2008,
Eddie Awad said… - Hi John and welcome to OracleCommunity.net. Nice Ubiquity command by the way.
Oracle Community On
Oracle Blogosphere
Badge
© 2010 Created by Eddie Awad.
Powered by 
.
