OID problem
Dear All, We have installed the OID. We want to use the LDAP inside this for authenticating the users to our application. We were able to connect to this using the JNDI, but we are not able to add anything to this. Could anybody explain why this is happening. It would be nice if somebody can give me a link to some simple step by step document for configuring the LDAP on OID. Regards Prem Chandran N
One way replication in multimaster environment
hi experts, In my replicated environment, i have one site (example: site X) that consolidate data from other sites (example : site Y and Z). I'm using multimaster to push transaction from site Y and Z to site X. How can i set - off the replication in site X , cause i dont want site X to push the changes to other sites or to disable row-level replication. any idea ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico 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-L Digest -- Volume 2002, Number 122
>> It is kind of amazing how irrelevant and lacking in substance >> this discussion is. > -- > > From: "Seefelt, Beth" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 16:00:57 -0400 > Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) > > Hmmm, I'm guessing you're a student at csus and not a professional > there. Grow up. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Create a new database
Hamid, Generally, finding an "alert*.log" file in the default "$ORACLE_HOME/rdbms/log" directory, even when BACKGROUND_DUMP_DEST has been set, indicates that someone issued the SHUTDOWN ABORT command when the instance wasn't already running. Alternatively, issuing the STARTUP FORCE command (which first performs a SHUTDOWN ABORT then a STARTUP) when the instance isn't already running could get the same effect. In other words, I think it's a red herring -- you probably shouldn't worry about it. Set your BACKGROUND_DUMP_DEST, USER_DUMP_DEST, CORE_DUMP_DEST, and AUDIT_FILE_DEST parameters to "$ORACLE_BASE/admin/$ORACLE_SID/bdump", ".../udump", ".../cdump", and ".../adump" respectively and start over. If the ORA-03113 occurs again, look for "core" or ".trc" files in those directories and log a TAR with Oracle Support... Hope this helps... -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:37 PM > Tim, > This is me again, this is all in $ORACLE_HOME/rdbms/log > Thu May 2 10:15:06 2002 > Shutting down instance (abort) > That's it which I found as a log. > Thanks for your HELP > > -Original Message- > Sent: Thursday, May 02, 2002 1:54 PM > To: Multiple recipients of list ORACLE-L > > > ORA-03113 (and ORA-03114) are error messages issued by the client process, > not generated on the server (like most "ORA-" messages). Both essentially > are complaints by the client process (i.e. SQL*Plus) that there is no longer > a connection to the database server process. The usual way this occurs is > if the database server process has "core-dumped" or "aborted" from > experiencing a "bus error", "segmentation fault", "segmentation violation", > etc. Something dramatic and instantly fatal, kind of like a brain aneurism > for computer processes... > > You should be able to find a large, cryptic ASCII-text trace file (i.e. > "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. > The "alert_.log" file (located in whatever directory the > BACKGROUND_DUMP_DEST parameter is pointing to) should also have something > logged in it. Unless the process was killed with the "KILL" or "-9" signal, > Oracle executables generally try to produce a "core" file before it dies. > This trace file would represent a good starting point for a search of > MetaLink or for logging a TAR... > > If you haven't set these two "_DEST" parameters yet, then these files can > probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some > such... > > And the advice to upgrade to 8.1.7.2 still holds... :-) > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:48 PM > > > > I don't know why you are getting the ORA-3113 > > > > I was merely trying to offer some advice based on limited information. > > > > ORA-3113 is a 'catch all' error; any number of things can cause that > > error. > > > > Are there other errors associated with it? > > > > Please include the list in your replies so as not to limit responses to > > one individual. > > > > And the advice to move to 8.1.7.2 still holds. > > > > Jared > > > > > > > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > > 05/02/2002 11:40 AM > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Create a new database > > > > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > > But during the installation 8.1.7.0 I create a database, How come now I > > can > > not create another one?? > > > > > > -Original Message- > > Sent: Thursday, May 02, 2002 11:22 AM > > To: [EMAIL PROTECTED] > > Cc: Hamid Alavi > > > > > > Which version exactly? > > > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > > databases. 8.1.7.3 is available, but rife with bugs. > > > > Jared > > > > > > > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 05/02/2002 11:28 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:Create a new database > > > > > > Hi List, > > > > When I try to create a new database (8.1.7) under sun solaris I got the > > following error: > > ORA-03113: end-of-file on communication channel > > > > Any Idea? Any help realy appreciated. > > > > This is the contenet of log file which created: > > > > Connected. > > ORA-03113: end-of-file on communication channel > > CREATE DATABASE "CMSREPT" > > * > > ORA-03114: not connected to ORACLE > > Disconnected. > > > > > > Thanks > > > > > > > > Hamid Alavi > > Office 818 737-0526 > > Cell818 402-1987 > > > > > > > > > > > > > > === Confidentiality Statement === > > The information contained in this message and any attachments is > > intended only for the use of the individual
Re: ORACLE-L Digest -- Volume 2002, Number 122
the more important question is where are the rocky mtn oysters!? > -- > > From: "Weaver, Walt" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 14:16:25 -0600 > Subject: RE: ITS THE PHB, STPID (was: anti-virus spam) > > Ball in your court, Mr. Pierce. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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 nt threads sql / Re: ORACLE-L Digest -- Volume 2002, Number 122
ORACLE-L Digest -- Volume 2002, Number 122 > -- > > From: "Yechiel Adar" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 13:14:18 +0200 > Subject: Re: CPU Pegged at 100% > > Hello Igor > > Thank you for the info. > > I got the following script from one of the articals that Thomas Day point > to in the message With subject Oracle & windows. It shows the threads that > oracle is using. The first column has a call to some function that > probably did some formating but I deleted it. > > create or replace view > NT_threads > as > select > p.spid "ID_THREAD", > p.background "BACKGROUND", > b.name "NAME", > s.sid "SID", > s.serial# "SERIAL#", > s.username "USERNAME", > s.status "STATUS", > s.osuser "OSUSER", > s.program "PROGRAM" > from > v$process p, > v$bgprocess b, > v$session s > where > s.paddr = p.addr > and > b.paddr(+) = p.addr; > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: pl/sql is INTERPRETED?
Okay then, but you are on probation for 30 daze, don't do it again ;^) Brian Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: pl/sql is INTERPRETED? om 05/02/02 04:53 PM Please respond to ORACLE-L Hmmm... Appears I'm violating some of my own rules here. My bad, I apoligize to the list. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/02/2002 12:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? And here I thought this was a private message. You have unfortunately caught me in a rather stressful week, and I find great relief in greeting arrogance with sarcasm. Don't worry about it, what I learned in a week would take you a month. Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably say any language is easy to learn; it is just ifs, elses, and loops. On Thu, 2 May 2002 [EMAIL PROTECTED] wrote: > It ain't that tough. We're not talking about taking a programming > class without any experience, I've done a bit of it before. > > Learning all the API's, etc.: that would take some time. > > The language? It isn't that difficult, though I would be > hard put to write any at the moment. The job I was going > to use Java on was at Enron, and we all know what happened > to that. > > It's been a year since I took the class, and I *much* prefer > Perl. It can run circles around Java for most stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously do not know it. > Syntax is one thing design is another. I would love to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's is > > another story, but Java as a language is pretty simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > > learned fairly easily in comparison to the many other choices out > there. > > > However, it takes a bit of database savvy to do it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college that the same people > failing > > > the simple entity-relationship modeling portion of the class that had > aced > > > the Op Systems and networking classes we took. I nearly failed both > > > classes, they were so complex. I was the teacher's pet in the db > class > > > because I asked him questions that made him think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - night student, straight > from > > > work.)
RE: ERD generation tool
All bugs that I am experiencing are in 3.5.2. A lot of the problems with ERwin are not CA's fault. And trust me, I have no respect for CA. -Original Message- Chris Sent: Thursday, May 02, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Yes, I always have that box checked. I still get an mixed order columns when I gen the DDL. Yes, 4.0 sucks. One of the projects here actually purchased 4.0, but then had to fall back to 3.5.2, because of the bugs. Let's all thank CA for taking another fine product and destroying it. -Original Message- Sent: Thursday, May 02, 2002 12:45 PM To: Multiple recipients of list ORACLE-L As I remember (since I'm no longer using ERWin since CA's takeover) there is a "Physical Order" box somewhere than needs to be clicked. If you do this, ERWin will use the actual physical order of the table, otherwise it will put them in another order (I think that it's primary key, foreign keys, and then alphabetical). The latest version of ERWin just isn't bug free enough for me to use as a primary tool --- so I'm using nothing. If I can't trust a tool then I can't use it. "Grabowy, Chris" To: Multiple recipients of list ORACLE-L @fcg.com>cc: Sent by: rootSubject: RE: ERD generation tool 05/01/2002 06:56 PM Please respond to ORACLE-L No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... -Original Message- Sent: Wednesday, May 01, 2002 6:32 PM To: Multiple recipients of list ORACLE-L I have seen it create two columns with the exact same name in a table. It did this by putting double quotes around the column it was adding (that actually already existed.) What's so bad about moving the pk fields to the top? Why would you put them in the middle of the table? I think having pk at the top is more readable, and it assists with more optimal storage at a very low level. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Paul Li [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 6:17 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > ERWin change the column sequences when using Reverse Engineering to > generate > diagram. It puts all of primary key columns on the top. But, actually some > primary key columns are in the middle of table. That is really bad. Does > anybody see the same problem? > > > > -Original Message- > Sent: Wednesday, May 01, 2002 5:01 PM > To: Multiple recipients of list ORACLE-L > > > ERWin's not much better. Has some better modeling capability as you might > guess, but has some VERY annoying quirks too. You also need to drill down > endlessly when doing a compare and I have seen it see two exact tables > (even > case being the same) and see them as different. The DO have a MATCH > button > that I would SUPPOSE allows you to re-align them, but I would not know for > sure as I get Dr. Watson's whenever I press it and the whole thing > crashes! > > I had a nice BUG last week only. Generated scripts for the model, ran > them > on the db, then ran a compare from the model to the db. Darn thing came > up > with differences > > Furthermore, I find that if you work from the Logical Model (like I do), > the > changes are not equally presented to the physical model (ie name > change./datatype change) and its NOT consistent with this behavior either! > > It has a report builder, but it doesn't report on datatypes entered on the > Logical side (even though the datatype on the physical MAY be different) = > therefore you can't run any consistency reports between the Logical and > Physical models. > > I have been using ERWin both as a modeling tool and a change repository > for > the model.I like to run several reports against a model (I call them > the > Sanity Checks Reports) you know, make sure that all columns named the > same (ie DESCRIPTION) are of the same datatype, length, etc. > > Anyhow, I can rant and rant. > > ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and > it > is rather easy to accidentally drop and drag either a relationship or > field > when re-aligning the model.. > ugh > > I wish we could get together a group and benchmark some relatively unknown > but stable modeling tool who's maker will listen to the DBA community and > put their name in the market (IE. give them market share)
Re: pl/sql is INTERPRETED?
Hmmm... Appears I'm violating some of my own rules here. My bad, I apoligize to the list. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/02/2002 12:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? And here I thought this was a private message. You have unfortunately caught me in a rather stressful week, and I find great relief in greeting arrogance with sarcasm. Don't worry about it, what I learned in a week would take you a month. Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably say any language is easy to learn; it is just ifs, elses, and loops. On Thu, 2 May 2002 [EMAIL PROTECTED] wrote: > It ain't that tough. We're not talking about taking a programming > class without any experience, I've done a bit of it before. > > Learning all the API's, etc.: that would take some time. > > The language? It isn't that difficult, though I would be > hard put to write any at the moment. The job I was going > to use Java on was at Enron, and we all know what happened > to that. > > It's been a year since I took the class, and I *much* prefer > Perl. It can run circles around Java for most stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously do not know it. > Syntax is one thing design is another. I would love to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's is > > another story, but Java as a language is pretty simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > > learned fairly easily in comparison to the many other choices out > there. > > > However, it takes a bit of database savvy to do it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college that the same people > failing > > > the simple entity-relationship modeling portion of the class that had > aced > > > the Op Systems and networking classes we took. I nearly failed both > > > classes, they were so complex. I was the teacher's pet in the db > class > > > because I asked him questions that made him think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - night student, straight > from > > > work.) > > > > > > What's easy for who is dependent on the person's strengths. > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > > To:Multiple recipients of list ORACLE-L > > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > > short period of time, or for that matter, any other language. > > > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, > and > > > > he tore into many real-life examples of PL/SQL. Supposedly, these > were > > > > written > > > > by developers that knew what they were doing. > > > > > > > > Granted, if a smart developer sits down and reads Feuerstein's > Learning > > > > PL/SQL and Best Practices books, then perhaps they will be good. But > who > > > > the hell has free time? There is no free time on any project or > effort > > > > that > > > > I know of!! I'm struggling with trying to improve my Oracle DBA > skills, > > > > plus some developers skills so I can speak their language when they > blow > > > > out > > > > OPEN_CURSORS or something. My head is swimming in the stupid > technical > > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, > BC4J, > > > > JDBC, > > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me > what > > > > all > > > > those mean, because I can't
Re: pl/sql is INTERPRETED?
Recess is over children. Let it go. Time to get back to work. Jeeze By the way Alex, nice to see another m-net.arbornet.org user on the list. Brian P. MacLean Oracle DBA, OCP8i Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: pl/sql is INTERPRETED? om 05/02/02 12:33 PM Please respond to ORACLE-L Watch for my new book! Learn Java in 20 minutes and earn BIG Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. -- 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).
Re: shared pool memory issue on OPS (non-MTS)
That certainly sounds like the solution to the immediate problem. (Mind you, those initial numbers look like generated values, not manual settings). However, it doesn't answer the question of why one of the machines has the problem. Do you think it;s possible that lots of material gets loaded and KEEP'ed in this instance before the other instance starts up, making this instance the resource master for a very large dictionary cache ? Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 02 May 2002 22:44 |Check out the following two values: | |Resource Current MaxInitial Limit |Name Utilization UtilizationAllocation Value |---- ---- |lm_ress252143 256732 177599 UNLIMITED |lm_locks 278106 288642 189208 UNLIMITED | |Notice that "Current/Max Utilization" is much higher than "Initial |Allocation"? | |This means that (messages to alert.log or not), the DLM is overflowing its |allocated space in the SGA and invading the Shared Pool. Increase your |LM_RESS and LM_LOCKS parameter values... | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Does any one know how to call LDAP from UNIX script ?
I'm very very appreciate call the helps I get here.
Just have to listen to the users also.
Thanks
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Are you kidding? Charlie goes through the trouble
> of sending this to you
> and the list and you ask for it in a different
> language?
>
> Jump in, learn something new. It's fun in here.
>
> Lisa Koivu
> Oracle Database Baby Oven
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
>
> > -Original Message-
> > From: Steven Joshua [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, May 02, 2002 6:17 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: Does any one know how to call LDAP
> from UNIX script ?
> >
> > Thanks for the code.
> > But can we do this in UNIX shell script or Java?
> >
> > Thanks again
> >
> > Steven
> >
> >
> > --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > > I hope you can read UGLY Perl code.
> > >
> > > HTH & YMMV!
> > >
> > > #!/usr/local/bin/perl
> > > # File: chg-oracle-passwd.cgi
> > > use Net::LDAP;
> > > use Carp;
> > > use DBI;
> > > $ENV{"ORACLE_HOME"} =
> > > "/db02/app/oracle/product/8.1.6";
> > > print "Content-type: text/html\n\n";
> > > print "\n\n\n\n";
> > > #print "METHOD = $ENV{'REQUEST_METHOD'}\n";
> > > if ($ENV{'REQUEST_METHOD'} eq 'GET') {
> > >$form_info = $ENV{'QUERY_STRING'};
> > > }
> > > elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
> > >$form_info = '';
> > >$bytes = $ENV{'CONTENT_LENGTH'};
> > >read (STDIN, $form_info, $bytes);
> > > }
> > > @pairs = split(/&/, $form_info);
> > > foreach $pair (@pairs) {
> > >($name, $value) = split(/=/, $pair);
> > >$value =~ tr/+/ /;
> > >$value =~
> s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",
> > > hex($1))/eg;
> > >if ($name eq "UNAME") {
> > > $istring = $value;
> > >}
> > >if ($name eq "PWORD") {
> > > $passwd = $value;
> > >}
> > >if ($name eq "DATABASE") {
> > > $dbase = $value;
> > >}
> > > }
> > > #
> > > my ($ldap, $res, $code);
> > > $mypasswd = $passwd;
> > > $myuid= $istring;
> > > $ldap = Net::LDAP->new('ldap.mwh.com:389') ||
> die
> > > "$@";
> > > $mesg = $ldap->bind('cn=Directory Manager') ||
> > > die("failed to bind with ",
> > > $mesg->code(),"\n");
> > > $res = $ldap->search
> > > (
> > >base => "ou=People,o=mwh.com",
> > >filter => "&(uid=$myuid )
> > > (!(objectclass=alias))",
> > >attrs => []
> > > ) || die;
> > > $code = $res->code;
> > > $cnt = $res->count;
> > > #print "After 1st LDAP call using $myuid with
> > > results = $code\n";
> > > #die "User $myuid not found" if $code ||
> $res->count
> > > != 1;
> > > if ( $code == 1 || $cnt == 1 )
> > > {
> > > $valid_username = 1;
> > > #print "code equal to $code and count = $cnt
> > > \n";
> > > my $entry = $res->entry(0);
> > > $res = $ldap->bind(dn => $entry->dn, password
> =>
> > > $mypasswd) or die;
> > > $code = $res->code;
> > > #print "LDAP return value = $code \n";
> > > #die "Login failed" if $code;
> > > if ( $code != 0 )
> > > {
> > > $pwmatch = 0;
> > > } else
> > > {
> > > $pwmatch = 1;
> > > }
> > > #$mesg = $ldap->search
> > > #print "mesg is $mesg";
> > > } else
> > > {
> > > $valid_username = 0;
> > > $pwmatch = 0;
> > > #print "invalid username ";
> > > }
> > > $ldap->unbind;
> > >
> > > Steven Joshua wrote:
> > > >
> > > > Hello:
> > > >
> > > > Hope the subject make sense. I'm new to LDAP,
> and
> > > > don't know how it works.
> > > > I need to use SQL Loader to load a text file
> into
> > > > Oracle817 Database from a unix box. The
> file/data
> > > > comes from LDAP server. My question is: how do
> I
> > > get
> > > > the file/object from LDAP site from my unix
> > > script?
> > > >
> > > > Does anyone has any examples? or know a
> helpful
> > > URL?
> > > >
> > > > Thanks
> > > >
> > > > From Steven
> > > >
> > > >
> __
> > > > Do You Yahoo!?
> > > > Yahoo! Health - your guide to health and
> wellness
> > > > http://health.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: Steven Joshua
> > > > 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: Does any one know how to call LDAP from UNIX script ?
Here are a few more resources:
http://www.umich.edu/~dirsvcs/ldap/ldclients.html (you could download
the client for Unix and use those libraries in shell)
http://www.mozilla.org/directory/standards.html
Suzy Vordos wrote:
>
> Yes, you'd need the LDAP API libraries, check here
> http://www.openldap.org/
>
> Steven Joshua wrote:
> >
> > Thanks for the code.
> > But can we do this in UNIX shell script or Java?
> >
> > Thanks again
> >
> > Steven
> >
> > --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > > I hope you can read UGLY Perl code.
> > >
> > > HTH & YMMV!
> > >
> > > #!/usr/local/bin/perl
> > > # File: chg-oracle-passwd.cgi
> > > use Net::LDAP;
> > > use Carp;
> > > use DBI;
> > > $ENV{"ORACLE_HOME"} =
> > > "/db02/app/oracle/product/8.1.6";
> > > print "Content-type: text/html\n\n";
> > > print "\n\n\n\n";
> > > #print "METHOD = $ENV{'REQUEST_METHOD'}\n";
> > > if ($ENV{'REQUEST_METHOD'} eq 'GET') {
> > >$form_info = $ENV{'QUERY_STRING'};
> > > }
> > > elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
> > >$form_info = '';
> > >$bytes = $ENV{'CONTENT_LENGTH'};
> > >read (STDIN, $form_info, $bytes);
> > > }
> > > @pairs = split(/&/, $form_info);
> > > foreach $pair (@pairs) {
> > >($name, $value) = split(/=/, $pair);
> > >$value =~ tr/+/ /;
> > >$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",
> > > hex($1))/eg;
> > >if ($name eq "UNAME") {
> > > $istring = $value;
> > >}
> > >if ($name eq "PWORD") {
> > > $passwd = $value;
> > >}
> > >if ($name eq "DATABASE") {
> > > $dbase = $value;
> > >}
> > > }
> > > #
> > > my ($ldap, $res, $code);
> > > $mypasswd = $passwd;
> > > $myuid= $istring;
> > > $ldap = Net::LDAP->new('ldap.mwh.com:389') || die
> > > "$@";
> > > $mesg = $ldap->bind('cn=Directory Manager') ||
> > > die("failed to bind with ",
> > > $mesg->code(),"\n");
> > > $res = $ldap->search
> > > (
> > >base => "ou=People,o=mwh.com",
> > >filter => "&(uid=$myuid )
> > > (!(objectclass=alias))",
> > >attrs => []
> > > ) || die;
> > > $code = $res->code;
> > > $cnt = $res->count;
> > > #print "After 1st LDAP call using $myuid with
> > > results = $code\n";
> > > #die "User $myuid not found" if $code || $res->count
> > > != 1;
> > > if ( $code == 1 || $cnt == 1 )
> > > {
> > > $valid_username = 1;
> > > #print "code equal to $code and count = $cnt
> > > \n";
> > > my $entry = $res->entry(0);
> > > $res = $ldap->bind(dn => $entry->dn, password =>
> > > $mypasswd) or die;
> > > $code = $res->code;
> > > #print "LDAP return value = $code \n";
> > > #die "Login failed" if $code;
> > > if ( $code != 0 )
> > > {
> > > $pwmatch = 0;
> > > } else
> > > {
> > > $pwmatch = 1;
> > > }
> > > #$mesg = $ldap->search
> > > #print "mesg is $mesg";
> > > } else
> > > {
> > > $valid_username = 0;
> > > $pwmatch = 0;
> > > #print "invalid username ";
> > > }
> > > $ldap->unbind;
> > >
> > > Steven Joshua wrote:
> > > >
> > > > Hello:
> > > >
> > > > Hope the subject make sense. I'm new to LDAP, and
> > > > don't know how it works.
> > > > I need to use SQL Loader to load a text file into
> > > > Oracle817 Database from a unix box. The file/data
> > > > comes from LDAP server. My question is: how do I
> > > get
> > > > the file/object from LDAP site from my unix
> > > script?
> > > >
> > > > Does anyone has any examples? or know a helpful
> > > URL?
> > > >
> > > > Thanks
> > > >
> > > > From Steven
> > > >
> > > > __
> > > > Do You Yahoo!?
> > > > Yahoo! Health - your guide to health and wellness
> > > > http://health.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: Steven Joshua
> > > > 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).
> > >
> > > --
> > > Charlie Mengler
> > > Maintenance Warehouse
> > > [EMAIL PROTECTED] 10641
> > > Scripps Summit Ct.
> > > 858-831-2229 San Diego,
> > > CA 92131
> > > Am I sure? Of course I'm sure. I could be wrong, but
> > > I'm sure for now!
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Charlie Mengler
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat C
RE: Does any one know how to call LDAP from UNIX script ?
Are you kidding? Charlie goes through the trouble of sending this to you
and the list and you ask for it in a different language?
Jump in, learn something new. It's fun in here.
Lisa Koivu
Oracle Database Baby Oven
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
> -Original Message-
> From: Steven Joshua [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 6:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Does any one know how to call LDAP from UNIX script ?
>
> Thanks for the code.
> But can we do this in UNIX shell script or Java?
>
> Thanks again
>
> Steven
>
>
> --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > I hope you can read UGLY Perl code.
> >
> > HTH & YMMV!
> >
> > #!/usr/local/bin/perl
> > # File: chg-oracle-passwd.cgi
> > use Net::LDAP;
> > use Carp;
> > use DBI;
> > $ENV{"ORACLE_HOME"} =
> > "/db02/app/oracle/product/8.1.6";
> > print "Content-type: text/html\n\n";
> > print "\n\n\n\n";
> > #print "METHOD = $ENV{'REQUEST_METHOD'}\n";
> > if ($ENV{'REQUEST_METHOD'} eq 'GET') {
> >$form_info = $ENV{'QUERY_STRING'};
> > }
> > elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
> >$form_info = '';
> >$bytes = $ENV{'CONTENT_LENGTH'};
> >read (STDIN, $form_info, $bytes);
> > }
> > @pairs = split(/&/, $form_info);
> > foreach $pair (@pairs) {
> >($name, $value) = split(/=/, $pair);
> >$value =~ tr/+/ /;
> >$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",
> > hex($1))/eg;
> >if ($name eq "UNAME") {
> > $istring = $value;
> >}
> >if ($name eq "PWORD") {
> > $passwd = $value;
> >}
> >if ($name eq "DATABASE") {
> > $dbase = $value;
> >}
> > }
> > #
> > my ($ldap, $res, $code);
> > $mypasswd = $passwd;
> > $myuid= $istring;
> > $ldap = Net::LDAP->new('ldap.mwh.com:389') || die
> > "$@";
> > $mesg = $ldap->bind('cn=Directory Manager') ||
> > die("failed to bind with ",
> > $mesg->code(),"\n");
> > $res = $ldap->search
> > (
> >base => "ou=People,o=mwh.com",
> >filter => "&(uid=$myuid )
> > (!(objectclass=alias))",
> >attrs => []
> > ) || die;
> > $code = $res->code;
> > $cnt = $res->count;
> > #print "After 1st LDAP call using $myuid with
> > results = $code\n";
> > #die "User $myuid not found" if $code || $res->count
> > != 1;
> > if ( $code == 1 || $cnt == 1 )
> > {
> > $valid_username = 1;
> > #print "code equal to $code and count = $cnt
> > \n";
> > my $entry = $res->entry(0);
> > $res = $ldap->bind(dn => $entry->dn, password =>
> > $mypasswd) or die;
> > $code = $res->code;
> > #print "LDAP return value = $code \n";
> > #die "Login failed" if $code;
> > if ( $code != 0 )
> > {
> > $pwmatch = 0;
> > } else
> > {
> > $pwmatch = 1;
> > }
> > #$mesg = $ldap->search
> > #print "mesg is $mesg";
> > } else
> > {
> > $valid_username = 0;
> > $pwmatch = 0;
> > #print "invalid username ";
> > }
> > $ldap->unbind;
> >
> > Steven Joshua wrote:
> > >
> > > Hello:
> > >
> > > Hope the subject make sense. I'm new to LDAP, and
> > > don't know how it works.
> > > I need to use SQL Loader to load a text file into
> > > Oracle817 Database from a unix box. The file/data
> > > comes from LDAP server. My question is: how do I
> > get
> > > the file/object from LDAP site from my unix
> > script?
> > >
> > > Does anyone has any examples? or know a helpful
> > URL?
> > >
> > > Thanks
> > >
> > > From Steven
> > >
> > > __
> > > Do You Yahoo!?
> > > Yahoo! Health - your guide to health and wellness
> > > http://health.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Steven Joshua
> > > 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).
> >
> > --
> > Charlie Mengler
> > Maintenance Warehouse
> > [EMAIL PROTECTED] 10641
> > Scripps Summit Ct.
> > 858-831-2229 San Diego,
> > CA 92131
> > Am I sure? Of course I'm sure. I could be wrong, but
> > I'm sure for now!
> > --
> > 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-50
RE: shared pool memory issue on OPS (non-MTS)
Bryan, There have been issues with this hanging problem with OPS in some releases. I am not sure if this is the problem, but applications that heavily use the rowcache in an OPS environment can have performance problems if the shared_pool is loaded and cause sudden hangs when the row cache object is being flushed from the shared pool. This problems should have been fixed with 8171 but it appears that the fix is in 8173. Hope this helps, Scott --- "Rodrigues, Bryan" <[EMAIL PROTECTED]> wrote: > No messages in the alert log about dynamic lock > allocation, the node that is > having the issue has a small load on it right now > and the memory is still > being used up. > > Thanks > > -Original Message- > Sent: Thursday, May 02, 2002 3:29 PM > To: Multiple recipients of list ORACLE-L > > > Any messages in the alert file, like dynamic lock > allocation or resource > allocation ? > In Oracle8 locks and resources for OPS are > dynamically allocated from the > shared pool after the initial values of _LM* are > used. > You can monitor that in v$resource_limit. > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 9:03 PM > > > > Hello, > > We are working on (2) HP 9000 64 bit HP-UX 11.0 in > an OPS cluster (non > mts) > > on version 8.1.7.2.1 32 bit, we were encountering > ora-4031 errors on one > of > > the instances, so we increased the amount of > shared pool memory from 100mb > > to 200mb on both nodes in the cluster. Since the > shared pool memory was > > increased the instance on the node that had the > error is no longer > > encountering it. But now the instance on the other > node that was not > having > > any issue, is able to keep only 1% of the shared > pool memory free and has > > hung 2 times. We are working with Oracle, but > would appreciate any ideas. > We > > know that we have 'bind variable' issues, but not > enough to get us into > the > > situation that we now face. > > > > > > Thank you, > > > > Paul Sherman > > DBAElcom, Inc. > > voice - 781-501-4143 (direct #) > > fax- 781-278-8341 (secure) > > email - [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Sherman, Paul R. > > 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: Anjo Kolk > 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: Rodrigues, Bryan > 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!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott 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 li
Re: Does any one know how to call LDAP from UNIX script ?
Yes, you'd need the LDAP API libraries, check here
http://www.openldap.org/
Steven Joshua wrote:
>
> Thanks for the code.
> But can we do this in UNIX shell script or Java?
>
> Thanks again
>
> Steven
>
> --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > I hope you can read UGLY Perl code.
> >
> > HTH & YMMV!
> >
> > #!/usr/local/bin/perl
> > # File: chg-oracle-passwd.cgi
> > use Net::LDAP;
> > use Carp;
> > use DBI;
> > $ENV{"ORACLE_HOME"} =
> > "/db02/app/oracle/product/8.1.6";
> > print "Content-type: text/html\n\n";
> > print "\n\n\n\n";
> > #print "METHOD = $ENV{'REQUEST_METHOD'}\n";
> > if ($ENV{'REQUEST_METHOD'} eq 'GET') {
> >$form_info = $ENV{'QUERY_STRING'};
> > }
> > elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
> >$form_info = '';
> >$bytes = $ENV{'CONTENT_LENGTH'};
> >read (STDIN, $form_info, $bytes);
> > }
> > @pairs = split(/&/, $form_info);
> > foreach $pair (@pairs) {
> >($name, $value) = split(/=/, $pair);
> >$value =~ tr/+/ /;
> >$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",
> > hex($1))/eg;
> >if ($name eq "UNAME") {
> > $istring = $value;
> >}
> >if ($name eq "PWORD") {
> > $passwd = $value;
> >}
> >if ($name eq "DATABASE") {
> > $dbase = $value;
> >}
> > }
> > #
> > my ($ldap, $res, $code);
> > $mypasswd = $passwd;
> > $myuid= $istring;
> > $ldap = Net::LDAP->new('ldap.mwh.com:389') || die
> > "$@";
> > $mesg = $ldap->bind('cn=Directory Manager') ||
> > die("failed to bind with ",
> > $mesg->code(),"\n");
> > $res = $ldap->search
> > (
> >base => "ou=People,o=mwh.com",
> >filter => "&(uid=$myuid )
> > (!(objectclass=alias))",
> >attrs => []
> > ) || die;
> > $code = $res->code;
> > $cnt = $res->count;
> > #print "After 1st LDAP call using $myuid with
> > results = $code\n";
> > #die "User $myuid not found" if $code || $res->count
> > != 1;
> > if ( $code == 1 || $cnt == 1 )
> > {
> > $valid_username = 1;
> > #print "code equal to $code and count = $cnt
> > \n";
> > my $entry = $res->entry(0);
> > $res = $ldap->bind(dn => $entry->dn, password =>
> > $mypasswd) or die;
> > $code = $res->code;
> > #print "LDAP return value = $code \n";
> > #die "Login failed" if $code;
> > if ( $code != 0 )
> > {
> > $pwmatch = 0;
> > } else
> > {
> > $pwmatch = 1;
> > }
> > #$mesg = $ldap->search
> > #print "mesg is $mesg";
> > } else
> > {
> > $valid_username = 0;
> > $pwmatch = 0;
> > #print "invalid username ";
> > }
> > $ldap->unbind;
> >
> > Steven Joshua wrote:
> > >
> > > Hello:
> > >
> > > Hope the subject make sense. I'm new to LDAP, and
> > > don't know how it works.
> > > I need to use SQL Loader to load a text file into
> > > Oracle817 Database from a unix box. The file/data
> > > comes from LDAP server. My question is: how do I
> > get
> > > the file/object from LDAP site from my unix
> > script?
> > >
> > > Does anyone has any examples? or know a helpful
> > URL?
> > >
> > > Thanks
> > >
> > > From Steven
> > >
> > > __
> > > Do You Yahoo!?
> > > Yahoo! Health - your guide to health and wellness
> > > http://health.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Steven Joshua
> > > 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).
> >
> > --
> > Charlie Mengler
> > Maintenance Warehouse
> > [EMAIL PROTECTED] 10641
> > Scripps Summit Ct.
> > 858-831-2229 San Diego,
> > CA 92131
> > Am I sure? Of course I'm sure. I could be wrong, but
> > I'm sure for now!
> > --
> > 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 informa
Re: shared pool memory issue on OPS (non-MTS)
Check out the following two values: Resource Current MaxInitial Limit Name Utilization UtilizationAllocation Value ---- ---- lm_ress252143 256732 177599 UNLIMITED lm_locks 278106 288642 189208 UNLIMITED Notice that "Current/Max Utilization" is much higher than "Initial Allocation"? This means that (messages to alert.log or not), the DLM is overflowing its allocated space in the SGA and invading the Shared Pool. Increase your LM_RESS and LM_LOCKS parameter values... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM > Here is the results from v$resource limit on the node with the problem. > > RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION > INITIAL_AL LIMIT_VALU > -- --- --- > -- -- > processes 52 54 > 800800 > sessions52 56 > 885885 > enqueue_locks 233 242 > 11081 11081 > enqueue_resources 233 261 > 7870 7870 > _lm_procs 52 53 > 801801 > lm_ress 252143 256732 > 177599 UNLIMITED > lm_locks278106 288642 > 189208 UNLIMITED > lm_cache_ress25822 25920 > 0 UNLIMITED > dml_locks0 42 > 7250 7250 > temporary_table_locks0 2 > UNLIMITED UNLIMITED > transactions 0 9 > 973973 > > RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION > INITIAL_AL LIMIT_VALU > -- --- --- > -- -- > sort_segment_locks 0 5 > UNLIMITED UNLIMITED > max_rollback_segments9 9 > 195195 > distributed_transactions 0 0 > 5 5 > mts_max_servers 0 0 > 20 20 > parallel_max_servers 1 1 > 6 6 > > 16 rows selected. > > Please disregard previous message with the contents of v$resource table. > > > -Original Message- > Sent: Thursday, May 02, 2002 4:54 PM > To: Multiple recipients of list ORACLE-L > > > What does V$RESOURCE_LIMIT say? You can probably post that as a reply... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 2:27 PM > > > > No messages in the alert log about dynamic lock allocation, the node that > is > > having the issue has a small load on it right now and the memory is still > > being used up. > > > > Thanks > > > > -Original Message- > > Sent: Thursday, May 02, 2002 3:29 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Any messages in the alert file, like dynamic lock allocation or resource > > allocation ? > > In Oracle8 locks and resources for OPS are dynamically allocated from the > > shared pool after the initial values of _LM* are used. > > You can monitor that in v$resource_limit. > > > > Anjo. > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Thursday, May 02, 2002 9:03 PM > > > > > > > Hello, > > > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non > > mts) > > > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on > one > > of > > > the instances, so we increased the amount of shared pool memory from > 100mb > > > to 200mb on both nodes in the cluster. Since the shared pool memory was > > > increased the instance on the node that had the error is no longer > > > encountering it. But now the instance on the other node that was not > > having > > > any issue, is able to keep only 1% of the shared pool memory free and > has > > > hung 2 times. We are working with Oracle, but would appreciate any > ideas. > > We > > > know that we have 'bind variable' issues, but not enough to get us into > > the > > > situation that we now face. > > > > > > > > > Thank you, > > > > > > Paul Sherman > > > DBAElcom, Inc. > > > voice - 781-501-4143 (direct #) > > > fax- 781-278-8341 (secure) > > > email - [EMAIL PROTECTED] > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Sherman, Paul R. > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (
Re: shared pool memory issue on OPS (non-MTS)
V$RESOURCE_LIMIT not V$RESOURCE... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:37 PM > Here is the results of looking at the v$resource table for the node with the > issue. > > select * from v$resource; > > ADDR TYID1ID2 > > -- -- -- > > D4F7C2F8 TS 3 692077582 > > D4F7C340 TS 38 268439158 > > D4F7C388 RT 2 0 > > D4F7C3D0 PI 1 0 > > D4F7C418 RT 2 1 > > D4F7C460 DM 1 0 > > D4F7C4A8 MR 1 0 > > D4F7C4F0 MR 2 0 > > D4F7C538 MR 3 0 > > D4F7C580 MR 4 0 > > D4F7C5C8 MR 5 0 > > D4F7C610 MR 6 0 > > D4F7C658 MR 7 0 > > D4F7C6A0 MR 8 0 > > D4F7C6E8 MR 9 0 > > D4F7C730 MR 10 0 > > D4F7C778 MR 11 0 > > D4F7C7C0 MR 12 0 > > D4F7C808 MR 13 0 > > D4F7C850 MR 14 0 > > D4F7C898 MR 15 0 > > D4F7C8E0 MR 16 0 > > D4F7C928 MR 17 0 > > D4F7C970 MR 18 0 > > D4F7C9B8 MR 19 0 > > D4F7CA00 MR 20 0 > > D4F7CA48 MR 21 0 > > D4F7CA90 MR 22 0 > > D4F7CAD8 MR 23 0 > > D4F7CB20 MR 24 0 > > D4F7CB68 MR 25 0 > > D4F7CBB0 MR 26 0 > > D4F7CBF8 MR 27 0 > > D4F7CC40 MR 28 0 > > D4F7CC88 MR 29 0 > > D4F7CCD0 MR 30 0 > > D4F7CD18 MR 31 0 > > D4F7CD60 MR 32 0 > > D4F7CDA8 MR 33 0 > > D4F7CDF0 MR 34 0 > > D4F7CE38 MR 35 0 > > D4F7CE80 MR 36 0 > > D4F7CEC8 MR 37 0 > > D4F7CF10 MR 38 0 > > D4F7CF58 MR 39 0 > > D4F7CFA0 MR 40 0 > > D4F7CFE8 MR 41 0 > > > ADDR TYID1ID2 > > -- -- -- > > D4F7D030 MR 42 0 > > D4F7D078 MR 43 0 > > D4F7D0C0 MR 44 0 > > D4F7D108 MR 45 0 > > D4F7D150 MR 46 0 > > D4F7D198 MR 47 0 > > D4F7D1E0 MR 48 0 > > D4F7D228 MR 49 0 > > D4F7D270 MR 50 0 > > D4F7D2B8 MR 51 0 > > D4F7D300 MR 52 0 > > D4F7D348 MR 53 0 > > D4F7D390 MR 54 0 > > D4F7D3D8 MR 55 0 > > D4F7D420 MR 56 0 > > D4F7D468 MR 57 0 > > D4F7D4B0 MR 58 0 > > D4F7D4F8 MR 59 0 > > D4F7D540 MR 60 0 > > D4F7D588 MR 61 0 > > D4F7D5D0 MR 62 0 > > D4F7D618 MR 63 0 > > D4F7D660 MR 64 0 > > D4F7D6A8 MR 65 0 > > D4F7D6F0 MR 66 0 > > D4F7D738 MR 67 0 > > D4F7D780 MR 68 0 > > D4F7D7C8 MR 69 0 > > D4F7D810 MR 70 0 > > D4F7D858 MR 71 0 > > D4F7D8A0 MR 72 0 > > D4F7D8E8 MR 79 0 > > D4F7D930 MR 80 0 > > D4F7D978 MR 81 0 > > D4F7D9C0 MR 82 0 > > D4F7DA08 MR 83 0 > > D4F7DA50 MR 84 0 > > D4F7DA98 MR 85 0 > > D4F7DAE0 MR 86 0 > > D4F7DB28 MR 87 0 > > D4F7DB70 MR 88 0 > > D4F7DBB8 MR 89 0 > > D4F7DC00 MR 90 0 > > D4F7DC48 MR 91 0 > > D4F7DC90 MR 92 0 > > D4F7DCD8 MR 93 0 > > D4F7DD20 MR 94 0 > > > ADDR TYID1ID2 > > -- -- -- > > D4F7DD68 MR 95 0 > > D4F7DDB0 MR 96 0 > > D4F7DDF8 MR 97 0 > > D4F7DE40 MR 98 0 > > D4F7DE88 MR101 0 > > D4F7DED0 MR102 0 > > D4F7DF18 MR105 0 > > D4F7DF60 MR106 0 > > D4F7DFA8 MR107 0 > > D4F7DFF0 MR108 0 > > D4F7E038 MR109 0 > > D4F7E080 MR110 0 > > D4F7E0C8 MR111 0 > > D4F7E110 MR112 0 > > D4F7E158 MR113 0 > > D4F7E1A0 MR114 0 > > D4F7E1E8 MR115 0 > > D4F7E230 MR116 0 > > D4F7E278 MR117 0 > > D4F7E2C0 MR118 0 > > D4F7E308 MR119 0 > > D4F7E350 MR120 0 > > D4F7E398 MR121 0 > > D4F7E3E0 MR122
Re: Hardware requirements for large data sets
I would include PL/SQL in that mix for operations that can be easily done within the database, as it will be faster than Perl. You just have to balance the mix. Add to that a decent scheduler and who needs Informatica? Jared Joe Raube <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Hardware requirements for large data sets or processing time requirements?? I suggest Perl. ;-) -Joe --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Shouldn't there be another "goal" like "query the data"? How about > "query > the data while refresh is running"? > > If you're on UNIX, I'm guessing that "dd" and "grep" should do just > about > everything for you... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:29 PM > > > > > > 1-3 terabytes of raw data. ASCII format. Flat files. No > requirement for > > RDBMS > > > > Goal: to be able to "refresh" weekly from tapes/cds/other > sources. > > > > What kinds of software/hardware may be needed to tackle this? > > > > Gary Weber > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gary Weber > > 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 Gorman > 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!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Does any one know how to call LDAP from UNIX script ?
Thanks for the code.
But can we do this in UNIX shell script or Java?
Thanks again
Steven
--- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> I hope you can read UGLY Perl code.
>
> HTH & YMMV!
>
> #!/usr/local/bin/perl
> # File: chg-oracle-passwd.cgi
> use Net::LDAP;
> use Carp;
> use DBI;
> $ENV{"ORACLE_HOME"} =
> "/db02/app/oracle/product/8.1.6";
> print "Content-type: text/html\n\n";
> print "\n\n\n\n";
> #print "METHOD = $ENV{'REQUEST_METHOD'}\n";
> if ($ENV{'REQUEST_METHOD'} eq 'GET') {
>$form_info = $ENV{'QUERY_STRING'};
> }
> elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
>$form_info = '';
>$bytes = $ENV{'CONTENT_LENGTH'};
>read (STDIN, $form_info, $bytes);
> }
> @pairs = split(/&/, $form_info);
> foreach $pair (@pairs) {
>($name, $value) = split(/=/, $pair);
>$value =~ tr/+/ /;
>$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C",
> hex($1))/eg;
>if ($name eq "UNAME") {
> $istring = $value;
>}
>if ($name eq "PWORD") {
> $passwd = $value;
>}
>if ($name eq "DATABASE") {
> $dbase = $value;
>}
> }
> #
> my ($ldap, $res, $code);
> $mypasswd = $passwd;
> $myuid= $istring;
> $ldap = Net::LDAP->new('ldap.mwh.com:389') || die
> "$@";
> $mesg = $ldap->bind('cn=Directory Manager') ||
> die("failed to bind with ",
> $mesg->code(),"\n");
> $res = $ldap->search
> (
>base => "ou=People,o=mwh.com",
>filter => "&(uid=$myuid )
> (!(objectclass=alias))",
>attrs => []
> ) || die;
> $code = $res->code;
> $cnt = $res->count;
> #print "After 1st LDAP call using $myuid with
> results = $code\n";
> #die "User $myuid not found" if $code || $res->count
> != 1;
> if ( $code == 1 || $cnt == 1 )
> {
> $valid_username = 1;
> #print "code equal to $code and count = $cnt
> \n";
> my $entry = $res->entry(0);
> $res = $ldap->bind(dn => $entry->dn, password =>
> $mypasswd) or die;
> $code = $res->code;
> #print "LDAP return value = $code \n";
> #die "Login failed" if $code;
> if ( $code != 0 )
> {
> $pwmatch = 0;
> } else
> {
> $pwmatch = 1;
> }
> #$mesg = $ldap->search
> #print "mesg is $mesg";
> } else
> {
> $valid_username = 0;
> $pwmatch = 0;
> #print "invalid username ";
> }
> $ldap->unbind;
>
> Steven Joshua wrote:
> >
> > Hello:
> >
> > Hope the subject make sense. I'm new to LDAP, and
> > don't know how it works.
> > I need to use SQL Loader to load a text file into
> > Oracle817 Database from a unix box. The file/data
> > comes from LDAP server. My question is: how do I
> get
> > the file/object from LDAP site from my unix
> script?
> >
> > Does anyone has any examples? or know a helpful
> URL?
> >
> > Thanks
> >
> > From Steven
> >
> > __
> > Do You Yahoo!?
> > Yahoo! Health - your guide to health and wellness
> > http://health.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Steven Joshua
> > 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).
>
> --
> Charlie Mengler
> Maintenance Warehouse
> [EMAIL PROTECTED] 10641
> Scripps Summit Ct.
> 858-831-2229 San Diego,
> CA 92131
> Am I sure? Of course I'm sure. I could be wrong, but
> I'm sure for now!
> --
> 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).
__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Joshua
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
Re: shared pool memory issue on OPS (non-MTS)
Hmmm, Not v$resource but v$resource_limit .. Anjo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 11:37 PM > Here is the results of looking at the v$resource table for the node with the > issue. > > select * from v$resource; > > ADDR TYID1ID2 > > -- -- -- > > D4F7C2F8 TS 3 692077582 > > D4F7C340 TS 38 268439158 > > D4F7C388 RT 2 0 > > D4F7C3D0 PI 1 0 > > D4F7C418 RT 2 1 > > D4F7C460 DM 1 0 > > D4F7C4A8 MR 1 0 > > D4F7C4F0 MR 2 0 > > D4F7C538 MR 3 0 > > D4F7C580 MR 4 0 > > D4F7C5C8 MR 5 0 > > D4F7C610 MR 6 0 > > D4F7C658 MR 7 0 > > D4F7C6A0 MR 8 0 > > D4F7C6E8 MR 9 0 > > D4F7C730 MR 10 0 > > D4F7C778 MR 11 0 > > D4F7C7C0 MR 12 0 > > D4F7C808 MR 13 0 > > D4F7C850 MR 14 0 > > D4F7C898 MR 15 0 > > D4F7C8E0 MR 16 0 > > D4F7C928 MR 17 0 > > D4F7C970 MR 18 0 > > D4F7C9B8 MR 19 0 > > D4F7CA00 MR 20 0 > > D4F7CA48 MR 21 0 > > D4F7CA90 MR 22 0 > > D4F7CAD8 MR 23 0 > > D4F7CB20 MR 24 0 > > D4F7CB68 MR 25 0 > > D4F7CBB0 MR 26 0 > > D4F7CBF8 MR 27 0 > > D4F7CC40 MR 28 0 > > D4F7CC88 MR 29 0 > > D4F7CCD0 MR 30 0 > > D4F7CD18 MR 31 0 > > D4F7CD60 MR 32 0 > > D4F7CDA8 MR 33 0 > > D4F7CDF0 MR 34 0 > > D4F7CE38 MR 35 0 > > D4F7CE80 MR 36 0 > > D4F7CEC8 MR 37 0 > > D4F7CF10 MR 38 0 > > D4F7CF58 MR 39 0 > > D4F7CFA0 MR 40 0 > > D4F7CFE8 MR 41 0 > > > ADDR TYID1ID2 > > -- -- -- > > D4F7D030 MR 42 0 > > D4F7D078 MR 43 0 > > D4F7D0C0 MR 44 0 > > D4F7D108 MR 45 0 > > D4F7D150 MR 46 0 > > D4F7D198 MR 47 0 > > D4F7D1E0 MR 48 0 > > D4F7D228 MR 49 0 > > D4F7D270 MR 50 0 > > D4F7D2B8 MR 51 0 > > D4F7D300 MR 52 0 > > D4F7D348 MR 53 0 > > D4F7D390 MR 54 0 > > D4F7D3D8 MR 55 0 > > D4F7D420 MR 56 0 > > D4F7D468 MR 57 0 > > D4F7D4B0 MR 58 0 > > D4F7D4F8 MR 59 0 > > D4F7D540 MR 60 0 > > D4F7D588 MR 61 0 > > D4F7D5D0 MR 62 0 > > D4F7D618 MR 63 0 > > D4F7D660 MR 64 0 > > D4F7D6A8 MR 65 0 > > D4F7D6F0 MR 66 0 > > D4F7D738 MR 67 0 > > D4F7D780 MR 68 0 > > D4F7D7C8 MR 69 0 > > D4F7D810 MR 70 0 > > D4F7D858 MR 71 0 > > D4F7D8A0 MR 72 0 > > D4F7D8E8 MR 79 0 > > D4F7D930 MR 80 0 > > D4F7D978 MR 81 0 > > D4F7D9C0 MR 82 0 > > D4F7DA08 MR 83 0 > > D4F7DA50 MR 84 0 > > D4F7DA98 MR 85 0 > > D4F7DAE0 MR 86 0 > > D4F7DB28 MR 87 0 > > D4F7DB70 MR 88 0 > > D4F7DBB8 MR 89 0 > > D4F7DC00 MR 90 0 > > D4F7DC48 MR 91 0 > > D4F7DC90 MR 92 0 > > D4F7DCD8 MR 93 0 > > D4F7DD20 MR 94 0 > > > ADDR TYID1ID2 > > -- -- -- > > D4F7DD68 MR 95 0 > > D4F7DDB0 MR 96 0 > > D4F7DDF8 MR 97 0 > > D4F7DE40 MR 98 0 > > D4F7DE88 MR101 0 > > D4F7DED0 MR102 0 > > D4F7DF18 MR105 0 > > D4F7DF60 MR106 0 > > D4F7DFA8 MR107 0 > > D4F7DFF0 MR108 0 > > D4F7E038 MR109 0 > > D4F7E080 MR110 0 > > D4F7E0C8 MR111 0 > > D4F7E110 MR112 0 > > D4F7E158 MR113 0 > > D4F7E1A0 MR114 0 > > D4F7E1E8 MR115 0 > > D4F7E230 MR116 0 > > D4F7E278 MR117 0 > > D4F7E2C0 MR118 0 > > D4F7E308 MR119 0 > > D4F7E350 MR120 0 > > D4F7E398 MR121 0 > > D4F7E3
RE: shared pool memory issue on OPS (non-MTS)
Here is the results from v$resource limit on the node with the problem. RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU -- --- --- -- -- processes 52 54 800800 sessions52 56 885885 enqueue_locks 233 242 11081 11081 enqueue_resources 233 261 7870 7870 _lm_procs 52 53 801801 lm_ress 252143 256732 177599 UNLIMITED lm_locks278106 288642 189208 UNLIMITED lm_cache_ress25822 25920 0 UNLIMITED dml_locks0 42 7250 7250 temporary_table_locks0 2 UNLIMITED UNLIMITED transactions 0 9 973973 RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU -- --- --- -- -- sort_segment_locks 0 5 UNLIMITED UNLIMITED max_rollback_segments9 9 195195 distributed_transactions 0 0 5 5 mts_max_servers 0 0 20 20 parallel_max_servers 1 1 6 6 16 rows selected. Please disregard previous message with the contents of v$resource table. -Original Message- Sent: Thursday, May 02, 2002 4:54 PM To: Multiple recipients of list ORACLE-L What does V$RESOURCE_LIMIT say? You can probably post that as a reply... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 2:27 PM > No messages in the alert log about dynamic lock allocation, the node that is > having the issue has a small load on it right now and the memory is still > being used up. > > Thanks > > -Original Message- > Sent: Thursday, May 02, 2002 3:29 PM > To: Multiple recipients of list ORACLE-L > > > Any messages in the alert file, like dynamic lock allocation or resource > allocation ? > In Oracle8 locks and resources for OPS are dynamically allocated from the > shared pool after the initial values of _LM* are used. > You can monitor that in v$resource_limit. > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 9:03 PM > > > > Hello, > > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non > mts) > > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one > of > > the instances, so we increased the amount of shared pool memory from 100mb > > to 200mb on both nodes in the cluster. Since the shared pool memory was > > increased the instance on the node that had the error is no longer > > encountering it. But now the instance on the other node that was not > having > > any issue, is able to keep only 1% of the shared pool memory free and has > > hung 2 times. We are working with Oracle, but would appreciate any ideas. > We > > know that we have 'bind variable' issues, but not enough to get us into > the > > situation that we now face. > > > > > > Thank you, > > > > Paul Sherman > > DBAElcom, Inc. > > voice - 781-501-4143 (direct #) > > fax- 781-278-8341 (secure) > > email - [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sherman, Paul R. > > 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: Anjo Kolk > 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: Does any one know how to call LDAP from UNIX script ?
Interesting, Charlie! By the name of this script, I assume it's used to change your Oracle password, but it's not searching against OiD, unless you've manually added the "Directory Manager" cn. Are you using iPlanet? Are your Oracle clients authenticating against this LDAP server? Or for Oracle names resolution? Very interesting. Especially since Oracle Support now balks at every mention of a non-OiD LDAP server for Oracle lookups. And the stupid netca (Net Config Assist) is the only supported method of creating an "Oracle Context" in LDAP (in order to use OiD for Oracle names resolution). Of course it only takes a little work to create the correct LDIFs to create your own "Oracle Context" in iPlanet... :D The reason I'm asking is because OID IS A PAIN. Even v3. Documentation is horrible, replication is a bear, and OiD is not LDAP. From a co-worker who has setup iPlanet in-house, it looks like Oracle's gone off on their own to try and change the loose LDAP "standard". This gets to be a pain when you're trying to debug an LDAP problem, but since Oracle's moved the location of LDAP attributes, for example, you can't readily use widely available LDAP documentation and examples to troubleshoot. You must use Oracle Support. That's fine, but I don't want to have to log another 25 TARs to get answers to what should be simple questions. Ah...that felt good. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Charlie Mengler [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 3:54 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Does any one know how to call LDAP from UNIX script ? > > > I hope you can read UGLY Perl code. > > HTH & YMMV! > > #!/usr/local/bin/perl > # File: chg-oracle-passwd.cgi > use Net::LDAP; > use Carp; > use DBI; > > [truncated for brevity] -- 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: Create a new database
Tim, This is me again, this is all in $ORACLE_HOME/rdbms/log Thu May 2 10:15:06 2002 Shutting down instance (abort) That's it which I found as a log. Thanks for your HELP -Original Message- Sent: Thursday, May 02, 2002 1:54 PM To: Multiple recipients of list ORACLE-L ORA-03113 (and ORA-03114) are error messages issued by the client process, not generated on the server (like most "ORA-" messages). Both essentially are complaints by the client process (i.e. SQL*Plus) that there is no longer a connection to the database server process. The usual way this occurs is if the database server process has "core-dumped" or "aborted" from experiencing a "bus error", "segmentation fault", "segmentation violation", etc. Something dramatic and instantly fatal, kind of like a brain aneurism for computer processes... You should be able to find a large, cryptic ASCII-text trace file (i.e. "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. The "alert_.log" file (located in whatever directory the BACKGROUND_DUMP_DEST parameter is pointing to) should also have something logged in it. Unless the process was killed with the "KILL" or "-9" signal, Oracle executables generally try to produce a "core" file before it dies. This trace file would represent a good starting point for a search of MetaLink or for logging a TAR... If you haven't set these two "_DEST" parameters yet, then these files can probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some such... And the advice to upgrade to 8.1.7.2 still holds... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:48 PM > I don't know why you are getting the ORA-3113 > > I was merely trying to offer some advice based on limited information. > > ORA-3113 is a 'catch all' error; any number of things can cause that > error. > > Are there other errors associated with it? > > Please include the list in your replies so as not to limit responses to > one individual. > > And the advice to move to 8.1.7.2 still holds. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > 05/02/2002 11:40 AM > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > cc: > Subject:RE: Create a new database > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > But during the installation 8.1.7.0 I create a database, How come now I > can > not create another one?? > > > -Original Message- > Sent: Thursday, May 02, 2002 11:22 AM > To: [EMAIL PROTECTED] > Cc: Hamid Alavi > > > Which version exactly? > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > databases. 8.1.7.3 is available, but rife with bugs. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Create a new database > > > Hi List, > > When I try to create a new database (8.1.7) under sun solaris I got the > following error: > ORA-03113: end-of-file on communication channel > > Any Idea? Any help realy appreciated. > > This is the contenet of log file which created: > > Connected. > ORA-03113: end-of-file on communication channel > CREATE DATABASE "CMSREPT" > * > ORA-03114: not connected to ORACLE > Disconnected. > > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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). > > > > > > > > === Confidentiality Statement === > The information contained in t
RE: Create a new database
Thanks Tim, Would you please let me know where can I download the Patch2 or 3 for 8.1.7 for OSsun5.7, Appreciate Thanks -Original Message- Sent: Thursday, May 02, 2002 1:54 PM To: Multiple recipients of list ORACLE-L ORA-03113 (and ORA-03114) are error messages issued by the client process, not generated on the server (like most "ORA-" messages). Both essentially are complaints by the client process (i.e. SQL*Plus) that there is no longer a connection to the database server process. The usual way this occurs is if the database server process has "core-dumped" or "aborted" from experiencing a "bus error", "segmentation fault", "segmentation violation", etc. Something dramatic and instantly fatal, kind of like a brain aneurism for computer processes... You should be able to find a large, cryptic ASCII-text trace file (i.e. "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. The "alert_.log" file (located in whatever directory the BACKGROUND_DUMP_DEST parameter is pointing to) should also have something logged in it. Unless the process was killed with the "KILL" or "-9" signal, Oracle executables generally try to produce a "core" file before it dies. This trace file would represent a good starting point for a search of MetaLink or for logging a TAR... If you haven't set these two "_DEST" parameters yet, then these files can probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some such... And the advice to upgrade to 8.1.7.2 still holds... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:48 PM > I don't know why you are getting the ORA-3113 > > I was merely trying to offer some advice based on limited information. > > ORA-3113 is a 'catch all' error; any number of things can cause that > error. > > Are there other errors associated with it? > > Please include the list in your replies so as not to limit responses to > one individual. > > And the advice to move to 8.1.7.2 still holds. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > 05/02/2002 11:40 AM > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > cc: > Subject:RE: Create a new database > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > But during the installation 8.1.7.0 I create a database, How come now I > can > not create another one?? > > > -Original Message- > Sent: Thursday, May 02, 2002 11:22 AM > To: [EMAIL PROTECTED] > Cc: Hamid Alavi > > > Which version exactly? > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > databases. 8.1.7.3 is available, but rife with bugs. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Create a new database > > > Hi List, > > When I try to create a new database (8.1.7) under sun solaris I got the > following error: > ORA-03113: end-of-file on communication channel > > Any Idea? Any help realy appreciated. > > This is the contenet of log file which created: > > Connected. > ORA-03113: end-of-file on communication channel > CREATE DATABASE "CMSREPT" > * > ORA-03114: not connected to ORACLE > Disconnected. > > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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). > > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only f
RE: shared pool memory issue on OPS (non-MTS)
Here is the results of looking at the v$resource table for the node with the issue. select * from v$resource; ADDR TYID1ID2 -- -- -- D4F7C2F8 TS 3 692077582 D4F7C340 TS 38 268439158 D4F7C388 RT 2 0 D4F7C3D0 PI 1 0 D4F7C418 RT 2 1 D4F7C460 DM 1 0 D4F7C4A8 MR 1 0 D4F7C4F0 MR 2 0 D4F7C538 MR 3 0 D4F7C580 MR 4 0 D4F7C5C8 MR 5 0 D4F7C610 MR 6 0 D4F7C658 MR 7 0 D4F7C6A0 MR 8 0 D4F7C6E8 MR 9 0 D4F7C730 MR 10 0 D4F7C778 MR 11 0 D4F7C7C0 MR 12 0 D4F7C808 MR 13 0 D4F7C850 MR 14 0 D4F7C898 MR 15 0 D4F7C8E0 MR 16 0 D4F7C928 MR 17 0 D4F7C970 MR 18 0 D4F7C9B8 MR 19 0 D4F7CA00 MR 20 0 D4F7CA48 MR 21 0 D4F7CA90 MR 22 0 D4F7CAD8 MR 23 0 D4F7CB20 MR 24 0 D4F7CB68 MR 25 0 D4F7CBB0 MR 26 0 D4F7CBF8 MR 27 0 D4F7CC40 MR 28 0 D4F7CC88 MR 29 0 D4F7CCD0 MR 30 0 D4F7CD18 MR 31 0 D4F7CD60 MR 32 0 D4F7CDA8 MR 33 0 D4F7CDF0 MR 34 0 D4F7CE38 MR 35 0 D4F7CE80 MR 36 0 D4F7CEC8 MR 37 0 D4F7CF10 MR 38 0 D4F7CF58 MR 39 0 D4F7CFA0 MR 40 0 D4F7CFE8 MR 41 0 ADDR TYID1ID2 -- -- -- D4F7D030 MR 42 0 D4F7D078 MR 43 0 D4F7D0C0 MR 44 0 D4F7D108 MR 45 0 D4F7D150 MR 46 0 D4F7D198 MR 47 0 D4F7D1E0 MR 48 0 D4F7D228 MR 49 0 D4F7D270 MR 50 0 D4F7D2B8 MR 51 0 D4F7D300 MR 52 0 D4F7D348 MR 53 0 D4F7D390 MR 54 0 D4F7D3D8 MR 55 0 D4F7D420 MR 56 0 D4F7D468 MR 57 0 D4F7D4B0 MR 58 0 D4F7D4F8 MR 59 0 D4F7D540 MR 60 0 D4F7D588 MR 61 0 D4F7D5D0 MR 62 0 D4F7D618 MR 63 0 D4F7D660 MR 64 0 D4F7D6A8 MR 65 0 D4F7D6F0 MR 66 0 D4F7D738 MR 67 0 D4F7D780 MR 68 0 D4F7D7C8 MR 69 0 D4F7D810 MR 70 0 D4F7D858 MR 71 0 D4F7D8A0 MR 72 0 D4F7D8E8 MR 79 0 D4F7D930 MR 80 0 D4F7D978 MR 81 0 D4F7D9C0 MR 82 0 D4F7DA08 MR 83 0 D4F7DA50 MR 84 0 D4F7DA98 MR 85 0 D4F7DAE0 MR 86 0 D4F7DB28 MR 87 0 D4F7DB70 MR 88 0 D4F7DBB8 MR 89 0 D4F7DC00 MR 90 0 D4F7DC48 MR 91 0 D4F7DC90 MR 92 0 D4F7DCD8 MR 93 0 D4F7DD20 MR 94 0 ADDR TYID1ID2 -- -- -- D4F7DD68 MR 95 0 D4F7DDB0 MR 96 0 D4F7DDF8 MR 97 0 D4F7DE40 MR 98 0 D4F7DE88 MR101 0 D4F7DED0 MR102 0 D4F7DF18 MR105 0 D4F7DF60 MR106 0 D4F7DFA8 MR107 0 D4F7DFF0 MR108 0 D4F7E038 MR109 0 D4F7E080 MR110 0 D4F7E0C8 MR111 0 D4F7E110 MR112 0 D4F7E158 MR113 0 D4F7E1A0 MR114 0 D4F7E1E8 MR115 0 D4F7E230 MR116 0 D4F7E278 MR117 0 D4F7E2C0 MR118 0 D4F7E308 MR119 0 D4F7E350 MR120 0 D4F7E398 MR121 0 D4F7E3E0 MR122 0 D4F7E428 MR123 0 D4F7E470 MR124 0 D4F7E4B8 MR125 0 D4F7E500 MR126 0 D4F7E548 MR127 0 D4F7E590 MR128 0 D4F7E5D8 MR129 0 D4F7E620 MR130 0 D4F7E668 MR131 0 D4F7E6B0 MR132 0 D4F7E6F8 MR133 0 D4F7E740 MR134 0 D4F7E788 MR135 0 D4F7E7D0 MR136 0 D4F7E818 MR137 0 D4F7E860 MR
RE: Create a new database
ftp://oracle-ftp.oracle.com/server/patchsets/unix/SUN_SOLARIS2/81patchsets/3 2BIT/ -Original Message- Sent: Thursday, May 02, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Would you please let me know where can I download the Patch2 or 3 for 8.1.7 for OSsun5.7, Appreciate Thanks -Original Message- Sent: Thursday, May 02, 2002 1:54 PM To: Multiple recipients of list ORACLE-L ORA-03113 (and ORA-03114) are error messages issued by the client process, not generated on the server (like most "ORA-" messages). Both essentially are complaints by the client process (i.e. SQL*Plus) that there is no longer a connection to the database server process. The usual way this occurs is if the database server process has "core-dumped" or "aborted" from experiencing a "bus error", "segmentation fault", "segmentation violation", etc. Something dramatic and instantly fatal, kind of like a brain aneurism for computer processes... You should be able to find a large, cryptic ASCII-text trace file (i.e. "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. The "alert_.log" file (located in whatever directory the BACKGROUND_DUMP_DEST parameter is pointing to) should also have something logged in it. Unless the process was killed with the "KILL" or "-9" signal, Oracle executables generally try to produce a "core" file before it dies. This trace file would represent a good starting point for a search of MetaLink or for logging a TAR... If you haven't set these two "_DEST" parameters yet, then these files can probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some such... And the advice to upgrade to 8.1.7.2 still holds... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:48 PM > I don't know why you are getting the ORA-3113 > > I was merely trying to offer some advice based on limited information. > > ORA-3113 is a 'catch all' error; any number of things can cause that > error. > > Are there other errors associated with it? > > Please include the list in your replies so as not to limit responses to > one individual. > > And the advice to move to 8.1.7.2 still holds. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > 05/02/2002 11:40 AM > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > cc: > Subject:RE: Create a new database > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > But during the installation 8.1.7.0 I create a database, How come now I > can > not create another one?? > > > -Original Message- > Sent: Thursday, May 02, 2002 11:22 AM > To: [EMAIL PROTECTED] > Cc: Hamid Alavi > > > Which version exactly? > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > databases. 8.1.7.3 is available, but rife with bugs. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Create a new database > > > Hi List, > > When I try to create a new database (8.1.7) under sun solaris I got the > following error: > ORA-03113: end-of-file on communication channel > > Any Idea? Any help realy appreciated. > > This is the contenet of log file which created: > > Connected. > ORA-03113: end-of-file on communication channel > CREATE DATABASE "CMSREPT" > * > ORA-03114: not connected to ORACLE > Disconnected. > > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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 (li
RE: Hardware requirements for large data sets
Tim, Good description. Hence, my original statement for not needing RDBMS. I'm leaning towards calling this monstrosity a data parking of a sort. Just trying to figure out the best way to build the parking lot. Gary Weber -Original Message- Sent: Thursday, May 02, 2002 5:07 PM To: Multiple recipients of list ORACLE-L What you have is a database that only supports full table scans and only allows "cold" full database backups and "cold" full database restores. Hopefully, you're never just seeking anything less than a full file, there are no referential-integrity issues between the files, and the availability requirements allow the data to be completely quiesced (no updates at all, just reads) while those cold backups are running. Even with a week between individual cycles, adding more load/update cycles can really make a week disappear... Good luck! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 2:27 PM > > No need for query as we know it. Strictly bulk data collection/delivery. > There may be a need for some cleansing. We've had a limited exposure to > Informatica and believe it would meet our light needs in that respect. > > Gary Weber > > -Original Message- > Sent: Thursday, May 02, 2002 3:59 PM > To: Multiple recipients of list ORACLE-L > > > Shouldn't there be another "goal" like "query the data"? How about "query > the data while refresh is running"? > > If you're on UNIX, I'm guessing that "dd" and "grep" should do just about > everything for you... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:29 PM > > > > > > 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for > > RDBMS > > > > Goal: to be able to "refresh" weekly from tapes/cds/other sources. > > > > What kinds of software/hardware may be needed to tackle this? > > > > Gary Weber > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gary Weber > > 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 Gorman > 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: Gary Weber > 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 Gorman 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: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
Re: shared pool memory issue on OPS (non-MTS)
Trivial checks that you've probably gone through, but are there messages for Dynamic resource allocation Dynamic lock allocation in the alert log. Are you using partitioned views Do you see lots of waits for "DFS Lock handle" on the instance that isn't having the memory problem Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 02 May 2002 19:22 |Hello, |We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts) |on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of |the instances, so we increased the amount of shared pool memory from 100mb |to 200mb on both nodes in the cluster. Since the shared pool memory was |increased the instance on the node that had the error is no longer |encountering it. But now the instance on the other node that was not having |any issue, is able to keep only 1% of the shared pool memory free and has |hung 2 times. We are working with Oracle, but would appreciate any ideas. We |know that we have 'bind variable' issues, but not enough to get us into the |situation that we now face. | | |Thank you, | |Paul Sherman |DBAElcom, Inc. |voice - 781-501-4143 (direct #) |fax- 781-278-8341 (secure) |email - [EMAIL PROTECTED] | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Sherman, Paul R. | 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: Jonathan Lewis 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).
Inactive sessions where program = dllhost.exe
Hi All, In a particular instance there are some inactive sessions where program is dllhost.exe. It appears when user disconnects this dllhost.exe is not going away. Does anyone know why these dllhost.exe are not going away? Thanks Rick -- 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: Does any one know how to call LDAP from UNIX script ?
You need to do an LDIF export, using the LDAP export tool that came with your LDAP server -- the tools differ between servers. Or you could write your own using one of the Perl LDAP modules. -Joe --- Steven Joshua <[EMAIL PROTECTED]> wrote: > Hello: > > Hope the subject make sense. I'm new to LDAP, and > don't know how it works. > I need to use SQL Loader to load a text file into > Oracle817 Database from a unix box. The file/data > comes from LDAP server. My question is: how do I get > the file/object from LDAP site from my unix script? > > Does anyone has any examples? or know a helpful URL? > > Thanks > > From Steven > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Joshua > 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!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: shared pool memory issue on OPS (non-MTS)
What does V$RESOURCE_LIMIT say? You can probably post that as a reply... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 2:27 PM > No messages in the alert log about dynamic lock allocation, the node that is > having the issue has a small load on it right now and the memory is still > being used up. > > Thanks > > -Original Message- > Sent: Thursday, May 02, 2002 3:29 PM > To: Multiple recipients of list ORACLE-L > > > Any messages in the alert file, like dynamic lock allocation or resource > allocation ? > In Oracle8 locks and resources for OPS are dynamically allocated from the > shared pool after the initial values of _LM* are used. > You can monitor that in v$resource_limit. > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 9:03 PM > > > > Hello, > > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non > mts) > > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one > of > > the instances, so we increased the amount of shared pool memory from 100mb > > to 200mb on both nodes in the cluster. Since the shared pool memory was > > increased the instance on the node that had the error is no longer > > encountering it. But now the instance on the other node that was not > having > > any issue, is able to keep only 1% of the shared pool memory free and has > > hung 2 times. We are working with Oracle, but would appreciate any ideas. > We > > know that we have 'bind variable' issues, but not enough to get us into > the > > situation that we now face. > > > > > > Thank you, > > > > Paul Sherman > > DBAElcom, Inc. > > voice - 781-501-4143 (direct #) > > fax- 781-278-8341 (secure) > > email - [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sherman, Paul R. > > 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: Anjo Kolk > 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: Rodrigues, Bryan > 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 Gorman 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: Hardware requirements for large data sets
What you have is a database that only supports full table scans and only allows "cold" full database backups and "cold" full database restores. Hopefully, you're never just seeking anything less than a full file, there are no referential-integrity issues between the files, and the availability requirements allow the data to be completely quiesced (no updates at all, just reads) while those cold backups are running. Even with a week between individual cycles, adding more load/update cycles can really make a week disappear... Good luck! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 2:27 PM > > No need for query as we know it. Strictly bulk data collection/delivery. > There may be a need for some cleansing. We've had a limited exposure to > Informatica and believe it would meet our light needs in that respect. > > Gary Weber > > -Original Message- > Sent: Thursday, May 02, 2002 3:59 PM > To: Multiple recipients of list ORACLE-L > > > Shouldn't there be another "goal" like "query the data"? How about "query > the data while refresh is running"? > > If you're on UNIX, I'm guessing that "dd" and "grep" should do just about > everything for you... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:29 PM > > > > > > 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for > > RDBMS > > > > Goal: to be able to "refresh" weekly from tapes/cds/other sources. > > > > What kinds of software/hardware may be needed to tackle this? > > > > Gary Weber > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gary Weber > > 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 Gorman > 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: Gary Weber > 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 Gorman 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: Does any one know how to call LDAP from UNIX script ?
I hope you can read UGLY Perl code.
HTH & YMMV!
#!/usr/local/bin/perl
# File: chg-oracle-passwd.cgi
use Net::LDAP;
use Carp;
use DBI;
$ENV{"ORACLE_HOME"} = "/db02/app/oracle/product/8.1.6";
print "Content-type: text/html\n\n";
print "\n\n\n\n";
#print "METHOD = $ENV{'REQUEST_METHOD'}\n";
if ($ENV{'REQUEST_METHOD'} eq 'GET') {
$form_info = $ENV{'QUERY_STRING'};
}
elsif ($ENV{'REQUEST_METHOD'} eq 'POST') {
$form_info = '';
$bytes = $ENV{'CONTENT_LENGTH'};
read (STDIN, $form_info, $bytes);
}
@pairs = split(/&/, $form_info);
foreach $pair (@pairs) {
($name, $value) = split(/=/, $pair);
$value =~ tr/+/ /;
$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
if ($name eq "UNAME") {
$istring = $value;
}
if ($name eq "PWORD") {
$passwd = $value;
}
if ($name eq "DATABASE") {
$dbase = $value;
}
}
#
my ($ldap, $res, $code);
$mypasswd = $passwd;
$myuid= $istring;
$ldap = Net::LDAP->new('ldap.mwh.com:389') || die "$@";
$mesg = $ldap->bind('cn=Directory Manager') || die("failed to bind with ",
$mesg->code(),"\n");
$res = $ldap->search
(
base => "ou=People,o=mwh.com",
filter => "&(uid=$myuid ) (!(objectclass=alias))",
attrs => []
) || die;
$code = $res->code;
$cnt = $res->count;
#print "After 1st LDAP call using $myuid with results = $code\n";
#die "User $myuid not found" if $code || $res->count != 1;
if ( $code == 1 || $cnt == 1 )
{
$valid_username = 1;
#print "code equal to $code and count = $cnt \n";
my $entry = $res->entry(0);
$res = $ldap->bind(dn => $entry->dn, password => $mypasswd) or die;
$code = $res->code;
#print "LDAP return value = $code \n";
#die "Login failed" if $code;
if ( $code != 0 )
{
$pwmatch = 0;
} else
{
$pwmatch = 1;
}
#$mesg = $ldap->search
#print "mesg is $mesg";
} else
{
$valid_username = 0;
$pwmatch = 0;
#print "invalid username ";
}
$ldap->unbind;
Steven Joshua wrote:
>
> Hello:
>
> Hope the subject make sense. I'm new to LDAP, and
> don't know how it works.
> I need to use SQL Loader to load a text file into
> Oracle817 Database from a unix box. The file/data
> comes from LDAP server. My question is: how do I get
> the file/object from LDAP site from my unix script?
>
> Does anyone has any examples? or know a helpful URL?
>
> Thanks
>
> From Steven
>
> __
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness
> http://health.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steven Joshua
> 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).
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
--
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).
Re: ERD generation tool
Yechiel, In the instance that you refer to it could present a problem if you use the "changed" table description to build a different instance and then used the "mined" info to update the table in the new instance. This would be a case where the source and target databases are not the same and then I don't think that any form of data replication should be blindly trusted. Remember, the OS, and database have to match to work properly. It is a good point that you brought out and it should be a warning to make sure the source and target are the same. Another item that could be overlooked in this case is father time. Did you use the changed ERD to create a table and then use old archives to mine the data changes?. It goes along with the changing of a column on a table and then trying to use old data to updates it or perform a calculation on it. There could be problems. That is why we document everything we do to the data. It gives us a reference to a point in time we can restore to if we need it. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/02/02 01:23PM >>> Hello Ron I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10' What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Yechiel Adar 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: Ron Rogers 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: Create a new database
ORA-03113 (and ORA-03114) are error messages issued by the client process, not generated on the server (like most "ORA-" messages). Both essentially are complaints by the client process (i.e. SQL*Plus) that there is no longer a connection to the database server process. The usual way this occurs is if the database server process has "core-dumped" or "aborted" from experiencing a "bus error", "segmentation fault", "segmentation violation", etc. Something dramatic and instantly fatal, kind of like a brain aneurism for computer processes... You should be able to find a large, cryptic ASCII-text trace file (i.e. "*.trc") in whatever directory the parameter USER_DUMP_DEST is pointing to. The "alert_.log" file (located in whatever directory the BACKGROUND_DUMP_DEST parameter is pointing to) should also have something logged in it. Unless the process was killed with the "KILL" or "-9" signal, Oracle executables generally try to produce a "core" file before it dies. This trace file would represent a good starting point for a search of MetaLink or for logging a TAR... If you haven't set these two "_DEST" parameters yet, then these files can probably be found in "$ORACLE_HOME/rdbms/log" or "$ORACLE_HOME/dbs" or some such... And the advice to upgrade to 8.1.7.2 still holds... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:48 PM > I don't know why you are getting the ORA-3113 > > I was merely trying to offer some advice based on limited information. > > ORA-3113 is a 'catch all' error; any number of things can cause that > error. > > Are there other errors associated with it? > > Please include the list in your replies so as not to limit responses to > one individual. > > And the advice to move to 8.1.7.2 still holds. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > 05/02/2002 11:40 AM > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > cc: > Subject:RE: Create a new database > > > yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. > But during the installation 8.1.7.0 I create a database, How come now I > can > not create another one?? > > > -Original Message- > Sent: Thursday, May 02, 2002 11:22 AM > To: [EMAIL PROTECTED] > Cc: Hamid Alavi > > > Which version exactly? > > If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any > databases. 8.1.7.3 is available, but rife with bugs. > > Jared > > > > > > Hamid Alavi <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 11:28 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Create a new database > > > Hi List, > > When I try to create a new database (8.1.7) under sun solaris I got the > following error: > ORA-03113: end-of-file on communication channel > > Any Idea? Any help realy appreciated. > > This is the contenet of log file which created: > > Connected. > ORA-03113: end-of-file on communication channel > CREATE DATABASE "CMSREPT" > * > ORA-03114: not connected to ORACLE > Disconnected. > > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > = End Confidentiality Statement = > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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). > > > > > > > > === Confidentiality Statement === > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL > and exempt from disclosure under applicable law. If you have received > this message in error, yo
Does any one know how to call LDAP from UNIX script ?
Hello: Hope the subject make sense. I'm new to LDAP, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does anyone has any examples? or know a helpful URL? Thanks >From Steven __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Joshua 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: Hardware requirements for large data sets
or processing time requirements?? I suggest Perl. ;-) -Joe --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Shouldn't there be another "goal" like "query the data"? How about > "query > the data while refresh is running"? > > If you're on UNIX, I'm guessing that "dd" and "grep" should do just > about > everything for you... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 1:29 PM > > > > > > 1-3 terabytes of raw data. ASCII format. Flat files. No > requirement for > > RDBMS > > > > Goal: to be able to "refresh" weekly from tapes/cds/other > sources. > > > > What kinds of software/hardware may be needed to tackle this? > > > > Gary Weber > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gary Weber > > 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 Gorman > 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!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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).
Does any one know how to call LDAP from UNIX script ?
Hello: Hope the subject make sense. I'm new to LDAP, and don't know how it works. I need to use SQL Loader to load a text file into Oracle817 Database from a unix box. The file/data comes from LDAP server. My question is: how do I get the file/object from LDAP site from my unix script? Does anyone has any examples? or know a helpful URL? Thanks >From Steven __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Joshua 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: pl/sql is INTERPRETED?
You...must...resist.
Only...afew.more...days.
:o)
-Original Message-
Sent: Thursday, May 02, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a survey on beer. I laughed
at him and hung up.
Lisa Koivu
Oracle Database BABY OVEN
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: pl/sql is INTERPRETED?
>
> >-Have another beer
>
> Excellent advice. I think I'll do just that.
>
> Dave
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> yeah, yeah Chris, whatever.
>
> Have another beer and do some creative writing.
>
> ;-{)
>
> Jared
>
>
>
>
>
> "Grabowy, Chris" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 11:48 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: pl/sql is INTERPRETED?
>
>
> Java this...PERL thatCOBOL rules It's easy to write and
> maintain...back to writing my book...
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It ain't that tough. We're not talking about taking a programming
> class without any experience, I've done a bit of it before.
>
> Learning all the API's, etc.: that would take some time.
>
> The language? It isn't that difficult, though I would be
> hard put to write any at the moment. The job I was going
> to use Java on was at Enron, and we all know what happened
> to that.
>
> It's been a year since I took the class, and I *much* prefer
> Perl. It can run circles around Java for most stuff.
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 08:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Re: pl/sql is INTERPRETED?
>
>
> It took you a week to learn it? Then you obviously do not know it.
> Syntax is one thing design is another. I would love to know what you
> learned in that week.
>
>
> On Thu, 2 May 2002, Jared Still wrote:
>
> >
> > Hold on Lisa!
> >
> > Java is not complex. It's a very simple language
> > actually. It took me a week to learn it, though I'm
> > not using it now: I much prefer Perl.
> >
> > Getting a handle on all of the libraries and API's is
> > another story, but Java as a language is pretty simple.
> >
> > Jared
> >
> > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote:
> > > You have a point Chris, but pl/sql is nowhere near as complex as an OO
> > > language like java or C++, IMHO. I agree with Tom that pl/sql can be
> > > learned fairly easily in comparison to the many other choices out
> there.
> > > However, it takes a bit of database savvy to do it correctly. (Not
> much
> > > tho)
> > >
> > > I was amazed in my "database" class in college that the same people
> failing
> > > the simple entity-relationship modeling portion of the class that had
> aced
> > > the Op Systems and networking classes we took. I nearly failed both
> > > classes, they were so complex. I was the teacher's pet in the db
> class
> > > because I asked him questions that made him think, and he sometimes
> > > couldn't answer. (And I had to wear a skirt - night student, straight
>
>
> from
> > > work.)
> > >
> > > What's easy for who is dependent on the person's strengths.
> > >
> > > Lisa Koivu
> > > Oracle Database Monkey Mama
> > > Fairfield Resorts, Inc.
> > > 5259 Coconut Creek Parkway
> > > Ft. Lauderdale, FL, USA 33063
> > >
> > > > -Original Message-
> > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, April 30, 2002 1:14 PM
> > > > To:Multiple recipients of list ORACLE-L
> > > > Subject: RE: pl/sql is INTERPRETED?
> > > >
> > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very
> > > > short period of time, or for that matter, any other language.
> > > >
> > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference,
> and
> > > > he tore into many real-life examples of PL/SQL. Supposedly, these
> were
> > > > written
> > > > by developers that knew what they were doing.
> > > >
> > > > Granted, if a smart developer sits down and reads Feuerstein's
> Learning
> > > > PL/SQL and Best Practices books, then perhaps they will be good. But
>
>
> who
> > > > the hell has free time? There is no free time on any project or
> effort
> > > > that
> > > > I know of!! I'm struggling with trying to improve my Oracle DB
RE: Create a new database
Where can I download the Patch2 for Oracle 8.1.7.0 SunOS 5.7 I couldn't find anything like Patch2 or Patch3 Thanks for HELP -Original Message- Sent: Thursday, May 02, 2002 11:22 AM To: [EMAIL PROTECTED] Cc: Hamid Alavi Which version exactly? If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any databases. 8.1.7.3 is available, but rife with bugs. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 11:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Create a new database Hi List, When I try to create a new database (8.1.7) under sun solaris I got the following error: ORA-03113: end-of-file on communication channel Any Idea? Any help realy appreciated. This is the contenet of log file which created: Connected. ORA-03113: end-of-file on communication channel CREATE DATABASE "CMSREPT" * ORA-03114: not connected to ORACLE Disconnected. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Hardware requirements for large data sets
No need for query as we know it. Strictly bulk data collection/delivery. There may be a need for some cleansing. We've had a limited exposure to Informatica and believe it would meet our light needs in that respect. Gary Weber -Original Message- Sent: Thursday, May 02, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Shouldn't there be another "goal" like "query the data"? How about "query the data while refresh is running"? If you're on UNIX, I'm guessing that "dd" and "grep" should do just about everything for you... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:29 PM > > 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for > RDBMS > > Goal: to be able to "refresh" weekly from tapes/cds/other sources. > > What kinds of software/hardware may be needed to tackle this? > > Gary Weber > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gary Weber > 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 Gorman 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: Gary Weber 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: ERD generation tool - Active SCM
Yes, what you describe does work. However, when the person you don't trust is another DBA (Can we think of another name considering this guy is a DBA? Doom Big Ash-Hole?), it's another story. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 3:49 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: ERD generation tool - Active SCM > > Well Keith > > Our solution to the is: > > Do not grant they rights to do any DDL either in test nor in prod. > > The dab stuff does all the DDL work. > Sure it is an added chore, but after tracking down, a few times, tables > that > were dropped > inadvertently by users (their tool did it by itself) we now use the > following policy: > > Every application has two user id's: > Owner, with password known only to the DBA group. > User with rights for select, insert, update, delete ONLY. > > It works. > > Yechiel Adar > Mehish > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 7:54 PM > > > > Lisa, > > There is only so much you can control via a model, > > since it remains a process away from the DB, and > > cannot be enforced via privileges, etc. So, we are > > always in the hands of Dom Phoc (and their siblings), > > who can do "stuff" even in the production database > > with SQLPLus/TOAD/... Under this schenario, do you > > sleep well at night? > > > > So, we said lets work with our Dom Phoc's. On > > production databases, we will STRIP them off of the > > Oracle database passwords. No password, no change. > > ENFORCED! Now, I can sleep well at night. > > > > How? Not via models. Via a solution involving the > > following, and it seems to be working for us well: > > ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ > > White Paper: > > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > > > Take charge of the "Dom Phocs" in your org! > > > > Keith > > > > > > > > > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > > Date: Wed, 1 May 2002 16:06:00 -0500 > > > > > > > > > > > > Well, for one thing, if your developer, Dom Phoc, > > starts changing crap > > in > > your database (as has happened to me in the past) a > > compare to the dev > > model > > would be great because my development changes would be > > in the model, > > not in > > the test or production databases. In that specific > > case I had to TRUST > > him > > (what? trust him after what he just did?) to change > > everything back, > > or > > restore from a backup, which would have been very time > > consuming. > > > > I was one large ball of raging hormones that day and I > > took it all out > > on > > him. We don't work on the same projects anymore. > > > > Lisa Koivu > > Oracle Database Administrator > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 01, 2002 5:50 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: ERD generation tool - Active > > Comparisons > > > > > > Am I speaking to the wind > > > > > > For Compares, why would you compare the MODEL with > > the > > > DATABASE...like going from US to London via Tokyo... > > > ... and you get to pay more, like... you pay not for > > > distance, but for "time in the air"... If a tool > > takes > > > longer to do something, makes more mistakes, is > > bumpy > > > and complex... you get to pay more. > > > > > > For compares, someone tell me what beats > > > ActiveCompare: > > > http://www.iraje.com/compare-diff.htm > > > > > > http://www.iraje.com/ActiveCompare_viewlet.html > > > > > > > > > ...and I will switch my tool. > > > > > > Keith > > > > > > > > __ > > Do You Yahoo!? > > Yahoo! Health - your guide to health and wellness > > http://health.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Keith Peterson > > 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: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat Ci
RE: shared pool memory issue on OPS (non-MTS)
No messages in the alert log about dynamic lock allocation, the node that is having the issue has a small load on it right now and the memory is still being used up. Thanks -Original Message- Sent: Thursday, May 02, 2002 3:29 PM To: Multiple recipients of list ORACLE-L Any messages in the alert file, like dynamic lock allocation or resource allocation ? In Oracle8 locks and resources for OPS are dynamically allocated from the shared pool after the initial values of _LM* are used. You can monitor that in v$resource_limit. Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 9:03 PM > Hello, > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts) > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of > the instances, so we increased the amount of shared pool memory from 100mb > to 200mb on both nodes in the cluster. Since the shared pool memory was > increased the instance on the node that had the error is no longer > encountering it. But now the instance on the other node that was not having > any issue, is able to keep only 1% of the shared pool memory free and has > hung 2 times. We are working with Oracle, but would appreciate any ideas. We > know that we have 'bind variable' issues, but not enough to get us into the > situation that we now face. > > > Thank you, > > Paul Sherman > DBAElcom, Inc. > voice - 781-501-4143 (direct #) > fax- 781-278-8341 (secure) > email - [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sherman, Paul R. > 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: Anjo Kolk 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: Rodrigues, Bryan 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: pl/sql is INTERPRETED?
that was me! rude of you to hang-up on me! I was just getting to the good
questions!
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a survey on beer. I laughed
at him and hung up.
Lisa Koivu
Oracle Database BABY OVEN
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: pl/sql is INTERPRETED?
>
> >-Have another beer
>
> Excellent advice. I think I'll do just that.
>
> Dave
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> yeah, yeah Chris, whatever.
>
> Have another beer and do some creative writing.
>
> ;-{)
>
> Jared
>
>
>
>
>
> "Grabowy, Chris" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 11:48 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: pl/sql is INTERPRETED?
>
>
> Java this...PERL thatCOBOL rules It's easy to write and
> maintain...back to writing my book...
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It ain't that tough. We're not talking about taking a programming
> class without any experience, I've done a bit of it before.
>
> Learning all the API's, etc.: that would take some time.
>
> The language? It isn't that difficult, though I would be
> hard put to write any at the moment. The job I was going
> to use Java on was at Enron, and we all know what happened
> to that.
>
> It's been a year since I took the class, and I *much* prefer
> Perl. It can run circles around Java for most stuff.
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 08:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Re: pl/sql is INTERPRETED?
>
>
> It took you a week to learn it? Then you obviously do not know it.
> Syntax is one thing design is another. I would love to know what you
> learned in that week.
>
>
> On Thu, 2 May 2002, Jared Still wrote:
>
> >
> > Hold on Lisa!
> >
> > Java is not complex. It's a very simple language
> > actually. It took me a week to learn it, though I'm
> > not using it now: I much prefer Perl.
> >
> > Getting a handle on all of the libraries and API's is
> > another story, but Java as a language is pretty simple.
> >
> > Jared
> >
> > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote:
> > > You have a point Chris, but pl/sql is nowhere near as complex as an OO
> > > language like java or C++, IMHO. I agree with Tom that pl/sql can be
> > > learned fairly easily in comparison to the many other choices out
> there.
> > > However, it takes a bit of database savvy to do it correctly. (Not
> much
> > > tho)
> > >
> > > I was amazed in my "database" class in college that the same people
> failing
> > > the simple entity-relationship modeling portion of the class that had
> aced
> > > the Op Systems and networking classes we took. I nearly failed both
> > > classes, they were so complex. I was the teacher's pet in the db
> class
> > > because I asked him questions that made him think, and he sometimes
> > > couldn't answer. (And I had to wear a skirt - night student, straight
>
>
> from
> > > work.)
> > >
> > > What's easy for who is dependent on the person's strengths.
> > >
> > > Lisa Koivu
> > > Oracle Database Monkey Mama
> > > Fairfield Resorts, Inc.
> > > 5259 Coconut Creek Parkway
> > > Ft. Lauderdale, FL, USA 33063
> > >
> > > > -Original Message-
> > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, April 30, 2002 1:14 PM
> > > > To:Multiple recipients of list ORACLE-L
> > > > Subject: RE: pl/sql is INTERPRETED?
> > > >
> > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very
> > > > short period of time, or for that matter, any other language.
> > > >
> > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference,
> and
> > > > he tore into many real-life examples of PL/SQL. Supposedly, these
> were
> > > > written
> > > > by developers that knew what they were doing.
> > > >
> > > > Granted, if a smart developer sits down and reads Feuerstein's
> Learning
> > > > PL/SQL and Best Practices books, then perhaps they will be good. But
>
>
> who
> > > > the hell has free time? There is no free time on any project or
> effort
> > > > that
> > > > I know of!! I'm struggling with trying to improve my Oracle DBA
> skills,
> > > > plus some developers skills so I can speak their language when they
> blow
>
RE: pl/sql is INTERPRETED?
Ahhyes...COBOL for Dummiesthat sounds like a good name for a book -Original Message- Sent: Thursday, May 02, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I think there is a book called Java for Dummies. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Grabowy, Chris 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: pl/sql is INTERPRETED?
Yea It contain one page with the instructions: Take a clean cup. Put in one teaspoon of sugar. Add one teaspoon of JAVA. Fill the cup with boiling water up to half an inch from the rim. Use the teaspoon to mix. WAIT - let it cool some. The FDA rules that drinking boiling beverages is not good to your health. Drink. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 9:53 PM > I think there is a book called Java for Dummies. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > 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: Yechiel Adar 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: Hardware requirements for large data sets
Shouldn't there be another "goal" like "query the data"? How about "query the data while refresh is running"? If you're on UNIX, I'm guessing that "dd" and "grep" should do just about everything for you... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:29 PM > > 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for > RDBMS > > Goal: to be able to "refresh" weekly from tapes/cds/other sources. > > What kinds of software/hardware may be needed to tackle this? > > Gary Weber > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gary Weber > 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 Gorman 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: Hardware requirements for large data sets
Big hardware. ;) But seriously, that's not a question to be answered easily. A team that I was a member of spent 9 months answering that question. There's a lot more to it than just determining which piece of HW the main database resides on. But anyway, our answer for the main piece of HW was an 16 Way IBM S80 with 16 gig of RAM. Or was it 32 gig? Not sure. Big anyway. Jared "Gary Weber" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 12:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:OT: Hardware requirements for large data sets 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for RDBMS Goal: to be able to "refresh" weekly from tapes/cds/other sources. What kinds of software/hardware may be needed to tackle this? Gary Weber -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber 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: pl/sql is INTERPRETED?
Please, someone. Savor a thick and tasty Guinness for me...
I even had someone call my house wanting to do a survey on beer. I laughed
at him and hung up.
Lisa Koivu
Oracle Database BABY OVEN
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 3:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: pl/sql is INTERPRETED?
>
> >-Have another beer
>
> Excellent advice. I think I'll do just that.
>
> Dave
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> yeah, yeah Chris, whatever.
>
> Have another beer and do some creative writing.
>
> ;-{)
>
> Jared
>
>
>
>
>
> "Grabowy, Chris" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 11:48 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: pl/sql is INTERPRETED?
>
>
> Java this...PERL thatCOBOL rules It's easy to write and
> maintain...back to writing my book...
>
> -Original Message-
> Sent: Thursday, May 02, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It ain't that tough. We're not talking about taking a programming
> class without any experience, I've done a bit of it before.
>
> Learning all the API's, etc.: that would take some time.
>
> The language? It isn't that difficult, though I would be
> hard put to write any at the moment. The job I was going
> to use Java on was at Enron, and we all know what happened
> to that.
>
> It's been a year since I took the class, and I *much* prefer
> Perl. It can run circles around Java for most stuff.
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/02/2002 08:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:Re: pl/sql is INTERPRETED?
>
>
> It took you a week to learn it? Then you obviously do not know it.
> Syntax is one thing design is another. I would love to know what you
> learned in that week.
>
>
> On Thu, 2 May 2002, Jared Still wrote:
>
> >
> > Hold on Lisa!
> >
> > Java is not complex. It's a very simple language
> > actually. It took me a week to learn it, though I'm
> > not using it now: I much prefer Perl.
> >
> > Getting a handle on all of the libraries and API's is
> > another story, but Java as a language is pretty simple.
> >
> > Jared
> >
> > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote:
> > > You have a point Chris, but pl/sql is nowhere near as complex as an OO
> > > language like java or C++, IMHO. I agree with Tom that pl/sql can be
> > > learned fairly easily in comparison to the many other choices out
> there.
> > > However, it takes a bit of database savvy to do it correctly. (Not
> much
> > > tho)
> > >
> > > I was amazed in my "database" class in college that the same people
> failing
> > > the simple entity-relationship modeling portion of the class that had
> aced
> > > the Op Systems and networking classes we took. I nearly failed both
> > > classes, they were so complex. I was the teacher's pet in the db
> class
> > > because I asked him questions that made him think, and he sometimes
> > > couldn't answer. (And I had to wear a skirt - night student, straight
>
>
> from
> > > work.)
> > >
> > > What's easy for who is dependent on the person's strengths.
> > >
> > > Lisa Koivu
> > > Oracle Database Monkey Mama
> > > Fairfield Resorts, Inc.
> > > 5259 Coconut Creek Parkway
> > > Ft. Lauderdale, FL, USA 33063
> > >
> > > > -Original Message-
> > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, April 30, 2002 1:14 PM
> > > > To:Multiple recipients of list ORACLE-L
> > > > Subject: RE: pl/sql is INTERPRETED?
> > > >
> > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very
> > > > short period of time, or for that matter, any other language.
> > > >
> > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference,
> and
> > > > he tore into many real-life examples of PL/SQL. Supposedly, these
> were
> > > > written
> > > > by developers that knew what they were doing.
> > > >
> > > > Granted, if a smart developer sits down and reads Feuerstein's
> Learning
> > > > PL/SQL and Best Practices books, then perhaps they will be good. But
>
>
> who
> > > > the hell has free time? There is no free time on any project or
> effort
> > > > that
> > > > I know of!! I'm struggling with trying to improve my Oracle DBA
> skills,
> > > > plus some developers skills so I can speak their language when they
> blow
> > > > out
> > > > OPEN_CURSORS or something. My head is swimming in the stupid
> techn
RE: pl/sql is INTERPRETED?
I think there is a book called Java for Dummies. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: pl/sql is INTERPRETED?
Yes indeed. Have often wondered why Perl is'nt considered cross-platform. After all, is'nt it true to say that it probably runs on way more platforms than Java, can be programmed either straight or OOP, is fast and relatively easy to learn. Did I mention it's free. Gotta love those open source folks. --- [EMAIL PROTECTED] wrote: > It's been a year since I took the class, and I > *much* prefer > Perl. It can run circles around Java for most > stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously > do not know it. > Syntax is one thing design is another. I would love > to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though > I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's > is > > another story, but Java as a language is pretty > simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere > near as complex as an OO > > > language like java or C++, IMHO. I agree with > Tom that pl/sql can be > > > learned fairly easily in comparison to the many > other choices out > there. > > > However, it takes a bit of database savvy to do > it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college > that the same people > failing > > > the simple entity-relationship modeling portion > of the class that had > aced > > > the Op Systems and networking classes we took. > I nearly failed both > > > classes, they were so complex. I was the > teacher's pet in the db > class > > > because I asked him questions that made him > think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - > night student, straight > from > > > work.) > > > > > > What's easy for who is dependent on the person's > strengths. > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > > From: Grabowy, Chris > [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 30, 2002 > 1:14 PM > > > > To:Multiple recipients of list > ORACLE-L > > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > > > IMHO, I don't believe that you can "properly" > learn PL/SQL in a very > > > > short period of time, or for that matter, any > other language. > > > > > > > > I attended Steve Feuerstein's presentation at > MAOP-AOTC conference, > and > > > > he tore into many real-life examples of > PL/SQL. Supposedly, these > were > > > > written > > > > by developers that knew what they were doing. > > > > > > > > Granted, if a smart developer sits down and > reads Feuerstein's > Learning > > > > PL/SQL and Best Practices books, then perhaps > they will be good. But > who > > > > the hell has free time? There is no free time > on any project or > effort > > > > that > > > > I know of!! I'm struggling with trying to > improve my Oracle DBA > skills, > > > > plus some developers skills so I can speak > their language when they > blow > > > > out > > > > OPEN_CURSORS or something. My head is > swimming in the stupid > technical > > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, > SOAP, ASP, ADO, EJB, > BC4J, > > > > JDBC, > > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, > IIOP...and don't ask me > what > > > > all > > > > those mean, because I can't keep them > straight. But I do keep > hearing > > > > that > > > > XML is going to put me out of a job, so I > guess I should learn > > > > that...whatever that is. Isn't XML an add-on, > or extension, or > something > > > > to > > > > DML??? > > > > > > > > Now where the heck did I hide that bottle... > > > > > > > > -Original Message- > > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Lisa, > > > > > > > > You are right about the debate between PL/SQL > & Java (or anything > else > > > > outside of the db). > > > > > > > > In my mind, the deciding factor (and something > that is *never* > mentioned) > > > > is > > > > what programming langauage the organization is > satisfied > with/settled > > > > upon. > > > > > > > > In my little opinion, *any* programmer can > learn PL/SQL in a very > short > > > > period of time. This means that development > and maintenance costs > are > > > > relatively low. If an IT shop is stronger in > Java, then they should > > > > probably program in
RE: Create a new database
I don't know why you are getting the ORA-3113 I was merely trying to offer some advice based on limited information. ORA-3113 is a 'catch all' error; any number of things can cause that error. Are there other errors associated with it? Please include the list in your replies so as not to limit responses to one individual. And the advice to move to 8.1.7.2 still holds. Jared Hamid Alavi <[EMAIL PROTECTED]> 05/02/2002 11:40 AM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: Subject:RE: Create a new database yes I am 0n 8.1.7.0, so you mean 8.1.7.0 can not create a new database. But during the installation 8.1.7.0 I create a database, How come now I can not create another one?? -Original Message- Sent: Thursday, May 02, 2002 11:22 AM To: [EMAIL PROTECTED] Cc: Hamid Alavi Which version exactly? If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any databases. 8.1.7.3 is available, but rife with bugs. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 11:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Create a new database Hi List, When I try to create a new database (8.1.7) under sun solaris I got the following error: ORA-03113: end-of-file on communication channel Any Idea? Any help realy appreciated. This is the contenet of log file which created: Connected. ORA-03113: end-of-file on communication channel CREATE DATABASE "CMSREPT" * ORA-03114: not connected to ORACLE Disconnected. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- 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: ERD generation tool - Active SCM
Well Keith Our solution to the is: Do not grant they rights to do any DDL either in test nor in prod. The dab stuff does all the DDL work. Sure it is an added chore, but after tracking down, a few times, tables that were dropped inadvertently by users (their tool did it by itself) we now use the following policy: Every application has two user id's: Owner, with password known only to the DBA group. User with rights for select, insert, update, delete ONLY. It works. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 7:54 PM > Lisa, > There is only so much you can control via a model, > since it remains a process away from the DB, and > cannot be enforced via privileges, etc. So, we are > always in the hands of Dom Phoc (and their siblings), > who can do "stuff" even in the production database > with SQLPLus/TOAD/... Under this schenario, do you > sleep well at night? > > So, we said lets work with our Dom Phoc's. On > production databases, we will STRIP them off of the > Oracle database passwords. No password, no change. > ENFORCED! Now, I can sleep well at night. > > How? Not via models. Via a solution involving the > following, and it seems to be working for us well: > ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ > White Paper: > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > Take charge of the "Dom Phocs" in your org! > > Keith > > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 16:06:00 -0500 > > > > > > Well, for one thing, if your developer, Dom Phoc, > starts changing crap > in > your database (as has happened to me in the past) a > compare to the dev > model > would be great because my development changes would be > in the model, > not in > the test or production databases. In that specific > case I had to TRUST > him > (what? trust him after what he just did?) to change > everything back, > or > restore from a backup, which would have been very time > consuming. > > I was one large ball of raging hormones that day and I > took it all out > on > him. We don't work on the same projects anymore. > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > -Original Message- > > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, May 01, 2002 5:50 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: ERD generation tool - Active > Comparisons > > > > Am I speaking to the wind > > > > For Compares, why would you compare the MODEL with > the > > DATABASE...like going from US to London via Tokyo... > > ... and you get to pay more, like... you pay not for > > distance, but for "time in the air"... If a tool > takes > > longer to do something, makes more mistakes, is > bumpy > > and complex... you get to pay more. > > > > For compares, someone tell me what beats > > ActiveCompare: > > http://www.iraje.com/compare-diff.htm > > > > http://www.iraje.com/ActiveCompare_viewlet.html > > > > > > ...and I will switch my tool. > > > > Keith > > > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Peterson > 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: Yechiel Adar 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: pl/sql is INTERPRETED?
>-Have another beer
Excellent advice. I think I'll do just that.
Dave
-Original Message-
Sent: Thursday, May 02, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
yeah, yeah Chris, whatever.
Have another beer and do some creative writing.
;-{)
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/02/2002 11:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: pl/sql is INTERPRETED?
Java this...PERL thatCOBOL rules It's easy to write and
maintain...back to writing my book...
-Original Message-
Sent: Thursday, May 02, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
It ain't that tough. We're not talking about taking a programming
class without any experience, I've done a bit of it before.
Learning all the API's, etc.: that would take some time.
The language? It isn't that difficult, though I would be
hard put to write any at the moment. The job I was going
to use Java on was at Enron, and we all know what happened
to that.
It's been a year since I took the class, and I *much* prefer
Perl. It can run circles around Java for most stuff.
Jared
Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/02/2002 08:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:Re: pl/sql is INTERPRETED?
It took you a week to learn it? Then you obviously do not know it.
Syntax is one thing design is another. I would love to know what you
learned in that week.
On Thu, 2 May 2002, Jared Still wrote:
>
> Hold on Lisa!
>
> Java is not complex. It's a very simple language
> actually. It took me a week to learn it, though I'm
> not using it now: I much prefer Perl.
>
> Getting a handle on all of the libraries and API's is
> another story, but Java as a language is pretty simple.
>
> Jared
>
> On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote:
> > You have a point Chris, but pl/sql is nowhere near as complex as an OO
> > language like java or C++, IMHO. I agree with Tom that pl/sql can be
> > learned fairly easily in comparison to the many other choices out
there.
> > However, it takes a bit of database savvy to do it correctly. (Not
much
> > tho)
> >
> > I was amazed in my "database" class in college that the same people
failing
> > the simple entity-relationship modeling portion of the class that had
aced
> > the Op Systems and networking classes we took. I nearly failed both
> > classes, they were so complex. I was the teacher's pet in the db
class
> > because I asked him questions that made him think, and he sometimes
> > couldn't answer. (And I had to wear a skirt - night student, straight
from
> > work.)
> >
> > What's easy for who is dependent on the person's strengths.
> >
> > Lisa Koivu
> > Oracle Database Monkey Mama
> > Fairfield Resorts, Inc.
> > 5259 Coconut Creek Parkway
> > Ft. Lauderdale, FL, USA 33063
> >
> > > -Original Message-
> > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
> > > Sent: Tuesday, April 30, 2002 1:14 PM
> > > To:Multiple recipients of list ORACLE-L
> > > Subject: RE: pl/sql is INTERPRETED?
> > >
> > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very
> > > short period of time, or for that matter, any other language.
> > >
> > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference,
and
> > > he tore into many real-life examples of PL/SQL. Supposedly, these
were
> > > written
> > > by developers that knew what they were doing.
> > >
> > > Granted, if a smart developer sits down and reads Feuerstein's
Learning
> > > PL/SQL and Best Practices books, then perhaps they will be good. But
who
> > > the hell has free time? There is no free time on any project or
effort
> > > that
> > > I know of!! I'm struggling with trying to improve my Oracle DBA
skills,
> > > plus some developers skills so I can speak their language when they
blow
> > > out
> > > OPEN_CURSORS or something. My head is swimming in the stupid
technical
> > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB,
BC4J,
> > > JDBC,
> > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me
what
> > > all
> > > those mean, because I can't keep them straight. But I do keep
hearing
> > > that
> > > XML is going to put me out of a job, so I guess I should learn
> > > that...whatever that is. Isn't XML an add-on, or extension, or
something
> > > to
> > > DML???
> > >
> > > Now where the heck did I hide that bottle...
> > >
> > > -Original Message-
> > > Sent: Tuesday, April 30, 2002 12:15 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Lisa,
> > >
> > > You are right about the debate between PL/SQL & Java (or anything
else
> > > outside of the db).
> > >
> > > In my mind, the decidi
Re: shared pool memory issue on OPS (non-MTS)
Any messages in the alert file, like dynamic lock allocation or resource allocation ? In Oracle8 locks and resources for OPS are dynamically allocated from the shared pool after the initial values of _LM* are used. You can monitor that in v$resource_limit. Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 9:03 PM > Hello, > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts) > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of > the instances, so we increased the amount of shared pool memory from 100mb > to 200mb on both nodes in the cluster. Since the shared pool memory was > increased the instance on the node that had the error is no longer > encountering it. But now the instance on the other node that was not having > any issue, is able to keep only 1% of the shared pool memory free and has > hung 2 times. We are working with Oracle, but would appreciate any ideas. We > know that we have 'bind variable' issues, but not enough to get us into the > situation that we now face. > > > Thank you, > > Paul Sherman > DBAElcom, Inc. > voice - 781-501-4143 (direct #) > fax- 781-278-8341 (secure) > email - [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sherman, Paul R. > 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: Anjo Kolk 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: pl/sql is INTERPRETED?
You must be pretty smart then. I wonder why rates for java are not $6/hr seeing that it only takes a week to learn. You could probably say any language is easy to learn; it is just ifs, elses, and loops. On Thu, 2 May 2002 [EMAIL PROTECTED] wrote: > It ain't that tough. We're not talking about taking a programming > class without any experience, I've done a bit of it before. > > Learning all the API's, etc.: that would take some time. > > The language? It isn't that difficult, though I would be > hard put to write any at the moment. The job I was going > to use Java on was at Enron, and we all know what happened > to that. > > It's been a year since I took the class, and I *much* prefer > Perl. It can run circles around Java for most stuff. > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/02/2002 08:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Re: pl/sql is INTERPRETED? > > > It took you a week to learn it? Then you obviously do not know it. > Syntax is one thing design is another. I would love to know what you > learned in that week. > > > On Thu, 2 May 2002, Jared Still wrote: > > > > > Hold on Lisa! > > > > Java is not complex. It's a very simple language > > actually. It took me a week to learn it, though I'm > > not using it now: I much prefer Perl. > > > > Getting a handle on all of the libraries and API's is > > another story, but Java as a language is pretty simple. > > > > Jared > > > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > > learned fairly easily in comparison to the many other choices out > there. > > > However, it takes a bit of database savvy to do it correctly. (Not > much > > > tho) > > > > > > I was amazed in my "database" class in college that the same people > failing > > > the simple entity-relationship modeling portion of the class that had > aced > > > the Op Systems and networking classes we took. I nearly failed both > > > classes, they were so complex. I was the teacher's pet in the db > class > > > because I asked him questions that made him think, and he sometimes > > > couldn't answer. (And I had to wear a skirt - night student, straight > from > > > work.) > > > > > > What's easy for who is dependent on the person's strengths. > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lauderdale, FL, USA 33063 > > > > > > > -Original Message- > > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > > To:Multiple recipients of list ORACLE-L > > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > > short period of time, or for that matter, any other language. > > > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, > and > > > > he tore into many real-life examples of PL/SQL. Supposedly, these > were > > > > written > > > > by developers that knew what they were doing. > > > > > > > > Granted, if a smart developer sits down and reads Feuerstein's > Learning > > > > PL/SQL and Best Practices books, then perhaps they will be good. But > who > > > > the hell has free time? There is no free time on any project or > effort > > > > that > > > > I know of!! I'm struggling with trying to improve my Oracle DBA > skills, > > > > plus some developers skills so I can speak their language when they > blow > > > > out > > > > OPEN_CURSORS or something. My head is swimming in the stupid > technical > > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, > BC4J, > > > > JDBC, > > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me > what > > > > all > > > > those mean, because I can't keep them straight. But I do keep > hearing > > > > that > > > > XML is going to put me out of a job, so I guess I should learn > > > > that...whatever that is. Isn't XML an add-on, or extension, or > something > > > > to > > > > DML??? > > > > > > > > Now where the heck did I hide that bottle... > > > > > > > > -Original Message- > > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Lisa, > > > > > > > > You are right about the debate between PL/SQL & Java (or anything > else > > > > outside of the db). > > > > > > > > In my mind, the deciding factor (and something that is *never* > mentioned) > > > > is > > > > what programming langauage the organization is satisfied > with/settled > > > > upon. > > > > > > > > In my little opinion, *any* programmer c
RE: ERD generation tool
You don't say. -Original Message- Sent: Thursday, May 02, 2002 2:38 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Grabowy, Chris 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: Create a new database
Which version exactly? If on version 8.1.7.0, you should upgrade to 8.1.7.2 before creating any databases. 8.1.7.3 is available, but rife with bugs. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 11:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Create a new database Hi List, When I try to create a new database (8.1.7) under sun solaris I got the following error: ORA-03113: end-of-file on communication channel Any Idea? Any help realy appreciated. This is the contenet of log file which created: Connected. ORA-03113: end-of-file on communication channel CREATE DATABASE "CMSREPT" * ORA-03114: not connected to ORACLE Disconnected. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: ERD generation tool
Ron wrote: > Did you use the changed ERD to create a table and then use old archives to > mine the data changes? NO. I did not started to work with log miner yet. I just saw the article that Joe published and thought about this point. I have enough experience to know that you can not teach old data new tricks (or new structure). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 8:48 PM Yechiel, In the instance that you refer to it could present a problem if you use the "changed" table description to build a different instance and then used the "mined" info to update the table in the new instance. This would be a case where the source and target databases are not the same and then I don't think that any form of data replication should be blindly trusted. Remember, the OS, and database have to match to work properly. It is a good point that you brought out and it should be a warning to make sure the source and target are the same. Another item that could be overlooked in this case is father time. Did you use the changed ERD to create a table and then use old archives to mine the data changes?. It goes along with the changing of a column on a table and then trying to use old data to updates it or perform a calculation on it. There could be problems. That is why we document everything we do to the data. It gives us a reference to a point in time we can restore to if we need it. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/02/02 01:23PM >>> Hello Ron I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10' What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Yechiel Adar 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: Ron Rogers 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: Yechiel Adar 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 P
e: shared pool memory issue on OPS (non-MTS)
Hello, We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts) on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of the instances, so we increased the amount of shared pool memory from 100mb to 200mb on both nodes in the cluster. Since the shared pool memory was increased the instance on the node that had the error is no longer encountering it. But now the instance on the other node that was not having any issue, is able to keep only 1% of the shared pool memory free and has hung 2 times. We are working with Oracle, but would appreciate any ideas. We know that we have 'bind variable' issues, but not enough to get us into the situation that we now face. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: pl/sql is INTERPRETED?
Hope it's not the program that triggered the whole Enron thing :) Regards, Waleed -Original Message- Sent: Thursday, May 02, 2002 2:14 PM To: Multiple recipients of list ORACLE-L It ain't that tough. We're not talking about taking a programming class without any experience, I've done a bit of it before. Learning all the API's, etc.: that would take some time. The language? It isn't that difficult, though I would be hard put to write any at the moment. The job I was going to use Java on was at Enron, and we all know what happened to that. It's been a year since I took the class, and I *much* prefer Perl. It can run circles around Java for most stuff. Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. On Thu, 2 May 2002, Jared Still wrote: > > Hold on Lisa! > > Java is not complex. It's a very simple language > actually. It took me a week to learn it, though I'm > not using it now: I much prefer Perl. > > Getting a handle on all of the libraries and API's is > another story, but Java as a language is pretty simple. > > Jared > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > learned fairly easily in comparison to the many other choices out there. > > However, it takes a bit of database savvy to do it correctly. (Not much > > tho) > > > > I was amazed in my "database" class in college that the same people failing > > the simple entity-relationship modeling portion of the class that had aced > > the Op Systems and networking classes we took. I nearly failed both > > classes, they were so complex. I was the teacher's pet in the db class > > because I asked him questions that made him think, and he sometimes > > couldn't answer. (And I had to wear a skirt - night student, straight from > > work.) > > > > What's easy for who is dependent on the person's strengths. > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > To:Multiple recipients of list ORACLE-L > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > short period of time, or for that matter, any other language. > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > > written > > > by developers that knew what they were doing. > > > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > > the hell has free time? There is no free time on any project or effort > > > that > > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > > plus some developers skills so I can speak their language when they blow > > > out > > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > > JDBC, > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > > all > > > those mean, because I can't keep them straight. But I do keep hearing > > > that > > > XML is going to put me out of a job, so I guess I should learn > > > that...whatever that is. Isn't XML an add-on, or extension, or something > > > to > > > DML??? > > > > > > Now where the heck did I hide that bottle... > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Lisa, > > > > > > You are right about the debate between PL/SQL & Java (or anything else > > > outside of the db). > > > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > > is > > > what programming langauage the organization is satisfied with/settled > > > upon. > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > > period of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring back APL!). > > > > > > IT tool selection
Re: ERD generation tool
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: ERD generation tool - Active SCM
Thanks Keith, I'll check it out. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 1:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool - Active SCM > > Lisa, > There is only so much you can control via a model, > since it remains a process away from the DB, and > cannot be enforced via privileges, etc. So, we are > always in the hands of Dom Phoc (and their siblings), > who can do "stuff" even in the production database > with SQLPLus/TOAD/... Under this schenario, do you > sleep well at night? > > So, we said lets work with our Dom Phoc's. On > production databases, we will STRIP them off of the > Oracle database passwords. No password, no change. > ENFORCED! Now, I can sleep well at night. > > How? Not via models. Via a solution involving the > following, and it seems to be working for us well: > ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ > White Paper: > http://www.iraje.com/docs/ActiveSecureDesigner.htm > > Take charge of the "Dom Phocs" in your org! > > Keith > > > > > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Wed, 1 May 2002 16:06:00 -0500 > > > > > > Well, for one thing, if your developer, Dom Phoc, > starts changing crap > in > your database (as has happened to me in the past) a > compare to the dev > model > would be great because my development changes would be > in the model, > not in > the test or production databases. In that specific > case I had to TRUST > him > (what? trust him after what he just did?) to change > everything back, > or > restore from a backup, which would have been very time > consuming. > > I was one large ball of raging hormones that day and I > took it all out > on > him. We don't work on the same projects anymore. > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > > -Original Message- > > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, May 01, 2002 5:50 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: ERD generation tool - Active > Comparisons > > > > Am I speaking to the wind > > > > For Compares, why would you compare the MODEL with > the > > DATABASE...like going from US to London via Tokyo... > > ... and you get to pay more, like... you pay not for > > distance, but for "time in the air"... If a tool > takes > > longer to do something, makes more mistakes, is > bumpy > > and complex... you get to pay more. > > > > For compares, someone tell me what beats > > ActiveCompare: > > http://www.iraje.com/compare-diff.htm > > > > http://www.iraje.com/ActiveCompare_viewlet.html > > > > > > ...and I will switch my tool. > > > > Keith > > > > __ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Keith Peterson > 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: Koivu, Lisa 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: Partitoned Table Insert Performance
Two years ago when partitioning came out we ran some tests. We found out that oracle had some coding problems if you were using 8.0.5. Everything ran okay, but it was slow. The problems was with how the determined which partition to put data into. If you had 200 partition and data was being loaded into the the last partition, it had to do 200 compares and then insert. They have fixed it and now the use a hash algorythem to determine which partition to insert data into. It is really fast. However you will find your biggest pay backs will be in doing selects. Did you know that partitioning takes advantage of pararrel processing, so your selects can be hitting several partitions at the same time. This really speeds everything up. You will not want to partition every table. Only those table that fit the partitioning model. Also the way that you partition data can make or break your application. You need to really think out how you are going to partition a table. It really makes a big difference in performance. Try different options and do some testing. Ask this question, "how are my users going to access the data?" This is the starting question. Also you can also see how partitioning is going to effect backups and system/database management. How many disks are you going to put data on. Which drives are used. Where are my indexes and data? All good question. So it's not just a partitioning question. >From: "Toepke, Kevin M" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Partitoned Table Insert Performance >Date: Thu, 02 May 2002 09:48:31 -0800 > >Way back in the days of Oracle 8.0.5 I did some performance testing of bulk >inserts/sqlldr of range partitioned tables v.s. non-partitioned tables. I >don't have the benchmarks on hand, but here's what I found. All tests were >done using the direct path inserts (sqlldr direct=true or /*+ APPEND */) > >If the table had no indexes, then there was no noticable difference when >inserting approx 8 million rows. > >If the partitioned table had only local indexes, then the inserts into the >tables were slightly faster. The difference was in seconds for my 8million >row test. > >If the partitioned table had global partitioned indexes, then the inserts >were generally slower. Again, the diference was in seconds. > >If the partitioned table had a global non-partitioned index there was no >noticable diffence in time. > >In sort, range partitioning a table does not effect performance. The >indexing of the range-partitioned table does. > >HTH >Caver > >-Original Message- >Sent: Thursday, May 02, 2002 12:45 PM >To: Multiple recipients of list ORACLE-L > > >I am in the process of implementing partitioning on some existing tables. I >have been asked by management to evaluate the performance impacts of the >changes. I am aware of many of the performance advantages of partitioning: >partition pruning, partition-wise joins and parallel data loads. What I am >concerned about is the additional overhead of inserting data into a >partitioned table. What sort of overhead is associated with partitioned >table inserts? Does determining the correct partition slow insertions? We >are utilizing only range partitions, so hash value computations should not >be a factor. Our application is very insertion intensive. One of the >operations that performs insertions does so synchronously, so any decrease >in insertion performance would be quite visible. Do you have any thoughts >or >experiences with this issue. Any performance tests on two similar tables, >one partitioned and the other not? Any input would be appreciated. Thanks. >Erik > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Toepke, Kevin M > 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: basher 59 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
RE: pl/sql is INTERPRETED?
Java this...PERL thatCOBOL rules It's easy to write and maintain...back to writing my book... -Original Message- Sent: Thursday, May 02, 2002 2:14 PM To: Multiple recipients of list ORACLE-L It ain't that tough. We're not talking about taking a programming class without any experience, I've done a bit of it before. Learning all the API's, etc.: that would take some time. The language? It isn't that difficult, though I would be hard put to write any at the moment. The job I was going to use Java on was at Enron, and we all know what happened to that. It's been a year since I took the class, and I *much* prefer Perl. It can run circles around Java for most stuff. Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. On Thu, 2 May 2002, Jared Still wrote: > > Hold on Lisa! > > Java is not complex. It's a very simple language > actually. It took me a week to learn it, though I'm > not using it now: I much prefer Perl. > > Getting a handle on all of the libraries and API's is > another story, but Java as a language is pretty simple. > > Jared > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > learned fairly easily in comparison to the many other choices out there. > > However, it takes a bit of database savvy to do it correctly. (Not much > > tho) > > > > I was amazed in my "database" class in college that the same people failing > > the simple entity-relationship modeling portion of the class that had aced > > the Op Systems and networking classes we took. I nearly failed both > > classes, they were so complex. I was the teacher's pet in the db class > > because I asked him questions that made him think, and he sometimes > > couldn't answer. (And I had to wear a skirt - night student, straight from > > work.) > > > > What's easy for who is dependent on the person's strengths. > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > To:Multiple recipients of list ORACLE-L > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > short period of time, or for that matter, any other language. > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > > written > > > by developers that knew what they were doing. > > > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > > the hell has free time? There is no free time on any project or effort > > > that > > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > > plus some developers skills so I can speak their language when they blow > > > out > > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > > JDBC, > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > > all > > > those mean, because I can't keep them straight. But I do keep hearing > > > that > > > XML is going to put me out of a job, so I guess I should learn > > > that...whatever that is. Isn't XML an add-on, or extension, or something > > > to > > > DML??? > > > > > > Now where the heck did I hide that bottle... > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Lisa, > > > > > > You are right about the debate between PL/SQL & Java (or anything else > > > outside of the db). > > > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > > is > > > what programming langauage the organization is satisfied with/settled > > > upon. > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > > period of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring back APL!). > > > > > >
Re: OTN service
On Thu, May 02, 2002 at 09:18:31AM -0800, Yechiel Adar wrote: > Hello Ray > > I think that the intent is for you to burn the gz file and expand it on the > target system. > I installed today upgrade 9.0.1.3 for NT that came in the same way. > > Yechiel Adar > Mehish Other Oracle distributions I have downloaded from otn provide multiple disk images of the "correct" size. During the install you are prompted to change cds. This is much better from the user perspective. During an emergency situation requiring a re-install are you going to want to spend the time creating the staging area? What you propose is the only solution I can think of, I'm just grumpy about it. > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 4:53 PM > > > > > > I mentioned that the 32 bit solaris gz file for 8.1.7 > > that I downloaded from otn provided one disk image on the order > > of 900MB. What technology do I need to move to in order > > to burn this onto plastic? Are we talking dvd burner here? > > > > I asked oracle what the intent was with this, the answer is > > a classic: > > > > The OTN Service Network is specifically designed for customers who need > > support on software downloaded via OTN. The OTN Service Network offers > > pay-per-incident support provided by Oracle certified professionals. > > Support is available on Oracle Database Server, Oracle9I Application > > Server and Oracle Tools products. Pricing is $50, $75 or $100 based on > > the complexity of the issue. > > > > By intent, I ment what technology was targeted. Anybody know? > > === > > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ray Stell > > 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: Yechiel Adar > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
BFILE
Hi ,
i have a procedure to open the BFILE
data.
CREATE OR REPLACE procedure openmyfile as
lob_loc bfile;
filesize number;
lob_loc bfile:=bfilename('IMG','a.jpg');
begin
--select f_lob into lob_loc from lob_table where key_value=21;
dbms_lob.fileopen(lob_loc,dbms_lob.file_readonly);
dbms_lob.fileclose(lob_loc);
filesize:=dbms_lob.getlength(lob_loc);
dbms_output.put_line(filesize);
end;
procedure compiles w/o errors and when i execute the procedure it does w/o
any errors but it doesn't open the file.
i have the procedure on the sun server and also the jpg file.i am trying to
execute the procedure from oracle
client but it doens't open the file but just just o/ps the filesize.what is
that i need to do to make the file open on
the client m/c.i understand that the file "a.jpg" should open.Am I missing
anything?
ravi
Create a new database
Hi List, When I try to create a new database (8.1.7) under sun solaris I got the following error: ORA-03113: end-of-file on communication channel Any Idea? Any help realy appreciated. This is the contenet of log file which created: Connected. ORA-03113: end-of-file on communication channel CREATE DATABASE "CMSREPT" * ORA-03114: not connected to ORACLE Disconnected. Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: pl/sql is INTERPRETED?
Ah, didn't make the connection. crontab -e: now that's just nuts. ;) Jared "Steve McClure" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: pl/sql is INTERPRETED? >It took you a week to learn it? Then you obviously do not know it. >Syntax is one thing design is another. I would love to know what you >learned in that week. >> Getting a handle on all of the libraries and API's is >> another story, but Java as a language is pretty simple. >> >> Jared Well Jared, He certainly referenced your message, but I am not sure if he actually read it first. You two actually seem to be in agreement. Java language/syntax is pretty straight forward, using it/libraries, API's, etc are another story. I think he is still just stinging from that crontab -e thread. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: ERD generation tool
Yes, I always have that box checked. I still get an mixed order columns when I gen the DDL. Yes, 4.0 sucks. One of the projects here actually purchased 4.0, but then had to fall back to 3.5.2, because of the bugs. Let's all thank CA for taking another fine product and destroying it. -Original Message- Sent: Thursday, May 02, 2002 12:45 PM To: Multiple recipients of list ORACLE-L As I remember (since I'm no longer using ERWin since CA's takeover) there is a "Physical Order" box somewhere than needs to be clicked. If you do this, ERWin will use the actual physical order of the table, otherwise it will put them in another order (I think that it's primary key, foreign keys, and then alphabetical). The latest version of ERWin just isn't bug free enough for me to use as a primary tool --- so I'm using nothing. If I can't trust a tool then I can't use it. "Grabowy, Chris" To: Multiple recipients of list ORACLE-L @fcg.com>cc: Sent by: rootSubject: RE: ERD generation tool 05/01/2002 06:56 PM Please respond to ORACLE-L No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... -Original Message- Sent: Wednesday, May 01, 2002 6:32 PM To: Multiple recipients of list ORACLE-L I have seen it create two columns with the exact same name in a table. It did this by putting double quotes around the column it was adding (that actually already existed.) What's so bad about moving the pk fields to the top? Why would you put them in the middle of the table? I think having pk at the top is more readable, and it assists with more optimal storage at a very low level. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Paul Li [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 6:17 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > ERWin change the column sequences when using Reverse Engineering to > generate > diagram. It puts all of primary key columns on the top. But, actually some > primary key columns are in the middle of table. That is really bad. Does > anybody see the same problem? > > > > -Original Message- > Sent: Wednesday, May 01, 2002 5:01 PM > To: Multiple recipients of list ORACLE-L > > > ERWin's not much better. Has some better modeling capability as you might > guess, but has some VERY annoying quirks too. You also need to drill down > endlessly when doing a compare and I have seen it see two exact tables > (even > case being the same) and see them as different. The DO have a MATCH > button > that I would SUPPOSE allows you to re-align them, but I would not know for > sure as I get Dr. Watson's whenever I press it and the whole thing > crashes! > > I had a nice BUG last week only. Generated scripts for the model, ran > them > on the db, then ran a compare from the model to the db. Darn thing came > up > with differences > > Furthermore, I find that if you work from the Logical Model (like I do), > the > changes are not equally presented to the physical model (ie name > change./datatype change) and its NOT consistent with this behavior either! > > It has a report builder, but it doesn't report on datatypes entered on the > Logical side (even though the datatype on the physical MAY be different) = > therefore you can't run any consistency reports between the Logical and > Physical models. > > I have been using ERWin both as a modeling tool and a change repository > for > the model.I like to run several reports against a model (I call them > the > Sanity Checks Reports) you know, make sure that all columns named the > same (ie DESCRIPTION) are of the same datatype, length, etc. > > Anyhow, I can rant and rant. > > ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and > it > is rather easy to accidentally drop and drag either a relationship or > field > when re-aligning the model.. > ugh > > I wish we could get together a group and benchmark some relatively unknown > but stable modeling tool who's maker will listen to the DBA community and > put their name in the market (IE. give them market share) in exchange for > giving our community a tool that would actually work for us and work well! > > Rant over now. > > Please continue... > > > > > > > * It cannot handle obejcts (CLOBs, BLOBs, ...) that are not stored > inline.
Re: pl/sql is INTERPRETED?
It ain't that tough. We're not talking about taking a programming class without any experience, I've done a bit of it before. Learning all the API's, etc.: that would take some time. The language? It isn't that difficult, though I would be hard put to write any at the moment. The job I was going to use Java on was at Enron, and we all know what happened to that. It's been a year since I took the class, and I *much* prefer Perl. It can run circles around Java for most stuff. Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: pl/sql is INTERPRETED? It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. On Thu, 2 May 2002, Jared Still wrote: > > Hold on Lisa! > > Java is not complex. It's a very simple language > actually. It took me a week to learn it, though I'm > not using it now: I much prefer Perl. > > Getting a handle on all of the libraries and API's is > another story, but Java as a language is pretty simple. > > Jared > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > learned fairly easily in comparison to the many other choices out there. > > However, it takes a bit of database savvy to do it correctly. (Not much > > tho) > > > > I was amazed in my "database" class in college that the same people failing > > the simple entity-relationship modeling portion of the class that had aced > > the Op Systems and networking classes we took. I nearly failed both > > classes, they were so complex. I was the teacher's pet in the db class > > because I asked him questions that made him think, and he sometimes > > couldn't answer. (And I had to wear a skirt - night student, straight from > > work.) > > > > What's easy for who is dependent on the person's strengths. > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > To:Multiple recipients of list ORACLE-L > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > short period of time, or for that matter, any other language. > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > > written > > > by developers that knew what they were doing. > > > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > > the hell has free time? There is no free time on any project or effort > > > that > > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > > plus some developers skills so I can speak their language when they blow > > > out > > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > > JDBC, > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > > all > > > those mean, because I can't keep them straight. But I do keep hearing > > > that > > > XML is going to put me out of a job, so I guess I should learn > > > that...whatever that is. Isn't XML an add-on, or extension, or something > > > to > > > DML??? > > > > > > Now where the heck did I hide that bottle... > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Lisa, > > > > > > You are right about the debate between PL/SQL & Java (or anything else > > > outside of the db). > > > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > > is > > > what programming langauage the organization is satisfied with/settled > > > upon. > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > > period of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring back APL!). > > > > > > IT tool selection/standards should be the deciding factor. > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 11:34
Re: Oracle IFS
SAMBA would be much easier to implement, and certainly adequate if you just need a file server. http://www.samba.org Another advantage: it's open source Jared "Jack van Zanen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 01:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle IFS Hi All, We are looking for possible solutions to share files between Windows & Unix. And also store millions of little files that are now a backup nightmare. Does anybody have any experience with IFS (performance, possibilities, pitfalls ) TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: How to know if another database is running on the same machine?
You can Lsnrctl Will return a list of "running" databases on the server. Bob > Sent: Thursday, May 02, 2002 10:18 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: How to know if another database is running on > the same machine? > > > v$database will always show one and only one database - the > database to which the instance you are running the query > against is attached. As for how to find out on Windows, I'll > leave that to someone who knows Windows better than I. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: ERD generation tool
Yes. Your suggestion is correct. After you run Reverse Engineer to get the table diagram from database, right click the blank area. Small windows show up and select Stored Display Settings, select Physical tab, select Physical Order in Display Level and PK Designator. The diagram will be refreshed. The sequence is same as database. If you use Forward Engineer to generate sql script later on, the DDL is same as database structure. Thanks for all of your help. Paul -Original Message- Sent: Thursday, May 02, 2002 12:45 PM To: Multiple recipients of list ORACLE-L As I remember (since I'm no longer using ERWin since CA's takeover) there is a "Physical Order" box somewhere than needs to be clicked. If you do this, ERWin will use the actual physical order of the table, otherwise it will put them in another order (I think that it's primary key, foreign keys, and then alphabetical). The latest version of ERWin just isn't bug free enough for me to use as a primary tool --- so I'm using nothing. If I can't trust a tool then I can't use it. "Grabowy, Chris" To: Multiple recipients of list ORACLE-L @fcg.com>cc: Sent by: rootSubject: RE: ERD generation tool 05/01/2002 06:56 PM Please respond to ORACLE-L No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... -Original Message- Sent: Wednesday, May 01, 2002 6:32 PM To: Multiple recipients of list ORACLE-L I have seen it create two columns with the exact same name in a table. It did this by putting double quotes around the column it was adding (that actually already existed.) What's so bad about moving the pk fields to the top? Why would you put them in the middle of the table? I think having pk at the top is more readable, and it assists with more optimal storage at a very low level. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Paul Li [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 6:17 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > ERWin change the column sequences when using Reverse Engineering to > generate > diagram. It puts all of primary key columns on the top. But, actually some > primary key columns are in the middle of table. That is really bad. Does > anybody see the same problem? > > > > -Original Message- > Sent: Wednesday, May 01, 2002 5:01 PM > To: Multiple recipients of list ORACLE-L > > > ERWin's not much better. Has some better modeling capability as you might > guess, but has some VERY annoying quirks too. You also need to drill down > endlessly when doing a compare and I have seen it see two exact tables > (even > case being the same) and see them as different. The DO have a MATCH > button > that I would SUPPOSE allows you to re-align them, but I would not know for > sure as I get Dr. Watson's whenever I press it and the whole thing > crashes! > > I had a nice BUG last week only. Generated scripts for the model, ran > them > on the db, then ran a compare from the model to the db. Darn thing came > up > with differences > > Furthermore, I find that if you work from the Logical Model (like I do), > the > changes are not equally presented to the physical model (ie name > change./datatype change) and its NOT consistent with this behavior either! > > It has a report builder, but it doesn't report on datatypes entered on the > Logical side (even though the datatype on the physical MAY be different) = > therefore you can't run any consistency reports between the Logical and > Physical models. > > I have been using ERWin both as a modeling tool and a change repository > for > the model.I like to run several reports against a model (I call them > the > Sanity Checks Reports) you know, make sure that all columns named the > same (ie DESCRIPTION) are of the same datatype, length, etc. > > Anyhow, I can rant and rant. > > ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and > it > is rather easy to accidentally drop and drag either a relationship or > field > when re-aligning the model.. > ugh > > I wish we could get together a group and benchmark some relatively unknown > but stable modeling tool who's maker will listen to the DBA community and > put their name in the market (IE. give them market share) in exchange for > giving our community a tool
Re: Changing SQL statements inside the database
Well, there *is* a product that allows you to do this. http://www.teleran.com/products/iguard.htm This product t intercepts SQL and lets you do all manner of interesting things to it. Implementing something like this is rather expensive ( 6 figures minimum, U.S. Dollars ) and probably not what you had in mind. Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 06:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Changing SQL statements inside the database Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: ERD generation tool - Active SCM
Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their siblings), who can do "stuff" even in the production database with SQLPLus/TOAD/... Under this schenario, do you sleep well at night? So, we said lets work with our Dom Phoc's. On production databases, we will STRIP them off of the Oracle database passwords. No password, no change. ENFORCED! Now, I can sleep well at night. How? Not via models. Via a solution involving the following, and it seems to be working for us well: ActiveDesigner/ActiveChangeManager/ActiveCompare/A+ White Paper: http://www.iraje.com/docs/ActiveSecureDesigner.htm Take charge of the "Dom Phocs" in your org! Keith To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Date: Wed, 1 May 2002 16:06:00 -0500 Well, for one thing, if your developer, Dom Phoc, starts changing crap in your database (as has happened to me in the past) a compare to the dev model would be great because my development changes would be in the model, not in the test or production databases. In that specific case I had to TRUST him (what? trust him after what he just did?) to change everything back, or restore from a backup, which would have been very time consuming. I was one large ball of raging hormones that day and I took it all out on him. We don't work on the same projects anymore. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Keith Peterson [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 5:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool - Active Comparisons > > Am I speaking to the wind > > For Compares, why would you compare the MODEL with the > DATABASE...like going from US to London via Tokyo... > ... and you get to pay more, like... you pay not for > distance, but for "time in the air"... If a tool takes > longer to do something, makes more mistakes, is bumpy > and complex... you get to pay more. > > For compares, someone tell me what beats > ActiveCompare: > http://www.iraje.com/compare-diff.htm > > http://www.iraje.com/ActiveCompare_viewlet.html > > > ...and I will switch my tool. > > Keith __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson 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: Partitoned Table Insert Performance
Way back in the days of Oracle 8.0.5 I did some performance testing of bulk inserts/sqlldr of range partitioned tables v.s. non-partitioned tables. I don't have the benchmarks on hand, but here's what I found. All tests were done using the direct path inserts (sqlldr direct=true or /*+ APPEND */) If the table had no indexes, then there was no noticable difference when inserting approx 8 million rows. If the partitioned table had only local indexes, then the inserts into the tables were slightly faster. The difference was in seconds for my 8million row test. If the partitioned table had global partitioned indexes, then the inserts were generally slower. Again, the diference was in seconds. If the partitioned table had a global non-partitioned index there was no noticable diffence in time. In sort, range partitioning a table does not effect performance. The indexing of the range-partitioned table does. HTH Caver -Original Message- Sent: Thursday, May 02, 2002 12:45 PM To: Multiple recipients of list ORACLE-L I am in the process of implementing partitioning on some existing tables. I have been asked by management to evaluate the performance impacts of the changes. I am aware of many of the performance advantages of partitioning: partition pruning, partition-wise joins and parallel data loads. What I am concerned about is the additional overhead of inserting data into a partitioned table. What sort of overhead is associated with partitioned table inserts? Does determining the correct partition slow insertions? We are utilizing only range partitions, so hash value computations should not be a factor. Our application is very insertion intensive. One of the operations that performs insertions does so synchronously, so any decrease in insertion performance would be quite visible. Do you have any thoughts or experiences with this issue. Any performance tests on two similar tables, one partitioned and the other not? Any input would be appreciated. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M 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: pl/sql is INTERPRETED?
>It took you a week to learn it? Then you obviously do not know it. >Syntax is one thing design is another. I would love to know what you >learned in that week. >> Getting a handle on all of the libraries and API's is >> another story, but Java as a language is pretty simple. >> >> Jared Well Jared, He certainly referenced your message, but I am not sure if he actually read it first. You two actually seem to be in agreement. Java language/syntax is pretty straight forward, using it/libraries, API's, etc are another story. I think he is still just stinging from that crontab -e thread. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure 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: Partitoned Table Insert Performance
My last set of test results is a little out of date, but here's an idea to check. Inserting single rows: partitioned key insert HAD ca. 50% overhead Array Inserts sorted by partition key to get lots of adjacent rows in the same partition virtually no overhead Array inserts randomised to maximise the probability of adjacent inserts being to different partitions Overhead ca. 50% Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 02 May 2002 17:35 |I am in the process of implementing partitioning on some existing tables. I |have been asked by management to evaluate the performance impacts of the |changes. I am aware of many of the performance advantages of partitioning: |partition pruning, partition-wise joins and parallel data loads. What I am |concerned about is the additional overhead of inserting data into a |partitioned table. What sort of overhead is associated with partitioned |table inserts? Does determining the correct partition slow insertions? We |are utilizing only range partitions, so hash value computations should not |be a factor. Our application is very insertion intensive. One of the |operations that performs insertions does so synchronously, so any decrease |in insertion performance would be quite visible. Do you have any thoughts or |experiences with this issue. Any performance tests on two similar tables, |one partitioned and the other not? Any input would be appreciated. Thanks. |Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: 9i new features update
Thanks Joe. Jared "JOE TESTA" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/02/2002 06:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:9i new features update I finally got the website updated. For those of you who lost, never saw, would like to review, all of the past editions of the 9i new features series is at http://www.oracle-dba.com click on the 9i link. joe -- 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: ERD generation tool
Hello Ron I was just looking at Joe new oracle 9i features at http://www.oracle-dba.com I saw that log miner gives you something like: update "SCOTT"."TEST_LOG" set "C2" = '10' What happens if you extract this info and erd tool moved a column? Inquiring minds wants to know Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:58 PM Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Yechiel Adar 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: Advice on going about a minor upgrade.
Option 4: Install 8.1.7 shutdown the database change ORACLE_HOME etc etc to point to the 8.1.7 ORACLE_HOME startup the database You shouldn't have to rebuild the database when moving to a minor release Rachel |+---> || | || | || [EMAIL PROTECTED]| || ate.nh.us| || | || 05/02/2002 | || 12:45 PM | || Please | || respond to | || ORACLE-L | || | |+---> >| || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Advice on going about a minor | | upgrade. | >| Greetings fellow-DBAs, We have a web application which exists on a Windows/NT 4 box running Oracle Standard Server 8.1.6. A new application to be added to that platform needs Oracle 8.1.7 (They've even specified needing Patch Set 8.1.7.2.1 and ODBC driver 8.01.74.00). I have just ordered the Oracle 8.1.7 Server for Windows NT and would like to ask what you think in terms of direction I should take for the upgrade. Here is my plan: (1) Have the NT System Administrator back up the entire system (2) Take a full export of the existing database Either Option1: (3a) Install Oracle 8.1.7 (4a) Build the database from scratch (5a) Import the full export from #2 Or Option 2: (3b) Deinstall Oracle 8.1.6 (4b) Install Oracle 8.1.7 (5b) Build the database from scratch (6b) Import the full export from #2 Or Option 3: (3c) Install Oracle 8.1.7 (4c) Migrate the existing database. Any pros, cons, or suggestions with respect to what I've laid out here? As always, thank you very much in advance for all the sound advice you've historically offered. Jim Damiano -- 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: Advice on going about a minor upgrade.
I did this exact upgrade a very short time ago, using Option1. It worked just fine. I would add step (6a) install patches up to 8.1.7.3., after the database has moved to the new version. I would stay away from Option2. You have no fallback. -Original Message- Sent: Thursday, May 02, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Greetings fellow-DBAs, We have a web application which exists on a Windows/NT 4 box running Oracle Standard Server 8.1.6. A new application to be added to that platform needs Oracle 8.1.7 (They've even specified needing Patch Set 8.1.7.2.1 and ODBC driver 8.01.74.00). I have just ordered the Oracle 8.1.7 Server for Windows NT and would like to ask what you think in terms of direction I should take for the upgrade. Here is my plan: (1) Have the NT System Administrator back up the entire system (2) Take a full export of the existing database Either Option1: (3a) Install Oracle 8.1.7 (4a) Build the database from scratch (5a) Import the full export from #2 Or Option 2: (3b) Deinstall Oracle 8.1.6 (4b) Install Oracle 8.1.7 (5b) Build the database from scratch (6b) Import the full export from #2 Or Option 3: (3c) Install Oracle 8.1.7 (4c) Migrate the existing database. Any pros, cons, or suggestions with respect to what I've laid out here? As always, thank you very much in advance for all the sound advice you've historically offered. Jim Damiano -- 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: Seefelt, Beth 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: OTN service
Hello Ray I think that the intent is for you to burn the gz file and expand it on the target system. I installed today upgrade 9.0.1.3 for NT that came in the same way. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:53 PM > > I mentioned that the 32 bit solaris gz file for 8.1.7 > that I downloaded from otn provided one disk image on the order > of 900MB. What technology do I need to move to in order > to burn this onto plastic? Are we talking dvd burner here? > > I asked oracle what the intent was with this, the answer is > a classic: > > The OTN Service Network is specifically designed for customers who need > support on software downloaded via OTN. The OTN Service Network offers > pay-per-incident support provided by Oracle certified professionals. > Support is available on Oracle Database Server, Oracle9I Application > Server and Oracle Tools products. Pricing is $50, $75 or $100 based on > the complexity of the issue. > > By intent, I ment what technology was targeted. Anybody know? > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > 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: Yechiel Adar 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).
Advice on going about a minor upgrade.
Greetings fellow-DBAs, We have a web application which exists on a Windows/NT 4 box running Oracle Standard Server 8.1.6. A new application to be added to that platform needs Oracle 8.1.7 (They've even specified needing Patch Set 8.1.7.2.1 and ODBC driver 8.01.74.00). I have just ordered the Oracle 8.1.7 Server for Windows NT and would like to ask what you think in terms of direction I should take for the upgrade. Here is my plan: (1) Have the NT System Administrator back up the entire system (2) Take a full export of the existing database Either Option1: (3a) Install Oracle 8.1.7 (4a) Build the database from scratch (5a) Import the full export from #2 Or Option 2: (3b) Deinstall Oracle 8.1.6 (4b) Install Oracle 8.1.7 (5b) Build the database from scratch (6b) Import the full export from #2 Or Option 3: (3c) Install Oracle 8.1.7 (4c) Migrate the existing database. Any pros, cons, or suggestions with respect to what I've laid out here? As always, thank you very much in advance for all the sound advice you've historically offered. Jim Damiano -- 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: Correcting user sql inside the database
Hello Anjo If you know of a way to change the SQL at the client side I would LOVE to know it. We where thinking about changing the connections string on the fly (not this fly) And this can help a lot. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:43 PM > Outlines is one way, but there is another sneaky way, but that involves a > lot of programming depending on what you want to change. > And it also depends on where the client runs and how it is linked > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 2:48 PM > > > > Hello list > > > > This time I need your help on how to implement a weird idea. > > We have a third party application that fire wasteful SQL's to the > database. > > (Remember the discussion on using x$dual Vs dual some days ago?) > > > > I am wondering: Is there a way to change the SQL that the user send? > > > > In ADABAS on the mainframe I can activate a user exit that gets the > command > > that > > the user send to the database and change it (Not only can, but we are > doing > > it!). > > > > Is there a way to do the same with SQL in Oracle? > > > > In the server (preferably) or in the client. > > > > Thanks > > > > Yechiel Adar > > Mehish > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > 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: Anjo Kolk > 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: Yechiel Adar 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).
Partitoned Table Insert Performance
I am in the process of implementing partitioning on some existing tables. I have been asked by management to evaluate the performance impacts of the changes. I am aware of many of the performance advantages of partitioning: partition pruning, partition-wise joins and parallel data loads. What I am concerned about is the additional overhead of inserting data into a partitioned table. What sort of overhead is associated with partitioned table inserts? Does determining the correct partition slow insertions? We are utilizing only range partitions, so hash value computations should not be a factor. Our application is very insertion intensive. One of the operations that performs insertions does so synchronously, so any decrease in insertion performance would be quite visible. Do you have any thoughts or experiences with this issue. Any performance tests on two similar tables, one partitioned and the other not? Any input would be appreciated. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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: Changing SQL statements inside the database
Thanks for the idea Tim but I am thinking about adding hints to the sql or changing the FROM table. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 4:48 PM > The Virtual Private Database (VPD) facility (a.k.a. "fine-grain" or > "row-level" security) can be used to alter SQL on the server, regardless of > origin. I implemented an access control list (ACL) feature for a system two > years ago, complete with recursion inside PL/SQL for navigating the > (implied) double-dimensioned linked-lists that typical ACL functionality > requires. > > Navigating linked-lists is naturally something that you wouldn't want to > code in a SQL statement, but VPDs did it quite nicely by allowing me to run > a custom PL/SQL packaged function during the PARSE phase of a SQL statement. > The packaged function is supposed to return a string which is tacked onto > the SQL statement, so you cannot "modify" existing text in the SQL, but you > can add additional SQL text to the WHERE clause, including subqueries. > There are other little useful twists and tricks and gotchas involved, but > that's the general idea... > > But, be *very* careful! You can just imagine how badly you can harm > performance and accessibility through casual use of this feature... :-) > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 7:18 AM > > > > Hello list > > > > This time I need your help on how to implement a weird idea. > > We have a third party application that fire wasteful SQL's to the > database. > > (Remember the discussion on using x$dual Vs dual some days ago?) > > > > I am wondering: Is there a way to change the SQL that the user send? > > > > In ADABAS on the mainframe I can activate a user exit that gets the > command > > that > > the user send to the database and change it (Not only can, but we are > doing > > it!). > > > > Is there a way to do the same with SQL in Oracle? > > > > In the server (preferably) or in the client. > > > > Thanks > > > > Yechiel Adar > > Mehish > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > 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 Gorman > 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: Yechiel Adar 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: 9i new features update
Hello Joe Just took a peek. Looks illuminating. Keep up the good work. Yechiel Adar Mehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, May 02, 2002 3:48 PM Subject: 9i new features update I finally got the website updated. For those of you who lost, never saw, would like to review, all of the past editions of the 9i new features series is at http://www.oracle-dba.com click on the 9i link. joe
RE: ERD generation tool
As I remember (since I'm no longer using ERWin since CA's takeover) there is a "Physical Order" box somewhere than needs to be clicked. If you do this, ERWin will use the actual physical order of the table, otherwise it will put them in another order (I think that it's primary key, foreign keys, and then alphabetical). The latest version of ERWin just isn't bug free enough for me to use as a primary tool --- so I'm using nothing. If I can't trust a tool then I can't use it. "Grabowy, Chris" To: Multiple recipients of list ORACLE-L @fcg.com>cc: Sent by: rootSubject: RE: ERD generation tool 05/01/2002 06:56 PM Please respond to ORACLE-L No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... -Original Message- Sent: Wednesday, May 01, 2002 6:32 PM To: Multiple recipients of list ORACLE-L I have seen it create two columns with the exact same name in a table. It did this by putting double quotes around the column it was adding (that actually already existed.) What's so bad about moving the pk fields to the top? Why would you put them in the middle of the table? I think having pk at the top is more readable, and it assists with more optimal storage at a very low level. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 > -Original Message- > From: Paul Li [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 6:17 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > ERWin change the column sequences when using Reverse Engineering to > generate > diagram. It puts all of primary key columns on the top. But, actually some > primary key columns are in the middle of table. That is really bad. Does > anybody see the same problem? > > > > -Original Message- > Sent: Wednesday, May 01, 2002 5:01 PM > To: Multiple recipients of list ORACLE-L > > > ERWin's not much better. Has some better modeling capability as you might > guess, but has some VERY annoying quirks too. You also need to drill down > endlessly when doing a compare and I have seen it see two exact tables > (even > case being the same) and see them as different. The DO have a MATCH > button > that I would SUPPOSE allows you to re-align them, but I would not know for > sure as I get Dr. Watson's whenever I press it and the whole thing > crashes! > > I had a nice BUG last week only. Generated scripts for the model, ran > them > on the db, then ran a compare from the model to the db. Darn thing came > up > with differences > > Furthermore, I find that if you work from the Logical Model (like I do), > the > changes are not equally presented to the physical model (ie name > change./datatype change) and its NOT consistent with this behavior either! > > It has a report builder, but it doesn't report on datatypes entered on the > Logical side (even though the datatype on the physical MAY be different) = > therefore you can't run any consistency reports between the Logical and > Physical models. > > I have been using ERWin both as a modeling tool and a change repository > for > the model.I like to run several reports against a model (I call them > the > Sanity Checks Reports) you know, make sure that all columns named the > same (ie DESCRIPTION) are of the same datatype, length, etc. > > Anyhow, I can rant and rant. > > ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and > it > is rather easy to accidentally drop and drag either a relations
Re: Changing SQL statements inside the database
I'd believe it. I have a classic in my seminar where VPD/FGAC/RLS turned a simple single table query into a 16-table join. There is a vague directive from Oracle nowadays that you should only be using VPD to generate predicates involving sys_context() calls, rather than attaching subqueries. This is partly to do with an invalidation issue that Tom Kyte describes in his book. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 02 May 2002 15:32 |But, be *very* careful! You can just imagine how badly you can harm |performance and accessibility through casual use of this feature... :-) | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Correcting user sql inside the database
Anjo, Can you tell us more on the "sneaky" way? Babu - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 8:43 AM > Outlines is one way, but there is another sneaky way, but that involves a > lot of programming depending on what you want to change. > And it also depends on where the client runs and how it is linked > > Anjo. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 2:48 PM > > > > Hello list > > > > This time I need your help on how to implement a weird idea. > > We have a third party application that fire wasteful SQL's to the > database. > > (Remember the discussion on using x$dual Vs dual some days ago?) > > > > I am wondering: Is there a way to change the SQL that the user send? > > > > In ADABAS on the mainframe I can activate a user exit that gets the > command > > that > > the user send to the database and change it (Not only can, but we are > doing > > it!). > > > > Is there a way to do the same with SQL in Oracle? > > > > In the server (preferably) or in the client. > > > > Thanks > > > > Yechiel Adar > > Mehish > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yechiel Adar > > 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: Anjo Kolk > 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: Babu Nagarajan 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: pl/sql is INTERPRETED?
I think that given Jared's strong Perl background, his picking up the syntax was easy enough for him. Heck, I downloaded some Java programs from the web and made changes to them while playing around, and my changes worked just fine (I change colors of moving objects - whoopee, I'm a Java programmer!) But even he said, and I am assuming that Alex is alluding to - that understanding the libraries so that one truely develops OOP programs would take awhile to learn. I rememember doing programming like this once - but it was in Assembly Language class back in 1976. That's when programmers were much closer to the hardware than we are now. Ooops - showed my age again... :( Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, May 02, 2002 11:24 AM To: Multiple recipients of list ORACLE-L It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. On Thu, 2 May 2002, Jared Still wrote: > > Hold on Lisa! > > Java is not complex. It's a very simple language > actually. It took me a week to learn it, though I'm > not using it now: I much prefer Perl. > > Getting a handle on all of the libraries and API's is > another story, but Java as a language is pretty simple. > > Jared > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > learned fairly easily in comparison to the many other choices out there. > > However, it takes a bit of database savvy to do it correctly. (Not much > > tho) > > > > I was amazed in my "database" class in college that the same people failing > > the simple entity-relationship modeling portion of the class that had aced > > the Op Systems and networking classes we took. I nearly failed both > > classes, they were so complex. I was the teacher's pet in the db class > > because I asked him questions that made him think, and he sometimes > > couldn't answer. (And I had to wear a skirt - night student, straight from > > work.) > > > > What's easy for who is dependent on the person's strengths. > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > short period of time, or for that matter, any other language. > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > > written > > > by developers that knew what they were doing. > > > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > > the hell has free time? There is no free time on any project or effort > > > that > > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > > plus some developers skills so I can speak their language when they blow > > > out > > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > > JDBC, > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > > all > > > those mean, because I can't keep them straight. But I do keep hearing > > > that > > > XML is going to put me out of a job, so I guess I should learn > > > that...whatever that is. Isn't XML an add-on, or extension, or something > > > to > > > DML??? > > > > > > Now where the heck did I hide that bottle... > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Lisa, > > > > > > You are right about the debate between PL/SQL & Java (or anything else > > > outside of the db). > > > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > > is > > > what programming langauage the organization is satisfied with/settled > > > upon. > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > > period of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring back APL!). > > > > > > IT tool selection/standards should be the deciding factor. > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- >
Re: Oracle IFS
Samba on Linux has been a life saver. Users can map a network drive, that's nfs mounted on UNIX that's accessible from the web. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Jack van Zanen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: L> Subject: Oracle IFS Sent by: [EMAIL PROTECTED] om 05/02/2002 03:48 AM Please respond to ORACLE-L Hi All, We are looking for possible solutions to share files between Windows & Unix. And also store millions of little files that are now a backup nightmare. Does anybody have any experience with IFS (performance, possibilities, pitfalls ) TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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
Re: pl/sql is INTERPRETED?
It took you a week to learn it? Then you obviously do not know it. Syntax is one thing design is another. I would love to know what you learned in that week. On Thu, 2 May 2002, Jared Still wrote: > > Hold on Lisa! > > Java is not complex. It's a very simple language > actually. It took me a week to learn it, though I'm > not using it now: I much prefer Perl. > > Getting a handle on all of the libraries and API's is > another story, but Java as a language is pretty simple. > > Jared > > On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > > You have a point Chris, but pl/sql is nowhere near as complex as an OO > > language like java or C++, IMHO. I agree with Tom that pl/sql can be > > learned fairly easily in comparison to the many other choices out there. > > However, it takes a bit of database savvy to do it correctly. (Not much > > tho) > > > > I was amazed in my "database" class in college that the same people failing > > the simple entity-relationship modeling portion of the class that had aced > > the Op Systems and networking classes we took. I nearly failed both > > classes, they were so complex. I was the teacher's pet in the db class > > because I asked him questions that made him think, and he sometimes > > couldn't answer. (And I had to wear a skirt - night student, straight from > > work.) > > > > What's easy for who is dependent on the person's strengths. > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 1:14 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: pl/sql is INTERPRETED? > > > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > > short period of time, or for that matter, any other language. > > > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > > written > > > by developers that knew what they were doing. > > > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > > the hell has free time? There is no free time on any project or effort > > > that > > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > > plus some developers skills so I can speak their language when they blow > > > out > > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > > JDBC, > > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > > all > > > those mean, because I can't keep them straight. But I do keep hearing > > > that > > > XML is going to put me out of a job, so I guess I should learn > > > that...whatever that is. Isn't XML an add-on, or extension, or something > > > to > > > DML??? > > > > > > Now where the heck did I hide that bottle... > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 12:15 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Lisa, > > > > > > You are right about the debate between PL/SQL & Java (or anything else > > > outside of the db). > > > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > > is > > > what programming langauage the organization is satisfied with/settled > > > upon. > > > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > > period of time. This means that development and maintenance costs are > > > relatively low. If an IT shop is stronger in Java, then they should > > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > > decade happens to be (lets bring back APL!). > > > > > > IT tool selection/standards should be the deciding factor. > > > > > > Tom Mercadante > > > Oracle Certified Professional > > > > > > > > > -Original Message- > > > Sent: Tuesday, April 30, 2002 11:34 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > This is something that's been debated on the list in the past. The > > > general > > > consensus was: > > > > > > For manipulating data in the database, nothing beats pl/sql. It is well > > > suited for this purpose. > > > > > > For everything else, java could beat it. > > > > > > I am sure fellow list members will post links describing studies. I > > > remember seeing these last year. > > > > > > Stefan, have you tried running your own test? There's a sure fire way to > > > convince yourself. Even a small test (no fancy code) would suffice. > > > Wish I > > > had more time to play... > > > > > > Lisa Koivu > > > Oracle Database Monkey Mama > > > Fairfield Resorts, Inc. > > > 5259 Coconut Creek Parkway > > > Ft. Lau
Disaster Recovery Plan
Hi All, We are in the process of developing a discovery plan. Does anyone have any links,example disaster recovery plans,etc that I can research for ideas. Thanks Rick -- 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: Can't Connect to DB
Hi Ken, Is your listener started?? That appears to be the case based on this message. Go to your services and see if the Oraclelistener service is started. If not then start this service and try to connect then. If you are getting an error when attempting to start the service you will need to go to the dos prompt to get a more meaningful error and attempt to start the service with the command lsnrctl start It will probably still not start but you should get a better error. Good luck, John Hough [EMAIL PROTECTED] wrote: Oracle 9i on XP Prof. DB is on a single PC. When I try to do a DB connection I get this error. Yesterday I created a second DB on my PC and was able to connect successfully to either of them. This morning I rebooted my PC and now I cannot connect. Any idea what the problem is? TIA, Ken Janusz, CPIM - ORA-12541: TNS:no listener Details: Building Oracle HOMES List HOME Name OraHome90 added to list. Found multiple homes, searching each HOMEx for valid PATH searching in SOFTWARE\ORACLE\HOME0 Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path! oci.dll found
RE: Can't Connect to DB
Start the database and listener services. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 02, 2002 9:43 AM > To: Multiple recipients of list ORACLE-L > Subject: Can't Connect to DB > > Oracle 9i on XP Prof. > DB is on a single PC. > > When I try to do a DB connection I get this error. Yesterday I created a > second DB on my PC and was able to connect successfully to either of them. > This morning I rebooted my PC and now I cannot connect. > > Any idea what the problem is? > > TIA, > Ken Janusz, CPIM > > - > > ORA-12541: TNS:no listener > > Details: > Building Oracle HOMES List > HOME Name OraHome90 added to list. > Found multiple homes, searching each HOMEx for valid PATH > searching in SOFTWARE\ORACLE\HOME0 > Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path! > oci.dll found -- 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).
Fwd: Message Stopped ---- Virus Detected ---- RE: ERD
Did anyone else receive this message from a reply to the list? Ron ROR mª¿ªm >>> <[EMAIL PROTECTED]> 05/02/02 10:01AM >>> Sky City's e-mail system has stopped the following message because: * It believes the e-mail message and/or an attachment contains a known virus. Message: B00014e2f1.0001.mml From:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: ERD generation tool Please re-send the e-mail message after you have removed the virus from the e-mail message (and your computer). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).
