ORA-65535 error

From: Khan, Muhammad S <Muhammad.Khan_at_ca.com>
Date: Tue, 11 Sep 2007 13:34:13 -0400
Message-ID: <06FBECFB25A476489623850EE472C29F0409C7DF@USILMS12.ca.com>

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

Received on Tue Sep 11 2007 - 12:34:13 CDT