Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
Possibly due initially to the fact that ping is ICMP and runs very low in the TCP/IP stack that is in the network layer or the third level up from the hardware and TNSPING is application layer which puts it up at the top of the stack or two more layers higher. This alone can contribute to the performance or response time differences. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28/12/2003 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE I agree that this difference might be only because sqlnet is much more fat that ICMP. But anyway, could some overhead be added be because the failover load balancing clauses that require extra work? Also, if listener logs every connection, this might add some extra IO time as well (if writes for log file aren't write buffered). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, December 23, 2003 3:29 AM I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. for example this tnsping took about 270 ms which is strange and its consistent Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADD RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 OK (270 msec) and a ping to the same host Ping statistics for x.x.x.x: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 61ms, Maximum = 70ms, Average = 67ms Why could there be such a difference? Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Shell script broken, bdf adds new line for long filesystem name.
I don't know if it will be available on your platform but have you tried using fold to see of that affects your script. I didn't think line wrapping was an issue with a script, so it seems to be a bug in bdf. have you tried just df Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/10/2003 04:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Shell script broken, bdf adds new line for long filesystem name. Note that the foofoofoo volume causes the disk info to show up on the following line. A script I have that loops through each line coming back from bdf is breaking because of this. Any simple way to bring the line back up to the Filesystem line using awk, sed etc...? bdf -l Filesystem kbytesused avail %used Mounted on /dev/vg02/foofoo 2048000 1973804 70415 97% /foofoo /dev/vg02/foofoofoo 532486624 43711 13% /foofoofoo /dev/vg02/foofoof 512000 259286 236944 52% /foofoof -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan 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: 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).
Moving Data from Oracle to SQL Server
Hi I am going to be migrating data from Oracle to a SQL server and wanted to know what is the likely variation in database size when its done that is if I had a 10GB Oracle DB, should I expect the SQL server to be a lot bigger, a lot smaller or about the same -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: How to invoke stored procedures from another instance?
For this AQ or possibly streams in 9i would be the best, but there is a bit of work to get either set up and functioning the way you want. The big benefit is done right you cant lose a message from one system to the other. This is fundamentally EAI integration without the messaging server. You could effectively though have an EAI adaptor for your application with a bit of additional thought Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Ranganath K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28/08/2003 08:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to invoke stored procedures from another instance? Hi listers, Assume that there are two instances in Oracle. Both instances are on different machines and different Oracle versions. There is a table on first instance. Any update on this table should invoke stored procedures on the second instance. This should be real time based. Options we looked at are 1. Trigger on the table invoking the procedures of the other instance 2. Using dbms_alert 3. Some kind of polling mechanism Triggers we would like to avoid. Options we are left with are dbms_alert and polling mechanism. Is it possible to use dbms_alert in this case? If yes how? Can you think of some kind of polling mechanism which will satisfy the need of real time communication? Updates on the table is done at a very fast rate, hence processing should also be at a fast rate. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath MailFiler [RK-FM8B9B3] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: How to keep root out?
Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Nature of Oracle-l has changed
Yes I would say that most of the topics have been more in line with operational issues. I think RMAN has probably had a higher hit in the conversation counter and that i guess is due to more DBA's flirting with it in there environment, Roberts book probably helps. Since I am fortunate enough to be working with in a development project I will have to see what I can do to stir up some conversations. Should have a major AQ design sub project coming up, so here's hoping Maybe now that there is signs of life back in the US economy things might become a bit more active in the development world, unless America has shipped all development work offshore these days. Its Friday arvo and almost beer o'clock so the brain is about to hit neutral. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Jared Still [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22/08/2003 04:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Nature of Oracle-l has changed Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
Hi Babette This is a feature of 9i. using SYS you have to always use as sysdba same thing on Windows and Solaris at least and I am sure it is all other OS's Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Babette Turner-Underwood [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17-08-2003 02:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9i and connect as sys 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: 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).
materialized view failing to create in 9.2.0.3
, 'P1730'AS P_No, P1730 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P1800'AS P_No, P1800 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P1830'AS P_No, P1830 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P1900'AS P_No, P1900 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P1930'AS P_No, P1930 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2000'AS P_No, P2000 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2030'AS P_No, P2030 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2100'AS P_No, P2100 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2130'AS P_No, P2130 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2200'AS P_No, P2200 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2230'AS P_No, P2230 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2300'AS P_No, P2300 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2330'AS P_No, P2330 AS P_Reading FROM EP_CURVEDETAILS UNION ALL SELECT curvedetails_id, curve_id,curvedetails_date, 'P2400'AS P_No, P2400 AS P_Reading FROM EP_CURVEDETAILS order BY curvedetails_id, curve_id, curvedetails_date, p_no This cause the instance to shutdown of the Oracle instance under windows and causes a disconnect ( end of communication error)under Solaris both DB's9.2.0.3. I havent raised a tar as yet so if anyone can tell me my query is wrong or invalid for a mview or other useful info else I shall raise a TAR Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Re: What books recommended for Data Modeling ?
Perhaps a bit late but I have just been cleaning up the email As an alternate suggestion perhaps running Oracle under VMware with GSX Server. You can build a single instance of the training environment and then replicate the environment to build multiple instances, A nice feature is the ability to make each instance non persistent so that at the end of training you can simply undo all the work done in the training class GSX allows you to run as many instances as your hardware can support and if they are willing to buy big hardware then a GSX license is probably going to be cheap Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Guang Mei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07-08-2003 02:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What books recommended for Data Modeling ? I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it. Guang On Wed, 6 Aug 2003, Dilip Patel wrote: Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred database instances on same server machine, which *each* will be accessed simultaneously from 100 different client workstations. The reasons for installing all instances on same machine are - to avoid re-installing databases on 100 workstations after each round of training. - No user should see any other user's data. Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and it seems to work. The customer is willing to upgrade to any hardware needed for this setup. Thanks in advance for your time. Dilip. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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: 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).
Analytical Functions
Hi Can anyone tell me if the Analytical functions as shown in the extracted piece of SQL using the OVER clause are part of standard 9i SQL or is it part of the OLAP engine. What i want to know is do I need OLAP installed to use these functions SELECT last_name, hire_date, salary, LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees WHERE job_id = 'PU_CLERK'; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Analytical Functions
Sorry for the late response as it was a holiday here in Brisbane yesterday. You have all confirmed what I thought but all my development databases have OLAP installed and I don't presently have the space to install another 9i environment. So I couldn't Identify that information I will advise if the PL/SQL now understands them, I suspect it will as a lot of other things work. Update soon And thanks guys Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13-08-2003 12:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytical Functions Nope, Use them every day. Their standard issue, but require Enterprise edition in 8i. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 12, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi Can anyone tell me if the Analytical functions as shown in the extracted piece of SQL using the OVER clause are part of standard 9i SQL or is it part of the OLAP engine. What i want to know is do I need OLAP installed to use these functions SELECT last_name, hire_date, salary, LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees WHERE job_id = 'PU_CLERK'; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Goulet, Dick 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: 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
Re: How to Lock and unlock a table until SP completes
Hmm I see a major performance issue coming on Seems that your program might have some other bugs in it as what you want to do isn't a very good approach to solving your problem. For performance and scalability your application doesn't want you doing table locks as you will soon learn. If it wont breach any confidentiality I suggest you post a more detailed description of your problem to get a real solution instead of applying what maybe a really bad band aid to your problem and yes Oracle can table lock try the LOCK TABLE Statement as in LOCK TABLE accts IN SHARE MODE; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. WLSH [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04-08-2003 04:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to Lock and unlock a table until SP completes Dear List: How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused. I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example? Thanks Steven Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: RMAN/Veritas duplicate db article
Ok I will go one better and say I actually did have a look at it at first glance it looked a bit like my first effort of dealing with RMAN, and Veritas, I will have a better look now I am back in the office and see if i can add some useful comment. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Babette Turner-Underwood [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28-07-2003 01:54 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN/Veritas duplicate db article Didn't get a change to read it yet, but if it makes you feel better, I REALLY DID bookmark it to read later, when I thought it might apply to me. Currently in the big blue world (Oracle on the mainframe) and Veritas is just a pleasant memory :-( Babette -Original Message- Jared Still Sent: Sunday, July 27, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Hmm... absolutely no responses. Perhaps a bit of clarification is in order. I'm interested in comments only on the content. This was a write as a you go paper and decidely not publishable as is. If it seems worthwhile, I will rewrite into something a little more acceptable than the very rough draft that it is. Thanks, Jared On Wednesday 23 July 2003 14:29, [EMAIL PROTECTED] wrote: List, I've written a short ( compared to the length of time it took to do this anyway ) article on how to create a duplicate database on a remote server using RMAN and Veritas NetBackup. It can be found at: http://www.tinyurl.com/hu4r or at this one if you can't access tinyurl.com: http://www.cybcon.com/~jkstill/Alternate%20Client%20Restore%20With%20Verita s%20NetBackup%20and%20Oracle%20RMAN.doc It's kinda rough, so suggestions, comments, criticisms are welcome. Thanks, Jared -- 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). -- 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: 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: Integration with IBM Mqueue series
Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta 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: 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: Re[2]: Union quries: INTERSECT, MINUS, etc
Love it classic execution of KISS, no bull it just works and quick and efficient Waiting for my plane home from Perth Have a good weekend as its Friday night here Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: Union quries: INTERSECT, MINUS, etc okay, I answered this offlist but... it started out as do we have a problem, indicated by records in the parent table with no children select id from parent minus select parentid from child that identified that we had a problem. next step (I'm a paranoid DBA when it comes to permanently deleting data from production) create holding_table as select * from parent where id in (select id from parent minus select parentid from child) last step delete from parent where id in select id from holding_table elegant? no. Fast? yes. And when I'm doing this 10 minutes before I'm supposed to leave for the day, fast is what I want :) I'm a BIG believer in plain vanilla coding. Slick is fine, but if I have to spend too much more time than the slick query saves me in creating it, it's not worth it. This is a one-off. --- Jonathan Gennick [EMAIL PROTECTED] wrote: Friday, July 25, 2003, 6:39:35 AM, you wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Offhand, I'd think you could do this without using MINUS. Maybe I'm wrong. But assuming there is a non-MINUS solution, what led you to choose to use MINUS? 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). __ 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: Rachel Carmichael 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: 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
Re: Update through a DBLink
I can only say that with a rather basic type of update across a dblink we had a problem with it inserting two records, it was done with a trigger will all the code within the trigger, so this could be related, we made a work around to check for the record before trying to insert it Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. John Shaw [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 25-07-2003 02:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Update through a DBLink There is or at least was a problem if you had a autonomous transaction across a dblink with a commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: 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: DB2 pointers
From a previous request to the list try these: DB2 links from SearchDatabase.com - http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282900,00.html Learning the Lingo - article from DB2 Magazine that maps some Oracle and DB2 concepts - http://www.db2mag.com/db_area/archives/2002/q1/pdfs/Kolluru.pdf DB2 Self-Study course (u can download it for free): http://www-3.ibm.com/software/data/db2/selfstudy/index.html DB2 Manuals - http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main hth, Marin Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-07-2003 04:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DB2 pointers Hi All are there any Db2 mailing lists which are active like this one..where i can develop my knowledge on Db2.I know this is a Oracle mailing lists but i thought maybe one of you might be Db2 DBA as well.. regards Hrishy Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= 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: 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: Online tech books - Not online anymore
Remember this one well it seems the publisher may have had some impact No books now with some bullshit apology about bandwidth issues HAHAHAHA Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-06-2003 02:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Online tech books This was just passed on to me and I'd like to share it wit the list... http://www.palaydium.net/tech/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: 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: ER Tools (was: erwin)
I gave DBdesigner a bit of a test reverse engineering a fairly decent size database I am working on and it kept crashing after loading a bunch of the tables, seemed that i might have exceeded a limit of it handling large database structures. The schema has 470 tables in it That wont stop me using it as it seems to do a very nice diagram ran it against the 9i HR schema to see what it can do Now all i have top do is work out how to do subsets of the schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09-07-2003 02:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: ER Tools (was: erwin) Interesting tool, complete with reverse-engineering, and it's GPL'd. I'd really like it if it did crow's foot, though. But the website does say to use the big ER tools for conceptual modeling. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 3:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: ER Tools (was: erwin) SDesigner became PowerDesigner when Sybase bought/rebranded things. There's an open source product I've been testing ... DBDesigner by fabForce. Not too bad, but I haven't really stretched it so far. www.fabforce.net Ciao Fuzzy :-) -- 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: 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).
Need to get the output of a column with its column name in as rows
Hi Have the following table columns curvedetails_id, curve_id, curvedetails_date, p0030, p0100, p0130, p0200, p0230, p0300, p0330, I need to do a query that does the following output CurveId ,CurveDate, PNumber, PReading 206116, 31-Dec-2002, P0030, 26.18 206116, 31-Dec-2002,P0100, 8.80 where the pnumber column is the column name in the table Is there anyway to get this without using a whole bunch of unions Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Oracle Technology Champion OTC
Hi has anyone sat the OTC exam before and did they find it difficult Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: VB Oracle question
You have declared a cursor c1
and then in your code you try and open P_IC
try opening C1
You need to go read the documentation on cursors and learn how they are manipulated as your coding around the usage of the cursor is rather wrong
From The Application Developers Guide - Fundamentals
DECLARE
Emp_name VARCHAR2(10);
Cursor c1 IS SELECT Ename FROM Emp_tab
WHERE Deptno = 20;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO Emp_name;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(Emp_name);
END LOOP;
END;
Cheers
--
=
Peter McLartyE-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision
=
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Teresita Castro [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
19-06-2003 10:05 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:VB Oracle question
Hi!!!
I create a package in Oracle.
When I run the line:
Set adoRS = mCmd.Execute
VB sent me the next error:
Run-time error '-214721700 (80040E14)':
Ora-06550: line 1, column 33: PLS-002001: Identifier 'P_IC' must be declare.
Ora-06550: line1, column 7: PLS/SQL: Statemnt ignored.
What I am doing wrong
This is the code
CREATE OR REPLACE PACKAGE LAWSON1.PACK_ICTRANS AS
CURSOR c1 IS
SELECT ITEM,DOC_TYPE,DOCUMENT FROM ICTRANS;
TYPE t_row IS REF CURSOR RETURN c1%ROWTYPE;
PROCEDURE CL_CURSOR(p_item in varchar2, P_IC OUT t_row);
END PACK_ICTRANS;
CREATE OR REPLACE PACKAGE BODY LAWSON1.PACK_ICTRANS AS
PROCEDURE CL_CURSOR(p_item in varchar2, P_IC OUT t_row)
IS
BEGIN
OPEN P_IC FOR
SELECT ITEM,DOC_TYPE,DOCUMENT FROM ICTRANS WHERE ITEM=p_item;
END CL_CURSOR;
END PACK_ICTRANS;
This is the code in VB:
Private Sub cmdTestOracle_Click()
Dim mCmd As ADODB.Command
Dim mCmdPrm1 As New ADODB.Parameter
Set adoRS = New ADODB.Recordset
If Open_cnOracle Then
adoRS.CursorType = adOpenDynamic
sSQL = {call PACK_ICTRANS.CL_CURSOR(?, {resultset 1000, P_IC})}
' adoRS.Open sSQL, gcnOracle, , , adCmdTable
Set mCmd = New ADODB.Command
With mCmd
.CommandText = sSQL
.CommandType = adCmdText
.ActiveConnection = gcnOracle
Set mCmdPrm1 = .CreateParameter(p_item, adVarChar, adParamInput, 32, 0010096)
.Parameters.Append mCmdPrm1
End With
Set adoRS = New ADODB.Recordset
mCmdPrm1 = 0010096
Set adoRS = mCmd.Execute -Error here
MsgBox adoRS.Fields(0)
End If
End Sub
Function Open_cnOracle() As Boolean
Dim oMsgSplitter As New LawsonErrMsgSplitter.Splitter
Dim vaPieces As Variant
On Error GoTo ErrorConectarOracle:
Set gcnOracle = New ADODB.Connection
With gcnOracle
ConnectionString = Provider=OraOLEDB.Oracle.1;Password=burke00;Persist Security Info=True;User ID=lawson1;Data Source=LAWS
.CommandTimeout = 0
.Open
Open_cnOracle = True
End With
Exit Function
ErrorConectarOracle:
vaPieces = oMsgSplitter.SplitMsg(Err.Description)
MsgBox vaPieces(mpText)
Open_cnOracle = False
End Function
Re: oracle full table scan
Perhaps you need to do a trace to determine the real cause of you problems. Full table scans are not necessarily the problem. When you have trace for the program and the explain plain you have of the executing SQL you will have a better idea than assuming you need indexes to stop full table scans. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Arvind Kumar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2003 02:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oracle full table scan Dear All, is there any way to find which tables (table name) are suffering from full table scan ,so that i can create indexes on them to enhance the performance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar 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: 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).
Autoallocate vs Uniform extent performance
Hi all Some time ago there was a discussion about the use of the different extent management types and that if my memory serves me that there was a perception that Auto allocate extents had some performance issues against Uniform extents. Was this correct and can it be backed up with some definitive testing, has someone done a whitepaper??? Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: dbshut script - shutdown or shutdown immediate
I think I would still prefer a shutdown abort over a kill -9. There might be even a slight level of control and error management in a shutdown abort but not in a kill -9 nothing and I repeat nothing can avoid a kill -9 and there is no cleanup by the process that is killed. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Nelson, Allan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2003 09:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dbshut script - shutdown or shutdown immediate Suppose you have a database with a sid of mydb running on unix. Shutdown abort is like doing the following from the unix command line: ps -ef | grep mydb | grep -v grep | xargs kill -9. All the processes that make up the instance or processes that are connected to that instance are killed. The database will require instance recovery on the next start. Allan -Original Message- Sent: Wednesday, April 02, 2003 4:29 PM To: Multiple recipients of list ORACLE-L Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: Pardee, Roy E 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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
OT- Start a process after oracle on Win 2K
Hi Slightly OT I have a couple of programs that need to be run after Oracle has started and want to run them without a user logging in. The likely place seems to be in the scheduled tasks running at startup or as a program under the local run key in the registry. The processes are a couple of scripts and I would envisage running them as a batch file What is best? Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: enterprise manager console and sqlplus worksheet can't work
Its the Java JVM you have installed with the Jdeveloper. Have a look at your Environment variables and see what Java is in the path and what classpath is set. I would say OEM isn't compatible with the one installed when you installed JDeveloper Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Mohammed Shakir [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/04/2003 08:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: enterprise manager console and sqlplus worksheet can't work I installed Jdeveloper 9.x on oracle 9.0.1.3 and did not have a problem with OEM or SQL worksheet. I believe, you need to install it in a separate directory. Also it does not give you any startup Icon or put the Jdeveloper in Start and program menu, so you need to start from the directory. --- [EMAIL PROTECTED] wrote: If it is NT/2000 platform, Oracle installer normally screws up the registry entries, for example TNS_ADMIN in registry etc. Some product also screws up DLL ( specially microsoft DLL) files , if installed in the same oracle Home ( overwrite good DLLs with new but incompatible DLL) . 1. See, if OLD TNS_ADMIN is overridden by new TNS_ADMIN. Copy old stuff into the tnsnames.ora of new TNS_ADMIN. You will be lucky if this is the case. 2. Deinstall and reinstall all of the stuff in seperate home. Lots of work. In between install(s), you can export registry entries for backup and compare. 3. Some products have to be in same oracle home and will still screw up. In that case call Oracle :). Meanwhile, you can again deinstall everything and try, change the order of install of the product. I am assuming here that you have no other work, but do these over and over again. Pradip -Original Message- Sent: Thursday, March 27, 2003 12:09 AM To: Multiple recipients of list ORACLE-L afer installed the development tools I downloadd the developer suites from www.oracle.com such as jdeveloper. But after I installed it .my oracle enterprise manager console and sqlplus worksheet cant work which I installed before. Why ,and how to make them work . Thanks in advance! Regards Liujd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd 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: 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego
Re: Accessing LOB
What SQL are you using to access the table that causes the error Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2003 08:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Accessing LOB Friends, Find below the script of a table with a CLOB datatype CREATE TABLE lob_content_display ( content_display_id VARCHAR2(30), business_id VARCHAR2(30), language_id VARCHAR2(30), content_typeVARCHAR2(30), detail CLOB DEFAULT EMPTY_CLOB(), CONSTRAINT pk_lob_cont_dsp PRIMARY KEY(content_display_id, business_id, language_id,content_type) USING INDEX TABLESPACE indx, CONSTRAINT fk_clcd_contdsp_bsl_ct FOREIGN KEY(content_display_id, business_id, language_id,content_type) REFERENCES content_display(content_display_id,business_id, language_id, content_type) ) LOB (detail) STORE AS (TABLESPACE ts_lobs CHUNK 16K PCTVERSION 10); As can be seen in the script, the LOB is stored in a separate tablespace. I am able to access the data in all the columns except the 'detail' column. Oracle throws an error - 'ORA-03120: two-task conversion routine: integer overflow' when the mentioned column is accessed. The oracle documentation says : ORA-03120: two-task conversion routine: integer overflow Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application. Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767. Please let me know how to solve this problem. Should I change any of the parameters in the init.ora file. Regards, Narasimhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: 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: AIX question
Hi Lisa Here is the link to all AIX manuals online for 4.3 http://publib16.boulder.ibm.com/pseries/en_US/infocenter/base/aix43.htm I think lspv is the one you want Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Koivu, Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22/02/2003 03:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here but the SA for this system is scarce. Thanks for any suggestions, and have a great weekend everyone Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa 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: 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: Another Question on Authority and Security
No as it is in user A schema then it has authority the same as user A always as The compiler of the object isn't the owner the schema owner where it is created is the owner. From the Concepts guide Oracle verifies that the calling user owns or has the EXECUTE privilege on the procedure or encapsulating package. The user who executes a procedure does not require access to any procedures or objects referenced within the procedure; only the creator of a procedure or package requires privileges to access referenced schema objects. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Kevin Lange [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06-03-2003 07:31 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Another Question on Authority and Security Given: User_A Owns procedure 'MY_PROCEDURE'. User_B originally compiles procedure ''USER_A.MY_PROCEDURE, thereby allowing 'MY_PROCEDURE to be able to do whatever User_B can. User_C recompiles USER_A.MY_PROCEDURE by issuing the ALTER PROCEDURE USER_A.MY_PROCEDURE COMPILE; command. Question: Is procedure USER_A.MY_PROCEDURE now able to do whatever User C can do instead of User B ?? Or does it retain the authority from User_B instead. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Set Email alert at NT
Do a rewrite in Perl to run it on Windows.
There is am smtp module for Perl that will allow you to inject an message
straight to a mail server.
You could then use that both on Unix and windows
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision
=
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please
delete it and notify the sender. The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group of
companies unless expressly stated otherwise.
Mitchell [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
22-02-2003 05:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Set Email alert at NT
Hi
The following sh is one I used for monitoring all 20 instances on unix
boxes(aix and sun). So I could receive the ora message by palm. Now there
are 2 nt box with Oracle 8.17 installed. I have no idea how to do it in
windows. Any idea?
This is my ksh and run as cron job every 30 min.
if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log |
grep 'ORA' | wc -l) -gt 0 ];
then
cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep
'ORA' $HOME/alert_me
mailx -s Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!! [EMAIL PROTECTED]
$HOME/alert_me
fi
Thanks in advance.
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
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: Anybody using Mercury WinRunner?
I know our company did some trials with WinRunner and the general consensus amongst the people testing of which two were our development dba's thought it a very good product. We however didn't buy due to the decision to purchase some other products from one of there competitors and so I believe we got a deal on buying a packaged bundle etc. Speak to Mercury and get it for appraisal If you are serious and want more than one license I suspect you will have a Mercury consultant knocking on your door to assist you in testing it out. They work hard to beat the opposition Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Meng, Dennis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07-02-2003 05:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Anybody using Mercury WinRunner? Hi all - We are thinking about using Mercury WinRunner to load test our 11 to 11i upgrade and wondering if anybody has experience using this before. How steep the learning curve, how reliable and how 'real' the load is comparing to the production load. Any other feedbacks are also welcome. Thanks Dennis 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: Meng, Dennis 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: 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: RMAN - questions.. Rob Freeman?
You will only know what your system is capable of It is very dependant on the disk arrays and no of scsi or fibre channels you have to support those disks Also RAID level will be a big contributor How long does it take to copy say a 500MB file from location to location. check it out this way. see what throughput you are reporting in sar or glance or similar Test this between the filesystem your db is on and where you want to put the backup to disk -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Spears, Brian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06-02-2003 06:16 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN - questions.. Rob Freeman? I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users This rman would be the secondary recovery solution (Timefinder is the first). Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte of database from disk? I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit in the SLA requirements. Any parameters to focus on to improve performance other than allocating channels? Thanks for any help Brian Spears -Original Message- Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Andriyashchenko 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: Freeman Robert - IL 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: Spears, Brian 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
RE: Oracle list for developers ??
Actually there is and it runs of the fatcity servers go to the ODTUG website http://www.odtug.com and the details to sign up are there Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11-10-2002 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle list for developers ?? No there isn't. And a google search certainly wouldn't turn up any. Give up the quest and read your manuals. That is all. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Droogendyk, Harry [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:44 PM To:Multiple recipients of list ORACLE-L Subject: Oracle list for developers ?? Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). STG06646 Description: Binary data
Re: Advice needed on move to Sun 15K (losing spindles)
Ask the Sun guys if they will sign a document saying they will pay all cost including hardware to fix the performance problems, if after you make the change and performance is worse. It will show that you are serious and if they seriously believe they are right then they have nothing to fear, I never understand why these vendors insist in building systems with so little hardware Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Anjo Kolk [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10-10-2002 05:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Advice needed on move to Sun 15K (losing spindles) Jay, You will hit performance problems because of not having I/O bandwidth. Databases don't need storage, they need IO operations. Two important pieces of info that are missing from your post: - How many databases in total are going to run on this Sun 15K ? - How many concurrent users on all databases at the same time ? Anjo. Miller, Jay wrote: Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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). STG18945 Description: Binary data
RE: Way of extracting record
Cool Tools have a tool that can assist with this The Extraction and load tool from Databee http://www.cool-tools.co.uk/ Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-10-2002 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Way of extracting record 1. You can use SQL*Plus COPY command to copy data from Production into development database. 2. You can create a link from Development database to Production database, and then use insert into Development database table by selecting data from table@Production database. 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). I would go with #1 first. Check SQL*Plus Reference Guide for (1) and (2) Check Utilities Guide for (3). HTH.. - Kirti -Original Message- Sent: Monday, September 30, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Hi guru , I need your advise , currently our customer have a production and development system , if there is a problem log being raise , then we need to port the data from development to production but not the whole database sometime is only certain record. Is there any method to use instead of generate insert statement for necessary table(PROD) and run the statement (DEV) ? I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). STG20975 Description: Binary data
RE: Agnostic references for Pracle v SQl Server 2000
Hi Maybe you need to talk with a Developer to quickly do a rough estimate of costs involved in taking one on the more complex form/reports systems to VB/.net platforms. make sure they don't scrimp on cost but be realistic. I don't think a 1 page report is fair or does justice to the question so develop a longer report and produce a 1 page executive summary to present, but say a development cost of 1,000,000 in that report to move only one application might be a significant hindrance to the M$ is cheaper. Also beware that a lot of things run in Win2k/sqlserver, but to get the advanced features for say clustering you then need to be running Advanced Server along with M$ clustering software and the price point then runs up somewhat higher. Remember the MSDN licenses that will need to be acquired, along with NT licenses if you don't currently have them Oh and decent Intel based hardware for the DB servers. Also consider talking to your Oracle rep and see if the issue of pricing re Charity status cant be worked over. A lesser license to Oracle for a registered charity has to be better than no license fee in the present climate. my 0.02c Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Martin Kendall [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-09-2002 08:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Agnostic references for Pracle v SQl Server 2000 Hi Dennis, They have 5 databases, dating back to 7.1 and up to 8.1.7 They also have some very complex Oracle Forms and Reports. What they do not realise at the moment is the amount of work they will have to put in to convert the Apps. AND retrain the 4-5 members of staff who are more scientists than DP professional types. The data extraction and migration itself should not be a problem. The Oracle costs a lot of money to licence story has worried them quite a bit. Martin -Original Message- WILLIAMS Sent: 23 September 2002 21:49 To: Multiple recipients of list ORACLE-L Martin - Thanks for the clarification, but this prompts more questions. Is there a single database involved that multiple clients share the use of, or are you the vendor of a product that sits atop a database, but each client has their own database installed at their location. If it is the latter, then the correct answer would be for them to keep ported to both Oracle and SQL Server. My experience has been that Microsoft tries to arrange it so that if you have a Microsoft front-end (.NET or VB), interface to the database will be much easier. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Hi Dennis, Personally I would like them not to move. Apart from all the Platform issues, they don't have ANY experience in .NET architecture and they only think it will be easier to administer the DB because they do not have any experienced Oracle DBA's in their employ. I am struggling to understand how they can possibly think of future-proofing their systems AND at the same time become a 100% Microsoft site. Martin -Original Message- WILLIAMS Sent: 23 September 2002 20:39 To: Multiple recipients of list ORACLE-L Martin - If I understand your first statement, the database is now on Oracle and you are writing a paper on why they should move it to MS SQL Server. If this is true, and given your other statements about the client, I would think you could get plenty of reasons from the Microsoft web site. Or did you mean to say you are trying to give them reasons not to move? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Hello all. I need to provide a one page report on why it may be beneficial for an organisation with light usage, small DB
Re: DBA work load
Sadly this is one of those How long is a piece of string questions, It relates to what are you doing with those databases what support is required on a daily basis for those databases I can have a single database that requires 2 full time DBA's and another DBA supporting 20 or 50 databases. It also comes down to the available management tools that you have to do set analysis tasks like mining the alert logs for errors. Apparently the book Implementing and Managing Oracle Databases has a chapter to assist in answering this question. I think one of the best ways to get a understanding on this is to show your manager what it is you do each day by doing a time and motion study on yourself, something like 8 am checked alert logs on databases 930 am Checked tablespace utilisation 10am increased xxx tablespace on database 1030 worked with Finance to tune new ad hoc query ( ie used for corporate BI tool) and so on Also you might like to see if having some management tools would simplify any processes to free up time and provide a list of tools, how they make you more efficient and the proposed cost of such tools. You can then say that the tools whilst useful still aren't going to be able to recover those 3 mission critical databases if they were to crash when you are 2 continents away skiing or surfing. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. tony ynot [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-09-2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:DBA work load I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want Industry Standards, like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot 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). STG09122 Description: Binary data
Re: Scripts to reengineer a DB / recovery speed-up
Go to Cool-Tools website http://www.cool-tools.co.uk/ and have a look at the Databee DBA Tool Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Andrey Bronfin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-09-2002 04:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Scripts to reengineer a DB / recovery speed-up Dear gurus ! Could you please point me to a free script /tool to capture the current DB metadata and to be able to recreate the DB (except for the actual data), i.e. tablespaces, users, roles etc... I can think of 2 semi-ways of doing it: 1) get the physical DB attributes (data files , redo logs , character set etc..) from alter database backup controlfile to trace 2) get the rest of metadata from a full DB export with no rows (rows=N). But if someone has a ready script , it will save me some time and work ;-) Thanks a lot ! Another question : i need the above in order to speed up bringing our DB back to production. We currently back it up via RMAN to tapes (via HP OmniBack II). This is a quite large DB (~950 GB, running on win2k , no UNIX) , and the RMAN restore/recovery took almost 48 hours after the recent crash. We're looking to speed up recovery and the most feasible option seems to be this : recreate the DB (empty DB , just build the users, TBS , tables etc..) , load configuration / reference / lookup/ static data (which needs to be backed up (exported) separately) . At this point the DB is operational again, loss of detailed data may be tolerated. The actual question is : what do you think of this scheme ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). STG40831 Description: Binary data
RE: Consulting Position Available-Oracle DBA/Developer/NYC
Or SQL server -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Bill Christison [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 20-09-2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Consulting Position Available-Oracle DBA/Developer/NYC TD, Transactional..for Sybase Bill Christison --- Thomas Day [EMAIL PROTECTED] wrote: Datawarehouse meta data. But what the heck is T SQL? Miller, Jay JayMiller To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @TDWaterhousecc: .comSubject: RE: Consulting Position Available-Oracle DBA/Developer/NYC Sent by: root 09/19/2002 02:08 PM Please respond to ORACLE-L But 4th normal form? Does anyone really use this? -Original Message- Sent: Tuesday, September 17, 2002 3:35 PM To: Multiple recipients of list ORACLE-L well the market must be picking up some, been definitely more reqs posted here a/o recent. joe Bill Christison wrote: Interested candidates reply to: [EMAIL PROTECTED] * Consulting Position Title: Oracle DBA/Developer Duties and Responsibilities: This position is a conversion to an Oracle Data warehouse. Excellent verbal skills are needed to obtain technical specification from the architect and users then to transform into written specifications. Experience Required: *Must have experience in PL SQL and T SQL *Must have 3rd and 4th form data normalization *Must have done business systems analysis Consulting Assignment Duration: 6 months to 12 months Assignment Location: New York City = Bill Christison Knowlton Group, LLC 845-258-5129 www.knowltongroup.com __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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
Re:RE: Returned mail :
Its Mailsweeper and they have it pretty locked down, its quite funny the things it sometimes rejects. Its virus sweeper just blocked an email I sent form an external account because it thinks the document attached in the zip file is corrupt. I actually think it was right about that one. I will see though if I can get the list added to the trusted email sites. then regardless of content the message will get through, viruses generally excluded. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28-08-2002 02:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re:RE: Returned mail : April, That was the first one I've ever gotten. Wonder what their using as a spam filter? We could use the same thing. Dick Goulet Reply Separator Author: April Wells [EMAIL PROTECTED] Date: 8/27/2002 7:53 AM I get these when I try to respond to a couple different lists... It detects something in the hidden header part of the mail... Suggestion was (last time) change your email client gee, wonder if the company will buy into our needing to change email servers because the list's detection software can't handle reply, only sent mail... ajw -Original Message- Sent: Tuesday, August 27, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Well, This is a new one!! Dick Goulet Forward Header_ Re[2]: [Q] security between Cold fusion Author: No Sender Date: 8/27/2002 11:20 PM Your message Re[2]: [Q] security between Cold fusion and oracle database? to [EMAIL PROTECTED] has been detected as having Unsolicited Commercial Email (SPAM) Content. Because of filtering tools in place, your message has not been delivered. If your message was not SPAM and was of a business related nature, please contact the recipient and inform them that mailsweeper has filtered a valid message and to contact the support centre. If your message did contain Unsolicited Commercial content, you are requested to remove all mincom.com email addresses from your mailing lists. -- 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). Embedded uuencode file has been extracted -- 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). -- 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
Re: PRO*C question
If you run the installer you can view a list of installed products. If the Pro C stuff isn't listed then it needs to be installed. the OraInventory under ORACLE_BASE is where this information is kept on the system in question. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. sultan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-08-2002 04:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:PRO*C question Hi , How can we come to know pro*c installed in the machine. If it is installed ,in which directory we can find out. Thanks in advance sultan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] security between Cold fusion and oracle database?
Basic firewall rule make sure your firewall rules only allow trusted servers to access ports or in this case make sure the host that is the coldfusion server is the only one allowed to connect on that port. and changing the port to a non default value will assist. it is no guarantee of security. It will just take them a lot longer to work out what is on the other side of the firewall at that port. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. dist cash [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 27-08-2002 07:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:[Q] security between Cold fusion and oracle database? We have ORACLE 8.1.7 on NT server. users can through Internet Cold fusion server (with ODBC) access ORACLE database. Between Cold fusion server and ORACLE server their has firewall on it. The firewall only open port 1521 to allow ODBC access to ORACLE database. We are worry the hacker may hack into ORACLE database (even firewall their) and plan to change port from 1521 to . Is this way improve security? We are NOT plan to buy ORACLE advance security module. Does their has other way to improve security between Cold fusion server to ORACLE server? Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Viewing Data in Oracle Apps Tables
I am not an Apps user but it sounds like that there might be a trigger that doesn't allow you to see the table data through SQL PLUS to inhibit the direct editing of tables. This I suppose is to stop editing that might break referential integrity Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Naveen Nahata [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 20-08-2002 09:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Viewing Data in Oracle Apps Tables Hi All, I'm using Oracle Apps 11.0.28 Database Version 8.0.5 When I query the Data using Application Forms I can view the data. When I see the record information it shows me the view name which is in APPS schema. When I query the view from SQL*PLUS or any other tool, it gives me 'NO ROWS FOUND' This is from Oracle 11 Architecture Manual: -- Oracle Applications forms and concurrent programs always access database objects from within the Oracle Applications environment. If you use a tool like SQL*Plus to connect directly to an Oracle Applications schema, the values returned by the view through SQL*Plus may be different from those returned by an Oracle Applications form or concurrent program. For example, when accessed within the Oracle Applications environment, some views reference profile options at different levels. When accessed directly from SQL*Plus, views reference only the site-level value of the profile option. And this is also mentioned in the same document: - In case you want to create a schema with read-only access to applications data. Grant access on objects to the user schema from the APPS schema, not from a base product schema. Now my questions are: 1. What is the meaning of the statement When accessed directly from SQL*Plus, views reference only the site-level value of the profile option. 2. Why is it not selecting the data from the view from SQL*PLUS whereas it can select the same data from the application forms 3. If I am not getting the required data when I connect to the DB using APPS username, how will I get the required data if I grant accss to the objects from APPS schema rather than giving access to underlying Objects directly? I have to create a seperate application for reporting summaries of critical information to the management. What access should I give to the application schema - Read only access on Objects directly or through APPS schema? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Win2000/8.1.7.3.0/SQL
The order by is dong a sort and you have insufficient sort space configured so it is doing it to disk and that is the temp tablespace or whatever is allocated as the users temporary tablespace. I suspect that this database has the smallest SGA for any of the databases you have tested. You might like to investigate the SORT_AREA_SIZE parameter or maybe just look at increasing the available memory to the instance. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Vergara, Michael (TEM) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 20-08-2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Win2000/8.1.7.3.0/SQL Hi Gurus: I have this SQL, see... col segment_name format a30 heading Segment Name col maxseg format 9,999,999.9 heading Largest|Segment (MB) col segment_type format a15 heading Segment|Type col pct_increase format 999 heading Pct|Incr col next_ext format 9,999,999.9 heading Next|Extent (MB) col ownerformat a12 prompt Generating First Troubled Objects Listing... select a.owner, a.tablespace_name, a.segment_name, a.segment_type, a.next_extent/1048576 next_ext, a.pct_increase, max(b.bytes)/1048576 MAXSEG from sys.dba_segments a, sys.dba_free_space b, (select max(fs.bytes) maxbytes, fs.tablespace_name tsname from sys.dba_free_space fs group by fs.tablespace_name) wherea.tablespace_name = b.tablespace_name and a.tablespace_name = tsname (+) and a.next_extent maxbytes group by a.owner, a.tablespace_name, a.segment_name, a.segment_type, a.next_extent, a.pct_increase order by a.next_extent desc, owner, segment_name / ...and it works great everywhere. Well, almost everywhere, and there's the rub. Thie query works on my 7.3, 8.0, 8i, 8iR2, and most 8iR3 databases. In this one database, on Windows 2000, it blows out the TEMP tablespace. Every time. And this is the only system where that happens. There are only 12 tablespaces, and 15 datafiles. Any ideas why this would fill up the TEMP space? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Simple favor from the guru's
Well this is from the 8.1.7 Doco Concepts guide Section introduction to an instance, and I quote This combination of the SGA and the Oracle processes is called an Oracle instance. It doesn't include the initora file, the concepts guide a bit further into it is this one To start an instance, Oracle must read a parameter file--a text file containing a list of configuration parameters (initialization parameters) for that instance and database. So if I read that correctly what we generally all refer to a database ie instance all files etc consists of three components: instance, database, and parameter file. After starting an instance, Oracle associates the instance with the specified database I refers to mounting the database so all things that are connected to an instance when you mount is the database. that would include all dbf file, redo, archive. That would make the alert log though part of the instance So now where did I go wrong Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Karniotis, Stephen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 16-08-2002 05:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Simple favor from the guru's Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
Re: Convert PL/SQL to Java
I didn't see a reply to this but apparently Jdeveloper 9i can do this From the 91 Help file Generating Java Source Code for Oracle Objects and PL/SQL Packages To generate Java classes for an object type or package, right-click an object type or package in JDeveloper's Navigator pane. You can also right-click a folder, such as the Object Types folder or the PL/SQL Packages folder, to generate Java classes for all of the objects or packages it contains. Choose Generate Java from the menu to open the JPublisher Wizard. Click Help for instruction on using the wizard. The generated classes are added to JDeveloper's Navigator pane for the Project and Package you specified. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Barry Deevey [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15-08-2002 07:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Convert PL/SQL to Java Good morning, Does anybody know of a utility that can convert PL/SQL code to Java code?? Thanks in advance for any replies. Barry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: user CGI-BIN directories
With Apache it is fairly easy but why you would do it is beyond me as they will then run anything in those directories and that is how you mess with a web server by allowing users to freely run cgi scripts. This is why most free websites don't give you access to CGI stuff or other server side capabilities. Most of there sites would have been hacked by now with this enabled. You need to modify the a Location section Read up the Apache doco on this as it will explain how a user can use this to create exploits on the server Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Alroy Mascranghe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-08-2002 05:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:OT: user CGI-BIN directories To execute the cgi scripts thru web/HTML forms we had to put them in the common cgi-bin directory. But is there a way to have these scripts in a user's home directory and still call them thru web/HTML forms? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Dba tools on NT
Looks OK to me, seems about right
Although when you start using Macros and such the readability drops a
little as it can take a bit of jumping around to understand it.
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision
=
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please
delete it and notify the sender. The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group of
companies unless expressly stated otherwise.
Jacques Kilchoer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
15-08-2002 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:RE: RE: Dba tools on NT
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
How many of those non-cryptic languages can dump a table
to a CSV file in 2 lines of (readable ) code?
while ( my $ary = $sth-fetchrow_arrayref ) {
print q{} . join(q{,},@{$ary}) . qq{\n};
Readable code?
Now take COBOL, that was readable code!
e.g. (from memory - excuse any errors)
IDENTIFICATION DIVISION.
PROGRAM-ID. DUMP_VALUES.
AUTHOR. MOI.
ENVIRONMENT DIVISION.
INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT MYDATAFILE ASSIGN TO SOMEFILE.DAT
ORGANIZATION IS LINE SEQUENTIAL.
DATA DIVISION.
FILE SECTION.
FD MYDATAFILE.
01 MYCOLS.
05 ID PIC 9(7).
05 NAME.
10 FIRST_NAME PIC X(20).
10 LAST_NAMEPIC X(20).
PROCEDURE DIVISION.
BEGIN.
OPEN INPUT MYDATAFILE.
READ MYDATAFILE
AT END MOVE HIGH-VALUES TO MYCOLS
END-READ.
PERFORM UNTIL MYCOLS = HIGH-VALUES
DISPLAY
ID SPACE FIRSTNAME SPACE LASTNAME
END-DISPLAY
READ MYDATAFILE
AT END MOVE HIGH-VALUES TO MYCOLS
END-READ
END-PERFORM.
CLOSE MYDATAFILE.
STOP RUN.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Unix Solaris forum.
try www.sun-managers.org -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Marul Mehta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13-08-2002 01:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: Unix Solaris forum. I looked for www.sunmangers.org but it doesnt work? Can you please re-check the reference. Thanks. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, August 11, 2002 9:18 PM www.sunmangers.org will do it for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Chuan Zhang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12-08-2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Unix solaris forum. Hi, DBAs, Could anyone recommend a good unix solaris discussion/news group for me? Thanks, Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marul Mehta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix Solaris forum.
www.sunmangers.org will do it for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Chuan Zhang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12-08-2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Unix solaris forum. Hi, DBAs, Could anyone recommend a good unix solaris discussion/news group for me? Thanks, Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 20 Instances 1 Machine
Although in this situation you would need separate file systems for each database to avoid those issues But I do agree that for providing databases to different customers I would never like to share an instance between customers. You are more prone to issues arising out of security mistakes or bugs like the one in 91r1 relating to the visibility of all objects. You could also consider HP's Superdome type architecture to partition each customer effectively to individual subsystems Each customer effectively has its own server. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02-08-2002 09:13 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: 20 Instances 1 Machine Ethan, The points you make are valid. There will be some resource wastage due to the overhead of each instance and database, but the potential downside may make it worthwhile. Suppose customerA's application has a bug generates a ton of redo, overflowing the archive_dump_dest. This means that customerB's (and all others) data is unavailable and applications will begin to malfunction. Imagine telling irate CustomerB that they are down because of CustomerA! This also simplifies backup and recovery requirements that differ between customers. There will be some performance penalties, but a sufficiently powerful machine should be able to mask them. -Original Message- Sent: Thursday, August 01, 2002 4:44 PM To: Multiple recipients of list ORACLE-L I am going to reply to this myself before I get flamed. I found a recent discussion on usenet regarding this topic. http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm=3d1091af %240%2428006%24afc38c87%40news.optusnet.com.aurnum=15prev=/groups%3Fq%3Dto o%2Bmany%2Binstances%2Bgroup:comp.databases.oracle.server%26hl%3Den%26lr%3D% 26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DN Basically everyone is against this idea. However no actual technical details are provided to explain why this could not be done in a production environment with the right sized machine. The scenario presented in which one would want 20 instances on a machine is in a class room setting. However, my scenario would be acting as an ASP. Each instance would support a different customer. My fear with splitting customers up into different schemas on the same instance is that I don't want to interupt other customers if recovery is required. This would have to be a tablespace point in time reco since we would only want to reco one customers data. Perhaps this isn't as big an issue if we go with RMAN? Ethan Post (972) 577-6552 [EMAIL PROTECTED] perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, August 01, 2002 4:58 PM To: Multiple recipients of list ORACLE-L I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: UNIX Q: How do I delete files beginning with #
I assume that you are talking about Unix is so the use rm #Column to get rid of it Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Ross Collado [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-08-2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:UNIX Q: How do I delete files beginning with # Hi, I have files like: #Column #This # How do I get rid of these 3? Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: efficient way to duplicate db on another unix host?
Having just been working with it rman duplicate seems a good bet. It seems very efficient and you don't have to worry about sizing issues as it just builds it as it sees it If you have any questions I might be able to help I have seen one problem and that was with it not doing a proper recovery and you need your original db in archivelog mode. I seem to have a problem in the controlfile, it put in a screwy path for the directory where the logs are. I think I need new controlfiles in the original dbs but haven't been able to work this out. alternatively I have a script here that came from one of the sites around and it explains how to do it by doing an OS copy of the datafiles. This entails a lot of downtime in the original unless you can say split the mirror or something the rman method does it with a hot backup so there is no downtime on the first system HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2002 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:efficient way to duplicate db on another unix host? Hi Oracle gurus: What is, in your opinion, the fastest way to duplicate a database on a another unix host? Thanks, Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: system tablespace with oracle software on same
Nah wouldn't do it! Ideally you separate everything that improves performance and recovery chances in the event of a failure and I don't like the idea of having code and data on the same volume spindles. Remember that Oracle has to access the admin part of the tree to write trace files and alert log and probably at time access code that resides on the disk and along with that you want it to keep the dictionary up to date in the system table. I see a potential conflict with that. My 0.02c US today Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-07-2002 09:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:system tablespace with oracle software on same Hi Oracle gurus: Old db question: best db file layout accross filesystems/disks. (unix - Solaris 2.8, Oracle 8.1.7.4) I have inherited a db file layout recommendation that says to put oracle software and db system tablespaces on the same filesystem /u00/ This is for a production system and it doesnt seem ok to me. What experiences do you have in your environments with this? Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Log Aging Script
It keeps the file handle to the inode not the filename so when you mv filea fileb the listener is still writing to the inode which now belongs to fileb so if you want to move it you need to do the set listener. On the other hand if you cp filea to fileb then the listener is stilled pointed at inode in filea so if you intend to truncate then the cat /dev/null cleans out file a whilst all contents up to that point are now in fileb. i think most unixes allow filea to delete its contents HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Erik Williams [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 24-07-2002 09:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Listener Log Aging Script Why is it necessary to null out the file? Does LSNR keep a open file handle open to it? -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:25 PM To:Multiple recipients of list ORACLE-L Subject: RE: Listener Log Aging Script Make a copy of the file appended by the Julian date then empty the log via cat /dev/null listener.log. (You don't really need a cat.) -Original Message- Sent: Wednesday, July 24, 2002 9:50 AM To: Multiple recipients of list ORACLE-L Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Rman duplicating failing when setting redo logs
One for the rman smarties I am duplicating a database with rman and it get to the section where it does an alter database open reset logs and it fails as there appears to be a path error. I then go into server manager and do the same and the path is '/u01/oracle/product/8.1.7/dbs/ /u07/oracle/oradata/mimstrn/log1a.log' If I do a backup control file to trace on this now created database the path for the logs is like above for all log files If I now edit that and use it to generate a new control file I am able to open the database with a resetlogs. Question is there something I have wrong with rman or am I doing something wrong with my setup Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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).
Moving tables from one schema to another
Hi I have a user with a schema and want to move that schema to another user. I don't need the original user after the change Can I do this without an export/import. All data and tables in this database I care about is in this schema Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rant-Rant
I didn't know that they gave Managers jobs to people under 20 :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-07-2002 07:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Rant-Rant Oh I know. I was lucky my last job, we had two full-time DBAs (one senior - me, and one junior/mid) and one senior DBA consultant. I *did* look at my boss last week and said I no longer work 20 hour days. Not that I had to. He's good, he's very adamant about the fact that if there is too much work for one person, we will either hire consultants or the deadlines will be changed. I'd fall in love with him but he's way too young for me. :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Rachel, you are actually proving my point - that a company does not have the luxury (or common sense) to have more than one DBA on staff. Robert's utopia just doesn't fly in todays world. hire one person and work-em till they drop is the current motto. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 3:24 PM To: Multiple recipients of list ORACLE-L The only problem with your idea that I see is that a typical organization will only keep one (or so) DBA on staff per project - they rarely have excuse me while I wipe the Diet Coke off the screen that I spit out when I read this. One DBA per project? Oh God that would be a luxury beyond belief. As I type this I am the DBA for: a new data mart/data warehouse project a new content management system project a new ecommerce project the existing universal login project AND the replacement project the existing asset management application the existing community site (bulletin boards) and anything else that needs a DBA ... and I am it, ain't no other DBAs around .. oh yeah, I'm the data architect and data modeler on half these as well... which is REALLY funny as I have almost zero data modeling experience, other than common sense --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: OMG! A Socialist in the group! I believe that if we think about these things in a way that we ask ourselves how can I maximize the potential of this person in our organization, pay him/her a fair wage for what they can do, and free up my time to address the really gnarly stuff we can help our entire society better transition to the information era and not marginalize a bunch of great people in the process. The only problem with your idea that I see is that a typical organization will only keep one (or so) DBA on staff per project - they rarely have the cash for multiple people. So a DBA ends up getting called upon do cross the boundary between very technical stuff as part of the SA group and data access/design with the applications group. Lots of room in between here for talented people. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, July 22, 2002 1:23 PM To: Multiple recipients of list ORACLE-L I have been reading this list for the past several months as I prepare to move my universe of databases from 7.3 to 9 (probably 9) and I have a rant of my own. It seems that the implicit expectation is that every DBA should be or should aspire to be a Master Technical DBA. I have a slightly different take on the situation. It is a little convoluted but I believe that the DBA world needs some additional job classifications. In a decent sized organization, the day to day management functions should be accomplished by an Admin DBA who might be someone who was perfectly happy spending his/her working career operating a precision milling machine at Boeing. Since the machinist jobs are going away, I see no reason why a competent
Re: a couple of questions
Sheesh Has Oracle employed some MS developers, sure sounds like one of there brain dead ideas :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17-07-2002 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: a couple of questions Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. I can see it now: one table in a database two columns, one for primary key, the other for data ( of type ANY of course ) all on one server all disk striped a SAME structure as a series of RAID 5 arrays. No DBA? Hell, you don't even need a duhveloper, just use the ODBC interface in MS Excel. Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/17/2002 12:35 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: a couple of questions Rachel, This variant datatype sounds a lot like the union data structure from C language, which closely resembled a struct (i.e. record) but all of the fields overlap the same memory address. In other words, it was a mechanism for type re-casting. In the grand tradition of robust programming languages, there are about a dozen and a half ways to do this in C, and the union structure is one of the less popular. Luckily, it is difficult to use for any other purpose... Not so with what you're describing. Sounds like a feature which is ripe for all kinds of abuse. I can just imagine entire tables populated with columns of type VARIANT by some designer touting flexibility as a mantra. Fortunately, Oracle developers can use the RAW datatype in the same fashion, and it is interesting to note (but perhaps not coincidental) that most C programmers tend to favor a similar mechanism (i.e. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17, 2002 11:08 AM Okay, I'm working on what feels like 30 new projects all at once and I WILL be RTFM'ing as soon as I can get more than 5 minutes out of meetings but first: has anyone heard of any problems with 64-bit Oracle on a Solaris 64-bit OS? second (and this one confuses me a bit)... I've been asked if Oracle9i supports a variant datatype -- they are not familiar with oracle but are familiar with SQL Server and say that there is a datatype called variant there where you can basically overload the column with whatever datatype you want (string, number, date) and the database knows what type of data it is storing within the column. They referred me to C++ and Java, neither of which I know. Can anyone point in the right direction to start researching this? Thanks! Rachel __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: 9iAS Application Server: Win2k vs. Linux?
As you have Unix skills and therefore could handle Linux OK, then unless you will have issues with people about support for Linux I would offer to save the organisation money by using Linux for your platform Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Gene Sais [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 16-07-2002 12:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:9iAS Application Server: Win2k vs. Linux? I am not looking for an OS war, but has anyone on the list had experience in setting up/administering 9iAS rel 2. (1.0.2.2.2a) on Win2k or Red Hat Linux? I have the option of selecting the OS on this one. All of my oracle databases are on AIX (sort of like unix). I have 1 OAS 4.0.8.2 App Server running on NT. I am not sure if I should continue the NT track for App Servers or go Linux? Any opinions, experiences would be appreciated. Thanks, Gene PS. I will also be running the Forms Server w/ this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Exporting stats for a production server to a dev/test server
Hi Can anyone give feedback good or bad on the dbms_stats feature of exporting statistics. Is there any gotcha's or does it work well Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
Hi I am guessing that he has a P4 cpu in the system and you need to do the following. There is also a new installer to overcome this as well but don't have the info at hand there is more on Metalink ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer will exit without any notice. The reason for this is that the Pentium 4 architecture has problems with the Just In Time installer. To fix this problem, just find all copies of the file symcjit.dll and rename them to symcjit.org. Then the installer will work. Copy the installation CD to the HDD and make the changes, then install from the HDD. Voila! CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02-07-2002 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Oracle client won't install on Windows 2000 One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, 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). STG31844 Description: Binary data
RE: Oracle AQ MQ Series
That's probably because they want to sell you Interconnect, it is Oracles version of MQ and by linking messaging gateway to AQ you are replicating a lot of the base functionality of MQ or Interconnect, ie you have a messaging component that can store and manage messages. Keep adding appropriate logic and you build a messaging broker. It sorts of spoils their pricing fun with these products Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 28-06-2002 05:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Oracle AQ MQ Series I did the same thing: opened a TAR, asked for a product that has this functionality, was told there is no such product, posted some of the doc of the messaging GW, TAR was forwarded to the INTERNAL group, and finally was told I can use the messaging gateway. I was told it's on a separate cd in 9.01 and is included in 9iR2. What Oracle release did you get it running? what is the name on the CD ? Thanks a lot for the feedback, Waleed -Original Message- Sent: Thursday, June 27, 2002 2:35 PM To: Multiple recipients of list ORACLE-L Waleed - I tried implementing AQ to MQ with the MEssaging Gateway. I could not find anyone at Oracle to support it. When I would open a TAR, the analyst would come back and say 'this is not an Oracle product'. I finally got it escalated to the point that I was talking to the developer of the Messaging Gateway component. He helped me get it running, but after all the hassle, we went back and told our application group that we could not support the use of AQ in this situation. Hopefully, the product will mature and it can be useable someday. Lisa -Original Message- Sent: Wednesday, June 19, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Thanks for the reply. I think what we need is: the Messaging Gateway. I saw this yesterday and was not sure. So opened a TAR where Oracle support told me they can not find anything related to my issue! Here is a link: http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96587/mgw.htm Thanks Waleed -Original Message- Sent: Wednesday, June 19, 2002 5:30 PM To: Multiple recipients of list ORACLE-L Oracle provides an AQ-to-MQ gateway as part of the Integration Server ($). IBM provides a PL/SQL gateway for free (but implemented as an external procedure) which can be used to create your own bridge between the 2 messaging systems. The support pack can be found at http://www-3.ibm.com/software/ts/mqseries/txppacs/ma0i.html. HTH Tony Aponte -Original Message- Sent: Wednesday, June 19, 2002 4:22 PM To: Multiple recipients of list ORACLE-L I have an application (informatica) that can read/write to MQ Series. We want the tool to be able to read/write to Oracle AQ. Do you know of any product that could act as a listener for Oracle AQ to provide an interface layer that act similar to MQ Series so that these applications that work with MQ could work directly with Oracle AQ? Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG15562 Description: Binary data
Re: Exp Imp User ?
RTFM http://tahiti.oracle.com -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. guess who [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-06-2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Exp Imp User ? I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG10979 Description: Binary data
RE: SqlServer Interview Questions
Although the site has a problems with there SQL server I would have a look at the notes on the cramsession site for SQL server to give you some guides. Also have a look around the MS site for some bulletins on SQL server problems with there fixes and see what there knowledge is there, Another resource is possibly Techrepublic for general interest stuff on SQL server Try him on routine maintenance things that DBA's should be doing regardless of product. things like index rebuilds, space management, explain plans, etc etc and for a tricky one ask them about the wait interface, can't tell you much about it but it has one and it has a number of wait events that it uses. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-06-2002 10:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: SqlServer Interview Questions You can evaluate his / her general attitude about work. Most people give the right answers at first, but you can dig in a bit more to see if they really believe in being organized, etc. Re. SQL Server I don't know enough about it at this point to be helpful, finding practical issues that aren't covered in the MCSE exams would be ideal I think, just to see. My CDN$0.02. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 13, 2002 2:22 PM To: Multiple recipients of list ORACLE-L I've just been elected to particiate in the candidate interview process for a SQL Server DBA at one of our satelite offices. After 10 years of working with Oracle, the only thing I know about SQL Server is the weekly security advisories for either it or Win 2k. Any tips, links, flames, etc would be appreciated. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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). STG32488 Description: Binary data
RE: Management Reports
Thomas said: How's the database running? is as silly a question as you asking your child How you feeling today?. Both answers are a flat fine. My two year old would respond with don't know !!, could be a manager in the making or maybe a NT admin :-) But I had also wondered what the already in trouble was, get a clear dialogue going as to what is his pain so you can resolve it. And if you don't think you can resolve it polish the resume because whatever you do you may well find yourself bundled out of there sooner or later anyway. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-06-2002 10:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Management Reports Mike, My suggestion was silly, I agree. But it forces management to come up with a better question. How's the database running? is as silly a question as you asking your child How you feeling today?. Both answers are a flat fine. I would suggest you have a dialogue to ask what kind of information are they looking for? You already received a few decent ideas - # of log switches a day - a relative indicator of update usage; # hours per day/week/month database is available suck data from STATSPACK and put it into Excel showing disk/tablespace i/o etc. You mentioned that you were already in trouble - not sure what you meant by this, but start a discussion with your boss to figure out what he is looking for. Find a way to get out of trouble :) hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 13, 2002 1:30 PM To: Multiple recipients of list ORACLE-L LOL! But I'm already in the doghouse, so I don't think they'd see it as funny! -Original Message- Sent: Thursday, June 13, 2002 9:23 AM To: Multiple recipients of list ORACLE-L hi! select 1998, 'a lot to do' from dual; select 1999, 'even more to do' from dual; select 2000, 'ph ' from dual; select 2001, 'at full speed' from dual; select 2002, 'increase the DBAs salary from dual'; my boss was delighted about it daniel Vergara, Michael (TEM) wrote: Good Morning Everyone! My management wants a chart that shows the performance of the database. If this was your boss, what would you show them? Thanks, Mike P.S. This is a repeat e-mail. I never saw my other one hit the list. --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author
Re: How do YOU use Java in the DB?
I have some Java in a database I am working on it is a really simple parser for doing something that with a real tricky piece of PL/SQL I could no doubt emulate. Java just was easier. I will most likely use some of the AQ stuff with Java in later development, currently we can swing both ways. I would almost certainly get Java to handle any OS functions. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07-06-2002 07:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:How do YOU use Java in the DB? So, we've finally taken the jump and are using JSPs (erm...Java Stored Procedures, not Java Server Pages) on 8.1.7.2.0. Informal Poll: How do you use Java Stored Procedures? 1) Easy interface from PL/SQL to lp and other OS commands. 2) 3) 4) ... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG32249 Description: Binary data
RE: Production Database Open Fails after Mount
HP-UX allocates as required these are limit values, if I remember rightly there is a slight memory overhead with some of these parameters, it is in the order of 1 MB supports all values or some such, it is negligible however it still exists. I think maxprocs is the culprit as it builds an empty linked list, hash table or some such to manage the procs up to the max value. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05-06-2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Production Database Open Fails after Mount John, That's a splendid idea. I forgot about it.. Thanks. - Kirti -Original Message- Sent: Tuesday, June 04, 2002 8:18 PM To: Multiple recipients of list ORACLE-L Vivek, Just to add a simple way of determining the extent of overflow, you could use the sar -v command. This will also display other OS counters as well. 00:00:02 proc-sz ov inod-sz ov file-sz ov lock-sz 00:20:02 435/2580 0 4641/8816 0 7593/16884 0 25/33168 In fact, I would first check this out before adding a new database on any server, and use the SHM-modifications-reboot to change these as well. As per my understanding, Solaris defines an upper limit for these values, but doesn't allocate space until required, so you are Ok to define larger values without bulking up OS memory requirements. Anyone knows what happens in HP-UX? John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 5:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Production Database Open Fails after Mount Vivek, You are right, this is an OS related issue, but a DBA must be aware of why it happens ;) Error 23 means 'File Table Overflow' and it is generated when the system wide limit for the number of simultaneously open files is exceeded. It is controlled by a kernel parameter 'nfile'. which defaults to a value arrived at by a formula that uses 'maxusers' (and a couple of other) kernel parameters. You can check the values set for 'maxusers' and 'nfile' on these servers, and get your SA to increase those on the server where you had a problem starting the database. Use '/usr/sbin/kmtune -q parameter' command to check currently set value for 'nfile' and 'maxusers'. Read more about 'nfile' at http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html. HTH, - Kirti -Original Message- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
Re: SQL Question
Kirti I needed to do something similar but it isn't due to bad normalisation it is to extract data in a load process so we don't have bad normalisation. I decided to use Java and built a parser in that and I just feed it a line and the code simply extracts that data on the selected delimiter. Mine the delimiter is a fixed value in code, it could be altered to use a runtime selected value. I can provide the source if it would be of use. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30-05-2002 04:22 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:SQL Question I need some help... The database table has following structure. commision_id number com_text_msg varchar2(500) The second column contains data fields that are delimited by ~ and delimiter's position varies. But there are only eight data fields in the column. Is there a way in SQL, other than substr/instr combinations, to extract each data field to report? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG17766 Description: Binary data
Re: OT: Miracle Database forum in Sydney - get together Sunday night
Bruce et all myself and a couple of workmates will also be in Sydney early evening, and will be finding a place for a beer so maybe we can catch up Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 03:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:OT: Miracle Database forum in Sydney - get together Sunday night Hi all, If you don't live in Sydney or you're not going to the Miracle Database forum in Sydney then you can delete this. I'm arriving into Sydney early Sunday evening (missing the presenter's chat from 3pm - 6pm on the Sunday afternoon) and wondering who else out of attendees or list members might be there and want to catch up on the Sunday evening? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG16994 Description: Binary data
RE: Data Warehouse experts, a simple question for you| Outdated?
And that means we can all now ask Rachel our Datawarehousing questions and not RTFM :-) Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Data Warehouse experts, a simple question for you| Outdated? Dennis, I have on my desk, all in varying stages of being read: Inmon's book Building the Data Warehouse (very understandable) Kimball's articles from his site and from the Intelligententerprise.com site (somewhat understandable, I think you need a base from which to read his articles). His books are on order and should arrive today Tim Gorman's book Essential Oracle8i Data Warehousing (this I haven't started, as Tim tells me to read it AFTER I have a basic understanding of data warehousing) The Oracle8i Data Warehousing documentation (actually pretty readable and understandable) Ya think I might be over-researching this stuff and panicking a bit? Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ian, - In the beginning was the data warehouse and yeah it was good. It would solve all corporate problems and would encompass all corporate data so all corporate minions would see the same data. - But yeah it took so long to create the corporate data warehouse that management despaired and canceled the project. Or by the time the monster data warehouse came blinking and straining into the daylight all the users said that the company had evolved in the meanwhile and the warehouse was obsolete. - So data warehouses gained a bad rep from corporate managers and yeah none would fain to propose the conception of a data warehouse for fear of castigation. - Then some marketing interns bribed a DBA to send them data weekly. And they stored this data in a database and lo, their superiors were impressed. - Everyone was in awe of the marketing database, but none dared tarnish it by speaking the name which shall not be mentioned, so it was christened a data mart. - And lo, the data marts multiplied and were fruitful. And the DBA cursed the day she was weak and did give data to the marketing interns. - Then another prophet did arise and did challenge the prophet Kimball. His name was Inmon. And he did claim to be the progenitor of data warehouses. And therefore all should do data warehousing his way and use his terms. - And great confusion arose over the land. And many debates ensued, including some face to face between Inmon and Kimball. And terms such as Operational Data Store (ODS) were bandied about. - And some said that queries against the ODS were acceptable and others deemed them forbidden. And some said that if it looks like a data warehouse and smells like a data warehouse it verily indeed is a data warehouse. - And consultants warred against consultants and did call the other consultants ignoramuses in front of management such that nobody knew what anybody was talking about. - And the DBAs said that creating a data warehouse or data mart was not nearly as hard as figuring out what to call it. The moral of the story is to figure out what you need to do and be aware that different authors use the same terms for different purposes and coin their own terms. Personally, I have understood everything that Kimball has written and have never been able to read one of Inmon's articles to the end. But maybe that is just me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Outdated? Ian, Good question. I think that I've seen more recenct references in articles that state the current thinking of DW/DM. I'm sure that I've seen Inmon refer to them that way, or maybe it was Richard Winter? Anyway, I guess that part is a bit dated
Re: Oracle and Delphi
Another product to consider is ODAC for Core Labs http://www.crlab.com/home.html Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Santosh Varma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22-05-2002 08:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Oracle and Delphi Hi list, I am developing an application wherein Delphi is the Front-end and Oracle the Back-end. I wanted to know what all are needed to get connected to Oracle Database , i.e - settings,configuration etc.. Thanks and regards, Santosh STG13127 Description: Binary data
Re: newbie seeks career direction: become a DBA or DEVELOPER?
I always keep an open mind on these sort of things, I would suggest that you now look for an IT job, where you can get close to Oracle product and hopefully some people like are on this list. You are coming in with no experience it would appear, so you are in the same boat as a grad. You might try for some help desk role, and then find opportunities within that organisation to expand your skills. Developer, DBA whatever will come your way of you just keep at it. You also might like to consider looking at Oracle for phone support roles. if you are enthusiastic and are adaptable and can express that to a prospective employer you might get into what you want. I think attitude and life experience are your catches for trying to get a role. Broaden your scope for the time being to allow you to get a toe in and then start working on the career path A lot on the list here started out in some sort of entry role, the younger ones via hep desk or PC support roles and older ones via operator or grad programmer roles. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-05-2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: newbie seeks career direction: become a DBA or DEVELOPER? Sherry, Sounds like good advice. There is no way of actually knowing, but I'm sure that the vast majority of DBAs on this list were systems- and applications-developers first. I still consider myself a C programmer first and foremost even though nobody cares about C anymore, and just about everything I learned that was undocumented was due to an understanding of how C programs (like Oracle) work on UNIX (itself written in C). I didn't make the switch to DBA until about 8 years ago, after about 10 years as a developer and sysadmin... Of course, if you want to be the life of the party, be a dessert chef. My younger brother starts discussing the chocolate-chipotle-hazelnut-endive tarts he made the other day, and instantly he is the center of attention. Try doing that by discussing session waits...(yawn)... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 6:33 PM Hi gurus, I have taken a few Oracle DBA courses at UCLA Extension, passed my first DBA certification exam, but have not been able to find an entry level position in this area. (My background is in printing and marketing... big career move... I've been told my timing is bad cause the job market is bad here). It was suggested to me, by someone at the LA Oracle User Group meeting, that I become an Oracle Developer first. Is this the path you recommend? Although I liked the UCLA classes, I was dissappointed that the Career Center was off limits to the Extension students. Can you suggest any better/cheaper classes in Southern California? Any with career placement? I have acquired many of the books that have been suggested in these postings and have learned much by being a subscriber to this mailing list. Thanks in advance! SL _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherry Lopata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Calling an External Java Class from PL/SQL
You can call them by building a wrapper in the Java in DB and have it call the external procedure. You can expose that internal Java to the PL/SQL RTFM and get back with any further queries. The Oracle Java documents have quite a bit of useful info on this Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Vadim Gorbounov [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 16-05-2002 05:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Calling an External Java Class from PL/SQL Hi, Pete, PL/SQL has an interface to built-in Oracle JServer. You can load external class here and call it, but at this point class is not external anymore, right? If you need access to the class on a different JVM - true external class, Java provides you RMI, EJB, Corba interfaces. Oracle implements these Java specifications in JServer, that is you can develop Java classes providing access to remote (i.e. external) classes, deploy these classes to Oracle JServer and create PL/SQL wrapper. URLs http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90210/toc.htm http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90187/toc.htm http://technet.oracle.com/docs/products/oracle9i/doc_library/901_doc/java.90 1/a90188/toc.htm HTH Vadim -Original Message- Sent: Wednesday, May 15, 2002 1:53 PM To: Multiple recipients of list ORACLE-L We have a developer who has asked this question. How do you call an external java class from a pl/sql stored procedure? You can stick my knowledge of java in a thimble. Can this be done, if so can you point me to a url with an example or two. Thanks, Pete = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG48418 Description: Binary data
RE: Telephone Alerts
Optus here will provide you with software for free and a $150 connection charge that gives you an SMS gateway of your own you needed a modem and line for it if I remember right. It then just costs for each message delivered. You can then send email to it or I think some of the monitoring tools like Tivoli and Openview have a native type interface to it for ending messages. So you might just like to get in touch with your mobile carrier One great feature for this was the ability to build groups so you could send messages to multiple phones, good for escalation stuff. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 14-05-2002 12:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Telephone Alerts Simon, Working with a tools company that provides a monitoring tool for Oracle - we have had a lot of call for sending alerts to SMS. We've done a fair bit of testing of various SMS providers in the UK so that we can try to recommend a valid solution to our customers - that is able to alert a user with a consistently good response time. The norm is to use an SMS gateway, where you send a standard email to a an SMS Gateway provider - who then forward that email in SMS form to your mobile phone. We've tried various people such as Genie (BT's) now called mmo2, http://www.uboot.com, http://www.iobox.com etc. etc. all of which have had poor response times at various times in the day due to user traffic.. There is also the possibility of getting tools that people have pre-built to send SMS from a desktop - or server.. Many of these are pretty good in GUI form, but when it comes to command line support, they are usually very lacking to none - and let's face it if we wanted to use it, or if you wanted to call it from a shell type script you *need* command line support.. And if there is command line support - most of the time these are made by people in other countries, and don't seem to support our UK service providers such as Orange, One-2-One, and to a slightly lesser extent Vodafone. If we are asked to provide SMS alerts for our tools, we now point our customers to a company called Textforce (http://www.textforce.net) which is actually supposed to be a targeted marketing type site for sending marketing SMS messages. It's a pay per message provider - with each SMS being around 7-8 pence.. The only reason we actually recommend to our customers that they use this site - is that throughout our entire testing, this site provided response times (from the time the email was sent, to the time the SMS was received) of between 30 seconds - 4 minutes consistently! Many of the other providers, such as genie, or uboot et al have greatly differing response times - from 20 seconds right up to 14 hours! I'd still be interested though if anybody has any experience with server based tools that are available (for things such as Sun, HP, AIX, NT/2000) that do have command line support, and also support the major UK providers.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Gorbatchev Sent: 13 May 2002 14:48 To: Multiple recipients of list ORACLE-L Some mobile network providers make use of email gateway for sms. In that case you have some email address which is redirected by your provider to your phone. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 13, 2002 3:03 PM We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong
RE: Licences for testing
Just catching up after the long weekend here, I have been under the understanding that if you are a development partner then you are covered for all products for as many installations for testing and development and learning purposes. Is this wrong or changed ?? If not then it may be in your interests to check out partner status and the value of joining the partner program. Oracle PartnerNetwork Policy Document is the one which states this and as it was explained to me by an Oracle Partner Account Manager a year or so ago Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03-05-2002 11:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Licences for testing As far as I am aware : NO. It has played a major role in me not being able to obtain some more test boxes at my current job. I believe the licensing is a little better, but it is still there. Plus, you also need the OS (Sun Solaris) so you get hit there too. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of O'Neill, Sean [EMAIL PROTECTED] Sent: Friday, May 03, 2002 8:09 AM To:Multiple recipients of list ORACLE-L Subject: Licences for testing We're planning to set-up some test servers here and I'm wondering what the practice is out there regarding licences for same. This is only for short term testing and to try out various DR scenarios etc. I'd guess there's an Oracle view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) -- 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG14543 Description: Binary data
RE: Solid DB and Oracle (NNM)
no I have done some work with Openview but never tried to deal with database backends, sorry -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sujatha Madan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-05-2002 04:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Solid DB and Oracle (NNM) Hi, I have checked on ITRC. There are some things, but they don't really explain much. I thought as much that we couldn't have different Oracle instances on each collector. Have you done this before?? Did it go alright? Regs suji -Original Message- Sent: Wednesday, 1 May 2002 3:38 PM To: Multiple recipients of list ORACLE-L Hi I suggest you go to www.itrc.hp.com and study up there. Your sysadmin will have a full login that you can use to access all of the secrets. The openview manager probably has one linked to the openview license. I think only the management station will have a the oracle database. It is probably not a good idea to change the collectors even if you can as that might cause licensing concerns unless all those systems are already running Oracle instances and adding another instance for this is within current licenses you have. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sujatha Madan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-05-2002 02:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Solid DB and Oracle (NNM) Hi, Sorry but this situation is specific to a particular application ... so don't read past this line if you don't know what NNM (Network Node Manager) is. We're using NNM 6.2 with the default solid db for trend data, event data, topology etc. They have now decided that it is about time we move this to an Oracle database/datawarehouse. I just want to know if anyone has been through this before. We have four collector stations, each running NNM 6.2 and each with its own solid db (on HP-UX 11). Can I confirm that this is how the process will work: Each collection station will send the data to a management station. I then have to export all the data and via an ODBC connection transfer it to the Oracle datawarehouse which will reside on a different machine. What I don't understand is, in this process do I convert each solid db on all 4 collectors to an Oracle db??? Or, will the collectors still use solid??? I am quite unclear on this. Management won't buy another another Unix box because there are a few Windows servers lying around, so I have to put the Oracle datawarehouse db on one of them. I'll appreciate any insights, experiences etc. Thanks and regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated
Re: unix df -k .. not giving extact space at point in time
It is possible that some process was attached to those files and until that process released those files it wouldn't release the space, Also Unix will take its own time to actually clean up a delete. It will delete the inode reference from the directory listing but can take some time to actually release the space depending on how busy the system, or that filesystem, is. I have seen some programs that make hidden files to carry out tasks. The software actually created a file then attached a process to it and then deleted the file whilst the process was attached. The file was accessible to the process but was hidden from everything else. You can find them with an inode listing. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Narender Akula [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-05-2002 08:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:unix df -k .. not giving extact space at point in time hi gurus, This is unix question but hope someone got the answer I ran df -k yesterday on my oracle directories. /oradata4 81% /oradata3 77% /oradata6 72% ( this not exact out put only inclueded mount on ,capacity) I removed some files from /oradata4 and added some files to /oradata4 the figure didnot changed on /oradata4 .. but increased to 87% . today agian I ran df -k which showed. /oradata4 as at 76% capacity. my question why df -k command took some time to give exact figures on disk usage ? Is there any why to refresh this command or are there any alternatives ? naren narender akula Oracle DBA OCP TERRALINK INTERNATIONAL LIMITED ddi: 04 915 6055 fax: 04 915 6030 mobile: 021470971 email: [EMAIL PROTECTED] mail:PO Box 2872, Wellington -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG41677 Description: Binary data
Re: Root Cause Analysis White Papers
Also Have a look around TechRepublic http://www.techrepublic.com. They usually have articles about things like this and may even have some templates that you can use as a guide to get started. There approach would be very IT generalist Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Steven Lembark [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-05-2002 02:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: Root Cause Analysis White Papers -- Peter Barnett [EMAIL PROTECTED] We have been having some heavy discussions about system failures, root cause analysis and developing some proactive metrics. Generally, our problems revolve around frequently late nights for the On Call DBA because something out of our control goes wrong. The damagement folks want to fix the immediate problem and consider the job done. The DBAs are asking for an approach that will allow us to identify potential problems before something breaks at 3:00 a.m. Does anyone know of a source of white papers or other data that has been generated for systems, storage or databases? We can always roll out own, but why recreate someone else's work. See the Usenix doc's on Auditing, sys-admin skills for examples. LISA papers also have covered audit procedures. What you are really asking for is a system audit. The results from a full audit would be a good place to start looking at what is done on the systems, what goes wrong with them and where to look further for root causes. Audit results also give you the facts you'll need in convincing the manglement that something really is wrong and it needs fixing. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG35511 Description: Binary data
Re: Solid DB and Oracle (NNM)
Hi I suggest you go to www.itrc.hp.com and study up there. Your sysadmin will have a full login that you can use to access all of the secrets. The openview manager probably has one linked to the openview license. I think only the management station will have a the oracle database. It is probably not a good idea to change the collectors even if you can as that might cause licensing concerns unless all those systems are already running Oracle instances and adding another instance for this is within current licenses you have. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sujatha Madan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-05-2002 02:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Solid DB and Oracle (NNM) Hi, Sorry but this situation is specific to a particular application ... so don't read past this line if you don't know what NNM (Network Node Manager) is. We're using NNM 6.2 with the default solid db for trend data, event data, topology etc. They have now decided that it is about time we move this to an Oracle database/datawarehouse. I just want to know if anyone has been through this before. We have four collector stations, each running NNM 6.2 and each with its own solid db (on HP-UX 11). Can I confirm that this is how the process will work: Each collection station will send the data to a management station. I then have to export all the data and via an ODBC connection transfer it to the Oracle datawarehouse which will reside on a different machine. What I don't understand is, in this process do I convert each solid db on all 4 collectors to an Oracle db??? Or, will the collectors still use solid??? I am quite unclear on this. Management won't buy another another Unix box because there are a few Windows servers lying around, so I have to put the Oracle datawarehouse db on one of them. I'll appreciate any insights, experiences etc. Thanks and regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG54429 Description: Binary data
RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n
Yes I think many people often forget the simple value in the tracking of values and watching for discrepancies. I have a simple script that I used on a HP box that i was SA on that simply collected a bunch of simple stats from sar and vmstat and mailed them to me. I was able to prove many times that the changes that had been requested helped or hurt the system. -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Connor McDonald [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23-04-2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n I still like to recommend the buffer cache hit ratio because its so easy to please customers with an improvement - A plsql routine to generate any desired hit ratio on a running system is freely available for download from my site... a consultants dream! :-) But, serious hat on temporarily, there IS still a use for the buffer hit ratio as a delta measurement. What I mean by this is that you measure it every 'n' mins/hrs/whatever and store it. When it displays a massive dip or a massive increase (ie something out of the ordinary for *your* system), then whilst it doesn't necessarily mean anything is wrong - it DOES mean that something has changed in your system, which is a good prompt to do some investigation.. hth connor --- John Kanagaraj [EMAIL PROTECTED] wrote: Mark, This is from a first-timer at IOUG, so I may be way off here. A lot of marketing blurb was thrown out at IOUG (probably a lot less than usual, and *much* less than Oracle OpenWorld in any case!). As for tools, many vendors were flogging the same ones, improved versions maybe. One which did make us say 'wow' was StorageXpert from Quest. IMHO, this is an excellent tool, engineered by our very own Gaja. I believe details are at the Quest site at www.quest.com. If you have EMC disks and are facing performance problems, I believe there is the best there is. (Or even if you have other storage devices, it would still give you the hotspots). And NO, I do NOT work for Quest, nor have Quest stock! And for others, I believe this was a major turning point and an eye-opener as far as the Wait Interface goes (This has (un)officially been renamed to OWI as per Kirti's slides :-). Most attendees 'saw the light' as far as CHR (Cache Hit Ratio) goes, and there were two distinct camps after the first few days - the 'CHR' and 'OWI'. No prizes for guessing who won the day! The massive number of defections and the absolute absense of CHR-based-discussions at the Performance round tables was clear evidence that OWI is here to stay! (Mr. R might still rewrite that book sooner than later!) About 20 Listers met for dinner on Sunday night (and again in a larger group at the SeaWorld bash). The meeting was characterized by geek-talk such as 'Can you fit us all in one extent?' i.e. 'can we all sit at one table?'), 'Please coalesce' - 'please move in so that more people can fit into the aisle seats'. Oh Boy, that WAS a lot of fun! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Subject: Anything new from IOUG? Hi All that recently attended IOUG. If you don't already know - I sell tools for Oracle. (delete this now if you want to DG! ;P) I was just wondering if anybody at IOUG had any feedback on any new tools that were launched, or any tools that made a significant impact at IOUG? This is purely for vendor awareness for myself, as I like to keep up to date on anything new in and around our particular market place.. If anybody saw something and thought wow!, I'd be interested in hearing about it. If you would like to contact me directly about this - please feel free, though I feel
initjvm and rmjvm failing
Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG18853 Description: Binary data
RE: initjvm and rmjvm failing
Thanks Bruce The initjvmaux.sql was the key to the cleanup and increasing the Java_shared_pool to 50M got it going properly The metalink notes that I had read suggested 30 so I had 35MB Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 17-04-2002 02:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: initjvm and rmjvm failing Peter, On NT 817 I haven't succeeded in getting JVM to deinstall cleanly and have had to end up rebuilding databases. That said, have a look at bugs 1955536 and 1751857 for details of problems with deinstalling JVM and potential workarounds From bug 1955536: So, the first thing to try here is probably to . 1) restart the database 2) start a different session that the one the started the database 3) run initjvmaux.sql 4) run rmjvm.sql 5) do the following from bug 1751857 . drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg; . 6) restart the database - if you get trigger errors, ignore them make sure java_pool_size is at least 50MB 7) start a new session 8) try initjvm.sql . Keep spool files of everything. and then Note also that not only does running initjvm after rmjvm require a new session, it requires restarting the database instance. The newer versions of initjvm attempt to enforce this by exiting immediately if it can be detected that rmjvm has run in the same instance. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 17 April 2002 14:08 Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG63997 Description: Binary data
Re: Question about Forms Version
Hi You can try two books for learning Oracle Developer Advanced Forms and Reports by Dorsey and Koletzke I also have another one that Uni is using for a subject on Developer Enhanced Guide to Oracle 8i, Morrison Morrison both have supporting websites and Peter Koletzke hangs out on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = JoJo Zawawi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: Question about Forms Version Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG26619 Description: Binary data
Re: Question about Forms Version
I have both running on a laptop here the only thing that will happen is that Developer uses its own net8 client and as such sets the Oracle HOME to teh home you install Dev 6i in. You most likely will want to install a copy of your tnsnames in your Develop home. If you have the Home selector installed you will need to set the default home for the system back to the 8i home, other than that it seems to work OK Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = JoJo Zawawi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 10:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: Question about Forms Version Hi Peter, Thanks a lot for the book recommendations. I have another question: I have Oracle 8i on an NT box. I just downloaded Oracle Forms Developer 6i Release 2 for NT (which has as part of it, Oracle 9iAS Forms Services for NT). Can I install it on that same NT box, or is it going to mess up my Oracle 8i? (I couldn't find any earlier versions of Forms Developer on Oracle's site.) Thanks again, JoJo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 5:38 PM Hi You can try two books for learning Oracle Developer Advanced Forms and Reports by Dorsey and Koletzke I also have another one that Uni is using for a subject on Developer Enhanced Guide to Oracle 8i, Morrison Morrison both have supporting websites and Peter Koletzke hangs out on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = JoJo Zawawi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/04/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: Question about Forms Version Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG29483 Description: Binary data
RE: WHICH UNIX FOR ORACLE?
Yes It is so true I think the best option with what is best is probable get along to you local Oracle or whatever usergroup meetings and find out the war stories from those that are there. You might find that over time you see more of your IBM rep or Sun rep at those meetings, also a sign of the type of support you might get. I was supporting a product MFG/PRO on Progress in a couple of previous jobs and it was a fairly regular occurence to see a HP rep at teh user group meetings, they also seemed to have the lions share of sites for that product. Oh and HP's support isn't too bad here at present. but I also havent had a problem with Sun or IBM, Just lucky, maybe Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/04/2002 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: WHICH UNIX FOR ORACLE? Hi List, Glad this is turning out into a full scale war :) One thing that we need to remember is that this is Global list. So if Sun is strong in Singapore, HP is stronger in Australia - it all depends on who is supported from where and what is the level of training/skill of the engineers themselves regionally... So perceptions change! My experience with AIX was in a remote corner of the world (Can someone spot a 100 mile x 5 mile deep coastal country called Brunei? Hint - you can find it is part of a larger Asian Island). IBM S'pore had a local man with local on-site spares and although he was on call literally all the time, he did have his feet up in the air on a desk since the machines broke down _rarely_. Sun and HP hardware, patches and spare parts had to on the other hand arrive from S'pore and that took a while. As well, the local engineers were from a Sales agency rather than from the vendor, and had to drive about 100 miles to get there, maybe adding to my perception. Again. my perception of AIX in the US is that it does not have too much penetration, and thus that much less exposure as compared to HP and Sun. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Sakthi , Raj [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:32 AM To: Multiple recipients of list ORACLE-L Subject: RE: WHICH UNIX FOR ORACLE? John, I knew this...but again what else does anyone expect from a bunch of Hard core DBAs..:) (Damn this feels good..;) so it can't be bad to wage this kinda war...what do you think..?) Cheers, RS --- John Kanagaraj [EMAIL PROTECTED] wrote: Bunyamin, Here we go again! (Raj - this _is_ a war!!) My preference is: 1. AIX 2. HP-UX 3. Solaris Ultimately, it is a question of how much $$$ - now (purchase), later (maintenance costs), and how much when it goes down. I have managed about 150 AIX boxes at one time, and have not had H/w based difficulties running them. And still managed 6 Solaris boxes at the same time and had major headaches with the H/W... YMMV! -Original Message- From: Sakthi , Raj [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: WHICH UNIX FOR ORACLE? What are you planning..? A religious war..:) well..here is my 2 cents,IMHO 1. HP-UX 2. SOlaris 3. AIX in the order of preference. I have worked with all three and I found HP machines to be reliable and HP-UX easy to work with. This is not to say solaris is not but I had some nightmare stroies to tell about the bugs and quality of support from SUN. Again this is only my opinion and as everybody knows OS is ,to some extent ,a matter of personal choice also. ( Running to put on flame proof suit..:) ) Cheers, RS --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct
RE: Database shut itself down
Hi Lisa Just check that the files owner is who you think it should be and check the permissions. A great thing NT Admins are god for is changing permissions in a directory at teh top of a tree and propagating it down with teh include subdirectories checkbox. the OS error Access denied says either you don't have permissions on the file or another process is holding a file lock on it. A reboot of teh server should clear that if you cant resolve it by other means Oh and you are right Oracle holds exclusive locks on the files at the OS level and as such if you try and move or delete them it won't happen Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Koivu, Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/2002 07:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Database shut itself down I thought you couldn't delete a database file in Windows when the database is up? I have tried and tried to no avail. Maybe this is a nice 'feature' but it doesn't leave much room for testing br Lisa Koivu Oracle Database Brick House - 36-54-36 Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: John Hallas [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:53 PM To:Multiple recipients of list ORACLE-L Subject: Re: Database shut itself down Sorry to be the bearer of bad news That normally happens when someone has deleted the file by mistake. Other suggestions could be that it was being archived or locked by some other process which inhibited Oracle from updating the file. Has the database restarted OK. HTH John -Original Message- Dave Sent: 02 April 2002 20:03 To: Multiple recipients of list ORACLE-L I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the SIDAlert.log I have the following error. Tue Apr 02 10:47:40 2002 KCF: write/open error block=0x21de online=1 file=10 J:\ORANT\ORADATA\TDISPACH\DISDATA01_01.DBF error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied.' DBW0: terminating instance due to error 1242 Instance terminated by DBW0, pid = 287 This is a new for me. Any ideas what I am dealing with? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Re: Dynamic create and execute procedure
What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Bernard, Gilbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 30/03/2002 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Dynamic create and execute procedure I need to create a generic dynamic procedure to create and execute any procedure I wish. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 32-bit vs. 64-bit on HP-UX 11.0
Yes and its a good time to look at the whole server configuration from changes to mount points filesystem layouts swap space and just about any other thing you and your sysadmin can look at. A couple of years ago I had a HPUX 10-20 system that needed to be upgraded to 11 and the end result was that some the overnight batch processing times dropped from around 10 hrs to around 2 hrs. In this case it was mostly because of the fact we had added ram but had not been able to use it effectively due to inadequate swap space for the amount of RAM we had installed. So give it a good working over as part of the 11 upgrade. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sakthi , Raj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/2002 07:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: 32-bit vs. 64-bit on HP-UX 11.0 Kirti, I am assuming you are still looking for some answers to this. ( Allright I am late ..but it is because my network is slow..;) ) Having done several conversions on HP from 32 bit oracle to 64 bit I think I can safely say 64 bit is the way to go. There is a paper titled ORACLE 64-bit ADVANTAGES on metastink under system admin and platforms/misc. and it talks about HP also. I can't say I got 300% (??!) improvement but I found that apart from increase in memory addressing( Oh yeah.!..a whole lot of it ), utilities like exp and sqlldr ran atleast 30% faster on 64 bit. Could be the way the executables addressed the memory, I really don't know. As to recreate instead of migrate I think the poster got the OS mixed up with oracle. On HP if you are on 10.20 and going to 11.0 then the OS need to be completely wiped out and reinstalled or ORACLE will have a fit. I think it has got to do with some library functions which didn't change or had some different name on 11.0 and they get linked to oracle exe. When I contacted OTS in 1999 dec. they told me the same and I did some research on it and found that to be true. So we wiped out the 10.20 and reinstalled the 11.0 64 bit and everything went smooth. HTH Cheers, RS --- Deshpande, Kirti [EMAIL PROTECTED] wrote: All, Following is from the LazyDBA list. Any 64-byters on this list seen this ??? If so, can you please share you experience and findings? Thanks. - Kirti -Original Message- Sent: Wednesday, March 20, 2002 1:37 PM To: LazyDBA.com Discussion Don't upgrade, export, recreate the database and import or you will not get full benefit from 64 bit. At one client we saw a 300% performance boost on some processes by rebuilding the instance from scratch verses just migrating. Mike Original Message- Sent: Wednesday, March 20, 2002 2:52 PM To: [EMAIL PROTECTED]; Mike, Can you please elaborate, as to how exactly going 64-bit this way helped boost the performance by 300%? Don't you think that export/import helped some by eliminating chained rows (if any), reducing or eliminating block level fragmentation, reducing blevels in indexes etc. Or there weren't any of these issues to be concerned with. Just curious.. as we are pondering on such a move in the very near future... Thanks. - Kirti -Original Message- Sent: Wednesday, March 20, 2002 2:00 PM To: 'Deshpande, Kirti' Nope, they migrated the instance, then exported, dropped and imported back into the migrated instance as part of the testing process, then used the export to build a new 64 bit database. When the performance of the old migrated but rebuilt database was tested against the new imported database the processes that did many IOs, such as updates, took up to 300% longer on the migrated instance. Both instances where on the same host going against the same disk array. the initialization parameters where identical. The migrated instance showed nearly 300-400 percent more consistant gets for the same process leading me to believe it is some type of internal byte splicing technique being used to emulate the 64 bit environment in the migrated instance while true 64 bit is used in a new 64 bit instance. Exporting the migrated database, dropping the instance and recreating then importing brought the performance back in line with the other instance
RE: Do programmers tune SQL?
The Developers will also need really big PC's, Last company I worked for was using TogetherSoft and we found 256 MB RAM an absolute minimum requirement. If you don't have much knowlege of Java I suggest you get hold of some skills as well. I have just created a database utility to do what DBMS_UTLIITY.COMMA_TO_TABLE does but with out the restrictions on what can be in the input string. Quite an interesting exercise for learning about Java in the database. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/2002 12:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Do programmers tune SQL? All, We are in transition here at my site. Our primary development tool over the past few years has been a client-server tool named Uniface from Compuware, which does an excellent job of protecting developers from themselves. However, we are switching to Java, and moving more developers from the mainframe to an Oracle-Java system that is being developed. For a Java IDE, it looks like a tool named TogetherSoft. I am concerned that I will need to take a more active role with the developers. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 29, 2002 8:03 PM To: Multiple recipients of list ORACLE-L Greg, You *do* see DBA's doing the bulk of the SQL tuning work in many shops. But it's not necessarily because the developers, or at least some them, can't, or, that many of them don't care (and *many* of them never do give it a thought). I've seen places where the developers begged for the ability to turn on tracing in development, or to have a plan_table and/or the use of autotrace, and were denied. And other cases where the development, testing, and QA environments were so different from production that there was nearly no point. Anyway, just by virtue of their titles, I don't know that a DBA is any better at SQL tuning than a developer or vice versa (and I'm not pointing that comment at you, Greg, but just in general that I don't think the title of DBA or developer makes a difference). It really depends on their backgrounds and skill levels. I've seen, for the most obvious example, many DBA's and developers freak when they see a full table scan, never taking into consideration if that was the appropriate approach. Instead, they just lived by some rule that full table scans are bad. You see lots of things like that. Anyway, as someone who started off as both a DBA and developer, and drifts back and forth between the two and still serving in both roles, I can see both sides. I know DBA's who rant about the developers not giving a flip about performance when they write their code, and in many cases it is true, the issue of performance was never considered. But I also know many developers who *do* care and are hindered from doing so. By the same token, I know a lot of DBA's who are very good at SQL tuning, and tuning and general, and many more who aren't. So, what we can we do? We can work with the developers (and DBA's) and mentor them. We can teach the tricks and efficient styles (whether SQL itself or application design in general). And it really helps if we can provide an environment that mimics production (dollars and budgets make that hard to do in many cases). Sorry for the length, but it touches on something I'm dealing with right now. I'm helping some developers who are getting hammered about why their code performs so poorly in production. Heck, it ran great in all the other environments, there's not much more that they could have done. And yes, I now sit in on the code reviews making suggestions when something could be done better, and testing their code and every SQL statement against production. Often times requires significant work in stubbing out the DML pieces and duplicating the same logic when doing so. But if they aren't given a real environment, and, they are interested, I have sympathy when seeing them hammered for poor performing code and SQL statements when they did everything they could with what they were provided. Oh well, end of the week rant of sorts. I'm sending everyone a case of their favorite scotch if they just ask ;-) Just
Re: OT : Upgrade Unix OS with Veritas Volumn Manager
I suspect that you need a new version of Veritas Volume manager, I would check around the Veritas website for info. or there is a driver you need to load in the boot of the installation process. If you are still mystified try asking your question over on the sunmangers list. www.sunmanagers.org you almost certainly will find an answer there Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/03/2002 11:33 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:OT : Upgrade Unix OS with Veritas Volumn Manager Hi Unix Gurus, My UNIX administrator has to upgrade the OS from 5.6 to 5.8. We are using Veritas Volumn Manager. The upgrade fails because we are not familiar with Veritas Volumn Manager. Has anyone upgraded SUN-Solaris Unix OS from 5.6 to 5.8 with Veritas Volumn Manager ? Please help. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Re: CASE under Oracle8i
SQL SELECT CASE 2 WHEN DUMMY='X' THEN 'Dual is OK' 3 ELSE 'Dual is messed up' 4 END 5 FROM DUAL; CASEWHENDUMMY='X'THEN'DUALISOK -- Dual is OK DECLARE 2 dual_message VARCHAR2(20); 3 BEGIN 4 SELECT CASE 5 WHEN DUMMY='X' THEN 'Dual is OK' 6 ELSE 'Dual is messed up' 7 END INTO dual_message 8 FROM DUAL; 9 DBMS_OUTPUT.PUT_LINE(dual_message); 10 END; 11 / DECLARE dual_message VARCHAR2(20); BEGIN SELECT CASE WHEN DUMMY='X' THEN 'Dual is OK' ELSE 'Dual is messed up' END INTO dual_message FROM DUAL; DBMS_OUTPUT.PUT_LINE(dual_message); END; ORA-06550: line 4, column 11: PLS-00103: Encountered the symbol CASE when expecting one of the following: ( * - + all mod null an identifier a double-quoted delimited-identifier a bind variable table avg count current distinct max min prior sql stddev sum unique variance execute the forall time timestamp interval date a string literal with character set specification a number a single-quoted SQL string SQL Yep that about sums it up, the second one doesn't work in 8.1.7.0.0 Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 25/03/2002 01:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:CASE under Oracle8i If you run Oracle8i, and could conveniently test a couple of statements for me, I'd appreciate it. First, I believe the following should work under Oracle8i: SELECT CASE WHEN DUMMY='X' THEN 'Dual is OK' ELSE 'Dual is messed up' END FROM DUAL; I'm less certain about the following, which I vagualy recall hearing might not work under Oracle8i, but which does work under Oracle9i: DECLARE dual_message VARCHAR2(20); BEGIN SELECT CASE WHEN DUMMY='X' THEN 'Dual is OK' ELSE 'Dual is messed up' END INTO dual_message FROM DUAL; DBMS_OUTPUT.PUT_LINE(dual_message); END; Be sure to SET SERVEROUTPUT ON before executing the above. Otherwise you won't see the results. The point of all this is that I seem to recall hearing that, while SQL in 8i supported the CASE statement, that SQL within PL/SQL did not. I'm trying to verify the truth or falsity if that statement. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 817
Sorry 8.1.7.Release 3 is in fact 8.1.7.0.0. The Release 3 is the third release of 8i 8.1.5 Release 1 8.1.6 Release 2 8.1.7 Release 3 If you go to Metalink and select patches you can search for the Patches for your platform. There you will find the Patch 3 for your platform, if it is available Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = James A [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13/03/2002 07:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: 817 That should be patch if you got it off Oracle site. The base release is Oracle 8.1.7.0.0. Release 3 is the approved patch which brings you to 8.1.7.3.0. If you want further info search Oracle Metalink. good luck. -Original Message- Sent: Tuesday, March 12, 2002 12:30 PM To: Multiple recipients of list ORACLE-L HI ALL, I WAS LOOKING FOR 817 PATCH3 FOR 817 BUT THE ONLY THING WHICH I FOUND WAS 817 RELEASE3 IS THIS MEAN 8.1.7 PATCH3 OR NOT? I HAVE HEARED FOR UPGRADING FROM 8.1.6 FIRST INSTALL 8.1.7 THEN UPGRADE IT TO PATCH3 BUT I DON'T KNOW WHERE CAN I DOWNLOAD PATCH3. THANKS Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Poll Questions
One of my approaches for resolving this issue was to ask them exactly where they intended to build a test database to validate that bug out of the production environment, because sometimes those bugs don't show up in the stripped down developer database . There was also an issue of space and creating databases for recovery functions in disaster recovery Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Tracy Rahmlow [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13/03/2002 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Poll Questions We currently have a production, system and development database here. The system and development databases are purged periodically and reloaded with lookup data. The developers are then responsible for entering transactional data in both regions. I am looking to follow the same practice for development, however I would like to clone my production database directly to the system test database. The production database is ~75G. Management does not want to commit $ to a full sized system database. Costs outweigh the benefits. I would like to sway them. HOW? Please give me your costs/benefits of doing this. In addition, what is the norm (if there can be one) in other shops. Does utopia exist? ps. One of the biggest reasons for this database would be for benchmarking, timings, stress-testing. I realize I can copy the production stats, but that won't give me a good execution time. Do others load a subset of data (say 25%) and then extrapolate to a total time? Is that even necessarily accurate to do? I have my doubts. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP-UX Oracle Install
The trick is that when you run commands on that directory you the directory list gets parsed in such a way so that the -i file is at the top of the list. rm sees this as a parameter and as such invokes the interactive option of rm you then get asked whether you want to delete each file you create the file with a path something like touch /test/-i will create a directory in the test directory. Its really only a block on rm * type behaviour It is a help in stopping your files from getting clobberd by enthusiastic SA's Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/03/2002 01:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re: HP-UX Oracle Install Can you explain the An old sys admin trick is to put a file named -i in the directory that you don't want touched. Does this prevent deletions of the files or rebooting or unmounting the file system ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd [EMAIL PROTECTED] 28/02/2002 02:23 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: HP-UX Oracle Install Hi As long as you don't have issues with having data files mounted remotely ie you have a pretty robust network between the server this shouldn't be a problem just clearly mark/document the directories that you use on the server that you mount file systems from as sometimes clever sysadmins delete directories that they cant find owners of files. One issue that you can have a little problem but it is mostly cosmetic and that is if you don't use common UID's in Unix. I always did consider remotely mounting datafiles as not a bright idea but apparently NFS 3 alleviates most of those concerns. Still you cant help someone rebooting the remote server. An old sys admin trick is to put a file named -i in the directory that you don't want touched. HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Sujatha Madan [EMAIL PROTECTED] To:Multiple recipients Sent by: [EMAIL PROTECTED] of list ORACLE-L [EMAIL PROTECTED] cc: 28/02/2002 12:13 PM Fax to: Please respond to ORACLE-L Subject:HP-UX Oracle Install Hi, This may be more of a UNIX question, so please bear with me. We have a test server that has 1GB free space. We need to test our Oracle and application upgrade and there are no other servers other than this test server. Obviously there is not enough space. The powers above want to use two spare disks that are on our production system. Unfortunately they are part of a disk array and we can't remove them seperately and install them onto the test system. So what they want is to remotely mount these partitions (which are from the production server) onto the test system. That way I have more space and should be able to install Oracle. Does anyone know if this would cause a problem when installing Oracle? The production server already has two Oracle installations on seperate partitions. Could there be a conflict? I have a feeling there won't be a problem, but I just wanted to make sure. Thanks Sujatha --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 347
Re: Oracle OLE-DB
I love the java that Oracle provide for doing this sort of thing. You can simply have all of the files sent to the server and a process on the server can do it Oracle has CSV and XML parsers so you just hand it all off to the server to do. It will parse the files and then load it automatically into the databse for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Viral Amin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 23/02/2002 03:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Oracle OLE-DB Hi All Can anyone help me on this..Pls reply ASAP The requirement is as follows: -- The front-end is reading some data from external files (flat files like csv or maybe xml). -- The middle tier application (C++ component) is processing this information i.e. identifying the data and mapping the information to the respective table/column format -- The middle tier application is storing this mapped information in some kind of buffer/array -- The OLE-DB (or anything similar) set of functions/procedures should provide means to interface with this buffer and also the oracle database. I wanted to know if there is any layer (like OLE-DB or something similar) that can read this and provide functions that can insert/update data to the oracle database. Please let me know anyone's view on this. Let anybody forward me the ideas if any. Regards, Viral Amin -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Options instead of ODBC + MS-Access [Slightly? Off-topic]
Corvu, Cognos, Crystal reports(oops did I say that), Oracle Discoverer, Depends on the budget and what you really need to do. The first to are to very powerful tools but do cost a bit but they will use native links annd you can generate much smater queries with them Access and ODBC may well show performance problems as ODBC isn't generally a great performer. HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = O'Neill, Sean [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 21/02/2002 10:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Options instead of ODBC + MS-Access [Slightly? Off-topic] A developer here has put together a reporting package which uses ODBC to interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to extract data and generate nice GUI final presentation of data. The data extracted has various computations performed. The developer has asked what other Oracle or 3rd party options might be used to realise the same end results perhaps in a more efficient manner. Their concern is that as data volumes grow the performance will degredate substantially. Anyone any ideas?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: [sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vul
As I have done a bit of networking and set up stuff to monitor equipment with SNMP I will confirm that SNMP uses a port that the snmpd or equivalent listens to and then passes the request to the appropriate process depending on what is registered with the snmpd. This is usually done on unix if I remember using /etc/.snmp/conf. If really interested start looking in man snmpd Yes Oracle itself may not be vunerable but depending on the OS and system patches snmpd on that system may be vunerable so if your network engineers that did your firewalling are less than you hoped for you probably will have trouble. If your firewall is sound then I cant see this being a problem. your biggest worry in any site is the perimeter router as it nearly always has SNMP turned on for monitoring purposes and tools such as HP Openview to manage these. and you will have snmp open over the firewall between this router and the monitoring station /Openview system. Good firewall rules should protect you, but that is for your network engineers to decide. HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/02/2002 08:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Re[2]: [[EMAIL PROTECTED]: SANS FLASH ALERT: Widespread SNMP Vul Ray, No, but I do have a SA who believes that to be true. I'll try to explain it as he did. The DBSNMP agent registers a MIB with the snmp agent. It is the snmp agent that has the interface to the world. As he put it, it's not the back end that has the problem, but the front end that faces the network, namely the snmp agent. As to your nervousness, our facilities folks are using the back of my chair as a paint shaker. Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 2/14/2002 12:18 PM Dick, does this mean that you have firsthand knowledge that the oracle's snmp code is free from the underlying vulnerabilities? There was no mention of Oracle in the advisory. This could mean that they did not respond or they are not vulnerable. I posted to the Oracle Networking Technical Forum yesterday on this issue, but there has been no Oracle Corp response. You can search for SNMP to follow their response. Joan, Dick is certainly correct here with respect to the the system snmp agent. The sysadmins need to address this by either patching or disabling snmpd. However, unless Oracle confirms they did not use the old flawed code, I don't see any reason to assume their product is not vulnerable. Until they do, I will: 1) be nervous, 2) bug oracle corp, 3) confirm ip filter rules, 4) study dbsnmp On Thu, Feb 14, 2002 at 09:53:37AM -0800, [EMAIL PROTECTED] wrote: Joan, The Oracle intelligent agent which uses dbsnmp is not the problem here. The real problem is the snmp agent that is running on the computer and owned by root. Therefore your SA needs to do something, not you. Dick Goulet Reply Separator Author: Joan Hsieh [EMAIL PROTECTED] Date: 2/14/2002 7:48 AM Hi Ray, We use dbsnmp on the production server. How it will affect us? Our system people sent us the same article to us and very concerned the security. Joan Ray Stell wrote: Oracle does not seem to be listed, but you got to wonder what code they based their snmp stuff on. You may want to nudge you sysadmin in the ribs, also. - Forwarded message from The SANS Institute [EMAIL PROTECTED] - Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST) To: Ray Stell [EMAIL PROTECTED](SD569668) SANS FLASH ALERT: Widespread SNMP Vulnerability 1:30 PM EST 12 February, 2002 To: Ray Stell (SD569668) Note: This is preliminary data! If you have additional information, please send it to us at [EMAIL PROTECTED] In a few minutes wire services and other news sources will begin breaking a story about widespread vulnerabilities in SNMP (Simple Network Management Protocol). Exploits of the vulnerability cause systems to fail or to be taken over. The vulnerability can be found in more than a hundred manufacturers' systems and is very widespread - millions of routers
RE: my boss wants a report !!!
You might like to try and explain that they might be in perfect health today but when someone next runs some progam module that you have that they will not be in perfect heath and would need maintenance. Still I suppose you could do as so many before you have done Yes they are in perfect health as of today, and if they do let you go, when they come calling for your assistance then make sure you give then consultant rates as a big thank you for their past support. By the way have you had a look at Orasnap it will give you a good set of values to put together for them to peruse as good values today Cheers and have a good weekend -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/02/2002 03:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: my boss wants a report !!! Any plans for layoff?! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/14/02 11:13 PM list, the management has asked me to report the activities i do to make sure that all the DB's are in perfect health.!! Without being technical the report should somehow show the status of the DB's . I have decided to devide the report into the following sections - performance how to show the performance of the DB ??? without using any stats . - storage occupied / available - security unauthorized access - backup and recovery status of the hot standby database. could anyone point out some more information to include showing the performance of the DB ? Regards Rahul -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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).
