Your details

[eastham]

Please see the attached file for details.

movie0045.pif
Description: Binary data

Re: alter system reset

[bulbultyagi]

Yes , opened up spfile in a text editor and undo_suppress_errors exists. But
I get the error , no matter which parameter I try to reset. ex:
undo_management, undo_tablespace, undo_retention, pga_aggregate_target,
workarea_size_policy, shared_pool_size, sort...etc, etc
However when I open the spfile I find that shared_pool_size exists there ,
then I try resetting it  (just to test it out)


SQL> alter system reset shared_pool_size scope=spfile sid='lahiri' ;
alter system reset shared_pool_size scope=spfile sid='lahiri'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE


SQL> alter system set shared_pool_size=40M scope=spfile sid='lahiri' ;


System altered.

SQL> alter system reset shared_pool_size scope=spfile sid='lahiri' ;

System altered.

Why does this happen ?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 00:44


> Does the entry even exist in the SPFILE? Open up the spfile in notepad and
> check the existence of the parameter in there. Do the following:
>
> SQL> alter system set undo_suppress_errors = false scope=spfile
> sid='ananda';
>
> System altered.
>
> SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda';
>
> System altered.
>
> HTH.
>
> Arup
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 01, 2003 2:14 PM
>
>
> > Hello list I am using Oracle 9.2.0.1.0 enterprise on windows.
> >
> > When I run the following ( connected as sysdba , and using an spfile
> called
> > %oracle_home%\database\spfilelahiri.ora )
> >
> > SQL> show user
> > USER is "SYS"
> >
> > SQL> host echo %oracle_sid%
> > LAHIRI
> >
> > SQL> sho parameter db_name
> >
> > NAME TYPE  VALUE
> > db_namestring   lahiri
> >
> > SQL> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri';
> > ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'
> > *
> > ERROR at line 1:
> > ORA-32010: cannot find entry to delete in SPFILE
> >
> > Any ideas ?  I get the same problem irrespective of the parameter I try
to
> > reset.
> > ..
> >
> > --
> > 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: Arup Nanda
>   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).

RE: Oracle on Win2000

[Charu Joshi]

Citrix could another option worth evaluating. (I personally find it 
better than PCAnywhere.)
 
Regards,
Charu.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of 
  [EMAIL PROTECTED]Sent: Thursday, September 04, 2003 3:25 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on Win2000The 
  primary reason for problems with terminal server is that it is just that - a 
  terminal. VNC and PcAnywhere 
  actually take control of the console on a Windows machine. 
  A default Oracle install requires console 
  access for certain things, such as starting the database from a command line using svrmgrl or sqlplus. 
  Jared 
  


  
  "Smith, Ron L." 
<[EMAIL PROTECTED]> Sent 
by: [EMAIL PROTECTED] 
 09/03/2003 02:39 PM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        RE: Oracle on 
Win2000Be careful using Terminal Server.  If you are running batch jobs, 
  the variables like ORACLE_SID and ORACLE_HOME don't always get picked up 
  correctly by the batch job.  I have spent hours trying to debug a script 
  run with Terminal Server, then switch to VNC and it works fine. 
    Ron Smith -Original 
  Message-From: Branimir Petrovic [mailto:[EMAIL PROTECTED] 
  Sent: Wednesday, September 03, 2003 4:14 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: Oracle on 
Win2000
  Windows Terminal services that comes 
  with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows 
  Components, then install Windows Terminal Client on admin PC). 
  Bigger hassle to install and configure, 
  but a LOT better performer than PCAnywhere or VNC (other two "usual suspects" 
  for remoting unremoteable). 
  Branimir 
   
  -Original Message-From: Bala 
  Regupathy [mailto:[EMAIL PROTECTED]Sent: September 3, 2003 
  1:44 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000First time I have got 
  to maintain Oracle databases on Win 2000 server.  What tools do you guys 
  use to get to the server to admin oracle databases ?   Thanks,   
  Bala. 



*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com

ProAct with Oracle

[Gunnar Berglund]

Hi all,
 
who has used ProAct products (NetApp Filer etc),  with oracle with RAC and/or Linux.
 
How do rate those and do you have any feedback or recommendations.
 
All information is appreciated!
 
rgds
gWant to chat instantly with your online friends? Get the FREE Yahoo!
Messenger

Re: EXECUTE IMMEDIATE and PL/SQL variables - SOLVED

[Mark Richard]

Sorry listers,

I spent a bit of time searching Google and quickly found my answer.  I
shouldn't have rushed to post to the list.  The answer is to move the INTO
clause outside of the string as shown below:

DECLARE
  n_count NUMBER;
BEGIN
  EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM DUAL' INTO n_count;
  dbms_output.put_line('Number is '||n_count);
END;
/





   
   
  "Mark Richard"   
   
  <[EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>  
  ban.com.au>  cc: 
   
  Sent by: Subject:  EXECUTE IMMEDIATE and PL/SQL 
variables???
  [EMAIL PROTECTED]
   
  .com 
   
   
   
   
   
  04/09/2003 16:39 
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   





Hi List,

I know someone will have a good answer to this question:

I have a large PL/SQL program to convert some data.  Some tables are
created dynamically during the PL/SQL procedure using EXECUTE IMMEDIATE.  I
need to query values from some of these tables (only a couple of rows, so
performance is a non-issue currently).  Since the tables don't exist at
compilation time I thought about putting them into EXECUTE IMMEDIATE
statements to enable the PL/SQL to compile.  My problem, therefore, is how
do I get a figure from such a statement back into a normal variable?

I really don't want to break the conversion process into several PL/SQL
blocks if there is a way to avoid this.  Does anyone know of a tidy way to
accomplish this?  I'm willing to accept any ideas currently.

Thanks in advance,

Mark.

What, for example, is the equivalent of:

DECLARE
  n_count NUMBER;
BEGIN
  EXECUTE IMMEDIATE 'SELECT COUNT(*) INTO n_count FROM DUAL';
  dbms_output.put_line('Number is '||n_count);
END;
/

<<>>

   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>





<<>>

Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone.
In such a case, you should destroy this message and kindly notify the
sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3
9612-6999.
Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message that do not
relate to the official business of Transurban Infrastructure Developments
L

RE: Oracle not available???

[Denham Eva]

Thanks Patrice,

I'll look into this, however I find it way strange that the server has been
running no problems for almost three months. Maybe a suggestion from one of
the other listers is very pertinant - reboot bi-weekly perhaps. However I
hear from my virus admin that we were attacked by another worm yesterday and
also that it was not only my system that lost connections, the other system
was a SQLserver machine. So makes me wonder.
Anyway Patrice, I'll look into your suggestion, purely because I was did not
know of it before, and thanks for the info.

PS when you mention mem utilization stats - are thinking of the ones
generated by the windows monitoring utility?

Best Regards
Denham




Check in Task Manager, Performance Tab...

upper right corner, Physical Memory (K) Total = 
lower left corner, Commit Charge (K) Peak = 

Commit Charge Peak should be less than half physical RAM, otherwise users
may not be able to connect.

Oracle can't be swapped to disk in Windows because it updates the data block
and other headers regularly, and it's too fast for the Windows virtual
memory manager.  I don't know if this is the case only for busy databases,
but I bumped into that here.

Windows splits memory equally between kernel and user processes, that means
you get to use about half the available RAM on your machine.  

User sessions can usually be swapped to disk (I think), if they are
inactive.

I would be curious to hear what memory utilization stats you have on the
machine.

Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denham Eva
  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).

RMAN backup and recovery scenarios

[Prem Khanna J]

Hi all,

Is there any doc./URL which lists out RMAN backup and recovery scenarios ?
did not find one in metalink.

Thanks & Regards,
Jp.



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

EXECUTE IMMEDIATE and PL/SQL variables???

[Mark Richard]

Hi List,

I know someone will have a good answer to this question:

I have a large PL/SQL program to convert some data.  Some tables are
created dynamically during the PL/SQL procedure using EXECUTE IMMEDIATE.  I
need to query values from some of these tables (only a couple of rows, so
performance is a non-issue currently).  Since the tables don't exist at
compilation time I thought about putting them into EXECUTE IMMEDIATE
statements to enable the PL/SQL to compile.  My problem, therefore, is how
do I get a figure from such a statement back into a normal variable?

I really don't want to break the conversion process into several PL/SQL
blocks if there is a way to avoid this.  Does anyone know of a tidy way to
accomplish this?  I'm willing to accept any ideas currently.

Thanks in advance,

Mark.

What, for example, is the equivalent of:

DECLARE
  n_count NUMBER;
BEGIN
  EXECUTE IMMEDIATE 'SELECT COUNT(*) INTO n_count FROM DUAL';
  dbms_output.put_line('Number is '||n_count);
END;
/

<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>




<<>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of 
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and kindly notify the sender by reply 
e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
Please advise immediately if you or your employer does not consent to Internet e-mail 
for messages of this kind.
Opinions, conclusions and other information in this message that do not relate to the 
official business of Transurban Infrastructure Developments Limited and CityLink 
Melbourne Limited shall be understood as neither given nor endorsed by them.
<<>>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  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: Urgent INFO needed.

[Maria Aurora de la Vega]

Its quite unfair for DBAs to blame their job loss/fear of job loss to DBAs
in India or some other countries with cheaper labor.
And to say that "you get what you pay for" or insinuating that cheaper
labor means less quality...is definitely out of line...
some people are just better than others...that's it...it has nothing
to do with geography or nationality...
some of the best DBAs...or IT professionals in general...are in fact
indians...
Point is its not the indians' fault jobs just come knocking at their
doors...
we all want better jobs and better pay...if it comes to me i'll grab
it no doubt... would I think about other DBAs who were taken off to accomodate
me? of course not. I have nothing to do with their decision to outsource...and
even if I stress myself worrying about it...can I do anything about it?
no...so, what do I do...I'd take advantage of course...
I've come to believe no one is indispensable...even if you've served
5, 10, 15 years in a company...there's always a reason to take you out
no matter how good you are...
And sometimes companies think...do I really need someone that good
and costs a lot more? or can we do with someone quite average but can get
the job done and costs a lot less?
Tony Johnson wrote:
 All
I know about it is that for every new job in India one more DBA is out
of work here in the United States.

-Original
Message-
From: Ora DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September
03, 2003 5:30 AM
To: Multiple recipients of
list ORACLE-L
Subject: Urgent INFO needed.
 
Dear Friends,
One of my friends has got the offer from CSC india ltd. Please respond
this mail if any one from CSC india ltd? just to know some info , thats
it.
Any info regarding this is appreciated. Please give me your mail id
and contacts..
Thanks a lot.
Regards
Oracle DBA

Do you Yahoo!?
Yahoo!
SiteBuilder - Free, easy-to-use web site design software

Re: ORA-01031: insufficient privileges -- from user oracle running

[Jared Still]

Sorry to be pedantic, but that isn't the sticky bit,
that is the SUID bit.  There's also an SGID bit.

The sticky bit is set with a 't', and is redundant
on modern versions of unix ( including linux ) and 
may well be ignored altogether.

Oh, and I'm not sorry about being pedantic, not really.  :)

Jared

On Wed, 2003-09-03 at 20:39, Dave Hau wrote:
> Make sure you have the sticky bit set for the oracle executable:
> 
> chmod u+s $ORACLE_HOME/bin/oracle
> 
> HTH,
> Dave
> 
> 
> 
> 
> [EMAIL PROTECTED] wrote:
> > Hi:
> > 
> > I have an Oracle 8173 db running on  Solaris 2.8 box (called rex) and
> > today I found something that I am trying to understand.  When I login to
> > the Unix box as user "oracle" (which I used to install oracle software), I
> > can manaully run svrmgrl, then connect as "internal", I can do "startup"
> > and "shutdown immediate" with no problem. I have been doing this for
> > years.
> > 
> > But if I still log in as "oracle", at unix prompt I do:
> > 
> > rex$ which dbstart
> > /oracle/product/8.1.7/bin/dbstart
> > rex$ dbstart
> > 
> > SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 3 20:57:16 2003
> > 
> > (c) Copyright 2000 Oracle Corporation.  All rights reserved.
> > 
> > connect internalORA-01031: insufficient privileges
> > connect internal
> > Database "YPD" warm started.
> > rex$ ps -ef|grep oracle
> >   oracle  2268 1  0 16:54:27 ?0:00
> > /oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
> >   oracle 11195 11152  0 20:57:26 pts/20:00 grep oracle
> >   oracle 11152 11150  0 20:56:19 pts/20:00 -sh
> > 
> > I know "dbstart" worked before because it was called by "auto start"
> > script that I put in /etc/init.d/oracle and /etc/rc2.d/S99oracle last
> > year.
> > 
> > I also checked /var/opt/oracle/oratab  and environmental variables:
> > 
> > rex$ env|grep ORACLE
> > ORACLE_ADMIN=/oracle/admin
> > ORACLE_BASE=/oracle
> > ORACLE_HOME=/oracle/product/8.1.7
> > ORACLE_SID=YPD
> > 
> > And they seem working fine (again I can use svrmgrl without any problems).
> > 
> > Does anyone know where I should fix so I can start the instance by running
> > script "dbstart"?  TIA.
> > 
> > Guang
> > 
> > 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dave Hau
>   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: Jared Still
  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 World - Listers get together (proposed Tuesday Sep 9)

[Mladen Gogala]

Why don't listers meet on the east coast, somewhere in the area codes
203,718 or 212? I don't pay roaming charges in those phone areas.
Can you hear me now?
On 2003.09.04 00:49, Arup Nanda wrote:
John,

Oracle Awards felicitation is a luncheon on Wednesday. So Dinner is free
that day.
By the way, Sean Hull also expressed his interest to join the party.

Thanks.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 5:54 PM
> Hi all,
>
> We talked about this earlier and I wanted to get this mail out before
> everyone participating departs for OOW. I would propose a Lister's
> get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed
> has the 'OracleWorld Appreciation day' in the evening and I am assuming
> there will be felicatations for Arup and Mogens at this time... (and Thu
> ends it all).
>
> I have the following that have responded (in no particular order): Arup
> Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
> Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey last
> time?), Connor McDonald (all the way from Down under!), Greg Loughmiller,
> Matthew Zito, Molina Gerardo and self.
>
> We will meet over Dinner at a restaurant across the street from Moscone
> Center - probably from about 6:30PM? The address is:
>
> Chevy's
> 201 3rd Street (corner of 3rd and Howard)
> San Francisco, CA 94105
> 415-543-8060
>
> I will send out a reminder email closer to that time (like Monday :) Let
me
> know if there are additional numbers...
>
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> Disappointment is inevitable, but Discouragement is optional!
>
> ** The opinions and facts contained in this message are entirely mine and
do
> not reflect those of my employer or customers **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Kanagaraj
>   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: Arup Nanda
  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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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 World - Listers get together (proposed Tuesday Sep 9)

[Arup Nanda]

John,

Oracle Awards felicitation is a luncheon on Wednesday. So Dinner is free
that day.

By the way, Sean Hull also expressed his interest to join the party.

Thanks.

Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 5:54 PM


> Hi all,
>
> We talked about this earlier and I wanted to get this mail out before
> everyone participating departs for OOW. I would propose a Lister's
> get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed
> has the 'OracleWorld Appreciation day' in the evening and I am assuming
> there will be felicatations for Arup and Mogens at this time... (and Thu
> ends it all).
>
> I have the following that have responded (in no particular order): Arup
> Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
> Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey last
> time?), Connor McDonald (all the way from Down under!), Greg Loughmiller,
> Matthew Zito, Molina Gerardo and self.
>
> We will meet over Dinner at a restaurant across the street from Moscone
> Center - probably from about 6:30PM? The address is:
>
> Chevy's
> 201 3rd Street (corner of 3rd and Howard)
> San Francisco, CA 94105
> 415-543-8060
>
> I will send out a reminder email closer to that time (like Monday :) Let
me
> know if there are additional numbers...
>
> John Kanagaraj
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> Disappointment is inevitable, but Discouragement is optional!
>
> ** The opinions and facts contained in this message are entirely mine and
do
> not reflect those of my employer or customers **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Kanagaraj
>   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: Arup Nanda
  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: ORA-01031: insufficient privileges -- from user oracle running

[Guang Mei]

OK, I found the problem. It was due to Bug Number 923077 (see metalink Doc
ID: Note:110901.1).

Guang

On Wed, 3 Sep 2003, Dave Hau wrote:

> Make sure you have the sticky bit set for the oracle executable:
>
> chmod u+s $ORACLE_HOME/bin/oracle
>
> HTH,
> Dave
>
>
>
>
> [EMAIL PROTECTED] wrote:
> > Hi:
> >
> > I have an Oracle 8173 db running on  Solaris 2.8 box (called rex) and
> > today I found something that I am trying to understand.  When I login to
> > the Unix box as user "oracle" (which I used to install oracle software), I
> > can manaully run svrmgrl, then connect as "internal", I can do "startup"
> > and "shutdown immediate" with no problem. I have been doing this for
> > years.
> >
> > But if I still log in as "oracle", at unix prompt I do:
> >
> > rex$ which dbstart
> > /oracle/product/8.1.7/bin/dbstart
> > rex$ dbstart
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 3 20:57:16 2003
> >
> > (c) Copyright 2000 Oracle Corporation.  All rights reserved.
> >
> > connect internalORA-01031: insufficient privileges
> > connect internal
> > Database "YPD" warm started.
> > rex$ ps -ef|grep oracle
> >   oracle  2268 1  0 16:54:27 ?0:00
> > /oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
> >   oracle 11195 11152  0 20:57:26 pts/20:00 grep oracle
> >   oracle 11152 11150  0 20:56:19 pts/20:00 -sh
> >
> > I know "dbstart" worked before because it was called by "auto start"
> > script that I put in /etc/init.d/oracle and /etc/rc2.d/S99oracle last
> > year.
> >
> > I also checked /var/opt/oracle/oratab  and environmental variables:
> >
> > rex$ env|grep ORACLE
> > ORACLE_ADMIN=/oracle/admin
> > ORACLE_BASE=/oracle
> > ORACLE_HOME=/oracle/product/8.1.7
> > ORACLE_SID=YPD
> >
> > And they seem working fine (again I can use svrmgrl without any problems).
> >
> > Does anyone know where I should fix so I can start the instance by running
> > script "dbstart"?  TIA.
> >
> > Guang
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dave Hau
>   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: Guang Mei
  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: ORA-01031: insufficient privileges -- from user oracle running

[Dave Hau]

Make sure you have the sticky bit set for the oracle executable:

chmod u+s $ORACLE_HOME/bin/oracle

HTH,
Dave


[EMAIL PROTECTED] wrote:
Hi:

I have an Oracle 8173 db running on  Solaris 2.8 box (called rex) and
today I found something that I am trying to understand.  When I login to
the Unix box as user "oracle" (which I used to install oracle software), I
can manaully run svrmgrl, then connect as "internal", I can do "startup"
and "shutdown immediate" with no problem. I have been doing this for
years.
But if I still log in as "oracle", at unix prompt I do:

rex$ which dbstart
/oracle/product/8.1.7/bin/dbstart
rex$ dbstart
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 3 20:57:16 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

connect internalORA-01031: insufficient privileges
connect internal
Database "YPD" warm started.
rex$ ps -ef|grep oracle
  oracle  2268 1  0 16:54:27 ?0:00
/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
  oracle 11195 11152  0 20:57:26 pts/20:00 grep oracle
  oracle 11152 11150  0 20:56:19 pts/20:00 -sh
I know "dbstart" worked before because it was called by "auto start"
script that I put in /etc/init.d/oracle and /etc/rc2.d/S99oracle last
year.
I also checked /var/opt/oracle/oratab  and environmental variables:

rex$ env|grep ORACLE
ORACLE_ADMIN=/oracle/admin
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/product/8.1.7
ORACLE_SID=YPD
And they seem working fine (again I can use svrmgrl without any problems).

Does anyone know where I should fix so I can start the instance by running
script "dbstart"?  TIA.
Guang




--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dave Hau
 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: Re: "Application DBA"

[M Rafiq]

William, I did my OCP because of the same reason. My student was given 
preference by one recruiter who did OCP and my resume kept on a side because 
I was not OCP. My 10 years experience in 1998 was not counted agianst 1 year 
experience + OCP of my student.

Yes, this happened in USA. Now a days I got a short term assignment because 
I am OCP 9i and US Citizen(because client is defence contractor).

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 03 Sep 2003 10:59:27 -0800
[EMAIL PROTECTED]  scribbled on the wall in glitter crayon:

> more and more employers are requiring OCPs and 'related degrees' such
> as computer science or a masters degree. At least in the US they are.
> How are things in other parts of the world?
that they are and experience doesn't seem to count either.  i was refused
interviews for a number of jobs because i have neither a degree or an OCP.
and while interviewed for others, they hired someone with a degree [in one
case a degree in history] and no experience.  i even had one place come back
to me a couple of months after not hiring me, asking if i would work for
them as a contractor to clean up the mess the person they did hire made.  i
had just taken this contract at the time so i graciously refused.;-)
--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

Science is a wonderful thing if one does not have to earn one's living at
it. - Albert Einstein
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thater, William
  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).
_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

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

ORA-01031: insufficient privileges -- from user oracle running

[Guang Mei]

Hi:

I have an Oracle 8173 db running on  Solaris 2.8 box (called rex) and
today I found something that I am trying to understand.  When I login to
the Unix box as user "oracle" (which I used to install oracle software), I
can manaully run svrmgrl, then connect as "internal", I can do "startup"
and "shutdown immediate" with no problem. I have been doing this for
years.

But if I still log in as "oracle", at unix prompt I do:

rex$ which dbstart
/oracle/product/8.1.7/bin/dbstart
rex$ dbstart

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Sep 3 20:57:16 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

connect internalORA-01031: insufficient privileges
connect internal
Database "YPD" warm started.
rex$ ps -ef|grep oracle
  oracle  2268 1  0 16:54:27 ?0:00
/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
  oracle 11195 11152  0 20:57:26 pts/20:00 grep oracle
  oracle 11152 11150  0 20:56:19 pts/20:00 -sh

I know "dbstart" worked before because it was called by "auto start"
script that I put in /etc/init.d/oracle and /etc/rc2.d/S99oracle last
year.

I also checked /var/opt/oracle/oratab  and environmental variables:

rex$ env|grep ORACLE
ORACLE_ADMIN=/oracle/admin
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/product/8.1.7
ORACLE_SID=YPD

And they seem working fine (again I can use svrmgrl without any problems).

Does anyone know where I should fix so I can start the instance by running
script "dbstart"?  TIA.

Guang


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  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: DBI in activestate perl

[Jared . Still]

This may or may not work depending on which version of Perl that you install.

If you installed Perl 5.8, you can't install DBD::Oracle from ActiveState.

ActiveState seems to be in a bit of disarray in this regard.  There are numerous
modules for which I have had to hack the PM so that I could install them.

Some I just could not install at all.  I think it was the Crypt::RC4 module that I
recently had to install from CPAN source on Windows, this due to using Perl 5.8.

The ppm.activestate.com site has a list of modules that have passed testing
for 5.8, but many are not available via PPM.

I try to do as much admin work from linux as is possible, and avoid the Windoze pain.

Jared









Pete Finnigan <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 10:29 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: DBI in activestate perl


Hi Mladen

Jared and Andy's book "Perl for Oracle DBA's" has an excellent chapter
all about getting DBD and DBI and installing from source and binary.
basically for ActiveState you can use the "ppm" utility run it from a
DOS window and type 

c:\> ppm
ppm> install DBI
ppm> install DBD-Oracle8

Jared's book shows DBD-Oracle8, i guess it should be Oracle9 now?

hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  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: A basic replication question

[Odland, Brad]

Some issues to think about here:

Do they really need all the data from production?
Or are they just saying that without any justification...

Do they know what questions they are going to ask?
Or is this a fishing expedition.

Are they going to understand ad-hoc development will continue to not occur
in production?

Do they understand the complexity and cost associated this what they are
asking for?
And can they justify the resource requirements and cost with a ROI study?

Are these request coming from users or management?

Did someone recently go to some buiness intelligence conference?

Anyone download some sexy new query tool?

How many users is "quite a few"?

Frankly Walt I would be careful about opening that "ad-hoc" door. the next
thing you will have is a real CF on your hands and lots of regrets.

I would aim for a data mart and extracting the information needed for
specific uses that have actual business value. Charge them to give specific
examples that are valuable to the company.

Unless of course this is a true vendor-customer relationship and they are
going to pay actual money for this. Then sell away...If it is an internal
"customer" then I would be cautious.

Having said that you can make a copy of the database during backups and use
to create a new instance of the same db. We do that here. Catch is all that
work and disk space goes unused. because the users "need" real time data
access for thier ad-hoc activity and reports...

Brad O.



-Original Message-
Sent: Wednesday, September 03, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L


Okay, we have a request for quite a few of our customers for read-only
copies of their databases they can do their ad-hoc queries on. These
read-only databases need to as closely matched to the production
database as possible, i.e., exact, from their point of view.

I've looked into some options to do this. Since we're going to 9i fairly
soon I was thinking of setting up logical standbys, but I've read some
pretty bad things about logical standbys -- typical new buggy Oracle
product.

I've also started into looking at basic replication: maybe just simple
updateable snapshots refreshed every now and then. 

So, for the past couple of days I've gone through Metalink, Technet, and
the mail archives on Oracle-l trying to learn about simple, basic,
readonly replication.

The problem is, all of the manuals, white papers, etc. I've found don't
deal with how to set up and administer simple basic replication. It's
all mixed in with multi-master replication, Advanced Replication, and
stuff like that.

I'm new to replication and would like to basically start learning the
basics for basic replication, basically.

Can anyone point me to a document that talks about basic read-only
replication only? Or am I fooling myself into thinking there is such a
thing?

Thanks,
--Walt Weaver
  Bozeman, Montana
-- 
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: Odland, Brad
  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 on Win2000

[Farnsworth, Dave]

Hammer, screwdriver and duct tape.
 
;o)

  -Original Message-From: Bala Regupathy 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  12:44 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000
  First time I have got to maintain Oracle 
  databases on Win 2000 server.  What tools do you guys use to 
  get to the server to admin oracle databases ?
   
  Thanks,
   
  Bala.

Re: DBI in activestate perl

[Pete Finnigan]

Hi Mladen

Jared and Andy's book "Perl for Oracle DBA's" has an excellent chapter
all about getting DBD and DBI and installing from source and binary.
basically for ActiveState you can use the "ppm" utility run it from a
DOS window and type 

c:\> ppm
ppm> install DBI
ppm> install DBD-Oracle8

Jared's book shows DBD-Oracle8, i guess it should be Oracle9 now?

hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  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: Urgent INFO needed.

[Orr, Steve]

> part of the problem is that very few people can write decent 
> specs - because in any creative process, and software 
> engineering is one, you only converge towards the result 
> through several iterations

Good point. If folks speaking the same language aren't communicating
well how much more of a challenge is it when there is a language
barrier?! Regarding clear specs, here's one of my keeper links about
what it takes to write perfect software:
http://www.fastcompany.com/online/06/writestuff.html


Steve Orr



-Original Message-
Sent: Wednesday, September 03, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L
Importance: High


I disagree about the 'you get what you pay for'. I have been reviewing
in the past weeks code written both in Bangalore and in Paris, and in
both cases I have had to reach for my Prozac box. For what had been
written in France, it is the product of a big (US) consulting firm which
must have been retrospectively happy to change their name a couple of
years ago; note that it is in no way specific of them, I can exhibit
dreadful code from multiple sources. I can assure you that it was both
bad and expensive. Concerning what you pay for, I believe that whatever
you outsource is far from being as cheap as it looks like; part of the
problem is the existence of a contract, part of the problem is indeed
the developers, part of the problem is that very few people can write
decent specs - because in any creative process, and software engineering
is one, you only converge towards the result through several iterations
(just look at famous manuscripts or Old Masters X-ray pictures), and
that interaction with end-users is essential.

Which means that I agree with the conclusion :-). 

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  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: Does the 9iR2 Installer delete patch files?

[Mladen Gogala]

Oracle Untested Infuriator strikes again.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Jesse, Rich
Sent: Wednesday, September 03, 2003 11:54 AM
To: Multiple recipients of list ORACLE-L


Hey all,

During the instal of 9iRAC on RH9, the instructions say to install the
9.2.0.1 software, then apply the 9.2.0.4 patch separately to the Installer,
OCM, and finally to the RAC software itself.  This is my second time through
and both times there were files in the cpio-exploded patch that had
disappeared somewhere between the patching of the Installer and the RAC
software.  This time I kept the cpio file of the patch so I didn't need to
download it again.

I should probably have taken down some of the names of the files that came
up as "File not found" errors during the RAC install, but there were so many
during my first install, I figured I had accidentally "rm"d a directory.

Anyone know what's up with the Installer?  "Or is it just me?" he axes,
praying for the former...

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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 on Win2000

[Tony Johnson]

Depending on the size of your databases OEM and its Tuning Pack may work 
very well for you.

  -Original Message-From: Bala Regupathy 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  10:44 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000
  First time I have got to maintain Oracle 
  databases on Win 2000 server.  What tools do you guys use to 
  get to the server to admin oracle databases ?
   
  Thanks,
   
  Bala.

RE: Re: "Application DBA"

[cornichepark]

Back in India, the academic qualification is weighed more than anything
else.  Guys from institutes like Indian Institute of Technology IITs
/ Indian Institue Management (IIT/IM) (to quote an example) are treated as
demi-godes and look at with awe (even if the guy doesn't know anything
about Oracle). For that matter i have worked with both the category.
Currently i have few such people working with me and the guys are average
except one.

The problem with these guys is not lack of potential, but they do not
apply themselves in their chosen profession.  One cannot sit back on
past laurels (Surprisingly Indian market looks only at that).
In this profession, things keep changing every day and one has
to keep himself/herself. So what if someone is qualified.
I have come across some DBAs who are just graduates but who
can take on the best. Period.  I for that matter was not getting
calls for interviews till i forced myself to clear OCP.  Indian
market atleast expects some of the following:
Academic qual / Certification / H1B  (not necessarily in that order).
If you have H1B or you are already in US they care a damn for your
qualification. Because they can market you and can get some commission.

I have seen situations where a graduate with 10-12 yrs exp (like the
guys i quoted above who have solid exp. in Application/DBA/Languages)
simply bypassed and some other joker with no relevant exp but is from
IIT/IIM chosen for the post of Tech.Lead. Strange but true.

GovindanK

> [EMAIL PROTECTED]  scribbled on the wall in glitter crayon:
>
>> more and more employers are requiring OCPs and 'related degrees' such
>> as computer science or a masters degree. At least in the US they are.
>> How are things in other parts of the world?
>
> that they are and experience doesn't seem to count either.  i was refused
> interviews for a number of jobs because i have neither a degree or an OCP.
> and while interviewed for others, they hired someone with a degree [in one
> case a degree in history] and no experience.  i even had one place come
> back
> to me a couple of months after not hiring me, asking if i would work for
> them as a contractor to clean up the mess the person they did hire made.
> i
> had just taken this contract at the time so i graciously refused.;-)
>

-- 
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: Oracle survey

[Goulet, Dick]

Humm,  Looks like a fishing expedition to catch additional revenue.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, September 03, 2003 4:40 PM
To: Multiple recipients of list ORACLE-L


Someone asked about EMS, Oracle posted this:

http://infopoll.net/live/surveys/s23243.htm


Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice 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).
-- 
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: Oracle Masters exam

[Pete Sharman]

And having sat through the beta of the masters exam, let me reiterate
what Reichert said in the article.  You really do have to have the hands
on experience to pass it.  I've been using Oracle for something like 15
years now, and training others in the DBA world for 11 or so of those 12
years, and this was the hardest exam I've ever sat through.


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Boivin, Patrice J
Sent: Thursday, September 04, 2003 6:45 AM
To: Multiple recipients of list ORACLE-L


Oracle Mag has something about the Oracle Masters program...

http://otn.oracle.com/oramag/oracle/03-sep/o53news.html

Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  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: test

[Daniel Fink]

fail

Babette Turner-Underwood wrote:

> test
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Babette Turner-Underwood
>   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).
begin:vcard 
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel  W. Fink
end:vcard

Re: test

[AK]

fail
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 3:04 PM


> test
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Babette Turner-Underwood
>   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: Urgent INFO needed.

[Stephane Faroult]

Freeman Robert - IL wrote:
> 
> Actually, I've seen the reverse be true. I've seen the work offshore be so
> poor that more folks are brought in locally to correct the problems, yet the
> offshore remain too because of contractual issues. Happened to me on at
> least two different occations. You get what you pay for. There are some
> great Indian DBA's out there (KG for one is awsome), but just as in America,
> for every great one there are probably 5 that should take up some other
> profession. This will come and go like everything else.
> 
> RF

I disagree about the 'you get what you pay for'. I have been reviewing
in the past weeks code written both in Bangalore and in Paris, and in
both cases I have had to reach for my Prozac box. For what had been
written in France, it is the product of a big (US) consulting firm which
must have been retrospectively happy to change their name a couple of
years ago; note that it is in no way specific of them, I can exhibit
dreadful code from multiple sources. I can assure you that it was both
bad and expensive.
Concerning what you pay for, I believe that whatever you outsource is
far from being as cheap as it looks like; part of the problem is the
existence of a contract, part of the problem is indeed the developers,
part of the problem is that very few people can write decent specs -
because in any creative process, and software engineering is one, you
only converge towards the result through several iterations (just look
at famous manuscripts or Old Masters X-ray pictures), and that
interaction with end-users is essential.

Which means that I agree with the conclusion :-). 

-- 
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: Oracle Standby Database Backups.

[Indy Johal]

Tom

As long as 

your standby database is Physical Standby DB [ Not for Logical Standby Database where you also need to take the standby database backup]
If the Database size is very big [ Not even in TB but few hundred GB ],
If the Database is 24*7
If the Network connection is good [ We are not using this for some of the Server that are in remote location as Disaster recovery Server and Network connection is not good]

It is good idea to perform the Oracle Backup thru RMAN on Standby Database as this way you can avoid any Resource issue on the Primary Database.Arup has already pointed out the detailed benefits. We are using this for lots of big databases.


Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com

(201) 946-5687 [W]
(201) 400-3960 [M]

"We tell your story to the world."






"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/03/03 03:04 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Oracle Standby Database Backups.


Tom,
 
You should perform backups from the Standby database, regular RMAN backups, no need to shutdown the database. Make sure you backup the archived log files from there too. Contrary to what the docs might _imply_, I use the word "imply" rather than "state", since the docs have been kind of ambiguous, the archivedlog backups from the standby are perfectly alright to be used for recoveries..
 
You could use the RMAN backup on the primary, but why? You would rather want to offload the CPU cycles for RMAN to the standby database. In case of a failure in the primary, your first option is to get the files from standby and recover them. If standby is down too (as in case of a complete disaster), you would reinstate the standby backup files to primary and you will be ok.
 
We are using it to backup out 7 TB OLTP database.
 
HTH.
 
Arup
- Original Message - 
From: Mercadante, Thomas F 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, September 03, 2003 2:29 PM
Subject: Oracle Standby Database Backups.

All,

We are in the beginning stages of designing a database with Oracle Standby capability.  The initial size of the database will be 600-800 Gig.  The proposed database will be run on a IBM P690 with a mirrored fail-over machine.  Two separate machines with separate disk.  We are considering using Oracle Standby to have the database available as much as possible.
 
Do I need to perform regular backups of the Standby database?  Sounds like a silly question, but how do I do this?  Using Rman?  Or do I shut it down and perform a cold backup?  I will definitely use Rman on the primary database.  Just curious what you all would suggest.
 
Thanks in advance!
Tom Mercadante 
Oracle Certified Professional 
 

RE: RAC 9i database - gx$ views ?

[Mladen Gogala]

No, those are XXX$ views.

--
Mladen Gogala
Oracle DBA 



-Original Message-
Browett, Darren
Sent: Wednesday, September 03, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L


I know there is the gv$ views which are the cluster wide equivialent of the
v$ views, but is there any gx$ views where are equivalent to the x$ views
???

Thanks

Darren


--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  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).




Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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 World - Listers get together (proposed Tuesday Sep 9)

[Indy Johal]

John

I am also going to join everybody after finishing mine Presentation which is also scheduled on Tuesday from 5:30-6:30pm

Thanks

Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com

(201) 946-5687 [W]
(201) 400-3960 [M]

"We tell your story to the world."






John Kanagaraj <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/03/03 05:54 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Oracle World - Listers get together (proposed Tuesday Sep 9)


Hi all,

We talked about this earlier and I wanted to get this mail out before
everyone participating departs for OOW. I would propose a Lister's
get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed
has the 'OracleWorld Appreciation day' in the evening and I am assuming
there will be felicatations for Arup and Mogens at this time... (and Thu
ends it all).

I have the following that have responded (in no particular order): Arup
Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey last
time?), Connor McDonald (all the way from Down under!), Greg Loughmiller,
Matthew Zito, Molina Gerardo and self.

We will meet over Dinner at a restaurant across the street from Moscone
Center - probably from about 6:30PM? The address is:

Chevy's
201 3rd Street (corner of 3rd and Howard)
San Francisco, CA 94105
415-543-8060

I will send out a reminder email closer to that time (like Monday :) Let me
know if there are additional numbers...

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional! 

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  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 on Win2000

[Jared . Still]

The primary reason for problems with terminal server is that it is just that - a terminal.

VNC and PcAnywhere actually take control of the console on a Windows machine.

A default Oracle install requires console access for certain things, such as starting
the database from a command line using svrmgrl or sqlplus.

Jared








"Smith, Ron L." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 02:39 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Oracle on Win2000


Be careful using Terminal Server.  If you are running batch jobs, the variables like ORACLE_SID and ORACLE_HOME don't always get picked up correctly by the batch job.  I have spent hours trying to debug a script run with Terminal Server, then switch to VNC and it works fine.
 
Ron Smith
-Original Message-
From: Branimir Petrovic [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 03, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle on Win2000

Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, then install Windows Terminal Client on admin PC). 
Bigger hassle to install and configure, but a LOT better performer than PCAnywhere or VNC (other two "usual suspects" for remoting unremoteable). 
Branimir
 
-Original Message-
From: Bala Regupathy [mailto:[EMAIL PROTECTED]
Sent: September 3, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle on Win2000

First time I have got to maintain Oracle databases on Win 2000 server.  What tools do you guys use to get to the server to admin oracle databases ?
 
Thanks,
 
Bala.

test

[Babette Turner-Underwood]

test
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Babette Turner-Underwood
  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 Standby Database Backups.

[Arup Nanda]

Tom,
 
You should perform backups from the Standby 
database, regular RMAN backups, no need to shutdown the database. Make sure you 
backup the archived log files from there too. Contrary to what the docs might 
_imply_, I use the word "imply" rather than "state", since the docs have been 
kind of ambiguous, the archivedlog backups from the standby are perfectly 
alright to be used for recoveries..
 
You could use the RMAN backup on the primary, but 
why? You would rather want to offload the CPU cycles for RMAN to the standby 
database. In case of a failure in the primary, your first option is to get the 
files from standby and recover them. If standby is down too (as in case of a 
complete disaster), you would reinstate the standby backup files to primary and 
you will be ok.
 
We are using it to backup out 7 TB OLTP 
database.
 
HTH.
 
Arup

  - Original Message - 
  From: 
  Mercadante, Thomas F 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 03, 2003 2:29 
  PM
  Subject: Oracle Standby Database 
  Backups.
  
  All,
  We are in the beginning stages 
  of designing a database with Oracle Standby capability.  The initial size 
  of the database will be 600-800 Gig.  The proposed database will be run on a IBM P690 with a 
  mirrored fail-over machine.  Two separate machines with separate 
  disk.  We are considering 
  using Oracle Standby to have the database available as much as 
  possible.
   
  Do I need to perform regular backups of the Standby database?  
  Sounds like a silly question, but how do I do this?  Using Rman?  Or 
  do I shut it down and perform a cold backup?  I will definitely use Rman 
  on the primary database.  Just curious what you all would 
  suggest.
   
  Thanks in advance!
  Tom Mercadante Oracle Certified Professional 
   

Oracle World - Listers get together (proposed Tuesday Sep 9)

[John Kanagaraj]

Hi all,

We talked about this earlier and I wanted to get this mail out before
everyone participating departs for OOW. I would propose a Lister's
get-together on the evening of Tuesday Sep 9. Monday is the first day, Wed
has the 'OracleWorld Appreciation day' in the evening and I am assuming
there will be felicatations for Arup and Mogens at this time... (and Thu
ends it all).

I have the following that have responded (in no particular order): Arup
Nanda, Jonathan Gennick, Matthew Adams, Brian McGraw, Ari Kaplan, Cary
Millsap (+ other Gurus - Cary brought along Tom Kyte and Kyle Hailey last
time?), Connor McDonald (all the way from Down under!), Greg Loughmiller,
Matthew Zito, Molina Gerardo and self.

We will meet over Dinner at a restaurant across the street from Moscone
Center - probably from about 6:30PM? The address is:

Chevy's
201 3rd Street (corner of 3rd and Howard)
San Francisco, CA 94105
415-543-8060

I will send out a reminder email closer to that time (like Monday :) Let me
know if there are additional numbers...

John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional! 

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  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 Masters exam

[Boivin, Patrice J]

Oracle Mag has something about the Oracle Masters program...

http://otn.oracle.com/oramag/oracle/03-sep/o53news.html

Patrice.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice 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: Oracle Enhancement Request System

[Arup Nanda]

Title: Oracle Enhancement Request System



Raj,
 
The new enhancement system is inside Metalink now. 
When you want to open an ER, just open an iTAR, but in the drop down field named 
Type of TAR, choose "Enhancement Request".
 
Thanks.
 
Arup

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, September 02, 2003 1:34 
  PM
  Subject: Oracle Enhancement Request 
  System
  
  Does anyone have the URL handy ?? I have 
  managed to misplace mine. 
  TIA 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 ! 

Re: Urgent INFO needed.

[Ryan]

i dont think so. There is too much money in this. Odds are they will refine
their processes 'slowly' improve. Over a period of years they will be
better. Will it always be as good as the US? No, but it doesnt need to be.
Its cheap. This doesnt mean every IT job will dissapear, but there is a
contraction in the market and it is continueing..

Those manufacturing jobs sent to sweat shops never came back due to lack of
quality? No I dont think the IT market will dissapear, however, I think
wages will continue to decline at least for a while. Most of the jobs out
there these days are low paying, short temp jobs.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 5:29 PM


> Actually, I've seen the reverse be true. I've seen the work offshore be so
> poor that more folks are brought in locally to correct the problems, yet
the
> offshore remain too because of contractual issues. Happened to me on at
> least two different occations. You get what you pay for. There are some
> great Indian DBA's out there (KG for one is awsome), but just as in
America,
> for every great one there are probably 5 that should take up some other
> profession. This will come and go like everything else.
>
> RF
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 9/3/2003 3:44 PM
>
> That is call mondialisation...
>
>
>
> Stephane Paquette
>
>
> Administrateur de bases de donnees
>
> Database Administrator
>
> Standard Life
>
> www.standardlife.ca
>
> Tel. (514) 499-7999 7470 and (514) 925-7187
>
> [EMAIL PROTECTED]
> 
>
> -Original Message-
> Tony Johnson
> Sent: Wednesday, September 03, 2003 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> All I know about it is that for every new job in India one more DBA is
> out of work here in the United States.
>
> -Original Message-
> Sent: Wednesday, September 03, 2003 5:30 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Dear Friends,
>
> One of my friends has got the offer from CSC india ltd. Please respond
> this mail if any one from CSC india ltd? just to know some info , thats
> it.
>
> Any info regarding this is appreciated. Please give me your mail id and
> contacts..
>
> Thanks a lot.
>
> Regards
>
> Oracle DBA
>
>
>
>   _
>
> Do you Yahoo!?
> Yahoo!  
> SiteBuilder - Free, easy-to-use web site design software
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
>   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: Ryan
  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 on Win2000

[Smith, Ron L.]

Title: Message



Be 
careful using Terminal Server.  If you are running batch jobs, the 
variables like ORACLE_SID and ORACLE_HOME don't always get picked up correctly 
by the batch job.  I have spent hours trying to debug a script run with 
Terminal Server, then switch to VNC and it works fine.
 
Ron 
Smith

  
  -Original Message-From: Branimir 
  Petrovic [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 
  2003 4:14 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Oracle on Win2000
  
  Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, 
  then install Windows Terminal Client on admin PC). 
  Bigger hassle to install and 
  configure, but a LOT better performer than PCAnywhere or VNC (other two "usual 
  suspects" for remoting unremoteable). 
  Branimir
   
  
-Original Message-From: Bala Regupathy 
[mailto:[EMAIL PROTECTED]Sent: September 3, 2003 1:44 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle on Win2000
First time I have got to maintain Oracle 
databases on Win 2000 server.  What tools do you guys use to 
get to the server to admin oracle databases ?
 
Thanks,
 
Bala.

RE: Re: "Application DBA"

[Mercadante, Thomas F]

Bill,

Did you point out to them how *freekin wrong* they had been?!?!?!?!  I would
not have been able to resist the free shot.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 03, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L


[EMAIL PROTECTED]  scribbled on the wall in glitter crayon:

> more and more employers are requiring OCPs and 'related degrees' such
> as computer science or a masters degree. At least in the US they are.
> How are things in other parts of the world? 

that they are and experience doesn't seem to count either.  i was refused
interviews for a number of jobs because i have neither a degree or an OCP.
and while interviewed for others, they hired someone with a degree [in one
case a degree in history] and no experience.  i even had one place come back
to me a couple of months after not hiring me, asking if i would work for
them as a contractor to clean up the mess the person they did hire made.  i
had just taken this contract at the time so i graciously refused.;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

Science is a wonderful thing if one does not have to earn one's living at
it. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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: Mercadante, Thomas F
  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: Future demand for DBAs

[Freeman Robert - IL]

>> They estimate that by 2010, a quarter of the IT workforce will be over
>> 55 years old.

Heck, thats true now in the mainframe world I think.

RF
 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/3/2003 8:54 AM

The META Group has released a study that forecasts increased demand for
DBAs
in the future. They quote the U.S. Department of Labor's Bureau of Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two
factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over
55
years old.
The new features to make databases self-managing will only help with
lower
value labor intensive tasks such as schema changes and performance
tuning,
not with higher value skills such as design and troubleshooting.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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: Freeman Robert - IL
  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 on Win2000

[Branimir Petrovic]

Windows Terminal services that comes with Windows (in Control Panel, Add/Remove Programs, Add/Remove Windows Components, 
then install Windows Terminal Client on admin PC). 
Bigger hassle to install and 
configure, but a LOT better performer than PCAnywhere or VNC (other two "usual 
suspects" for remoting unremoteable). 
Branimir
 

  -Original Message-From: Bala Regupathy 
  [mailto:[EMAIL PROTECTED]Sent: September 3, 2003 1:44 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000
  First time I have got to maintain Oracle 
  databases on Win 2000 server.  What tools do you guys use to 
  get to the server to admin oracle databases ?
   
  Thanks,
   
  Bala.

RE: Urgent INFO needed.

[Freeman Robert - IL]

Actually, I've seen the reverse be true. I've seen the work offshore be so
poor that more folks are brought in locally to correct the problems, yet the
offshore remain too because of contractual issues. Happened to me on at
least two different occations. You get what you pay for. There are some
great Indian DBA's out there (KG for one is awsome), but just as in America,
for every great one there are probably 5 that should take up some other
profession. This will come and go like everything else.

RF

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/3/2003 3:44 PM

That is call mondialisation...
 
 

Stephane Paquette


Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]
 

-Original Message-
Tony Johnson
Sent: Wednesday, September 03, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


All I know about it is that for every new job in India one more DBA is
out of work here in the United States.

-Original Message-
Sent: Wednesday, September 03, 2003 5:30 AM
To: Multiple recipients of list ORACLE-L



Dear Friends, 

One of my friends has got the offer from CSC india ltd. Please respond
this mail if any one from CSC india ltd? just to know some info , thats
it. 

Any info regarding this is appreciated. Please give me your mail id and
contacts.. 

Thanks a lot. 

Regards 

Oracle DBA



  _  

Do you Yahoo!?
Yahoo!  
SiteBuilder - Free, easy-to-use web site design software

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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: Re: "Application DBA"

[Ryan]

im going with the flow. doing a Masters(company is paying for it) and doing
my OCP. Ill probably go cert happy over time... do java,solaris, etc... I
know for a fact not having a computer science degree hurt me. I was told it.
So if employers want something, Ill give it to them. As long as a company
has tuition reimbursement, I dont see why not to use it? Im going to grad
school for free.

Gotta give people what they want. btw, Im learning alot of useful stuff in
school. It does not make up for experience, but its very helpful.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 4:19 PM


> Bill,
>
> Did you point out to them how *freekin wrong* they had been?!?!?!?!  I
would
> not have been able to resist the free shot.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Wednesday, September 03, 2003 2:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> [EMAIL PROTECTED]  scribbled on the wall in glitter crayon:
>
> > more and more employers are requiring OCPs and 'related degrees' such
> > as computer science or a masters degree. At least in the US they are.
> > How are things in other parts of the world?
>
> that they are and experience doesn't seem to count either.  i was refused
> interviews for a number of jobs because i have neither a degree or an OCP.
> and while interviewed for others, they hired someone with a degree [in one
> case a degree in history] and no experience.  i even had one place come
back
> to me a couple of months after not hiring me, asking if i would work for
> them as a contractor to clean up the mess the person they did hire made.
i
> had just taken this contract at the time so i graciously refused.;-)
>
> --
> Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
> [EMAIL PROTECTED]
> 
> Science is a wonderful thing if one does not have to earn one's living at
> it. - Albert Einstein
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Thater, William
>   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: Mercadante, Thomas F
>   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: Ryan
  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: RAC 9i database - gx$ views ?

[Jacques Kilchoer]

> -Original Message-
> From: Browett, Darren [mailto:[EMAIL PROTECTED]
> 
> I know there is the gv$ views which are the cluster wide 
> equivialent of
> the v$ views,
> but is there any gx$ views where are equivalent to the x$ views ???

I don't think so, but does the source code for a RAC view show any gx$ views?
for example, what does this show you?
select * from v$fixed_view_definition where view_name = 'V$PING' ;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  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: alter system reset

[Ron Rogers]

Ian, 
That is a very good point to remember. Sounds like the voice of
experience.
Thanks for the tip.
Ron

>>> [EMAIL PROTECTED] 09/03/03 03:34PM >>>
Is the want to read the spfile just a curiosity?  One should not rely
on either the init.ora or the spfile to determine which parameters are
set, but should query the database.  

Now that we have both init.ora and an spfile someone is going to get
caught.  For instance a patch requirement requires 150 MB shared_pool
and java_pool sizes and warns about an unrecoverable memory error if the
pools are undersized.  The person dutifully makes the changes to the
init.ora and starts the database, but forgets that an spfile is being
used with the database  He then starts the patch and it fails with the
unrecoverable memory error.

I would have been caught by this if my patchset installation procedure
did not include "show parameter"  to verify their settings.

Ian MacGregor  
Stanford Linear Accelerator Center
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, September 01, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Prem,

The SPFILE should never be opened to be modified; opening a file to see
the contents are acceptable and that's what I said. Sometimes opening
the file in an editor may not be needed; "type" in Windows command
prompt or "cat" in unix will let us achive the same objective.

Talking about the SPFILE modification, you can't effectively modify it
with accuracy. The file is binary (actually binary in the beginning and
then text towards the bottom part), so even if you open it in notepad
and save it, there is no guarantee that the file will be accurately
saved with all contents intact.

By the way, I have edited the SPFILE in some cases, only in
development, though; but I wouldn't advise it to be done that way;
always use ALTER SYSTEM ... SCOPE=SPFILE to modify it or edit the
init.ora file and then create the SPFILE from it. You can create the
spfile from pfile even when the instance is down.

HTH.

Arup

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 10:49 PM


> Arup Bhai, i remember oracle docs saying NOT to open a spfile and
that 
> it
may even
> corrupt the file.
>
> Is that always true ?
> Can the spfile be opened ?
> can you kindly explain me ?
>
> Thanks & Regards,
> Prem Khanna J.
>
>
> 02-09-2003 04:14:26, "Arup Nanda" <[EMAIL PROTECTED]> wrote:
> >Does the entry even exist in the SPFILE? Open up the spfile in 
> >notepad
and
> >check the existence of the parameter in there. Do the following:
> >SQL> alter system set undo_suppress_errors = false scope=spfile
sid='ananda';
> >System altered.
> >SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile 
> >SQL> sid='ananda';
> >System altered.
> >Arup
>
>
>
> --
> 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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Arup Nanda
  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: MacGregor, Ian A.
  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

RE: Urgent INFO needed.

[Stephane Paquette]

That 
is call mondialisation...
 
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Tony JohnsonSent: 
  Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of 
  list ORACLE-LSubject: RE: Urgent INFO needed.
  All 
  I know about it is that for every new job in India one more DBA is out of work 
  here in the United States.
  
-Original Message-From: Ora DBA 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
5:30 AMTo: Multiple recipients of list 
ORACLE-LSubject: Urgent INFO needed.
Dear Friends, 
One of my friends has got the offer from CSC india ltd. Please respond 
this mail if any one from CSC india ltd? just to know some info , thats it. 

Any info regarding this is appreciated. Please give me your mail id and 
contacts.. 
Thanks a lot. 
Regards 
Oracle DBA



Do you Yahoo!?Yahoo! 
SiteBuilder - Free, easy-to-use web site design 
software

Oracle survey

[Boivin, Patrice J]

Someone asked about EMS, Oracle posted this:

http://infopoll.net/live/surveys/s23243.htm


Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice 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: more questions

[cornichepark]

Check with
http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548

Make sure to shutdown/start related stuff (viz OAS) that might have been
installed too.

Also, on some UNIX systems, NFS file system from Server A  might have been
mounted on Server B. If so, you need to shutdown the database first,
umount the file system, then shutdown. Upon starting Server, the bootstrap
script to mount the file system (share it), followed by starting of the
database.  You can modify the script in such a way that, if the FS is
not mounted, page the DBA, donot start the Database.

Also, the shutdown script normaly has SHUTDOWN ; change it to SHUTDOWN
IMMEDIATE / SHUTDOWN ABORT depending on what you prefer.

HTH

GovindanK

>Hi Greetings,
>
> We are using solaris. I wonder how to startup oracle after machine
> is bootup and how to shutdown oracle before unix is shutdown?
> I know how to multiplex control files and redo files. It seems to
> me that I cannot multiplex data files. Is that true?
>
> Thanks!
> Jin
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: CHEN,JIN
>   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: Future demand for DBAs

[Ron Rogers]

by the time 2010 rolls around I will be on FULL social Security.

The numbers were not given but the percentages were. 66% increase in
the DBA's and 25% of the workforce will be over 55. Is that 25% of the
66% that are DBA's or is it 66% of the 25% that are DBA's?

Rom mª¿ªm

>>> [EMAIL PROTECTED] 09/03/03 02:54PM >>>
"They estimate that by 2010, a quarter of the IT workforce will be over
55
years old."

Well, I don't know about that, but one of those old fogies is right
here!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, September 03, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


The META Group has released a study that forecasts increased demand for
DBAs
in the future. They quote the U.S. Department of Labor's Bureau of
Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two
factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over
55
years old.
The new features to make databases self-managing will only help with
lower
value labor intensive tasks such as schema changes and performance
tuning,
not with higher value skills such as design and troubleshooting.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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).
-- 
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).

RE: sqlload

[Mercadante, Thomas F]

John,

I didn't say that a parameter file can't be used.  The correct syntax is
"control=", not "parfile=".

And I agree about postings.  I posted that message yesterday at around noon.
FInally showed up today.  But my email server is flaky.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, September 03, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L


Tom,
I am afraid you are wrong there, a parameter file can be used to run a
sqlloader script

The syntax that Fawzia uses is correct although as per imp/exp it would be
better to put all the parameters in the parfile file 

I spent years not knowing that and in frustration posted to the list and was
immediately shown how to do it

Interesting  to see if this reply makes it to the list as the last one I
posted about 2 hours ago never got there.

John


-Original Message-
Sent: 02 September 2003 19:05
To: Multiple recipients of list ORACLE-L


Fawzia,

Try the following (change parfile= to control=)

sqlldr control=pants.ctl log=me.log

parfile is for imp/exp.

Good Luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 02, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L



PLEASE Can someone help??I have a sqlloader control file below and I am
getting the following error when I run it and I just cant see what is
wrong!!!

Rgds

Fawzia
[EMAIL PROTECTED]> sqlldr parfile=pants.ctl log=me.log
LRM-00110: syntax error at 'LOAD'
LRM-00113: error when processing file 'pants.ctl'

Control file:


LOAD DATA
INFILE  'gazza2.csv'
APPEND
INTO TABLE olsr10_tlmif2.gazetteer1
fields terminated by ','
trailing nullcols
(postcode_prefix_spaced char,
filler1 char,
postcode_prefix char,
filler2 char,
postcode_range char,
filler3 char,
town char,
filler4 char,
county char,
valid_date char)


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Malik, Fawzia
  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: Mercadante, Thomas F
  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: Hallas, John, Tech Dev
  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: Mercadante, Thomas F
  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).

rename data file on standby database

[Kader Ben]

Hi Listers, 

I have standby database working fine (until now!). I
have renamed one datafile on the primary database and
I'm wondering if I have to do the same thing on the
standby database to reflect the structure change. 
I have renamed the file yesterday and the standby
database stil recovering incoming archives without any
error but the data file renamed on the primary
database is on the its original location on the
standby database. 

Many thanks for your help, 

Kader 



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kader Ben
  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: decode

[Stephane Faroult]

Imran Ashraf wrote:
> 
> Hi,
> 
> I have this query...
> select decode(length(sn),8),substr(sn,-7),sn )from .
> 
> However i want to change it so that if the length of sn is >= 8 then set sn
> to last 7 characters.
> 
> How can i implement this?
> 
> Regards
> --
 
   decode(sign(length(sn) - 8, 1, ..., 0, ..., sn)

-- 
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: ORA-16014

[Stephane Faroult]

Saira Somani-Mendelin wrote:
> 
> Received this alert minutes ago. There is no disk space shortage.
> 
> What else can I check for?
> 
> ORA-16014: log 2 sequence# 6362 not archived, no available destinations
> ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log'
> ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log'
>  ORA-16014: log 2 sequence# 6362 not archived, no available destinations
> ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log'
> ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log'
> 
> Any help is greatly appreciated.
> 
> Thanks,
> Saira
> 

Check in v$parameter what is specified as archiving destination. A link
may have disappeared.

-- 
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: C program won't run in 9.0.2.3

[Ruth Gramolini]

Thanks, Peter! 
We have solved the problem now.  Glad for the help, tho!

Regards,
Ruth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Pete Finnigan
> Sent: Monday, September 01, 2003 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: C program won't run in 9.0.2.3
> 
> 
> Hi Ruth
> 
> Try running under truss or equivalent and check what libraries are being
> linked in, maybe you have linked against an incorrect ORACLE_HOME?. 
> 
> Also I have seen a similar issue going from 7.3.4 to 8.0.6 a long time
> back but if I remember correctly it was caused by a previous printf
> statement with incorrect number of format args called before the place
> there was a similar error to yours. We could only assume at the time
> that the different Pro*C libs / calls built a slightly different stack /
> heap and caused the overwrite to happen in a different place between
> versions. 
> 
> It could of course be a bug in Pro*C, check metalink?
> 
> hth
> 
> kind regards
> 
> Pete
> -- 
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see 
> http://store.sans.org for details.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pete Finnigan
>   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: Ruth Gramolini
  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: Future demand for DBAs

[Jesse, Rich]

Yeah, you and running guru Jim Fixx.  Oh wait...

BTW, high alpha-acid beers (from hops) contain xanthohumol.  Xanthohumol is
a type of flavinoid, which is acts as an antioxidant.  Xanthohumol is also
reported to be six times as strong an antioxidant as those found in citris
fruits.

Put down the Bud Light and drink a REAL beer like Three Floyds Alpha King,
Sierra Nevada Pale Ale, Guinness, or Goose Island Honkers Ale.

There's gotta be an "Oracle" hook here somehere...Drink REAL beer at
OracleWorld!


Rich Jesse
President, Beer Ale Lager Lovers Society
http://society.servebeer.com


> -Original Message-
> From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 1:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Future demand for DBAs
> 
> 
> That is precisely why I don't smoke, don't drink, work out 
> and watch what I
> eat.
> I want to be around when the demand goes up. In 2061, I'll be the 1st
> century 
> old DBA in the good ol' US. Life is a bore, but it will be a long one.
> 
> --
> Mladen Gogala
> Oracle DBA 
-- 
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: log buffer space wait

[Avnish.Rastogi]

I have 
one question regarding these wait times, may be dump. In the following wait 
events what is the unit of measurement for Time, I believe its in seconds as per 
the documentation. If yes then here stats 
are collected for only 51.23 Minutes (Appx 3073 seconds), how come 
Oracle is showing 566,516 seconds wait for log buffer space. I would appreciate 
if someone can explain.
 
Thanks
 
 

Top 5 Timed 
Events
~~ 
% Total
Event   
Waits    Time (s) Ela Time
 
 --- 
log buffer 
space    
1,817,258 566,516    
56.24
latch 
free  
2,964,652 334,120    
33.17
log file 
sync  
55,230  43,488 
4.32
buffer busy waits  
62,839  
26,129 2.59
CPU 
time   


  -Original Message-From: VIVEK_SHARMA 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 02, 2003 
  6:39 AMTo: Multiple recipients of list ORACLE-LSubject: 
  log buffer space wait 
  
  At a Benchmark a 
  particular Processing + DML intensive batch Job (Accounts Interest 
  Calculation) is experiencing 
  “log buffer space” wait 
  .
   
  Config 
:-
  On Solaris 9 
  
  Cpu_count = 
  72
  Oracle 
  9.2
  Online Redo logfiles are 
  on a RAID 0+1 Volume (NOT Raw or RAID 1) Log_buffer = 10 M
  $ sar Command Outpuit %wio 
  only about 6 % for Volume containing the redo logfiles
  Database in NOARCHIVELOG 
  mode
   
  Qs. How can we reduce this 
  wait event ? Would RAW / RAID 1 for redo logfiles help ?
  Qs. Could this be a Bug 
  ?
   
  *
  STATSPACK report 
  for
   
  DB 
  Name DB Id    
  Instance Inst Num Release 
  Cluster Host
   --- 
    --- --- 
  BM2 
    3727568246 
  bm2 
  1 9.2.0.3.0   NO  
  sleepy
   
      
  Snap Id Snap Time  
  Sessions Curs/Sess Comment
      
  --- --  - 
  ---
  Begin 
  Snap: 240 01-Sep-03 03:09:41   
  23   1.5
    End 
  Snap: 241 01-Sep-03 04:00:55   
  24   1.7
     
  Elapsed:   
  51.23 (mins)
   
  Top 5 Timed 
  Events
  ~~ 
  % Total
  Event   
  Waits    Time (s) Ela Time
   
   --- 
  log buffer 
  space    
  1,817,258 566,516    
  56.24
  latch 
  free  
  2,964,652 334,120    
  33.17
  log file 
  sync  
  55,230  43,488 
  4.32
  buffer busy waits  
  62,839  
  26,129 2.59
  CPU 
  time   
  22,018 2.19
    
  -
  Wait Events for DB: 
  BM2  Instance: bm2  Snaps: 240 -241
  -> s  - 
  second
  -> cs - centisecond 
  - 100th of a second
  -> ms - millisecond 
  -    1000th of a second
  -> us - microsecond - 
  100th of a second
  -> ordered by wait time 
  desc, waits desc (idle events last)
   
      
     Avg
   
  Total Wait   wait    Waits
  Event   
  Waits   Timeouts   Time (s)   
  (ms) /txn
   
   -- -- -- 
  log buffer 
  space    
  1,817,258    139    
  566,516    312 54.4
  latch 
  free  
  2,964,652    892,594    
  334,120    113 88.8
  log file 
  sync  
  55,230 21,210 
  43,488    787  
  1.7
  buffer busy 
  waits  
  62,839 10,250 
  26,129    416  
  1.9
   
   
  Latch Activity for DB: 
  BM2  Instance: bm2  Snaps: 240 -241
   
     
  Pct    Avg   
  Wait 
  Pct
    
  Get  Get   
  Slps   Time   NoWait 
  NoWait
  Latch   
  Requests  Miss  /Miss    
  (s) Requests   Miss
   
  -- -- -- --  --
  post/wait 
  queue  
  97,357    4.7    0.4    
  577    1,871,155  249.5
  process 
  allocation  
  751    7.2    3.0 
  10  747    
  0.5
  process group 
  creation   

RE: Future demand for DBAs

[Paula_Stankus]

Title: RE: Future demand for DBAs





Again,


Some issues:
-Labor supplied from operations overseas
-Issues of security 
-Issues of plain old communication and the role of a DBA requiring communication
-Cost of moving overseas - certainly can't be afforded by all companies
-"remote" administration - scary - I wouldn't advise having someone do a "remote" recovery too many factors


-Some demand will certainly be dampened by overseas operations but still I think an overall positive gain.  


-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 03, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Future demand for DBAs



That is precisely why I don't smoke, don't drink, work out and watch what I
eat.
I want to be around when the demand goes up. In 2061, I'll be the 1st
century 
old DBA in the good ol' US. Life is a bore, but it will be a long one.


--
Mladen Gogala
Oracle DBA 




-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, September 03, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L



The META Group has released a study that forecasts increased demand for DBAs
in the future. They quote the U.S. Department of Labor's Bureau of Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over 55
years old. The new features to make databases self-managing will only help
with lower value labor intensive tasks such as schema changes and
performance tuning, not with higher value skills such as design and
troubleshooting.


Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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).




Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: Urgent INFO needed.

[Tony Johnson]

All I 
know about it is that for every new job in India one more DBA is out of work 
here in the United States.

  -Original Message-From: Ora DBA 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  5:30 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Urgent INFO needed.
  Dear Friends, 
  One of my friends has got the offer from CSC india ltd. Please respond this 
  mail if any one from CSC india ltd? just to know some info , thats it. 
  Any info regarding this is appreciated. Please give me your mail id and 
  contacts.. 
  Thanks a lot. 
  Regards 
  Oracle DBA
  
  
  
  Do you Yahoo!?Yahoo! 
  SiteBuilder - Free, easy-to-use web site design 
software

RE: decode

[Igor Neyman]

decode(sign(8 - length(sn)), -1, substr(sn,-7), sn )


Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Imran Ashraf
Sent: Wednesday, September 03, 2003 1:00 PM
To: Multiple recipients of list ORACLE-L

Hi,

I have this query...
select decode(length(sn),8),substr(sn,-7),sn )from .

However i want to change it so that if the length of sn is >= 8 then set
sn
to last 7 characters.

How can i implement this?

Regards
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Imran Ashraf
  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: Re: "Application DBA"

[Thater, William]

[EMAIL PROTECTED]  scribbled on the wall in glitter crayon:

> more and more employers are requiring OCPs and 'related degrees' such
> as computer science or a masters degree. At least in the US they are.
> How are things in other parts of the world? 

that they are and experience doesn't seem to count either.  i was refused
interviews for a number of jobs because i have neither a degree or an OCP.
and while interviewed for others, they hired someone with a degree [in one
case a degree in history] and no experience.  i even had one place come back
to me a couple of months after not hiring me, asking if i would work for
them as a contractor to clean up the mess the person they did hire made.  i
had just taken this contract at the time so i graciously refused.;-)

--
Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
[EMAIL PROTECTED]

Science is a wonderful thing if one does not have to earn one's living at
it. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  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).

RAC 9i database - gx$ views ?

[Browett, Darren]

I know there is the gv$ views which are the cluster wide equivialent of
the v$ views,
but is there any gx$ views where are equivalent to the x$ views ???

Thanks

Darren


--
Darren Browett P.EngThis
message was transmitted
Data Administrator  using
100% recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  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: 64bit or 32 Bit

[Johnston, Tim]

isainfo -v

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 1:14 PM
To: Multiple recipients of list ORACLE-L


  How can I find if my SunOs is 64 or 32 bit?
-- 
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: Johnston, Tim
  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: Future demand for DBAs

[Stephane Faroult]

 Well, it may at last be the golden age, with EXPERIENCED developers !

 SF

"Goulet, Dick" wrote:
> 
> "They estimate that by 2010, a quarter of the IT workforce will be over 55
> years old."
> 
> Well, I don't know about that, but one of those old fogies is right here!!
> 
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
> 
> -Original Message-
> Sent: Wednesday, September 03, 2003 9:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> The META Group has released a study that forecasts increased demand for DBAs
> in the future. They quote the U.S. Department of Labor's Bureau of Labor
> Statistics that forecasts a 66% increase in DBAs by 2010. The two factors
> that META feels will increase demand are:
>   1. Increased use of DW
>   2. Aging workforce
> They estimate that by 2010, a quarter of the IT workforce will be over 55
> years old.
> The new features to make databases self-managing will only help with lower
> value labor intensive tasks such as schema changes and performance tuning,
> not with higher value skills such as design and troubleshooting.
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
-- 
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: Onames and various connections scenarios

[Jared . Still]

My names servers and clients are both 8.1.7.

Could be a problem between versions.

I'm not sure why support thinks a client is any different than a server.

I have 3 names servers.  By logging on to the the oracle account
on one of the servers, I use namesctl for admin work on all 3.

In this case, the server I'm logged  onto is a client.  Not any different
than running namesctl from my laptop.

Try it with a 9i client.

Jared








"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 07:29 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Onames and various connections scenarios


Jared, 
    
    Ive read the documentation http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/controlu.htm#442071
 
But I dont see where it says this is a method to get a tnsnames on the *clients* workstation, It works on the server  but creates a 0 byte file on the client workstation
 
I have a 9i names server, 8.17 on the client and win2k. I also dont see how set server fits in as namesctl on the client reveals the name server  correctly 
my 817 is patched to level 4 although the banner for namesctl does not show it
EG

C:\>namesctl dump_tnsnames
Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 03-SEP-2003 09:16:16
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
Currently managing name server "NS_CPSDB2"
Version banner is "Oracle Names for 32-bit Windows: Version 9.2.0.1.0 - Production"

Are you saying you have the same setup and it works for you? Here is my sqlnet.ora
 
NAMES.INITIAL_RETRY_TIMEOUT = 2
NAMES.REQUEST_RETRIES = 1
NAMES.DIRECTORY_PATH= (ONAMES,TNSNAMES, HOSTNAME)
 
NAMES.PREFERRED_SERVERS =
  (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP)(HOST = CPSDB2)(PORT = 1575))
        (ADDRESS = (PROTOCOL = TCP)(HOST = CPS012)(PORT = 1575))
  )
 
SQLNET.EXPIRE_TIME = 10
SQLNET.AUTHENTICATION_SERVICES= (NTS)
 
### 
 
Of course I can have a logon script grap the file, but I prefer this method as its much more elegant
 
 
... and indeed I saw it on the list last Friday. 

Sure it's supposed to work that way.  It is a documented feature. 

Otherwise there would be little point in having a 'set server' command. 

Jared 







"Bob Metelsky" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 09/02/2003 03:19 PM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        RE: Onames and various connections scenarios



This is a mesage that I sent on Friday, and to my knowledeg did not show
up, (+ there were no responses) Im assuming if I can post... That I am
in fact subscribed ;-)

Hopefully this make it

Thanks!
bob
##
Ok, so it was too good to be true

the suggestion to run 

namesctl dump_tnsnames 

on the client and expecting a fresh copy of tnsnames to be installed (on
the clients machine) is NOT supported.

I searched on metalink, alot of people have the same problem " a 0 byte
tnsnames file being created using namesctl"

Alot of OLD bugs that were never fixed, so I submitted an iTAR, and the
rep tried his best to convince me that this is NOT how the namesctl is
designed to work.

Does anyone know with certinty that this could be the methood to get a
fresh tnsnames file on the client from the onames server in the event
you do not want individual users to maintain their own tnsnames file?
The workaround wast to have the logon server pull and distribute the tns
from the onames server
And the money we pay oracle!

any ideas

thanks!
bob




Hello Jared

   I did not know that the client could call the "default" name
server... from sqlnet.ora...  pretty cool.
However, there now seems to be some bugs (no..)

It seems the namesctl ignores the arg to use a user defined path eg a
file does *not*  gets created in C:\temp
BUT an *empty*  tnsnames files does get created in the
%oracle_home%\network\admin
PROVIDING there is *not* an existing tnsnames there, if there is,
namesctl simply creates a copy of the *existing* tnsnames with a .sav
extension
!
Ive tested this on my machine running 8.1.7.4 all our client/user pcs
here are 8.17 0r 8.16

Im running w2k pro on all our client  machines

maybe I discoverd a bug in Oracle! 

thanks!
bob

examples

namesctl dump_tnsnames c:\temp\tnsnames.txt 
creates the above scenario

the output

C:\>namesctl dump_tnsnames c:\temp\tnsnames.txt

Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production
on 27-AUG-2003 11:31:39

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Currently managing name server "NS_CPSDB2"
Version banner is "Oracle Names

Re: alter system reset

[Arup Nanda]

>> One should not rely on either the init.ora or the spfile to determine
which parameters are set, but should query the database

True, but the original poster wanted to see why the ALTER SYSTEM RESET ...
SCOPE=SPFILE failed and that would occur only if the entry is not found in
the spfile, even if the value is set in the database with SCOPE=MEMORY.
Hence you should _not_ check the database but should check the spfile.

HTH.

Arup

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 03, 2003 3:34 PM


> Is the want to read the spfile just a curiosity?  One should not rely on
either the init.ora or the spfile to determine which parameters are set, but
should query the database.
>
> Now that we have both init.ora and an spfile someone is going to get
caught.  For instance a patch requirement requires 150 MB shared_pool and
java_pool sizes and warns about an unrecoverable memory error if the pools
are undersized.  The person dutifully makes the changes to the init.ora and
starts the database, but forgets that an spfile is being used with the
database  He then starts the patch and it fails with the unrecoverable
memory error.
>
> I would have been caught by this if my patchset installation procedure did
not include "show parameter"  to verify their settings.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Monday, September 01, 2003 8:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Prem,
>
> The SPFILE should never be opened to be modified; opening a file to see
the contents are acceptable and that's what I said. Sometimes opening the
file in an editor may not be needed; "type" in Windows command prompt or
"cat" in unix will let us achive the same objective.
>
> Talking about the SPFILE modification, you can't effectively modify it
with accuracy. The file is binary (actually binary in the beginning and then
text towards the bottom part), so even if you open it in notepad and save
it, there is no guarantee that the file will be accurately saved with all
contents intact.
>
> By the way, I have edited the SPFILE in some cases, only in development,
though; but I wouldn't advise it to be done that way; always use ALTER
SYSTEM ... SCOPE=SPFILE to modify it or edit the init.ora file and then
create the SPFILE from it. You can create the spfile from pfile even when
the instance is down.
>
> HTH.
>
> Arup
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, September 01, 2003 10:49 PM
>
>
> > Arup Bhai, i remember oracle docs saying NOT to open a spfile and that
> > it
> may even
> > corrupt the file.
> >
> > Is that always true ?
> > Can the spfile be opened ?
> > can you kindly explain me ?
> >
> > Thanks & Regards,
> > Prem Khanna J.
> >
> >
> > 02-09-2003 04:14:26, "Arup Nanda" <[EMAIL PROTECTED]> wrote:
> > >Does the entry even exist in the SPFILE? Open up the spfile in
> > >notepad
> and
> > >check the existence of the parameter in there. Do the following:
> > >SQL> alter system set undo_suppress_errors = false scope=spfile
> sid='ananda';
> > >System altered.
> > >SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile
> > >SQL> sid='ananda';
> > >System altered.
> > >Arup
> >
> >
> >
> > --
> > 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).
> >
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Arup Nanda
>   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: MacGregor, Ian A.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -

RE: Some posts not showing up

[Jared . Still]

Of course, the assumption that everyone is making is that their posts
made it to fatcity.com in the first place.

Given the recent assaults on mail servers by spam and viruses, that's
not a good bet.

Jared







DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 10:29 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Some posts not showing up


Tanel - I've experienced the same, sometimes my posting hasn't shown up
until the next day. But everyone knows I'm a little slow.

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


-Original Message-
Sent: Tuesday, September 02, 2003 6:19 PM
To: Multiple recipients of list ORACLE-L


Hm, I get other's recent messages, that means I must still be subscribed?
But I don't see any of my messages sent today. Is it possible that listserv
keeps me in receiver's list, but just doesn't accept my posts for some
reason?

Anyway, I resubscribed & lets see what happens.

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 03, 2003 1:14 AM



There is no moderator per se.  The only one is me, and I only
do that when absolutely necessary.

I see this one made it to the list, you must have resubscribed.

All:  If email sent to you bounces too many times, you will be
automatically dropped from the subscriber list, and you will
have to re-subscribe.

If you're not getting emails from the list, try resubscribing.

Jared





"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/02/2003 06:44 AM
 Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
        cc:
        Subject:        Some posts not showing up



I've noticed a few of my recent posts have not shown up. Is "someone"
reading and discerning whether the post is suitable? I've newer seen
this before but some of my posts make it and some do not. I don't see
how my content would be objectionable

Thanks
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
 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: Tanel Poder
  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: alter system reset

[MacGregor, Ian A.]

Is the want to read the spfile just a curiosity?  One should not rely on either the 
init.ora or the spfile to determine which parameters are set, but should query the 
database.  

Now that we have both init.ora and an spfile someone is going to get caught.  For 
instance a patch requirement requires 150 MB shared_pool and java_pool sizes and warns 
about an unrecoverable memory error if the pools are undersized.  The person dutifully 
makes the changes to the init.ora and starts the database, but forgets that an spfile 
is being used with the database  He then starts the patch and it fails with the 
unrecoverable memory error.

I would have been caught by this if my patchset installation procedure did not include 
"show parameter"  to verify their settings.

Ian MacGregor  
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, September 01, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Prem,

The SPFILE should never be opened to be modified; opening a file to see the contents 
are acceptable and that's what I said. Sometimes opening the file in an editor may not 
be needed; "type" in Windows command prompt or "cat" in unix will let us achive the 
same objective.

Talking about the SPFILE modification, you can't effectively modify it with accuracy. 
The file is binary (actually binary in the beginning and then text towards the bottom 
part), so even if you open it in notepad and save it, there is no guarantee that the 
file will be accurately saved with all contents intact.

By the way, I have edited the SPFILE in some cases, only in development, though; but I 
wouldn't advise it to be done that way; always use ALTER SYSTEM ... SCOPE=SPFILE to 
modify it or edit the init.ora file and then create the SPFILE from it. You can create 
the spfile from pfile even when the instance is down.

HTH.

Arup

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 10:49 PM


> Arup Bhai, i remember oracle docs saying NOT to open a spfile and that 
> it
may even
> corrupt the file.
>
> Is that always true ?
> Can the spfile be opened ?
> can you kindly explain me ?
>
> Thanks & Regards,
> Prem Khanna J.
>
>
> 02-09-2003 04:14:26, "Arup Nanda" <[EMAIL PROTECTED]> wrote:
> >Does the entry even exist in the SPFILE? Open up the spfile in 
> >notepad
and
> >check the existence of the parameter in there. Do the following:
> >SQL> alter system set undo_suppress_errors = false scope=spfile
sid='ananda';
> >System altered.
> >SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile 
> >SQL> sid='ananda';
> >System altered.
> >Arup
>
>
>
> --
> 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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  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: MacGregor, Ian A.
  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: log buffer space wait

[Jared . Still]

These are cumalitive times for a few hundred processes.

Jared








<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 10:34 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: log buffer space wait


I have one question regarding these wait times, may be dump. In the following wait events what is the unit of measurement for Time, I believe its in seconds as per the documentation. If yes then here stats are collected for only 51.23 Minutes (Appx 3073 seconds), how come Oracle is showing 566,516 seconds wait for log buffer space. I would appreciate if someone can explain.
 
Thanks
 
 
Top 5 Timed Events
~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
  --- 
log buffer space                                1,817,258     566,516    56.24
latch free                                      2,964,652     334,120    33.17
log file sync                                      55,230      43,488     4.32
buffer busy waits                                  62,839      26,129     2.59
CPU time                                                       
-Original Message-
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L
Subject: log buffer space wait 

At a Benchmark a particular Processing + DML intensive batch Job (Accounts Interest Calculation) is experiencing 
"log buffer space" wait .
 
Config :-
On Solaris 9 
Cpu_count = 72
Oracle 9.2
Online Redo logfiles are on a RAID 0+1 Volume (NOT Raw or RAID 1) Log_buffer = 10 M
$ sar Command Outpuit %wio only about 6 % for Volume containing the redo logfiles
Database in NOARCHIVELOG mode
 
Qs. How can we reduce this wait event ? Would RAW / RAID 1 for redo logfiles help ?
Qs. Could this be a Bug ?
 
*
STATSPACK report for
 
DB Name         DB Id    Instance     Inst Num Release     Cluster Host
 ---   --- --- 
BM2           3727568246 bm2                 1 9.2.0.3.0   NO      sleepy
 
            Snap Id     Snap Time      Sessions Curs/Sess Comment
            --- --  - ---
Begin Snap:     240 01-Sep-03 03:09:41       23       1.5
  End Snap:     241 01-Sep-03 04:00:55       24       1.7
   Elapsed:               51.23 (mins)
 
Top 5 Timed Events
~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
  --- 
log buffer space                                1,817,258     566,516    56.24
latch free                                      2,964,652     334,120    33.17
log file sync                                      55,230      43,488     4.32
buffer busy waits                                  62,839      26,129     2.59
CPU time                                                       22,018     2.19
          -

Wait Events for DB: BM2  Instance: bm2  Snaps: 240 -241
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 100th of a second
-> ordered by wait time desc, waits desc (idle events last)
 
                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
  -- -- -- 
log buffer space                1,817,258        139    566,516    312     54.4
latch free                      2,964,652    892,594    334,120    113     88.8
log file sync                      55,230     21,210     43,488    787      1.7
buffer busy waits                  62,839     10,250     26,129    416      1.9
 
 

Latch Activity for DB: BM2  Instance: bm2  Snaps: 240 -241
 
                                           Pct    Avg   Wait                 Pct
                              Get          Get   Slps   Time       NoWait NoWait
Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
 -- -- -- --  --
post/wait queue                  97,357    4.7    0.4    577    1,871,155  249.5
process allocation                  751    7.2    3.0     10          747    0.5
process group creation            1,502    0.0             0            0
redo allocation              24,482,283   13.5    0.4 ## 

RE: DBI in activestate perl

[Jared . Still]

That won't help.

ActiveState does not have a DBD::Oracle for Perl 5.8.

Jared








"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 08:09 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: DBI in activestate perl


do you know about ppm
type ppm at the command line
 
perl package manager
http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/
 
http://perl.about.com/library/weekly/aa030500a.htm
 
h th
bob 

Does anybody know how and where to get DBI/DBD::Oracle for  ActivePerl 5.8.0.806 ?
Here is what is happenening to me:

C:\tmp>perl dbi.pl
Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at d
bi.pl line 1.
BEGIN failed--compilation aborted at dbi.pl line 1.
 
Line 1 is, of course, "use DBI;" . Does anybody have a solution? Do I get it if I buy the development kit?
--
Mladen Gogala
Oracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.  Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such
  entity.
 
 

Re: DBI in activestate perl

[Jared . Still]

ftp://ftp.esoftmatic.com/outgoing/DBI/








"Mladen Gogala" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 07:09 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        DBI in activestate perl


Does anybody know how and where to get DBI/DBD::Oracle for  ActivePerl 5.8.0.806 ?
Here is what is happenening to me:

C:\tmp>perl dbi.pl
Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at d
bi.pl line 1.
BEGIN failed--compilation aborted at dbi.pl line 1.
 
Line 1 is, of course, "use DBI;" . Does anybody have a solution? Do I get it if I buy the development kit?
--
Mladen Gogala
Oracle DBA 
 
 
Note:
This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.  Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such
  entity.
 
 

RE: "Application DBA"

[Boivin, Patrice J]

not here... we are running Oracle Financials somewhere but not related to
me, I don't interact with that group.

Patrice.

-Original Message-
Sent: Tuesday, September 02, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


i take 'applications dbas' when i see them advertised as jobs to mean a dba
experienced with the the oracle applications like financials, etc... 

am i correct to assume this? 
> 
> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> Date: 2003/09/02 Tue PM 03:54:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: "Application DBA"
> 
> Someone sent me this URL when I mentioned that there may be Application
> Administrators, but no Application DBAs.
>  
>
 uide/SECURITYANDACCESSPOLICY.htm>
>
http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/StyleGu
> ide/SECURITYANDACCESSPOLICY.htm
> 
> Patrice.
> 
>  
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice 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: Oracle on Win2000

[Murali_Pavuloori/Claritas]

pcanywhere...the remote control for the windoze servers.

Murali.



   
  
"Bala  
  
Regupathy"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]> 
<[EMAIL PROTECTED]   cc:   
  
obal.net>Subject: Oracle on Win2000
  
Sent by:   
  
[EMAIL PROTECTED]  
 
ity.com
  
   
  
   
  
09/03/2003 
  
01:44 PM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




First time I have got to maintain Oracle databases on Win 2000 server.
What tools do you guys use to get to the server to admin oracle databases ?

Thanks,

Bala.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Murali_Pavuloori/[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: Listener Lockout Feature

[Post, Ethan]

Yeah

-Original Message-
Sent: Wednesday, September 03, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L


Whoops, disregard my last post - do you mean logging on to lsnrctl?

-Original Message-
Post, Ethan
Sent: 03 September 2003 17:39
To: Multiple recipients of list ORACLE-L


Any idea if a listener lockout feature is going to be added to the listener
utility, i.e. lock after "x" failed login attempts (this is on the listener
password).  Are failed login attempts logged in the log file?  Being lazy on
that last question.

Thanks,
Ethan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
  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).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

-- 
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: Post, Ethan
  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: decode

[Stephane Paquette]

Use greatest ...

decode(greatest(sn,7),sn, substr(sn,-7),sn )


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] 



-Original Message-
Imran Ashraf
Sent: Wednesday, September 03, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have this query...
select decode(length(sn),8),substr(sn,-7),sn )from .

However i want to change it so that if the length of sn is >= 8 then set sn
to last 7 characters.

How can i implement this?

Regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Imran Ashraf
  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).

RE: A basic replication question

[Rachel Carmichael]

"ad-hoc queries"

as in, we'll write something that will bring your database to its knees

that kind of reporting, it's better to have a separate database


--- "Thater, William" <[EMAIL PROTECTED]> wrote:
> Weaver, Walt  scribbled on the wall in glitter crayon:
> 
> > Okay, we have a request for quite a few of our customers for
> read-only
> > copies of their databases they can do their ad-hoc queries on.
> These
> > read-only databases need to as closely matched to the production
> > database as possible, i.e., exact, from their point of view.
> 
> can they use a read only login for it?  just set up a username with
> no quota
> and grant it select on the tables it needs.  or am i missing
> something here?
> 
> --
> Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25
> [EMAIL PROTECTED]
>

> Making allowances for human imperfections, I do feel that in America
> the
> most valuable thing in life is possible; the development of the
> individual
> and his creative powers. - Albert Einstein
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Thater, William
>   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).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.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).

ORA-16014

[Saira Somani-Mendelin]

Received this alert minutes ago. There is no disk space shortage.

What else can I check for?

ORA-16014: log 2 sequence# 6362 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log'
ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log'
 ORA-16014: log 2 sequence# 6362 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log'
ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log'

Any help is greatly appreciated.

Thanks,
Saira

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani-Mendelin
  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: Listener Lockout Feature

[Arup Nanda]

Listener password failures do not lock the password, unfortunately; but it
is possible to identify the failed logins. The listener log shows entries
similar to the lines below

05-JUL-2003 21:14:39 * services * 1169
TNS-01169: The listener has not recognized the password

Note the lines "TNS-01169: The listener has not recognized the password ",
which could mean as simple as a fat fingered DBA or repeated attempts to
break in. As a rule of thumb, I scan TNS-01169 errors and review them
periodically.

HTH.

Arup Nanda
www.proligence.com


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


> Any idea if a listener lockout feature is going to be added to the
listener
> utility, i.e. lock after "x" failed login attempts (this is on the
listener
> password).  Are failed login attempts logged in the log file?  Being lazy
on
> that last question.
>
> Thanks,
> Ethan
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Post, Ethan
>   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: Arup Nanda
  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: Read data from a file

[Jared . Still]

How embarrasing!

Someone else suggested a Perl solution.

I did think of doing so, but then didn't do so for some reason.

And of course, there are some scripts for that in "Perl for Oracle DBA's" .  :)

Jared







Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 09/03/2003 05:14 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: Read data from a file


#!/usr/bin/perl
use DBI;
my $username=undef;
my $dbh=DBI->connect("dbi:Oracle:sid",system,password);
while ($username=) {
   chomp($username);
   $dbh->do("create user $username identified by $username
             default tablespace syastem
             temporary tablespace system");
   $dbh->do("grant connect,resource, dba to $username");
}
print "You got yourself a few new usernames!\n";




On 2003.09.03 01:34, setiady wrote:
> MessageHi All,
>     I wonder if it is possible for me to execute a script file to create  
> user
> while I have another file (a text file) consisting the names of the users I
> want to create. Assuming that all the users are having the same privileges,
> what is the procedure to read the names from the other file? Thank you.
>

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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: DBI in activestate perl

[AK]

Title: Message



You can user perl package manager in activestate . 
from ppm command prompt issue "search dbi" or "search dbd" and then issue 
install dbd /dbi.
 
-ak
 

  - Original Message - 
  From: 
  Mladen 
  Gogala 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, September 03, 2003 7:09 
  AM
  Subject: DBI in activestate perl
  
  Does anybody know 
  how and where to get DBI/DBD::Oracle for  ActivePerl 5.8.0.806 
  ?
  Here is what is happenening 
  to me:
  C:\tmp>perl dbi.plCan't locate DBI.pm 
  in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at dbi.pl line 
  1.BEGIN failed--compilation aborted at dbi.pl line 1.
   
  Line 1 is, of 
  course, "use DBI;" . Does anybody have a solution? Do I get it if I buy 
  the development kit?
  --Mladen 
  GogalaOracle DBA 
   
   
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any mistransmission.  
  If you receive this message in error, please immediately delete it and 
  all copies of it from your system, destroy any hard copies of it and notify 
  the sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. Wang Trading 
  LLC and any of its subsidiaries each reserve the right to 
  monitor all e-mail communications through its networks.  Any views 
  expressed in this message are those of the individual sender, except where the 
  message states otherwise and the sender is authorized to state them to be the 
  views of any such entity.
   
   

RE: sqlload

[Hallas, John, Tech Dev]

Tom,
I am afraid you are wrong there, a parameter file can be used to run a sqlloader script

The syntax that Fawzia uses is correct although as per imp/exp it would be better to 
put all the parameters in the parfile file 

I spent years not knowing that and in frustration posted to the list and was 
immediately shown how to do it

Interesting  to see if this reply makes it to the list as the last one I posted about 
2 hours ago never got there.

John


-Original Message-
Sent: 02 September 2003 19:05
To: Multiple recipients of list ORACLE-L


Fawzia,

Try the following (change parfile= to control=)

sqlldr control=pants.ctl log=me.log

parfile is for imp/exp.

Good Luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 02, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L



PLEASE Can someone help??I have a sqlloader control file below and I am
getting the following error when I run it and I just cant see what is
wrong!!!

Rgds

Fawzia
[EMAIL PROTECTED]> sqlldr parfile=pants.ctl log=me.log
LRM-00110: syntax error at 'LOAD'
LRM-00113: error when processing file 'pants.ctl'

Control file:


LOAD DATA
INFILE  'gazza2.csv'
APPEND
INTO TABLE olsr10_tlmif2.gazetteer1
fields terminated by ','
trailing nullcols
(postcode_prefix_spaced char,
filler1 char,
postcode_prefix char,
filler2 char,
postcode_range char,
filler3 char,
town char,
filler4 char,
county char,
valid_date char)


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Malik, Fawzia
  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: Mercadante, Thomas F
  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: Hallas, John, Tech Dev
  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: Future demand for DBAs

[Goulet, Dick]

"They estimate that by 2010, a quarter of the IT workforce will be over 55
years old."

Well, I don't know about that, but one of those old fogies is right here!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, September 03, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


The META Group has released a study that forecasts increased demand for DBAs
in the future. They quote the U.S. Department of Labor's Bureau of Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over 55
years old.
The new features to make databases self-managing will only help with lower
value labor intensive tasks such as schema changes and performance tuning,
not with higher value skills such as design and troubleshooting.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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: sqlload

[DENNIS WILLIAMS]

Congratulations Thomas!

You win the eagle-eye prize of the day! Unfortunately it is a virtual prize.
Funny what an obscure error sqlldr produced.

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


-Original Message-
Sent: Tuesday, September 02, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L


Fawzia,

Try the following (change parfile= to control=)

sqlldr control=pants.ctl log=me.log

parfile is for imp/exp.

Good Luck!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 02, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L



PLEASE Can someone help??I have a sqlloader control file below and I am
getting the following error when I run it and I just cant see what is
wrong!!!

Rgds

Fawzia
[EMAIL PROTECTED]> sqlldr parfile=pants.ctl log=me.log
LRM-00110: syntax error at 'LOAD'
LRM-00113: error when processing file 'pants.ctl'

Control file:


LOAD DATA
INFILE  'gazza2.csv'
APPEND
INTO TABLE olsr10_tlmif2.gazetteer1
fields terminated by ','
trailing nullcols
(postcode_prefix_spaced char,
filler1 char,
postcode_prefix char,
filler2 char,
postcode_range char,
filler3 char,
town char,
filler4 char,
county char,
valid_date char)


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Malik, Fawzia
  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: Mercadante, Thomas F
  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: Future demand for DBAs

[Mladen Gogala]

That is precisely why I don't smoke, don't drink, work out and watch what I
eat.
I want to be around when the demand goes up. In 2061, I'll be the 1st
century 
old DBA in the good ol' US. Life is a bore, but it will be a long one.

--
Mladen Gogala
Oracle DBA 



-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, September 03, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


The META Group has released a study that forecasts increased demand for DBAs
in the future. They quote the U.S. Department of Labor's Bureau of Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over 55
years old. The new features to make databases self-managing will only help
with lower value labor intensive tasks such as schema changes and
performance tuning, not with higher value skills such as design and
troubleshooting.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  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).

Does the 9iR2 Installer delete patch files?

[Jesse, Rich]

Hey all,

During the instal of 9iRAC on RH9, the instructions say to install the
9.2.0.1 software, then apply the 9.2.0.4 patch separately to the Installer,
OCM, and finally to the RAC software itself.  This is my second time through
and both times there were files in the cpio-exploded patch that had
disappeared somewhere between the patching of the Installer and the RAC
software.  This time I kept the cpio file of the patch so I didn't need to
download it again.

I should probably have taken down some of the names of the files that came
up as "File not found" errors during the RAC install, but there were so many
during my first install, I figured I had accidentally "rm"d a directory.

Anyone know what's up with the Installer?  "Or is it just me?" he axes,
praying for the former...

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
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: Offshore threat

[rgaffuri]

i find it difficult to believe. manufacturing jobs have been going over seas for 
years. Michael Jordan shoes are made in sweat shops in Asia. People are less likely to 
feel sorry for relatively high payed DBAs than they are for poorer manufacturers and 
what good did it do them? Their unions didnt save them.

people in India and other countries are just as good as the people in the US. Alot of 
stuff can be done offshore. You can pay someone in another country a pitance compared 
to what you pay Americans. Keep in mind that they may pay people in Asian countries 
25% of what they pay americans the exchange rate is so huge its probably like 10% when 
you factor in total cost. 

people most likely to be hurt by this are immigrants to the US. Since US citizens 
without criminal records can always do government work that requires citizenship. 
Demand for people with clearances is 'insane' in the DC area. Salaries can be 50% 
higher or more. The market for US citizens who are eligible for clearances has picked 
up quite a bit(no criminal record, bad debts, or long stays outside the US). However, 
that is less than 20% of the market. 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/09/03 Wed AM 09:44:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Offshore threat
> 
> All - Recently several shared their experiences with offshore development.
> This month's CIO magazine is devoted to issues surrounding offshore. 
> 
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 1. The Politics: Backlash
> As a growing number of IT jobs move overseas, some CIOs and
> economists prophesy a political storm against offshore
> outsourcing and a negative perception of those companies
> that practice it.
> http://www.cio.com/archive/090103/backlash.html
> 
> ** Don't miss the story's sidebar, "The Visa War," about the
> controversial policies surrounding L-1 and H-1B visas.
> http://www.cio.com/archive/090103/backlash_sidebar_1.html
> 
> 2. The People: The Radicalization of Mike Emmons
> How one laid-off IT worker became a guerrilla campaigner
> against offshore outsourcing. "They can't just give away all
> these jobs and expect the country to survive," he says.
> http://www.cio.com/archive/090103/people.html
> 
> ** Another programmer who lost his job to an Indian
> outsourcer is willing to relocate in India. But Indian
> officials have told him they don't hire Americans. Read
> about another politicized IT worker in "No Americans Need
> Apply."
> http://www.cio.com/archive/090103/people_sidebar_1.html
> 
> -- 
> 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: <[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).

Oracle Standby Database Backups.

[Mercadante, Thomas F]

All,
We are in the beginning stages of 
designing a database with Oracle Standby capability.  The initial size of 
the database will be 600-800 Gig.  The proposed database will be run on a IBM P690 with a 
mirrored fail-over machine.  Two separate machines with separate 
disk.  We are considering using 
Oracle Standby to have the database available as much as possible.
 
Do I need to perform regular backups of the Standby database?  
Sounds like a silly question, but how do I do this?  Using Rman?  Or 
do I shut it down and perform a cold backup?  I will definitely use Rman on 
the primary database.  Just curious what you all would 
suggest.
 
Thanks 
in advance!
Tom Mercadante Oracle Certified Professional 
 

RE: Oracle not available???

[Wolfe Stephen S GS-11 6 MDSS/SGSI]

You don't get any other message than a 'Not Available' message?  I have
one application that did that a lot, but that was because it's SGA was
sized way to small.

And, thankfully, the people on the this list help me over that bump in
the road.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



> -Original Message-
> From: Denham Eva [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, September 03, 2003 10:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle not available???
> 
> 
> Hello Gurus
> 
> I had a weird one to day, all access to Oracle on our oracle 
> database was suddenly lost When you try to connect it 
> says that Oracle is on available. However the DB has been up 
> for more than 70 days. The other thing the service was 
> running and the Oracle process and listener was running? No 
> errors in the logs, nothing.
> Server: Win2k, Oracle 817.
> 
> 
> Has anyone experienced this before???
> 
> TIA
> Denham Eva
> Oracle DBA
> Linux like TeePee... No Windows, No Gates and Apache inside!
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Denham Eva
>   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: Wolfe Stephen S GS-11 6 MDSS/SGSI
  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).

Priority paging and Solaris 8

[Jos]

List,
This is not entirely an Oracle question, more related
to Solaris 8. We had some reports which run for 5 to
10 minutes and the unix process gone to sleep for an
hour before it woke up and finished. The Oracle
session showed that they are waiting for SQL message
from client. During the same period, there were a lot
of paging activity happening on the swap disk and the
Oracle database itself is not doing much. I remember
in Solaris 2.6, we have to set priority_paging to 1 in
/etc/system to improve paging performance, so Solaris
won't page out application executable. However, this
is Solaris 8, I just checked the documentation, we are
not suppose to set priority_paging. I am a bit
confuse, I am seeing the symptom of application code
being paged out but this problem seem to be fixed in
Solaris 8. Is anyone had any experience with paging
performance on Solaris 8?
Jos

http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Jos?=
  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: RE: URGENT : sql*loader performance problem on partionned table

[rgaffuri]

1. by 'filling' are you doing inserts also? I see a 'FOR UPDATE' statement which 
implies that you are doing updates from with in a cursor. 
2. How many indexes do you have on this table?
3. Is anything else running at the same time? 
4. Are you doing your DML from with in a cursor. This is very slow. Try to do it all 
in SQL. 
5. Consider changing your not exists to 
Where NOT IN (SELECT /*+ hash_aj */ ...)
That can be faster if your sub-query is significantly less costly than your your outer 
query(its the opposite for exists). Wont necessarily help in your case. 
You can also eliminate the join with the 'in'. This can improve performance as well. 

Please post a subset of your batch script. Please format it so its readable. Ill look 
at it. Also please post how many rows are in each table. 

Ill see if I can find anything. I think the two locks on the same object are locks on 
seperate partitions. Not sure. 
> 
> From: "NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
> Date: 2003/09/03 Wed AM 09:59:27 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: URGENT : sql*loader performance problem on partionned table
> 
> thank U Dennis,
> 
> I use local index, 
> the script is still running (2hours now! instead of 10-20 min) and here is
> the statement  in question (the script who used non-partionned table is
> already ended)
> 
> SELECT NULL
> FROM hrel_fusion
> WHERE cod_rel = :b1
>   AND dat_rel = :b2
>   AND NOT EXISTS (SELECT NULL
>   FROM primedi_enr2_temp_fusion
>   WHERE primedi_enr2_temp_fusion.nodos_or = 
> hrel_fusion.nodos_or
> AND primedi_enr2_temp_fusion.code_logis = 
> hrel_fusion.cod_rel
> AND primedi_enr2_temp_fusion.date_logis = 
> hrel_fusion.dat_rel)
> FOR UPDATE
> 
> 
> The explain plan show that hrel_fusion table is ACCESS BY LOCAL INDEX ROWID
> and primedi table used INDEX too.
> When I looking at lock tables it show me 2 session locked :
> 
> SQL> select session_id, oracle_username, object_name
>   2  from v$locked_object lo, dba_objects o
>   3  where lo.object_id = o.object_id
>   4  ;
> 
> SESSION_ID ORACLE_USERNAMEOBJECT_NAME
> -- --
> 
> 
>  7 FICOM  HREL_FUSION
>  7 FICOM  HREL_FUSION
> 
> -Why are there 2 locks on this table even there only one session ?
> - Yesterday I did gather_statitic on this table and it worked fine (12 min),
> should I do this each day ?
> TIA
> Philippe
> 
> 
> 
> -Message d'origine-
> De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
> Envoyé : 02 September 2003 19:45
> À : Multiple recipients of list ORACLE-L
> Objet : RE: URGENT : sql*loader performance problem on partionned table
> 
> 
> Philippe
>  You aren't providing many details on which to base some guesses.
> However, your statement "brand new disks" implies that you are adding
> additional partitions to an existing table. Then, your statement "should I
> drop indexes" implies that you have indexes on the partitioned table,
> possibly global indexes. If you are continuing to grow a partitioned (or
> non-partitioned) table than has indexes, then the load time will increase
> because Oracle must integrate each new entry into the index, which will take
> more time as the index grows. Take a look at local indexes. If I not
> understood your situation correctly, please clarify your situation further.
> 
> 
> 
> Dennis Williams 
> DBA, 80%OCP, 100% DBA 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Tuesday, September 02, 2003 12:14 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi gurus, 
> we have two daily loads that one after the other. 
> The first fill up a non partitionned table and the second do the same into a
> partitionned table. 
> First times the second load ran very quickly : 1 min instead of 5 min (non
> partitionnned table). 
> But now since few days, the partitionned table filling take more than 1-2
> hours ! yesterday it took 14 hours  
> Any one has any clue ? 
> - Tablespaces for partitionned table used brand new separate disks 
> - Does it come from indexes ? should I drop them first ? 
> 
> Thankx in advance! 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> 
> 
Title: RE: URGENT : sql*loader performance problem on partionned table





thank U Dennis,


I use local index, 
the script is still running (2hours now! instead of 10-20 min) and here is the statement  in question (the script who used non-partionned table is already ended)

SELECT NULL
    FROM hrel_fusion
    WHERE cod_rel = :b1
  AND dat_rel = :b2
  AND NO

Future demand for DBAs

[DENNIS WILLIAMS]

The META Group has released a study that forecasts increased demand for DBAs
in the future. They quote the U.S. Department of Labor's Bureau of Labor
Statistics that forecasts a 66% increase in DBAs by 2010. The two factors
that META feels will increase demand are:
  1. Increased use of DW
  2. Aging workforce
They estimate that by 2010, a quarter of the IT workforce will be over 55
years old.
The new features to make databases self-managing will only help with lower
value labor intensive tasks such as schema changes and performance tuning,
not with higher value skills such as design and troubleshooting.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
-- 
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: Permissions error

[Hallas, John, Tech Dev]

Well spotted Ron. I had not realised it was a VMS box
Either way the principle is correct - set up the environment first

John

-Original Message-
Sent: 03 September 2003 13:25
To: Multiple recipients of list ORACLE-L


John,
 If the OS is Dec Alpha OpenVMS.
 In the user environment execute the $ORACLE_HOME[.util]orauser.com to
properly set the Oracle logicals for the user. A SHOW LOGICAL will
display what you have set now.
Ron
>>> [EMAIL PROTECTED] 09/03/03 04:34AM >>>
The different account wil lnot have it's Oracle environment set up
properly.
Check out  the .profile on the account that works and the one that does
not.
One will set up an Oracle_home and Oracle_sid variable, the other will
not.
If it is not in the .profile then look at any other script that is
called before you run sqlplus
 
John

-Original Message-
Sent: 03 September 2003 01:19
To: Multiple recipients of list ORACLE-L



Hi All 

I get this error when I try to log into sqlplus from my DEC ALPHA
machine through a telnet session. 


Enter user-name: testid 
Enter password: 
ERROR: ORA-01034: ORACLE not available 
ORA-07320: smsget: shmat error when trying to attach sga. 
DEC OSF/1 (AXP) Error: 13: Permission denied 


Did some permissions get corrupted.  I am able to connect using sqlplus
from my oracle account. 
This happens when I try to connect from a different account. 


Thanks 
David 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Hallas, John, Tech Dev
  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: Hallas, John, Tech Dev
  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: 64bit or 32 Bit

[Murali_Pavuloori/Claritas]

  Use the isalist command to determine whether the machine is running   
  the 32-bit or 64-bit operating system. If you are running the 64-bit  
  operating system on an UltraSPARC machine, then isalist   
  will list sparcv9 first   






Murali.




   
  
<[EMAIL PROTECTED] 
  
nents.com>   To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
Sent by: cc:   
  
[EMAIL PROTECTED]Subject: 64bit or 32 Bit  
  
   
  
   
  
09/03/2003 01:14 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




  How can I find if my SunOs is 64 or 32 bit?
--
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: 
  INET: Murali_Pavuloori/[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 on Win2000

[Mercadante, Thomas F]

Bala,
 
I 
create shortcuts to the Oracle/dbs directory and bdump & Udump directories 
so that I can get there easily from my desktop.
 
I use 
telnet to log onto the machine to bring the database up and down.  I 
have NT admins for installing the software, so I 
don't 
need to use PCAnywhere for other stuff.
 
Good 
Luck.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Bala Regupathy 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 
  1:44 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle on Win2000
  First time I have got to maintain Oracle 
  databases on Win 2000 server.  What tools do you guys use to 
  get to the server to admin oracle databases ?
   
  Thanks,
   
  Bala.

RE: Listener Lockout Feature

[Mark Leith]

Ethan,

You can do this with profiles. Here's an example by Connor McDonald, on
Jonathan Lewis' site:

http://www.jlcomp.demon.co.uk/faq/password_expiry.html

HTH

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


-Original Message-
Post, Ethan
Sent: 03 September 2003 17:39
To: Multiple recipients of list ORACLE-L


Any idea if a listener lockout feature is going to be added to the listener
utility, i.e. lock after "x" failed login attempts (this is on the listener
password).  Are failed login attempts logged in the log file?  Being lazy on
that last question.

Thanks,
Ethan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
  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).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

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

Offshore threat

[DENNIS WILLIAMS]

All - Recently several shared their experiences with offshore development.
This month's CIO magazine is devoted to issues surrounding offshore. 

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

1. The Politics: Backlash
As a growing number of IT jobs move overseas, some CIOs and
economists prophesy a political storm against offshore
outsourcing and a negative perception of those companies
that practice it.
http://www.cio.com/archive/090103/backlash.html

** Don't miss the story's sidebar, "The Visa War," about the
controversial policies surrounding L-1 and H-1B visas.
http://www.cio.com/archive/090103/backlash_sidebar_1.html

2. The People: The Radicalization of Mike Emmons
How one laid-off IT worker became a guerrilla campaigner
against offshore outsourcing. "They can't just give away all
these jobs and expect the country to survive," he says.
http://www.cio.com/archive/090103/people.html

** Another programmer who lost his job to an Indian
outsourcer is willing to relocate in India. But Indian
officials have told him they don't hire Americans. Read
about another politicized IT worker in "No Americans Need
Apply."
http://www.cio.com/archive/090103/people_sidebar_1.html

-- 
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: Re: "Application DBA"

[rgaffuri]

more and more employers are requiring OCPs and 'related degrees' such as computer 
science or a masters degree. 
At least in the US they are. How are things in other parts of the world? 
> 
> From: "Nuno Souto" <[EMAIL PROTECTED]>
> Date: 2003/09/03 Wed AM 07:19:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: "Application DBA"
> 
> - Original Message - 
> 
> > Usually, the term used is devlopment DBA.
> >sniperoo 
> > http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/StyleGu
> > ide/SECURITYANDACCESSPOLICY.htm
> 
> 
> and some will insist they be OCPs...
> 
> Cheers
> Nuno Souto
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Nuno Souto
>   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).

Urgent INFO needed.

[Ora DBA]

Dear Friends, 
One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. 
Any info regarding this is appreciated. Please give me your mail id and contacts.. 
Thanks a lot. 
Regards 
Oracle DBA

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: A basic replication question

[Weaver, Walt]

Well, that's what the users want.   :>)

But, due to the way our web hosting security is set up we can't do it.

--Walt

> -Original Message-
> From: Thater, William [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 11:49 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: A basic replication question
> 
> Weaver, Walt  scribbled on the wall in glitter crayon:
> 
> > Okay, we have a request for quite a few of our customers for
read-only
> > copies of their databases they can do their ad-hoc queries on. These
> > read-only databases need to as closely matched to the production
> > database as possible, i.e., exact, from their point of view.
> 
> can they use a read only login for it?  just set up a username with no
> quota
> and grant it select on the tables it needs.  or am i missing something
> here?
> 
> --
> Bill "Shrek" Thater ORACLE DBA  BAARF Party member #25

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