FW: Oracle Instances not starting up via services

2003-07-21 Thread Skursk Michal
Hi, I send this mail on friday, but it seems me not arrived to the list. Michal -Original Message- Sent: Friday, July 18, 2003 11:32 AM To: '[EMAIL PROTECTED]' Hi, my experience: 1. It is not possible to start instance through Terminal Services - svrmgrl produces ORA-12560 error.

Re: Re: DB shift

2003-07-21 Thread bhabani s pradhan
thanks a lot On Sun, 20 Jul 2003 Tanel Poder wrote : Hi! When moving to binary compatible platform, you can directly copy over the files (and software). It's even possible with different versions of OS - like from SunOS 2.6 to Solaris 8. For upgrading to 8.1.7.4 follow

Re: RE: Different Platform

2003-07-21 Thread bhabani s pradhan
FORTE compiler On Mon, 21 Jul 2003 Richard Ji wrote : So which compiler will you standarize on? GCC? On Solaris I believe the Sun C Compiler is supported but not gcc, though you can make it work. -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To:

Re: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

2003-07-21 Thread Garry Gillies
Hi Nirmal, I believe there is a bug in the installer and the following two steps are missing cd $ORACLE_HOME/plsql/jlib loadjava -user sys/sys_password plsql.jar Do them yourself manually and you should be fine. Hope this helps Garry Gillies Database Administrator Business Systems

RE: ODBC Patch 8.1.5.7 where to download

2003-07-21 Thread Grant Allen
Title: ODBC Patch 8.1.5.7 where to download technet.oracle.com. Follow the download links. Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 18, 2003 15:49To: Multiple recipients of list

AW: Re: Object Types in PL/SQL

2003-07-21 Thread Stefan Jahnke
Hi Sorry for the late reply ... weekend ;). If I understand you correctly, you do the following: Use normal tables (a normalized data model ?), then create an additional Object Type for each table with methods to do DML on that table. From Java, only use stored procs/funcs to manipulate the

Re: RAID select

2003-07-21 Thread Thomas Day
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_HOME RBS01 RBS02 TEMP STAT(For PERFSTAT) RAID-1

RE: Recent reports on outages caused by DB2 and 9iRAC issues

2003-07-21 Thread Orr, Steve
WOW! Those are some good stories to keep in mind... And some folks wonder why techies like working with computers more than working with people. ;-) Trying to be wise as a serpent and harmless as a dove... -Original Message- Sent: Friday, July 18, 2003 1:49 PM To: Multiple recipients

RE: faq broke? -- Other options

2003-07-21 Thread Jesse, Rich
Hey Bruce, Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: DB shift

2003-07-21 Thread Goulet, Dick
No, See the 8.1.7.4 patch set documentation and do it with a COLD database on the source side. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Sunday, July 20, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi All We are planning to Shift our

RE: oracle10g

2003-07-21 Thread Ruth Gramolini
What on earth does the g stand for? RBG -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, July 17, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle.

How to use SYS.DBMS_OUTPUT.PUT_LINE in ProC?

2003-07-21 Thread gyurika
Hi, I have a problem with using oracle built in stored procedures in embadded C. It is impossible to compile my program by ProC. It says: sys.dbms_alert.remove( 'prolan_alert' ); ..1 PLS-S-00201, identifier 'SYS.DBMS_ALERT' must be declared sys.dbms_alert.remove(

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 !

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

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

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

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

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: 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: [EMAIL

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 Jamadagni, Rajendra
Title: Message Yes and no it is more likedistributed 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 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

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

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

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

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

RE: SHOW ERRORS not working

2003-07-21 Thread Gogala, Mladen
Have him try SHOW ERRORS PROCEDURE proc. name 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

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

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

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

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 recipients

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

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 list

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

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

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

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: Solaris/Veritas filesystem for Oracle

2003-07-21 Thread Roger Xu
the following 6 volumes have all my datafiles, [lostdog]root:/tmpdf -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

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

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

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

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:

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

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 seethe same page whether we type in the virtual hostname or the actual host name. I would have thought that

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 WOULDNT want to do this. -Original Message- From: Hallas, John, Tech Dev

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=109tid=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,

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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 error

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

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

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 error

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

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

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

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 be

RE: RAC

2003-07-21 Thread Odland, Brad
Title: Message You must of taken the Oracle AdvancedComeback 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

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]

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

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.

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

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 values

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

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]

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

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

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,

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

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

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

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 . Arethere any issues/bugs/problems when some tablespaces are dict managed and others are LMT. -ak

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_HOME

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

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,

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

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: 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 VirtualHost 144.25.187.172 DocumentRoot /usr/local/apache/htdocs1 ServerName

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

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

  1   2   >