RE: Unix Client Install - OraInventory
Actually, on my original install, it went one level up from ORACLE_HOME - e.g, ORACLE_HOME was /dsk001/app/oracle/product/8.1.7; the OraInventory,oui,jre went into /dsk001/app/oracle/product - one level up. Since that's where I tarred/untarred to on the new machine, I should have the installer info - at least it appears there. All seems to work fine. I'll keep an eye out when/if patching! Much and Many thanks for all the responses, I'll sleep easier. Ed Maurer. -Original Message- From: Lord, David - CS [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 1:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix Client Install But it is stored, by default, under the oracle account's home directory (together with the OUI and jre). I haven't tried it, but maybe you could copy those as well? I would guess that the paths to all of these bits would have to be the same on both machines. YMMV David Lord -Original Message- Sent: 09 August 2001 02:56 To: Multiple recipients of list ORACLE-L It will allow you to run Oracle, but you won't be able to upgrade it later. There some orainventory directory where OUI keeps track of what it has installed on this system. This folder is NOT stored in or under ORACLE_HOME HTH YYMV! Ed Maurer wrote: Given virtually identical Unix machines (i.e., same kernel and patch sets,) is there any reason NOT to take the cowards way out and use a tar file of $ORACLE_HOME from the first client only install (from CD with X-win client) to install to another machine? My original install CD has 'walked'; I could download and cpio ... or wait 3 days for support to get me new CD's. Why shouldn't I use the working installation as a base? Are there any machine specific actions taken by the installer besides obvious tnsnames if you use the installation gui) for client installations ? TIA Ed Maurer Acquirex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix Client Install
Given virtually identical Unix machines (i.e., same kernel and patch sets,) is there any reason NOT to take the cowards way out and use a tar file of $ORACLE_HOME from the first client only install (from CD with X-win client) to install to another machine? My original install CD has 'walked'; I could download and cpio ... or wait 3 days for support to get me new CD's. Why shouldn't I use the working installation as a base? Are there any machine specific actions taken by the installer besides obvious tnsnames if you use the installation gui) for client installations ? TIA Ed Maurer Acquirex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
3rd Party Java and Oracle Triggers
In the course of customizing one of our 3rd party apps that uses Entity Beans to do multiple inserts to some tables, It has been decided we'd use triggers on the tables to do some RI logic and insert essentially duplicate data into another database - Oracle Financials interface, to be exact, I've been opposed to this methodology, on the grounds that nobody here can tell me exactly how this app is behaving in the first place. I've heard that some beans do stupid (sic) things like insert a row, then update each column in the course of a single transactional insert, thus requiring both insert and update triggers; performance could be nightmarish, assuming we don't hit 4091 errors even trying to write the code. Unfortunately, without some hard facts, I'm going to have a hard time convincing anyone this is bad practice. And without tools to see exactly how the object(s) behaving, I won't be able toprove it on our development platformseither. Anyone have any experience here, or ideas for tools (besides packet capture) that can assist ? TIA Ed Maurer
RE: SQL-Server Presentation/Reality Check
Privilege ? Reality? Reality and MS is an oxymoron. I've had the fortune (misfortune) to become a SQL Server DBA in addition to my Oracle duties, due to packaged application requirements. As an admitted defiler of all MS stands for and it's dubious accomplishments, I'll offer a few grains of sand, most of which you might be advised to take up with management away from the MS marketing morons. First, be aware that MS pricing is not nearly as inexpensive as their hype would have you believe, once you remember that they have always charged for upgrades, their discounts aren't usually as steep, and support... well, what there is of it s. I've spent 3 calls at $245.00 each only to be told each time the answer was to 'reboot'. This on W2K/SS2K fail-over cluster, with many of their best support people contributing to this non-solution. On a technical note: Virtually every one of their new speed marks of note have been done on multi-server clusters; Oracle still holds most single-server benchmarks. Additionally, their application benchmarks have no relationship to real world, as even their SAP benchmark was done on a modified SAP installation not available in 'ordinary' SAP applications. The overhead of multi-server/cluster management makes their scalability arguments, even if they could be accommodated by existing software, moot. Self-Tuning - Bah, Humbug. I've had the opportunity to see some server code from SAP, PeopleSoft and Commerce One designed for SQL Server. Guess what ? The real stuff, that which has to perform, is often hinted (statements like 'option (loop join , force order, maxdop 1 )' which is pretty much self explanatory; 'maxdop 1' = Oracle's noparallel.) Then there's the entire discussion of read-consistency, which SQL Server doesn't support. A whole thread there, and one reason why SQL Server can be very quick in some operations: No RBS to support. Everything is done from the transaction logs. And then there's functionality... Just my 2 cents... Ed Maurer Sr. DBA Acquirex -Original Message- Sent: Wednesday, June 27, 2001 11:32 AM To: Multiple recipients of list ORACLE-L I have the privilege of being tasked to attend a SQL Server presentation to be conducted by Microsoft at our site. Our company's current take on SQL Server is that it's to be used only in the case where a packaged application requires it, or when there are 'tactical' exceptions, while Oracle is viewed as being 'strategic'. However, given the 'challenges' with Oracle's new pricing methods, there is being given increased consideration to expanding SQL Server's use. Now, I know next to nothing about SQL Server, and while I would appreciate the opportunity to learn it, I don't want to go to the presentation and let the MS marketing droids completely have their way, some reality checks need to be presented. So, what questions/issues/considerations should I raise during the presentation? TIA! Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL-Server Presentation/Reality Check
From SQL-Server BOL (Books on Line) READ COMMITTED Specifies that shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in nonrepeatable reads or phantom data. This option is the SQL Server default. READ UNCOMMITTED Implements dirty read, or isolation level 0 locking, which means that no shared locks are issued and no exclusive locks are honored. When this option is set, it is possible to read uncommitted or dirty data; values in the data can be changed and rows can appear or disappear in the data set before the end of the transaction. This option has the same effect as setting NOLOCK on all tables in all SELECT statements in a transaction. This is the least restrictive of the four isolation levels. Note in the above 'nonreaptable reads' and 'phantom data'. Again, from BOL: nonrepeatable read: When a transaction reads the same row more than one time, and between the two (or more) reads, a separate transaction modifies that row. Because the row was modified between reads within the same transaction, each read produces different values, which introduces inconsistency. phantom: By one task, the insertion of a new row or the deletion of an existing row in a range of rows previously read by another task that has not yet committed its transaction. The task with the uncommitted transaction cannot repeat its original read because of the change to the number of rows in the range. If a connection sets its transaction isolation level to serializable, SQL Server uses key-range locking to prevent phantoms. My observations: Note that setting the transaction isolation level to serializeable may make large portions of a table unavailable to another transaction yet that's the only way to insure no phantom data, and is too restrictive to be the default. Also note that unless a transaction explicitly defines 'Begin Transaction', data is auto-committed. i.e. 'update students set lname='Smith' followed by 'go' will trash your student table if you forget the 'where' clause. You cannot issue a rollback, since you didn't define a transaction. In addition, another transaction already reading the student table will get some percentage of all rows as 'Smith' even though it began before the 'bad' update. Try it yourself, as a I did (I used a large 'waitfor' in the middle of a procedural loop to simulate a larger table or more per-row processing) HTH Still unashamedly anti-Redmond, Ed Maurer Sr. DBA Acquirex -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL-Server Presentation/Reality Check Can you provide some references to lack of support of read-consistency. Not that I don't believe you but I just read that to a guy next to me and he is clamoring for evidence. - E -Original Message- Sent: Wednesday, June 27, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Privilege ? Reality? Reality and MS is an oxymoron. I've had the fortune (misfortune) to become a SQL Server DBA in addition to my Oracle duties, due to packaged application requirements. As an admitted defiler of all MS stands for and it's dubious accomplishments, I'll offer a few grains of sand, most of which you might be advised to take up with management away from the MS marketing morons. First, be aware that MS pricing is not nearly as inexpensive as their hype would have you believe, once you remember that they have always charged for upgrades, their discounts aren't usually as steep, and support... well, what there is of it s. I've spent 3 calls at $245.00 each only to be told each time the answer was to 'reboot'. This on W2K/SS2K fail-over cluster, with many of their best support people contributing to this non-solution. On a technical note: Virtually every one of their new speed marks of note have been done on multi-server clusters; Oracle still holds most single-server benchmarks. Additionally, their application benchmarks have no relationship to real world, as even their SAP benchmark was done on a modified SAP installation not available in 'ordinary' SAP applications. The overhead of multi-server/cluster management makes their scalability arguments, even if they could be accommodated by existing software, moot. Self-Tuning - Bah, Humbug. I've had the opportunity to see some server code from SAP, PeopleSoft and Commerce One designed for SQL Server. Guess what ? The real stuff, that which has to perform, is often hinted (statements like 'option (loop join , force order, maxdop 1 )' which is pretty much self explanatory; 'maxdop 1' = Oracle's noparallel.) Then there's the entire discussion of read-consistency, which SQL Server doesn't support. A whole thread there, and one reason why SQL Server can be very quick in some
RE: Terminal Emulation Sw.
look at http://www.uk.research.att.com/vnc/ HTH Ed Maurer -Original Message- From: DKTS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject: Terminal Emulation Sw. Hi listers... Could you recomend me some good free (not shareware) terminal emulation software for Windows? Something little better than windows telnet.exe? Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DKTS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FK Constraints
A disaster waiting to happen; it's not if one will happen, it's when. Applications, no matter how well written, will, sooner or later, lose transactional control because of design flaws, new front ends that don't enforce ACID transactions (or interfaces from other systems) or other acts of development or network failure. DON'T DO IT! I've seen too many projects fail, and spent too many hours trying the impossible: cleaning up integrity violations after the fact. If you want real life examples, I'll be happy to supply off-line (protecting the not-so-innocent) Ed Maurer Sr. DBA Acquirex -Original Message- From: ramani akhil [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: FK Constraints Hi all: We have a situation where are no relationships are defined at the database level. i.e no foreign keys constraints have established at the Database. The application is still at the Development Stage. Everything is controlled at the application level. I as the DBA appose this design for Data security and also cannot reverse engineer from the tables into Designer. Can you please share you pros / Cons. Thanks __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ramani akhil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ed Maurer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: hsodbc/Merant connection to MSSQL
Title: export / import 8.1.5 to 8.0 ? Anyone succeeded in getting hsodbc working (8.1.x); I need to get this up (Oracle to MSSQL 2K on Win2K); TG4MSQL is notviable as it isn't supported on W2K; can't wait for 'promised' upgrades. Merant seemed to be the way to go; but I've been unable to get that connection working either through hsodbc; I've been over my listener configs about 200 times already and all appears in order. Success / Failure stories much welcome. TIA Ed Maurer AcquireX