date:20030402

Even those of us with cursed systems have vpn access to our servers.
:)
Jared





"Nelson, Allan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/02/2003 03:08 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Remote DBA


Well, one of the easiest ways, assuming you are not cursed with a
windows database, is to provide a vpn solution for access to the
servers.  A vpm typically gives you an address on the network you vpn
into.  From this point standard client tools work.  If you are cursed
with windows then you can put a decent telnet server on the windows box,
cygwin I think will work, if you need direct access or use client tools
if you don't.  There are also tools like Damware and VNC to manage
windows servers remotely.  If you have linux or unix then cygwin,
Reflections, Hummingbird, a linux box, an xterm or someother unix
workstation will be all you need.

Allan

-Original Message-
Sent: Wednesday, April 02, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Thanks Goulet,Dennis for the feedback. I have already searched for and
found the same thru google. But could not found and docs/whitepaper link
on this. Suppose we have to do DBAdmin job for our on server remotely
then how we should go about it. Can u or anybody else explain! thanks in
advance.

Best Regards
Ramesh D. Papnoi

-Original Message-
WILLIAMS
Sent: Thursday, April 03, 2003 2:59 AM
To: Multiple recipients of list ORACLE-L


Ramesh
   If you visit the web sites of vendors that provide this type of
service, you may find the white papers you desire. I went to Google and
typed Oracle remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC
Patrol. Then you work together to set some guidelines on what they will
monitor and what action they will take under certain circumstances. In
addition, they can perform "staff augmentation" tasks as you desire. For
example, if your site doesn't have the staff to upgrade to a newer
Oracle version, they can plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate
if any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



__
This email is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. 
Copying, forwarding or distributing this message by persons or entities 
other than the addressee is prohibited

Re: RE: how to find INDEX CORRUPTION ???

2003-04-02 Thread Prem Khanna J

Thans Rafiq.
The degree for the table is 1.

SQL > create index idx_mh_frommemno on msg_history ( frommemno );

this is what i did ? 
either it's a bitmap or b-tree on this column (only) , it results in ORA-600. 

i wonder why it happens so ?!
any clue !!

thanx once again.

Jp.

2003/04/03 5:54:54, "M Rafiq" <[EMAIL PROTECTED]> wrote:

>Drop the index and recreate it without parallel clause. If your table is 
>having degree > 1 , then make it 1 and then recreate index. It looks a old 
>bug for bitmap index on a table having degree > 1.
>
>Regards
>Rafiq

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

Shutdown Immediate v. Shutdown abort (Tastes Great...Less Filling!)

I'll admit to being in the Immediate camp. Why? I like the database to come down in a
consistent state except in emergency circumstances. There have been bugs related to
shutdown abort causing database problems.
Do those in the Abort camp have valid reasons? Absolutely! Recovery is quicker and
problems are extremely rare.
I have a higher level of comfort in immediate. That is why I use it. Can I use abort/startup restrict/normal without incurring problems? Yes, except in rare cases. Almost certainly more rare than the times when the immediate takes longer than expected.

I don't think this issue is one of black and white/right and wrong, but rather varying shades of gray.

Okay, Connor...your turn!

--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

>To me it seemed the same as turning off your computer with the power >button instead 
>of the shutdown command or using kill -9, sometimes you >have to, but it's not what 
>you do normally.
>
>Chris Berry

Sounds practical. 
GovindanK

-- 
|XXX|
|You should treat others the way you want to be treated - Mahatma Gandhi|
|XXX|


__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Darrell Landrum

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

- Drives to work on busy streets exclusively
- successful trips to work: over 14,000
- accidents during trips to work: 0
- still, I drive carefully

>>> [EMAIL PROTECTED] 04/02/03 04:28PM >>>
Well... my official oracle instructor in dba larva school said that
it's
tantamount to crashing the db--or so I recall anyway.  This isn't so?

Peace,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L

On Wed, 2 Apr 2003, Chris Berry wrote:

> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?

What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton 

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: invalid dbms_shared_pool

2003-04-02 Thread AK

thanks  Rich ,
is is hp-ux 8.1.6. db . I haven't tried alter package .. yet . Only thing
that's differnet is there was no patch or compilation in last few months .
How can the package become invalid one day .

-ak


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 2:28 PM


> You don't say what version, but I've seen many SYS packages go invalid in
> 8.1.x on HP/UX, especially after patching or installing a new
option/feature
> like Oracle Text.  I've found that attempting to revalidate them either by
> hand or by running ?/rdbms/admin/utlrp.sql is futile.  One gets fixed and
> five others break.  Fix those five and three more break.  Lather.  Rinse.
> Repeat.
>
> For better or worse, the only way I've been able to consistently fix this
is
> to take the brute force approach and rerun the ?/rdbms/admin/whatever.sql
> script that created the packages that are now invalid in the order in
which
> they were originally run when the DB was created.  Depending on which
> packages, this may be best left to off-hours.
>
> GL!
>
>
> Rich
>
> Rich JesseSystem/Database Administrator
> [EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA
>
> -Original Message-
> Sent: Wednesday, April 02, 2003 3:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> In one of our db i found that dbms_shared_pool package body is invalid .
Any
> idea why that could happen . It's not causing any problem . It's just
> appearing as one of invalid objects .
> In fact I am able to execute dbms_shared_pool.keep
> with out error . Looks like  specification are intact .
>
> there was no package compilation in many days .
>
> Only thing i remeber is , we tried to set keep pool
> and i misspelled  keep_pool ,( but does that cause invalidation , i dont
buy
> it )
>
> -ak
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Nelson, Allan

Suppose you have a database with a sid of mydb running on unix.
Shutdown abort is like doing the following from the unix command line:
ps -ef | grep mydb | grep -v grep | xargs kill -9.  All the processes
that make up the instance or processes that are connected to that
instance are killed.  The database will require instance recovery on the
next start.

Allan

-Original Message-
Sent: Wednesday, April 02, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L

Well... my official oracle instructor in dba larva school said that it's
tantamount to crashing the db--or so I recall anyway.  This isn't so?

Peace,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L

On Wed, 2 Apr 2003, Chris Berry wrote:

> Shutdown abort is pretty drastic, are you sure shutdown immediate 
> didn't work?

What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Remote DBA

From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Ramesh
   My assumption was that you were considering hiring a remote DBA 
service.
If you are talking about managing your own server remotely, that is a
different issue.
   For that, the first question is whether the platform of your server is
Unix or Windows. For Unix, pretty much everything is remote anyway. I 
rarely
need physical access to the server. It matters little whether the server is
in the next room or on the other side of the world.
   Now, if you are on a Windows platform, it matters which Windows version
(NT vs. 2000). I have little experience with remotely managing Oracle on a
Windows platform, but I'm sure someone on the list does it.
I do both platforms, my recommendation is OpenSSH + VNC, they work great, 
they're free, and they're available for both platforms.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Remote DBA

2003-04-02 Thread Nelson, Allan

Well, one of the easiest ways, assuming you are not cursed with a
windows database, is to provide a vpn solution for access to the
servers.  A vpm typically gives you an address on the network you vpn
into.  From this point standard client tools work.  If you are cursed
with windows then you can put a decent telnet server on the windows box,
cygwin I think will work, if you need direct access or use client tools
if you don't.  There are also tools like Damware and VNC to manage
windows servers remotely.  If you have linux or unix then cygwin,
Reflections, Hummingbird, a linux box, an xterm or someother unix
workstation will be all you need.

Allan

-Original Message-
Sent: Wednesday, April 02, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Thanks Goulet,Dennis for the feedback. I have already searched for and
found the same thru google. But could not found and docs/whitepaper link
on this. Suppose we have to do DBAdmin job for our on server remotely
then how we should go about it. Can u or anybody else explain! thanks in
advance.

Best Regards
Ramesh D. Papnoi

-Original Message-
WILLIAMS
Sent: Thursday, April 03, 2003 2:59 AM
To: Multiple recipients of list ORACLE-L


Ramesh
   If you visit the web sites of vendors that provide this type of
service, you may find the white papers you desire. I went to Google and
typed Oracle remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC
Patrol. Then you work together to set some guidelines on what they will
monitor and what action they will take under certain circumstances. In
addition, they can perform "staff augmentation" tasks as you desire. For
example, if your site doesn't have the staff to upgrade to a newer
Oracle version, they can plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate
if any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: [EMAIL PROTECTED]

Fat City N

Re: dbshut script - shutdown or shutdown immediate

From: Jeremiah Wilton <[EMAIL PROTECTED]>
On Wed, 2 Apr 2003, Chris Berry wrote:
> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?
What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!
Well, you have way more experience than me in this subject so do it how you 
like.  I was under the impression that telling the database to drop 
everything was not the best practice, and should only be used when shutdown 
immediate didn't work.  To me it seemed the same as turning off your 
computer with the power button instead of the shutdown command or using kill 
-9, sometimes you have to, but it's not what you do normally.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Remote DBA

2003-04-02 Thread DENNIS WILLIAMS

Ramesh
   My assumption was that you were considering hiring a remote DBA service.
If you are talking about managing your own server remotely, that is a
different issue. 
   For that, the first question is whether the platform of your server is
Unix or Windows. For Unix, pretty much everything is remote anyway. I rarely
need physical access to the server. It matters little whether the server is
in the next room or on the other side of the world. 
   Now, if you are on a Windows platform, it matters which Windows version
(NT vs. 2000). I have little experience with remotely managing Oracle on a
Windows platform, but I'm sure someone on the list does it.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, April 02, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Thanks Goulet,Dennis for the feedback. I have already searched for and found
the same thru google. But could not found and docs/whitepaper link on this.
Suppose we have to do DBAdmin job for our on server remotely then how we
should go about it. Can u or anybody else explain! thanks in advance.

Best Regards
Ramesh D. Papnoi

-Original Message-
WILLIAMS
Sent: Thursday, April 03, 2003 2:59 AM
To: Multiple recipients of list ORACLE-L


Ramesh
   If you visit the web sites of vendors that provide this type of service,
you may find the white papers you desire. I went to Google and typed Oracle
remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC Patrol.
Then you work together to set some guidelines on what they will monitor and
what action they will take under certain circumstances. In addition, they
can perform "staff augmentation" tasks as you desire. For example, if your
site doesn't have the staff to upgrade to a newer Oracle version, they can
plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  Yo

Re: dbshut script - shutdown or shutdown immediate

Agreed. I admit my English needs some improvement. What i wanted to say was about 
rollback but used the words no.of.users. Thanks for pointing out.

GovindanK

Jeremiah Wilton <[EMAIL PROTECTED]> wrote:

>On Wed, 2 Apr 2003, GovindanK wrote:
>
>> Shutdown immediate does rollback and will take time if no.of users
>> is high.
>
>Number of users is not the largest contributing factor to shutdown
>immediate taking a long time.  The longest poles in the tent are large
>transaction rollback and lazy temp segment deallocation.
>
>> On the otherside, shutdown abort simply takes the db down and does
>> not bother about anything else. As per manual, if you do a shutdown
>> abort then you WILL need the online redo logs for recovery just in
>> case.  
>
>Do you know of anyone who does not have their online redologs?  You
>pretty much need them or your database would have crashed a long time
>ago.
>
>> Think twice if your db is in NOARCHIVELOG mode. If your db is in
>> ARCHIVE mode make sure the logs are multiplexed.
>
>As has been pointed out, having multiplexed logs has nothing to do
>with archivelog mode.  Furthermore there is no reason to be more
>careful about using abort if you are in noarchivelog mode.  Crash
>recovery will not need any archived redologs, since it only needs
>those logs since the last checkpoint.
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>-- 
>Author: Jeremiah Wilton

__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76956/onlinere.htm#3981
would be nice reference. 
What i was trying to communicate was this: If the log is not multiplexed and the only 
log member is not avbl for writing then LGWR cannot write and the db instance will go 
down. However, if it is multiplexed then an error will be logged to the alert.log but 
the db will continue to function.  I agree this has nothing to do with the arch/noarch 
mode but one has to have the log files multiplexed to get out of such scenarios. 

HTH

GovindanK
-- 
|XXX|
|You should treat others the way you want to be treated - Mahatma Gandhi|
|XXX|

"Daniel W. Fink" <[EMAIL PROTECTED]> wrote:

>The scenario you describe would occur regardless of the archive mode. An 
>active log cannot be archived. This would require that the ARCH process 
>read the log while LGWR is writing it. Once a log switch occurs 
>(automatic or manual), the previously active log can be archived.
>In this scenario, you cannot perform a complete recovery. You can 
>recover up to the last log that can be read. If the active log cannot be 
>read, the previous log is the end point of your recovery.
>
>-- 
>Daniel W. Fink
>http://www.optimaldba.com
>
>IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
>   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
>   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals
>
>
>GovindanK wrote:
>
>>This topic is getting interesting once more. Lets contribute.
>>
>>  
>>
Multiplexing redo logs has nothing to do with the archive mode.

>>
>>Take a situation wherein the db is in NOARCH mode with only one member per group 
>>(default setup).  The dba gives shutdown abort and upon starting for some reason the 
>>active log could not be read for recovery. How would one perform a complete 
>>recovery?. 
>>
>>Let me know if you have a workaround. 
>>
>>I am willing to learn.
>>
>>GovindanK

__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Remote DBA

2003-04-02 Thread Ramesh Papnoi

Thanks Goulet,Dennis for the feedback. I have already searched for and found
the same thru google. But could not found and docs/whitepaper link on this.
Suppose we have to do DBAdmin job for our on server remotely then how we
should go about it. Can u or anybody else explain! thanks in advance.

Best Regards
Ramesh D. Papnoi

-Original Message-
WILLIAMS
Sent: Thursday, April 03, 2003 2:59 AM
To: Multiple recipients of list ORACLE-L


Ramesh
   If you visit the web sites of vendors that provide this type of service,
you may find the white papers you desire. I went to Google and typed Oracle
remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC Patrol.
Then you work together to set some guidelines on what they will monitor and
what action they will take under certain circumstances. In addition, they
can perform "staff augmentation" tasks as you desire. For example, if your
site doesn't have the staff to upgrade to a newer Oracle version, they can
plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Pardee, Roy E

Well... my official oracle instructor in dba larva school said that it's
tantamount to crashing the db--or so I recall anyway.  This isn't so?

Peace,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, April 02, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L

On Wed, 2 Apr 2003, Chris Berry wrote:

> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?

What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: invalid dbms_shared_pool

2003-04-02 Thread Jesse, Rich

You don't say what version, but I've seen many SYS packages go invalid in
8.1.x on HP/UX, especially after patching or installing a new option/feature
like Oracle Text.  I've found that attempting to revalidate them either by
hand or by running ?/rdbms/admin/utlrp.sql is futile.  One gets fixed and
five others break.  Fix those five and three more break.  Lather.  Rinse.
Repeat.

For better or worse, the only way I've been able to consistently fix this is
to take the brute force approach and rerun the ?/rdbms/admin/whatever.sql
script that created the packages that are now invalid in the order in which
they were originally run when the DB was created.  Depending on which
packages, this may be best left to off-hours.

GL!


Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Wednesday, April 02, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L


In one of our db i found that dbms_shared_pool package body is invalid . Any
idea why that could happen . It's not causing any problem . It's just
appearing as one of invalid objects .
In fact I am able to execute dbms_shared_pool.keep 
with out error . Looks like  specification are intact .
 
there was no package compilation in many days .
 
Only thing i remeber is , we tried to set keep pool 
and i misspelled  keep_pool ,( but does that cause invalidation , i dont buy
it )
 
-ak
 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

On Wed, 2 Apr 2003, GovindanK wrote:

> Shutdown immediate does rollback and will take time if no.of users
> is high.

Number of users is not the largest contributing factor to shutdown
immediate taking a long time.  The longest poles in the tent are large
transaction rollback and lazy temp segment deallocation.

> On the otherside, shutdown abort simply takes the db down and does
> not bother about anything else. As per manual, if you do a shutdown
> abort then you WILL need the online redo logs for recovery just in
> case.  

Do you know of anyone who does not have their online redologs?  You
pretty much need them or your database would have crashed a long time
ago.

> Think twice if your db is in NOARCHIVELOG mode. If your db is in
> ARCHIVE mode make sure the logs are multiplexed.

As has been pointed out, having multiplexed logs has nothing to do
with archivelog mode.  Furthermore there is no reason to be more
careful about using abort if you are in noarchivelog mode.  Crash
recovery will not need any archived redologs, since it only needs
those logs since the last checkpoint.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

On Wed, 2 Apr 2003, Chris Berry wrote:

> Shutdown abort is pretty drastic, are you sure shutdown immediate
> didn't work?

What is drastic about shutdown abort?

Never one to opt out of a shutdown abort thread,
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

- Uses shutdown abort exclusively
- successful shutdowns/startups: over 10,000
- problems with shutdown abort: 0
- versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta)
- still employed!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

On Wed, 2 Apr 2003, Stephen Murphy wrote:

> We replace the simple shutdown command with:
> 
>   shutdown immediate
>   startup restrict
>   alter system switch logfile;
>   host sleep 10
>   shutdown immediate

Why do you do this elaborate dance?  Are you trying to get the last
logfile?  If so, you should know that this combination of commands
will not accomplish that.  Any user with DBA priv can be in the
database doing stuff and making transactions after your switch logfile
and your shutdown immediate.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Remote DBA

One note, these types of service providers tend to specify the number of hours per 
week that they will dedicate to your site.  This normally covers things like normal 
monitoring only.  Anything else is done by the hour or part thereof and it's normally 
EXPENSIVE!  Case in point is a vendor (name to remain anonymous as they almost became 
my employer) that dedicated 10 hours to your site each week, basically 2 hours per day 
which did just cover the monitoring.  Anything else above that was at the hourly rate 
of $300 per hour.  An Oracle upgrade was a normal 40 hour job by the time you included 
planning for, testing the upgrade, and implementation.  Try to fit that into your 
budget, OUCH!!!

Dick Goulet

-Original Message-
Sent: Wednesday, April 02, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L


Ramesh
   If you visit the web sites of vendors that provide this type of service,
you may find the white papers you desire. I went to Google and typed Oracle
remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC Patrol.
Then you work together to set some guidelines on what they will monitor and
what action they will take under certain circumstances. In addition, they
can perform "staff augmentation" tasks as you desire. For example, if your
site doesn't have the staff to upgrade to a newer Oracle version, they can
plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: daily clone

>From TFM:

Specify REUSE to indicate that existing control files identified by the initialization 
parameter CONTROL_FILES can be reused, thus ignoring and overwriting any information 
they may 
currently contain. If you omit this clause and any of these control files 
already exists, Oracle returns an error. 

So it would seem a valid syntax.

Jared






Joan Hsieh <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/02/2003 12:48 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: daily clone


Bill,

Kind of curiosity, I don't know this syntax; I do "create controlfile
set database" or "create controlfile resue database". But never did
reuse set. Is that a valid syntax? I don't have time to check it by
myself. sorry to ask.

Joan

>CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS  NOARCHIVELOG

Niall Litchfield wrote:
> 
> Obviously the usual caveats of 'test this first' and ' don't just listen
> to some bloke off of email' apply but here would be my contributions.
> 
> 1. Don't copy temp - create a new one - it by definition has nothing in
> it.
> 2. Don't copy online redo logs - resetlogs means that a) the old ones
> are useless and the SCN will be reset b) new ones will get created if
> necessary.
> 3. I'm not quite clear what is going on with these read/write-read-only
> nfs files, are these genuinely copied across to a new location, or are
> they the actual datafiles mounted read-only in an nfs environment, or
> are they some sort of weird vendor-provided copy of the datafiles? This
> is probably all my stupidity in not reading you clearly enough.
> 
> Niall
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: 26 March 2003 19:59
> > To: Multiple recipients of list ORACLE-L
> > Subject: daily clone
> >
> >
> >
> > Hello,
> >
> > Env: Oracle 9.2.0.2.0 on Solaris 9 (2 machines)
> >
> > I'm trying to set up a daily cloning process between 2 Oracle
> > instances (SIDA is source, SIDB is target) using the CREATE
> > CONTROLFILE  REUSE SET DATABASE SIDB ... method. The steps are:
> >
> > 1) Shutdown immediate SIDB
> > 2) Shutdown immediate SIDA, startup restrict, shutdown normal
> > 3) Copy system datafile to target machine (I'm going to reset logs,
> >dbs are shutdown, shouldn't require any recovery)
> > 4) Create read-only copy of all user datafiles using a vendor feature
> >called checkpoints (not Oracle checkpoints)
> > 5) Startup SIDA
> > 6) Run the following script on SIDB (adapted from SIDA backup
> > controlfile to trace)
> >
> > STARTUP NOMOUNT PFILE='/oracle_home_path/dbs/initDWQ.ora'
> > CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS  NOARCHIVELOG
> > MAXLOGFILES 5
> > MAXLOGMEMBERS 3
> > MAXDATAFILES 512
> > MAXINSTANCES 1
> > MAXLOGHISTORY 1817
> > LOGFILE
> >   GROUP 1 '/redo1/dws/redo01.log'  SIZE 100M,
> >   GROUP 2 '/redo1/dws/redo02.log'  SIZE 100M,
> >   GROUP 3 '/redo1/dws/redo03.log'  SIZE 100M
> > DATAFILE
> >   '/dwdata1/dwq/sys/system01.dbf',
> >   '/rbs/dws/undotbs01.dbf',
> >   '/data1/dws/users.dbf',
> >   '/data1/dws/tools.dbf',
> >   '/dwdata1.chkpnt/ckpt1/dws/data/lvl1_data/LVL1_DATA01.dbf',
> >   '/dwdata2.chkpnt/ckpt1/dws/index/lvl1_ndex/LVL1_NDEX01.dbf',
> >   '/dwdata1.chkpnt/ckpt1/dws/data/lvl2_data/LVL2_DATA01.dbf',
> >   '/dwdata2.chkpnt/ckpt1/dws/index/lvl2_ndex/LVL2_NDEX01.dbf',
> >...
> > CHARACTER SET WE8ISO8859P1
> > ;
> >
> > ALTER DATABASE OPEN RESETLOGS;
> > ALTER TABLESPACE TEMP ADD TEMPFILE '/oratmp1/dwq/temp01.dbf'
> >  SIZE 2049M REUSE AUTOEXTEND OFF;
> >
> > There are a couple of twists. The datafiles listed with
> > .chkpnt in their path are in a read-only nfs-mounted
> > filesystem; when shutdown before copying, their status within
> > Oracle was READ WRITE.
> >
> > The databases were both shutdown when the copies were made,
> > SIDB is using RESETLOGS, so I'm thinking this will work OK
> > and Oracle will not try and write anything to these when
> > opening SIDB.
> >
> > Does this sound OK?
> >
> > The next question is, do I need to copy any redo logs, undo
> > tblspc (using auto undo), or temp datafiles from SIDA to
> > SIDB? Again, since I'm shutting
> > down cleanly, and doing a resetlogs on opening, I am hoping
> > that I can simply reuse the existing redo logs, undo tblspc
> > and tempfile.
> >
> > The next twist is that we want to preserve some read write
> > tablespaces in SIDB, like users.dbf and tools.dbf listed
> > above, and not wipe them out when re-creating the controlfile
> > each day. Again, since we shut down SIDB cleanly, and I list
> > the existing datafiles under the datafile section of the
> > CREATE CONTROLFILE command, I am hoping this will preserve
> > their contents. Am I wrong?
> >
> > We will be testing these scenarios, but I am hoping for some
> > insightful advice from others who have gone before.
> >
>

RE: Remote DBA

2003-04-02 Thread DENNIS WILLIAMS

Ramesh
   If you visit the web sites of vendors that provide this type of service,
you may find the white papers you desire. I went to Google and typed Oracle
remote dba and found a lot of sites.
   In general terms, these companies work by first getting to know your
site, having one of their employees come to your site for a week or two.
Then they require you to install some monitoring software like BMC Patrol.
Then you work together to set some guidelines on what they will monitor and
what action they will take under certain circumstances. In addition, they
can perform "staff augmentation" tasks as you desire. For example, if your
site doesn't have the staff to upgrade to a newer Oracle version, they can
plan that task and perform the upgrade.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, April 02, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L


Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

Thanks Dan, I've found myself defending that position from time to time.

Jared






"Daniel W. Fink" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/02/2003 11:20 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: dbshut script - shutdown or shutdown immediate


Multiplexing redo logs has nothing to do with the archive mode. Logs are 
multiplexed so that an error writing to one of the members in a group does 
not cause the instance to terminate. 

Myth - If you use disk mirroring, you don't need to multiplex your redo 
logs.
Reality - Mirroring only protects from hardware failure. It will not 
protect you from accidental deletion of the log (been there, had to fix 
it!).
-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

GovindanK wrote:
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
work?
 

Well said. This topic has been circulating in many DBA forums for a long 
time. Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes the db down and 
does not bother about anything else. As per manual, if you do a shutdown 
abort then you WILL need the online redo logs for recovery just in case.
Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE 
mode make sure the logs are multiplexed.  Though Oracle's recovery seems
to be sturdy, double check your backup & recovery strategies. Also, which 
option to use is influenced by how much downtime/shutdown time you can 
afford.

HTH

GovindanK
 





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

> > >"Schauss, Peter" wrote:
> > > I have one Oracle instance which supports an application
> > > server which always maintains a database connection.
> > > The UNIX system administrator tells me that this instance always
> > > hangs when she tries to shut down the system.  The other instances,
> > > which do not support a 24x7 process shut down properly.
> > >
> > > Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to 
sqlplus
> > > is
> > > connect internal
> > > shutdown
> > >
> > > Should I modify the script to "shutdown immediate" so that it kills
> > > any connections?
> > >
> > > Environment is Oracle 8.1.7 /AIX 4.3.3.
> >From: Joan Hsieh <[EMAIL PROTECTED]>
> >Peter,
> >I modified to shutdown abort, starup then shutdown immediate.
>
> Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
> work?

From: Joan Hsieh <[EMAIL PROTECTED]>
At first, we do shutdown immediate, then startup. But we do have couple
times hang there and couldn't do the cold backup. Since changed to
shutdown abort, startup and shutdown immediate, we don't have any
problem at all. our database is in archive mode. Since our production
database has to refresh to reporting database nightly. I couldn't do
checkpoint before shutdown abort. (some error, forgot on reporting
database) otherwise, I will add to it.
If it's hanging on the startup I recommend trying this:

shutdown immediate
startup nomount
alter database mount
alter database open
You should get an error message at one of those steps that will lead you to 
the real problem.

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM jobs on Win2K

2003-04-02 Thread Mandar A. Ghosalkar

When a OEM export job is created, the agent on the database server runs the exp 
utility through a tcl script.

same for rman. on the database server you should find a rman.tcl file.

after executing the export job i run the following tcl commands through the same oem 
export job.
file rename -force f:/oracle/admin/btps/exp/btps_bt_rows.dmp 
f:/oracle/admin/btps/exp/btps_bt_rows_[clock format [clock seconds] -format %a].dmp
file rename -force f:/oracle/admin/btps/exp/btps_bt_rows.log 
f:/oracle/admin/btps/exp/btps_bt_rows_[clock format [clock seconds] -format %a].log

this is required because i cannot specify a time format in the export file name 
parameter.

HTH
Mandar

> -Original Message-
> From: Paul Baumgartel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OEM jobs on Win2K
> 
> 
> Hi all.  I've just entered the world of Oracle on Windows.  My first
> question regards the mechanism used to run jobs that are created using
> OEM.How does OEM execute RMAN, or export, for example?  
> 
> Thanks
> 
> Paul Baumgartel
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mandar A. Ghosalkar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

invalid dbms_shared_pool

2003-04-02 Thread AK




In one of our db i found that dbms_shared_pool 
package body is invalid . Any idea why that could happen . It's not causing any 
problem . It's just appearing as one of invalid objects .
In fact I am able to execute dbms_shared_pool.keep 

with out error . Looks like  
specification are intact .
 
there was no package compilation in many days 
.

 
Only thing i remeber is , we tried to set keep pool 

and i misspelled  keep_pool ,( but does that 
cause invalidation , i dont buy it )
 
-ak

Re: dbshut script - shutdown or shutdown immediate





The scenario you describe would occur regardless of the archive mode. An
active log cannot be archived. This would require that the ARCH process read
the log while LGWR is writing it. Once a log switch occurs (automatic or
manual), the previously active log can be archived.
In this scenario, you cannot perform a complete recovery. You can recover
up to the last log that can be read. If the active log cannot be read, the
previous log is the end point of your recovery.
-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

GovindanK wrote:

  This topic is getting interesting once more. Lets contribute.

  
  

  Multiplexing redo logs has nothing to do with the archive mode.
  

  
  
Take a situation wherein the db is in NOARCH mode with only one member per group (default setup).  The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. 

Let me know if you have a workaround. 

I am willing to learn.

GovindanK

RE: Oh Dear, Mr. Ellison's at it again

Let's see, there have been a couple of Oracle employees running around on the list 
before.  Wonder if their still there??  Maybe they might just forward this thread to 
the big man himself!!

Naw, miracles can't happen!!

Dick Goulet

-Original Message-
Sent: Wednesday, April 02, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


 I thought the same thing. Being the hubristic person that he is I doubt he will 
ever think about it himself...

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oh Dear, Mr. Ellison's at it again
> 
> 
> Wonder if anyone has clued him into MySql and PostGreSql yet!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> -- 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Upgrade from Oracle 10.7 char to 11.5.8 HP-UX11.00

2003-04-02 Thread M Rafiq

Rob,

Here we don't want to use SP mode. We are planning to migrate database and 
upgrade 10.7 application to 11.5.8 in one go. What is in my mind after 
having couple of responses that

1)create test environment on a separate machine with 10.7 application and 
7.3.4.5 database. Just purge un needed data and correct storage param or 
increase sizes of tablespaces as per requirement.

2) Install 8.1.7.4 software and migrate database from 7.3.4.5 to 8.1.7.4(No 
I/O patches applied)

3)Install 11.5.8 application

4)Upgrade 10.7 application to 11.5.8

5)Apply any other mini/other patches.

6)Pass on to user for testing after checking env param etc.

I would like comments on this approach or experiences if anyone used that 
approach.

I am still waiting response/comments from Chad Nester and Khurush...

Regards
Rafiq






Reply-To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
Date: Tue, 01 Apr 2003 20:18:57 -0500
Getting from 7.x to 8.1.7 for Apps 10.7 is a fairly well documented and
safe process.  The most difficult part might be finding to software
versions you need to be in 10.7 SP mode if you choose to upgrade the
RDBMS as a separate project before you migrate the Apps to 11i.  The 8i
migration utilities do most of the dirty work and do it well.  We used
ODMA for 10.7SC/SP and did it a few times before the production upgrade
over a year ago.
Rob Quiles

M Rafiq wrote:
>
> Pat
>
> Thanks..
>
> 4) Export from Oracle7 import into Oracle8i
>
> We cannot export because of size of database but to copy and migrate to
> 8.1.7? Have you tried this path or have any experience good or bad?
>
> Regards
> Rafiq
>
> From: "Turner, Patricia" <[EMAIL PROTECTED]>
> Reply-To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
> To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
> Date: Tue, 1 Apr 2003 17:16:23 -0500
>
> In a very compressed nutshell I did this:
>
> 1) Created a test 10.7 environment
> 2) Perform pre upgrade step (prepares Oracle 7 database)
> 3) Install new 11i software and create new Oracle8i instance
> 4) Export from Oracle7 import into Oracle8i
> 5) Upgrade using adaimgr
> 6) Install patches
>
> Be sure to keep track of every error and every step and every patch and
> every configuration and every profile, otherwise you will not get
> reproducible results.  Documentation, project management and testing is
> critical to success.  Read and reread all 11i upgrade documentation,
> installation guides, release notes and so BEFORE you begin.
>
> -Original Message-
> From: M Rafiq [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 4:56 PM
> To: OAUGNetDBA Listserv
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
>
> Pat,
>
> Thanks for reponse.
>
> "You also have the option of lumping both phases into one big step, 
thereby
> skipping the IO patches all together.  This was the strategy we used."
>
> Can you please explain your strategy for this? If you have any work paper 
,
> I shall appreciate to share with(if possible)...
>
> Regards
> Rafiq
>
> From: "Turner, Patricia" <[EMAIL PROTECTED]>
> Reply-To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
> To: "OAUGNetDBA Listserv" <[EMAIL PROTECTED]>
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
> Date: Tue, 1 Apr 2003 16:21:57 -0500
>
> Upgrading the database from Oracle7 to Oracle8i is optional if you want 
to
> break up the project into two big chunks:
>
> Phase 1) Upgrade database and install IO patches
> Phase 2) Upgrade apps to 11i
>
> You also have the option of lumping both phases into one big step, 
thereby
> skipping the IO patches all together.  This was the strategy we used.
>
> -Original Message-
> From: Lynne Ly [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 1:53 PM
> To: OAUGNetDBA Listserv
> Subject: [OAUGNetDBA]-Re: Upgrade from Oracle 10.7 char to 11.5.8 HP-UX
> 11.00
>
> We are on our third pilot testing from 10.7 character
> to 11.5.8.
>
> We had to upgrade to 8.1.6 a year ago so that we can
> upgrade to 11i. I don't think you can upgrade straight
> from 7.3.4 database without upgrading to 8i first.
> (you may want to check mettalink)
>
> When we upgradd to 8.1.6 we had to apply a lot of
> interopterability patches.  We then upgraded to
> 8.1.7.3 a few months ago.
>
> Once we were on 8.1.7.3 and 8k blocksize we followed
> the release notes and upgrade manual.  11.5.8 is not
> too bad, a lot problems that we encountered in 11.5.7
> was fixed in 11.5.8.  We started our first upgrade n
> 11.5.7.
>
> We are going live in a couple of months.
>
> Hope this helps.
>
> --- M Rafiq <[EMAIL PROTECTED]> wrote:
>   >
>   > Hello Gurus
>   >
>   > We are in process of planning to upgrade our
>   > existing Oracle Financials 10.7
>   > Character Applications  to 11i( ver 11.5.8)
>   >
>   > Existing env
>   >
>   > HP-UX 11.00 32bits
>   > Oracle Financ

Re: daily clone

2003-04-02 Thread Joan Hsieh

Bill,

Kind of curiosity, I don't know this syntax; I do "create controlfile
set database" or "create controlfile resue database". But never did
reuse set. Is that a valid syntax? I don't have time to check it by
myself. sorry to ask.

Joan

>CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS  NOARCHIVELOG

Niall Litchfield wrote:
> 
> Obviously the usual caveats of 'test this first' and ' don't just listen
> to some bloke off of email' apply but here would be my contributions.
> 
> 1. Don't copy temp - create a new one - it by definition has nothing in
> it.
> 2. Don't copy online redo logs - resetlogs means that a) the old ones
> are useless and the SCN will be reset b) new ones will get created if
> necessary.
> 3. I'm not quite clear what is going on with these read/write-read-only
> nfs files, are these genuinely copied across to a new location, or are
> they the actual datafiles mounted read-only in an nfs environment, or
> are they some sort of weird vendor-provided copy of the datafiles? This
> is probably all my stupidity in not reading you clearly enough.
> 
> Niall
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: 26 March 2003 19:59
> > To: Multiple recipients of list ORACLE-L
> > Subject: daily clone
> >
> >
> >
> > Hello,
> >
> > Env: Oracle 9.2.0.2.0 on Solaris 9 (2 machines)
> >
> > I'm trying to set up a daily cloning process between 2 Oracle
> > instances (SIDA is source, SIDB is target) using the CREATE
> > CONTROLFILE  REUSE SET DATABASE SIDB ... method. The steps are:
> >
> > 1) Shutdown immediate SIDB
> > 2) Shutdown immediate SIDA, startup restrict, shutdown normal
> > 3) Copy system datafile to target machine (I'm going to reset logs,
> >dbs are shutdown, shouldn't require any recovery)
> > 4) Create read-only copy of all user datafiles using a vendor feature
> >called checkpoints (not Oracle checkpoints)
> > 5) Startup SIDA
> > 6) Run the following script on SIDB (adapted from SIDA backup
> > controlfile to trace)
> >
> > STARTUP NOMOUNT PFILE='/oracle_home_path/dbs/initDWQ.ora'
> > CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS  NOARCHIVELOG
> > MAXLOGFILES 5
> > MAXLOGMEMBERS 3
> > MAXDATAFILES 512
> > MAXINSTANCES 1
> > MAXLOGHISTORY 1817
> > LOGFILE
> >   GROUP 1 '/redo1/dws/redo01.log'  SIZE 100M,
> >   GROUP 2 '/redo1/dws/redo02.log'  SIZE 100M,
> >   GROUP 3 '/redo1/dws/redo03.log'  SIZE 100M
> > DATAFILE
> >   '/dwdata1/dwq/sys/system01.dbf',
> >   '/rbs/dws/undotbs01.dbf',
> >   '/data1/dws/users.dbf',
> >   '/data1/dws/tools.dbf',
> >   '/dwdata1.chkpnt/ckpt1/dws/data/lvl1_data/LVL1_DATA01.dbf',
> >   '/dwdata2.chkpnt/ckpt1/dws/index/lvl1_ndex/LVL1_NDEX01.dbf',
> >   '/dwdata1.chkpnt/ckpt1/dws/data/lvl2_data/LVL2_DATA01.dbf',
> >   '/dwdata2.chkpnt/ckpt1/dws/index/lvl2_ndex/LVL2_NDEX01.dbf',
> >...
> > CHARACTER SET WE8ISO8859P1
> > ;
> >
> > ALTER DATABASE OPEN RESETLOGS;
> > ALTER TABLESPACE TEMP ADD TEMPFILE '/oratmp1/dwq/temp01.dbf'
> >  SIZE 2049M REUSE AUTOEXTEND OFF;
> >
> > There are a couple of twists. The datafiles listed with
> > .chkpnt in their path are in a read-only nfs-mounted
> > filesystem; when shutdown before copying, their status within
> > Oracle was READ WRITE.
> >
> > The databases were both shutdown when the copies were made,
> > SIDB is using RESETLOGS, so I'm thinking this will work OK
> > and Oracle will not try and write anything to these when
> > opening SIDB.
> >
> > Does this sound OK?
> >
> > The next question is, do I need to copy any redo logs, undo
> > tblspc (using auto undo), or temp datafiles from SIDA to
> > SIDB? Again, since I'm shutting
> > down cleanly, and doing a resetlogs on opening, I am hoping
> > that I can simply reuse the existing redo logs, undo tblspc
> > and tempfile.
> >
> > The next twist is that we want to preserve some read write
> > tablespaces in SIDB, like users.dbf and tools.dbf listed
> > above, and not wipe them out when re-creating the controlfile
> > each day. Again, since we shut down SIDB cleanly, and I list
> > the existing datafiles under the datafile section of the
> > CREATE CONTROLFILE command, I am hoping this will preserve
> > their contents. Am I wrong?
> >
> > We will be testing these scenarios, but I am hoping for some
> > insightful advice from others who have gone before.
> >
> > Sorry for the lengthy message, and as always, thanks to any
> > responders. Bill
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> > and in the message BODY, inclu

RE: how to find INDEX CORRUPTION ???

2003-04-02 Thread M Rafiq

Drop the index and recreate it without parallel clause. If your table is 
having degree > 1 , then make it 1 and then recreate index. It looks a old 
bug for bitmap index on a table having degree > 1.

Regards
Rafiq






Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 02 Apr 2003 06:28:53 -0800
analyze table MSG_HISTORY validate structure cascade;

If there is a problem with the table or any indexes, you should receive an 
error message. Rebuild that object.

Validating the structure of the table locks it up so don't do this while 
anyone is using the table especially if it's a large table with a lot of 
indexes.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
> -Original Message-
> From:	Prem Khanna J [SMTP:[EMAIL PROTECTED]
>
> Guys,
>
> I faced this error in an instsance of 8.1.6/win2k.
>
> Errors in file E:\ORACLE\ADMIN\ORA816\UDUMP\ORA00696.TRC:
> ORA-00600: Internal Error 
:[13013],[5001],[22211],[134225362],[15],[134225362],
> [1],[]
>
> but this morning i dropped an existing index ( on 3 columns together ).
> and created a bitmap index on FROMMEMNO ( a column in MSG_HISTORY table 
).
> when i delete a row from MSG_HISTORY table now , i get this ORA 600 
error.
>
> if i drop the index , DELETE works fine .
> if i create a index , it results in ORA 600.
>
> metalink says that it might be because of ondex corruption.
> how do i find index corruption ?
> does it mean that even a new index on this particular column will be a 
corrupted
> index ?
>
> Help me guys.
>
> TIA.
> Jp.
>

_
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

What does this have to do with archivelog mode?  In the bizarre
scenario in which you lose a log between the time you shut down and
started up, you are screwed with or without archivelog mode.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 2 Apr 2003, GovindanK wrote:

> This topic is getting interesting once more. Lets contribute.
> 
> >>Multiplexing redo logs has nothing to do with the archive mode.
> 
> Take a situation wherein the db is in NOARCH mode with only one member per group 
> (default setup).  The dba gives shutdown abort and upon starting for some reason the 
> active log could not be read for recovery. How would one perform a complete 
> recovery?. 
> 
> Let me know if you have a workaround. 
> 
> I am willing to learn.
> 
> GovindanK
> 
> -- 
> |XXX|
> |You should treat others the way you want to be treated - Mahatma Gandhi|
> |XXX|
> 
> 
> "Daniel W. Fink" <[EMAIL PROTECTED]> wrote:
> 
> >Multiplexing redo logs has nothing to do with the archive mode. Logs are 
> >multiplexed so that an error writing to one of the members in a group 
> >does not cause the instance to terminate.
> >
> >Myth - If you use disk mirroring, you don't need to multiplex your redo 
> >logs.
> >Reality - Mirroring only protects from hardware failure. It will not 
> >protect you from accidental deletion of the log (been there, had to fix 
> >it!).
> >
> >-- 
> >Daniel W. Fink
> >http://www.optimaldba.com
> >
> >GovindanK wrote:
> >
> >>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
> >>>work?
> >>>    
> >>>
> >>
> >>Well said. This topic has been circulating in many DBA forums for a long time. 
> >>Shutdown immediate does rollback and will take time if no.of users
> >>is high. On the otherside, shutdown abort simply takes the db down and 
> >>does not bother about anything else. As per manual, if you do a shutdown abort 
> >>then you WILL need the online redo logs for recovery just in case.
> >>Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make 
> >>sure the logs are multiplexed.  Though Oracle's recovery seems
> >>to be sturdy, double check your backup & recovery strategies. Also, which option 
> >>to use is influenced by how much downtime/shutdown time you can afford.
> >>
> >>HTH
> >>
> >>GovindanK
> >>  
> 
> 
> __
> Try AOL and get 1045 hours FREE for 45 days!
> http://free.aol.com/tryaolfree/index.adp?375380
> 
> Get AOL Instant Messenger 5.1 for FREE! Download Now!
> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: GovindanK
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Remote DBA

2003-04-02 Thread Ramesh Papnoi

Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]

TIA

Best Regards
Ramesh D. Papnoi

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ramesh Papnoi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RMAN question.... (figured out if anywone is interested)....w

2003-04-02 Thread DENNIS WILLIAMS

Chris - Congratulations on finding your problem. I have the RMAN log file
emailed to me for each backup. This means more to look through. What you
describe doesn't sound hard though.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, April 02, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L



Apparently the command: 

backup database format '/oracle_backup/ASTU/%U' 
(current controlfile); 

..places the controlfile in $ORACLE_HOME/dbs, but: 

backup database format '/oracle_backup/ASTU/%U' include current controlfile;


..places the contrlofile in the specified directory along with all
other backup pieces. 

Thanks for all input. 

Chris 

And now for the next step... 

.anyone have a script handy to query the catalog directly and validate
all backups ran successfully and send the info of success/failure in an
email?

.Thanks! 



-Original Message- 
 ] 
Sent: Tuesday, April 01, 2003 8:29 AM 
To: Multiple recipients of list ORACLE-L 

Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking 
too slow. I checked my systems and I see the snapcf_SID.f files, one for 
each database being backed up. I do not see the other files you mention. I 
notice the mystery file names have a format quite close to your backup 
format. I also notice the dates on the mystery files are today's date, so 
something must have written to them. Did the size change as well? Is there 
any possibility that another backup script is running? Maybe a cron job from

another userid. Have you verified that your RMAN backup files are getting 
created in the expected location? You could also check the catalog for 
additional backups. And just to be sure, you might connect to the target 
database alone and check for backups. A record of recent backups are stored 
in the controlfile even if you are using a catalog. 
  
Glad you are enjoying Lawson's book. 



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message- 
Sent: Tuesday, April 01, 2003 7:24 AM 
To: Multiple recipients of list ORACLE-L 



Dennis, 
I wasn't actually restoring the control file.  Only 'validating' that RMAN 
could do it.  I also backup the control file several other ways and would 
likely never ask RMAN to perform that function.  The only reason I issued 
'restore controlfile validate' was because it would help me figure out what 
those mystery files are for.  I just checked the directory and there are 3 
more files with similar names corresponding to the 3 databases we back up on

that machine.  I need to talk to the other DBA and find out if he has been 
manually deleting them because I haven't noticed this and we have been using

RMAN for over a month now. 

In addition, I don't believe these are the snapshot control files as there 
are 3 other files in $ORACLE_HOME/dbs named: 

-rw-r-   1 oracle dba41213952 Apr  1 00:35 snapcf_ASTU.f 
-rw-r-   1 oracle dba14376960 Apr  1 00:08 snapcf_PRD1.f 
-rw-r-   1 oracle dba16281600 Apr  1 00:36 snapcf_PRD2.f 

The files in question are: 

-rw-r-   1 oracle dba16290816 Apr  1 00:36 26eje5g8_1_1 
-rw-r-   1 oracle dba14394368 Apr  1 00:08 28eje3r5_1_1 
-rw-r-   1 oracle dba41231360 Apr  1 00:35 2seje5e5_1_1 

They seem to have corresponding file sizes.  I just don't see what statement

in my simple little scripts would cause the files to be written there. 

Again here is the backup script I use: 


#!/bin/sh 
export ORACLE_HOME=/u01/app/oracle/product/8.1.7 
export ORACLE_SID=ASTU 
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ 

rm /oracle_backup/$ORACLE_SID/* 
$ORACLE_HOME/bin/rman   
-- 
Author: DENNIS WILLIAMS 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  
San Diego, California-- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a li

RE: Oh Dear, Mr. Ellison's at it again

2003-04-02 Thread Gogala, Mladen

You mean that MySQL and Postgres will wipe out Microsoft? :)

-Original Message-
Sent: Wednesday, April 02, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L


Ellison: Linux Will Wipe Microsoft Out Of The Data Center

In dramatic terms, Oracle Corp. Chairman and CEO Larry Ellison
predicted the open-source operating system will wipe Microsoft "off the
face of the earth" in the battle for the data center market.

http://computerworld.com/newsletter/0%2C4902%2C79951%2C0.html?nlid=AM


Wonder if anyone has clued him into MySql and PostGreSql yet!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oh Dear, Mr. Ellison's at it again

2003-04-02 Thread Weaver, Walt

 I thought the same thing. Being the hubristic person that he is I doubt he will 
ever think about it himself...

--Walt Weaver
  Bozeman, Montana

> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oh Dear, Mr. Ellison's at it again
> 
> 
> Wonder if anyone has clued him into MySql and PostGreSql yet!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA 
> -- 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OEM jobs on Win2K

2003-04-02 Thread Paul Baumgartel

Hi all.  I've just entered the world of Oracle on Windows.  My first
question regards the mechanism used to run jobs that are created using
OEM.How does OEM execute RMAN, or export, for example?  

Thanks

Paul Baumgartel


__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Whose function is executing.

2003-04-02 Thread Reginald . W . Bailey


Try using PL/SQL tracing , available in Oracle8i and Oracle9i.
DBMS_TRACE.SET_PLSQL_TRACE (trace_level INTEGER).

RWB


Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

This topic is getting interesting once more. Lets contribute.

>>Multiplexing redo logs has nothing to do with the archive mode.

Take a situation wherein the db is in NOARCH mode with only one member per group 
(default setup).  The dba gives shutdown abort and upon starting for some reason the 
active log could not be read for recovery. How would one perform a complete recovery?. 

Let me know if you have a workaround. 

I am willing to learn.

GovindanK

-- 
|XXX|
|You should treat others the way you want to be treated - Mahatma Gandhi|
|XXX|

"Daniel W. Fink" <[EMAIL PROTECTED]> wrote:

>Multiplexing redo logs has nothing to do with the archive mode. Logs are 
>multiplexed so that an error writing to one of the members in a group 
>does not cause the instance to terminate.
>
>Myth - If you use disk mirroring, you don't need to multiplex your redo 
>logs.
>Reality - Mirroring only protects from hardware failure. It will not 
>protect you from accidental deletion of the log (been there, had to fix 
>it!).
>
>-- 
>Daniel W. Fink
>http://www.optimaldba.com
>
>GovindanK wrote:
>
>>>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
>>>work?
>>>    
>>>
>>
>>Well said. This topic has been circulating in many DBA forums for a long time. 
>>Shutdown immediate does rollback and will take time if no.of users
>>is high. On the otherside, shutdown abort simply takes the db down and 
>>does not bother about anything else. As per manual, if you do a shutdown abort then 
>>you WILL need the online redo logs for recovery just in case.
>>Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make 
>>sure the logs are multiplexed.  Though Oracle's recovery seems
>>to be sturdy, double check your backup & recovery strategies. Also, which option to 
>>use is influenced by how much downtime/shutdown time you can afford.
>>
>>HTH
>>
>>GovindanK
>>  

__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Lies, damn lies and statistics

2003-04-02 Thread Karen Morton

Thanks Stephane (1000 pardons on the earlier spelling FO-PAH!).

-Original Message-
Faroult
Sent: Wednesday, April 02, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L

Karen Morton wrote:
>
> Stephanie,

Cough, cough.

> I've ran into the exact same thing that statistics don't always tell the
> real story and that the bottom-line has to be elapsed time.
>
> I am curious however as to how you wrote the best performing (fastest)
> query.  I have a client who uses the exact same structure and methodology
> you mention (innate tree structure, views with outer joins, etc) and they
> have some pretty long and nasty queries (I see your 176 step execution
plan
> and raise you to 298!).  I've had pretty decent success re-writing these
> monsters but would be interested in hearing your different approaches to
> re-writing such queries to see if I can pick up a few ideas I hadn't
thought
> of.  Any generic ideas or methods you use might prove helpful to many.
>
> Thanks,
> Karen
>
> Karen Morton
> Morton Consulting
> [EMAIL PROTECTED]
>

Karen,

  The only effective method I know is to take an axe and cut everything
which is not strictly necessary. More often than not, when you replace a
view by its query, you realize that you only need some of the columns of
the view, and that some (possibly not fantastically efficient) joins in
the view can be happily disposed of. You also find useless joins outside
of views.
In the query mentioned above, the hard-core was a
   start with a_id in
 (select a.a_id
  from a, b, c, d
  where b.a_id = a.a_id
and 
and c.b_id = b.b_id
and 
and d.c_id = c.c_id
and 
  union
  select a.a_id
  from a, b, e, f
  where b.a_id = a.a_id
and 
and e.b_id = b.b_id
and 
and f.e_id = e.e_id
and 
  union
  ...)

Why joining on a, since the primary key of a (which is what we want) can
be found as foreign key in b? Why repeat the condition on b in the
second part of the union ? And so on.
Once everything was reduced to something I could grasp and constituent
pieces, it was far easier to twitch the code here and there and get
decent results.
'Far easier' is of course a way of speaking. I would be glad if there
were recipes. I usually start with something twice as bad as the
original query, which a bit of additional tuning takes to about ten
times slower than what you want to improve. At which point, about 2
hours after having started, I am beginning to get a better feeling of
the data, take another cup of coffee (and possibly another one), scrap
everything I have done so far and get some results. Another example
today (3rd of my 4 customers this week) where, starting with 170,000 or
about LIOs I have managed after much effort to peak at 500,000 before
reaching the finish line at 2,000. Phew, reputation saved, but it was
hot.

HTH,

Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karen Morton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why dbms_output is not working

2003-04-02 Thread Andreas . Haunschmidt

try dbms_output.put_line('hello');

or 
  dbms_output.put_line('') after
  dbms_output.put('hello'); 

HTH
   Andreas

-Original Message-
Sent: Wednesday, April 02, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L


I have a very simple code: 

begin 
dbms_output.enable(1000); 
dbms_output.put('hello'); 
end; 

but the dbms_output is not sending the output to the
screen. I've already stablished set serveroutput on
and also used set serverout on 
and still not working, this is a very frequent
situation and suddenly it displays everything stored,
why is this happening? Is there some buffer that I
have to flush with a command? Do I miss something? 

TIA 
Gabriel Aragon 

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why dbms_output is not working

2003-04-02 Thread Jamadagni, Rajendra

Title: Re: Why dbms_output is not working

You 
need put_line ... simple put() won't work as the line is not complete. At-least 
add dbms_output.new_line;

Raj

Rajendra dot Jamadagni at nospamespn 
dot com All Views expressed in 
this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

  At 10:55 AM 4/2/2003 -0800, you wrote: >I have a very simple code: > 
  >begin >dbms_output.enable(1000); >dbms_output.put('hello'); >end; 
  > >but the dbms_output is not 
  sending the output to the >screen. I've already 
  stablished set serveroutput on >and also used set 
  serverout on >and still not working, this is a very 
  frequent >situation and suddenly it displays 
  everything stored, >why is this happening? Is there 
  some buffer that I >have to flush with a command? 
  Do I miss something? > >TIA >Gabriel Aragon > >__ >Do you Yahoo!? >Yahoo! Tax Center - File 
  online, calculators, forms, and more >http://tax.yahoo.com 
  >-- >Please see the official 
  ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Gabriel Aragon 
  >   INET: [EMAIL PROTECTED] > >Fat City Network 
  Services    -- 858-538-5051 http://www.fatcity.com >San Diego, California    -- 
  Mailing list and web hosting services >- 
  >To REMOVE yourself from this mailing list, send an E-Mail 
  message >to: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and in >the message BODY, 
  include a line containing: UNSUB ORACLE-L >(or the 
  name of mailing list you want to be removed from).  You may 
  >also send the HELP command for other information (like 
  subscribing). 
  Wolfgang Breitling Centrex Consulting 
  Corporation http://www.centrexcc.com 

  This email communication is intended as a private 
  communication for the sole use of the primary addressee and those individuals 
  listed for copies in the original message. The information contained in this 
  email is private and confidential and if you are not an intended recipient you 
  are hereby notified that copying, forwarding or other dissemination or 
  distribution of this communication by any means is prohibited.  If you 
  are not specifically authorized to receive this email and if you believe that 
  you received it in error please notify the original sender immediately.  
  We honour similar requests relating to the privacy of email 
  communications.
  Cette communication par courrier électronique est une 
  communication privée à l'usage exclusif du destinataire principal ainsi que 
  des personnes dont les noms figurent en copie.  Les renseignements 
  contenus dans ce courriel sont confidentiels et si vous n'êtes pas le 
  destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, 
  tout transfert ou toute autre forme de diffusion de cette communication par 
  quelque moyen que ce soit est interdit.  Si vous n'êtes pas 
  spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu 
  par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous 
  respectons les demandes similaires qui touchent la confidentialité des 
  communications par courrier électronique.
This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

RE: Oh Dear, Mr. Ellison's at it again

Title: RE: Oh Dear, Mr. Ellison's at it again



Jeremy,
 
    True, you should watch what you wish for because it may 
well come true!!
 
    RIP Oracle???
 
Dick 
Goulet

  -Original Message-From: Jeremy Pulcifer 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003 
  2:14 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oh Dear, Mr. Ellison's at it again
  > -Original Message- > 
  From: Goulet, Dick [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 02, 2003 10:45 AM > To: Multiple recipients of list ORACLE-L > Subject: Oh Dear, Mr. Ellison's at it again > > > Ellison: 
  Linux Will Wipe Microsoft Out Of The Data Center > 
  > In dramatic terms, Oracle Corp. Chairman and CEO 
  Larry > Ellison predicted the open-source operating 
  system will wipe > Microsoft "off the face of the 
  earth" in the battle for the > data center 
  market. > > Wonder if 
  anyone has clued him into MySql and PostGreSql yet!! 
  Um, as he was talking about Linux, I suppose that MySQL and 
  PostGres would actually bolster his claim. Perhaps to his own detriment, 
  though...
  However, I liked this... Quoting 
  Larry, who is quoted in the ComputerWorld article mentioned: 
  "The computer industry is finally moving from a cottage 
  industry to an industrial industry. We're moving at breakneck pace toward the 
  19th century," he quipped.
  Gotta say, that's pretty funny.

Re: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Joan Hsieh

At first, we do shutdown immediate, then startup. But we do have couple
times hang there and couldn't do the cold backup. Since changed to
shutdown abort, startup and shutdown immediate, we don't have any
problem at all. our database is in archive mode. Since our production
database has to refresh to reporting database nightly. I couldn't do
checkpoint before shutdown abort. (some error, forgot on reporting
database) otherwise, I will add to it.

Joan

Chris Berry wrote:
> 
> > >"Schauss, Peter" wrote:
> > > I have one Oracle instance which supports an application
> > > server which always maintains a database connection.
> > > The UNIX system administrator tells me that this instance always
> > > hangs when she tries to shut down the system.  The other instances,
> > > which do not support a 24x7 process shut down properly.
> > >
> > > Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
> > > is
> > > connect internal
> > > shutdown
> > >
> > > Should I modify the script to "shutdown immediate" so that it kills
> > > any connections?
> > >
> > > Environment is Oracle 8.1.7 /AIX 4.3.3.
> >From: Joan Hsieh <[EMAIL PROTECTED]>
> >Peter,
> >I modified to shutdown abort, starup then shutdown immediate.
> 
> Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
> work?
> 
> Chris Berry
> [EMAIL PROTECTED]
> Systems Administrator
> JM Associates
> 
> "Without change, something sleeps inside us, and seldom awakens.  The
> sleeper must awaken." -- Duke Leto Atreides
> 
> _
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Berry
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Why dbms_output is not working

Title: RE: Why dbms_output is not working





Don't know what to tell you. I don't remember ever seeing output disappear if you use dbms_output.put_line.
Of course you have to remember to say
set serveroutput on size N
where N is the number of bytes that will be output
and if you are doing this in SQL*Plus you need to reissue the "set serveroutput" statement after each connect. Could that be the problem? You connected to a different database and then the output was no longer displayed?

> -Original Message-
> From: Gabriel Aragon [mailto:[EMAIL PROTECTED]]
> 
> Nope, I've already did it, first using put and then
> put_line, and sometimes I can see the output like you
> did, but sometimes I use de put_line without a
> previous put and it doesn't work! This is nonsense!
> 
> I also use the dbms_output.enable(somevalue) with the
> same frustrating result. Any other idea? I dont wnt to
> write the code to send the output to a file. 
> 
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> > You need a dbms_output.put_line to "complete" the
> > output line.
> > e.g.
> > SQL> set serveroutput on
> > SQL> begin
> >   2 dbms_output.put ('Hello') ;
> >   3  end ;
> >   4  /
> > Procedure PL/SQL terminee avec succes.
> > 
> > SQL> begin
> >   2    dbms_output.put_line ('Bonjour') ;
> >   3  end ;
> >   4  /
> > HelloBonjour
> > Procedure PL/SQL terminee avec succes.
> > 
> > > -Original Message-
> > > From: Gabriel Aragon
> > [mailto:[EMAIL PROTECTED]]
> > > 
> > > I have a very simple code: 
> > > 
> > > begin 
> > > dbms_output.enable(1000); 
> > > dbms_output.put('hello'); 
> > > end; 
> > > 
> > > but the dbms_output is not sending the output to
> > the
> > > screen. I've already stablished set serveroutput
> > on
> > > and also used set serverout on 
> > > and still not working, this is a very frequent
> > > situation and suddenly it displays everything
> > stored,
> > > why is this happening? Is there some buffer that I
> > > have to flush with a command? Do I miss something?

Re: Why dbms_output is not working

2003-04-02 Thread Wolfgang Breitling

Title: Re: Why dbms_output is not working

Try
begin
dbms_output.enable(1000);
dbms_output.put_line('hello');
end;

At 10:55 AM 4/2/2003 -0800, you wrote:
>I have a very simple code:
>
>begin
>dbms_output.enable(1000);
>dbms_output.put('hello');
>end;
>
>but the dbms_output is not sending the output to the
>screen. I've already stablished set serveroutput on
>and also used set serverout on
>and still not working, this is a very frequent
>situation and suddenly it displays everything stored,
>why is this happening? Is there some buffer that I
>have to flush with a command? Do I miss something?
>
>TIA
>Gabriel Aragon
>
>__
>Do you Yahoo!?
>Yahoo! Tax Center - File online, calculators, forms, and more
>http://tax.yahoo.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Gabriel Aragon
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California    -- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited.  If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately.  We honour similar requests relating to the privacy of email communications.

Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie.  Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit.  Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement.  Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.

Re: dbshut script - shutdown or shutdown immediate





Multiplexing redo logs has nothing to do with the archive mode. Logs are
multiplexed so that an error writing to one of the members in a group does
not cause the instance to terminate. 

Myth - If you use disk mirroring, you don't need to multiplex your redo logs.
Reality - Mirroring only protects from hardware failure. It will not protect
you from accidental deletion of the log (been there, had to fix it!).
-- 
Daniel W. Fink
http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
   Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

GovindanK wrote:

  
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
work?

  
  
Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes the db down and 
does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case.
Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed.  Though Oracle's recovery seems
to be sturdy, double check your backup & recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford.

HTH

GovindanK

Re: Lies, damn lies and statistics

2003-04-02 Thread Stephane Faroult

Karen Morton wrote:
> 
> Stephanie,

Cough, cough.

> I've ran into the exact same thing that statistics don't always tell the
> real story and that the bottom-line has to be elapsed time.
> 
> I am curious however as to how you wrote the best performing (fastest)
> query.  I have a client who uses the exact same structure and methodology
> you mention (innate tree structure, views with outer joins, etc) and they
> have some pretty long and nasty queries (I see your 176 step execution plan
> and raise you to 298!).  I've had pretty decent success re-writing these
> monsters but would be interested in hearing your different approaches to
> re-writing such queries to see if I can pick up a few ideas I hadn't thought
> of.  Any generic ideas or methods you use might prove helpful to many.
> 
> Thanks,
> Karen
> 
> Karen Morton
> Morton Consulting
> [EMAIL PROTECTED]
> 

Karen,

  The only effective method I know is to take an axe and cut everything
which is not strictly necessary. More often than not, when you replace a
view by its query, you realize that you only need some of the columns of
the view, and that some (possibly not fantastically efficient) joins in
the view can be happily disposed of. You also find useless joins outside
of views.
In the query mentioned above, the hard-core was a
   start with a_id in
 (select a.a_id
  from a, b, c, d
  where b.a_id = a.a_id
and 
and c.b_id = b.b_id
and 
and d.c_id = c.c_id
and 
  union
  select a.a_id
  from a, b, e, f
  where b.a_id = a.a_id
and 
and e.b_id = b.b_id
and 
and f.e_id = e.e_id
and 
  union
  ...)

Why joining on a, since the primary key of a (which is what we want) can
be found as foreign key in b? Why repeat the condition on b in the
second part of the union ? And so on.
Once everything was reduced to something I could grasp and constituent
pieces, it was far easier to twitch the code here and there and get
decent results.
'Far easier' is of course a way of speaking. I would be glad if there
were recipes. I usually start with something twice as bad as the
original query, which a bit of additional tuning takes to about ten
times slower than what you want to improve. At which point, about 2
hours after having started, I am beginning to get a better feeling of
the data, take another cup of coffee (and possibly another one), scrap
everything I have done so far and get some results. Another example
today (3rd of my 4 customers this week) where, starting with 170,000 or
about LIOs I have managed after much effort to peak at 500,000 before
reaching the finish line at 2,000. Phew, reputation saved, but it was
hot.

HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle view riddle I am being asked , help me out here.

Run autotrace or sql_trace and determine if the execution plans are 
different. If they are the same, increase the sql_trace level and find 
out what the wait events are.

--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
  Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL
  Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals
Ehresmann, David wrote:

So why would the sql statement used to create a view run faster
(significantly) than selecting from that view built with the same sql
statement?
thanks,



David Ehresmann   

 





--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel W. Fink
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oh Dear, Mr. Ellison's at it again

2003-04-02 Thread Jeremy Pulcifer

Title: RE: Oh Dear, Mr. Ellison's at it again







> -Original Message-
> From: Goulet, Dick [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 02, 2003 10:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oh Dear, Mr. Ellison's at it again
> 
> 
> Ellison: Linux Will Wipe Microsoft Out Of The Data Center
> 
> In dramatic terms, Oracle Corp. Chairman and CEO Larry 
> Ellison predicted the open-source operating system will wipe 
> Microsoft "off the face of the earth" in the battle for the 
> data center market.
> 
> Wonder if anyone has clued him into MySql and PostGreSql yet!!


Um, as he was talking about Linux, I suppose that MySQL and PostGres would actually bolster his claim. Perhaps to his own detriment, though...

However, I liked this...
Quoting Larry, who is quoted in the ComputerWorld article mentioned:


"The computer industry is finally moving from a cottage industry to an industrial industry. We're moving at breakneck pace toward the 19th century," he quipped.

Gotta say, that's pretty funny.

RE: Why dbms_output is not working

Title: RE: Why dbms_output is not working





You need a dbms_output.put_line to "complete" the output line.
e.g.
SQL> set serveroutput on
SQL> begin
  2 dbms_output.put ('Hello') ;
  3  end ;
  4  /
Procedure PL/SQL terminee avec succes.


SQL> begin
  2    dbms_output.put_line ('Bonjour') ;
  3  end ;
  4  /
HelloBonjour
Procedure PL/SQL terminee avec succes.


> -Original Message-
> From: Gabriel Aragon [mailto:[EMAIL PROTECTED]]
> 
> I have a very simple code: 
> 
> begin 
> dbms_output.enable(1000); 
> dbms_output.put('hello'); 
> end; 
> 
> but the dbms_output is not sending the output to the
> screen. I've already stablished set serveroutput on
> and also used set serverout on 
> and still not working, this is a very frequent
> situation and suddenly it displays everything stored,
> why is this happening? Is there some buffer that I
> have to flush with a command? Do I miss something?

Re: Oracle view riddle I am being asked , help me out here.

2003-04-02 Thread Stephane Faroult

"Ehresmann, David" wrote:
> 
> So why would the sql statement used to create a view run faster
> (significantly) than selecting from that view built with the same sql
> statement?
> 
> thanks,
> 
> David Ehresmann
> 

David,

   A view is a STORED object, which means that it executes using a plan
which was 'frozen' at compilation time. Nowadays stats updates normally
cause a view to reevaluate the plan but there are some parameters
(sort_area_size, hash_area_size, to name a few) which may significantly
change the execution plan without being perceived by Oracle as worth of
a recompilation (or cursor re-evaluation). Another possibility is that
the statement was compiled in another schema, and references similar
named, but different, objects. Check the execution plans, they are
probably different. Recompile the view, and (hopefully) it should be
better.

I assume of course that you have no additional WHERE clause. 

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: dbshut script - shutdown or shutdown immediate

>Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
>work?

Well said. This topic has been circulating in many DBA forums for a long time. 
Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes the db down and 
does not bother about anything else. As per manual, if you do a shutdown abort then 
you WILL need the online redo logs for recovery just in case.
Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make 
sure the logs are multiplexed.  Though Oracle's recovery seems
to be sturdy, double check your backup & recovery strategies. Also, which option to 
use is influenced by how much downtime/shutdown time you can afford.

HTH

GovindanK

-- 
|XXX|
|You should treat others the way you want to be treated - Mahatma Gandhi|
|XXX|


__
Try AOL and get 1045 hours FREE for 45 days!
http://free.aol.com/tryaolfree/index.adp?375380

Get AOL Instant Messenger 5.1 for FREE! Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Why dbms_output is not working

2003-04-02 Thread Gabriel Aragon

I have a very simple code: 

begin 
dbms_output.enable(1000); 
dbms_output.put('hello'); 
end; 

but the dbms_output is not sending the output to the
screen. I've already stablished set serveroutput on
and also used set serverout on 
and still not working, this is a very frequent
situation and suddenly it displays everything stored,
why is this happening? Is there some buffer that I
have to flush with a command? Do I miss something? 

TIA 
Gabriel Aragon 

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gabriel Aragon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Mail

Ron,

I've been to the seminars in the past.  The question is not what does Oracle 
have to say, but what do others who've made the move have to say.

Dick Goulet

-Original Message-
Sent: Tuesday, April 01, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L


Dick,
 check out this link
http://www.oracle.com/jsp/events/EventsDetail.jsp?p_eventId=9595&src=1544227&src=1544227&Act=183

it is the link top the OTN events about just what you are talking
about.
If your lucky you can get the slide show that did the comparisons
between Oracle and MS per user per year.
Ron

>>> [EMAIL PROTECTED] 04/01/03 04:08PM >>>
Kirti,

Can I add to your request?

I'd appreciate knowing of anyone who migrated to collaborative
suite instead of Exchange and if there was a $$ difference how much it
was and which way.  Also if you did make the move from Exchange to
Collaborative did you save any money in the process?


Dick Goulet

-Original Message-
Sent: Tuesday, April 01, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L


Hello All,

 Anyone migrated to Oracle Mail from MS Exchange Server?  Care to share
the experience?  

 I was asked about it. I have no idea how it works. I am trying to
gather as much info as possible from Oracle.com, Google  etc.. 

 Thanks.

- Kirti 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oh Dear, Mr. Ellison's at it again

Ellison: Linux Will Wipe Microsoft Out Of The Data Center

In dramatic terms, Oracle Corp. Chairman and CEO Larry Ellison
predicted the open-source operating system will wipe Microsoft "off the
face of the earth" in the battle for the data center market.

http://computerworld.com/newsletter/0%2C4902%2C79951%2C0.html?nlid=AM


Wonder if anyone has clued him into MySql and PostGreSql yet!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Igor Neyman

Kirti,

Thanks.
My question was not in regards to the tool, but in regards to use of SPFILE
in general.

Igor


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 12:23 PM


> Igor,
>  It depends.
>  If you are not aware of what the tool does, you will get caught by
surprise (like my co-worker;) May be there is an option to not create the
SPFILE.. I didn't use the tool when I upgraded a few my databases to 9i.
>  But, AFIAC, I am staying away from SPFILE, as long as possible, for my
own reasons..
>
> - Kirti
>
> -Original Message-
> Sent: Wednesday, April 02, 2003 10:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Kirti,
>
> Is it a bad thing?
>
> Igor
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 02, 2003 10:28 AM
>
>
> > I was told that the tool creates, and uses, SPFILE after the upgrade...
> >
> > - Kirti
> >
> >
> > -Original Message-
> > Sent: Wednesday, April 02, 2003 7:09 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > I used it recently on a W2K box, worked fine, no problems, no
> > hassles... took a while to do the upgrade so don't panic if it seems to
> > be taking a long time
> >
> >
> > --- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> > > Hi
> > >
> > > I'm about to upgrade 8.1.7 db to 9.2 db.
> > >
> > > Platform is AIX.
> > >
> > > "Database Upgrade Assistant" is going to be used. Does anyone have
> > > any bad experience with this oracle tool? Or the whole process is
> > > straight forward?
> > >
> > > Thanks,
> > > Vladimir Barac
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Reginald . W . Bailey


Also in the dbshut, change the connect internal to use sqlplus and "/ as
sysdba" as the connectivity string.  This is the approved method for
Oracle8i and Oracle9i.




Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)



   

[EMAIL PROTECTED]  
   
Sent by: To: [EMAIL PROTECTED] 
 
[EMAIL PROTECTED]   cc:
   
om   Subject: RE: dbshut script - shutdown or 
shutdown immediate   
   

   

04/02/2003 

10:19 AM   

Please respond 

to ORACLE-L

   

   





Yes, that should be a standard practice any time you perform an new Oracle
install.
Otherwise, that database will problably always hang waiting for all
sessions to
disconnect before completing the shutdown.

I believe the latest versions of Oracle have corrected that issue in the
dbshut
script.

-Original Message-
Peter
Sent: Wednesday, April 02, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system administrator tells me that this instance always
hangs when she tries to shut down the system.  The other instances,
which do not support a 24x7 process shut down properly.

Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
 connect internal
 shutdown

Should I modify the script to "shutdown immediate" so that it kills
any connections?

Environment is Oracle 8.1.7 /AIX 4.3.3.

Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary W. Parker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in

Re: dbshut script - shutdown or shutdown immediate

>"Schauss, Peter" wrote:
> I have one Oracle instance which supports an application
> server which always maintains a database connection.
> The UNIX system administrator tells me that this instance always
> hangs when she tries to shut down the system.  The other instances,
> which do not support a 24x7 process shut down properly.
>
> Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
> is
> connect internal
> shutdown
>
> Should I modify the script to "shutdown immediate" so that it kills
> any connections?
>
> Environment is Oracle 8.1.7 /AIX 4.3.3.
From: Joan Hsieh <[EMAIL PROTECTED]>
Peter,
I modified to shutdown abort, starup then shutdown immediate.
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't 
work?

Chris Berry
[EMAIL PROTECTED]
Systems Administrator
JM Associates
"Without change, something sleeps inside us, and seldom awakens.  The 
sleeper must awaken." -- Duke Leto Atreides

_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Berry
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle urban legends and myths needed

2003-04-02 Thread Stephane Paquette

Thanks,

I've found some on asktom also.

Stephane

-Original Message-
Litchfield
Sent: Tuesday, April 01, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L


I seem to be missing some of the replies etc to this so apologies for
repeating anything anyone else has said. 


1. A BCHR of x% means that you have a well tuned system (where x is
usually > 95)
2. Minimise the number of extents for each object
3. Set PCTIncrease to a small value (typically 1%) to minimise
fragmentation. 
4. Index blocks never get reused.
5. Rebuild indexes frequently. 
6. Separation of data and indexes improves performance
7. The most selective column of a concatenated index should be the
leading
Column
8. If its in print it must be true
9. If 'x' says so it must be true. 
10. Avoid Full Table Scans, they are always bad. 

Niall 


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
> Stephane Paquette
> Sent: 01 April 2003 15:54
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle urban legends and myths needed
> 
> 
> Hi all,
> 
> I'm currently writing an Oracle user guide for our 
> developpers about how Oracle is implemented, SQL and PL/SQL 
> good practices, tuning, rule base vs cost base (90 on 120 
> databases are still rule base) ...
> 
> 
> I want to add an Oracle urban legends and myths section 
> focussed on development. I'm missing inspiration as I only 
> have the "use an index it'll go faster" one.
> 
> I'm sure you have lots of them.
> 
> 
> TIA
> 
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 925-7187
> [EMAIL PROTECTED] 
> 
> 
> 
> -- 
> Please see 
> the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stephane Paquette
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle view riddle I am being asked , help me out here.

2003-04-02 Thread Ehresmann, David

So why would the sql statement used to create a view run faster
(significantly) than selecting from that view built with the same sql
statement?

thanks,



David Ehresmann   

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ehresmann, David
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Virus.

My desktop here at work was infected with that virus.

All attempts to eradicate it have failed.

Fortunately, I have another older machine under my desk
as well that was infected with RH80, which actually counteracts
the other virus.

Jared





"Gogala, Mladen" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/02/2003 08:03 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Virus.


There is a very dangerous virus just being concocted in Redmond, WA.
It is enormous, it will make your PC unstable and very insecure and 
you'll lose a lot of time and money trying to fix it.

-Original Message-
Sent: Wednesday, April 02, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L


Just had a virus come in to the list via [EMAIL PROTECTED] 
(who
I've copied directly, so "heads up Chris" ;)).

The virus is WORM_LIRVA.A, I didn't get infected (thankfully attachements
are stripped).. More details about the worm can be found here:

http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=WORM_LIRVA.A
&VSect=T

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote:

> Then, while bringing up, we do 
> 
> startup restrict;
> shutdown immediate;
> startup

Why?  Doesn't it start up fine the first time?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Gogala, Mladen

Only if you're not aware of it. I started editting init$ORACLE_SID.ora like
crazy
and parameter changes would have no effect whatsoever. I thought for a
moment that I've
enterd the twilight zone but then I resorted to the unthinkable: I read the
documentation.
I know I shouldn't have done it, but, at least, I confess to doing that.
After that,
I learned how to handle the SPFILE and I sort of like it.

-Original Message-
Sent: Wednesday, April 02, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Kirti,

Is it a bad thing?

Igor   


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 10:28 AM


> I was told that the tool creates, and uses, SPFILE after the upgrade... 
> 
> - Kirti
> 
> 
> -Original Message-
> Sent: Wednesday, April 02, 2003 7:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I used it recently on a W2K box, worked fine, no problems, no
> hassles... took a while to do the upgrade so don't panic if it seems to
> be taking a long time
> 
> 
> --- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> > Hi
> > 
> > I'm about to upgrade 8.1.7 db to 9.2 db.
> > 
> > Platform is AIX.
> > 
> > "Database Upgrade Assistant" is going to be used. Does anyone have
> > any bad experience with this oracle tool? Or the whole process is
> > straight forward?
> > 
> > Thanks,
> > Vladimir Barac
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle Job Task Analysis

Scott,

This is quite a list you have compiled.

I wouldn't subtract anything.

The only thing I could think of to add was in the Scalability section.

This section  seems to concentrate on using Oracle technologies
to enhance scalability, but there is another level that I think needs
to be considered as well.

The ability to scale ( or not ) is built into an application.   An app 
that
calls 'select something from dual' in every transaction is going to
have problems.

So will apps where the developers insist on trying to do everything
in code rather than relying on the database.

A DBA should be able to recognize when this is happening.  The 
best course is to have an adivisory position in this regard when an
app is being developed.  Doesn't often happen this way though.

A DBA should be able to demonstrate common developer habits
that inhibit scalability, and how to recode these so that they are
more scalable.

Being able to do so in PL/SQL is sufficient, and in fact preferable.

Any chance of us seeing the completed analysis?

Jared






Scott <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/01/2003 01:14 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle Job Task Analysis


I am putting together a prelimanary job task analysis
for Oracle DBA's and would like some input from you
hardworking DBA's on this list.

Here is what I have so far for core competencies and I
would like to add or subtract from this list based on
your input. 

A. Oracle Architecture And Options
B. Security and Network Access
C. Application Design and Modelling
D. Backup And Recovery
E. Software Maintenance And Operation
F. SEGMENT and DATA MANAGEMENT
G. Tuning And Troubleshooting

My Recommendations for slightly more advanced
competencies that are still quite important
For many installations.

H. Scalability
I. High Availability
J. Business Intelligence

Here is what I have as sub-components for the core
competencies.

A.  ORACLE ARCHITECTURE AND OPTIONS 
...




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Stephen Murphy

We replace the simple shutdown command with:

shutdown immediate
startup restrict
alter system switch logfile;
host sleep 10
shutdown immediate

We recently installed 9.2.0.2-64bit on AIX. As of that release, Oracle is
still shipping dbshut with simply shutdown normal.

--
*---
* 
  Stephen T. Murphy  
  Manager, Database and Technical Support 
  ITS - University Applications Development 
  MSC-100 
  The University at Albany, S.U.N.Y 
  Albany,  New York1
  Phone: (518) 437-4523 Fax: (518) 437-4540   
  MailTo: [EMAIL PROTECTED] AIM: SMurphy199 


-Original Message-
Sent: Wednesday, April 02, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L


Yes, that should be a standard practice any time you perform an new Oracle
install.
Otherwise, that database will problably always hang waiting for all sessions
to
disconnect before completing the shutdown.

I believe the latest versions of Oracle have corrected that issue in the
dbshut
script.

-Original Message-
Peter
Sent: Wednesday, April 02, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system administrator tells me that this instance always
hangs when she tries to shut down the system.  The other instances,
which do not support a 24x7 process shut down properly.

Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
is
connect internal
shutdown

Should I modify the script to "shutdown immediate" so that it kills
any connections?

Environment is Oracle 8.1.7 /AIX 4.3.3.

Thanks,
Peter Schauss
Northrop Grumman Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary W. Parker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Murphy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle Server / W2K

Joshua,

The correct answer is:  it depends.

It depends on how fast the response time from the database needs to be.

It depends on how much data you have.

If your database and archive logs and everything else your app needs
will never be more than 48 Gig, then you may want to create 3 mirrored
drives so that you can shuffle files around if necessary.

It could be that your app would work just fine on a 48 gig RAID 10, in 
which
case you just put everything on on logical volume.

Maybe you need 70 gig, in which case the only choice you have
is to put all 6 drives in a RAID5 group.

Jared





Joshua Becker <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/01/2003 11:13 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle Server / W2K


Hi all,

what might be the best configuration for OLTP database
if you have following "components":

DL380 2*1.4ghz, 2GB Mem, 6*16GB 15k Disks...

And what is the correct flag for Optimize Performance
for Applications or Background Processes...

TIA
Joshua

_
Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express
Se mer på: http://se.docs.yahoo.com/info/express/help/index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Joshua=20Becker?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: DBLink to SQL Server problem

2003-04-02 Thread Igor Neyman

Probably, because without double quotes Oracle was converting them to
upper-case (on Oracle side before sending SQL to SQLServer) as it usually
does, and they are not defined as upper case in SQLServer.
So, double quotes prevented implicit conversion.

Igor


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:43 AM


> Thanks Igor.  I figured it out.  I need double quotes around the column
name and it works.  Didn't see that mentioned in TFM.
>
>   1* select "mpp_id" from [EMAIL PROTECTED]
> tdispach> select "mpp_id" from [EMAIL PROTECTED] where "mpp_id" =
'LESS';
>
> mpp_id
> 
> LESS
>
> Thanks,
>
> Dave
>
> -Original Message-
> Sent: Wednesday, April 02, 2003 9:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dave,
>
> SQL Server is case-sensitive, when it comes to table names, column names.
> When stored in SQL Server data dictionary, they aren't converted into
> upper-case, as it is with Oracle (unless you use quotes around names).
> So, try to use the exact "case" when specifying field names (as they are
> stored in SQL Server data dictionary).
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 02, 2003 9:34 AM
>
>
> > I created a DBLink to a SQL Server database following DocID: 114820.1.
It
> seemed to work fine until I tried a real query.  If I do something like a
> SELECT COUNT(*) or SELECT * it works fine;
> >
> > tdispach> select count(*) from [EMAIL PROTECTED];
> >
> >  COUNT(*)
> > -
> >  1207
> >
> > But if I try to select on a specific field or have a WHERE clause
> specifying a filed I get this;
> >
> > tdispach> select mpp_id from [EMAIL PROTECTED];
> > select mpp_id from [EMAIL PROTECTED]
> >*
> > ERROR at line 1:
> > ORA-00904: invalid column name
> >
> > I know that the column name is correct so something else is not
> translating properly.  I tried a fully qualified column name of
> MANPOWERPROFILE.MPP_ID and that got the same error.  I don't see any
setting
> in my DSN that could effect this.  Anyone have any ideas, hunches or
clues?
> >
> > Thanks,
> >
> > Dave
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Farnsworth, Dave
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Igor Neyman
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle OCI JDBC Driver Not Recommended for Multiprocessor Machine

I guess they think that no one should use TAF, which requires the thick 
driver.

The poor scalability of the app couldn't have anything to do with the 
application.

Could it?  ;)

Jared





Rick Stephenson <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 04/02/2003 07:28 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Oracle OCI JDBC Driver Not Recommended for Multiprocessor 
Machine


Sun's FAQ on java hotspot VM  performance 
(http://java.sun.com/docs/hotspot/PerformanceFAQ.html) includes this interesting 
question:
 
My application uses a database and doesn't seem to scale well. What could 
be going on? 
Oracle provides two types of database drivers: a type-2 driver, called the 
OCI (Oracle Call Interface) driver that utilizes native code, and a type-4 
pure Java driver called the thin driver. In single processor environments, 
the thin driver works somewhat better than the OCI driver because of the 
JNI overhead associated with the OCI driver. On multi-processor 
configuations, synchronization points within Solaris used by the OCI 
driver become big bottlenecks and prevent scaling. We recommend using the 
thin driver in all cases. 
 
Is this actually the case?  Does anyone have more information on this?
 
Thanks,
 
Rick Stephenson


This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to which they are 
addressed. This message contains confidential information and is intended 
only for the individual named. If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail. Please notify the 
sender immediately by e-mail if you have received this e-mail by mistake 
and delete this e-mail from your system. If you are not the intended 
recipient you are notified that disclosing, copying, forwarding or 
otherwise distributing or taking any action in reliance on the contents of 
this information is strictly prohibited. 




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: DBLink to SQL Server problem

2003-04-02 Thread Jeremy Pulcifer

Title: RE: DBLink to SQL Server problem





Surround your column and table names with double-quotes (select "mpp_id" from...). I suspect that your SQL Server table was specified with lower-case columns.

> -Original Message-
> From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 02, 2003 6:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DBLink to SQL Server problem
> 
> 
> I created a DBLink to a SQL Server database following DocID: 
> 114820.1.  It seemed to work fine until I tried a real query. 
>  If I do something like a SELECT COUNT(*) or SELECT * it works fine;
> 
> tdispach> select count(*) from [EMAIL PROTECTED];
> 
>  COUNT(*)
> -
>  1207
> 
> But if I try to select on a specific field or have a WHERE 
> clause specifying a filed I get this;
> 
> tdispach> select mpp_id from [EMAIL PROTECTED];
> select mpp_id from [EMAIL PROTECTED]
>    *
> ERROR at line 1:
> ORA-00904: invalid column name
> 
> I know that the column name is correct so something else is 
> not translating properly.  I tried a fully qualified column 
> name of MANPOWERPROFILE.MPP_ID and that got the same error.  
> I don't see any setting in my DSN that could effect this.  
> Anyone have any ideas, hunches or clues?
> 
> Thanks,
> 
> Dave
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
>

RE: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Deshpande, Kirti

Igor,
 It depends. 
 If you are not aware of what the tool does, you will get caught by surprise (like my 
co-worker;) May be there is an option to not create the SPFILE.. I didn't use the tool 
when I upgraded a few my databases to 9i. 
 But, AFIAC, I am staying away from SPFILE, as long as possible, for my own 
reasons.. 

- Kirti 

-Original Message-
Sent: Wednesday, April 02, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L

Kirti,

Is it a bad thing?

Igor   

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 10:28 AM

> I was told that the tool creates, and uses, SPFILE after the upgrade... 
> 
> - Kirti
> 
> 
> -Original Message-
> Sent: Wednesday, April 02, 2003 7:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I used it recently on a W2K box, worked fine, no problems, no
> hassles... took a while to do the upgrade so don't panic if it seems to
> be taking a long time
> 
> 
> --- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> > Hi
> > 
> > I'm about to upgrade 8.1.7 db to 9.2 db.
> > 
> > Platform is AIX.
> > 
> > "Database Upgrade Assistant" is going to be used. Does anyone have
> > any bad experience with this oracle tool? Or the whole process is
> > straight forward?
> > 
> > Thanks,
> > Vladimir Barac
> 
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Whose function is executing.

Title: RE: Whose function is executing.





Could this script from Ixora help?
How can I tell if a procedure/package is running? 
http://www.ixora.com.au/q+a/0110/30141015.htm


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> 
> Is there a way to see whose function a user is executing?
> 
> Development and production schemas exist on the same database and both
> accounts have granted object privileges to the user roles. (I 
> think public
> synonyms are being used). I'm wondering if there is a way to 
> check that a
> user is executing x's procedure. Is this available in a trace?

Re: Db. Upgrade Assistant - any bad stories?

2003-04-02 Thread Stephen Andert

I'm not using the dbua since I cannot use X applications from home due
to the firewall we have.  

I've now upgraded 3 8.1.7.3 databases to 9.2.0.2.  One of these was a
very little play database I created just to test the upgrade process. 
The other 2 are fairly small (35-40 GB) test databases.  One of them had
some kind of hiccup and hung for nearly an hour during the u0801070.sql
script.  I did a shutdown immediate on the database and restarted and it
ran completely in 45 minutes.  I don't know what caused the problem, but
it looks like restarting the upgrade script fixed it.

Good luck.
Stephen

>>> [EMAIL PROTECTED] 04/02/03 06:08AM >>>
I used it recently on a W2K box, worked fine, no problems, no
hassles... took a while to do the upgrade so don't panic if it seems
to
be taking a long time

--- Vladimir Barac <[EMAIL PROTECTED]> wrote:
> Hi
> 
> I'm about to upgrade 8.1.7 db to 9.2 db.
> 
> Platform is AIX.
> 
> "Database Upgrade Assistant" is going to be used. Does anyone have
> any bad experience with this oracle tool? Or the whole process is
> straight forward?
> 
> Thanks,
> Vladimir Barac

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Andert
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Do triggers cause a context switch between SQL & PL/SQL

Title: RE: Do triggers cause a context switch between SQL & PL/SQL





Well yes. I was pointing out a second way to write the query that avoided selecting from dual. But the time it takes to run the query is the same in both examples.

-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]


I am not sure ... so far as I know "select count(*) from some_table" without any further group by has always resulted in one row ...

-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]


Your query with the exists would be the same as doing this, right? 
select count(*) 
  into numrows 
from ApplicationFormCriteria 
where ApplicationFormCriteria.applicationFormId = :old.applicationFormId 
  and rownum = 1 ; 


-Original Message- 
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 


A context switch is order because a trigger is a pl/sql object ... 
if you can change the trigger ... instead of count(*) try using exists assuming you have a usable index ... 
select count(*) 
  into numrows 
from dual 
where exists ( select 1 
    from ApplicationFormCriteria 
   where ApplicationFormCriteria.applicationFormId = :old.applicationFormId); 


...

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Farnsworth, Dave

I also started doing this a couple months ago and have not had a shutdown hang since.

Dave

-Original Message-
Sent: Wednesday, April 02, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L

We do shutdown abort. But we do checkpoint before shutdown abort i.e,

alter system checkpoint;
shutdown abort;

Then, while bringing up, we do 

startup restrict;
shutdown immediate;
startup

Rao

-Original Message-
Sent: Wednesday, April 02, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L

Peter,

I modified to shutdown abort, starup then shutdown immediate.

joan

"Schauss, Peter" wrote:
> 
> I have one Oracle instance which supports an application
> server which always maintains a database connection.
> The UNIX system administrator tells me that this instance always
> hangs when she tries to shut down the system.  The other instances,
> which do not support a 24x7 process shut down properly.
> 
> Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus
> is
> connect internal
> shutdown
> 
> Should I modify the script to "shutdown immediate" so that it kills
> any connections?
> 
> Environment is Oracle 8.1.7 /AIX 4.3.3.
> 
> Thanks,
> Peter Schauss
> Northrop Grumman Corporation
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schauss, Peter
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Query through database link gets lost