A free sql analysis tool
Dear All, I have found this Perl script that makes an analysis of 10046 SQL trace http://brainshed.com/software/ Kind Regards, Hatzistavrou Yannis
SQL*net message from client severly impact the Parse call of an insert statement
Dear All, I am faced with the following situation. Oracle 8.1.7.4. 64 bit , Solaris 8 There is a loader java process that when is executed against a test database(dwdsa)the response time is as expected to be. However when it is executed against the production instance (dwods) it is 2,5 to 3 times slower. I have traced the session on both occasions and reading the book of Carry Milsap I have spotted that the WAIT for SQL*Net message from client is very high for the PARSE call of an INSERT statement, whereas for the test instance there is no delay. I cannot however explain what might be the cause of this. Can somebody sched some light into this problem. Attached please find the SQL 10046 trace with level 8 a) Production trace (parser_dwods.zip) b) Test trace parser_dwdsa.zip Kind Regards, Hatzistavrou Yannis parser_dwods.zip Description: Zip compressed data The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. parser_dwdsa.zip Description: Zip compressed data
Slow process
Dear All, Seasons Greetings. I have the following problem: My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 . The last days the datawarehouse people complain that their load process which inserts data into tables is half time as fast as it was two days ago. From v$session_wait I can see that the process is spending time on SQL*Net message from client. The process is running on server and it is using PROTOCOL=BEQ and not TCP. May somebody help me clear this mess. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
RE: OpenLDAP instead of OID
in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Hatzistavrou John 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 Licensing
Dear All, Oracle licensing has been a subject that often is risen by somebody. I though I shall share this with you. Regards, Hatzistavrou Yannis Oracle_SW_License_Guide.pdf Description: Binary data
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
Title: Message Sorry, It is not readable. Kind Regards, Hatzistavrou Yannis -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 6:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Do not connect Oracle DB to the Internet. Oracle Alert #59 Hi MikeHere it is again. Let me know if you can read it.tatonyAt 08:54 AM 23/10/2003 -0800, Vergara, Michael (TEM) wrote: Tony:I did not receive the attachment clearly. Can you re-send itor cite the source?Thanks,Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 23, 2003 6:25 AM To: Multiple recipients of list ORACLE-L Subject: Do not connect Oracle DB to the Internet. Oracle Alert #59 Important: Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah? Buffer Overflow in Oracle Database Server Binaries This is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' file in $ORACLE_HOME/bin. Description A potential buffer overflow has been discovered in the "oracle" and "oracleO" (the letter O) binaries of the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflow to execute code on the operating system hosting the Oracle Database server. Products Affected Oracle 9i Database Release 2, Version 9.2.x Oracle 9i Database Release 1, Version 9.0.x Platforms Affected All supported UNIX and Linux operating system variants. Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman? I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publicly ta tony
RE: dbms_job issue.
Have you checked number of queues lately? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 8:30 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job issue. Hello List, I am running into weird dbms_job issue. I have a dbms_job to collect perfstat every 1 hour , job was running fine for last 8-9 months without any issue. For last 3 days job is stopping every night around 2 AM. I amnot seeing any trace file, any logs in alert file. Any idea what is cuasing this. Below is the output from dba_jobs. We are on 9202 AIX 5L. JOB LAST_DATE NEXT_DATE THIS_DATE B FAILURES TOTAL_TIME -- -- -- -- - -- -- 45 18-SEP-03 02:01:02 18-SEP-03 03:00:00 N 0 175 DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: get sid (session id) and serial#?
Check SYS_CONTEXT
Select sid,serial# from v$session where audsid = (select
sys_context('USERENV','SESSIONID') from dual);
Kind Regards,
Hatzistavrou Yannis
-Original Message-
Sent: Friday, August 29, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L
DABs,
Is there any way in my connection to get the sid and serial# for my own
connection?
Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED]
In this connection,
SQL
What shoud I input to get this sid and serial#?
TIA
Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally privileged information. If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited. If you receive this
transmission in error please notify the author immediately by telephone and
delete all copies of this transmission together with any attachments.
--
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: Hatzistavrou John
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: Query results to .csv
Well, you might as well search akstom.oracle.com for owa_sylk Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Monday, August 25, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Hi, Whats the best way to write the results of a SQL query to a CSV file? Thanks. _ Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Imran Ashraf 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: Hatzistavrou John 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
Part of the standard sql as was in 8i Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 12, 2003 9: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: Hatzistavrou John 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).
Problems connecting with Oracle Internet directory Manager
Title: Problems connecting with Oracle Internet directory Manager Dear All, I have installed the product after some manual intervention but now I am stuck when I am trying to use Oracle Directory Manager. Although I have manually started the OID mon and OID server and checked their logs and the Task Manager that everything is ok when I try to connect through Oracle Directory Manager as orcladmin I always get the error Server is not up and running which gives as details Server is not up and running:ldapoid.evergy.local/389 Oracle.ldap.admin.common.SaveChangeException: Server is not up and running:ldapoid.evergy.local/389 At oracle.ldap.admin.Root.saveChanges(Root:java:805) At oracle.ldap.admin.common.AdminPropView.saveChanges(AdminPropView.java:710) At oracle.ldap.admin.client.propEditors.TabView.commit(TabView.java:538) At oracle.ldap.admin.client.AdminUtil$logonCmds.run(AdminUtil.java:727) At java.lang.Thread.run(Thread.java:466) Any help will be greatly appreciated Oracle : 8.1.7.3 O/S: Windows 2000 Sp3 OID: 2.1.1 Kind Regards, Hatzistavrou Yannis
RE: Redo Logs Problem
Have you checked whether any tablespace is left in hot backup mode? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Subject: Redo Logs Problem Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client). Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated. Regards Munish Bajaj
RE: Oracle and OpenLDAP server
I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: Stefan Jahnke 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: Hatzistavrou John 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 and OpenLDAP server
I am looking forward to your feedback. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Hi Yannis (or John ?) That's GREAT. Exactly what I was looking for. I'll play around with it on the weekend and give some feedback to the list next week (if somebody is interested, that is). Thanks a lot ! Stefan -Ursprüngliche Nachricht- Von: Hatzistavrou John [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003 10:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: DENNIS WILLIAMS 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: Stefan Jahnke 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: Hatzistavrou John 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ORA600 [2103] [0] [0] [1] [900] -- Wrapping up
Phone ext. 478 Email: mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Hatzistavrou John 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: ORA600 [2103] [0] [0] [1] [900]
It is a local filesystem Kind Regards, Hatzistavrou Yannis -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA600 [2103] [0] [0] [1] [900] 1. Try writing the backup to another location alter database backup controlfile to '/tmp/cntrlfilebk.dbf' 2. Try it again with the reuse clause 3. Is the file system '/hot_backup/siebelp1' local or NFS mounted ? Hemant At 02:45 AM 12-06-03 -0800, you wrote: Dear All, I have encountered the following message during alter database backup controlfile to reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8. Attached please find extracts from alert and trace files a) alert hread 1 advanced to log sequence 41062 Thu Jun 12 02:33:43 2003 ARC1: Beginning to archive log# 1 seq# 41061 Thu Jun 12 02:33:43 2003 Current log# 2 seq# 41062 mem# 0: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log Current log# 2 seq# 41062 mem# 1: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log Thu Jun 12 02:33:44 2003 Completed: alter database backup controlfile to trace Thu Jun 12 02:33:44 2003 alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse Thu Jun 12 02:49:10 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 ARC1: terminating instance due to error 600 Instance terminated by ARC1, pid = 16563 Thu Jun 12 02:49:47 2003 Starting ORACLE instance (normal) b) trace Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production ORACLE_HOME = /oracle_home/product/8.1.7 System name: SunOS Node name: apps01-n01 Release: 5.8 Version: Generic_108528-21 Machine: sun4u Instance name: siebelp1 Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1) *** 2003-06-12 02:49:08.500 *** SESSION ID:(137.947) 2003-06-12 02:49:08.463 TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900 === SYSTEM STATE System global information: Number of NUMA instances : 1 processes: base 9010fe44, size 250, cleanup 90110864 allocation: free sessions(0) 90174724, free calls(0) 1 control alloc errors: 0 (process), 0 (session), 0 (call) system statistics: 0 47997 logons cumulative 0 1052 logons current 0 1649040 opened cursors cumulative 0 41528 opened cursors current 0 1311839 user commits 0 7201 user rollbacks 0 30519546 user calls 0 22909587 recursive calls 0 1827715 recursive cpu usage 0 1553098488 session logical reads 0 0 session stored procedure space 0 6209740 CPU used when call started 0 143359357 CPU used by this session 8236 791247589 session connect time 8236 791247589 process last non-idle time 1020 304666384 session uga memory Has anybody encountered such problem before? How can it be resolved? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
ORA600 [2103] [0] [0] [1] [900]
Title: ORA600 [2103] [0] [0] [1] [900] Dear All, I have encountered the following message during alter database backup controlfile to reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8. Attached please find extracts from alert and trace files a) alert hread 1 advanced to log sequence 41062 Thu Jun 12 02:33:43 2003 ARC1: Beginning to archive log# 1 seq# 41061 Thu Jun 12 02:33:43 2003 Current log# 2 seq# 41062 mem# 0: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log Current log# 2 seq# 41062 mem# 1: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log Thu Jun 12 02:33:44 2003 Completed: alter database backup controlfile to trace Thu Jun 12 02:33:44 2003 alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse Thu Jun 12 02:49:10 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 ARC1: terminating instance due to error 600 Instance terminated by ARC1, pid = 16563 Thu Jun 12 02:49:47 2003 Starting ORACLE instance (normal) b) trace Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production ORACLE_HOME = /oracle_home/product/8.1.7 System name: SunOS Node name: apps01-n01 Release: 5.8 Version: Generic_108528-21 Machine: sun4u Instance name: siebelp1 Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1) *** 2003-06-12 02:49:08.500 *** SESSION ID:(137.947) 2003-06-12 02:49:08.463 TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900 === SYSTEM STATE System global information: Number of NUMA instances : 1 processes: base 9010fe44, size 250, cleanup 90110864 allocation: free sessions(0) 90174724, free calls(0) 1 control alloc errors: 0 (process), 0 (session), 0 (call) system statistics: 0 47997 logons cumulative 0 1052 logons current 0 1649040 opened cursors cumulative 0 41528 opened cursors current 0 1311839 user commits 0 7201 user rollbacks 0 30519546 user calls 0 22909587 recursive calls 0 1827715 recursive cpu usage 0 1553098488 session logical reads 0 0 session stored procedure space 0 6209740 CPU used when call started 0 143359357 CPU used by this session 8236 791247589 session connect time 8236 791247589 process last non-idle time 1020 304666384 session uga memory Has anybody encountered such problem before? How can it be resolved? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
RE: passing ref cursor on a procedure
Title: passing ref cursor on a procedure Example Package ll is Type lrec is record( ? A ?integer, ? B? varchar2(72)); Type lrectype is REF CURSOR return lrec; Procedure getl( par1 in varchar2, ?? Xcursor IN OUT lrectype); End; Now , HOW do I execute procedure getl from sqlplus? Kind Regards, Hatzistavrou Yannis ? -Original Message- From: Regis Biassala [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: passing ref cursor on a procedure example -Original Message- From: Hatzistavrou John [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: passing ref cursor on a procedure Dear All, I have a vendor procedure which I wish to run . This procedure takes as input variables a varchar and a ref_cursor. I know the query that is related to the ref_cursor and I wish to implicitly pass it to the procedure . How can this be done? Kind Regards, Hatzistavrou Yannis * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. **
RE: StoredProc SQL statistics
DBMS_PROFILER Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Hi People, Is there any way to find the statistics(like tkprof gives) of SQL's within storedproc , when storedrpoc is called. Basically I want to find culprit SQL within StoredProc. Any help is appreciated Regards Sam __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sam d 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: Hatzistavrou John 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).
copycommit probs
Title: copycommit probs Dear All, I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA-12154 eror. How can I resolve this? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
RE: copycommit probs
Title: copycommit probs Case resolved. Hint. Copy does only use the alias in tnsnames.ora and not the loopback db_links Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- From: Hatzistavrou John Sent: Thursday, March 06, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: copycommit probs Dear All, I am trying to copy a local table to another local . I have created the link which is working when doing a select but when it comes to copying it gives an ORA-12154 eror. How can I resolve this? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
RE: oracle version
From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa 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: Hatzistavrou John 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).
Geneva application
Title: Geneva application Hi, I wish to hear from those that have been administrating Oracle instances of Geneva billing application. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
DBMS_SQL
Title: DBMS_SQL Dear All, I am trying to pass to dbms_sql.parse dynamic values from a cursor declared before the call by the dbms_sql.parse. I am getting ORA 1001 . How can I do that? Kind Regards, Hatzistavrou Yannis
Ora-1001
Title: Ora-1001 Dear all, I am trying to construct the following PL/SQL block. When I run it I always get an 0RA-1001 error. May you please help me Environment Oracle 8.1.7.0 O/S W2K Sp3 declare l_cursor integer := dbms_sql.open_cursor; output utl_file.file_type; cursor lnklst_cur is select db_link lnk from dba_db_links; lala varchar2(300); begin for lnklst_rec in lnklst_cur loop output := utl_file.fopen( 'c:\', lnklst_rec.lnk||'_tablespace_healthcheck_20030213.slk', 'w', lala := ' select tablespace_name from dba_tablespaces@'||lnklst_rec.lnk; utl_file.put_line(output , lala); dbms_sql.parse( l_cursor,lala ,dbms_sql.native ); /*owa_sylk.show( p_file = output , p_cursor = l_cursor, p_sum_column = owa_sylk.owaSylkArray( 'N' ), p_show_grid = 'YES' );*/ dbms_sql.close_cursor( l_cursor ); utl_file.fclose( output ); end loop; end; (DC07DB-SYSADM)/ declare * 1: ORA-01001: cursor ORA-06512: SYS.DBMS_SYS_SQL, 824 ORA-06512: SYS.DBMS_SQL, 32 ORA-06512: 12 It seems that dbms_sql.parse cannot understand the statement. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
Need some insight views
Title: Need some insight views I wish to hear from those that have experience supporting Oracle databases for Geneva billing systems and Siebel. It will be greatly appreciated if somebody can advise me on any hotspots. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED]
