Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 3920 invoked from network); 11 Sep 2007 18:13:51 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 11 Sep 2007 18:13:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D39E0740646; Tue, 11 Sep 2007 18:35:08 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25566-01-981; Tue, 11 Sep 2007 18:35:08 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F0687407A9; Tue, 11 Sep 2007 18:31:56 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Sep 2007 17:47:24 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A3683740C9C for ; Tue, 11 Sep 2007 17:47:24 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08704-06 for ; Tue, 11 Sep 2007 17:47:24 -0400 (EDT) Received: from mx03.mailboxcop.com (mx03.mailboxcop.com [206.125.223.73]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33F34740D37 for ; Tue, 11 Sep 2007 17:47:23 -0400 (EDT) Received: from secure9.apollohosting.com (secure9.apollohosting.com [206.125.217.251]) by mx03.mailboxcop.com (8.13.1/8.13.1) with ESMTP id l8BMPfZE007287 for ; Tue, 11 Sep 2007 17:25:42 -0500 Received: (qmail 20684 invoked from network); 11 Sep 2007 15:02:24 -0500 Received: from unknown (HELO ?172.20.10.93?) (tim@12.109.229.8) by prince-william-county-homes.com with ESMTPA; 11 Sep 2007 20:02:23 -0000 Message-ID: <46E6F3E5.4080908@evdbt.com> Date: Tue, 11 Sep 2007 14:00:37 -0600 From: Tim Gorman Organization: Evergreen Database Technologies, Inc. User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: alvaro.fernandez@sivsa.com CC: Muhammad.Khan@ca.com, oracle-l@freelists.org Subject: Re: ORA-65535 error References: <607D6181D9919041BE792D70EF2AEC48242C72@LIMENS.sivsa.int> In-Reply-To: <607D6181D9919041BE792D70EF2AEC48242C72@LIMENS.sivsa.int> Content-Type: text/html; charset=ISO-8859-1 X-Bayes-Prob: 0.0001 (Score 0) X-Spam-Score: 0.60 () [Hold at 6.00] HTML_MESSAGE,J_CHICKENPOX_83,MIME_HTML_ONLY X-CanItPRO-Stream: outgoing (inherits from default) X-Canit-Stats-ID: Bayes signature not available X-Scanned-By: CanIt (www . roaringpenguin . com) on 192.168.15.5 X-archive-position: 1458 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: tim@evdbt.com Precedence: normal Reply-to: tim@evdbt.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain What is suspicious is that 65535 is (2**16)-1, and I don't think Oracle has errors (yet!) that go quite that high -- it smells of AutoSys trying to handle a "null" value returned from the database, where the variable is populated with 0xFFFF already.  And ORA-00001 is supposed to mean "duplicate value on index", which has little to do with connecting to the database, so that suggests something similar (i.e. twisted error handling by AutoSys).

On the other hand, ORA-00001 could be a valid return code from Oracle, which would indicate that AutoSys is connecting successfully (Oracle would not return ORA-00001 without successful connection first) but then doing something wrong afterwards.

I'd suggest creating an AFTER LOGON trigger for the username that AutoSys is connecting to -- you can use the code at http://www.EvDBT.com/tracetrg.sql if you wish.

I'll bet you a fine malted beverage that you find that AutoSys is indeed connecting into the database successfully, but it is doing something peculiar to AutoSys immediately after connection and failing, emitting a misleading error message about "problems connecting".

This should all become clear in the SQL trace...


Alvaro Jose Fernandez wrote:

Hi,

 

I don’t know about AIX nor Autosys, but it one possibility seems to be related with the environment of the Oracle user’s account used to

connect . The Oracle user’s account you tested via sqlplus, is the same used by the Autosys?

 

Maybe an after-logon trigger on the database, and for that user it is defined, which fires the ORA-0001 depending on the tools used????

 

regards

 

 

We have a setup where the jobs are run through Autosys on the Oracle 9.2 server (AIX 5L). I’ve installed oracle client 9.2 on another AIX box. I can connect the database via sqlplus and also able to tnsping.

The problem is that, the autosys jobs are not able to run while its logs are throwing following errors:

 

Attempting (1) to Connect with Database: <servername>

 

Oracle Logon Error: ORA-65535 and ORA-00001

 

Oracle Logon Error: Unable to display error message for ORA-65535 and ORA-00001

 

 

 

I couldn’t find any details for ORA-65535 error. Also turned sqlnet logging on but the trace files don’t reflect any error, even not the ora-65535 or ora-00001.

 

$TNS_ADMIN is set to /usr/vendor/oracle/9i/9.2.0/network/admin.

Permissions on tnsnames.ora are

-rw-rw-r--   1 oracle   dba             502 Aug 06 00:31 tnsnames.ora

 

which is actually the same as the other boxes running fine with autosys.

 

Can anyone please highlight what can be the problem here?

 

 

Thanks.

-- http://www.freelists.org/webpage/oracle-l