Re: Linux
Run it on Linux like you would run it on Windows. You do need some Unix skills for any OS level work though. Otherwise, Oracle is the same (mostly) on both platforms. Download Oracle for Linux., It's free for evaluation, education and development use from http://www.oracle.com -- Lyndon Tiu Quoting Turner, Christine [EMAIL PROTECTED]: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Why do I receive the mails late?
Yes. This is very normal for me as well. Naveen Nahata wrote: I receive the mails of this late after a long delay approx 1-2 hours. Is this common? Sometimes i get the reply first and then i get the question Regards Naveen -- ltiu OCP 9i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dark side of the force
I don't get it. Why RPG with DB2? Why not SQL and Java on DB2? Is this because of legacy RPG that's why shops still use RPG today? Or is there an advantage to using RPG ( Report Program Generator )? I used to work for this company that couldn't find enough RPG programmers, they had to find a few dozen from a different country. ltiu Farnsworth, Dave wrote: That's good cuz RPG IS the dark side, it's evil. BUWAHAHAHAHAHAHA -Original Message- Sent: Wednesday, October 02, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Thanks. I do not think so as DB2 was chosen because we'll be implementing Siebel (and Siebel is recommanding DB2). They're should be 2 DB2 databases, one for Siebel and one for the staging area as 8 different data sources will be loaded in Siebel. So I hope RPG won't fit in ;-) --- Farnsworth, Dave [EMAIL PROTECTED] a écrit : Try this one for DB2. So do you have to deal with a bunch of RPG programmers for DB2? www.idug.org Dave -Original Message- Sent: Tuesday, October 01, 2002 10:03 PM To: Multiple recipients of list ORACLE-L Hi all, I'll be seeing the dark side of the force as I'll be the DBA on a DB2 UDB project. Is there a list like this one for DB2 ? Any links to DB2 stuff ? I'd be interested in documents showing the differences/similarities between Oracle and DB2 UDB. Let's see our bargaining power with our Oracle rep once DB2 is in our Oracle shop (over 100 instances) = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle D.B.A. required in M.A.
You know what, this means the people who are hiring does not know what they are looking for. Gene Sais wrote: lol, i love #1 #2, developer but not a development dba. good luck in your search, quite a few requirements :) gene [EMAIL PROTECTED] 10/02/02 11:50AM In my company, we require Oracle D.B.A. to maintain development and production Oracle databases. This is a permanent position. Our compnay is 24 yrs. old company. Our company is situated on Route 128 in M.A. We require the candidate urgently. If interested, please send your resumes within the next two days to the following e-mail: [EMAIL PROTECTED] Following are the details for the job: Our environment: Solaris 7 and solaris 8. Databases versions: 804, 8.1.6.1, 8.1.7.3 OLTP databases and datawarehouse. Veritas File System. Middleware: Tuxedo and MQ series Quest, DataMirror - Replication products Apps: WebLogic Following is the skill set for the candidate: Following are essential requirements for an Oracle DBA. 1. Must have worked as Oracle developer at least 3 years. 2. Must have been working as Oracle DBA at least for the last 3 years in a PRODUCTION environment in 8i. (We don't want development DBA's). 3. Must have excellent knowledge in installing Oracle software and its products. Must have installed patches in his earlier job. 4. Thorough knowledge in Backup and Recovery procedures. Must be able to solve scenarios during the interview. 5. Good knowlege in Oracle tuning process. Must be able to solve scenarios during the interview. 4. Must have good knowledge in running various statistical packages like STATSPACK. 5. Excellent knowledge in shell programming and understanding of awk and sed usage. 6. Must be very familiar with Solaris 7 and higher versions. Must have general understanding of tuning/performance processes involved on Unix level. Should be able to give us various scenarious he/she faced during his career in tuning. 7. Must have good understanding of PL/SQL, SQL. 8. Must be familiar with OMS and its tools. 9. Must have thorough understanding of RAID concepts and its use in Oracle. And good knowledge on Oracle OFA methodology - -- This is must. 10. Must have good knowledge on normalization techniques. 11. Must be familiar with Oracle Standby databases and their running. -- This is essential. 12. Good communication skills and team work. Optional but would have weightage: 1. Oracle 9i knowledge 2. Oracle RAC environment experience. 3. Datawarehous knowledge and issues involved in setting up production datawarehouses 4. Understanding of Veritas 5. Knowledge about design tools like Oracle Designer/ERwin 6. Knowledge about Quest 7. Knowledge about DataMirror 8. General understanding of WebLogic 9. Understanding Tuxedo or MQM 10. Knowledge in C programing. Rao -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i R3, and 9i R2 on Same NT Box
This is interesting. I have installed and run multiple Oracle versions on the same Unix box but not NT. Sam Bootsma wrote: Hello, Does anybody out there run Oracle 8.1.7 and Oracle 9.2 on the same NT (or Windows 2000) box? Is it running smoothly. Any difficulties installing or running both versions on the same box? I ask because one of my colleagues has encountered difficulties installing and running Oracle 8.1.7 and Oracle 9.2 on the same NT box. Thanks for any input. Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remember me? Oracle DBA veteran considering getting certifi
I think he meant Oracle 9i Exam 1 of 4 - Intro to SQL. On Saturday 28 September 2002 14:28, Mohammad Rafiq wrote: Which version you are talking about? 8i or 9i upgrade certification Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sat, 28 Sep 2002 08:53:19 -0800 Well, Given the IT market I felt that it was worth getting certified even though I haven't had any problems and been working with Oracle as DBA for over 8 years. However, I decided that I didn't want to spend a lot of money or time to do it. I have 2 small children, work, - yadayadayada(sp?). I got the self-test for the first test, studied using that and read Mike Ault's Exam cram book from front to back (excellent resource, concise, straightforward, good examples - just a couple of errors in whole book). Total test time was about 30 hours. Took the exam this morning in 60 minutes (120 alloted), got 49 out of 57 questions correct and passed. I really want to thank Mike Ault for the excellent concise Cram book and intend to continue on this same path for the other exams. Unfortunately, Mike didn't write all of them - however, I am hoping they are all of the same level of quality. I haven't taken a course in Oracle (any) for about 5 year and SQL/PLSQL in about 10-12. Total hours to prepare : 30 hours Resources: Exam Cram by Mike Ault and self-test exam Any additional costs - none Didn't want to study on clients time so ended up studying mostly between the hours of 2:00 a.m. and 8:00 a.m. in the morning. Hope the others go well and can get this done before Oracle changes the criteria. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Employment shifts in 2001
How many went back to their old non-IT jobs before they moved into IT during the boom years when IT sucked people from the non-IT sector? ltiu DENNIS WILLIAMS wrote: List - We have discussed the employment situation a lot over the past year, and I am still dismayed to hear of Oracle DBAs out of work. I found some interesting statistics that put the situation in perspective: In 2001, there were an estimated 10.4 million IT workers in the U.S. In 2001, 2.6 million IT workers were dismissed. In 2001, 2.1 million IT workers were hired. In 2002, there were an estimated 9.9 million IT workers in the U.S. This means that 1 in 4 IT professionals were laid off in 2001. Small wonder that some of those included DBAs. Of those laid off, 20% were not rehired (at least in IT). These figures are from: http://www2.cio.com/metrics/ The print magazine had a small summary box that I couldn't find online. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ltiu 3/4 OCP 9i eH? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MIcrosoft Blackmail
Nothing wrong with dominating as long as the rule the better product wins is followed (i.e. not through foul play like forcing Dell or HP to bundle MSOffice or else they can't sell MSWindows with their PC's). ltiu Orr, Steve wrote: Speaking of RD, what about the eWeek article about how M$ is going to pump $3,000,000,000.00 into MS Office? They want to achieve $20,000,000,000.00 per year in revenue on MSOffice alone. Seems like they want to dominate the desktop with more that just the O/S and browser. Can't anyone slay this beast? It's an evil world in which we live... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: oracle-dba.com up for sale on ebay.com
What's the reserve price? ltiu JOE TESTA wrote: For those of you who don't know, i've put in place a plan to leave the oracle field and move back into the medical field, saying that, i've decided to offload the oracle-dba.com domain that i purchased quite a few years ago. Its on ebay with a starting price of .01 with a reserve price. If you're dying to know what the reserve price is, drop me a line. its item# 2057533249 joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Agnostic references for Pracle v SQl Server 2000
Then use MySQL or PostGresSQL. These two are free (READ: LOW COST = Charity Status you are looking for) and runs on multiple different OSes. ltiu Martin Kendall wrote: Hello all. I need to provide a one page report on why it may be beneficial for an organisation with light usage, small DB to move from Oracle to SQL Server. Their request is purely due to having a recognition of their charity status by Microsoft and therefore being able to get everything at a much reduced price. It is bad enough that they do not have experienced Oracle DBAs on site, now it seems that they are attracted by the apparent ease of use / setup/ Graphical everything. They are even looking at adopting the same development technology as one of their main benefactors as this may help them win further funding from such a benefactor. I am talking .NET and VB. I am also asked to phrase my paper from the point of future proofing their business technology. I am struggling with the agnostic approach when taking into account the concept of vendor lock-in . It seems that cost is everything. But they will need to accept that cost is not just what you pay for the base product. People, I am not really interested in a religious war on this no doubt such discussion types have appeared on this List before. All I am asking for is pointers to any ref. material that you may know of. Happy days ! Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Misinformation Ranting
So, did you bend to her wishes? ltiu [EMAIL PROTECTED] wrote: RANT I've just spent 30 minutes with our SAP administrator trying to convince her that we really don't need to reorganize the tables in our production SAP database. Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' I think, she is equating number of extents with fragmentation. The text she referred me to is in fact discussing 'migrated rows' though that term is never used. She has become convinced that if the extents allocated for tables are not all in contigous space, some very nasty fragmentation will occur. I tried taking it down to disk and explaining that an OLTP system with hundreds of users won't really see much benefit from this, but she wasn't really ready for that. :) Her concern is that there are 29000 extents in an index tablespace. This might have something to do with there being 3400 indexes in said tablespace. Total 'wasted' ( honeycomb ) space in this 250 gig DB is 20 meg. Not much to gain there. The text of the book states that you should expect a '10 to 20 percent performance increase' by reorganizing the tables/indexes. No data to back it up of course. This is on a database that performs very well most of the time, outside of a couple of custom reports that run too long. No complaints from users about slowness. Arrghhh! I just had to vent to the list, cuz there's no one here that understands. \RANT Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recreate database script
Thanks. I wonder if you can treat an export file as a *.sql script and run it off sqlplus with the @@script.sql command? I shall give this a try. ltiu Fink, Dan wrote: If you export with rows=n, you get a text file with all the ddl to recreate the exportable objects. However, packages/procedures are formatted and not at all easy to use to recreate and the storage clauses are all in bytes. Not a pretty method, but certainly one that can be used. -Original Message- Sent: Friday, September 06, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Export can do this. Right? But the output is not a script but a binary file only Import can understand. ltiu Connie Milliken wrote: Does anyone have a script that will write another script to recreate a particular database quickly with all the info specific to that particular database? Seems to me that I have seen this somewhere before, but I am not sure where. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recreate database script
Hello, Could anyone here suggest a software package that can create an ER diagram by simply connecting to an Oracle database, reverse engineer it to see the schema in an ER diagram - instead of in a file with ddl/dml statements. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sort Area Size?
Hello, For an SGA of about 512MB and a 2GB database (total of the *.dbf) files. Is 1MB sort area size enough? Thank you for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No space left on device - but I have lots left.
Hello guys, Could use some help here. 1) System specs. Solaris 8 512MB Ram 1GB Swap Oracle 9i Rel2 2) Relevant init.ora parameters: *.LARGE_POOL_SIZE=1048576 *.SGA_MAX_SIZE=33554432 *.SHARED_POOL_SIZE=16777216 *.SORT_AREA_SIZE=2097152 *.compatible='9.2.0.1.0' *.db_cache_size=2097152 *.log_buffer=1048576 3) Starting up database, I get the following error: SQL startup nomount ORA-27302: failure occurred at: skgpwreset1 ORA-27303: additional information: invalid shared ctx ORA-27146: post/wait initialization failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper I have a lot of disk space left - 2.5GB. I have half of my RAM and the whole swap free when this error occurs. I appreciate any help and tips. Thank you. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: No space left on device - but I have lots left.
Thank you. Yes. You are right. The error messages are very informative don't you think? ltiu On Saturday 07 September 2002 16:23, Mladen Gogala wrote: I love emails like this. Do you read the error message at all or you simply email all your findings to the list assuming that the list will automatically be interested in everything coming from you? Don't you think that starting your email with something like sorry guys and goddesses, I'm a beginner in dire need would be in order? Now to your message. You need more semaphores, not disk space. Get a copy of Adrian Cockroft's performance tuning book and it will tell you exactly how to modify your /etc/system. Also, you may try looking for the words like semaphore at docs.sun.com. I know it's unusual thing to do and much harder then to email this list but you might want to try it nevertheless. On 2002.09.07 18:43 ltiu wrote: Hello guys, Could use some help here. 1) System specs. Solaris 8 512MB Ram 1GB Swap Oracle 9i Rel2 2) Relevant init.ora parameters: *.LARGE_POOL_SIZE=1048576 *.SGA_MAX_SIZE=33554432 *.SHARED_POOL_SIZE=16777216 *.SORT_AREA_SIZE=2097152 *.compatible='9.2.0.1.0' *.db_cache_size=2097152 *.log_buffer=1048576 3) Starting up database, I get the following error: SQL startup nomount ORA-27302: failure occurred at: skgpwreset1 ORA-27303: additional information: invalid shared ctx ORA-27146: post/wait initialization failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper I have a lot of disk space left - 2.5GB. I have half of my RAM and the whole swap free when this error occurs. I appreciate any help and tips. Thank you. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: No space left on device - but I have lots left.
Yes. Thank you for your advice. I do have to keep this in mind everyday. ltiu On Saturday 07 September 2002 17:28, Steven Lembark wrote: -- ltiu [EMAIL PROTECTED] The error messages are very informative don't you think? Error messages in most products stink. If you don't learn to outsmart the developers and find what's wrong you will never be able to manage databases or operating systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: connect to the databases without using tnsnames.ora?
Are you talking about the JDBC Oracle Thin Driver? This is because you configure it separately. It still has a tnsnames.ora type config somewhere hidden in it's own config file. Just that it does not use the regular tnsnames.ora. ltiu DENNIS WILLIAMS wrote: Cc I believe the Java thin client can connect without using the tnsnames.ora file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Does anyone here knows how to setup the connections to the database server without using tnsnames.ora? Our DBA didn't use it. But I don't know how and why? Could anyone tell me the other options? Cc Harvest __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Restoring RMAN backups to different host ......
About restoring controlfiles, if I remember this correctly as I did just
this a few months ago:
You have to startup database nomount.
Then restore controlfile.
Then alter database mount.
Then restore database.
ltiu
DENNIS WILLIAMS wrote:
Babu
I agree with Jay, you need to create symbolic links that mimic the
locations RMAN hopes to find the backup files.
I was unable to get RMAN to restore the control file. The problem I
encountered was that RMAN required the target database to be mounted first,
but without a control file I couldn't mount the database. Someone the list
reported that this was possible, but I finally just said that it was easier
to create a backup control file outside RMAN and use that.
The RMAN information needed to restore is probably still available in the
control file. I found that to simplify the type of recovery you are
attempting.
RMAN will need the archive logs that were created during the time it was
performing the backup in order to get the data files back to the same SCN.
This task took me awhile, so be patient.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 05, 2002 7:13 PM
To: Multiple recipients of list ORACLE-L
Dear List,
Iam following the procedure to restore database from RMAN backup from HOST_A
to HOST_B with a recovery catalog.
1. I copied the init.ora file to HOST_B
2. on HOST_B, I made an entry in oratab for 'rtest' database and switch to
'rtest' database using . oraenv
3. issued: rman target / catalog rman/rman@Connect String
4. startup nomount;
5. run {
allocate channel ch1 type 'sbt_tape';
restore controlfile;
}
It generates the following error. list backup of controlfile is showing up
the backup entries.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle=nre1u1kk_1_1, parms=
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Backup file not found.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Could someone help me in resolving the issue.
Thanks,
-- Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle on Win platforms
The best way to know is to actually do it. ltiu Richard Huntley wrote: A co-worker, neither a dba nor a developer, was able to successfully install 8.1.7 Personal Edition on 98 with no problems at all. I wonder if the same would work on ME, since 98SE and ME are like twin brothers from what I can tell. -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 7:44 AM To: Multiple recipients of list ORACLE-L Subject: Oracle on Win platforms Just a quickie, please, folks - I have used Win NT4 for years, but have now got Win98SE on a second PC. (Don't mention XP...) Which versions of Oracle will load to 98? Single user only, stand-alone machine (no networking). On attempting to load 7.3.4 an 'unsuported' message pops up, which wasn't exactly confidence inspiring... thanks, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 DBAs Need Jobs
Hello, This is very unfortunate. If you don't mind, where are your jobs moving to? Which country? Have you guys considered doing consulting/education/training work since you guys have quite a bit of experience? ltiu [EMAIL PROTECTED] wrote: Our company just gave us notice that they are moving our jobs off shore. My group is made up of 5 very experienced DBAs. Any help finding new jobs would be greatly appreciated. I have included my resume'. Thanks guys and gals. Linda Miller-Coker Home: (281) 252-0023 CAREER OBJECTIVE To be associated with a progressive, dynamic corporation that offers long term growth and career advancement using my technical skills and experience. EXPERIENCE March 1999 JPMorganChase to Present Senior Data Architect Responsible for data modeling, analyzing, designing, and implementing database applications and data warehouses using Oracle's database and tools including Discover. Implemented large data warehouses taking advantage of partitioning, material views and other 8I/9I features. Responsible for the installing, monitoring and supporting Oracle products on NT and UNIX. Design and implemented databases using Internet technologies Websphere/JSP, Vignette and Story Server. Configured and Maintain Websphere server running on NT. Migrated databases from Access, SQLServer, SyBase and 7.3 databases to Oracle 8I and 9I. Dec. 1990 Texaco Group, Inc. to March 1999 Senior Database Administrator Responsible for the installation and support of Oracle products on NT and UNIX. Responsible for the selection and implementation of Platinum's data manipulation and monitoring products. Application Development Developed a Geoscience application using Designer 2000 and Oracle's Developer 2000. Data Analyst Developed data strategies for Texaco departments, Caltex Pacfic Indonesia and Star Enterprise. Designed a SAP data warehouse. Instructor for Information Analysis I and II. Texaco's internal data modeling and database design courses. Beta Test Oracle Products such as Designer 2000, Oracle's Web Server, Developer 2000 and Web Forms. Chairperson for the Texaco/Star Enterprise Oracle User Group. Jan. 1990 toDeloitte Touche Dec. 1990 Database Consultant/Marketing Support Responsible for Oracle business development as well as functioning as a database consultant. Developed business plan to introduce company to prospective Oracle clients. Created advertisements for regional publications. Also responsible for preparing software proposals and making technical presentations. Dec. 1987 toAnadarko Petroleum Jan. 1990 Application Analyst Responsible for data modeling, analyzing, designing, and implementing database applications using Oracle's database and tools. Aug. 1983 toUnisys Corporation Dec. 1987 System Specialist/Consultant Functioned as a business solution consultant to customer and sales personnel by answering their varied questions about software products and programs, counseling them technically on product installations, modifications to software proposals and making technical presentations to customers. Dec. 1981 toSouthwest Electric Company Aug. 1983 Programmer Analyst EDUCATION May 1988University of Houston Masters of Business Administration Dec. 1981 University of New Mexico Bachelor of Business Administration Concentration: Business Computer Systems Minor in Accounting RECENT TECHNICAL TRAINING Oracle's Enterprise Manager Oracle9I New Functions and Features Vignette Content Management Server Using JSP Oracle's Develop Applications with Java -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
Re: Dev tools for web-based apps
Hello, Oracle's Developer Suite is available for free to developers as well as for educational use. It's good enough. You may want to look at Forte for java from Sun for your Java needs. It integrates well with Oracle using JDBC Thin Driver. ltiu Webber Valerie H wrote: What development tools (Oracle Forms, Java/JDeveloper) are your shops using to deploy new applications to the web? Or what Oracle tool would you recommend to Developers? My client is wanting to re-design an application (currently written in C) using Oracle Forms (partly due to a shorter learning curve with Forms.) The application will contain a great deal of complex business rules and consistency checks. I might add that product in production date is late 2005. I have concerns about Forms' performance issues in running a huge applet and mainly Forms' life expectancy. It appears to me that Oracle's focus and future is with Java and JDeveloper. Am I off base here? Thanks in advance! Val *Valerie H. Webber* Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: connect to the databases without using tnsnames.ora?
Actually, I am talking about my experince with Forte for Java. When establishing a connection to a database using a GUI. It will ask you for the username, password and SID as well as server name or IP address, and then it connects. I am completely oblivious as to where it keeps the parameters I have given it to I'm assuming it stores it somewhere. Not strictly a tnsnames.ora file but a config file somewhere that's specific to Forte. I also have the same experience with JDeveloper. What I meant is that JDBC itself does not use tnsnames.ora but something like it. Thanks for clarifying. ltiu Naveen Nahata wrote: JDBC Oracle thin driver DOES NOT require any config file. The connection url needs to be of the form jdbc:oracle:thin:@host:port:SID Naveen -Original Message- Sent: Friday, September 06, 2002 9:33 PM To: Multiple recipients of list ORACLE-L Are you talking about the JDBC Oracle Thin Driver? This is because you configure it separately. It still has a tnsnames.ora type config somewhere hidden in it's own config file. Just that it does not use the regular tnsnames.ora. ltiu DENNIS WILLIAMS wrote: Cc I believe the Java thin client can connect without using the tnsnames.ora file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Does anyone here knows how to setup the connections to the database server without using tnsnames.ora? Our DBA didn't use it. But I don't know how and why? Could anyone tell me the other options? Cc Harvest __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: connect to the databases without using tnsnames.ora?
This is interesting!! I'll give it a try. Thanks. ltiu Adams, Matthew (GEA, MABG, 088130) wrote: No it does not. try the following from the command line (with no tnsnames.ora file) (substitute valid values for machine, port, sid, etc) sqlplus username@(description=(address=(protocol=tcp)(host=machine1)(port=1521))(connect_data=(sid=sid1))) it will work. A similar syntax can be used in defining database links, by passing all need for tnsnames.ora file Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: connect to the databases without using tnsnames.ora? What do you mean by mistakenly require a TNSNAMES.ORA file ? The TNSNAMES.ORA file is required unless you are using either of a) Oracle Names b) Thin Java client Hemant At 06:38 AM 06-09-02 -0800, you wrote: As an FYI, some 3rd-party products still mistakenly require a TNSNAMES.ORA file. Quest's QCO (at least 2.0, haven't D/L'd 2.1 yet and Quest Support tells me it will be fixed in 3.0 next Q1) is one of them. Also, there is at least one circumstance that requires a TNSNAMES.ORA on a server. I can't remember for the life of me what it is, but something with the Intelligent Agent sticks in my head. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, September 05, 2002 10:28 PM To: Multiple recipients of list ORACLE-L -Original Message- From: CC Harvest [mailto:[EMAIL PROTECTED]] Does anyone here knows how to setup the connections to the database server without using tnsnames.ora? Our DBA didn't use it. But I don't know how and why? Could anyone tell me the other options? To add to what other posters have said: If the DBA was indeed using Oracle Names, you would see the configuration parameters for the names server in the sqlnet.ora file, which would be in the same directory where you would expect to find the tnsnames.ora file. -- 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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recreate database script
Export can do this. Right? But the output is not a script but a binary file only Import can understand. ltiu Connie Milliken wrote: Does anyone have a script that will write another script to recreate a particular database quickly with all the info specific to that particular database? Seems to me that I have seen this somewhere before, but I am not sure where. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql loader loads - what is the name of the counterpart that exports
Hello guys, I just blurted out my whole message in the subject line. Here it is again? Sql loader loads - what is the name of the counterpart that exports Oracle data in plain text? Export and Import does not handle plain ascii - these handle their own proprietary binary format, which utility can export Oracle data out from an Oracle database to a plain text file in comma-delimited format? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sql loader loads - what is the name of the counterpart that exports
So Oracle thinks that people will only move into Oracle and not out of Oracle. Which makes me think. Is there a utility available in other DB's that can extract Oracle data out in plain text? To put this question in another way, how do you transfer data between different database vendors? Are there utilities out there that allows you to export and import data to and from other types of databases - Oracle to DB2 to MS SQL to Oracle ? Thanks. ltiu Philip Douglass wrote: No such beast. But you can roll your own... :) Tom Kyte has a page that directly addresses this: http://govt.oracle.com/~tkyte/flat/index.html -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 2:05 PM exports Hello guys, I just blurted out my whole message in the subject line. Here it is again? Sql loader loads - what is the name of the counterpart that exports Oracle data in plain text? Export and Import does not handle plain ascii - these handle their own proprietary binary format, which utility can export Oracle data out from an Oracle database to a plain text file in comma-delimited format? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sql loader loads - what is the name of the counterpart that exports
OK. Very good. Wow!! Yes, this is what I am looking for. Thank you very much. ltiu [EMAIL PROTECTED] wrote: It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200, set record delimiter = ',' or '|' and set feedback off; and termout on. This should produce an ASCII file once you supply your own query. RWB ltiu [EMAIL PROTECTED]@fatcity.com on 09/05/2002 01:05:07 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: exports Hello guys, I just blurted out my whole message in the subject line. Here it is again? Sql loader loads - what is the name of the counterpart that exports Oracle data in plain text? Export and Import does not handle plain ascii - these handle their own proprietary binary format, which utility can export Oracle data out from an Oracle database to a plain text file in comma-delimited format? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sql loader loads - what is the name of the counterpart that e
Thanks. Good one. Deshpande, Kirti wrote: Click on Dump Tables To Flat File at http://www.cybcon.com/~jkstill/util/ - Kirti -Original Message- Sent: Thursday, September 05, 2002 2:12 PM To: Multiple recipients of list ORACLE-L exports OK. Very good. Wow!! Yes, this is what I am looking for. Thank you very much. ltiu [EMAIL PROTECTED] wrote: It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200, set record delimiter = ',' or '|' and set feedback off; and termout on. This should produce an ASCII file once you supply your own query. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sql loader loads - what is the name of the counterpart that exports
Thanks. Now I need to get M$ just to get Oracle to work for me. ltiu Farnsworth, Dave wrote: Hate to say it but the M$ DTS utility works really nice for moving data between different platforms. You can move data directly from DB2 to Oracle if you want. It is not good for the very huge tables though. But if you need a quick transfer I can have a DTS setup in a minute or two. Dave -Original Message- Sent: Thursday, September 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L exports So Oracle thinks that people will only move into Oracle and not out of Oracle. Which makes me think. Is there a utility available in other DB's that can extract Oracle data out in plain text? To put this question in another way, how do you transfer data between different database vendors? Are there utilities out there that allows you to export and import data to and from other types of databases - Oracle to DB2 to MS SQL to Oracle ? Thanks. ltiu Philip Douglass wrote: No such beast. But you can roll your own... :) Tom Kyte has a page that directly addresses this: http://govt.oracle.com/~tkyte/flat/index.html -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 2:05 PM exports Hello guys, I just blurted out my whole message in the subject line. Here it is again? Sql loader loads - what is the name of the counterpart that exports Oracle data in plain text? Export and Import does not handle plain ascii - these handle their own proprietary binary format, which utility can export Oracle data out from an Oracle database to a plain text file in comma-delimited format? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default Location of RMAN backup sets
OK guys. I found it. Starting up RMAN with recovery catalog. the list backup command will list the backups and the locations and the file names. ltiu On Friday 30 August 2002 22:13, ltiu wrote: What's the file name format of the RMAN backup set? I see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 10:28 PM Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Great Oracle Developer/Admin Tool
Hey guys, This one is good!! Runs on Linux and Windows and maybe Solaris too. http://www.globecom.se/tora/overview.htm http://www.globecom.se/tora http://sourceforge.net/project/showfiles.php?group_id=16636 ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Summary: Oracle thin driver for Forte for Java version 4
Hello, It's found in: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html Thanks. ltiu On Friday 30 August 2002 23:03, ltiu wrote: Hello guys, Forte for Java version 4 comes with jdbc to odbc driver (Windows only!??!). But it does not come with the Oracle thin driver to connect directly to an Oracle instance through the listener. Does anyone here know where to get this? Thanks for any info. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LIST ADMIN: VIRUS Warning: Please Repsond
Next question is, how did this happen? ltiu Mercadante, Thomas F wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find.
Re: LIST ADMIN: VIRUS Warning: Please Repsond
Lotus Notes is good enough and for a time were the number one (and the only one). How the hell did they lose market share? ltiu On Friday 30 August 2002 08:28, April Wells wrote: found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
Re: SQL*Plus in 10i
Nooo!!! On Friday 30 August 2002 09:23, Freeman, Robert wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL*Plus in 10i
oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL*Plus in 10i
Why not? It's easy to use. It will increase Oracle's market share to the dumb and dumber. ltiu On Friday 30 August 2002 12:24, you wrote: oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL*Plus in 10i
Rumor ... They might as well buy SUN along the way (and get rid of Java for good). SUN's market cap is only $13B. MS got $300B. On Friday 30 August 2002 12:44, Gogala, Mladen wrote: Connected to that, there is a rumor tha M$ will buy Oracle Corp., with Larry Ellison taking the place of Steve Ballmer. -Original Message- Sent: Friday, August 30, 2002 3:24 PM To: Multiple recipients of list ORACLE-L oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL*Plus in 10i
I wonder why there is no Oradim under Unix/Linux? ltiu On Friday 30 August 2002 19:23, Rachel Carmichael wrote: does oradim work in Unix boxes? I've never used it And it took a LOT of releases and warnings before they got rid of svrmgr.. they started saying it was going away in version 7 I believe. --- ltiu [EMAIL PROTECTED] wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Default Location of RMAN backup sets
Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default Location of RMAN backup sets
What's the file name format of the RMAN backup set? I see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 10:28 PM Hello, I took an RMAN backup of a database (for testing purpose only, thank goodness). The question is, where did RMAN put the backup set files? I read through an RMAN book and the official Oracle RMAN User Guide and neither mentions the location of the RMAN backup ?!! Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 thin driver for Forte for Java version 4
Hello guys, Forte for Java version 4 comes with jdbc to odbc driver (Windows only!??!). But it does not come with the Oracle thin driver to connect directly to an Oracle instance through the listener. Does anyone here know where to get this? Thanks for any info. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any do's and dont's for a 9i oracle installation on RedHat Linux
I got 9i release 2 running successfully on a RH7.2 and 7.3 system with no install or runtime problems. I also got release 2 to run without any problems on a Mandrake 8.1 and Mandrake 8.2. No surprise since Mandrake is based on RedHat. ltiu On Thursday 29 August 2002 03:08, Docherty, Heather wrote: I am installing RedHat Linux and oracle 9i on two RM servers. I have never run Linux before. I usually run HP L-class or Sun Sparc servers with 8/8i. I would welcome emails with tips anybody has for avoiding anything I don't know that I should be avoiding yet, if you see what I mean! OT: Does anyone know why running startx, after boot-up to a Linux text prompt, causes the shutdown -r to hang the box and not reboot? Heather Napier University Edinburgh, Scotland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LIST ADMIN: VIRUS Warning: Please Repsond
What are you trying to communicate to us. There is nothing in your mail. [EMAIL PROTECTED] wrote: Hi, I recieved an email today as follows: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AW: Oracle Application Server BUT how about 11i
I'm confused too. What's 11i?? Is this an SAP-like application? How does it tei to 9i DB and 9i AS? Thanks for any input. ltiu Stefan Jahnke wrote: Hi I always thought iAS refers to a whole suite of things. The webserver (which is an Apache in iAS) is one component. But there is more to it like J2EE containers, a servlet engine, mod_perl (?), messaging and other stuff (haven't really into anything besides J2EE EJB containers, the web server and the servlet engine..). regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] *visit our website: http://www.bov.de http://www.bov.de/* *subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp* *Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73!* Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- *Von:* Alessandro Guimaraes [mailto:[EMAIL PROTECTED]] *Gesendet:* Donnerstag, 29. August 2002 15:23 *An:* Multiple recipients of list ORACLE-L *Betreff:* Re: Oracle Application Server Hi, IAS - Apache OAS- SpyGlass OAS and iAS are webservers. iAS is basically the same as OAS, but the major difference is the listener is an Apache, and from cartridges to modules. iAS is more or less the 'next generation' of OAS as Oracle8i was the next generation of Oracle8. Regards, Alessandro Guimaraes *From:* Boivin, Patrice J mailto:[EMAIL PROTECTED] *To:* Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] *Sent:* Thursday, August 29, 2002 5:28 AM *Subject:* RE: Oracle Application Server there was a discussion re. the OWS/OAS/OWAS/iAS versions a week or two ago on this list. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- *From:* sultan [mailto:[EMAIL PROTECTED]] *Sent:* Thursday, August 29, 2002 3:50 AM *To:* Multiple recipients of list ORACLE-L *Subject:* Oracle Application Server Hi friends I would like to know is there any difference between Oracle Application Server and Oracle 9i Application server.? If there is difference ,then what is the First version of Oracle 9i Application Server? The term is confusing me. Any one clarrify me please. Thanks in advance syed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LIST ADMIN: VIRUS Warning: Please Repsond
Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROWNUM strangeness?
Holes in your extents/segments. Normal. You get this after repeated updates/deletes/inserts. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AW: Oracle Application Server BUT how about 11i
Thanks. So does this mean 12i or 13i will be a combo between the Oracle DB and the Oracle E-Biz (can I hear people say integration)? If this happens then SAP is toast! ltiu Inka Bezdziecka wrote: Oracle '11i' is E-Business Suite of Applications (yes, SAP like). It uses iAS (which is just a web server) as one of components. It requires two Oracle RDBMS technology stacks: 8.0.6 and 8.1.7 - it is very likely that for the latest release a database itself can be upgraded from 8.1.7 to 9i. If you need details check appsnet.oracle.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROWNUM strangeness?
Actually. Scratch my previous email on this matter. We have seen this problem before and I couldn't figure out how to fix it. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i Rel1 on SuSE 8.0 Pro
My first suggestion would be to try release 2. Second suggestion is that your new hard drive is defective. ltiu Joe A Cairns wrote: Help!!! I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro. The installation went fine, but the database keeps getting corrupted data blocks. Does anybody know why this keeps happing. I had thing running before and then I had a disk drive crash. 30.7 gig drive). replaced the drive, reinstalled everything and now keep getting corrupted datablock problems. Of course Oracle won't give me any support because of the OS version. I logged a TAR and they closed it. Has anyone else seen this problem; Here is my Config: AMD XP 1800+ MSI K7 Turbo2 Montherboard 1.2 GIG Memory 80 GIG Drive 30 GIG Drive SuSE 8.0 Pro Oracle 9.0.1 (RDBMS) Thanks in advance for your help. Joe Cairns -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LIST ADMIN: VIRUS Warning: Please Repsond
Linux or MacOSX are good alternatives for the end user. ltiu kkennedy wrote: You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROWNUM strangeness?
I agree. I got confused and my second email to disregard my erroneous first emai on this matterl was apparently shot down by the mail filters so it never got to you guys in time. Sorry for the confision. ltiu Fink, Dan wrote: Actually, ROWNUM has nothing to do with extents/segments/inserts/updates/deletes. It is all about access paths. The solution posted makes sense as ROWNUM can be affected by many subsequent operations. -Original Message- Sent: Thursday, August 29, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Holes in your extents/segments. Normal. You get this after repeated updates/deletes/inserts. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ROWNUM strangeness?
Yes sir. Paul Baumgartel wrote: I believe you have ROWNUM confused with ROWID. --- ltiu [EMAIL PROTECTED] wrote: Holes in your extents/segments. Normal. You get this after repeated updates/deletes/inserts. ltiu Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
No. Not really. I stand corrected. Got confused again. ltiu Seefelt, Beth wrote: Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
Plain ext3 = No. Adriano Freire wrote: My question is only this: Linux 7.3 REDHAT with ext3 work with datafiles or = 2Gb? If is true. How? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Select count(name) from table group by name where count(name) = 1
Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about distinct and unique, but this is not what I want. All I want is to be able to fish out the names of the people who have only one and exactly only one entry in the list. I do not want the names of those people who have more than one entry in the list. Could one of you do me a huge favor give me some hints as to how to contruct the select statement for this. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: basic Unix question ???
uname -an Janet Linsy wrote: Hi all, I have two questions. First, how to find out information about my unix box, like version, etc. In my box, I can use hostname to get the machine name. I remember there is a command called version, but I got Ksh: version: not found. Any other useful commands to know about my machine? Actually when I use top, it also returns ksh: top: not found. My second question is where does ksh usually reside, which value should I set for PATH. Thank you in advance. Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: working with datafile 2Gb in HadHat 7.3
If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support 2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Select count(name) from table group by name where count(name)
Thanks. It's the Having clause. Khedr, Waleed wrote: select name from table group by name having count(*) = 1 -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about distinct and unique, but this is not what I want. All I want is to be able to fish out the names of the people who have only one and exactly only one entry in the list. I do not want the names of those people who have more than one entry in the list. Could one of you do me a huge favor give me some hints as to how to contruct the select statement for this. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Select count(name) from table group by name where count(name)
Thanks. On Thursday 29 August 2002 16:47, you wrote: Use HAVING count(name) = 1 Example from our good friend scott.emp SQL select job, count(job) 2 from emp 3 group by job; JOB COUNT(JOB) - -- ANALYST2 CLERK 4 MANAGER3 PRESIDENT 1 SALESMAN 4 0 6 rows selected. SQL i 4 having count(job) = 1 5 SQL l 1 select job, count(job) 2 from emp 3 group by job 4* having count(job) = 1 SQL / JOB COUNT(JOB) - -- PRESIDENT 1 -Original Message- Sent: Thursday, August 29, 2002 4:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about distinct and unique, but this is not what I want. All I want is to be able to fish out the names of the people who have only one and exactly only one entry in the list. I do not want the names of those people who have more than one entry in the list. Could one of you do me a huge favor give me some hints as to how to contruct the select statement for this. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Select count(name) from table group by name where count(name)
Thanks. On Thursday 29 August 2002 16:47, you wrote: You use having count(name)=1 instead of where count(name)=1. -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about distinct and unique, but this is not what I want. All I want is to be able to fish out the names of the people who have only one and exactly only one entry in the list. I do not want the names of those people who have more than one entry in the list. Could one of you do me a huge favor give me some hints as to how to contruct the select statement for this. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: What is an API?
What's CPIM? ltiu Jamadagni, Rajendra wrote: Application Programming Interface ... http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API http://www.acronymfinder.com/af-query.asp?String=exactAcronym=API Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- *From:* KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] *Sent:* Wednesday, August 28, 2002 1:08 PM *To:* Multiple recipients of list ORACLE-L *Subject:* What is an API? I have read a lot about the term API. I have searched the web and documentation and cannot find API is an abbreviation for? And, I cannot find a definition of what an API is? If someone could help me on this I would appreciate it. All the documentation I have assumes that the reader knows what an API is. Thanks, Ken Janusz, CPIM *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PLSExtProc
PLSExtProc - found in listener.ora and tnsnames.ora - it's got to do with interMedia. What else is it good for? Is this really necessary for an Oracle Database to function? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, what could be the possible reasons for this? Thanks. ltiu On Sunday 18 August 2002 10:18, ltiu wrote: There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
Thank you very much for your informative little tutorial. I appreciate it a lot. I will give it a shot. Thanks. ltiu On Sunday 18 August 2002 12:03, you wrote: The error message in the install.log or make.log files should narrow your choices down, but in general... Underneath $ORACLE_HOME there are several .mk files, which are scripts for the venerable UNIX make command. To find them, you can run the UNIX find command as follows: $ find $ORACLE_HOME -name *.mk -print Within each product subdirectory under $ORACLE_HOME where a lib subdirectory exists, there will usually be two .mk files: one prefixed with env_ and another prefixed with ins_. For example, under the $ORACLE_HOME/rdbms subdirectory, you'll find a lib subdirectory in which resides an env_rdbms.mk file and an ins_rdbms.mk file. The ins_*.mk script is the one you're interested in; it references make script settings in the env_*.mk script, so in the end you're using both scripts anyway, but the ins_*.mk script is the top-level one... Within a make script there are targets defined, which describe how to compile (if necessary! not always necessary) and link an executable. Generally, Oracle defines an overall target called install to compile/link/install all executed defined within, or it defines targets for each specific executable (i.e. target ioracle performs compiles, links, and file-movement for installation of the oracle executable with the ins_rdbms.mk script, etc). To call make from the UNIX command-line to compile, link, and install a new oracle executable, you'd run the following commands: $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk ioracle If you were just going to shotgun both of the executables defined as part of the network product for the server-side, you'd run something like: $ cd $ORACLE_HOME/network/lib $ make -f ins_net_server.mk install ...and make would compile/link/install the tnslsnr and the lsnrctl executables... The error messages you see from the link phase of Oracle software installation in the install.log or make.log scripts come from these make -f ... commands. Check the log files to find out exactly what failed -- using the shotgun method can take a lot of time... :-) Hope this helps... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 11:18 AM There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
Thanks. On Sunday 18 August 2002 12:23, you wrote: genclntsh is a UNIX shell script run by the Oracle installer, so you can debug it like you would any shell script. It is located in $ORACLE_HOME/bin, so go to that directory while logged in as the Oracle software owner in UNIX and simply run the script. Maybe it will duplicate the problem you're observing; maybe not... If you edit/view the script file, you'll see a set -x command near the top, which is commented out by default. Un-comment it and the shell will output each shell command as it executes -- should help pinpoint where the problem is occuring and may even pinpoint what the problem is... Hope this helps... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
Thanks. On Sunday 18 August 2002 12:03, you wrote: Huge symbol tables, slow PCI 133 RAM, insufficient L2 cache, weak CPU, an enormous library that you're trying to produce. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Linking
Thanks. On Sunday 18 August 2002 13:43, you wrote: Don't forget about the relink script in $ORACLE_HOME/bin. This is new starting with 8.1.7 (I think). From the script... #!/bin/sh # #NAME # relink # #DESCRIPTION # performs manual relinking of Oracle product executables based # on what has been installed in the ORACLE_HOME. # script calls appropriate makefile targets for the following # accepted script parameters: # all -- everything which has been installed # oracle -- oracle database executable only # network -- net_client, net_server, cman, names # client -- net_client, otrace, plsql # client_sharedlib # interMedia -- ctx # precomp -- all precompilers which have been installed # utilities -- utilities # oemagent -- oemagent, odg # Ron Thomas Hypercom, Inc [EMAIL PROTECTED] If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro [EMAIL PROTECTED] To: [EMAIL PROTECTED] 08/18/02 11:18 AMcc: Please respond toSubject: Re: Oracle Linking ORACLE-L If linking is stuck at genclntsh, 100% cpu utilization, no disk activity, what could be the possible reasons for this? Thanks. ltiu On Sunday 18 August 2002 10:18, ltiu wrote: There is apparently two stages to the Oracle installation on Unix. A file copying installation where all the required binaries are copied from cdrom to hard disk and a linking install where the binary/object files are linked. If the first stage succeeds but the second stage does not. How do I start the linking install without having to go through the first stage copying install again? Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Linking during instllations
Linking. During installation of Oracle on Unix/Linux, the installer links 'things'. What are these things that are being linked and why link them during installation? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linking during instllations
I do not understand? Why is this unecessary on the Windows platform? Thanks for any input. ltiu On Saturday 17 August 2002 18:43, Ray Stell wrote: Note:131321.1 Relinking Oracle Background: Applications for UNIX are generally not distributed as complete executables. Oracle, like many application vendors who create products for UNIX, distribute individual object files, library archives of object files, and some source files which then get relinked at the operating system level during installation to create usable executables. This guarantees a reliable integration with functions provided by the OS system libraries. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Out of Memory
I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Out of Memory
Aha!!! I actually copied the init.ora file over from a Oracle9i database and I had to rename db_cache_size to db_block_buffers. Guess, what, now I remember - db_block_buffers are in blocks and db_cache_size are in bytes. So I simply renamed the parameter without changing the number : Thanks man!!! ltiu On Saturday 17 August 2002 21:08, Ji, Richard wrote: Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=32767 6) initSID.ora JAVA_POOL_SIZE=0 LARGE_POOL_SIZE=0 SHARED_POOL_SIZE=2097152 SORT_AREA_SIZE=262144 db_block_buffers=1048576 log_buffer=1048576 Can someone give me some tips as to where I need to look next. My system is not running DT/CDE/OW GUI so there is plenty of memory available for Oracle, about 81MB Ram and the whole Swap at system startup before I start Oracle. How come Oracle still insists I am out of memory? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data Warehouse on Windows
Unisys. Quoting [EMAIL PROTECTED]: Antje, Forgot to mention: The mgrs do know the memory limitations on Windows don't they, as DW are very memory hungry? Jared Sackwitz, Antje [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2002 06:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data Warehouse on Windows Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The os-system is set and cannot be Unix/Linux according to management decision. Any tips/recommendations appreciated Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 vs. DB2
People like to work(and are more effective) in an environment they are comfortable with, may it be Cobol Mainframe, RPG AS/400, MS SQL Server, MySQL, Oracle or Sybase. The point here is not which one is the best database, but which combination of database and people(talent/skill) can give you the best return on investment. Pointless having to use DB2 if your people don't know anything about DB2 - even if DB2 is the best, you still can't get it off the ground if you do not have the poeple to work it. Same goes for the other databases. If you need to evaluate which is the best database, evaluate it based on which is the best database for you (databse and people included). Even MS Access can fly to the moon if you have good people working it. ltiu Quoting Steven Lembark [EMAIL PROTECTED]: One thing that seems different to me: DBA's at the sites we work in with DB2 seem to swear by it more than at it. This is the reverse ratio I find at Oracle houses. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 vs. DB2
But then this is an Oracle email list. What do you know, Oracle is da Best!! Quoting Igor Neyman [EMAIL PROTECTED]: Even MS Access can fly to the moon if you have good people working it. I wouldn't bet my money on that :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 12:08 PM People like to work(and are more effective) in an environment they are comfortable with, may it be Cobol Mainframe, RPG AS/400, MS SQL Server, MySQL, Oracle or Sybase. The point here is not which one is the best database, but which combination of database and people(talent/skill) can give you the best return on investment. Pointless having to use DB2 if your people don't know anything about DB2 - even if DB2 is the best, you still can't get it off the ground if you do not have the poeple to work it. Same goes for the other databases. If you need to evaluate which is the best database, evaluate it based on which is the best database for you (databse and people included). Even MS Access can fly to the moon if you have good people working it. ltiu Quoting Steven Lembark [EMAIL PROTECTED]: One thing that seems different to me: DBA's at the sites we work in with DB2 seem to swear by it more than at it. This is the reverse ratio I find at Oracle houses. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apple rack-mounted servers
It was mentioned in a different thread that Oracle had the most supported platforms minus Apple OS and BSD(Free, Open,and Net). Quoting Joe Raube [EMAIL PROTECTED]: Yes, FreeBSD... Since when do Oracle products work on FreeBSD? -Joe --- Grabowy, Chris [EMAIL PROTECTED] wrote: It is based on some *NIX variant...was it FreeBSD? __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Apple rack-mounted servers
Hey Tom, You mention that you are replacing 10 macOS servers. I did not know that MacOS 'had' servers before MacOS X came out. What OS are these running? ltiu Quoting Tom Schruefer [EMAIL PROTECTED]: Interesting. Has anyone purchased and/or installed one of these X Servers? Being essentially UNIX, I'd prefer one of these over a MacOS server or WinXX. Background, we are looking to replace about 10 MacOS servers in our High Schools right now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice J Sent: Tuesday, August 13, 2002 1:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Apple rack-mounted servers No longer OT! Oracle says 9I will run on Apple's new servers? http://www.apple.com/xserve/reaction.html Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 13, 2002 12:45 PM To: '[EMAIL PROTECTED]' Subject:OT: Apple rack-mounted servers My brother just sent me this link... http://www.apple.com/xserve/ 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: Tom Schruefer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: /etc/system on Sun Solaris 8 for 8i and 9i
How do you know it ran out of resource? What's the error message and when does this appear? During startup, during heavy use or when it's just idle? ltiu On Sunday 11 August 2002 20:08, you wrote: Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, and what is the impact for my Sun Machine if I increase the /etc/system value?? Below is my /etc/system. thanks Ahmadsyah.Alghozi.Nugroho ps: I'm feel sorry for my english.. :( === /etc/system === set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100fdx_cap=1 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set ge:ge_adv_1000autoneg_cap=0 set ge:ge_adv_1000fdx_cap=1 set ge:ge_adv_1000hdx_cap=0 forceload: drv/vxdmp forceload: drv/vxio forceload: drv/vxspec forceload: sys/semsys set semsys:seminfo_semmsl = 500 set semsys:seminfo_semmap = 10 set semsys:seminfo_semmni = 1200 set semsys:seminfo_semmns = 5000 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 forceload: sys/shmsys set shmsys:shminfo_shmmax = 4294967295 set shmsys:shminfo_shmmni = 800 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmseg = 400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Migrating Advanced Queue from 8i (8.1.6.3.0) to 9i (9.0.1.3.0)
Take a look at line 3121 and line 237 of SYS.DBMS_AQADM. This will definitely
give you some clues.
ltiu
On Saturday 03 August 2002 08:38, you wrote:
Hello all,
We have here some advanced queues running under Oracle 8.1.6.3.0.
There is no problem with production.
Now, we're trying Oracle9i (9.0.1.3.0), so we'd installed the Oracle
software and we'd migrated this instance to new version.
Then, this problem arise, because we could not start/stop the queues, all
the commands give the same error below:
The error occur in SQL*Plus (version 8.1.7.0.0) and Oracle manual tell me
to DROP / RECREATE the queue, something impossible in production
enviroment.
SQL EXECUTE DBMS_AQADM.STOP_QUEUE('JSIC.ERROR');
BEGIN DBMS_AQADM.STOP_QUEUE('JSIC.ERROR'); END;
*
ERROR at line 1:
ORA-24026: operation failed, queue JSIC.ERROR has errors
ORA-06512: at SYS.DBMS_AQADM_SYS, line 3121
ORA-06512: at SYS.DBMS_AQADM, line 237
ORA-06512: at line 1
If you'd already experienced this problem please let me know.
You can mail me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
as well.
Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: LINUX and Oracle Corp.
OK. I should try Linux with Oracle then. Cheap(er) alternative. Cheapest would be Linux with Postgresql/MySQL but functionality is not there yet. Price-wise, is the performace of Dell better than Sun? Dollar/performance ? How much (cost) is the Dell and how much is the Sun? ltiu On Saturday 03 August 2002 10:08, Jared Still wrote: On Friday 02 August 2002 20:38, ltiu wrote: RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? 8.1.7 required a bit of work... 9iR1 never did work 9iR2 was fairly simple The Dell is a fast machine with some nice ultra wide SCSI ports. The Sun is a low end server. Dell doesn't have anything that will keep up with Sun's more offerings. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Windows 2000 SP3 License Agreement
I hope PostgresSQL and MySQL will catch up before that happens On Friday 02 August 2002 17:58, you wrote: I wouldn't be one bit surprised if Oracle came out with something similar. Ian MacGregor (X3528) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LINUX and Oracle Corp.
RH 2.7 with Oracle 8 and 9 wow!!! where did you get these beasts to work together? How come Dell Intels outperform Suns. I don't get it? ltiu On Friday 02 August 2002 20:03, you wrote: Mladen and all, I have a Dell 2500 with 2 1GHZ Pentium III's, 2 Gig of RAM and 3 30 Gig RAID1 disk on SCSI. It performs rather well, and will run circles around a lightly loaded 2 CPU Sun 220R we use in production. This is my own personal little DBA playground, running RH 2.7, Oracle 8.1.7 and 9.2. :) Jared On Thursday 01 August 2002 09:03, Gogala, Mladen wrote: Yes and no. If you put in a decent new Adaptec (AHA) SCSI III adapter, it will be capable of working with a 133MHZ or better motherboard and IO will be fast, even faster then on an expensive SUN 4xx servers. Of course, we must be aware that people are putting sound, webcams, game ports and TV cards into their PCs ant that is never a good idea for a database server. Personally, I think that a big SMP PC with a few gigs of RAM and decent SCSI or FC/AL disk farm can easily service 2 or 3 hundred users. One would still need approximately $10,000 to assemble a piece like that, but before that, the prices used to have more zeroes. Of course, there is that little added cost of Oracle RDBMS which will be 2 times as expensive as the HW it's running on and that is really what people don't like. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: LINUX and Oracle Corp. -- Cabansay, Yoyong [EMAIL PROTECTED] on 08/01/02 02:19:10 -0800 regarding the above topic but on a different note, anyone here on the list that is on an Oracle/HP-UX OS platform for backend and 9iAS/Linux on the middle tier? problems encountered? gotchas? stories to tell. we are looking at this configuration right now for our Oracle Apps 11i. Main issue w/ most linux boxes is hardware: PC's stink at I/O due to the Intel motherboard design. The net result tends to be a transfer bottleneck. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Corp. move to India
Then just move on. When shipbiuilding went overseas, we moved on. When textile making moved overseas, we moved on. When mining moved overseas, we moved on. If IT moves overseas, then we just have to move on. Invent something new that will last us the next 20 years then move on again after it moves overseas in 20 years. It's a cycle. ltiu On Thursday 01 August 2002 05:48, Glenn Stauffer wrote: When your government sees evidence that the loss of high skill jobs in this country impacts our prosperity as a nation, perhaps something will be done about it. Until then, if moving operations overseas benefits the corporation and its stock holders, your job (and mine) really doesn't matter much to the people in power. There are thousands who have been down this road before and no one, not the government or the governed (who happily buy anything made anywhere as long as the price is right) cared when steel and fabric mills, shoe factories, electronics factories, and the like all closed up as production went overseas. The fact is that, overall, the economy keeps growing and many people view such events as a natural course in the evolution of a nation. Learn to adjust to the times. When you can't find employment in your chosen field, it is time to re-group and re-engineer yourself for present realities. Unfortunately, like some of my industrial engineering friends, that can often mean working retail into your retirement years. Glenn Stauffer On Wednesday 31 July 2002 04:55 pm, [EMAIL PROTECTED] wrote: I would not treat this snip of news in such a light-hearted manner. Comparing to couple of years ago, the IT job market has slumped completely from a sellers market to a buyer's market. I am not a greedy person by any means and all I asking for is a decent salary and some job security. But if this trend of massive exports of IT jobs overseas continues, I am not sure how many of us will be able to have that. BTW, before firing the slingshots at this E-mail, please note that I am pro-globalization and have heard the arguments about fair market/competition etc. But bear in mind that we are standing on uneven grounds when competing with third world programmers because of the huge housing and living expense differences. Dennis Meng Database Administrator Focal Communications Corp. Gogala, Mladen [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: RE: Oracle Corp. move to India [EMAIL PROTECTED] 07/31/02 03:15 PM Please respond to ORACLE-L Is Larry Ellison learning how to speak Hindi? -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Corp. move to India Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
Re: Oracle Corp. move to India
If you can't bring Indians with H1-B visa over to Oracle, then bring Oracle over to the Indians. On Wednesday 31 July 2002 13:48, Khedr, Waleed wrote: He is learning how to lower development costs, increase his profit margin, and increase US unemployment. Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Corp. move to India
Are you are implying that India can't be better? ltiu On Wednesday 31 July 2002 20:13, Jos Someone wrote: Based on the services we got from Oracle Support there, I can't imagine what the Oracle software will be like if they move the development over there Ray Stell [EMAIL PROTECTED] wrote: Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Unfortunately, MS SQL Server's GUI tools are better in that it is actually useful and it works. How come? Most of my younger peers prefer to use SQL Server (never mind it's shortcomings) simply because it's more GUI than Oracle - hence easier Oracle is losing the future here by screwing up it's GUI tools (my opinion). How I wish TOAD could come to the rescue. ltiu On Wednesday 31 July 2002 23:18, Straub, Dan wrote: You're on target there. Don't start. It's not just a job it's an adventure. I must say that I used the DBCA twice. After cleaning up the mess it made the first time, I just had it create the scripts for me. After 'fixing' the scripts to do it right and give me what I wanted, I've since been able to skip that particular Gooey. Dan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
It did not mention how much is the pay? How much should this type of job pay though? ltiu On Sunday 28 July 2002 08:18, Gesler, Rich wrote: no way! It's all mine...you'll have to find this gem yourself ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
You should email us the comany name too. On Saturday 27 July 2002 07:58, Gesler, Rich wrote: To OCP or not to OCP... I found an interesting Job Description Job description: Oracle Certified OCP DBA 8i and 9i with Des 2000 -Oracle Database Administrator10 plus yrs. experience in IT with at least 5 yrs. as Oracle DBA B.S. and Masters in Computer Science, or related curriculum. Copies of diplomas must accompany the bid response. Failure to do so will result in the bid being declared as non-responsive. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
Homeland security job? On Saturday 27 July 2002 09:18, Khedr, Waleed wrote: It looks like governmental or military position. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: RE: Rant
IBM's latest DB2 claims to do this. Self monitoring, self healing. ltiu Quoting [EMAIL PROTECTED]: Right and the database will tell the end user where to park his/her stupid cartesian product sql statement!! Sometime after I'm dead and buried I'm sure. Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 7/22/2002 12:14 PM What happened to the dream about the database that doesn't need a DBA? Something like that was announced for the version 27i. You know, everything will tune itself, database engine will tap directly into the user's mind and, based on that, define the best possible access path. Of course, the instance would spread iself ideally accross the available disks, allocate the optimum amount of memory, tune its parameters and deinstall any MS Office products from the machine. Sort of Larry Ellison's version of I have a dream speach. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: Rant
Yes. I do. Because they're IBM. Quoting Gogala, Mladen [EMAIL PROTECTED]: Do you believe them? Mladen Gogala Oracle DBA Phone: (203) 459-6855 Email: [EMAIL PROTECTED] -Original Message- From: ltiu [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 6:02 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: RE: Rant IBM's latest DB2 claims to do this. Self monitoring, self healing. ltiu Quoting [EMAIL PROTECTED]: Right and the database will tell the end user where to park his/her stupid cartesian product sql statement!! Sometime after I'm dead and buried I'm sure. Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 7/22/2002 12:14 PM What happened to the dream about the database that doesn't need a DBA? Something like that was announced for the version 27i. You know, everything will tune itself, database engine will tap directly into the user's mind and, based on that, define the best possible access path. Of course, the instance would spread iself ideally accross the available disks, allocate the optimum amount of memory, tune its parameters and deinstall any MS Office products from the machine. Sort of Larry Ellison's version of I have a dream speach. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on Linux ..... Red Hat vs. Suse
Mandrake 8.1/8.2 works really well with Oracle 9i Release 2. It's RH compatible, meaning applications are numerous but it does not have the faulty compiler and it's still free unlike Suse. Downloads are easy to get at as well. A lot easier than RH and Suse. ltiu Quoting Gogala, Mladen [EMAIL PROTECTED]: Well, I switched from RH 6.2 to SuSE 7.2 (now I'm running 8.0) and here are my impressions: 1) RH was using a proprietary compiler (gcc 2.96) and libraries were incompatible with many independent pieces of software. In particular, Oracle installation was a genuine nightmare. No way I'm going back to RH while they're using that @#$! compiler. 2) Availability of software for SuSE is very poor. Nothing on the rpmfind.net, their website is lousy and they are working very hard to make it even worse. In particular, they used to have a subdirectory called full-names where one could find all rpm packages that were officially available for a given release. That was far too easy, so they removed that directory and replaced it with the file INDEX.gz which you are supposed to download, zgrep for the given package and then download it from it's location. 3) SuSE technical support is bad and less then useless. RH wasn't a shining example of customer service either, but SuSE really shows you what the word untermensch really means. 4) SuSE kernel is tainted and is not reporting version the way it's supposed to. That confuses the heck out of the utilities like OSS sound drivers. When I asked SuSE for help they told me to use ALSA (I've paid for OSS and with ALSA my mic was dead as dodo). When further pressed, they told me that kernel relinking is for gurus only and to stay away from that nasty stuff. Eventually, I downloaded a standard kernel, linked it to fit my HW, installed OSS and it worked perfectly. SuSE kernel has completely unexpected dependencies and cannot be compiled easily without the help from SuSE. The latter is impossible to get. 5) Software is installed in curious places (xmms is installed under /usr/X11 so that you cannot use plugin rpms) and is always at least a version behind. Ximian GNOME doesn't work quite well and one needs an expert to do so, otherwise, only KDE is left. 6) SuSE has memory test as one of the booting options which was an extremely convenient thing when I was installing additional memory and my DIMM was bad. 7) The latest RH betas are done with gcc 3.1 which is an official gcc release. As soon as that hits production, I'm switching back to RH, especially now when RH and Oracle Corp. resolved their differences. Mladen Gogala Oracle DBA Phone: (203) 459-6855 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle on Linux . Red Hat vs. Suse -- Christopher Royce [EMAIL PROTECTED] on 07/22/02 08:53:32 -0800 Have been unable to arrive at a definitive position There isn't one. There are tradeoffs between the two distro's. Most of it comes down to which one you are more comfortable with or which one does more things (including the installation) that you cannot fathom. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author
Re: RE: RE: Rant
Yes, of course. Because they are not Oracle. On Monday 22 July 2002 19:08, you wrote: Self-healing... did it have gaping wounds before? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, July 22, 2002 8:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: RE: Rant Yes. I do. Because they're IBM. Quoting Gogala, Mladen [EMAIL PROTECTED]: Do you believe them? Mladen Gogala Oracle DBA Phone: (203) 459-6855 Email: [EMAIL PROTECTED] -Original Message- From: ltiu [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 6:02 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: RE: Rant IBM's latest DB2 claims to do this. Self monitoring, self healing. ltiu Quoting [EMAIL PROTECTED]: Right and the database will tell the end user where to park his/her stupid cartesian product sql statement!! Sometime after I'm dead and buried I'm sure. Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 7/22/2002 12:14 PM What happened to the dream about the database that doesn't need a DBA? Something like that was announced for the version 27i. You know, everything will tune itself, database engine will tap directly into the user's mind and, based on that, define the best possible access path. Of course, the instance would spread iself ideally accross the available disks, allocate the optimum amount of memory, tune its parameters and deinstall any MS Office products from the machine. Sort of Larry Ellison's version of I have a dream speach. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
But do all these matter though? Everyone's moving to MS software and *nixes are getting rarer and rarer. The fact is that everyone's losing money (Sun, IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it or not. ltiu On Monday 15 July 2002 08:33, Andrey Bronfin wrote: Good bet that smaller Unix vendors will run to Linux before vendors like Sun do. Not exactly , just look at homepages of sun , ibm , oracle . There are more appearences of the word linux there than any word in Britannica ;-) DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, July 15, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Jared - Good point. In addition, other costs to an independent Unix vendor are: - Staff costs of a large development staff. This cost doesn't vary, regardless of the number of customers. Therefore, vendors with a small market share have proportionally higher costs. - Costs of attracting software vendors. If the Unix version has a large market share, application software vendors (like Oracle) will gladly port their product to your O.S. However, if your market share is low, vendors are reluctant to support your O.S. Then you are trapped in the chicken-and-egg syndrome (similar to nobody will give me a job because I don't have experience, but how can I get experience without a job). Good bet that smaller Unix vendors will run to Linux before vendors like Sun do. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 12:53 AM To: Multiple recipients of list ORACLE-L I'm sure that many vendors welcome an opportunity to stop paying royalties to ATT for unix code. I believe that all mainstream vendor implementations of unix have ATT base. Jared On Sunday 14 July 2002 11:58, Andrey Bronfin wrote: hi ! i might start another war , but i can't resist a part of me which wants to ask : what do you , seasoned gurus, think of everybody's (as it seems to be) plans to abandon the classic unix for linux ? In particular , most database vendors (as well as other enterprise software vendors) name linux as the future #1 platform for their DBs (especially given the fact that a DB cluster is not rare any more). It also looks like many development shops shift their efforts to develop on windows (or , in some rare cases, linux ) instead of unix . What do you think about this ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - unix vs linux vs windows - the future
Actually they were replaced in my previous company : Not XP though but W2K !!! On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote: Oh yes, and mainframes will all be replaced by XP next year as well. ltiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OT - unix vs linux vs windows - the future But do all these matter though? Everyone's moving to MS software and *nixes are getting rarer and rarer. The fact is that everyone's losing money (Sun, IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it or not. ltiu On Monday 15 July 2002 08:33, Andrey Bronfin wrote: Good bet that smaller Unix vendors will run to Linux before vendors like Sun do. Not exactly , just look at homepages of sun , ibm , oracle . There are more appearences of the word linux there than any word in Britannica ;-) DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
