RE: RAC

2003-07-21 Thread K Gopalakrishnan
Suhen: Check the Metalink note 166830.1 for the details. KG --- Suhen Pather <[EMAIL PROTECTED]> wrote: > Kay, > > Can we get the Metalink note to run a single node RAC on Linux. > > TIA > > Suhen > > -Original Message- > Sent: Tuesday, 22 July 2003 4:40 PM > To: Multiple recipient

RE: RAC

2003-07-21 Thread Suhen Pather
Title: RE: RAC Kay, Can we get the Metalink note to run a single node RAC on Linux. TIA Suhen -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 22 July 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: RAC Not required.. We

Re: Who Says Oracle does not listen

2003-07-21 Thread Alex Feinstein
RE: Who Says Oracle does not listenAgree. One can improve EXCEPTION section to ignore only relevant errors. Alex. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, July 21, 2003 6:19 AM That's not good enough. I don't want to discard ANY exception. When droppin

RE: RAC

2003-07-21 Thread K Gopalakrishnan
Not required.. We used to run OPS on single node :)) for testing purposes. There are some step by step instructions in Metalink abt how to do that. --- "Goulet, Dick" <[EMAIL PROTECTED]> wrote: > You need at least 2 servers. > > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > >

Re: RAC

2003-07-21 Thread K Gopalakrishnan
AK: Very much possible and very simple if you are using Linux or Windoze. I think there is a note on Metalink with step by step instructions for setting a RAC on single node -Linux. It is slightly complicated if you want to run RAC on windows. I know couple of guys here who are running RAC on Win

RE: iAS Apache name-based virtual hosting

2003-07-21 Thread RAJESH DAYAL
Title: Message Hi, Did you specify the documentroot in the new virtual-host definition.? From documentation the full specs for name based Virtual-Hosting is NameVirtualHost 144.25.187.172       DocumentRoot /usr/local/apache/htdocs1     ServerName hostname1     Error

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Mladen Gogala
10gR3 will read programmer's mind and automatically correct all design errors. RDBMS 11T will look like Arnie Schwartzenegger ("T" is for "Terminator"). I'll be back. On 2003.07.21 22:04, Rachel Carmichael wrote: 10gR2 will automatically correct the errors. I'm waiting for the version that will

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Reardon, Bruce (CALBBAY)
You need Rdb (Oracle's other database) for that to work: eg: SQL> seelct count(*) from pot; %SQL-I-SPELLCORR, identifier SEELCT replaced with SELECT 334 1 row selected SQL> show version Current version of SQL is: Oracle Rdb SQL V7.1-101 Underlying versions are: Database with filenam

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Rachel Carmichael
10gR2 will automatically correct the errors. I'm waiting for the version that will know that I *meant* to type "select" when I actually type "seelct" --- Daniel Fink <[EMAIL PROTECTED]> wrote: > Okay, so its Monday... > > What I meant to say is that are the queries with different execution > p

RE: LMT

2003-07-21 Thread DENNIS WILLIAMS
AK None that I'm aware of. That is how I moved my tables into LMT, a few at a time. You may want to check Metalink for any bugs related to your specific Oracle version. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July

RE: RAC

2003-07-21 Thread Niall Litchfield
Title: Message www.oaktable.net. Harrison redhouse has a paper on this. Think vmware.   Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: 21 July 2003 19:49To: Multiple recipients of list ORACLE-LSubject: RAC Is it possibl

Re: Re: RAID select

2003-07-21 Thread bhabani s pradhan
Thanks a Lot === On Mon, 21 Jul 2003 Thomas Day wrote : > >Assuming that you have 3 physical devices (NON-RAID, RAID-1, and >RAID-0+1) >my quick-and-dirty take on this is: > >NON-RAID > redo logs - mirrored by Oracle > control logs - mirrored by Oracle > ORACLE_

LMT

2003-07-21 Thread AK
I am planning to move one of highly fragemented index tablespace from dictionary managed to locally managed . while other tablespaces are still dict managed.Its 1 8.1.7.4 on hp-ux . Are there any issues/bugs/problems when some tablespaces are dict managed and others are LMT.   -ak      

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jared . Still
Mladen, You apparently have never been involved in supporting SAP. :) He may not be able to contact Oracle directly. And if it involves a patch, that patch must come from SAP. Jared "Gogala, Mladen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:34 PM Please respond to OR

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Anderson, Brian
Metalink: 241160.1 ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX. Versions 9.2.0.2 and 9.2.0.3 > -Original Message- > From: Daniel Fink [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 6:20 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: HP-UX 11i/

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Daniel Fink
Okay, so its Monday... What I meant to say is that are the queries with different execution plans the ones encountering 7445s. If there is a common thread in the execution plans (i.e. hash join instead of nested loops), then the hj may be triggering the 7445s. Actually, 10g will have a new "FOR

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
Actually, I'm quite unaware of ORA-07745 as an execution plan. Can "EXPLAIN PLAN" foretell the error? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 6:20 PM To: Multiple recipients of list ORACLE-L Michael, W

RE: Oracle configuration on SAN

2003-07-21 Thread Jesse, Rich
Right (write?) you are. From the FastT900 User Manual: "All data stored in memory is preserved as long as the batteries can sustain power to the cache memory. However, the battery does not provide power to the rest of the system during a power outage. Therefore, the system is not able to write da

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
I'm unable to open a TAR for you, but here is what a quick Metalink search has produced: Oracle Server-Enterprise and Standard Edition Technical Forum Displayed below are the messages of the selected thread. Thread Status: Active before applying patch RDBMS Version: 8.1.6 Oper

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Daniel Fink
Michael, When you say 'different execution plans', what are the differences? Is the choice in execution plans causing the ORA-07445? If so, why are the execution plans different (there has to be a reason)? Statistics, parameters, etc. will alter the execution plan choices. The 7

RE: Fast!

2003-07-21 Thread Jesse, Rich
I think our Corporate Networks just upgraded because I'm now getting over 600K/s sustained downloads. I thought it was just something on our end. Thanks for the boost, Bruce! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

RE: 9i Grid "voodoo" cookbook

2003-07-21 Thread Matthew Zito
Well, (and this is honestly not a marketing pitch, I SWEAR) that's where companies like mine are stepping in. All of these kind of technologies are fine and dandy, but they add complexity, new skills to train people on, etc. The ownership savings can be very questionable. So, vendors build pro

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Ron: According to the ABAP programmers, the code 'variant' is identical. The generated SQL 'looks' the same, but the execution plans are radically different. Thanks, Mike -Original Message- Sent: Monday, July 21, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Is or are ALL of

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Oh no! I have to wait for 9iBF? I'll be retired by then, and I'm only ... well ... never mind how old I am. I don't wanna wait that long. Cheers, Mike -Original Message- Sent: Monday, July 21, 2003 2:35 PM To: Multiple recipients of list ORACLE-L He needs to contact oracle support,

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Raj:   Is OWS 'Oracle Worldwide Support'?  Our Oracle support comes directly from SAP, and they're on the case, but are as flummoxed as I am.  Right now they're trying to convince me that the problem is in the NLS parameters. However, these valu

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Jared: I am in contact with SAP support, but they're scratching their collective heads, too. I was hoping that maybe a SAP-savvy lister would be able to say "We had that...here's the fix". What's strange is that the report runs to completion on our Stage server. Thanks, Mike -Original Mes

RE: RAC

2003-07-21 Thread Jamadagni, Rajendra
Title: Message try with cluster_database=true ... Oracle will immediately start all the GC traffic...   Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. Q

RE: Fast!

2003-07-21 Thread Goulet, Dick
Bruce, Regrettably I can't tell. There's a spam blocker that filters out messages where the person being sent to is the same as the person sending. So I don't see how fast the posts arrive. But on the plus side the inbox is filling up faster. Now if I could just find someone who kne

RE: 9i Grid "voodoo" cookbook

2003-07-21 Thread Gogala, Mladen
Microsoft is the world's largest provider of cluster f... solutions for the IT. Their OS has spawned $3G industry which has the sole purpose of trying to secure it. It is about time that they got some competition. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Origi

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Ron Rogers
Is or are ALL of the SAP form identical on both servers? It could be the SAP is different on the servers and be the cause of the problem. Ron >>> [EMAIL PROTECTED] 07/21/03 05:34PM >>> He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-

RE: RAC

2003-07-21 Thread Odland, Brad
Title: Message You must of taken the Oracle Advanced Comeback and Retort class   Brad O. -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 4:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC   No, its definitely po

Re: need help with execute immediate from a script

2003-07-21 Thread Ryan
that was just a mock up of what I wrote. I dont have '||' in the real version. Its jut a typo here. Anyone know what is going on? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 5:24 PM > Your "using v_var1,v_var2" shouldn't

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Gogala, Mladen
He needs to contact oracle support, because the dump came from the oracle server process. If he's lucky, the one-off patch is already published and he only needs to download it from Metalink and apply it. If not, then he has to wait for oracle 9BF (BF = Bug Free) Mladen Gogala Oracle DBA Phone:(

RE: Oracle configuration on SAN

2003-07-21 Thread Matthew Zito
Yeah, write-back cache is better than write-through for performance. Mirrored cache is nice too, except that some implementations (and I have zero idea whether this applies to HP or IBM) used to do silly things like dispatch mirrored writes in serial rather than in parallel, and don't load-balanc

9i Grid "voodoo" cookbook

2003-07-21 Thread Odland, Brad
(Yeah Tom Mercadante...I agree) I remember a time when Microsoft was spouting Windows clustering and how great it was. People started with two boxes then kept adding until the whole mess fell apart. People and companies whet bust promoting cluster solutions. Rather than sizing a box appropriately

RE: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jamadagni, Rajendra
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions Most likely some thing to do with OS library. contact OWS. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal

RE: need help with execute immediate from a script

2003-07-21 Thread Rudy Zung
Your "using v_var1,v_var2" shouldn't be appended to the string that represents the dynamic SQL to execute; the "using..." is part of the syntac for execute immediate. An Oracle error message being what they are, they don't always highlight the correct cause of fault, but will identify some other er

Re: HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Jared . Still
SIGSEGV = Segment Violation = invalid address = bad code Sounds like you need to contact SAP and/or Oracle support. Jared "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list OR

RE: RAC

2003-07-21 Thread Matthew Zito
Title: Message   No, its definitely possible to do it with one - I know we've done it in the lab.  It wasn't me hands-on-the-keyboard doing the work, but as it was explained to me, you basically trick the sole node into thinking that it used to have a friend, and that friend had died in a ho

RE: need execute immediate and script help

2003-07-21 Thread Rudy Zung
Your "using v_var1,v_var2" shouldn't be appended to the string that represents the dynamic SQL to execute; the "using..." is part of the syntac for execute immediate. An Oracle error message being what they are, they don't always highlight the correct cause of fault, but will identify some other er

RE: need execute immediate and script help

2003-07-21 Thread Jamadagni, Rajendra
Title: RE: need execute immediate and script help you want 'select count(*)' ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod ca

RE: 10G

2003-07-21 Thread MacGregor, Ian A.
We're already doing grid computing. My part is infinitesimal. We keep or MCAT database in Oracle See http://www.npaci.edu/DICE/SRB/, and I try to keep that database healthy. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 21,

HP-UX 11i/9.2.0.3/Strange Executions

2003-07-21 Thread Vergara, Michael (TEM)
Hi Everyone! HELP! I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend. Everything up until now has been OK. However, I now have some SAP Transactions (read: data entry forms) that are abending unexpectedly. What's strange is that when we run the transaction on our Stage server

RE: RAC

2003-07-21 Thread Goulet, Dick
You need at least 2 servers.   Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: RAC Is it possible to setup RAC in one box only. Jus

need help with execute immediate from a script

2003-07-21 Thread rgaffuri
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' ||

need execute immediate and script help

2003-07-21 Thread rgaffuri
Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable "2" not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '&1'; total number; begin execute immediate ' Select * ' ||

RE: Fast!

2003-07-21 Thread Ron Rogers
I don't keep my mail window on top. But when I check back in I have been noticing that the mail is already in the inbox. Very good work on your end. I will try not to expect it all of the time as we still have to contend with the internet, local gateways, mailservers, fire walls, and border manag

RE: Oracle configuration on SAN

2003-07-21 Thread Jesse, Rich
In the same cache vein, make sure you know what type of caching is being done at each LUN (or how ever the HP's setup). Write-thru caching won't help your write speed at all, while write-back will. The trade off is that since write-back acknowledges the write from the cache (write-thru won't ackn

RE: Fast!

2003-07-21 Thread Mercadante, Thomas F
I've noticed! Good job Bruce! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 21, 2003 4:29 PM To: Multiple recipients of list ORACLE-L FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I p

RE: oracle10g

2003-07-21 Thread April Wells
Title: Message 101   April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: Orr, Ste

Re: Fast!

2003-07-21 Thread Jared . Still
FYI Hi Jared -- Yeah, I've been finally working on getting us closer to real-time speed. I put in the first of the changes about two weeks ago, but you probably didn't notice them until last weekend, when some significant changes were made. I've still got some more work to do

Re: 10G

2003-07-21 Thread Jared . Still
Ron, Still have read them. :) >From what I already know, this sounds correct. Fits right in with Sun's N1 technology. Jared "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/21/2003 12:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L

RE: 10G

2003-07-21 Thread Mercadante, Thomas F
Jared, Did you read the OTN document? I don't see any new technology here. In fact, it looks like a nightmare. They cited using Read-Only Tablespaces, Transportable Tablespace, database links and Oracle Streams for sharing data across the "blades" of the multi-server nodes. This is supposed to

RE: Solaris/Veritas filesystem for Oracle

2003-07-21 Thread Matthew Zito
Well, I don't know if this is the whole problem, but at least part of the problem is this: v odsd2-ENABLED ACTIVE 17408 SELECT odsd2-02 fsgen pl odsd2-01 odsd2ENABLED ACTIVE 174082473 CONCAT - RW sd lst1dg01-02 odsd2-01 lst1dg01 6144903 3183389

RE: Active Directory question

2003-07-21 Thread Niall Litchfield
Title: Message I didn't see it, probably 10G overload   I too have thought about it and decided, um no.   My reasons.   1. Its a brand new naming method. Brand new tends to mean buggy. 2. It requires modifying the AD schema (so you need to be schema admin to do this) 3. It will in

Re: 10G

2003-07-21 Thread Ron Rogers
Jared, Thanks for the articles. It looks like to grid concept would require the idle computers in the office to be connected to a fiber net and available to pick up part of the load when demand increased. Or did I miss-understand the article and each computer has it's own area of expertice and an

RE: Oracle configuration on SAN

2003-07-21 Thread Matthew Zito
A 14-drive RAID-5 set is very large. It's certainly functional, but the two problems you'll run into is problems with spindle contention and rebuild times. With a 14-drive set, your drive is getting cut into 14 columns, so that there's 14 different disk regions per drive it might have to seek to

RE: iAS Apache name-based virtual hosting

2003-07-21 Thread Matthew Zito
Title: Message   Did you add a NameVirtualHost (ip address) entry to your config file?  Otherwise it won't enable name-based vhosting for a particular IP.   Matt   --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com --

OT slashdot article: does .NET really scale

2003-07-21 Thread Boivin, Patrice J
I found this last weekend while surfing the 'net. http://ask.slashdot.org/askslashdot/03/07/18/2056208.shtml?tid=109&tid=187 Reminds me of the "The Truth about .NET" article on Oracle's web site. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patr

Re: RAC

2003-07-21 Thread Ron Rogers
AK, I remember reading about just what you want to do. It is complicated to set up but it is do-able. see METALINK: Doc ID: Note:166830.1 - Single node Type: BULLETIN Status: PUBLISHED Ron >>> [EMAIL PROTECTED] 07/21/03 02:49PM >>> Is it possible to setup RAC in one box only. Just to play with i

RE: faq broke? -- Other options

2003-07-21 Thread Chris Stephens
Title: RE: faq broke? -- Other options There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDN"T want to do this. -Original Message- From: Hallas, John, Tech Dev

iAS Apache name-based virtual hosting

2003-07-21 Thread Boivin, Patrice J
Has anyone managed to make name-based virtual hosting work on Apache bundled into iAS for Win32?   We configured Apache here, but strangely the original hostname still works.   We see the same page whether we type in the virtual hostname or the actual host name.   I would have thought that

Re: 10G

2003-07-21 Thread Jared . Still
On more serious note: Here's are links to a couple Oracle grid computing documents. The first is a newsletter I receive from our local Oracle office. The second is an OTN document. http://www.cybcon.com/~jkstill/Jul2003.pdf http://otn.oracle.com/products/oracle9i/grid_computing/Oracle9iGridCo

RE: Oracle configuration on SAN

2003-07-21 Thread Nelson, Allan
You are probably not going to be too happy with the raid5 organization. Please tell us how the disks are organized inside the array. Are they on multiple internal controllers? Is the cache ram? Allan -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 1:49 PM To: M

RE: Active Directory question

2003-07-21 Thread Pardee, Roy E
I've never tried it, but have questions for you anyway: 8^) So you want your clients to query AD for tns connect params a la' OID? Or do you have OID set up & you want to add oracle db info to it, so you can synch OID w/ AD without losing your database info? If the latter, I trust you've seen m

Oracle configuration on SAN

2003-07-21 Thread Sherrie . Kubis
Dear Listers, I'm looking for advice on configuring Oracle under a SAN. We just got a new box, an HP UX, with an HP CASA that's connected to an HP MSA1000 with fourteen 72gb drives configured as RAID-5 with Advanced Data Guard, and two global hot spares on that drive shelf. All of this is connec

RAC

2003-07-21 Thread AK
Is it possible to setup RAC in one box only. Just to play with it . Dont have more hardware .   -ak

RE: Solaris/Veritas filesystem for Oracle

2003-07-21 Thread Roger Xu
the following 6 volumes have all my datafiles, [lostdog]root:/tmp>df -k | grep sapdata | sort /dev/vx/dsk/lst1dg/odsd1 15260136 14811592 29594499%/oracle/DV2/sapdata1 /dev/vx/dsk/lst1dg/odsd2 86474632 80075904 553398494%/oracle/DV2/sapdata2 /dev/vx/dsk/lst1dg/odsd3 55954312 539250

RE: Solaris/Veritas filesystem for Oracle

2003-07-21 Thread Matthew Zito
Hrrrmmhard to say from just that. Would you be comfortable sending a vxprint -g lst1dg -hrt so we can see how the volumes got created? Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original

Re: SHOW ERRORS not working

2003-07-21 Thread Daniel Fink
I don't think SHOW is a function that you will find in any of the Oracle db creation scripts. It is most likely part of the sql*plus program. The keyword SHOW can be used for a lot of things (USER and PARAMETER come to mind). Obviously, it reads some data structures, but I am sure it is not a st

Solaris/Veritas filesystem for Oracle

2003-07-21 Thread Roger Xu
Hi, After I moved all my Oracle tablespace datafiles to ufs filesystems in Veritas Volume, the database performance suffers a whole lot. I think the problem is in the way I create the volume or the way I create the filesystem. vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 newfs

RE: RE: SHOW ERRORS not working

2003-07-21 Thread Grant Allen
Nope, in fact this is a good example of my failure to "read the whole question before replying". I thought Dave said no output was showing ... but he really said no errors were showing after the response that there were errors. My bad. I blame the fact it's Monday :-) I think the other suggests

RE: SHOW ERRORS not working

2003-07-21 Thread Gudmundur Bjarni Josepsson
Have you tried 'show errors procedure blabla'? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing li

Re: RE: SHOW ERRORS not working

2003-07-21 Thread rgaffuri
you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its created? you can find the code and then just craete the show errors function? might be in sql.bsq > > From: "Grant Allen" <[EMAIL PROTECTED]> > Date: 2003/07/21 Mon PM 12:24:24 EDT > To: Multiple recipients of li

Re: SHOW ERRORS not working

2003-07-21 Thread AK
ask him to try "select * from user_errors" if that works ? -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 8:44 AM > I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it an

Re: SHOW ERRORS not working

2003-07-21 Thread Ron Rogers
Dave, Is the procedure owner the developer? If there are errors then they would show up in user_errors other wise the errors are owned by the owner of the procedure. Check the grants on the different xxx_error tables and grant accordingly. Ron >>> [EMAIL PROTECTED] 07/21/03 11:44AM >>> I have a d

RE: SHOW ERRORS not working

2003-07-21 Thread Grant Allen
This used to get me all the time. I'm pretty sure you need to issue SET SERVEROUTPUT ON; to see the output. Ciao Fuzzy :-) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Farnsworth, Dave > Sent: Monday, July 21, 2003 16:45 > To: Multiple recipien

RE: SHOW ERRORS not working

2003-07-21 Thread Rudy Zung
Not sure how SHOW ERRORS is implemented in SQLPlus, but it may only be looking at USER_ERRORS intead of ALL_ERRORS. So if your developer is altering another schema's procedure (via the alter ANY procedure privilege) those errors will not show up in his USER_ERRORS. BTW, this is just my guess on t

RE: oracle10g

2003-07-21 Thread Jamadagni, Rajendra
Title: Message I don't think there was one ... no handouts ...   Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an

RE: SHOW ERRORS not working

2003-07-21 Thread Igor Neyman
Not sure, what causes the problem. But, probably a workaround is to grant him rights to select from dba_errors. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Farnsworth, Dave Sent: Monday, July 21, 2003 10:45 AM To: Multiple recipients of list ORACLE-L I have a developer t

RE: SHOW ERRORS not working

2003-07-21 Thread Jamadagni, Rajendra
Title: RE: SHOW ERRORS not working select grant on all_errors ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an

RE: SHOW ERRORS not working

2003-07-21 Thread Gogala, Mladen
Have him try "SHOW ERRORS PROCEDURE " Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure,

Re: DB shift

2003-07-21 Thread Jared Still
You can copy 8170 files to a new server via hot backup, create a new control file, open resetlogs and then upgrade to 8174. Try it first on a test server. I've done this from 8.0.4 -> 8.1.7.4 with no problems. Jared On Monday 21 July 2003 07:44, Goulet, Dick wrote: > No, See the 8.1.7.4 patch

RE: oracle10g

2003-07-21 Thread Matthew Zito
Title: Message   Does anyone know if there's an archive of this presentation (slides, song and dance routine, etc.) available on the net somewhere?     Thanks, Matt  --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -

SHOW ERRORS not working

2003-07-21 Thread Farnsworth, Dave
I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions t

RE: oracle10g

2003-07-21 Thread Boivin, Patrice J
Title: Message Sounds promising actually...   I think this is mostly for high-end applications though, I don't know if the medium-sized shops will use the "g" in 10G.   Patrice. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003

RE: faq broke? -- Other options

2003-07-21 Thread Hallas, John, Tech Dev
Good point Rich. I am sure I saw a post recently from Cary Millsap which shows how you could flush the buffers out with an alter system command (9i only) - to save restarting the database when running performance trials I have searched for it everywhere to no avail So if anybody recalls what it

RE: Active Directory question

2003-07-21 Thread Jamadagni, Rajendra
Title: RE: Active Directory question I have _thought_ about  it and given up on that .. seriously, next year we will look at it again ... really . Raj Rajendra dot Jamadagni at nospamespn dot com All Views exp

RE: oracle10g

2003-07-21 Thread Orr, Steve
Title: Message 10 to the googol power. Pop Quiz... How many goose eggs is that?! -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta l

RE: oracle10g

2003-07-21 Thread Jamadagni, Rajendra
Title: Message Yes and no it is more like distributed RAC if you attended Hotsos/2003 you heard about this in the RAC presentation ... Oracle will find a node that has less work and ship your work over there and bring the results back to you ...  This is not exactly how it is (much more

Re: oracle10g

2003-07-21 Thread Joe Testa
performance drops off after 10g? joe Dong, Ping - Raleigh, NC wrote: 10G isn't as smart as Teradata (1000G). - Ping -Original Message- *From:* Ruth Gramolini [mailto:[EMAIL PROTECTED] *Sent:* Monday, July 21, 2003 10:59 AM *To:* Multiple recipients of list ORACLE-L

RE: oracle10g

2003-07-21 Thread Baswannappa, Shiva
grid computing   Shiva -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for?  RBG -Original Message-From: [EMAI

RE: oracle10g

2003-07-21 Thread Gogala, Mladen
I thought it was "gridlock", not "grid"? You know, something like I-84 at 8:30 A.M.?   Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 11:14 AMTo: Multiple

RE: How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

2003-07-21 Thread Goulet, Dick
First off you need SQLCHECK=SEMANTICS and the login that you pass must have execute priviledges. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 21, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Hi, I have a problem with using orac

RE: oracle10g

2003-07-21 Thread Nigel Bishop
Title: Message Grid as in Grid computing, sounds like RAC to me       -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: 21 July 2003 15:59To: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for?  RBG

RE: Active Directory question

2003-07-21 Thread DENNIS WILLIAMS
I did not receive any replies to this posting. Does that mean that nobody has connected Oracle to Active Directory? Has anyone tried and given up on this? -Original Message- Sent: Wednesday, July 16, 2003 1:42 PM To: '[EMAIL PROTECTED]' We are trying to configure an Oracle LDAP connectio

RE: oracle10g

2003-07-21 Thread Dong, Ping - Raleigh, NC
10G isn't as smart as Teradata (1000G).   - Ping -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]Sent: Monday, July 21, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle10g What on earth does the g stand for?  RBG -Ori

Re: oracle10g

2003-07-21 Thread Joe Testa
gobs of money joe Ruth Gramolini wrote: What on earth does the g stand for? RBG -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Adams, Matthew (GECP, MABG, 088130) *Sent:* Thursday, July 17, 2003 3:45 PM *To:* Multiple recipients of

RE: oracle10g

2003-07-21 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message Grid Computing??  If you click on the link, it says, "Oracle's introduces its new flagship database with Dynamic Grid Computing - Oracle10G". -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 9:59 AMTo: Multiple re

RE: oracle10g

2003-07-21 Thread Jamadagni, Rajendra
Oracle Grid Computing ...   Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Origina

  1   2   >