Re: DBMS_STATS

[Christian Trassens]

I don't know from Steve. However I can tell from my
experience that the options GATHER STALE and GATHER
EMPTY have problems.

Regards.

--- Anand Prakash <[EMAIL PROTECTED]>
wrote:
> Steve
> 
> You mentioned about dbms_stats having some teething
> problem on version 8.1.6. Can you provide some more
> details? I was planning to implement on version
> 8.1.6.2 on Compaq Tru64 unix 5.1.
> 
> Thanks.
> 
> Anand Prakash
> 
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Anand Prakash
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Bored!!!

[Ravinder_Bahadur]

Dear Audrey,
   Change your employer, go some place where you have N number of
platforms and N types of DB's. I am sure u will soon say the opposite.

Regards

__

Visit us at www.singaporeair.com.
__

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Setting event 10032

[novicedba]

hi all,
this is an excerpt from Steve Adams 
site
http://www.ixora.com.au/newsletter/2000_12.htm
First you need to determine the largest disk sort that is performed 
by the batch process. This can be done by setting event 10032 at level 1 in the 
session and then examining the process trace file. 
 
I wanted to know how to set the event at 
level
 
I use
8.1.5,8.1.6,8.1.7 on Windows NT 4.0
8.1.6,8.1.7  on RedHat Linux 7.0
 
thanks in advance
 
cozI am anoviceOracle Certifiable 
DBBS
 

Re: Why default domain?

[Jon Walthour]

In short, I don't. I use local resolution (as our ONS is frequently down and
unreliable) and none of my aliases have domain names attached to them. In my
sqlnet.ora, the entries about default domain, etc. are all commented out.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 8:35 PM


> The O'Reilly Net8 book states:
>
> "It's possible to run a Net8 network without using domains at all."
>
> If this is true, why create net service names that are qualified by a
domain
> name, why define a default domain in sqlnet.ora, etc.?  What benefit do
you
> get by setting things up to use a domain?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Jon Walthour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Reardon, Bruce (CALBBAY)]

Hi,

I have just found the email I posted earlier about this in the List
archives.
To find it search for "when it will need to delete the alert log
file"

I can't comment on the accuracy with respect to Unix as don't use it.
Under NT as others have said you can just rename the alert logfile and a new
one will be created.

The note summary is:
 Deleting the alert.log when the database is up 
 Type: Note Doc ID: 122401.1 
 Modified Date: 14-MAY-2001 
 Status: PUBLISHED 
 Platform: Unix Generic issue 
 Product: Oracle Server - Enterprise Edition V7 

Regards,
Bruce Reardon

"On Sunday 27 May 2001 18:10, Reardon, Bruce (CALBBAY) wrote:
> Hi,
>
> For information.
>
> At various times there has been a lot of discussion about deleting =
the
> alert.log.
>
> Looking through Metalink I found the following note which describes =
the
> behaviour change between 7.3.4 and 805 and above.
>
> Hope it is of help.
>
> Regards,
> Bruce
>
>
> Doc ID:  Note:122401.1
> Type:  BULLETIN
> Status:  PUBLISHED
> Content Type:  TEXT/PLAIN
> Creation Date:  18-OCT-2000
> Last Revision Date:  14-MAY-2001
>
>
> Problem Description
> ---
>
> The Oracle background processes has an open file descriptor on the
> alert.log.
> When the database is up and running it continually holds this file
> descriptor
> open. This was not the case in 7.3.4, but is true for 8.0.5 to 8.1.7.
>
> This poses the question: What if the database is up and the alert.log
> gets too large. Do I have to shutdown the database to release the =
open
> file descriptor on the alert.log, then deal with the large alert.log?
>
>
> Solution Description
> 
>
> You are able to copy the alert.log while the database is up and =
running.
>
> 1) Create an empty file:
>   (example: touch nullfile.log)
>
> 2) Replace the old alert.log with the new empty file:
>   (example: mv nullfile.log alert.log)
>
> The running database experiences no affects when doing this.
>
>
> Explanation
> ---
>
> Having the continual open file descriptor on the alert.log is =
intended
> behaviour for the database.
>
>
> References
> --
>
> [BUG:1388186]  OPEN FILE DESCRIPTORS HELD BY ORACLE BACKGROUND =
PROCESSES
>ON ALERT.LOG FILE
>
>
> Additional Search Words
> ---
>
> delete alert"

-Original Message-
Sent: Wednesday, 11 July 2001 5:06 
To: Multiple recipients of list ORACLE-L


dunno about NT, I do know that it changed on Unix.. as per a thread here in 
the not too distant past. I believe Anita had posted something on it.. and 
that it WAS a change from prior versions.

I am an Oracle on NT ignoramus :)

>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Date: Tue, 10 Jul 2001 10:00:34 -0800
>
>In 816 on NT, you can rename it any time you want.
>
>is this changing in 817 Rachel?
>
>Tom Mercadante
>Oracle Certified Professional
>
>-Original Message-
>Sent: Tuesday, July 10, 2001 1:27 PM
>
>depends on the version of the database you are running.. it used to be that
>yes, you could just rename it and Oracle would open a new one of the
>original name when it needed to write to it.
>
>In 8.? and above, you can no longer just rename it, Oracle now maintains an
>open file pointer to it, similar to the way it handles the listener log
>file. So you will need to do the same sort of tricks to the alert log as 
>you
>
>have to do to the listener log (make a copy then copy /dev/null to the
>original)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sizing a new server

[Reardon, Bruce (CALBBAY)]

Hi Lisa,

I also have good feelings for VMS so don't see the problem with an Alpha.
As for the disk farms, the RAID 7000 gave very good performance on VMS so 2
of the es10K should be excellent.

You and your company are of course aware that Compaq is planning to stop
Alpha chip development in 2-3 years and will port Tru64, VMS and NonStop
Kernel OS to Itanium processor family. 
(if not see http://www.compaq.com/newsroom/pr/2001/pr2001062501.html 
and http://www.compaq.com/hps/ipf-enterprise/ceo_letter.html as starting
points).

Regards,
Bruce Reardon

-Original Message-
Sent: Wednesday, 11 July 2001 2:11 
To: Multiple recipients of list ORACLE-L


Hi Lisa,
 
That doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to
14 CPUs and 28G of memory. They have seriously good I/O bandwidth. Needs a
three-phase power supply and weighs, literally, half a tonne. And best of
all, you can run VMS on them!
 
g
 
-Original Message-
Sent: Tuesday, July 10, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L


Bruce, 
It's going to be Unix, tru64.  Unfortunately I will be stuck with some old
hardware to start with - an Alpha, 8400, I believe maxes out at 8 cpu's,
along with two old disk farms (compaq esa10k).  I'm slapping together a
bunch of old pieces of hardware, upgrading where needed, obtaining software
licensing where needed, compaq hardware/software support, and with some duct
tape, political brown-nosing done by others and a few users screaming for
their data, I'll hopefully end up with some sort of reporting tool hitting
this.  (BizObj or Cogno$).  Man Cognos is expensive. 
I wish I could choose AIX here.  It's not an option.  
See doesn't this sound like a director's job?? 
Say it again:  I LOVE MY JOB 
Lisa 
-Original Message- 
[SMTP:[EMAIL PROTECTED]] 
Sent:   Monday, July 09, 2001 8:50 PM 
To: Multiple recipients of list ORACLE-L 
Lisa, 
Some may laugh at the question but what OS - NT, Unix, VMS or ? 
Regards, 
Bruce Reardon 
-Original Message- 
Sent: Tuesday, 10 July 2001 4:36 
To: Multiple recipients of list ORACLE-L 


Thanks Kimberly, 
I wish it was that way.  I have to justify my request with hard numbers or 
they are going to laugh at me when I say, "Because that's what I want".  :) 
They don't yet know how I'd react to that, it would be a knee-jerk type of 
reaction involving creative expletives...  not pretty.  
Good for you.  At least you have some real hardware and true HA.  I wish I 
did 
Lisa 


-Original Message- 
Sent:   Monday, July 09, 2001 12:51 PM 
To: Multiple recipients of list ORACLE-L 
Get the biggest, kick ass server they will let you buy.  If your site is 
anything like mine they just keep asking for more and more databases.  So no

matter what I have now I know its not enough.  I am really happy with the 
nice new N-class HP cluster I have sitting next door running Service Guard. 
I am also getting a A-class database cluster for some important but not fab 
critical databases.  Now if I can only get ride of the 5 K-class database 
servers.  Its kind of like when you go from a fast to a slow PC.  Drives me 
crazy.  Not that there are issues with performance from the databases.  It 
would only be me, while playing (which of course means working) on the 
server, that would notice. 
-Original Message- 
Sent: Monday, July 09, 2001 8:30 AM 
To: Multiple recipients of list ORACLE-L 


Good morning everyone, 
Lucky me, I get to choose the size of the server this company should 
consider purchasing.  I have been poking around on the net for any 
guidelines - I can make guesses based upon my gut feel and how strapped the 
current unix server is, but I want to be able to back this up with hard 
numbers.  This is for a dw application. 
Can anyone point me to a website, book, or anything in particular that can 
help me justify sizing a machine?  It's so fun working for a company that 
doesn't have a sysadmin on staff...  
Thanks 
Lisa Koivu 
Oracle Data Bored Administrator 
Ft. Lauderdale, FL, USA 
954-935-4117 
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Jared . Still]

Try the Oracle 8i Admin guide for NT

Here's the ORADIM part:

http://www-wnt.gsi.de/oragsidoc/doc_817/win.817/a73008/ch5.htm#1027981


Jared



   

lhoska@calibre 

sys.com  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: oradim   

om 

   

   

07/10/01 12:23 

PM 

Please respond 

to ORACLE-L

   

   





Can anyone point to oradim utility documentation?  I am having a little
hard
time finding it.
Thank you.
Lyuda Hoska

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

HASH_MULTIBLOCK_IO_COUNT

[DBarbour]

Jared - we were wrong, there are worse applications than Remedy out there.
I may be involved with one now.  The application uses massive sql
statements generated from a VB front-end connecting to COBOL on the server
via ODBC that runs against the database.  Some of our power users have been
receiving intermittent ORA-03232 errors.

>From the manual:

ORA-03232 unable to allocate an extent of string blocks from tablespace
string

 Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value
 that is greater than the tablespace's NEXT value.
 Action: Increase the value of NEXT for the tablespace using ALTER
 TABLESPACE DEFAULT STORAGE or decrease the value of
 HASH_MULTIBLOCK_IO_COUNT.

HASH_MULTIBLOCK_IO_COUNT specifies how many sequential blocks a hash join
reads and writes in one IO. When operating in multi-threaded server mode,
however, this parameter is ignored (a value of 1 is used even if you set
the parameter to another value). Because Oracle computes the value for this
parameter based on the query, you need not set the value for this
parameter.

The maximum value for HASH_MULTIBLOCK_IO_COUNT varies by operating system.
It is always less than the operating system's maximum I/O size expressed as
Oracle blocks (max_IO_size/DB_BLOCK_SIZE).
This parameter strongly affects performance because it controls the number
of partitions into which the input is divided. If you change the parameter
value, try to make sure that the following formula remains true:

 R / M <= Po2(M/C)

where:
 R = size of(left input to the join)
 M = HASH_AREA_SIZE * 0.9
 Po2(n) = largest power of 2 that is smaller than n
 C = HASH_MULTIBLOCK_IO_COUNT * DB_BLOCK_SIZE

Right now, I don't want to alter the value of next, as this beast is barely
under control as it is.  So I thought I might change the value of
HASH_MULTIBLOCK_IO_COUNT.  Problem is, I can't seem to determine a value
for R.  v$sqlarea and v$sqltext don't seem to be of much help outside of
being able to see the actual sql. Ditto with a few others I've tried.

Any takers?  Oracle 8.1.7/HPUX 11(64 bit)

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Why default domain?

[Greg Moore]

The O'Reilly Net8 book states:

"It's possible to run a Net8 network without using domains at all."

If this is true, why create net service names that are qualified by a domain
name, why define a default domain in sqlnet.ora, etc.?  What benefit do you
get by setting things up to use a domain?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Privilege problem ?????

[Andrea Oracle]

Hi all,

I wrote a script for developers to run.  I have
svrmgrl, connect internal in the script.  The
developer got error since he doesn't have privileges. 
So how to make the script runnable by non dbas???

Thanks.

Andrea

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Email/Paging/Mobile Phone alerts

[Ravindra Basavaraja]

Does anyone have a similiar script for doing 
the same on Windows NT.
 
Thanks
Ravindra

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of John CarlsonSent: 
  Thursday, February 22, 2001 5:30 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: Email/Paging/Mobile Phone 
  alerts
  I will make the assumption this is on unix and you can write a shell 
  script.  Here is a skeleton of the code.  You can put your own 
  checks it.
   
  EXAMPLE 
  >>>
   
  #!/bin/ksh
   
  tail -1f alert_x.log | while read linedo
   
   any other code you want here.
   
      echo $line | grep ORA-    if [ $? 
  -eq 0 ] ; then    
  (    
  error=`echo $line | sed 
  's=:.*=='`    
  echo "To: [EMAIL PROTECTED]"    
  echo "Subject: `uname -n` 
  $error"    
  echo "`uname -n` 
  alert_log"    
  echo $prevline | sed 
  's=:=-='    
  echo $line | sed 's=:=-='    ) | 
  mail [EMAIL PROTECTED]    
  fi
   
      prevline=$line
   
  done
  <
   
  This will run perpetually and check every line the alert log 
  writes.  You can test for any messages you want and send messages to 
  whatever.  Note the sed command changes ':' to '-' because mail has a 
  problem with colons in the text body sometimes.  Also, some mail servers 
  cannot handle it properly without the extra "To:".  
   
  Obviously, this is just a snippet of code.  You need to customize it 
  for your own needs.  You may need to write other scripts to query the 
  database to get number of connections and active connections if you need 
  that.
   
  HTH,
  John Carlson
  http://www.cj.com
  >>> [EMAIL PROTECTED] 02/22/01 03:15PM 
  >>>I am looking at a solution of sending a 
  email/paging/Mobilephone alertsin case of a problem on the database that 
  is reported in the alert.logfile. like tablespace full,no. of processes 
  exceeded,instance going downetc.I want a solution other than 
  OEM.What are the other ways of sending suchalert to notify the person who 
  takes care of the database.Thanks-Ravindra-- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  Ravindra Basavaraja  INET: 
[EMAIL PROTECTED]

Re: How to execute Unix Command/program within a pl/sql block.

[Jared . Still]

Unless I disrember, you can create a PL/SQL wrapper for your
Java stored procedure, and call OS commands from that.

Another way is to create an external library to do it for you.
This can also be in in Java, or in C.

Jared



   

MHately@etech- 

uk.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Re: How to execute Unix 
Command/program within a pl/sql  
omblock.   

   

   

07/10/01 02:37 

AM 

Please respond 

to ORACLE-L

   

   







Hi,
you can't do this from PL/SQL but you can do it from Java and it's fairly
easy
too.  I'm not able to check the name of the class tht does it but armed
with the
phrase "java os command" and either the Metalink or "Ask Tom" web site you
should be able to track it down.

Regards,
Mike



|+--->
||  Stephane |
||  Faroult  |
||   |
||   |
||  07/10/01 |
||  12:20 AM |
||  Please   |
||  respond to   |
||  ORACLE-L |
||   |
|+--->
  >|
  ||
  |   To: Multiple recipients of list  |
  |   ORACLE-L <[EMAIL PROTECTED]>  |
  |   cc: (bcc: Mike Hately/ETECH) |
  |   Subject: Re: How to execute Unix |
  |   Command/program within a pl/sql block.   |
  >|




Seema Singh wrote:
>
> Hi
> How to execute unix command in PL/SQL ?
> Thanks in advance.
> -Seema

You can't. The nearest you can get is to write a daemon program which
waits for commands on a (dbms) pipe, executes them (popen(),
while(fgets()) {}, pclose() in C) and feeds the output back to the pipe.
Needless to say, it can be a serious security gap if you do not screen
the commands, since you are likely to execute them with the privileges
of the user under which the said program is run.
Many moons ago, there used to be something named 'flex' developed by
Oracle consultants and freely available on the web which was more or
less doing that. It may or may not still be around. I have had a look at
it after having developed my own (in Pro*Fortran and under VMS, nothing
stops me - no pipe, but a /OUTPUT=... was appended to the command and I
was reading and sending back the ouput file) and I can tell you that
Flex was unnecessarily complicated. To make simple seems very difficult
to many people.

--
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269
Fax:+44  (0) 7050-696-449
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

DBMS_STATS

[Anand Prakash]

Steve

You mentioned about dbms_stats having some teething problem on version 8.1.6. Can you 
provide some more details? I was planning to implement on version 8.1.6.2 on Compaq 
Tru64 unix 5.1.

Thanks.

Anand Prakash


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[ARUN K C]

when you create the bat file using the db assist
you should see in that bat file like below
set ORACLE_SID=orcl

e:\orant\bin\oradim80 -new -sid orcl -intpwd oracle -startmode auto -pfile 
e:\orant\database\initorcl.ora

e:\orant\bin\oradim80 -startup -sid orcl -starttype srvc,inst -usrpwd oracle 
-pfile e:\orant\database\initorcl.ora

As you must be knowing the first command of oradim is used for creating the 
service and the second is used for starting the database automatic.
there is no compulsary thing that the second command should run , but the 
first is a must otherwise NT will not allow you to start the database.




>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: oradim
>Date: Tue, 10 Jul 2001 11:23:24 -0800
>
>Can anyone point to oradim utility documentation?  I am having a little 
>hard
>time finding it.
>Thank you.
>Lyuda Hoska
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[George Schlossnagle]

Nope, you don't need an entry in the /etc/vfstab.  You can just do a

mountand you're set.

Of course that won't be remounted when you reboot unless you put it in the
vfstab.  This is a classic blunder (you mount a new fs by hand, add
datafiles and forget to add it to the vfstab.  Low and behold, when the box
is rebooted, all your file 'disapear')

Best,

George

p.s.  I believe that manually altering mnttab is very very bad.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 5:36 PM


> Shoot, had to look up pedantic...
>
> Ok, I agree that df looks at /etc/mnttab to see mounted file systems, but
in
> order for an SA to mount a slice of a disk, that slice information must be
> present in /etc/vfstab.  At least that's the way I learned.  It's possible
> to have a mounted file system without having an entry in /etc/vfstab??
How
> do you do that?  I guess I've never heard of this or tried to mount a
slice
> without putting an entry in /etc/vfstab first.  Can you manually
manipulate
> /etc/mnttab?
>
> Thanks,
>
> Julie
>
>
> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA - OCP8i
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
>
>
> -Original Message-
> Sent: July 10, 2001 2:50 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Not to be pedantic, but df -k shows all mounted partitions, regardless of
> whether they are in /etc/vfstab or not.  It requires read permisions on
> /etc/mnttab (whihc should be readable by everyone, but I suppose some sick
> SA could change it so that only root could read it.  The system would
> function normally, but non-root users wouldn't be able to use df
> functionally.
>
> George
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 4:29 PM
>
>
> > Richard,
> >
> > df -k will show you what slices of a disk have an entry in /etc/vfstab
AND
> > have been mounted using the mount command in Solaris.  Whoever has root
> > privileges to the system (or have been given the right permissions) can
> use
> > the format command to see all disks attached to the machine, no matter
if
> > they have been mounted or not - no matter if they have an entry in
> > /etc/vfstab or not.
> >
> > HTH,
> >
> > Julie
> >
> >
> >
> > Julie Fisher
> > Sandia National Laboratories
> > Oracle 8i DBA - OCP8i
> > Solaris 2.6,7/HP-UX 11.0 System Administrator
> > Web Server Administrator
> >
> >
> > -Original Message-
> > Sent: July 10, 2001 1:23 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Df -k
> >
> > This does not cover raid volumes, that would depend which volume manager
> > your using.
> >
> > -Original Message-
> > Sent: Tuesday, July 10, 2001 1:52 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Does anyone know of a command or file that would display the available
> disks
> > on a Solaris 2.6 box and/or the corresponding disks for each mount
> point???
> >
> > TIA,
> > Richard Huntley
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Richard Huntley
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > 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.com
> > --
> > Author: Christopher Spence
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > 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.com
> > --
> > Author: Fisher, Julie
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 

Re: need to recreate database

[Jonathan Gennick]

Tuesday, July 10, 2001, 1:26:38 PM, Lyuda wrote:
lcc> I have not done it before and if I was doing it I would probably do
lcc> export/import type of thing but the higher ups would like to have it done
lcc> this way.

Uh oh. Damagement at work again. Let the "higher ups" do it
themselves if they are that picky.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[ARUN K C]

If you have already installed the oracle binaries on the machine the next 
thing you should do is to use oradim utility
or the best thing is
use database assistant which will create the oradim script for you.In order 
to get this oradim script all you have to do is to save the database 
creation script which in turn will create BAT files if it FAT OR cmd files 
if it NTFS.
edit this bat file (DONT RUN IT or double click on it)u will find the oradim 
script which you copy it onto another batch job and run it which will create 
the services for you.



>From: "Jack C. Applewhite" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: oradim
>Date: Tue, 10 Jul 2001 13:02:17 -0800
>
>Lyuda,
>
>Besides a brief mention in the Oracle8i for Windows 2000 Release Notes, all
>I've found (and needed, for that matter) is via executing "oradim -help" at
>the command line.  Oradim doesn't do very much and "oradim -help" lays it
>all out for you.
>
>Jack
>
>
>Jack C. Applewhite
>Database Administrator/Developer
>OCP Oracle8 DBA
>iNetProfit, Inc.
>Austin, Texas
>www.iNetProfit.com
>[EMAIL PROTECTED]
>(512)327-9068
>
>
>-Original Message-
>[EMAIL PROTECTED]
>Sent: Tuesday, July 10, 2001 2:23 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Can anyone point to oradim utility documentation?  I am having a little 
>hard
>time finding it.
>Thank you.
>Lyuda Hoska
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jack C. Applewhite
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Jared . Still]

Richard,

I think I know what you want. If you are trying to determine the actual
physical
disks that your datafiles are layed out on, and you're on Solaris, you
probably
need to use the 'vxprint' command.  This assuming you have Veritas volume
manager, which many Solaris sites use.

What you find may surprise  you.  I know I was when I discovered the TEMP
file system mapped onto the spare space on 156 physical disks.

Jared

-
#!/bin/ksh
#
# Script to convert a File System mount point to a list of disks in ssdxx
form
#

# jkstill 02/24/2000 - some mods to make this much faster

PROG=$(print $0 | sed -e 's,.*/,,g') # Name of this program
USAGE_MESSAGE="Usage: $PROG filesystem"

if (( $# != 1 )); then
   print $USAGE_MESSAGE
   exit 1
fi

VX_TMP_FILE=/tmp/vxprint.out.$$

DFOUT=$( df -k $1 | grep -v Filesystem | awk '{ print $1 }' )
VXDG="`echo $DFOUT | cut -f5 -d/`"
VXVOL="`echo $DFOUT | cut -f6 -d/`"

#print DFOUT = $DFOUT
#print VXDG  = $VXDG
#print VXVOL = $VXVOL

vxprint -tsg $VXDG | grep $VXVOL | cut -c67-74 >| $VX_TMP_FILE

#print 1 = $1

while read device
do
   #print $device
   Y=$( /bin/ls -lL /dev/dsk/${device}s0 | /bin/cut -f2 -d, | /bin/awk '{
print $1 }' )
   #print $Y
   ((Z = Y / 8))
   print ssd${Z}
done < $VX_TMP_FILE
-




   
  
Richard Huntley
  
   
aders.com> cc: 
  
Sent by:   Subject: UNIX   
  
[EMAIL PROTECTED]   
  
   
  
   
  
07/10/01 10:51 
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Does anyone know of a command or file that would display the available
disks
on a Solaris 2.6 box and/or the corresponding disks for each mount point???

TIA,
Richard Huntley

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

lock problem

[Harvinder Singh]

Hi,

we need to create a index on hot table(lot of updates r going on) but we r
getting error:
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
when i use create indexonline it just hangs there...
Is there any option to create index while not stopping the batch updates.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Fisher, Julie]

Shoot, had to look up pedantic...

Ok, I agree that df looks at /etc/mnttab to see mounted file systems, but in
order for an SA to mount a slice of a disk, that slice information must be
present in /etc/vfstab.  At least that's the way I learned.  It's possible
to have a mounted file system without having an entry in /etc/vfstab??  How
do you do that?  I guess I've never heard of this or tried to mount a slice
without putting an entry in /etc/vfstab first.  Can you manually manipulate
/etc/mnttab?

Thanks,

Julie


Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: July 10, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L


Not to be pedantic, but df -k shows all mounted partitions, regardless of
whether they are in /etc/vfstab or not.  It requires read permisions on
/etc/mnttab (whihc should be readable by everyone, but I suppose some sick
SA could change it so that only root could read it.  The system would
function normally, but non-root users wouldn't be able to use df
functionally.

George


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 4:29 PM


> Richard,
>
> df -k will show you what slices of a disk have an entry in /etc/vfstab AND
> have been mounted using the mount command in Solaris.  Whoever has root
> privileges to the system (or have been given the right permissions) can
use
> the format command to see all disks attached to the machine, no matter if
> they have been mounted or not - no matter if they have an entry in
> /etc/vfstab or not.
>
> HTH,
>
> Julie
>
>
>
> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA - OCP8i
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
>
>
> -Original Message-
> Sent: July 10, 2001 1:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Df -k
>
> This does not cover raid volumes, that would depend which volume manager
> your using.
>
> -Original Message-
> Sent: Tuesday, July 10, 2001 1:52 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Does anyone know of a command or file that would display the available
disks
> on a Solaris 2.6 box and/or the corresponding disks for each mount
point???
>
> TIA,
> Richard Huntley
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Fisher, Julie
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: George Schlossnagle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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
als

RE: oradim

[Jack C. Applewhite]

Lyuda,

Besides a brief mention in the Oracle8i for Windows 2000 Release Notes, all
I've found (and needed, for that matter) is via executing "oradim -help" at
the command line.  Oradim doesn't do very much and "oradim -help" lays it
all out for you.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L


Can anyone point to oradim utility documentation?  I am having a little hard
time finding it.
Thank you.
Lyuda Hoska


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Richard Ji]

You do have 4 disks, it's t0, t1, t2 and t3.  Each target is a separate disk.
You can use the "format" command to see the disks and it's partitions.

>>> [EMAIL PROTECTED] 07/10/01 04:20PM >>>
Joe, Chris
 
uh, yeah Joe, I guess that's what I'm asking...I'm just trying to map
the tablespaces/datafiles to the disk and "df -k" gives me something like
 
FilesystemMounted on
/dev/dsk/c0t3d0s0 /
/proc   /proc
fd   /dev/fd
/dev/dsk/c0t3d0s1/tmp
/dev/dsk/c0t0d0s0/u01
/dev/dsk/c0t0d0s1/u02
/dev/dsk/c0t0d0s3/u03
/dev/dsk/c0t1d0s0/u04
/dev/dsk/c0t1d0s1/u05
/dev/dsk/c0t1d0s3/u06
/dev/dsk/c0t2d0s0/u07
/dev/dsk/c0t2d0s1/u08
/dev/dsk/c0t2d0s3/u09
  
I'm expecting that to correspond to something like (c)ontroller, (t)arget,
(d)isk and (s)lice.  However, I know there are at least 4 disks while
everything is displaying as d0 and it's a test box so no RAID.  However, I
do have a box that uses RAID 5 and the same info would be helpful, however,
the person
that did the original configuration is gone bye-bye, that's why I was
wondering if there were any sys admin commands or a filie in the /etc or
some other standard UNIX directory that would tell me this info.  

Richard Huntley 


-Original Message-
Sent: Tuesday, July 10, 2001 3:28 PM
To: Multiple recipients of list ORACLE-L



Richard, are you asking about how to see the underlying striping/slicing?  I
thought only the unix/sysadmin could tell you for sure, or the person who
did the original slicing.
 
joe
 
 
 


>>> [EMAIL PROTECTED] 07/10/01 01:51PM >>>
Does anyone know of a command or file that would display the available disks
on a Solaris 2.6 box and/or the corresponding disks for each mount point???

TIA,
Richard Huntley

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Vergara, Michael (TEM)]

Somebody posted this url here a 
while back.  It's a pretty neat tool, but you gotta have root access to run 
it.

http://members.tripod.com/rose_swe/cfg/cfg.html
 
---
===
Michael P. 
Vergara  
| I’ve got a PBS mind in an MTV world
Oracle 
DBA  
|
Guidant 
Corporation 
|

  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 1:21 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  UNIX
  Joe, 
Chris
   
  uh, yeah Joe, I guess 
  that's what I'm asking...I'm just trying to map the tablespaces/datafiles to 
  the disk and "df -k" gives me something like
   
  Filesystem    
  Mounted on/dev/dsk/c0t3d0s0 
  //proc   
  /procfd   
  /dev/fd/dev/dsk/c0t3d0s1/tmp/dev/dsk/c0t0d0s0/u01/dev/dsk/c0t0d0s1/u02/dev/dsk/c0t0d0s3/u03/dev/dsk/c0t1d0s0/u04/dev/dsk/c0t1d0s1/u05/dev/dsk/c0t1d0s3/u06/dev/dsk/c0t2d0s0/u07/dev/dsk/c0t2d0s1/u08/dev/dsk/c0t2d0s3/u09
    
  I'm expecting that to 
  correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice.  
  However, I know there are at least 4 disks while everything is displaying 
  as d0 and it's 
  a test box so no RAID.  However, I do have a box that uses RAID 5 and the 
  same info would be helpful, however, the person
  that did the original 
  configuration is gone bye-bye, that's why I was wondering if there were any 
  sys admin commands or a filie in the /etc or some other standard UNIX 
  directory that would tell me this info.  
  Richard Huntley 
  -Original Message-From: JOE 
  TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 
  3:28 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: UNIX
  Richard, are you asking about how to see the underlying 
  striping/slicing?  I thought only the unix/sysadmin could tell you for 
  sure, or the person who did the original slicing.
   
  joe
   
   
   
  >>> [EMAIL PROTECTED] 07/10/01 01:51PM 
  >>>Does anyone know of a command or file that would display the 
  available diskson a Solaris 2.6 box and/or the corresponding disks for 
  each mount point???TIA,Richard Huntley-- Please see 
  the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  Richard Huntley  INET: [EMAIL PROTECTED]Fat City 
  Network Services    -- (858) 538-5051  FAX: (858) 
  538-5051San Diego, California    -- 
  Public Internet access / Mailing 
  ListsTo 
  REMOVE yourself from this mailing list, send an E-Mail messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
  BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing 
  list you want to be removed from).  You mayalso send the HELP command 
  for other information (like subscribing).

Re: UNIX

[George Schlossnagle]

Not to be pedantic, but df -k shows all mounted partitions, regardless of
whether they are in /etc/vfstab or not.  It requires read permisions on
/etc/mnttab (whihc should be readable by everyone, but I suppose some sick
SA could change it so that only root could read it.  The system would
function normally, but non-root users wouldn't be able to use df
functionally.

George


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 4:29 PM


> Richard,
>
> df -k will show you what slices of a disk have an entry in /etc/vfstab AND
> have been mounted using the mount command in Solaris.  Whoever has root
> privileges to the system (or have been given the right permissions) can
use
> the format command to see all disks attached to the machine, no matter if
> they have been mounted or not - no matter if they have an entry in
> /etc/vfstab or not.
>
> HTH,
>
> Julie
>
>
>
> Julie Fisher
> Sandia National Laboratories
> Oracle 8i DBA - OCP8i
> Solaris 2.6,7/HP-UX 11.0 System Administrator
> Web Server Administrator
>
>
> -Original Message-
> Sent: July 10, 2001 1:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Df -k
>
> This does not cover raid volumes, that would depend which volume manager
> your using.
>
> -Original Message-
> Sent: Tuesday, July 10, 2001 1:52 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Does anyone know of a command or file that would display the available
disks
> on a Solaris 2.6 box and/or the corresponding disks for each mount
point???
>
> TIA,
> Richard Huntley
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Richard Huntley
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Christopher Spence
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Fisher, Julie
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: George Schlossnagle
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: need to recreate database

[DBarbour]

Lyuda,

My guess is that if your networking folks performed the "copy" for you and
now all you have to do is get it up and running, you're probably better off
starting over.  If the database wasn't shutdown when the controlfiles were
copied, you're hosed.  I have no idea what you mean by copying the
datafiles - if the whole thing was shut down when the copies were made,
then why would you have to do an import/export? - the data is already
there.

Let's suppose that the networking guys knew about Oracle, and had shut
everything down before copying it (and copied) everything they needed to.
Safest bet is to move all the stuff to someplace else on your server or
another server, and follow this advice from Note #1080849.6 :

   

   1. Install the Oracle 
software  
   on server B.  You 
cannot simply 
   copy the orant folder 
to the
   new machine.  Registry 
entries  
   must be modified, file  

   dependencies between 
Oracle and 
   the Operating system, 
and   
   between multiple Oracle 
homes   
   (if applicable) must be 

   checked, services must 
be   
   created, etc.   

   

   2. Shut down the 
instance on
   server A.   

   

   3. Move all the data 
files, 
   redologs, archive logs, 
control 
   files, listener.ora,

   tnsnames.ora, 
init.ora and 
   config.ora to 
server B.
   

   4. On server B, open a 
Command  
   Window and execute the  

   following command:  

   

  oradim80 -new -sid 
sidname   
   -intpwd password -pfile 

   path_to_init_file 
-startmode
   auto

   

   5. Change the 
listener.ora to   
   reflect server B's 
hostname.
   

   6. Change all the 
tnsnames.ora  
   files on the clients to 
reflect 
   server B's hostname.

   

   7. Restart the 
listener.
   

   8. Edit the 
init.ora dna   
   config.ora files 
to
   reflect the correct 
directory   
   paths on server B for 
your  
  

RE: UNIX

[JOE TESTA]

Richard, as for the raid one, you'll need to find out what 
raid software is being used and that should let you peek underneath the logical 
volumes to see how the physical disks are sliced/diced.
 
 
joe
>>> [EMAIL PROTECTED] 07/10/01 04:20PM 
>>>
Joe, Chris
 
uh, yeah Joe, I guess 
that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the 
disk and "df -k" gives me something like
 
Filesystem    
Mounted on/dev/dsk/c0t3d0s0 
//proc   
/procfd   
/dev/fd/dev/dsk/c0t3d0s1/tmp/dev/dsk/c0t0d0s0/u01/dev/dsk/c0t0d0s1/u02/dev/dsk/c0t0d0s3/u03/dev/dsk/c0t1d0s0/u04/dev/dsk/c0t1d0s1/u05/dev/dsk/c0t1d0s3/u06/dev/dsk/c0t2d0s0/u07/dev/dsk/c0t2d0s1/u08/dev/dsk/c0t2d0s3/u09
  
I'm expecting that to 
correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice.  
However, I know there are at least 4 disks while everything is displaying 
as d0 and it's a 
test box so no RAID.  However, I do have a box that uses RAID 5 and the 
same info would be helpful, however, the person
that did the original 
configuration is gone bye-bye, that's why I was wondering if there were any sys 
admin commands or a filie in the /etc or some other standard UNIX directory that 
would tell me this info.  
Richard Huntley 
-Original Message-From: JOE 
TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 
3:28 PMTo: Multiple recipients of list ORACLE-LSubject: 
Re: UNIX
Richard, are you asking about how to see the underlying 
striping/slicing?  I thought only the unix/sysadmin could tell you for 
sure, or the person who did the original slicing.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 07/10/01 01:51PM 
>>>Does anyone know of a command or file that would display the 
available diskson a Solaris 2.6 box and/or the corresponding disks for each 
mount point???TIA,Richard Huntley-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard 
Huntley  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: Installation oracle through responsefile

[Terry Ball]

With WWS help, we have tried the non-interactive installation. We have
NEVER gotten it to succeed.

Terry

Brijesh Lal wrote:

> Hi All
>
> I am trying to install oracle 8.16 in non-interactive
> mode(silent) mode. However installation does not
> proceed and fails
> I am giving following command
> runInstaller -silent -responsefile /oracle/response/
> ee_typical.rsp
> However in /tmp/silentInstall.log I get following
> error
>
> No forced value specified for the variable
> ORACLE_HOME, associated with
> property ToLocation, in dialog
> oracle.sysman.oii.oiif.oiifw.OiifwInstLocWCDE
>
> This silent installation was unsuccessful.
> Warning :*** Alert: Do you really want to exit? ***
>
> I have done following setting in ee_typical.rsp
> UNIX_GROUP_NAME="dba"
>
> #FROM_LOCATION;String;Used in Dialog
> #Full path for the products.jar file.
> FROM_LOCATION="/data1/cdrom1/stage/products.jar"
>
> #ORACLE_HOME;String;Used in Dialog
> ORACLE_HOME="/oracle/product/8.1.5"
>
> Can anyone please help in solving this problem
> Thanks for the help in advance
>
> Regards
>
> Brijesh
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brijesh Lal
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Terry Ball
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Fisher, Julie]

Richard,

df -k will show you what slices of a disk have an entry in /etc/vfstab AND
have been mounted using the mount command in Solaris.  Whoever has root
privileges to the system (or have been given the right permissions) can use
the format command to see all disks attached to the machine, no matter if
they have been mounted or not - no matter if they have an entry in
/etc/vfstab or not.

HTH,

Julie



Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: July 10, 2001 1:23 PM
To: Multiple recipients of list ORACLE-L


Df -k

This does not cover raid volumes, that would depend which volume manager
your using.

-Original Message-
Sent: Tuesday, July 10, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


Does anyone know of a command or file that would display the available disks
on a Solaris 2.6 box and/or the corresponding disks for each mount point???

TIA,
Richard Huntley

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Fisher, Julie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Richard Huntley]

Joe, Chris
 
uh, yeah Joe, I guess 
that's what I'm asking...I'm just trying to map the tablespaces/datafiles to the 
disk and "df -k" gives me something like
 
Filesystem    
Mounted on/dev/dsk/c0t3d0s0 
//proc   
/procfd   
 
/dev/fd/dev/dsk/c0t3d0s1/tmp/dev/dsk/c0t0d0s0/u01/dev/dsk/c0t0d0s1/u02/dev/dsk/c0t0d0s3/u03/dev/dsk/c0t1d0s0/u04/dev/dsk/c0t1d0s1/u05/dev/dsk/c0t1d0s3/u06/dev/dsk/c0t2d0s0/u07/dev/dsk/c0t2d0s1/u08/dev/dsk/c0t2d0s3/u09
  
I'm expecting that to 
correspond to something like (c)ontroller, (t)arget, (d)isk and (s)lice.  
However, I know there are at least 4 disks while everything is displaying 
as d0 and it's a 
test box so no RAID.  However, I do have a box that uses RAID 5 and the 
same info would be helpful, however, the person
that did the original 
configuration is gone bye-bye, that's why I was wondering if there were any sys 
admin commands or a filie in the /etc or some other standard UNIX directory that 
would tell me this info.  
Richard Huntley 
-Original Message-From: JOE 
TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 
3:28 PMTo: Multiple recipients of list ORACLE-LSubject: 
Re: UNIX
Richard, are you asking about how to see the underlying 
striping/slicing?  I thought only the unix/sysadmin could tell you for 
sure, or the person who did the original slicing.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 07/10/01 01:51PM 
>>>Does anyone know of a command or file that would display the 
available diskson a Solaris 2.6 box and/or the corresponding disks for each 
mount point???TIA,Richard Huntley-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard 
Huntley  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: Rename alert log

[Richard Ji]

Does anyone know starting from which version you have to do the tricky
thing to rename the alert.log?  Or is this only apply to certain OS platforms?

I am on 8.1.7 EE on Solaris8 and I can still just move the alert.log and
Oracle will just recreate one when it needs to write the next message.

I don't like this new rule that you have to copy it and then null the alert log
since those are two separate operations.  I can loss a message or two if
there is a lag after the copying is done and before nulling the log file.

>>> [EMAIL PROTECTED] 07/10/01 01:26PM >>>
depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you 
have to do to the listener log (make a copy then copy /dev/null to the 
original)



>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED] 
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rename alert log
>Date: Tue, 10 Jul 2001 06:56:31 -0800
>
>Can the alert log be renamed while the database is up and running?
>
>Ron
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT - get together for list participants in DC area

[Mohan, Ross]

:)

-Original Message-
Sent: Tuesday, July 10, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L


Or the eau de fava bean...

"Mohan, Ross" wrote:
> 
> It's possible, sure..good idea.
> 
> It may just wind up being you and I
> Alex, in which case I can buy your beersif you don't mind the speedo.
> 
> :)
> 
> -Original Message-
> Sent: Monday, July 09, 2001 5:26 PM
> To: Multiple recipients of list ORACLE-L
> 
> There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston
Oracle
> building. Details on www.maop.org  I am doing presentation about LMT,
> temporary tablespaces and Global Temporary tables( very rude sel promo
:-)).
> I think it can be good opportunity to meet. After that we can go to get
> couple of beers etc. I do not know that area very well, so any suggestions
> welcome.
> 
> Alex Hillman

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: need to recreate database

[Tim Gardner]

Lyuda,

If the database is still running on the old server, and the disk 
structure is the same on the new server, the easiest way is to do an 
export of the old database and an import with full=Y on the new 
server.

If the database was shut down before the files were copied, this 
should also work, but you will need to set up the SID on the new 
server and have the init.ora point to the copied files.

Tim

>I need to recreate a database, basically make a complete copy of one of the
>existing databases on a new server.  My networking people already copied all
>datafiles, control file, log files, init file, etc to the target server.
>They also reproduced operating system directory structure.
>What I need to do is to make the second part of the task work, create the
>database, services, etc and make it run.
>I have not done it before and if I was doing it I would probably do
>export/import type of thing but the higher ups would like to have it done
>this way.
>One of the people has an idea suggesting just recreating the registry
>setting by exporting it from the existing machine to the new one.
>The other option is to reinstall Oracle but I am not sure how to make it to
>accept existing physical components(datafiles, control file, etc).
>If someone has a suggestion I would greatly appreciate it.
>Thank you in advance.
>
>Lyuda Hoska
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.com
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
-- 
Author: Tim Gardner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Installation oracle through responsefile

[Brijesh Lal]

Hi All

I am trying to install oracle 8.16 in non-interactive
mode(silent) mode. However installation does not
proceed and fails 
I am giving following command
runInstaller -silent -responsefile /oracle/response/
ee_typical.rsp
However in /tmp/silentInstall.log I get following
error

No forced value specified for the variable
ORACLE_HOME, associated with
property ToLocation, in dialog 
oracle.sysman.oii.oiif.oiifw.OiifwInstLocWCDE

This silent installation was unsuccessful.
Warning :*** Alert: Do you really want to exit? ***


I have done following setting in ee_typical.rsp
UNIX_GROUP_NAME="dba"

#FROM_LOCATION;String;Used in Dialog
#Full path for the products.jar file.
FROM_LOCATION="/data1/cdrom1/stage/products.jar"

#ORACLE_HOME;String;Used in Dialog
ORACLE_HOME="/oracle/product/8.1.5"

Can anyone please help in solving this problem
Thanks for the help in advance

Regards

Brijesh

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brijesh Lal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT - get together for list participants in DC area

[Scott Shafer]

Or the eau de fava bean...

"Mohan, Ross" wrote:
> 
> It's possible, sure..good idea.
> 
> It may just wind up being you and I
> Alex, in which case I can buy your beersif you don't mind the speedo.
> 
> :)
> 
> -Original Message-
> Sent: Monday, July 09, 2001 5:26 PM
> To: Multiple recipients of list ORACLE-L
> 
> There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston Oracle
> building. Details on www.maop.org  I am doing presentation about LMT,
> temporary tablespaces and Global Temporary tables( very rude sel promo :-)).
> I think it can be good opportunity to meet. After that we can go to get
> couple of beers etc. I do not know that area very well, so any suggestions
> welcome.
> 
> Alex Hillman

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Satish Iyer]

For the listener I had do the following to get listener 
to archive its old logs
lsnrctl set log_file 
$ORACLE_HOME/network/log/listener1.log    
mv  $ORACLE_HOME/network/log/listener.log  
$ORACLE_HOME/network/log/listener.log.$QUALIFIER    
lsnrctl set log_file $ORACLE_HOME/network/log/listener.log
 
But for alert.log it works fine with a simple mv
 
mv  
$ORACLE_BASE/admin/$SID/bdump/alert_$SID.log 
\    
$ORACLE_BASE/admin/$SID/bdump/alert_$SID.log.$QUALIFIER
 
We are on 8.1.5.
 
Satish>>> [EMAIL PROTECTED] 07/10/01 10:26AM 
>>>depends on the version of the database you are running.. it used 
to be that yes, you could just rename it and Oracle would open a new one of 
the original name when it needed to write to it.In 8.? and above, 
you can no longer just rename it, Oracle now maintains an open file pointer 
to it, similar to the way it handles the listener log file. So you will need 
to do the same sort of tricks to the alert log as you have to do to the 
listener log (make a copy then copy /dev/null to the 
original)>From: "Smith, Ron L." 
<[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: 
Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>>Subject: Rename alert log>Date: Tue, 
10 Jul 2001 06:56:31 -0800>>Can the alert log be renamed while the 
database is up and running?>>Ron>-->Please see the 
official ORACLE-L FAQ: http://www.orafaq.com>-->Author: 
Smith, Ron L.>   INET: [EMAIL PROTECTED]>>Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051>San Diego, California    
-- Public Internet access / Mailing 
Lists>>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 
your FREE download of MSN Explorer at http://explorer.msn.com-- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rachel 
Carmichael  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: UNIX

[JOE TESTA]

Richard, are you asking about how to see the underlying 
striping/slicing?  I thought only the unix/sysadmin could tell you for 
sure, or the person who did the original slicing.
 
joe
 
 
 
>>> [EMAIL PROTECTED] 07/10/01 01:51PM 
>>>Does anyone know of a command or file that would display the 
available diskson a Solaris 2.6 box and/or the corresponding disks for each 
mount point???TIA,Richard Huntley-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard 
Huntley  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Rename alert log

[Mark Leith]

Yup

-Original Message-
L.
Sent: Tuesday, July 10, 2001 03:57
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Jon Baker]

Title: RE: Rename alert log





same here.


jon



-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rename alert log



I am running 8.1.7 and just last week renamed my alert.log while the
database was up and everything seemed to work fine.  It created a new alert
log on the fly.


Dave

oradim

[lhoska]

Can anyone point to oradim utility documentation?  I am having a little hard
time finding it.
Thank you.
Lyuda Hoska

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Farnsworth, Dave]

Oh yea, I forgot to mention that I have Oracle running on NT.  :(

Dave

-Original Message-
Sent: Tuesday, July 10, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L


I am running 8.1.7 and just last week renamed my alert.log while the
database was up and everything seemed to work fine.  It created a new alert
log on the fly.

Dave

-Original Message-
Sent: Tuesday, July 10, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


In 816 on NT, you can rename it any time you want.

is this changing in 817 Rachel?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, July 10, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the 
original)



>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rename alert log
>Date: Tue, 10 Jul 2001 06:56:31 -0800
>
>Can the alert log be renamed while the database is up and running?
>
>Ron
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: help how get the n top rows for any table?

[Breno A. K. Magnago]

Alexander,

Tuesday, July 10, 2001, 1:45:51 PM, you wrote:

AO> Hi, gurus!!!

AO> A need know how get n top row for any table somebody can help me!!

AO> Thanks!!!

AO> @lex
AO> 
AO>   Lic. Alexander Ordóñez Arroyo 
AO>   Caja Costarricense del Seguro Social 
AO>   Soporte Técnico - División de Informática 
AO>   Telefono: 295-2004, San José, Costa Rica
AO>   [EMAIL PROTECTED]

AO> 
AO> UNIX is very user friendly, 
AO> It's just very particular about who it makes friends with.


Example with ROWNUM :

SELECT COD
FROM DETAIL
WHERE ROWNUM < 5
ORDER BY COD DESC

This script gets 4 tops rows

-- 
Breno A. K. Magnagomailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Breno A. K. Magnago
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[Weaver, Walt]

Specifically, what Steve and I are looking for are a list of things that, in
8i, were NOT included in the Standard Edition but MIGHT be included in the
Standard Edition in 9i. Bitmapped indexes, partitioning, and transportable
tablespaces are a few. 

Oracle has done this sort of thing in the past, if my memory is as good as I
think it is.

We're up here busily building an Enterprise-level, worldwide hosting system
the likes of which the world has never seen. We're trying to make ourselves
look like heroes by increasing the speed and efficiency of our hosting
platform without touching the application code (we're not allowed to). 

It's kinda like trying to break the sound barrier in an F-18 but being told
we can't turn on the engines.

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Tuesday, July 10, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L



This is the list for 8i:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server
.817/a76962/ch4.htm

http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm   

http://technet.oracle.com/doc/server.815/a68020/ch4.htm  


Although they are two different URL's the 8.1.6 and 8.1.7 pages look the 
same.  I haven't found anything for 9i yet.


>Rachel Carmichael - [EMAIL PROTECTED] on 7/10/2001 12:25 PM writes us:

>
>haven't found it in the concepts manual... can't remember where it was in 
>the 8i docs
>
>
>>From: "Orr, Steve" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: RE: O9i Licensing
>>Date: Tue, 10 Jul 2001 06:05:25 -0800
>>
>>Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
>>Edition features?
>>
>>Steve
>>
>>
>>-Original Message-
>>Sent: Monday, July 09, 2001 7:21 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>According to the 9i concepts manual, there is a standard and enterprise
>>edition.
>>
>>
>> >From: "Orr, Steve" <[EMAIL PROTECTED]>
>> >Reply-To: [EMAIL PROTECTED]
>> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>> >Subject: O9i Licensing
>> >Date: Mon, 09 Jul 2001 15:36:30 -0800
>> >
>> >Anyone familiar with Oracle9i Licensing... is there still a standard
>> >edition
>> >versus an enterprise edition? At OpenWorld LEllison said there would
only
>> >be
>> >two types of licenses for Oracle... the database server and the 
>>application
>> >server. If that's the case is there nolonger a standard vs enterprise
>> >license?
>> >
>> >On a related note, our sales rep said that 80% of Oracle's customer base

>>is
>> >on standard edition and only 20% is on enterprise edition. A lot less
>> >enterprise licenses than I would have thought. I believe the recent
>> >"decrease" in license fees is only true for enterprise edition but 
>>actually
>> >could amount to a price increase for standard edition if you were using
>> >power units.
>> >
>> >Feeling like a second class citizen... stuck with standard edition and
in
>> >need of transportable tablespaces, bitmapped indexes, function-based
>> >indexes, and PQO...
>> >Steve Orr
>> >
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> >--
>> >Author: Orr, Steve
>> >   INET: [EMAIL PROTECTED]
>> >
>> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>> >San Diego, California-- Public Internet access / Mailing Lists
>> >
>> >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 your FREE download of MSN Explorer at http://explorer.msn.com
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Rachel Carmichael
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>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.com
>>--
>>Author: Orr, Steve
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>--

Re: need to recreate database

[JOE TESTA]

>>> [EMAIL PROTECTED] 07/10/01 01:26PM 
>>>Hello,I need to recreate a database, basically make a 
complete copy of one of theexisting databases on a new server.  My 
networking people already copied alldatafiles, control file, log files, init 
file, etc to the target server.They also reproduced operating system 
directory structure.What I need to do is to make the second part of the task 
work, create thedatabase, services, etc and make it run.I have not done 
it before and if I was doing it I would probably doexport/import type of 
thing but the higher ups would like to have it donethis way.One of the 
people has an idea suggesting just recreating the registrysetting by 
exporting it from the existing machine to the new one.The other option is to 
reinstall Oracle but I am not sure how to make it toaccept existing physical 
components(datafiles, control file, etc).If someone has a suggestion I would 
greatly appreciate it.Thank you in advance.Lyuda Hoska-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

No Subject

[Joseph Testa]

Registry, services?

OH wait must be an NT thing, sorry, i was having an acid flashback that unix 
was going down the tubes.

Sorry, joe

Coed-naked Database Administration
Find 'em fragmented, leave 'em coalesced.




>>>[EMAIL PROTECTED] 07/10/01 01:26PM >>>
Hello,
I need to recreate a database, basically make a complete copy of one of the
existing databases on a new server.  My networking people already copied all
datafiles, control file, log files, init file, etc to the target server.
They also reproduced operating system directory structure.
What I need to do is to make the second part of the task work, create the
database, services, etc and make it run.
I have not done it before and if I was doing it I would probably do
export/import type of thing but the higher ups would like to have it done
this way.
One of the people has an idea suggesting just recreating the registry
setting by exporting it from the existing machine to the new one.
The other option is to reinstall Oracle but I am not sure how to make it to
accept existing physical components(datafiles, control file, etc).
If someone has a suggestion I would greatly appreciate it.
Thank you in advance.

Lyuda Hoska

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Christopher Spence]

Df -k

This does not cover raid volumes, that would depend which volume manager
your using.

-Original Message-
Sent: Tuesday, July 10, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


Does anyone know of a command or file that would display the available disks
on a Solaris 2.6 box and/or the corresponding disks for each mount point???

TIA,
Richard Huntley

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Farnsworth, Dave]

I am running 8.1.7 and just last week renamed my alert.log while the
database was up and everything seemed to work fine.  It created a new alert
log on the fly.

Dave

-Original Message-
Sent: Tuesday, July 10, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


In 816 on NT, you can rename it any time you want.

is this changing in 817 Rachel?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, July 10, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the 
original)



>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rename alert log
>Date: Tue, 10 Jul 2001 06:56:31 -0800
>
>Can the alert log be renamed while the database is up and running?
>
>Ron
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Jesse, Rich]

Hmmm...in Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX
10.20/11.0, a rename of the alert log causes a new one to be created with
the next message.  My "AlertLogChecker" renames the alert log if it finds an
error in there.  As I'm attempting to size partitions for a non-partitioned
table, I can tell you the rename of the alert log works very well (I've got
20+ renamed logs in my test DB's bdump dir)!  :)

OTOH, most, if not all versions of Oracle on OpenVMS *will* keep open the
alert log (and the udump trace/log files) like you describe.  Just the
nature of I/O on OpenVMS, probably due to it's superior file handling and
lack of OpenVMS experience on Oracle's OpenVMS porting (look at the DCL
they've created).  :D

Rich Jesse  System/Database Administrator, OpenVMS
bigot
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Tuesday, July 10, 2001 12:27
To: Multiple recipients of list ORACLE-L


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the 
original)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Rachel Carmichael]

dunno about NT, I do know that it changed on Unix.. as per a thread here in 
the not too distant past. I believe Anita had posted something on it.. and 
that it WAS a change from prior versions.

I am an Oracle on NT ignoramus :)



>From: "Mercadante, Thomas F" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rename alert log
>Date: Tue, 10 Jul 2001 10:00:34 -0800
>
>In 816 on NT, you can rename it any time you want.
>
>is this changing in 817 Rachel?
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-Original Message-
>Sent: Tuesday, July 10, 2001 1:27 PM
>To: Multiple recipients of list ORACLE-L
>
>
>depends on the version of the database you are running.. it used to be that
>yes, you could just rename it and Oracle would open a new one of the
>original name when it needed to write to it.
>
>In 8.? and above, you can no longer just rename it, Oracle now maintains an
>open file pointer to it, similar to the way it handles the listener log
>file. So you will need to do the same sort of tricks to the alert log as 
>you
>
>have to do to the listener log (make a copy then copy /dev/null to the
>original)
>
>
>
> >From: "Smith, Ron L." <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Rename alert log
> >Date: Tue, 10 Jul 2001 06:56:31 -0800
> >
> >Can the alert log be renamed while the database is up and running?
> >
> >Ron
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Smith, Ron L.
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >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 your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
>--
>Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Jon Walthour]

Sajid:

Try this piece. I use a version of it for my uptime.sql script:

TO_CHAR(TRUNC(date1 - date2)) || ' day(s), ' || TO_CHAR(TRUNC(MOD(date1
- date2 - 1, 1) * 24)) || ' hour(s), ' || TO_CHAR(TRUNC(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60)) || ' minute(s) and ' || TO_CHAR(ROUND(MOD(((MOD(date1
- date2 - 1, 1) * 24) - (TRUNC(MOD(date1 - date2 - 1, 1) * 24)))
* 60, 1) * 60, 1)) || ' seconds.'

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: Sajid Iqbal <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/10/01 9:26:09 AM
>

>Hello All
>
>I want to display the "time elapsed" between two dates - in
days, hours,
>minutes and seconds.
>
>If I do "select date1 - date2", the result is : 12.0194907
>
>Is there a function that will turn the number of days into something
more
>legible?  Ideally i'd like to do ;
>
>"to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't
work.  Is
>there a solution other than writing a complex function myself
which will
>have to * by 24, / by 60 and substr etc to get the different
bits of the
>number?
>
>Please CC any replies directly to me at [EMAIL PROTECTED]
>
>Thanks in advance,
>Saj.
>
>
>
>-- 
>Sajid Iqbal
>Database Team Leader
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Sajid Iqbal
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>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.com
-- 
Author: Jon Walthour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

UNIX

[Richard Huntley]

Does anyone know of a command or file that would display the available disks
on a Solaris 2.6 box and/or the corresponding disks for each mount point???

TIA,
Richard Huntley

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Client Connection-SQLNET ?/? ODBC.

[Miller, Jay]

Hello James,

Every ODBC connection I've seen or used has connected through SQL Net
(i.e,., app->odbc->sqlnet->database).  But ODBC isn't really my area of
expertise...

Jay Miller

-Original Message-
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Witold . Iwaniec]

Hi

The script below may help you - it will display different components in separate
columns, modify it with your two dates and proper table name and remove what you
don't need

select sysdate,
   sysdate - to_date('0307200100', 'DDMMHH24MISS') diffr,
trunc(sysdate - to_date('0307200100', 'DDMMHH24MISS')) days,
trunc(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'), 1) *
24) hrs,
trunc(mod(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'),
1) * 24, 1) * 60) min,
round(mod(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60, 1) * 60) sec,
to_char(trunc(sysdate - to_date('0307200100', 'DDMMHH24MISS')))
|| ' ' ||
lpad(trunc(mod(sysdate - to_date('0307200100', 'DDMMHH24MISS'),
1) * 24), 2, '0') || ':' ||
lpad(trunc(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60), 2, '0') || ':' ||
lpad(round(mod(mod(mod(sysdate - to_date('0307200100',
'DDMMHH24MISS'), 1) * 24, 1) * 60, 1) * 60), 2, '0') Difference
 from dual

HTH

Witold



Sajid Iqbal wrote:

> Hello All
>
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
>
> If I do "select date1 - date2", the result is : 12.0194907
>
> Is there a function that will turn the number of days into something more
> legible?  Ideally i'd like to do ;
>
> "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work.  Is
> there a solution other than writing a complex function myself which will
> have to * by 24, / by 60 and substr etc to get the different bits of the
> number?
>
> Please CC any replies directly to me at [EMAIL PROTECTED]
>
> Thanks in advance,
> Saj.
>
> --
> Sajid Iqbal
> Database Team Leader
>
> --






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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: help how get the n top rows for any table?

[Stas]

If you're running  Oracle8i,
you can do this: 
SELECT *
FROM  (SELECT * FROM my_table ORDER BY col_name_1
DESC)
WHERE  ROWNUM < 10;

Use this workaround with prior releases: 
SELECT *
FROM my_table a
WHERE 10 >= (SELECT COUNT(DISTINCT maxcol)
  FROM my_table b
  WHERE b.maxcol >= a.maxcol)
 ORDER BY maxcol DESC
;

Hope this helps!







--- Alexander Ordonez <[EMAIL PROTECTED]> wrote:
> Hi, gurus!!!
> 
> A need know how get n top row for any table somebody
> can help me!!
> 
> Thanks!!!
> 
> @lex
>

>   Lic. Alexander Ordóñez Arroyo 
>   Caja Costarricense del Seguro Social  
>   
>   Soporte Técnico - División de Informática 
>
>   Telefono: 295-2004, San José, Costa Rica  
>  
>   [EMAIL PROTECTED]
> 
>

> UNIX is very user friendly, 
> It's just very particular about who it makes friends
> with.
> 
> 
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Alexander Ordonez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stas
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Mercadante, Thomas F]

In 816 on NT, you can rename it any time you want.

is this changing in 817 Rachel?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, July 10, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the 
original)



>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rename alert log
>Date: Tue, 10 Jul 2001 06:56:31 -0800
>
>Can the alert log be renamed while the database is up and running?
>
>Ron
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OEM 2.2 client for Sun

[Wolfe, Charles]

Look in your $ORACLE_HOME/bin 
directory.  There should be an "oemapp" executable.  The OEM console 
is started by:  "oemapp console". 
 
hth

  -Original Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 11:41 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OEM 2.2 client for Sun
  i dont know the answer to that one for sure, but its available for 
  linux(java based) so i'd think it should be available.
   
  joe
  >>> [EMAIL PROTECTED] 07/10/01 09:45AM 
  >>>
  Hi gurus, 
  We work with OEM 2.1 client on PC and Sun 
  stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). 
  I can't find OEM 2.2 client for Sun on 
  the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me 
  or does Oracle not release a client version for Sun? 
  TIA 
  - Luc Demanche CETELEM 
  Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88 

RE: Rename alert log

[Jon Walthour]

Ron:

If you mean, "Can the alert log be renamed for archiving purposes
while the db is up?" the answer is yes. Oracle will just recreate
the alert log the next time it needs to write an entry to it.

--

Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio

>--- Original Message ---
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 7/10/01 10:56:31 AM
>

>Can the alert log be renamed while the database is up and running?
>
>Ron
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Smith, Ron L.
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing
Lists
>
>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.com
-- 
Author: Jon Walthour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Tommy Wareing]

On Tue, Jul 10, 2001 at 05:26:09AM -0800, Sajid Iqbal wrote:

> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
> 
> If I do "select date1 - date2", the result is : 12.0194907
> 
> Is there a function that will turn the number of days into something more
> legible?  Ideally i'd like to do ;
> 
> "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work.  Is
> there a solution other than writing a complex function myself which will
> have to * by 24, / by 60 and substr etc to get the different bits of the
> number?

using a as your value (cos it's shorter to write)

trunc(a)||':'||to_char(trunc(sysdate)+a-trunc(a), 'HH24:MI:SS')

You could get away with using
to_char(a+to_date('31-Dec-00'), 'DD:HH24:MI:SS')
if you can ensure that 1 <= a < 32

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: gzip does not want to work with files > 2G

[Richard Ji]

I also uses gzip 1.3 on Solaris 8 (1999-12-21 build).  The one that comes with Solaris 
8 was 1.2.24 or something
which doesn't support file >2G.  Did you get rid of the old gzip 1.2.24?  Make sure 
it's using the new one that you installed not the old version.

>>> [EMAIL PROTECTED] 07/10/01 10:05AM >>>
I use version 1.3 for Solaris 5.8 - it is the same version that is on
www.sunfreeware.com What version do you use and for which version on
Solaris?


Alex Hillman

-Original Message-
Sent: Monday, July 09, 2001 10:46 PM
To: Multiple recipients of list ORACLE-L


What version of gzip are you using?  I had the same problem before, just had
to get the latest version.

Richard Ji

>>> [EMAIL PROTECTED] 07/09/01 07:12PM >>>
I have Solaris 5.8 angzip does not want to work with files > 2G - tells that
file is too large. Anybody has any idea why?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com 
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com 
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Kevin Lange]

Yes.  Rename delete trimmedetc.

-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 81714 aborted upgrade and core dumps on NT

[Unal Bilisim]

Hello,

you can email me with zipped core file.



10/7/01 07:51:51, "Jeffrey Beckstrom" <[EMAIL PROTECTED]> wrote:

>
>
>
>We have been running 8.1.7 for a couple weeks.  The clients are 8.1.6
>still
>>>> [EMAIL PROTECTED] 7/10/01 11:55:59 AM >>>
>Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have
>some
>notablyunexplained errors connecting older versions to 8.1.7 - most
>with large objects.
>
>-Original Message-
>[mailto:[EMAIL PROTECTED]]
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>I have just had the experience of upgrading to 81714, discovering a
>in our application that did not show up in any testing and having to go
>back
>to 815.
>
>have the 817 instance available for further troubleshooting.e and we still
>
>This is on NT4.
>
>With 817, we were getting ora-3113 in the forms application and in ODBC
>connections and also seeing ora-03121 as well.
>We got core dump files produced (under 817 they are produced on NT) but
>Oracle support does not seem to know how to interpret them on NT - has
>anyone had any experience with this?
>
>files were produced in the user dump directory.within the alert log and no
>
>When I turned sql trace on for the session running forms, the ora-3113 did
>not occur - has anyone seen behaviour like this where SQL Trace will cause
>an ora-3113 to stop occurring?
>All suggestions on what to look for or how to interpret NT core dumps are
>welcome.
>
>Thanks,
>[EMAIL PROTECTED]
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>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
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>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
>also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[lhoska]

Yes, it can.  Just rename it and there will be new one created with an old
name at some point.

-Original Message-
Sent: Tuesday, July 10, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[dgoulet]

Walt,

Thanks man, my 401K can use the boost!!

Dick Goulet

Reply Separator
Author: "Weaver; Walt" <[EMAIL PROTECTED]>
Date:   7/10/2001 8:02 AM

Well, if you're lucky enough to use the Enterprise Edition you'll be saving
money. We use the Standard Edition, and at this time it looks like it's
going to cost us quite a bit more, actually, for a per-processor license. 

So, we're currently in delicate negotiations with our Oracle rep and various
resellers to see what kind of deal we can get. Fortunately we can still buy
licenses through the old "power unit" scheme through the end of July. Since
we're opening up a new hosting data center in New Jersey next month we're
gonna scarf up as many licenses as we can afford.

So, Larry, I got something you can smell right here.:>)

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 10, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L

Steve,

I have heard nothing to suggest that Oracle is abandoning the standard
vs.
enterprise edition packaging.  What I have heard and read at Oracle.com is
that
they are abandoning the Universal Power Unit in favor of Per Processor
pricing. 
Namely there is today two license models that they offer and support, named
user and per processor.  

Thanks Larry!!  Knew you'd smell the roses/coffee sooner or later.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

OT - get together for list participants in DC area

[Mohan, Ross]

It's possible, sure..good idea.

It may just wind up being you and I
Alex, in which case I can buy your beersif you don't mind the speedo. 

:)

-Original Message-
Sent: Monday, July 09, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L


There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston Oracle
building. Details on www.maop.org  I am doing presentation about LMT,
temporary tablespaces and Global Temporary tables( very rude sel promo :-)).
I think it can be good opportunity to meet. After that we can go to get
couple of beers etc. I do not know that area very well, so any suggestions
welcome.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[Tom Schruefer]

This is the list for 8i:

http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server
.817/a76962/ch4.htm

http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm   

http://technet.oracle.com/doc/server.815/a68020/ch4.htm  


Although they are two different URL's the 8.1.6 and 8.1.7 pages look the 
same.  I haven't found anything for 9i yet.


>Rachel Carmichael - [EMAIL PROTECTED] on 7/10/2001 12:25 PM writes us:

>
>haven't found it in the concepts manual... can't remember where it was in 
>the 8i docs
>
>
>>From: "Orr, Steve" <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>Subject: RE: O9i Licensing
>>Date: Tue, 10 Jul 2001 06:05:25 -0800
>>
>>Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
>>Edition features?
>>
>>Steve
>>
>>
>>-Original Message-
>>Sent: Monday, July 09, 2001 7:21 PM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>According to the 9i concepts manual, there is a standard and enterprise
>>edition.
>>
>>
>> >From: "Orr, Steve" <[EMAIL PROTECTED]>
>> >Reply-To: [EMAIL PROTECTED]
>> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>> >Subject: O9i Licensing
>> >Date: Mon, 09 Jul 2001 15:36:30 -0800
>> >
>> >Anyone familiar with Oracle9i Licensing... is there still a standard
>> >edition
>> >versus an enterprise edition? At OpenWorld LEllison said there would only
>> >be
>> >two types of licenses for Oracle... the database server and the 
>>application
>> >server. If that's the case is there nolonger a standard vs enterprise
>> >license?
>> >
>> >On a related note, our sales rep said that 80% of Oracle's customer base 
>>is
>> >on standard edition and only 20% is on enterprise edition. A lot less
>> >enterprise licenses than I would have thought. I believe the recent
>> >"decrease" in license fees is only true for enterprise edition but 
>>actually
>> >could amount to a price increase for standard edition if you were using
>> >power units.
>> >
>> >Feeling like a second class citizen... stuck with standard edition and in
>> >need of transportable tablespaces, bitmapped indexes, function-based
>> >indexes, and PQO...
>> >Steve Orr
>> >
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> >--
>> >Author: Orr, Steve
>> >   INET: [EMAIL PROTECTED]
>> >
>> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>> >San Diego, California-- Public Internet access / Mailing Lists
>> >
>> >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 your FREE download of MSN Explorer at http://explorer.msn.com
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Rachel Carmichael
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>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.com
>>--
>>Author: Orr, Steve
>>   INET: [EMAIL PROTECTED]
>>
>>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>>San Diego, California-- Public Internet access / Mailing Lists
>>
>>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 your FREE download of MSN Explorer at http://explorer.msn.com
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Rachel Carmichael
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMA

Question about OFA and RAID 5

[Tom Schruefer]

Any suggestions on the message below would be greatly appreciated.  
Thanks in advance.

I have been appointed our new Oracle DBA and have since been taking 
classes and reading books.  I quite enjoyed the recent thread on OFA.  I 
seem to have a bit of a quandary, here it is.


We have 68 schools with 46,000 students, each with their own student 
database, we have purchased a product that will allow us to aggregate all 
of these databases into one central database.  This project is but one 
step toward a centralized student data system, which we currently do not 
have the infrastructure for.

Here is the suggested configuration for the database server for this 
product.

2 9GB HD in a RAID 1 - Suggested for the OS and LOGS
6 18GB HD in RAID 5  - Database
1 18GB HD Hot Spare

I realize that something of this nature would allow for a lot of disk 
through-put (I would think), but it doesn't really allow for a OFA 
configuration.


I should clarify at this time that there were two choices for the DB 
either Oracle or SQL Server, we chose Oracle.  I have a suspicion that 
this configuration is either intended to maximize database access, at the 
expense of recoverability or its the SQL Server version of OFA, or both.  
If it is both is there a way to provide for OFA and also maximize disk 
access?

BTW, I actually purchased a system with much more disk space than the 
above, 14 18gb HD and 2 9gb HD.



--
Howard County Public School System, Maryland, USA
[EMAIL PROTECTED]

The views expressed in this message do not represent the views of the 
Howard County Public School System, blaa, blaa, blaa.  You get the idea.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

help how get the n top rows for any table?

[Alexander Ordonez]

Hi, gurus!!!

A need know how get n top row for any table somebody can help me!!

Thanks!!!

@lex

  Lic. Alexander Ordóñez Arroyo 
  Caja Costarricense del Seguro Social 
  Soporte Técnico - División de Informática 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]


UNIX is very user friendly, 
It's just very particular about who it makes friends with.



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Farnsworth, Dave]

Yes

-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Performance/Optimization/Monitoring Tools

[Mark Leith]

Other than those from the companies you have mentioned (and personally - as
already mentioned - I would stay away from CA) here are a few others to bear
in mind:


NORAD Surveillance Module - www.bradmark.com (also www.cool-tools.co.uk)
(Sits in between Spotlight & Foglight from Quest, except cheaper, well
established, and highly configurable)


Performance Centre - www.embarcadero.com
(Only version 1.something at the moment, but a solid start for a monitoring
tool)

Mamba - www.luminate.com
(it's free but a cool tool all the same)

Precise SQL - www.precise.com ?
(Very low impact on the actual server, meaning you can have very low
monitoring periods (2 seconds even) as they have mapped the system memory,
and do not need to connect to the database to monitor it)

Experience from market:

CA
(Don't even go there, support is bad, the products may be good, but not
really going anywhere in a hurry)

Quest
(Good solid tools, constantly moving forward in development, support a
little flaky at times and pretty expensive, but widely used)

BMC
(Plenty of $$, hard to configure for monitoring (have even heard you need
consultants to do this) but again good tools if you can afford them)

This is really a quick overview..

HTH

Mark

Disclaimer: These are my own personal views, from my experience in the DBA
tool market place, and in no way reflects the views of my employer
Cool-Tools


-Original Message-
Michael (TEM)
Sent: Monday, July 09, 2001 06:06
To: Multiple recipients of list ORACLE-L


DBA's:

We're looking at tools for monitoring and tuning our databases.  Our
primary applications are data warehouse, data marts, document control,
help desk, and laboratory management.  (We also have SAP but they have
their own tool set).

Anybody have any experience/recommendations/stay-away-froms for stuff from
vendors like BMC, Quest, CA, etc.?

Thanks,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Rename alert log

[Rachel Carmichael]

depends on the version of the database you are running.. it used to be that 
yes, you could just rename it and Oracle would open a new one of the 
original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an 
open file pointer to it, similar to the way it handles the listener log 
file. So you will need to do the same sort of tricks to the alert log as you 
have to do to the listener log (make a copy then copy /dev/null to the 
original)



>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Rename alert log
>Date: Tue, 10 Jul 2001 06:56:31 -0800
>
>Can the alert log be renamed while the database is up and running?
>
>Ron
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Performance/Optimization/Monitoring Tools

[Kimberly Smith]

I would say now that CA owns ERwin it pretty much is terminal, regardless of

whether or not its the last release they send out.

-Original Message-
Sent: Monday, July 09, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L


[EMAIL PROTECTED] wrote:

> For those of you who maybe interested:
>
> Kumar: CA to organize products into four brands
>
> At CA World, Computer Associates President and CEO Sanjay Kumar outlined
the
> software vendor's plan to refocus on six core segments divided into four
branded
> product lines.
>
> http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62061_NLTam%2C00.html
> --

so - does this mean 4.0 is a terminal release for ERWin?

I couldn't read that far between the lines.

Paul


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 81714 aborted upgrade and core dumps on NT

[Jeffrey Beckstrom]

We have 
been running 8.1.7 for a couple weeks.  The clients are 8.1.6 
still>>> [EMAIL PROTECTED] 7/10/01 11:55:59 AM 
>>>Are you running the 8.1.7 sqlnet clients and odbc drivers. We 
did have someas yet unexplained errors connecting older versions to 8.1.7 - 
most notablywith large objects.-Original Message-[mailto:[EMAIL PROTECTED]]Sent: 
Tuesday, July 10, 2001 3:05 AMTo: Multiple recipients of list 
ORACLE-LHi,I have just had the experience of upgrading to 81714, 
discovering a problemin our application that did not show up in any testing 
and having to go backto 815.The 815 instance is on a different 
server to the 817 instance and we stillhave the 817 instance available for 
further troubleshooting.This is on NT4.With 817, we were getting 
ora-3113 in the forms application and in ODBCconnections and also seeing 
ora-03121 as well.We got core dump files produced (under 817 they are 
produced on NT) butOracle support does not seem to know how to interpret 
them on NT - hasanyone had any experience with this?No mention of 
the core dump file was contained within the alert log and nofiles were 
produced in the user dump directory.When I turned sql trace on for the 
session running forms, the ora-3113 didnot occur - has anyone seen behaviour 
like this where SQL Trace will causean ora-3113 to stop 
occurring?All suggestions on what to look for or how to interpret NT 
core dumps arewelcome.Thanks,Bruce 
Reardon[EMAIL PROTECTED]-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
Reardon, Bruce (CALBBAY)  INET: 
[EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Shaw, John B  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Client Connection-SQLNET ?/? ODBC.

[Robin Ilardi]

Yes, you do need to have Net8 installed in order for Cold Fusion to connect
to the database through ODBC.  It uses ODBC through SqlNet.  First set up
the Sqlnet connection to the database, then set up the ODBC connection using
the service name you used for the Sqlnet connection.

hth,
Robin


-Original Message-
Damiano
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Robin Ilardi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[Christopher Spence]

Yeah, I noticed that about the pricing too, for the E10k it is still 2.6
Million, same exact price as before.

-Original Message-
Sent: Tuesday, July 10, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


Both are still there, and despite the hype it actually looks like a price
increase unless your cpu's are over 1Gz.

-Original Message-
Sent: Monday, July 09, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L


Anyone familiar with Oracle9i Licensing... is there still a standard edition
versus an enterprise edition? At OpenWorld LEllison said there would only be
two types of licenses for Oracle... the database server and the application
server. If that's the case is there nolonger a standard vs enterprise
license?

On a related note, our sales rep said that 80% of Oracle's customer base is
on standard edition and only 20% is on enterprise edition. A lot less
enterprise licenses than I would have thought. I believe the recent
"decrease" in license fees is only true for enterprise edition but actually
could amount to a price increase for standard edition if you were using
power units. 

Feeling like a second class citizen... stuck with standard edition and in
need of transportable tablespaces, bitmapped indexes, function-based
indexes, and PQO... Steve Orr

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Shaw, John B
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

need to recreate database

[lhoska]

Hello,
I need to recreate a database, basically make a complete copy of one of the
existing databases on a new server.  My networking people already copied all
datafiles, control file, log files, init file, etc to the target server.
They also reproduced operating system directory structure.
What I need to do is to make the second part of the task work, create the
database, services, etc and make it run.
I have not done it before and if I was doing it I would probably do
export/import type of thing but the higher ups would like to have it done
this way.
One of the people has an idea suggesting just recreating the registry
setting by exporting it from the existing machine to the new one.
The other option is to reinstall Oracle but I am not sure how to make it to
accept existing physical components(datafiles, control file, etc).
If someone has a suggestion I would greatly appreciate it.
Thank you in advance.

Lyuda Hoska

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

OT : Oracle datawarehouse DBA available in Canada

[paquette stephane]

Hi,

Sorry for the out of topic post.

I'm going back to Canada.   
I'll be looking for a position as an Oracle devlopment
dba in the datawarehousing field for the Montreal
area. 

I do not know if they are recruiters looking for
candidates in the Montreal area but if so you can
contact me at [EMAIL PROTECTED]



=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Client Connection-SQLNET ?/? ODBC.

[Shaw, John B]

Yes you need SQLNET. odbc uses sqlnet on the client.

-Original Message-
Sent: Tuesday, July 10, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Shaw, John B
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sizing a new server

[Kimberly Smith]

Title: RE: Sizing a new server



Actually, it really depends on the industry at the moment as to whether 
or not money is no object.  Currently money is a huge issue.  The 
semi-conductor fabs are not doing so hot right now (at least not the memory 
producing ones).  Fabs are all pretty much in a slow down.  


  -Original Message-From: Robertson Lee - lerobe 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 12:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Sizing a new server
  By 
  the sounds of it, Kimberley was in a very similar situation to me when I was 
  working for a semi-conductor manufacturing company afew years ago (the worst 
  job I ever had).Basically money was no object and anything was feasible as 
  long as the fab kept running 24x7.
   
  
  
-Original Message-From: Koivu, Lisa 
[mailto:[EMAIL PROTECTED]]Sent: 09 July 2001 
19:36To: Multiple recipients of list ORACLE-LSubject: 
RE: Sizing a new server
Thanks Kimberly, 
I wish it was that way.  I 
have to justify my request with hard numbers or they are going to laugh at 
me when I say, "Because that's what I want".  :)  They don't yet 
know how I'd react to that, it would be a knee-jerk type of reaction 
involving creative expletives...  not pretty.  
Good for you.  At least you 
have some real hardware and true HA.  I wish I did 
Lisa 

  -Original Message- From:   Kimberly Smith [SMTP:[EMAIL PROTECTED]] 
  Sent:   Monday, July 09, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Sizing a new server 
  Get the biggest, kick ass server 
  they will let you buy.  If your site is anything like mine they just 
  keep asking for more and more databases.  So no matter what I have 
  now I know its not enough.  I am really happy with the nice new 
  N-class HP cluster I have sitting next door running Service Guard.  I 
  am also getting a A-class database cluster for some important but not fab 
  critical databases.  Now if I can only get ride of the 5 K-class 
  database servers.  Its kind of like when you go from a fast to a slow 
  PC.  Drives me crazy.  Not that there are issues with 
  performance from the databases.  It would only be me, while 
  playing (which of course means working) on the server, that would 
  notice.
  
-Original 
Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, 
July 09, 2001 8:30 AMTo: Multiple recipients of 
list ORACLE-LSubject: Sizing a new 
server
Good morning everyone, 
Lucky me, I get to choose the size 
of the server this company should consider purchasing.  I have been 
poking around on the net for any guidelines - I can make guesses based 
upon my gut feel and how strapped the current unix server is, but I want 
to be able to back this up with hard numbers.  This is for a dw 
application.
Can anyone point me to a website, 
book, or anything in particular that can help me justify sizing a 
machine?  It's so fun working for a company that doesn't have a 
sysadmin on staff...  
Thanks 

Lisa KoivuOracle Data Bored 
AdministratorFt. Lauderdale, FL, USA954-935-4117 
The information in the electronic mail 
message is Cendant confidential and may be legally privileged, it is 
intended solely for the addressee(s) access to this internet electronic 
mail message by anyone else is unauthorized. If you are not the intended 
recipient, any disclosure, copying, distribution or any action taken or 
omitted to be taken in reliance on it is prohibited and may be 
unlawful.
The sender believes that this E-mail and any 
attachments were free of any virus, worm, Trojan horse, and/or malicious 
code when sent. This message and its attachments could have been 
infected during transmission. By reading the message and opening any 
attachments, the recipient accepts full responsibility for taking 
protective and remedial action about viruses and other defects. Cendant 
Corporation or Affiliates are not liable for any loss or damage arising 
in any way from this message or its attachments. 
  The information 
  contained in this communication isconfidential, is intended only for the 
  use of the recipientnamed above, and may be legally privileged. If the 
  reader of this message is not the intended recipient, you arehereby 
  notified that any dissemination, distribution orcopying of this 
  communication is strictly prohibited. If you have received this 
  communication in error, please re-send this communication to the sender 
  and delete the original message or any copy of it from your 
  computersystem.

Re:Client Connection-SQLNET ?/? ODBC.

[dgoulet]

James,

First off, Linux does not use DLL's, that's a MicroSlop thing.  It does make
use of .so files for Shared Object, which is a Unix thing.

Now as to the subject of ODBC: ODBC stands for Open Data Base Connectivity
which again was a MicroSlop idea that has caught one.  OK, I'll give Gates & CO
a pat on the back for a good idea that went bad elswhere.  Anyway, the idea is
that your application has a common interface, namely ODBC, that then connects to
each database vendor's proprietary transport.  This way the interface to the
database from your perspective (as the developer) is the same no matter who's
database is underneath.  In theory it is a great idea, but the implementation
results in a pile of ODBC driver HELL.  BUT to answer your question, if your
going to use ODBC to get to Oracle, you'll have to have the SQL*Net client stuff
on that machine as well.

Dick Goulet

Reply Separator
Author: "James Damiano" <[EMAIL PROTECTED]>
Date:   7/10/2001 7:15 AM

Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Jamadagni, Rajendra]

SELECT  12.0194907 
   ,FLOOR((12.0194907*86400)/86400) || ':' || 
 
TO_CHAR(TO_DATE(ROUND(SUBSTR(12.0194907,INSTR(12.0194907,'.'))*86400),'s
'),'HH24:MI:SS')
FROM dual

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Alert log scan script

[Mark Leith]

Ron,

I've attached one that I also got from the list some time ago, you may need
to use something like bablefish to translate the comments :)

HTH

Mark

-Original Message-
L.
Sent: Tuesday, July 10, 2001 02:32
To: Multiple recipients of list ORACLE-L


Last week I was bit by a corrupt block on an index.  I run Analyze every
week which I found has been blowing up for some time due to the block
corruption.  Since Analyze does not create a log I did not know the Analyze
was blowing up.  Now I know that there are messages in the alert log that
would have told me I had problems with the Analyze and the index.

To make a long story short I need a good log scan script.  Hopefully one
that will work on Unix and NT.  Mainly Unix.  If anyone can help I would
appreciate it.

Thanks!
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

 alerts.sql

Re: OEM 2.2 client for Sun

[JOE TESTA]

i dont know the answer to that one for sure, but its available for 
linux(java based) so i'd think it should be available.
 
joe
>>> [EMAIL PROTECTED] 07/10/01 09:45AM 
>>>
Hi gurus, 
We work with OEM 2.1 client on PC and Sun 
stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations). 
I can't find OEM 2.2 client for Sun on 
the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me or 
does Oracle not release a client version for Sun? 
TIA 
- Luc Demanche CETELEM 
Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88 

RE: Rename alert log

[Vergara, Michael (TEM)]

Ron:

Yep.  Do it every night at midnight.  But...you can't just rename it!
If you do a command like...

mv alert_SID.log alert_SID_010710.log
touch alert_SID.log

...Oracle will still append new entries to the old file, and your new
alert_SID.log file will continue to have 0 bytes.  What you need to 
do is...

cp -p alert_SID.log alert_SID_010710.log
> alert_SID.log

...This copies the file while maintaining the timestamp, and then nulls 
out the existing file.  This should work on most flavors of UNIX.

HTH,
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Tuesday, July 10, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L


Can the alert log be renamed while the database is up and running?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

old stats and temp space

[Steve Sapovits]

Is there any correlation between out of date analyze stats
and temp space usage?  i.e., could old stats cause overly
large temp space usage?


Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell:   610-574-7706
Pager:  877-239-4003

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 12514 Error

[Greg Solomon]

Hi

Definitely check whether you can ping the server from the client.
If not, then it's a network config problem.

After that, I once had this problem when a highly creative user (actually,
our CTO) had entered a setting for Oracle Names when we were using local
names only.  I had to delete the setting.

If that doesn't help, suggest that you turn on the trace files for 
a) the client you're trying to set up, and
b) another client which is known to work OK.

Comparing the trace files should give you a few clues.

HTH

Cheers
Greg

-Original Message-
Sent: Tuesday, 10 July 2001 16:56
To: Multiple recipients of list ORACLE-L


Hi,
I had installed oracle 8.1.7 on WINNT and installed
oracle client with administrator utility on win2k
system. When i want to connect to this client on win2k
to server on winnt. But i am getting the error
ORA:12514.
Can any one slove this for me.
The listener.ora and tnsnames.ora files seems to be
ok.

Thanks in advance
Bhanu

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorthy BhanuPrakash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Greg Solomon
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Alert log scan script

[Ruth Gramolini]

Try AlertView from zephyrus.com.  It is a free tool for analyzing your alert
logs.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 9:31 AM


> Last week I was bit by a corrupt block on an index.  I run Analyze every
> week which I found has been blowing up for some time due to the block
> corruption.  Since Analyze does not create a log I did not know the
Analyze
> was blowing up.  Now I know that there are messages in the alert log that
> would have told me I had problems with the Analyze and the index.
>
> To make a long story short I need a good log scan script.  Hopefully one
> that will work on Unix and NT.  Mainly Unix.  If anyone can help I would
> appreciate it.
>
> Thanks!
> Ron
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:12514 Error

[Gorthy BhanuPrakash]

Hi,
I had installed oracle 8.1.7 on WINNT and installed
oracle client with administrator utility on win2k
system. When i want to connect to this client on win2k
to server on winnt. But i am getting the error
ORA:12514.
Can any one slove this for me.
The listener.ora and tnsnames.ora files seems to be
ok.

Thanks in advance
Bhanu

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorthy BhanuPrakash
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

[Smith, Ron L.]

Can the alert log be renamed while the database is up and running?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: db-links question

[A. Bardeen]

Alex,

Yes, the connection remains open unless it is
explicitly closed (see Note: 1034343.6).

The session also takes out a lock on the local RBS
(see Note:74811.1) as this could be part of a
distributed transaction.  If this is a long running
query this can lead to abnormal growth in the RBS
since the active transaction in the RBS will prevent
the RBS from wrapping into that extent.  You can avoid
this by issuing SET TRANSACTION READ ONLY; prior to
running the distributed query.

AFAIK, you can use MTS connections, although I would
recommend using dedicated connections for any links
used for replication (push and refresh operations).

HTH,

-- Anita


--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> So you mean that connection to the remote DB stays
> open until session ends
> which issued query on remote DB. Are these
> connection dedicated? I think yes
> bur did not check. Is it possible to use MTS for
> such connection? And all
> new features like connection pooling etc.
> 
> Alex Hillman
> 
> -Original Message-
> Sent: Monday, July 09, 2001 6:55 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Yes, it creates a session. If you want to do a(n)
> SQL trace, you can do a
> SELECT 'x' FROM dual@remote_site, find the session
> at the remote site and
> turn on the trace, then run your next query. 
> 
> Henry
> 
> -Original Message-
> Sent: Monday, July 09, 2001 5:06 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> If I query table in the remote database using
> database link does user in the
> remote database which is referenced in the database
> link  create session in
> the remote database and if not could somebody
> explain how remote query is
> executed.
> 
> Alex Hillman
> 
> P.S. I know that I could try it myself but I am
> layzy (sp?) and tired
> (fighting with Ross for access to printing presses
> :-) )
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> -- 
> Author: Henry Poras
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> -- 
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: any dangers of using UTL_SMTP

[Naik, Sandesh S]

Thank you very much everybody for your expert comments. That really helped
me to put my case with manager who has concerns about using UTL_SMTP with
loading java in database.

Thanks again

Sandesh

-Original Message-
Sent: Friday, July 06, 2001 4:38 PM
To: Multiple recipients of list ORACLE-L


Sandesh:

We're running the same environment as you, except that we're using HP/UX
11.0 64-bit.  I just ran the install scripts and everything's been working
fine.  This machine is (don't yell!) half-Test and half-Production, and
the 8.1.6 database is the production half.  It just worked.

Good Luck!
Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |


-Original Message-
Sent: Friday, July 06, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L


Dear Friends,
 I have a Oracle 8.1.6.2.0 database on HP-UX 11.0 of about 25M Shared pool
about 10,000 db_block_buffers.
 One of our development team wants to use UTL_SMTP. I know I have install
Jserver and run initjvm.sql to install all the classes.
 I want to know any dangers or problems people have faced using this and
what are the precautions they have taken. Steps to set up Jserver to
UTL_SMTP to work smoothly are appreciated.
 All replies are welcome.

Thanks
Sandesh Naik
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Naik, Sandesh S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[Rachel Carmichael]

haven't found it in the concepts manual... can't remember where it was in 
the 8i docs


>From: "Orr, Steve" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: O9i Licensing
>Date: Tue, 10 Jul 2001 06:05:25 -0800
>
>Thanks Rachel. Is there any breakdown as to Enterprise Edition vs Standard
>Edition features?
>
>Steve
>
>
>-Original Message-
>Sent: Monday, July 09, 2001 7:21 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>According to the 9i concepts manual, there is a standard and enterprise
>edition.
>
>
> >From: "Orr, Steve" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: O9i Licensing
> >Date: Mon, 09 Jul 2001 15:36:30 -0800
> >
> >Anyone familiar with Oracle9i Licensing... is there still a standard
> >edition
> >versus an enterprise edition? At OpenWorld LEllison said there would only
> >be
> >two types of licenses for Oracle... the database server and the 
>application
> >server. If that's the case is there nolonger a standard vs enterprise
> >license?
> >
> >On a related note, our sales rep said that 80% of Oracle's customer base 
>is
> >on standard edition and only 20% is on enterprise edition. A lot less
> >enterprise licenses than I would have thought. I believe the recent
> >"decrease" in license fees is only true for enterprise edition but 
>actually
> >could amount to a price increase for standard edition if you were using
> >power units.
> >
> >Feeling like a second class citizen... stuck with standard edition and in
> >need of transportable tablespaces, bitmapped indexes, function-based
> >indexes, and PQO...
> >Steve Orr
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Orr, Steve
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >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 your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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.com
>--
>Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>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 your FREE download of MSN Explorer at http://explorer.msn.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Alert log scan script

[JDonson]

I believe that a dedicated window running

tail -f 10 /alert_log_filename

  will keep an eye on the last 10 lines of the
  alert log in Unix/Linux.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Stephane Faroult]

Sajid Iqbal wrote:
> 
> Hello All
> 
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
> 
> If I do "select date1 - date2", the result is : 12.0194907
> 
> Is there a function that will turn the number of days into something more
> legible?  Ideally i'd like to do ;
> 
> "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work.  Is
> there a solution other than writing a complex function myself which will
> have to * by 24, / by 60 and substr etc to get the different bits of the
> number?
> 
> Please CC any replies directly to me at [EMAIL PROTECTED]
> 
> Thanks in advance,
> Saj.
> 
> --
> Sajid Iqbal
> Database Team Leader

Sajid,

   The difference of two dates is a number of days. If you want to use a
function similar to the dates function, you have to treat the day and
fractional parts separately, eg

 select trunc(date2 - date1) days,
to_char(trunc(sysdate) + (date2 - date1) - trunc(date2 - date1),
 'HH24:MI')

 This uses a trick, the fact that date + number is a date ('number' is
assumed to be a number of days) - so we can use 0:00 today as 'base' and
just display hours and minutes (and seconds if you need them).
--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sizing a new server

[Guy Hammond]

Title: RE: Sizing a new server



Hi 
Lisa,
 
That 
doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs 
and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase 
power supply and weighs, literally, half a tonne. And best of all, you can run 
VMS on them!
 
g
 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 10, 2001 2:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Sizing a new server
  Bruce, 
  It's going to be Unix, tru64.  
  Unfortunately I will be stuck with some old hardware to start with - an Alpha, 
  8400, I believe maxes out at 8 cpu's, along with two old disk farms (compaq 
  esa10k).  I'm slapping together a bunch of old pieces of hardware, 
  upgrading where needed, obtaining software licensing where needed, compaq 
  hardware/software support, and with some duct tape, political brown-nosing 
  done by others and a few users screaming for their data, I'll hopefully end up 
  with some sort of reporting tool hitting this.  (BizObj or Cogno$).  
  Man Cognos is expensive. 
  I wish I could choose AIX here.  
  It's not an option.  
  See doesn't this sound like a 
  director's job?? Say it 
  again:  I LOVE MY JOB 
  Lisa 
  
-Original Message- From:   Reardon, Bruce (CALBBAY) 
[SMTP:[EMAIL PROTECTED]] Sent:   Monday, July 09, 
2001 8:50 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Sizing a new server 
Lisa, 
Some may laugh at the question but what OS - NT, 
Unix, VMS or ? 
Regards, Bruce 
Reardon -Original Message- 
Sent: Tuesday, 10 July 2001 4:36 
To: Multiple recipients of list 
ORACLE-L 
Thanks Kimberly, I wish it was that way.  I have to justify my request with hard 
numbers or they are going to laugh at me 
when I say, "Because that's what I want".  :) They don't yet know how I'd react to that, it would be a 
knee-jerk type of reaction involving 
creative expletives...  not pretty.  Good for you.  At least you have some real hardware and true 
HA.  I wish I did Lisa 
-Original Message- Sent:   Monday, July 09, 2001 12:51 PM 
To: Multiple 
recipients of list ORACLE-L Get the 
biggest, kick ass server they will let you buy.  If your site is 
anything like mine they just keep asking for 
more and more databases.  So no matter what I have now I know its not enough.  I am really happy 
with the nice new N-class HP cluster I 
have sitting next door running Service Guard. I am also getting a A-class database cluster for some important but 
not fab critical databases.  Now if 
I can only get ride of the 5 K-class database servers.  Its kind of like when you go from a fast to a slow 
PC.  Drives me crazy.  Not that 
there are issues with performance from the databases.  It 
would only be me, while playing (which of course 
means working) on the server, that would 
notice. -Original Message- 
Sent: Monday, July 09, 2001 8:30 AM 
To: Multiple recipients of list ORACLE-L 

Good morning everyone, Lucky me, I get to choose the size of the server this 
company should consider purchasing.  
I have been poking around on the net for any guidelines - I can make guesses based upon my gut feel and how 
strapped the current unix server is, but 
I want to be able to back this up with hard numbers.  This is for a dw application. Can anyone point me to a website, book, or anything in 
particular that can help me justify 
sizing a machine?  It's so fun working for a company that 
doesn't have a sysadmin on staff...  
Thanks Lisa Koivu Oracle Data Bored 
Administrator Ft. Lauderdale, FL, 
USA 954-935-4117 -- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce 
(CALBBAY)   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
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: 81714 aborted upgrade and core dumps on NT

[Shaw, John B]

Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some
as yet unexplained errors connecting older versions to 8.1.7 - most notably
with large objects.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:05 AM
To: Multiple recipients of list ORACLE-L


Hi,
I have just had the experience of upgrading to 81714, discovering a problem
in our application that did not show up in any testing and having to go back
to 815.

The 815 instance is on a different server to the 817 instance and we still
have the 817 instance available for further troubleshooting.

This is on NT4.

With 817, we were getting ora-3113 in the forms application and in ODBC
connections and also seeing ora-03121 as well.

We got core dump files produced (under 817 they are produced on NT) but
Oracle support does not seem to know how to interpret them on NT - has
anyone had any experience with this?

No mention of the core dump file was contained within the alert log and no
files were produced in the user dump directory.

When I turned sql trace on for the session running forms, the ora-3113 did
not occur - has anyone seen behaviour like this where SQL Trace will cause
an ora-3113 to stop occurring?

All suggestions on what to look for or how to interpret NT core dumps are
welcome.

Thanks,
Bruce Reardon
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Shaw, John B
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 support phone number

[Gogala, Mladen]

1-800-223-1711 (Silver)

-Original Message-
Sent: Monday, July 09, 2001 4:52 PM
To: Multiple recipients of list ORACLE-L



1-407-240-8900 

-Original Message- 
 ] 
Sent: Monday, July 09, 2001 4:05 PM 
To: Multiple recipients of list ORACLE-L 


Could somebody give me support 800 or long dist. phone number. I know that I

need to log itar first but this is a damagement request and I cannot find 
mine. 

Alex Hillman 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California-- Public Internet access / Mailing Lists 
 
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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 DBA with Data Warehouse Exp.-Albany, New York

[OraStaff]

Healthcare solutions company in Albany, New York needs an Oracle DBA to join
it's
I.T. team.
This company provides technical solutions to pharmacy, HMO and hospital clients.
They are calling it a "Developmental DBA":
You will be responsible for all facets of development related to the
logical database facilities.  Responsibilities will include working with
the Data Architect, Product Developers, and Application Programmers to
architect new solutions and enhance existing solutions. 

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Requirements:
- A B.S. Degree in C.S. or related field
- 3+ years Enterprise level Oracle DBA experience
- Proficiency in the following:
  development and modeling of OLTP, Warehouse, 
  data Marts databases and in leading database modeling tools
- Experience with and in writing and performance tuning PL-SQL.

- U.S. citizens or permanent residents only

This position offers:
* Opportunity to become a key member of the I.T. team
* Competitive Salary and Benefits package
* Relocation package may be available for the right candidate

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/Albany/DBA/Suzanne

Note: This is only one of the many opportunities that we have available
across the U.S. 
for candidates with Oracle skills who are U.S. citizens or permanent residents. 
So if this one is not a match for you, we invite you 
to send us your resume- as we quite possibly have the opportunity that you
are seeking.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Date / Time

[Scott Canaan]

Sajid,
Unfortunately, I ran into the same problem.  I didn't find anything to do
it for me, either, so I had to write the pl/sql code.  It is very long and
messy, but can be done.  When I did it, I didn't even attempt the days
notation.  Here is the code that I wrote:

date_diff := trans_cur.modified_date - last_date;
date_diff_tot := trans_cur.modified_date - first_date;
SELECT decode( trunc( date_diff * 24),0,
  to_char( trunc( date_diff * 1440), 'FM90') || ':' ||
  to_char( round( date_diff * 86400) - trunc( date_diff
* 1440) * 60,'FM00'),
  to_char( trunc( date_diff * 24),'FM90') || ':' ||
  to_char( trunc( date_diff * 1440 - trunc( date_diff *
24)
* 60),'FM00') || ':' ||
  to_char( round( date_diff * 86400 - trunc( date_diff
* 1440) * 60), 'FM00')),
  decode( trunc( date_diff_tot * 24), 0,
  to_char( trunc( date_diff_tot * 1440),'FM90') || ':' ||

  to_char( round( date_diff_tot * 86400)
- trunc( date_diff_tot * 1440) * 60,'FM00'),
  to_char( trunc( date_diff_tot * 24),'FM90') || ':' ||
  to_char( trunc( date_diff_tot * 1440
- trunc( date_diff_tot * 24) * 60),'FM00') || ':' ||
  to_char( round( date_diff_tot * 86400
- trunc( date_diff_tot * 1440) * 60), 'FM00'))
INTO elapsed_1, elapsed_2
FROM dual;

I hope this helps.

Sajid Iqbal wrote:

> Hello All
>
> I want to display the "time elapsed" between two dates - in days, hours,
> minutes and seconds.
>
> If I do "select date1 - date2", the result is : 12.0194907
>
> Is there a function that will turn the number of days into something more
> legible?  Ideally i'd like to do ;
>
> "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work.  Is
> there a solution other than writing a complex function myself which will
> have to * by 24, / by 60 and substr etc to get the different bits of the
> number?
>
> Please CC any replies directly to me at [EMAIL PROTECTED]
>
> Thanks in advance,
> Saj.
>
> --
> Sajid Iqbal
> Database Team Leader
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sajid Iqbal
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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).

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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

Client Connection-SQLNET ?/? ODBC.

[James Damiano]

Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: can/do indexes chain?

[A. Bardeen]

Even for inserts, index key values cannot span
multiple blocks.  An attempt to create an index where
a single key value won't fit in a single block will
result in an ORA-1450 "maximum key length exceeded".

-- Anita

--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote:
> Update in the index is done as delete and insert, so
> there is no chaining.
> 
> Alex Hillman
> 
> -Original Message-
> Sent: Thursday, July 05, 2001 5:46 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I've been asked to create an index which combines
> two fields, date &
> location.
> For reasons I don't really want to explain, we
> need/desire this index to
> be in the order of date, location. The minor gotcha
> is that while location
> will be populated at the time the record is created,
> the date field is not
> updated until a later point in time. This date is a
> document print date.
> So this date field will be going from a NULL value
> to a non-null value.
> I recognize that this can result in record chaining
> in the data table.
> In thinking about this, I realized this could have a
> similar affect
> within the index. However, I've never read anything
> about index chaining.
> 
> Do/can indexes chain? 
> Should I be concerned about this?
> 
> 
> -- 
> Charlie Mengler  Maintenance
> Warehouse  
> [EMAIL PROTECTED] 10641 Scripps
> Summit Ct.
> 858-831-2229   .NET? Not yet!San Diego, CA
> 92131
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Charlie Mengler
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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.com
> -- 
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: O9i Licensing

[Weaver, Walt]

Well, if you're lucky enough to use the Enterprise Edition you'll be saving
money. We use the Standard Edition, and at this time it looks like it's
going to cost us quite a bit more, actually, for a per-processor license. 

So, we're currently in delicate negotiations with our Oracle rep and various
resellers to see what kind of deal we can get. Fortunately we can still buy
licenses through the old "power unit" scheme through the end of July. Since
we're opening up a new hosting data center in New Jersey next month we're
gonna scarf up as many licenses as we can afford.

So, Larry, I got something you can smell right here.:>)

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Tuesday, July 10, 2001 8:35 AM
To: Multiple recipients of list ORACLE-L

Steve,

I have heard nothing to suggest that Oracle is abandoning the standard
vs.
enterprise edition packaging.  What I have heard and read at Oracle.com is
that
they are abandoning the Universal Power Unit in favor of Per Processor
pricing. 
Namely there is today two license models that they offer and support, named
user and per processor.  

Thanks Larry!!  Knew you'd smell the roses/coffee sooner or later.

Dick Goulet
Senior Oracle DBA
Vicor Corporation

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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