9iAS v 1.0.2.2.0 Installation Problem
We are trying to install 9iAS 1.0.2.2.0 on a Dell Poweredge 2650 / P4 2Gig, we have succesfully installed this software in older model machines. When we try to run the installer from the distribuition media we get an error that the installer did not run because it was probably aborted and to run setup again. We bypassed this by downloading the OUI 2.8.18.2 (installer 2.2) and that way we were able to run the installation. Everything seems to run fine until we get towards the end a CMD windows is display and it hangs, we closed it manually. Then a new CMD window is displayed and some script flashes trhough, after this the installation gets to 99% and it hangs. The installer shows that is installing a .gif file and it stays there. Can somebody shed some light on me, and prompt me on a solution path? I spent hours serching through Metalink and havn't found anything that helped. I submitted a TAR, but you guys know it may take a while and I'm pressed for time. T.I.A.. Luis Octavio de Urioste Systems Analyst PH. (850) 454.2943 e-mail: [EMAIL PROTECTED] Vertex Aerospace LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste 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: Database Link
You need to configure your TNSNames in your 9i Box. Luis -Original Message- Sent: Monday, September 08, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box) I have created a database link under oracle 8 to oracle 9 database it's working fine from 8 to 9, but when I try to use this link from 9 to 8 it's failed to ORA-12154. Any idea what could be this?? Thanks allot for your help. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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.net -- Author: Luis deUrioste 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: EM To Go
I be Ari Kaplan, designer and creator of Pocket DBA is not very happy. On the other hand he should be, they are following his idea. BTW, you can get a Palm VII [the dinosaur] for about $50 and it has a modem, probably more than you need to monitor a database. $70 with external keyboard. Luis -Original Message- Sent: Monday, September 08, 2003 7:30 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/article/03/09/05/HNorremote_1.html Now if only I had a PDA. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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.net -- Author: Luis deUrioste 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: Results of OCS mailing list survey
I think that is not apathy or des-interest in such a list. I think that OCS has not hit the main stream yet, or maybe there are listers that don't know much about and would like to learn from the posts more. Some of us use this lists as a learning and discovery tool. Don't get discourage. Luis -Original Message- Sent: Thursday, August 28, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Hi folks -- Response to my survey was dismal at best. Am I on that many kill lists? ;-) Anyhow, here are the counts: For: 3 Against: 1 Even though the response was 3:1 for the list, four people will not be able to carry a mailing list, so I will not be adding one at this time. Perhaps as OCS matures, there will be more demand. thanks, bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman 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.net -- Author: Luis deUrioste 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: Forms - as sysdba
Title: RE: Forms - as sysdba What about granting sysdba priviledge to yourself? then you could do everything sys could do! my 0.02 Luis -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 6:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forms - as sysdba One thing to bear in mind for forms development is Oracle does not support connecting as "/" (OPS$). Suhen -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L Subject: Re: Forms - as sysdba As this is Forms 6i, which was around long before "connect '/ as sysdba'" was required, Forms does not know about the new syntax. Try checking on MetaLink for a patch. Jared On Thu, 2003-08-21 at 01:54, Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
Urgent! Is it safe to aply patch Windows2000-KB823980?
Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste Systems Analyst PH. (850) 454.2943 e-mail: [EMAIL PROTECTED] Vertex Aerospace LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste 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: Urgent! Is it safe to aply patch Windows2000-KB823980?
Thanks for your response. -Original Message- Sent: Tuesday, August 19, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste Systems Analyst PH. (850) 454.2943 e-mail: [EMAIL PROTECTED] Vertex Aerospace LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste 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.net -- Author: Luis deUrioste 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 9i and connect as sys
It's the new way, the INN thing. -Original Message- Sent: Saturday, August 16, 2003 10:29 PM To: Multiple recipients of list ORACLE-L I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new 9i feature or if it was configurable? Or just a weird thing because of the mainframe environment. Comments please. Thanks in Advance - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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.net -- Author: Luis deUrioste 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 Metalink
I think they don't like you, Metalink is UP and well. :( -Original Message-From: Shannon St. Dennis [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle Metalink please tell me metalink is down and that they haven't revoked my membership! Shannon St. DennisDatabase AdministratorCity of Regina(306) 777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA
RE: optimizer parameters in Oracle 9.2
10.000 just kidding Supposetly is the new version of the DB 9i, 10G .. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:14 AM To: Multiple recipients of list ORACLE-L For the ignorant, what is 10G? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: optimizer parameters in Oracle 9.2 Please be aware that the paper and presentation were written in the 8i timeframe. I swear I'll get it updated for 9i, but already 10G is looming and it's summer and the weather is nicesigh... on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] wrote: Rich, thanks a lot. I just finished reading Tim's paper and it is truly enjoyable reading. I'm going to test his advices in a few moments. Gene --- Jesse, Rich [EMAIL PROTECTED] wrote: Paging Mr. GormanMr. Tim Gorman... I had wonderful luck with Tim's paper The Search for Intelligent Life in the Cost-Based Optimizer from: http://www.evdbt.com/papers.htm Enjoy! (And thanks again, Tim!) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: optimizer parameters in Oracle 9.2 Hi all: I have been reading on the optimizer_ parameters for Oracle 9i - optimizer_max_permutation, optimizer_index_caching and optimizer_index_cost_adj. I have also been playing whith them and I can see that they affect the explain plans for some queries quite dramatically. Is there any guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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.net -- Author: Luis deUrioste 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
RE: faq broke?
Seems to be Broke -Original Message- Sent: Thursday, July 17, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Is it just me, or . . . I have not been able to search the faq archives all week (www.orfaq.net). When I find a match and try to open it, I get a message Our apologies. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable Is it just me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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.net -- Author: Luis deUrioste 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: should you seperate indexes from tables in seperate datafiles?
I LOVE THIS LIST! A few more personalities (GAJA, ARI, IAN .) opinions added to this discussion and we could publish a paper on this thread alone. Thank you GURUS You are the ones that make monitoring this list worth more than anything ! Luis -Original Message- Sent: Tuesday, July 15, 2003 11:20 AM To: Multiple recipients of list ORACLE-L datafiles? The thing that occurred to me a few years ago (as a result of a test designed by Craig Shallahamer) is that what disks do gets very, very complicated when you add users. On any system busy enough to have a performance problem, the odds are usually slim that a disk is just sitting there waiting for your next I/O call. On a busy system, someone else's I/O call is almost always going to intercede between two of *your* I/O calls. As has been said many times, many ways... - DO separate tables and indexes into different tablespaces. There are lots of reasons you should do this. - DON'T necessarily feel that you have to put the index and data tablespaces on different devices. One decision criterion is performance: don't ever put two files on the same device if the sum of their I/O-per-second rates exceeds the I/O-per-second capacity of the device. Another decision criterion is availability: don't ever put more data on a device than you can recover in your acceptable downtime window. The list goes on... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Daniel Fink Sent: Tuesday, July 15, 2003 11:24 AM To: Multiple recipients of list ORACLE-L I may be way off base here, so any gurus please correct me with a gentle slap to the back of the head... Index and table access is not as simple as index entry..table row..index entry..table row..etc. I just ran a quick test (which may not be represntative and is using the primary key which can be understood as the row number in physical order of the data blocks) and I found (using the sequence of wait events) that there was substantial access to the index datafiles initially, followed by substantial access to the data datafiles. Then another single access to index, multiple access to data, single access to index, multiple access to data. It seems to me that this pattern is read several index blocks, then access several data blocks, read several index blocks, access several data blocks. This may be due to the sequential nature of the pk in the data blocks. It seems that the most efficient algorithm is to read enough index blocks to set up a list of data blocks to read, then go get them. Since you have the index block pinned, don't waste any resource in releasing the pin to pin the data blocks, then repin the index block. The other issue is that indexes can be accessed using multiblock reads (index fast full scan) and tables can be indexed using single block reads (table access by rowid). Garry Gillies wrote: It's hot here. I wish I was at the beach and I feel like a rant. oracle actually accesses indexes and tables serially Is it just me or is this blindingly obvious? You cannot access the table data until you have completed accessing the index data because the index data contains the location of the table data. During an indexed query on a single table the index will be accessed, then the table, then the index,then the table, then the index,then the table then the index,then the table. If the index and the table are on the same disk then a lot of time will be taken up by head seek movement. If they are on the different disks then the index heads can locate their data and stay there - and the data heads can locate their data and stay there. Less head movement, less wasted time. That is the argument for what it is worth. Real life is of course vastly more complex than this and we are swimming in very muddy waters, which is why there is so much argument on the subject (raid salesmen - spit). Thanks for the vent Garry Gillies -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap 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.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego
RE: ER Tools (was: erwin)
There was a Tool I used in the past, Sdesigner, simple to use. Also if all you need is an older version of Designer, what you could always do is buy one of the books that bundle with a copy of developer 2.1 or 6i. -Original Message- Sent: Monday, July 07, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Anyone care to ballpark a $$$ on the registered version of ERwin? I'm guessing it's expensive, and Computer ASSociates doesn't exactly trip my trigger. I'm trying to find a low-cost ER tool in order to get some simple data modeling done. So far, this is what I've found (VERY briefly): 1) Visio. Needs Enterprise edition. The UI is a pain, as far as I'm concerned. Pain, pain, pain. Cheapest viable option so far at less than $500/user. It can be used for more than just data modeling. 2) Oracle 9iDS. Hugely bloated. Relies on a 3GB (minimum) repository for some stupid reason. Apparently can't buy just Designer, which is all we need. Difficult to get started (concepts and management of workspace, container). Slow on a 2.4Ghz PC w/512MB RAM, although this may be due to me having to create the [EMAIL PROTECTED] repository DB on the same PC. Very comprehensive, though, from what I've seen. Can't access drawings from the OS, since they're (probably) in the repository. 3) No freeware tools such as dia, VisioModeler (pre-MS version of Visio), OpenOffice, or Koffice seemed to be able to draw crow's foot diagrams. 4) Sybase PowerBuilder. Didn't check out the download yet, although a demo of an older version (v6) seems like it would work. Not impressed with Sybase in general and it's probably in the $1Ks/user. 5) Data Architect from TheKompany.com only does physical modelling and their Kivio product doesn't seem to support crow's foot. 6) DeZign from datanamic.com. Haven't downloaded the demo yet, but the single screenshot looks promising. And at $149/user or $119/user for 10 licenses, I'm hoping... I've been looking thru past messages found on orafaq.com (better searching than fatcity.com) and this is the majority of what I've been able to find. Anyone have more to add? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: erwin hello: The below has info about the product: http://www3.ca.com/Solutions/Product.asp?ID=260 The below has the download link: http://www3.ca.com/Solutions/Collateral.asp?CID=33655ID=260 From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: erwin Date: Mon, 07 Jul 2003 04:54:25 -0800 How can I found a trial version of erwin Danke... Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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.net -- Author: Luis deUrioste 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: service name, sid ..
The laughof the day . the fecal matter hits the rotary oscillator. -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 2:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: service name, sid .. AK, You can make it as simple or complicated as you want. Personally I prefer the KISS principle. It's easier to troubleshoot when the fecal matter hits the rotary oscillator. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: service name, sid .. Tanel, Thanks for elaborate information , I really liked it . Still why do u need to provide db name in tnsnames, all one should know is which instance to connect . Instance know , which db to connect . why do net8 bother about dbname ? -ak - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, July 03, 2003 10:49 AM Subject: Re: service name, sid . Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create controlfile). You can have several databases with same db_name in one server, there is no restriction. SID - When we actually want to open and use the database, we have to start an instance whichwill be servicing the database. When starting instance, whe have to specify SID (system identifier) for it. This is actually just a operating system name for instance (or should I say SGA shared memory segments). As you know, SID is specified using ORACLE_SID OS environment variable and is only used by listener, when spawning new processesor when attaching directly to SGA using bequeath protocol. You can not have instances with same SID in one server, even if you use different oracle homes. instance_name - An Oracle parameter for specifying Oracle instance name. Seems that operating system doesn't know anything about it.For example, if you use SID_LIST parameters in your listener.ora, then listener always knows how to spawn processes for given SID, because (almost) all it takes to start another server process, is the location of oracle executable and SID value. But if you want to connect using instance name (not SID itself) then Oracle instance actually has to register itself with listener before any server processes can be spawned. Note that ORACLE_SID and instance_name variables do not have to match. (Tested on 9.2.0.1 on W2K). If my SID is ORCL for example and instance_name is TEST, then I can connect using both SID=ORCL and SID=TEST in CONNECT_DATA section of TNSNAMES (again, the instance name has to be registered with listener). V$INSTANCE still shows SID (ORCL) in instance name fielt. As we know, in OPS and RAC environment you could have several instances servicing one database, this is one ofcommon reasons why db_name and instance_name would be different. (ORCL for db_name, ORC0, ORC1, ORC2, etc.. for instance names for example). Btw, does anyone know if I can have the same instance name in all RAC nodes? RAC shouldn't care much, because it uses instance numbers anyway? service_names - this is an additionallayer for logically spreading work across nodes in RAC (and possibly other load balanced environments such replicated databases and even logical standby). For example, if you have 4 node RAC and have defined two "services" such OLTP and REPORTING, then you could assign OLTP for nodes and REPORTING for one, but during month end reporting you could still keep OLTP on 3 nodes, 1 node purely for REPORTING and add REPORTING to one or more OLTPs as well. So, when user's are connecting, they don't request a specific node or instance, they just request a service. And in load balancing environments then users are directed to instances, where appropriate service is defined. It gives somewhat flexibility, but I've never used it myself (thus my explanation here might wrong ;) Cheers, Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 02, 2003 9:49 PM Subject: service name, sid . I am reading oracle network admin guide and getting confused abt service name, instance name , db name , sid . why service name is not same as db name. Earlier service name and sid used to be same thing .. isn't it ( ? ) . Can some one clarify with some examples .
RE: Re[2]: Online tech books
Bless you Bob ! I will use your pictures to settle the argument of too many books with my wife! I told her I reduce my number of books as long as she reduces the number of shoes. She got a bit offensive. Luis -Original Message- Sent: Wednesday, July 02, 2003 10:11 AM To: Multiple recipients of list ORACLE-L Monday, June 30, 2003, 10:39:40 AM, you wrote: BM I just returned frm vacation, but I wanted to respond to Jonathan BM Gennick regarding my collection of books.( I managed to delete that BM message) But, Ive taken some pictures of my collection.. Ive actually BM purchaced all the books you see! BM http://162.42.213.232/books/index.html Wow! Bob, I think you have me beat, and I'm no slouch when it comes to ordering books. Hey, you know what else, as I look very closely at your bookcases, I think you use the same cheap, partical-board-covered-with-paper, bendable-shelf brand that I usegrin. I better get on the stick and order more booksgrin. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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.net -- Author: Luis deUrioste 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: LISTENER ON LINUX
Sounds like a duplicated IP or duplicated Service name. Luis -Original Message- Sent: Wednesday, July 02, 2003 12:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh 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.net -- Author: Luis deUrioste 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: !! *Very* important Oracle-L message !!
Hope I'm not too late, Im in $20 to start and a monthly fee if needed. [EMAIL PROTECTED] wrote: Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase. After some discussions with Jared (the list owner), and some encouragement from him, I am coming to you to ask for you help in keeping Fat City financially afloat until I can be self sufficient. I'm not asking for a specific dollar amount from anyone, nor am I *expecting* anything from you folks. But if it is within your power to contribute some money towards this end (and yes, I know these are hard financial times for everyone), I am hoping you can help. If I can get sufficient promise of funds that will see me through the next few months, I am willing to jump in with both feet and make Fat City a viable business. If it looks like the contributions are not sufficient to enable me to do that, I will cease operations within the next 45-60 days. Let me be clear about a few things: If I *do* cease operations, I will give all of my lists time to find new list providers, and will make every effort to aid the shift over to the new provider, provide list dumps, archives, mail forwarding, etc. Even though Rhythms goes out of business on 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable this to happen. So don't worry about having to rush into your conversion if things don't work out. I would also like to clearly state that this is not some attempt to blackmail or coerce anyone into coming up with money. This will either succeed or fail based on what you folks can comfortably and willingly contribute. If I had the ability to cover this startup period myself, I would definitely do so. If Fat City ultimately goes under, it wil NOT be your fault, and
Re: cleaning up oracle homes on NT
To avoid this problem on cleaning Registry what I do know (after painful rebuilds of machines) is before I install any new Oracle Software, I export (Backup) the oracle key from the registry and save it with a proper description i.e.. Reg_before_9iAS, then I proceed to do the installs etc. etc. If anything goes wrong then I delete the software and restore the registry from the backup. I'm back to where I started. Tavo Boivin, Patrice J wrote: Andrea asked about removing NT services. What about Oracle homes? The Oracle Universal Installer appears to be doing a poor job of cleaning those up when we de-install Oracle software. 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] mailto:[EMAIL PROTECTED] -- 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). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Microsoft IIS
Thanks that was me, since then they decided that Apache was just fine. Tavo [EMAIL PROTECTED] wrote: Someone, I don't remember who, posted a question a week of so ago about connecting to Oracle IAS via IIS instead of the provided Apache server because there damagement was afraid about being hacked. Well, pass the following along to damagement ask them again what they want to do: ** Internet Goes Red The Code Red worm ripped through Internet servers like no other previously unleashed piece of malicious code. We are witnessing Internet history, says Chris Rouland, director of Internet Security Systems X-Force, which tracks Internet vulnerabilities. Based on reports, Code Red has infected over 225,000 servers. The worm enters the targeted server through port 80. If the host is running Microsoft IIS, the worm executes a malformed HTTP get request to try to run a buffer overflow against the Microsoft IIS Indexing Service dynamic-link library. Once the worm successfully exploits the target, it starts searching for new servers to infect, and the compromised Web site is defaced. Code Red's ultimate target was Whithouse.gov. The worm was set to attack the White House Web site July 20 by unleashing a torrent of traffic at the site. According to Rouland, the White House managed to avoid the attack by switching the site's IP address. He says the author of Code Red made a critical design flaw by hard-coding the White House's IP address. That won't happen next time, he warns. When the ILoveYou virus struck last year, many copycats struck in the following weeks. I wouldn't be surprised to see many, many copy cats of this worm, he says. In fact, reports started surfacing Friday afternoon on security mailing list Bugtraq that several versions may already be loose. An explanation of, and patch for, the IIS buffer overflow vulnerability is available at http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20QKW0AK Has this one bit you? Tell other IT folks what you're doing to combat the problem in the Listening Post http://update.informationweek.com/cgi-bin4/flo?y=eD2T0BdFGA0V20Nmm0AD -- 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). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Linux Download and ADSL
What about Cable Modems ? any such service? Mark Leith wrote: LOL me too!! We have tried to get ADSL in our area - Worcester, UK - and have been told by BT that they have No plans to install it in our exchange! Now, Worcester is a City, and I've heard of cases around the country where smaller TOWNS can get hold of ADSL!!! I'm not even going to consider ISDN.. Just a case of sit back and wait, and tweak my Diamond 56k as much as I can.. -Original Message- John (NESL-IT) Sent: Tuesday, July 17, 2001 05:24 To: Multiple recipients of list ORACLE-L My ARSE :o) -Original Message- Sent: 17 July 2001 15:57 To: Multiple recipients of list ORACLE-L UK telecomms is in a hell of state. For most of us the best option is a fast connection at work and a CD writer. Cheers, Mike -- 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Oracle Internet Structure
Dave, I would strongly suggest you get the WEB APPLICATIONS 101 book, by Sten Vesterli , It will bring you up to speed pretty quick. It is very easy to read. Luis. Dave Leach wrote: Hi, I realize I'm way behind on this but can anyone point me to any links which describe the components that make up Oracle's Application Server in a novice way. The sort of things I'm looking for are In simple terms what is an Apps server? What is an Apache Server and how does this integrate with the Apps server? What is the difference between a Web site and Portal? What third party technologies are used with Oracle Apps server?. I have looked on OTN but cannot find something which describes the structure at the level required (ie. a complete novice) As I say I'm a complete novice in this area but our company is just starting to look at a web based solution and I want to get an understanding of what's involved and how this may effect me as a DBA. Any help would be appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Anybody running 9iAS using Microsoft's IIS
Fellow LISTERS, Is anybody running 9iAS on MicroSoft's IIS ? Damagement has reservations on using Apache since it is Open Source. I guess they fear hack attacks. Any information will be highly appreciated. TIA Tavo begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Anyone else get spammed by OraKnowledge.com???
yes, I hate the ^%##()( Grabowy, Chris wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: SQL DISTINCT alternate
What about using UNIQUE Select UNIQUE. Seema Singh wrote: Hi In a sql stmt what will be the impact if we used DISTINCT clause and how we can overcomes on the performance bottleneck caused by DISTINCT. like ... SELECT DISTINCT A,B,C FROM TAB_1 I want to get same output without using distinct?Is this possible?If, YES then how? Thanks in advance -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: OT / LOL/ Serious Question (believe it or not)...
Well I think if we all pitch in a bit, and put out one heck of a book and convince Steven Spielberg to take it to the screen, yes we would be rolling in Do. Oracle from the ground up ! a thriller, starring in order of appearance: The Goddess Rachel Carmichael The Tuner --- Gaja Krishna Vaidyanatha Remote --- Ari Kaplan Store Keeper -- Ian Abramson .. and others, just imagine the movie it would be wicked! oops! Sorry I Just lost it Rachel Carmichael wrote: let's see, I think Dad paid something on the order of $10K to publish his book (about 100 copies). Of course, it was a hard-cover edition. and editors don't come cheap. Alex -- how much money do you really think an author makes on a book??? I'd figure that the average book (and technical books have to be updated about every 18 months) takes about 500 hours to write (this is a number Kevin Loney has come up with and I'm willing to believe him, given his experience) So... as a consultant let's say I work cheap (in NY anyway) for $100/hr 500 hours over a 40 hour week = 12.5 weeks or about 3 months so 500*100 = $50,000 for 3 months, or $200,000 over a year THERE IS NO WAY IN HELL YOU MAKE ANYTHING LIKE THAT AS AN AUTHOR!!! Damn it, best-selling authors don't make that kind of money. Geez, wake up and smell the coffee, technical writing is NOT done to get rich. From: Hillman, Alex [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Serious Question (believe it or not)... Date: Thu, 07 Jun 2001 12:11:00 -0800 I am sure that any of working DBA's have this money to put up front. I don't think that risk to invest in the book is more than in the stock market. Also what is the problem to hire editor (especially not technical). Should not be too expencive. Of cource it is more work, but one can get much more money. Alex Hillman -Original Message- Sent: Thursday, June 07, 2001 3:26 PM To: Multiple recipients of list ORACLE-L self-publishing houses charge you to publish the book (yes, they do, that's how my father-in-law published his book) I also doubt that they give you much in the way of help in editing your book, so that if your English is not good (as the case of the author that Jonathan is working with) you end up with an unreadable book. From: Hillman, Alex [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Serious Question (believe it or not)... Date: Thu, 07 Jun 2001 07:45:49 -0800 I would one of self-publishing houses like Technion where you can get 33% of sales. If your book is any good it will sell in the same volume as with any other publisher (not that they spend a lot of money for promotion any way). Alex Hillman -Original Message- Sent: Thursday, June 07, 2001 4:31 AM To: Multiple recipients of list ORACLE-L First would be to prepare and send a synopsis to the 'big name' oracle publishers - O'Reilly, Wrox and the like.. hth connor --- Jim Hawkins [EMAIL PROTECTED] wrote: All, I am very interested in collaborating with others in the writing of an Oracle technical book (DBA subject matter). I am interested in how those of you who have done this (ala Rachel), got started or made the right connections. I do have a somewhat literary background, so I know I can do this. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?=
Re: LOT (Little OT): Interesting Oracle related URL's.
Authors, and List, I do agree that it is wrong to post papers without permissions etc. etc., but lets not be so harsh. I come from a Third world country (BOLIVIA) where getting up to-date Literature is almost impossible, most all documentation that people work with is obsolete, and this people heavily rely on papers posted somewhere. As far as books you could forget it, the cost of a book here is around $50.oo (101) series that is about 1/3 of their monthly salary. Some of the people that are benefited from this Piracy are college students that one day may become the next GAJA , RACHEL, or KEVIN. Lets remember that the NET's intent was to ease the sharing of information. Please, please lets not be to harsh on the people that post this materials, but lets ask them to give all the credit to the authors and if possible try to get their permission. We are lucky to live in a Country where we can afford to pay for this materials or to pay for conferences etc. other nations are not so lucky. I just had to let it out. Sorry Regardless Friend 4 ever Tavo Gaja Krishna Vaidyanatha wrote: Hi Steve and list, While we are on the subject, I found my RAID paper on multiple sites including this site : http://www.vampired.net/articles/php/concepts.php and I know for a fact that no one has gotten permission from me or IOUG-A, in this regard. Does this not mirror what is done on Marin's site? Gaja --- Steve Adams [EMAIL PROTECTED] wrote: Hi Rachel and list, The person responsible for that site is Marin Dimitrov [mailto:[EMAIL PROTECTED]]. Almost all the papers there are illegal copies (including one of mine). I once asked Marin to explain himself on the matter. His explanation was that the collection was for his personal use only. At the time, he removed the index to make the collection largely invisible to the rest of the net, but it appears to have come back! It can also be seen at http://harbinger.sirma.bg/Oracle/ and an older version is mirrored at http://www.itsystems.lv/gints/files/oracle/oracle.htm. I have copied Marin (and the person responsible for the mirror site) on this mail. Hopefully they will at least remove the indexes again, but I would prefer the papers to disappear too. Maybe if others add their votes to Rachel's and mine they'll take the stuff down. Bulgaria and Latvia may be immune to international copyright law, but individuals are seldom immune to community disapprobation. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 8 June 2001 3:01 To: Multiple recipients of list ORACLE-L I hate to be a spoilsport -- but this link (actually the fact that the paper is on his site) bothers me... DBA101: A Refresher Course http://pillango.sirma.bg/oracle/N092_dba.doc Neither Marlene nor I gave permission for this paper (which is copyrighted) to be posted there. Of course, he is not in the US, so the fact that this is illegal doesn't count. For what it's worth: it is only legal in the US to post a link to a legal copy of this sort of information. It is NOT legal to post copyrighted information without the express permission of the copyright holder. Having said that, I would have gladly sent a copy of the paper to anyone who asked or given permission to post it. But I would prefer to be ASKED. And Mark -- www.oracle-users.com now points you to the NY user group web page, as the company (Oracle User Resources) that sponsored it and the ECO conference, does not exist anymore. Rachel From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOT (Little OT): Interesting Oracle related URL's. Date: Thu, 07 Jun 2001 06:41:43 -0800 Thanks for your input guys - a great help! I had a few already - namely the Guru's of the list (That reminds me of a film title in a way :) But there were a few I didn't have. Here is my list so far.. IXOra.com (Steve Adam's Site) http://ixora.com.au/ Oracle Technet http://technet.oracle.com OraPub (Craig Shallahamer's Website) www.orapub.com DBA Support http://www.dbasupport.com/ Thomas Kyte's Website http://osi.oracle.com/~tkyte/ Connor McDonald's Web Site http://www.oracledba.co.uk/ Hotsos (Cary Millsap's Site) www.hotsos.com Jared Still's Website http://www.cybcon.com/~jkstill/util/util_master.html Thomas Cox's Website http://www.geocities.com/tbcox23/ Evergreen Database Technologies http://www.evdbt.com/ OraBugFinder http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html Vampire D's Oracle Den (Christopher R. Spence's Site) www.vampired.net Johnathan Lewis's excellent site http://www.jlcomp.demon.co.uk Lazy DBA
Re: iAS installation update
Patrice, I've installed 9iAS successfully, what I've done is just run the installer from the CD and on a new machine (virgin OS install) I selected all the defaults, and guess what everything work. In turn 9iAS created an ORACLE home in which there is a 806 and an iSuites directory, apparently when they say the 806 home what they refer to is that directory, the 806 directory seems to be where the tool set (Forms/ Reports) are housed and the iSuites where the Apache server and that stuff is. On a machine with a whole bunch of other ORACLE products, such as DEV 1.6 (FORMS 4.5 / Reports2.5), Designer 2000, Developer 6i and Personal Oracle 8.1.7, I've chosen a different home for each product and everything works fine. Of course a bunch of stuff is duplicated, but who cares Hard drive is cheap, the main thing is that everything works as advertised. When I tried installing everything on default Oracle homes nothing worked and it was a nightmare. My experience from the installs. Good luck Tavo Boivin, Patrice J wrote: FYI, I logged a TAR with Oracle last week or so because one Metalink tech had said in passing that Forms and Reports had to go into its own, separate oracle_home. This follows from a previous TAR I had logged with them, simply asking which products work best together. I had read the installation manual for iAS and had earlier found this: Note: Be sure not to install Oracle9i Application Server in an Oracle_home containing other Oracle products, including the database. Such an installation could overwrite shared components, causing the products to malfunction. (on p. 3-5, 4-5, 5-5). Now, in Oracle Reports Developer Getting Started - Release 6i for Windows, it says: Reports Developer 6i must reside in the default oracle_home. Reports Developer 6i and the Oracle8 or Oracle8i server must reside in separate oracle_Homes, although they can reside on the same physical machine. Similarly, in a web application deployment, Report Server and Oracle Application Server must reside in separate oracle_homes, although they can reside on the same physical machine. (p.1-16) Forms and Reports 6i happen to require an Oracle 8.0.6. oracle_home. This posed a dilemma: how can I install iAS in the default home, when many of its components require access to an origin database. I do not plan to use iAS with 8.0.6., I plan to use it with 8.1.7.. I thought I would have to install Forms and Reports 6i first, remove the tidbits that the Oracle Universal Installer installs by default, then install 8.1.7., and then install the iSuite components. Of course by the end of this tortuous process there were errors. I had a different Metalink technician this time, who told me to ignore what the first technician had said, and to just install iAS based on the installation manual, never mind the other worries that I had. So, I am ignoring the Oracle Reports Developer Getting Started manual, and I am installing based on the iAS installation manual. Hopefully that will work. /begin rant I still wish the Oracle techs could have told me which versions of the various products are concurrent, they just keep insisting that all their products are certified to work together. All I wanted to know was which oracle_home type do the various products use? Forms and Reports 6i requires an 8.0.6. home, Developer6 used an 8.0.5 home, etc. the Metalink techs do not appear to have a list, they didn't understand my question. When I logged a TAR on this I received three e-mails telling me that my TAR had been passed to different people, in the end the last tech told me that products sometimes are released together, but that it is not all that important, because everything is certified to work together. I can't shake the feeling that iAS is a bundle of things that were just slapped together. Seeing the old installer pop up during the installation doesn't help remove that impression. Hopefully when the next release comes out it will install in something other than an (old) Oracle 8.0.6. oracle_home. Since it's called Oracle9i iAS, maybe the Forms and Reports Servers will go into a 9i oracle_home (?). /end rant (this is my impression, not my employer's etc. etc.) Sorry if this comes across as a little harsh. 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] mailto:[EMAIL PROTECTED] -- 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
Re: Windows ME and Net8
I would try using the WIN2K Client CD. Good Luck April Wells wrote: We have several clients, mostly running NT or 98, and we have been able to get Net8 to install fine. Using the same CD, we cannot get it to install on Windows ME. I have been trying to get an answer as to support from Metalink, but so far have been unable to get an answer. Does anyone have any experience one way or another? Thank You April Wells -Original Message- Sent: Monday, June 04, 2001 1:24 PM To: April Wells April, Here is the error message that I received when attempting to install Oracle 8.1.6's Net on Windows ME. there was an problem in accessing the staging area. Please make sure the specified values for 'Source' and 'DESTINATION' are valid. The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: OEM Book Recommendation
The only book that I've found that touches the OEM in an ok way is ORACLE8 on Windows NT by Lilian Hobbs ISBN 1-8-190-0 begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: 16 bit sqlplus cannot connect to PO8i
Rahul, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. Hope it helps. Luis Octavio Rahul wrote: Jkstill, i'm using sql*net 2, and can connect to other 8i database on the AIX machine, but then i installed PO 805 (in another home) , and cannot use the sqlplus to connect to the local DB. (the sqlplus installed under the same home as the database can connect without problems) Regards PS: infact i did mention the platform and oracle version in my earlier mail also. -- From: Jared Still[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: 16 bit sqlplus cannot connect to PO8i On Monday 28 May 2001 11:00, Kimberly Smith wrote: Hey Jraed, Why did you change your name? Sorry, I am bored. Management decided to move us around so I am unpacking. I should change it, as I find Jread much easier to type than Jared. Jraed -Original Message- Sent: Monday, May 28, 2001 10:20 AM To: Multiple recipients of list ORACLE-L If by 16 bit sqlplus you mean version 1 of SqlNet, you can't connect to an 8i database with it. Some version numbers here would help. platform: version of platform: version of Oracle: etc... Jraed On Monday 28 May 2001 00:40, Rahul wrote: List, i'm trying to make a connect to 8i database (installed under orawin95) from a 16 bit sqlplus (installed under orawin) i tried to configure the IPC in listener, the sqlplus in orawin95 is able to connect, but the 16 bit sqlplus returns error...(cant get server error message) +-+-+-++-- LISTENER.ORA LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) ) +-+-+-++-- TNSNAMES.ORA local.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = oracle80) (ARGV0 = oracle80ORCL) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))') ) ) (CONNECT_DATA = (SID = ORCL) ) ) this is win95 and PO805 TIA Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: multiple versions of SQLPlus.exe
Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. Hope it helps. Luis Octavio Farnsworth, Dave wrote: I have a server NT4.0, SP5 that has two versions of Oracle installed. On drive J is Oracle 8.0.5 which is used by a third party app and has been up and running for about a year. This last week I installed on drive E Oracle 8i 8.1.7 and have not yet created a database. This Saturday on of the operations people re-booted this server. That night the app using 8.0.5 had an error. From what I can tell the following happened to cause the app to fail. When the server was re-booted, it reset the PATH setting in the environment in the win.ini file to point oracle to the 8.1.7 version. PATH=E:\ORA817\bin;E:\ORA817\Apache\Perl\5.00503\bin\mswin32-x86; E:\ORA817\Oracle\jre\1.1.7\bin;E:\ORANT\bin;c:\DMI\win32\bin; C:\WINNT\system32;C:\WINNT;E:\COBOL32\EXEDLL;E:\orawin\bin; j:\merant\net express\base\bin;e:\cobol32\exedll The app then tried to execute a batch file that calls sqlplus.exe. This is where the error occurs and the app sits at a sceen wanting a login name and password for sqlplus. Below is the batch file. J: cd \logility\Ora_sql set oracle_sid=LV54 SqlPlus user/pass@lv54 @Qry_Log.sql Notepad.exe qry_log.txt ::Qry_log_show.bat I get this error when the batch file is executed, ora-12154 TNS: Could not resolve service name. I assume that because the path is now set to point at 8.1.7 that sqlplus is now looking at the 8.1.7 tnsnames.ora which currently has no entries for databases. If I edit the PATH setting and put a reference to the 8.0.5 version on J drive, then it works fine but now I get the 8.0.5 sqlplus when I try go to e drive and type sqlplus at the command prompt. Can I have multiple versions of sqlplus that can be called from the command prompt on the same box? Can I have multiple versions of tnsnames.ora? Would I need to include all the database names for each version in every tnsnames.ora file? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Oracle Development Tool
Hi Deepak, This is a good one, we use SQL* NAVIGATOR and TOAD, 2 cents are that on the developer side SQL*Navigator would be a more complete tool, specially if you buy all the bells and whistles available (SQL formatter, Knowledge Base ...), and TOAD would be a better tool on the DBA side of the House. Yes a lot of the functionality is very similar, but the bottom line is that they are two different tools and depends on how you are going to use them. I suggest you download a trial version and call Quest for a technical walkthrough on both of the tools (Engineer on the phone very good and free) then you can make your final decision based on your own experience. Before calling for the walkthrough I would prepare a list of the tasks that you would like to perform or expect to perform in a routine manner and compare the tools based on that list. Luis Suri, Deepak wrote: I have a feeling that this is not the most appropriate list for this question, but then I swear by the postings of folks on this list, which means I value their opinions very much, so here goes ... Our organization is evaluating several tools to help us with our Oracle application development (excluding that done using Developer/2000). The front runners are TOAD and SQL Navigator both sold by Quest Software. The prices are comparable, the functionality is similar, support is the same, integration with PVCS is available etc. Would any of you gurus out there care to comment on which one and why one tool might be better than the other ? thanx ! deepak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suri, Deepak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: MS access
Migrate to ORACLE ! sorry could not resist t> "Li, Xiangli" wrote: Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: Developer, C/C++, Java lists
The developer list is ODTUG-DEV2K-L and it is hosted by fatcity also, there is also a WEBDEV list and a Java list and if my memory doesn't fail me there is also a PRO*C list. \Umesh Chander Sharma\ wrote: Hi Gurus, Any idea about lists existing like this one for other areas like Oracle Developer, C/C++/Pro*C and Java etc. TIA, Umesh --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: \Umesh Chander Sharma\ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: OT - Books Covering Partitioning in 8i
What about Ian Abramson 's book on DATA WAREHOUSING ? I have not read it from cover to cover ( in scheduled readings) but from what I've seen I think is what you want. Luis Octavio [EMAIL PROTECTED] wrote: Listers, I might end up on a Data Warehouse and Data Mart project using 8i. I've read various white papers, Oracle doc's, etc on partitioning capabilities of 8/8i. And I've dinked around on my test machine a bit trying things out. Are there any books out there that you would recommend for digging deeper into the partitioning subject? I have some prior experience in the DW/DM arena on *V7*, but, a book going into real detail on partitioning in 8i, what works well when, what doesn't, gotcha's to look out for, etc would be helpful. I've already been planning on getting Jonathan Lewis's Practical Oracle 8i. And I heard and/or read that it does a good job of covering partitioning. I've also accumulated a list of recommendations for Oracle specific DW books, though I don't have any of them yet. I already own, and have read, an assortment of Inmon and Kimball books on DW. Thanks, Larry G. Elkins [EMAIL PROTECTED] -- 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). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: ....A drop schema script ??
Thank you Jared for the words of encouragement and specially for the SCRIPT Luis Octavio Jared Still wrote: Luis, Don't feel bad, this is a valid question. DROP USER CASCADE is not always the most efficient way to drop a user, especially a user with a large number of objects. I've had that command fail a number of times, and had to rerun it until I decided there must be a better way. DROP USER CASCADE can generate a *lot* of recursive SQL, and therefore can take a very long time. It also eats up system resources at a prodigious rate. I've found that when dropping a schema owner, it's much easier to drop their objects individually, then drop the user. e.g. spool '_dropscott.sql' select 'drop ' || object_type || ' scott.' || object_name || decode(object_type, 'TABLE', ' cascade constraints;',';') from dba_objects where object_type in ('TABLE','PACKAGE','PROCEDURE','FUNCTION') and owner = 'SCOTT'; spool off @_dropscott.sql drop user scott cascade; I still include the 'cascade' on drop user to pick up any objects not included in the above list. Works for me, YMMV. Jared On Thursday 17 May 2001 13:25, Luis DeUrioste wrote: uhhh DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A Content-Type: text/x-vcard; charset=us-ascii; name=Luis_deUrioste.vcf Content-Transfer-Encoding: 7bit Content-Description: Card for Luis Octavio de Urioste -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
....A drop schema script ??
All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: ....A drop schema script ??
uhhh DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
WIN2k - Backup
Dear List Members: We are in the planning stage of upgrading from NT 40 to Windows2000 and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row. My question is, has anybody used Win2k Backup to Backup the database ? Can it handle somehow shutting down the DB for cold Backups ? I currently use ArcServIT with the Oracle Agent and it handles the whole "Enchilada".Should I upgrade ArcServIT and keep it? Are there any better Backup Solutions? Any input will be appreciated. Regards Tavo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luis DeUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Win2k Backup
Dear List Members: We are in the planning stage of upgrading from NT 40 to Windows2000 and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row. My question is, has anybody used Win2k Backup to Backup the database ? Can it handle somehow shutting down the DB for cold Backups ? I currently use ArcServIT with the Oracle Agent and it handles the whole "Enchilada".Should I upgrade ArcServIT and keep it? Are there any better Backup Solutions? Any input will be appreciated. Regards Tavo begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard