RE: ORACLE 9i doesn't start on Linux Solved
Hi, Thank you very much. It solved my problem. Zsolt Csillag Hungary At 12:38 2002.04.11. -0800, you wrote: Hi Zsolt , check /etc/oratab, you may need to replace N by Y hth Vadim -Original Message- Sent: Thursday, April 11, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Hi, I've installed Oracle 9i on Suse Linux 7.1. The lsnrctl starts nicely, however when I type dbstart then it does absolutelly nothing. No error message, but the database won't start. Any ideas? Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Data transfer between 2 databases
Hi, I have an Oracle Database on Intranet network that is used for internal program ( insert, update etc.). The other database will be at the Internet provider and our cgi will run on it. Because the users on the Internet should see the actual data and the users can make some inserts in the database - I need to transfer records in both way, from one database to the other and inverse. What makes my problem even worse - only the Internet provider's Oracle has fix IP address, the other that is on the internal network doesn' t. Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
How to prevent Oracle 9i for Windows from starting?
Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: The code doesn't work in the package
Hi, Thank you for your help. Now it works. At 11:00 2001.12.16. -0800, you wrote: You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs. joe Csillag Zsolt wrote: Hi, The following code work as you can see below, but if I put this code in a package ( a procedure in a package) then I got ORA-01031 insufficient privileges error. This is absurd for me because it's the same user (an administrator) that owns the package, tablespace, table and everything. From a pl/sql block it works perfectly with the same user. *Declare * Command *VarChar2*(*1000*) ; *Begin *Command := *'create table PROBA1 ( PROBA1_1 NUMBER, PROBA1_2 VARCHAR2(50) ) tablespace XXX pctfree 10 pctused 40 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited )'* ; *Execute* *Immediate* Command ; *end* ; -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Csillag Zsolt 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).
The code doesn't work in the package
Hi, The following code work as you can see below, but if I put this code in a package ( a procedure in a package) then I got ORA-01031 insufficient privileges error. This is absurd for me because it's the same user (an administrator) that owns the package, tablespace, table and everything. From a pl/sql block it works perfectly with the same user. Declare Command VarChar2(1000) ; Begin Command := 'create table PROBA1 ( PROBA1_1 NUMBER, PROBA1_2 VARCHAR2(50) ) tablespace XXX pctfree 10 pctused 40 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited )' ; Execute Immediate Command ; end ;
1 1 ??? Strange problem
Hi, I have noticed this strange error with two different database: 8i and 9i. We have a cgi that worked well under 8i but not under 9i. The problem was here : If MyString = '' Then Return xxx End If ; It never went in. I tried the following : If 'string' = 'string' Then -- never come here End If ; If 1 = 1 Then -- never come here either End If ; I don't understand why. Is this a bug? There was a 8i database previously that behaved in this manner but after a time it solved the problem by itself. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Morpheus killed my Oracle! Help!
Hi, Unfortunatelly my Oracle runs under Windows Nt, so I have no inetd.conf :-( At 17:20 2001.11.25. -0800, you wrote: Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 Csillag Zsolt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26/11/2001 09:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject: Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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. Zsolt Csillag Hungary
RE: Morpheus killed my Oracle! Help!
Hi, At 20:34 2001.11.26. +, you wrote: Hi, I don't know what Morpheous is, but have you tried netstat -an to find out which ports really are in use. For example on my notebook: rem no listener running When I type netstat then: TCP nt:1025 localhost:026 ESTABLISHED TCP nt:1026 localhost:025 ESTABLISHED TCP nt:1076 10.0.0.17:1521 SYN_SENT My listener.log contains: Megfigyelési kisérlet a következon: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nt)(PORT=1521))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW))) TNS-12542: TNS: ezt a címet már más használja - This address is being used TNS-12560: TNS: protokoll adapter hiba TNS-00512: Ezt a címet már más használja 32-bit Windows Error: 48: Unknown error Thank you H:\netstat -an | find 1521 H:\ H:\lsnrctl start rem and the listener output was here. The command completed successfully H:\netstat -an | find 1521 TCP0.0.0.0:1521 0.0.0.0:0 LISTENING H:\ so after listener was running I have something listening on port 1521. Does your winnt\system32\drivers\etc\services file get updated by Morpheous? If so, maybe it will tell you what ports are used. When you try to start the listener service what gets written into the listener log file? HTH, Bruce Reardon - Csillag Zsolt [EMAIL PROTECTED] 26/11/2001 09:00 AM Subject:Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Dba studio under 9i for Linux?
Hi, Thank you very much. It works. At 10:40 2001.11.18. -0800, you wrote: Hi, Use oemapp in $ORACLE_HOME/bin. oemapp requiers some parameter (that tells witch program to start (DBA studio among others)). If you call it without parameters it will tell you possible values. regards torben holm Csillag Zsolt wrote: Hi, Can you tell me where can I find Dba Studio under Oracle 9i for Linux. I've tried the different files in the Bin directory with no result. T.I.A. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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). Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Morpheus killed my Oracle! Help!
Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
lsnrctl error
Hi, I've installed Oracle 9i. I can start the database, but when I want to run lsnrctl I get the message: Message 414 not found;No message file for product=network, facility=nms Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Linux client error
We have Oracle 9i under Suse Linux. I installed DOA for Kylix. After putting an Oracle Session on the form and made a Connect I received the following error message: Initialization error Could not load home/oracle/OraHome/lib/libcIntsh.so OCIDLL forced to home/oracle/OraHome/lib/libcIntsh.so Load library home/oracle/OraHome/lib/libcIntsh.so returned 0 This seems crazy because this libcIntsh.so _is_ in the directory. On the other hand Oracle works perfectly, I can connect via Sql Plus and the Orahome is in path and environment settings. I've been told that It turned out that the Oracle client library ($ORACLE_HOME/lib/libclntsh.so) contained an undefined symbol __cmpdi2. Can somebody help me? Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Dba studio under 9i for Linux?
Hi, Can you tell me where can I find Dba Studio under Oracle 9i for Linux. I've tried the different files in the Bin directory with no result. T.I.A. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Group by problem
Hi, If I have the following query: Select a.column1, count(*) from a, b where a.column2 = b.column2 It works correctly, it displays the correct number in the count. However there are records that don't meet the criteria 'where a.column2 = b.column2' So I modified the query: Select a.column1, count(*) from a, b where a.column2 = b.column2(+) Now with (+) it displays every record, but the problem is that in case there is no relation, the count displays 1 instead of 0. In other cases it is good. But I can't decide from the program if it's 1 because it had 1 relation in table b, or 1 because it hadn't got any relation. Can you help me work around this problem? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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[2]: For i (Select..)
Thank you very much. Your answers explained everything about explicit and implicit cursors. At 07:00 2001.10.02. -0800, you wrote: You can do all three, but if you do not declare it you can't use the 'for update of' clause. Of course the 'for i in ()loop' does replace a lot of lines of code. Dick Goulet Reply Separator Author: Steve Smith [EMAIL PROTECTED] Date: 10/1/2001 7:50 PM You can also use the for loop - end loop with explicit cursors.. You don't have to define the cursor in the loop itself.. That is my preferred method (defining the cursor in the declare section and referencing it in the for loop).. There really isn't any more work defining the cursor up front and then using the for loop as there is using the for loop and defining the cursor in the loop.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 01, 2001 6:01 PM If you only use a cursor in this manner, the only place that the cursor can be used is in the particular For Loop in which it is defined - it can't be shared by other procedures or functions. If you design and create packaged public cursors, they can be reused from other stored procedures and/or client side programs. Code reuse is just one advantage. When table structures change - as they invariably do - you have only a few cursors to change, instead of a bazillion Cursor For Loops. Also, you can more easily tune a few public cursors. I'd also recommend passing in Table%RowType arguments to your public cursors and specifying that they return Table%RowType records. That further isolates your code from table changes. Jack Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
For i (Select..)
Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop ; I have tried it and it works great. The question is that what is the difference betwen a cursor and the code above? Which is more efficient? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: For i (Select..)
Hi, If this code is a cursor then why doesn't everybody use it this way? For me it seems a lot simplier and easier than declaring a cursor in a normal way. At 14:50 2001.10.01. -0800, you wrote: the code IS a cursor --- Csillag Zsolt [EMAIL PROTECTED] wrote: Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop ; I have tried it and it works great. The question is that what is the difference betwen a cursor and the code above? Which is more efficient? Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Bulk collect error
Hi, Type T_FofejezetNev_Table IS TABLE OF Fofejezet.Fofejezet_Megnevezes_Magyar%Type INDEX BY BINARY_INTEGER; Type T_FofejezetKod_Table IS TABLE OF Fofejezet.Fofejezet_Azonosito2%Type INDEX BY BINARY_INTEGER; Type T_SzamTomb IS TABLE OF Pls_integer INDEX BY BINARY_INTEGER; TYPE T_FOFEJEZET IS RECORD ( FoFejezetNev T_FofejezetNev_Table, FoFejezetKod T_FofejezetKod_Table, Darab T_SzamTomb ); Vissza T_FOFEJEZET ; And the code I can't complile : Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2 , (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= f.Fofejezet_Azonosito2) Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; When I want to compile I get PLS-00103 error. At 11:10 2001.09.20. -0800, you wrote: What is the definition for Vissza.FoFejezetNev and Vissza.FoFejezetKod and Vissza.Darab ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Bulk collect error
Hi, I think I provided the details you need. But to be sure : Oracle 8.1.6 Personal edition, cost based optimizer. The problem is that I can' t TRANSLATE the package because of PLS-00103 error. So there should be a syntax problem but I don' t know what I' ve done wrong. Thanx At 04:20 2001.09.20. -0800, you wrote: Can you provide simplified resource details -Original Message- From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 11:40 PM To: Multiple recipients of list ORACLE-L Subject: Bulk collect error can you provide simlified resource details. Hi, The following statment works perfectly: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) From Fofejezet F ; However when I put this very same statement into a Pl/Sql procedure with Bulk Collect, I get PLS-00103 error: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; Can somebody help me? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Nirmal Kumar Muthu Kumaran 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). Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Bulk collect error
Hi, The following statment works perfectly: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) From Fofejezet F ; However when I put this very same statement into a Pl/Sql procedure with Bulk Collect, I get PLS-00103 error: Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2, (Select Count(*) from alfejezet where alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2) Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab From Fofejezet F ; Can somebody help me? Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Surprising event
Hi, We have a cgi that displays data from oracle tables. The program has been running for several months perfectly. Last week every time it started, it seemed to almost freeze the Oracle server , it didn' t end the operation (many Select statements). After several hours of work we removed the /*+ FIRST_ROWS */ hints from some of the selects and the problem went down to 50% ( It woult be a long story to tell all the details). At last we recreated _all_ the indexes and the problem dissapeared, everything was fine again. Question: Should a bad index cause a problem like this and why? If an index is bad how come Oracle doesn' t see it? It is important for me to know that for I don' t want to run in this problem again. Thank you Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Order by question - newbie
Hi, I have a table with 3 colums : PersonalCode, Name and SpecialOrder. The PersonalCode is the primary index and I have also an index on SpecialOrder,Name columns. However the following select: Select PersonalCode From MyTable Order By SpecialOrder,Name doesn't use the SpecialOrder,Name index at all. If I watch it in Explain Plan window I can see that : SELECT STATEMENT, GOAL = CHOOSE1181163782456700 SORT ORDER BY1181163782456700 TABLE ACCESS FULLADMINMyTable69163782456700 How can I make the index work? Thank you in advance Zsolt Csillag Hungary
RE: Rollback after truncate?? + 2 more questions :-)
Tom, Thank you for your answer - it has solved my problem. At 05:11 2001.08.16. -0800, you wrote: Zsolt, The correct call for the function if the function exists within the package would be: Insert into A ( Select Col1 ,PackageName.MyFunction(Col1) from B ); Tom Mercadante Oracle Certified Professional Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Rollback after truncate?? + 2 more questions :-)
Hi, 1.Can I rollback after doing a truncate table (it seems to me that I can' t) e.g. Execute Immediate 'Truncate Table '|| TablaNevTomb(i); Execute Immediate 'Begin '|| 'Insert into '|| TablaNevTomb(i) ||' (Select * From X$_'||TablaNevTomb(i)||');'|| 'End;'; Exception When others Then RollBack 2. Is there a way to use a command with more than one word in Pl/Sql without using it dynamically? For example I can use Truncate table only with Execute immediate within a Pl/Sql block. 3. I have a statement in a package: Insert into A ( Select Col1 ,MyFunction(Col1) from B ); If the MyFunction function is made with create or replace function everything works perfectly, but if the same function is declared within the package, I get the error message: PLS-00231 function 'string' may not be used in SQL Thank you for your help Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Update ALL colums without knowing their name??-correction
Hi, Thank you for your answer. Unfortunatelly I can't truncate, then insert into ... select ( I myself thought about it before )because the tables are always used ( there are always a few users connecting to database). Thank you Zsolt Csillag Hungary At 13:52 2001.07.23. -0800, you wrote: Are you just trying to totally refresh table1 from table 2? how about: 1. TRUNCATE table1; 2. INSERT INTO table1 SELECT * FROM table2; (assuming structures of the two tables are compatible) Or am I just totally missing the mark in what you are looking to do? Jon [EMAIL PROTECTED] -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Subject: Update ALL colums without knowing their name?? Hi, I need an universal update procedure in which I don' t know the colums name. How can I make an update like this: Update Table1 set Every_columns = ( Select * from Table2) I tried set Table1.* wiht no result. How can I work around this? Csillag Zsolt www.star-soft.hu
Update question - a little newbie
Hi, I have several tables in a tablespace. Every real (used) table has a clone table in another tablespace with the same field structure. What I have to do periodically, with example: Real Table: cNumcName -- 1 First 2 Second 3 Third 4 Forth 5 Fifth Clone Table: cNumcName -- 1 First 2 Second 4 Forth 5 Fifth 6 Sixth 1.Delete all rows that are in real tables that are not in the clone tables ( delete Third) 2.Update the real tables with the rows of the clone tables ( update First,Second,Forth,Fifth) 3.Insert into real tables the valus that are in clone tables but not in real tables ( insert Sixth) Unfortunatelly I can't use Truncate and then Insert Into RealTable(Select * from CloneTable); due to database charteristics ( there are tables that overlappes each other) so I have to use Update to do this. For there are many real and clone tables I'd like to make an efficient procedure that can do the whole thing. Can you send me some sample code how to make the update? I have tried to make Cursors with 'for update' but it seems too rigid for me: 1. in Update statement I have to fill the Set colums e.g. I can't use Set RealTable.* = 'values' 2. If I have a cursor: CURSOR MyCursor IS SELECT * FROM RealTable,CloneTable Where RealTable.Column1 = CloneTable.Column1 FOR UPDATE ; I get the error: PLS-00402 alias required in SELECT list of cursor to avoid duplicate column names. That's correct since the two tables has the same structure. Thank you for your help Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: I still can't install Oracle on Linux - help
Hi, Thank you for your help. The problem is I can't download the 1.1.8 Java from www.blackdown.org because every link responds with 'Server not available' or something like this. Can you send it to my e-mail address? ( [EMAIL PROTECTED]) Thank you very much Zsolt Csillag, Hungary At 09:56 2001.07.18. -0800, you wrote: The Java that comes with Oracle is broke. Sorry. Here's how you can make it work, at least it did for me using SuSE 7.1 and Oracle 8.1.7. Get the 1.1.8 Java from www.blackdown.org Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
I still can't install Oracle on Linux - help
Hi, I have the following environment: Suse 7.1, Oracle 8.1.6, 256 Mb Ram, KDE, Java runtime (I hope I installed it correctly). When I run the Installer from Kde, it makes nothing, but if I run from terminal window I get a very long list ended by an OK. I'm going to paste below the whole message, I hope somebody will help : oracle@linux:~ cd /cdrecorder oracle@linux:/cdrecorder ./runInstaller oracle@linux:/cdrecorder Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... SIGSEGV received at bfffd994 in /cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads/libjava.so. Processing terminated Wed Jul 18 17:06:53 2001 jre full version JDK 1.1.8 IBM build l118-2429 (JIT enabled: jitc) Operating Environment - Host : linux. OS Level : 2.2.18.#1 Mon Feb 5 17:56:44 GMT 2001 glibc Version : 2.2 No. of Procs : 1 Memory Info: total: used: free: shared: buffers: cached: Mem: 268017664 239714304 28303360 0 126836736 39231488 Swap: 115109888 0 115109888 MemTotal: 261736 kB MemFree: 27640 kB MemShared: 0 kB Buffers: 123864 kB Cached: 38312 kB BigTotal: 0 kB BigFree: 0 kB SwapTotal: 112412 kB SwapFree: 112412 kB User Limits (in bytes except for NOFILE and NPROC) - RLIMIT_FSIZE : infinity RLIMIT_DATA : infinity RLIMIT_STACK : 2093056 RLIMIT_CORE : 0 RLIMIT_NOFILE : 1024 RLIMIT_NPROC : 1024 Application Environment --- Signal Handlers - SIGQUIT : ignored SIGILL : sysThreadIDump (libjava.so) SIGABRT : sysThreadIDump (libjava.so) SIGFPE : sysThreadIDump (libjava.so) SIGBUS : sysThreadIDump (libjava.so) SIGSEGV : sysThreadIDump (libjava.so) SIGPIPE : ignored SIGUSR1 : doSuspendLoop (libjava.so) Environment Variables - PWD=/cdrecorder/install LTDL_LIBRARY_PATH=/home/oracle/.kde2/lib:/opt/kde2/lib konq_sm_file=/opt/kde2/share/config/SuSE/config/konqueror:1054d0ebe29756685240014220002 PAGER=less GLX_NO_DIRECT=t HOSTNAME=linux LD_LIBRARY_PATH=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/linux/native_threads:/lib:/usr/lib:/opt/kde/lib:/home/oracle/.kde2/lib:/opt/kde2/lib LS_OPTIONS=-N --color=tty -T 0 ignoreeof=0 KDEDIRS=/etc/opt/kde2:/opt/kde2 KDEHOME=/home/oracle/.kde2 POVRAYOPT=-l/usr/lib/povray/include SUSE_DOC_HOST=localhost QTDIR=/usr/lib/qt OPENWINHOME=/usr/openwin D=32 CLASSPATH=/tmp/OraInstall0:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/OraInstaller.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstImages.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/InstHelp.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/oracleice.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/help.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/ewt.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/xmlparser.jar:../stage/Components/oracle.swd.oui/1.7.0.18.0A/1/DataFiles/Expanded/lib/swingaccess.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/rt.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/i18n.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/math.jar:/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/lib/classes.zip LESSKEY=/etc/lesskey.bin LESSOPEN=|lesspipe.sh %s MANPATH=/usr/local/man:/usr/share/man:/usr/man:/usr/X11R6/man:/usr/openwin/man LANGUAGE=hungarian NNTPSERVER=news KDEDIR=/opt/kde LESS=-M -S -I USER=oracle LS_COLORS= HISTCONTROL=ignoredups XSESSION_IS_UP=yes THREADS_TYPE=native_threads MACHTYPE=i386-suse-linux XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB THREADS_FLAG=native LANG=hu_HU GNOMEDIR=/opt/gnome JAVA_HOME=/cdrecorder/stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux COLORTERM=1 X=1024 INFOPATH=/usr/local/info:/usr/share/info:/usr/info Y=768 DISPLAY=:0 LOGNAME=oracle SHLVL=3 TEXINPUTS=~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:~/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX MINICOM=-c on INFODIR=/usr/local/info:/usr/share/info:/usr/info SESSION_MANAGER=local/linux:/tmp/.ICE-unix/667 KDE_INITIAL_DESKTOP=1 SHELL=/bin/bash PRINTER=lp HOSTTYPE=i386 QT_XFT=Y OSTYPE=linux WINDOWMANAGER=/usr/X11R6/bin/kde HOME=/home/oracle TERM=kvt XNLSPATH=/usr/X11R6/lib/X11/nls no_proxy=localhost PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/home/zsolti/kylix/bin:/home/zsolti/kylix/lib:/usr/lib/java/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:/opt/kde2/bin:/opt/kde/bin:. LESSCHARSET=latin1 FROM_HEADER=YAST_ASK LC_COLLATE=POSIX
ORA-03113 end of file comm. error - Why???
Hi, I have a program that converts records from d-base to Oracle 8.1.7. I works perfectly but about once a week it gives the Ora-03113 error and the whole Oracle freezes, we have to restart the whole server. There is no logic in it since if I repeat the converting procedure 100 times with the same data, maybe all 100 will be good, but there is a chance that e.g. the 97-th will give this error. Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Linux profile - a little offtopic
Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Function slows the select
Hi, In the following select statement I have a function GetSid that slows the update for hours even if the Link_keszit updatable table consists of a few rows. Update UpdateTable--Varosokat updatel Set UpdateTable_Column1= -- ( Select distinct 'Some string here'||GetSid||UpdateTable_Column2||Logo.Logo_Filenev From VarosTorzs,Logo, Link_keszit Where logo_varos_unique_az = link_keszit_varos_az and logo.logo_azonosito1= 'KKEPX' and logo.logo_azonosito2= '20200' and logo_varos_unique_az = varos_unique_azonosito ) Where UpdateTable_Column2 Is Not Null ; The GetSid function is: CREATE OR REPLACE Function GetSid Return VarChar2 AS BEGIN return(SYS_GUID()); END GetSid; So the problem is that _with_ GetSid function it takes many hours instead of a few minutes. Thank you in advance Zsolt Csillag, Hungary
Utl_Smtp trouble
Hi, I tried to send e-mail with Utl_Smtp package. At the line c := utl_smtp.open_connection('MySmtpServerAddress.com'); I always get the error message: Service not available.Utl_Smtp line 83.Utl_Smtp line 344 What should be wrong? I tried this at two different customers with 8.1.6 and 8.1.7 versions. Both customers have internet through ethernet(intranet) connection. Thank you in advance. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).