John Piwowar
  • Male
  • Vancouver, BC
  • Canada
Share on Facebook
Share Twitter

John Piwowar's Friends

  • Tony D'Amico
  • Surachart Opun

Gifts Received

Gift

John Piwowar has not received any gifts yet

Give a Gift

 

Hi there!

Latest Activity

John Piwowar commented on jay's blog post What product components are covered by Standard Edition 10g
"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."
Jun 5, 2009
abhishek singh left a comment for John Piwowar
"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…"
May 1, 2009
John Piwowar posted a blog post

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.
Apr 30, 2009
John Piwowar commented on Zeeshan Ali's blog post function query
"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…"
Apr 23, 2009
John Piwowar posted a blog post

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:…See More
Apr 11, 2009
John Piwowar posted a blog post

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.
Apr 3, 2009
John Piwowar posted a blog post

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 EBSAfter two months of cheerfully monitoring your…See More
Mar 23, 2009
John Piwowar posted a blog post

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. ;-)
Feb 13, 2009

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

OTN Forums
LinkedIn
Facebook
Oracle Mix
Caribou Coffee (usually with a sleeping toddler)

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

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… 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 (3 comments)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

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 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

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Oracle AQ: working with PL/SQL asynchronous notifications

I'd like to share a basic example of how to consume Oracle AQ messages using PL/SQL: https://fcosfc.wordpress.com/2014/12/17/oracle-aq-working-with-plsql-asynchronous-notifications/

Posted by Paco Saucedo on December 17, 2014 at 12:45pm

flashback recovery in RAC enviorment using Data Guard Broker

I am trying to flashback recover using DGMGRL from the current primary node.

I am running the following command:

    dgmgrl> reinstate database pri

but I am getting the  error "ORA: 16653" every time when all the instances of failed primary database are up/running but if only one instance is up then it doesn't give any error.

So I want to ask that:

Is flashback recover is supported through DGMGRL or it is supported only in case of one…

Continue

Posted by Vishvendra Singh Rana on November 25, 2014 at 7:30am

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

profiles in Oracle DBA

I've one question it is related to Oracle DBA, I've just read about password settings in profiles concept, i'm little bit confusing on PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME, and I understand something about these two topics. I updating here what i'm understand when I was reading about this, so tell me is it right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used for reusing of old passwords. The functionality of this setting is restricts reusing of old password for…

Continue

Posted by Bhagya Raj Katta on October 10, 2014 at 7:21am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service