RE: Replication question
Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences on the subject. Thanks awfully, Harry Lowes "My enthusiasm for both the job in hand and the welfare of my fellow man knows no bounds." Database Administrator and bon vivante, npower Northern Limited -Original Message- Sent: 21 June 2002 11:49 To: Multiple recipients of list ORACLE-L Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (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).
RE: another listener.ora
Morning, The listener starts using the file listener.ora in the directory pointed to by the environment variable TNS_ADMIN. By default this is set to $ORACLE_HOME/network/admin or $ORACLE_HOME/net80/admin depending on the Oracle version (%ORACLE_HOME%\net... on Windows). You can set the TNS_ADMIN environment variable manually to point to another directory on the server, and the lsnrctl utility will use the listener.ora file there instead of the default. You will have to use a different listener name, however, and some programs called by the listener appear to only run one per platform (e.g. EXTPROC). HTH, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: 04 April 2002 00:38 To: Multiple recipients of list ORACLE-L How can I start another listener on same box using another listener.ora file . TIA Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (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).
RE: Manager decrees "his" data warehouse design. Help!
data. (These are users that were just converted off from "green screen" teminals within the last 45-days, to Windows 98 with 64k RAM.) 7 - We are not to just copy the legacy transactions. 8 - We are to load into "an" Oracle table, all legacy transction data because "we don't want to limit how or what a user will look at" 9 - It is not necessary to talk with the users to see what data they want to look at, or the atomic level. "They are smart enough to fighure this out on their own. We just need to provide them the data." 10 - There shall be no long term maintenance required by "the" dw. Any ideas on how to deal with this situation? For tomorrow, I've done a CTAS from a materialized view that we created to support one departments known requirements. Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lowes, Harry (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).
URGENT - Newly Server-Partitioned Applications 11.0.3/8.1.6 grind
Afternoon esteemed colleagues, We are running Applications 11.0.3, and in a move towards iProcurement have upgraded our 8.0.5.2 database to 8.1.6.3. Everything tested OK, but after a couple of days of live running, the ORA-4031 errors that we used to get in clumps once / twice a day crept up to four / five times a day, then in 24 hours brought the system to it's knees. I have monitored perm chunks in the shared pool, and the free space gradually gets maxed out, even though the lib cache and buffer cache are 95% and 85% full respectively. It looks like the free chunks (when they finally appear) are big enough to accommodate the chunks that are failing in the ORA-4031 message, tho'... Has anyone seen anything else like this? The instance is now unusable after 30 minutes, and shows no signs of miraculous recovery. Thanks in advance, Harry Lowes Database Administrator, npower Northern Limited mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (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).
RE: Connection question?
Alright Paul, Not too sure myself (as I said in my post). I know on VMS the bequeath listener is a job started using the BEQLSNR utility. After a bit of digging on Metalink, I found Note: 62142.1 that illustrates the bequeath connection quite well. Looks like it's a direct one-home one-server connection, where the app spawns it's own server-side process to connect to a db in the same oracle home. This connection is performed using Unix pipes. The listener spawns the server-side process for IPC connections, and these communicate using Unix Domain Sockets. Amazing what you can learn with a little digging.. ;-) Thanks, Harry Lowes Database Administrator, npower Northern Limited Tel: (0191) 210 2278 Fax: (0191) 210 2647 mailto:[EMAIL PROTECTED] -Original Message- Sent: 28 November 2001 17:41 To: Multiple recipients of list ORACLE-L Harry, you say that IPC and BEQ both use the listener to spawn a server-side process -- but the docs say that BEQ "...enables clients that exist on the same machine as the server to retrieve information from the database without using the listener". Which is correct? --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > Hi Harry, > > I admit ignorance. Networking was never my strong point. IN fact > sometimes > I wonder if I still have one. > > Thanks for your response. > > Lisa > > > -Original Message- > > From: Lowes, Harry (NESL-IT) > [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, November 28, 2001 10:31 AM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Connection question? > > > > Afternoon Lisa, > > > > I thought that BEQ and (for example) IPC protocols both used the > listener > > to > > spawn a server-side process. The difference is in the protocol used > in the > > communication between the remote and local processes. IPC uses Unix > Domain > > Sockets to communicate between the client-side and server-side > processes, > > where BEQ uses Unix pipes. I had assumed that this was why BEQ > connections > > had to be local. This is the view expounded in Note: 1014940.6. If > I've > > got > > it wrong, it'd be nice to know. Any comments, Gurus? > > > > > > > > > > Thanks, > > > > Harry Lowes > > Database Administrator, > > npower Northern Limited > > mailto:[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > > > __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lowes, Harry (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: Connection question?
7;ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lowes, Harry (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).
RE: How Can I get A sequence Current Value in PROC
ribing). -- 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: Lowes, Harry (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).