RE: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris[Scanned]
Joshua, I too faced a similar problem last week! The problem was that the users, used 'Ctrl + C' to close the WL which resulted in the number of process to exceed the limit. This problem was solved when the developers started using the WL console to close the oracle sessions. K. -Original Message- Sent: Wednesday, October 16, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Solaris[Scanned] Hi all, we are facing strange problems with our environment. we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connections is getting extremely high and it seems that WL is doing db connection each time user clicks the aplication. Is there any parameter on oracle side causing this. We have tested this with two similar environment and other seems to work ok and other does generate these connections but we do not find any reason for the different behaviour... Any ideas... Rgds, Joshua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned]
Try, set serveroutput on size 100 I faced this problem sometime back and it worked when I set the size to 100. -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 24, 2002 10:23 PMTo: Multiple recipients of list ORACLE-LSubject: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned] Hi All, Below is a script to retrieve data from BFILE column and its output. The external PDF file is around 53, 435 bytes (text and picture altogether in one file). Anyone please have a fix for this script. I am unable to view the content of the external PDF file on the sreen. Any help is greatly appreciated. Thanks alot Lenka set serveroutput onDECLARE v_book_file BFILE; v_length NUMBER; v_position NUMBER; v_piece RAW (56,320);BEGIN SELECT book_file INTO v_book_file FROM my_book_text WHERE file_desc = 'testing'; dbms_lob.open (v_book_file, ); v_length := dbms_lob.getlength (v_book_file); v_position := 1; LOOP EXIT WHEN v_position > v_length; v_piece := dbms_lob.substr (v_book_file, 100, v_position); dbms_output.put_line (utl_raw.cast_to_varchar2(v_piece)); v_position := v_position + 100; END LOOP; dbms_lob.close (v_book_file);END;/== %PDF-1.3%bcOS1 0 obj<< /Creator6f007200640020>/CreationDate (D:19991019160202)/Title30031002e005000440046>/Author/Producer (AcrobatPDFWriter 4.0 for Windows)/ModDate (D:20001019200402+08'00')>> endobj2 0obj[ /PDF /Text /ImageB ]endobj3 0 obj<< /Pages 5 0 R /Type /Catalog /DefaultGray 31 0 R /DefaultRGB 32 0 R >> endobj4 0 obj<< /Type /Page /Parent 5 0 R /Resources << /Font << /F1 8 0 R/F2 10 0 R /F0 6 0R /F3 14 0 R /F4 16 0 R >> /ProcSet [ /PDF /Text /ImageB ] >> /Contents 57 0 R >> endobj5 0 obj << /Kids [ 4 0 R 18 0 R ] /Count 2 /Type /Pages /MediaBox [ 0 0 612 792 ] >> endobj6 0 obj<< /Type /Font /Subtype /TrueType /Name /F0 /BaseFont /Arial /FirstChar 31 /LastChar 255 /Widths [ 750 278 278 355 556 556 889 667 191 333 333 389 584 278 333 278 278 556556 556 556 556 556 556 556 556 556 278 278 584 584 584 556 1015 667 667 722 722 667 611 778 722 278500 667 556 833 722778 667 778 722 667 611 722 667 944 667 667 611 278 278 278 469 556 333 556556 500 556 556 278 556 556 222 222 500 222 833 556 556 556 556 333 500 278 556 500 722 500 500 500334 260 334 584 750 556 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500500 500 500 500 500DECLARE*ERROR at line 1:ORA-2: ORU-10027: buffer overflow, limit of 2000 bytesORA-06512: at "SYS.DBMS_OUTPUT", line 91ORA-06512: at "SYS.DBMS_OUTPUT", line 58ORA-065! ! 12: at line 17 Do you Yahoo!?New DSL Internet Access from SBC & Yahoo!
RE: Group By - Without using aggregate functions[Scanned]
Thanks a lot for your help. The Java programmers have decided to format the output themselves. K. -Original Message- Sent: Monday, September 23, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Karthik, To me it seems that you do not want any aggregate totals, just a list grouping the employees of one department together. For this if you could try ORDER BY DeptNo, EmpNo, I think it should work, HTH! Aleem -Original Message- Sent: Monday, September 23, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Subject:Group By - Without using aggregate functions Hi Gurus, I would like to group by the result of a select statement based on a particular column. But I am not using any aggregate function in the select list. For eg. select deptno, empno from emp group by deptno, empno; I tried to do it in sqlplus by setting BREAK ON and it works. But I want use this query in a java program. Is there any solution for this? TIA regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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: Abdul Aleem 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: Karthikeyan S 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).
Group By - Without using aggregate functions
Hi Gurus, I would like to group by the result of a select statement based on a particular column. But I am not using any aggregate function in the select list. For eg. select deptno, empno from emp group by deptno, empno; I tried to do it in sqlplus by setting BREAK ON and it works. But I want use this query in a java program. Is there any solution for this? TIA regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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: Moving data between tablespaces[Scanned]
Thomas / Amar,
I moved the tables from SYSTEM to the DATA tablespace. But now I am getting the
following error.
"ORA-01502: index 'ETAIL_TEST_NEW.AGENT_PK' or partition of such index is in unusable
state"
Is it because of moving the table to a different tablespace or is it something else?
TIA
regards,
Karthik
-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Karthik,
Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.
It will do exactly what you want.
You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Some of my tables are accidentally created in the SYSTEM tablespace.
Is there any way to move the records and the table to some other tablespace?
regards,
Karthik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
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: Moving data between tablespaces[Scanned]
Amar / Thomas,
Thanks a lot for your help.
As you said, "ALTER TABLE {table_name} MOVE {tablespace}", solved the problem.
regards,
Karthik
-Original Message-
Sent: Tuesday, September 17, 2002 5:10 PM
To: [EMAIL PROTECTED]
Cc: Karthikeyan S
Karthik,
Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.
It will do exactly what you want.
You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Some of my tables are accidentally created in the SYSTEM tablespace.
Is there any way to move the records and the table to some other tablespace?
regards,
Karthik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
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: Karthikeyan S
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 between tablespaces
Hi All, Some of my tables are accidentally created in the SYSTEM tablespace. Is there any way to move the records and the table to some other tablespace? regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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 Installer not launching in NT[Scanned]
Hi, It is an Oracle bug. There is a DLL called symcjit.dll. You have to rename this DLL to something else before running the installer. This bug occurs when you are using Pentium-3 or above. regards, Karthik -Original Message- Sent: Tuesday, September 17, 2002 8:28 AM To: Multiple recipients of list ORACLE-L I have s similar problem (Oracle Installer 8.1.6 / 8.1.7 not launching in NT) but on a Pentium 3 with NT4 SP5, anyone has a workround? Many thanks. Kitty -Original Message- Heisler Sent: 25 July, 2002 12:13 PM To: Multiple recipients of list ORACLE-L If it's a Pentium 4, it's a known bug. See MetaLink note 131299.1. The patch is 1507768. Dennis > [EMAIL PROTECTED] wrote: > > Hi List, > > I saw a similar post to this in the last 2 weeks, but deleted it > (oops) as I am in a unix shop. But I now have a client who is > trying to install the oracle client on his nt box in order to demo our > *product*. > > However, he can't get the installer to even launch. He thinks its > a Java VM conflict. > > Any ideas? I need this rather quick so please also reply direct > to me and in the meantime I will hit the internet. > > Thanks, > > Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler 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: Kitty Luo 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: Karthikeyan S 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).
Spooling data containing Umlaut character (DB characterset UTF8)
Hi, We are trying to extract the data from the oracle database 8.1.7. which contains special characters like umlaut. The Characterset of Oracle db is UTF8 and the Character set at Client side is AMERICAN_AMERICA.UTF8. While we spool the data from the Oracle db an extra space (byte) is added if umlaut character exists. For example : 'MÜNCHEN' - If we query the size it shows 7 bytes but while spooling to a flat file it takes 8 bytes. This problem exists only when the umlaut character and normal character exists like the above eg. If data contains only umlaut then we dont get this problem. Any info on this would be of great help. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karthikeyan S 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: Changing sysdate - Problem resolved
Title: RE: Constraints problem Hi Gurus, Thanks a lot for your help. The problem is resolved now. regards, Karthik -Original Message-From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 2:48 AMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
RE: Changing sysdate[Scanned]
Title: RE: Constraints problem Hi, I am getting the error "newdate does not exist" when I tried $newdate '09042002 14:48:00' . Is it the command I should use to change the sysdate in Solaris? regards, Karthik -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:53 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Changing sysdate[Scanned] Change the System date, and restart the database. -Original Message-----From: Karthikeyan S [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002 12:18 PMTo: Multiple recipients of list ORACLE-LSubject: Changing sysdate Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
Changing sysdate
Title: RE: Constraints problem Hi, Is it possible to change the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K.
Cognos-unix???
Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
To_Char Problem
Hi All, I am using the to_char function in the following query. But it treats the date '31/12/2001' as greater than '01/01/2002'. Is there any solution to fix this problem? select distinct(a.default_type_id), a.new_val from amend_default_value a, amend_default_value b where a.effective_from <= sysdate and a.effective_to>= sysdate and a.group_id = '942' and a.default_type_id = b.default_type_id and to_char(a.updated_date,'dd/mm/ hh:mi:ss') = ( select max(to_char(updated_date,'dd/mm/ hh:mi:ss')) from amend_default_value c where c.effective_from <= sysdate and c.effective_to>= sysdate and c.group_id = '942' and c.default_type_id = b.default_type_id); Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
Error while invoking Email from PL/SQL
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL> @initplsj.sql
call dbms_java.set_output(1)
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
call dbms_java.loadjava('-resolve plsql/jlib/plsql.jar')
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
And then I tried to run
loadjava -user sys/*** plsql.jar, again to no avail
Thanks in advance
K.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: karthikeyan S
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).
CLOB columns
Hi Guys, I am using a CLOB column in my database. Is there any way to fetch and see the entire content of the CLOB field? For (eg) If I have stored my resume in the CLOB colum (in a text/HTML format) then is there any way to display the entire content in the database or in some other editor? I tried DBMS_LOB.READ(locator_var,amount_var,offset_var,output_var) and DBMS_LOB.OPEN(locator_var,1); K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
Unable to conenct from Java front end
Hi, I am trying to connect to Oracle database (8.1.7) from Java. But I am getting the following error. http param elementcode = 30011 Can you please let me know the solution to fix this? Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
Problem while importing a dmp file
Hi, I am facing the following problem while importing a .dmp file (from a tape) into solaris 8 server. Oracle : 8.1.7 I am getting the following error while using the IMP command. " Invalid format of import utility name " " Verify that oracle_home is properly set" Any help regarding this is appreciated. Thanks in advance, regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
Select Query - Help required
Gurus, Please read the following problem and help me if you have any solution. Select product_id from where id = 2; Product_ID -- A B C D But I want the output as follows: Select product_id from where id = 2; Product ID - ABCD. Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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).
Unable to connect to an Oracle Instance
Hi, I am not able to connect from my oracle client to an oracle db server (NT) When i try to configure and test for the ora service(from my work station) it says "Connecting...ORA-12545: Connect failed because target host or object does not exist The test did not succeed.(this particular ora instance is not connectable from any workstation) " Thanks in Advance K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S 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 Performance Tuning steps[Scanned]
Gavin, I too faced a similar kind of problem in the past. Probably there are some uncommited data in your database (that are related to this package) or somebody might have closed a sql session manually while executing this package. This will create a lock on some of the tables accessed by this package. So make sure you give an explixit commit before compiling this package and also make sure that nobody closes an sql session manually (by using Ctrl+Alt+Del) while this package is executed. Hope it helps. K. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, July 01, 2002 3:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Performance Tuning steps[Scanned] Gavin, You need to monitor who is locking the object. v$locked_object could be queried for this info. Long -Original Message-From: Gavin D'Mello [mailto:[EMAIL PROTECTED]]Sent: Monday, 1 July 2002 6:03 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Performance Tuning steps Hi, I'm working on a pidley sized db ( about 100mb) but sometimes when I try compiling a decent sized package i get a time out error saying the object is locked, while at other times the package compiles on the fly. I'm trying to figure out why i get this error randomly. Some suggestions maybe that the compiler is going into a loop in my code which i seriously doubt. Is there any way I can find out what is causing the compile to hang up yes i know it says the object is locked but when no one is using the db ( that's when I update) why should the object (i.e. my package) lock ? any help would be really appreciated, thank you, Gavin
