Hi,
i'm testing iManager syncronization with an Oracle DB.
I've set up a JDBC driver that connects to an Oracle 10g. Subscriber
channel is ok, I can add/modify and delete an user in e-Directory, and
oracle DB automatically do same actions. But Publisher channel gives
errors.
When i start JDBC driver in log file there are many errors as:

<jdbc-driver>
<errors>
<connectivity>
<error-code description="oracle initialization or shutdown
in progress">
<!-- sql state: 7200 -->
<!-- ORA-01033 -->
<value>1033</value>
</error-code>
<regular-expression description="conection lost contact">
<!--
NOTE: error code 3135 can be either a returned
error code or an embedded code in the message of a
wrappering exception (e.g., ORA-17081: error
occurred during batch)
-->
<value>.*ORA-03135.*</value>
</regular-expression>
<error-code description="connection lost contact">
<value>3135</value>
</error-code>
<regular-expression description="TNS:listener does not
currently know of SID given in connect descriptor">
<!-- error code: 0 -->
<value>.*ORA-12505.*</value>
</regular-expression>
<regular-expression description="TNS:listener: all
appropriate instances are blocking new connections">
<!-- error code 0 -->
<value>.*ORA-12528.*</value>
</regular-expression>
<error-code description="connection refused | could not
establish connection | database serer not started | connection
timed-out">
<!-- connection refused = SID is incorrect -->
<!-- could not establish a connection = wrong IP
address -->
<!-- database server is not started = start
database-->
<!-- connection timed-out = adjust firewall TCP timeout
settings -->
<value>17002</value>
</error-code>
<error-code description="no more data to read from
socket">
<value>17410</value>
</error-code>
<error-code description="must be logged on to server">
<value>17430</value>
</error-code>
</connectivity>
<retry>
<!--error-code description="resource busy">
<value>54</value>
</error-code -->
</retry>
<authentication>
<error-code description="login denied; invalid
username/password">
<!-- sql state: 72000 -->
<value>1017</value>
</error-code>
<error-code description="login denied; no CREATE SESSION
privilege">
<value>1045</value>
</error-code>
<error-code description="invalid arguments in call">
<!-- null username or null password -->
<value>17433</value>
</error-code>
</authentication>
<fatal>
<error-code description="maximum open cursors exceeded">
<!-- sql-state = 72000 -->
<value>1000</value>
</error-code>
<error-code description="invalid batch command">
<value>17080</value>
</error-code>
</fatal>
</errors>
</jdbc-driver>
[09/30/09 11:43:32.122]:JDBCProof ST:Applying import '_std_err.xml'.
[09/30/09 11:43:32.123]:JDBCProof ST:

<!--
Please send suggestions for improving this descriptor file to
idm@lists.novell.com with the keywords "jdbc" and "descriptor"
somewhere in the subject line.
-->
<jdbc-driver>
<errors>
<connectivity>
<sql-state-class description="connectivity-related">
<value>08</value>
</sql-state-class>
<actions>
<check-for-closed-connection/>
<rollback/>
<fetch-metadata/>
</actions>
</connectivity>
</errors>
</jdbc-driver>
[09/30/09 11:43:32.128]:JDBCProof ST:Temporary runtime descriptor:
[09/30/09 11:43:32.129]:JDBCProof ST:
<jdbc-driver>
<identity>
<name>Oracle JDBC</name>
<jdbc-class>oracle.jdbc.driver.OracleDriver</jdbc-class>
</identity>
<sql-type-map>
<type>
<from>91</from>
<to>93</to>
</type>
</sql-type-map>
<options>
<handle-stmt-results>single</handle-stmt-results>
</options>
<errors>
<connectivity>
<regular-expression>
<value>.*ORA-03135.*</value>
</regular-expression>
<regular-expression>
<value>.*ORA-12505.*</value>
</regular-expression>
<regular-expression>
<value>.*ORA-12528.*</value>
</regular-expression>
<sql-state-class>
<value>08</value>
</sql-state-class>
<error-code>
<value>1033</value>
</error-code>
<error-code>
<value>3135</value>
</error-code>
<error-code>
<value>17002</value>
</error-code>
<error-code>
<value>17410</value>
</error-code>
<error-code>
<value>17430</value>
</error-code>
<actions>
<check-for-closed-connection/>
<rollback/>
<fetch-metadata/>
</actions>
</connectivity>
<retry/>
<authentication>
<error-code>
<value>1017</value>
</error-code>
<error-code>
<value>1045</value>
</error-code>
<error-code>
<value>17433</value>
</error-code>
</authentication>
<fatal>
<error-code>
<value>1000</value>
</error-code>
<error-code>
<value>17080</value>
</error-code>
</fatal>
</errors>
</jdbc-driver>
[09/30/09 11:43:32.141]:JDBCProof ST:Parameter: 'sync-filter'
Value: 'list'
[09/30/09 11:43:32.142]:JDBCProof ST:Parameter: 'sync-schema'
Value: null
[09/30/09 11:43:32.143]:JDBCProof ST:Parameter: 'sync-tables'
Value: [indirect.usr, indirect.grp,
indirect.userProof]
[09/30/09 11:43:32.143]:JDBCProof STriver is schema-aware.
[09/30/09 11:43:32.144]:JDBCProof ST:Parameter: 'force-username-case'
Value: null
[09/30/09 11:43:32.145]:JDBCProof ST:Parameter: 'server'
Value:
'jdbcracle:thin:@192.168.10.99:1521:iamdb'
[09/30/09 11:43:32.145]:JDBCProof ST:Parameter: 'user'
Value: 'indirect'
[09/30/09 11:43:32.146]:JDBCProof ST:Parameter:
'connection-properties' Value: ''
[09/30/09 11:43:32.146]:JDBCProof ST:Parameter: 'reuse-statements'
Value: [descriptor-dependent]
[09/30/09 11:43:32.147]:JDBCProof ST:Parameter:
'use-manual-transactions' Value: [descriptor or
metadata-dependent]
[09/30/09 11:43:32.148]:JDBCProof ST:Parameter:
'transaction-isolation-level' Value:
[descriptor-dependent]
[09/30/09 11:43:32.149]:JDBCProof ST:Parameter:
'use-single-connection' Value:
[descriptor-dependent]
[09/30/09 11:43:32.149]:JDBCProof ST:Parameter: 'minimal-metadata'
Value: [descriptor-dependent]
[09/30/09 11:43:32.150]:JDBCProof ST:Parameter: 'handle-stmt-results'
Value: [descriptor-dependent]
[09/30/09 11:43:32.150]:JDBCProof ST:Instantiating connection tester
from jdbc driver descriptor file '_oracle_jdbc.xml'.
[09/30/09 11:43:32.151]:JDBCProof ST:Parameter:
'connection-tester-class' Value:
'com.novell.nds.dirxml.driver.jdbc.util.connect.JD BCConnectionTester'
[09/30/09 11:43:32.152]:JDBCProof ST:Parameter: 'enable-refs'
Value: true
[09/30/09 11:43:32.155]:JDBCProof ST:Parameter:
'enable-meta-identifiers' Value: true
[09/30/09 11:43:32.156]:JDBCProof ST:Parameter:
'left-outer-join-operator' Value:
[descriptor-dependent]
[09/30/09 11:43:32.157]:JDBCProof ST:Parameter: 'include-table-filter'
Value: [descriptor-dependent]
[09/30/09 11:43:32.158]:JDBCProof ST:Parameter: 'exclude-table-filter'
Value: [descriptor-dependent]
[09/30/09 11:43:32.158]:JDBCProof ST:Parameter:
'function-return-method' Value:
[descriptor-dependent]
[09/30/09 11:43:32.159]:JDBCProof ST:Parameter: 'state-dir'
Value: '.'
[09/30/09 11:43:32.159]:JDBCProof ST:Parameter:
'supports-schemas-in-metadata-retrieval' Value:
[descriptor-dependent]
[09/30/09 11:43:32.160]:JDBCProof ST:Parameter:
'column-position-comparator' Value:
'com.novell.nds.dirxml.driver.jdbc.util.config.com p.StringByteComparator'
[09/30/09 11:43:32.161]:JDBCProof ST:Parameter: 'time-syntax'
Value: '1'
[09/30/09 11:43:32.162]:JDBCProof ST:Parameter: 'enable-locking'
Value: false
[09/30/09 11:43:32.163]:JDBCProof STriverShim.init() returned:
[09/30/09 11:43:32.164]:JDBCProof ST:

Any ideas are welcome.
Thanks to all


--
FedeNovellIM
------------------------------------------------------------------------
FedeNovellIM's Profile: http://forums.novell.com/member.php?userid=66205
View this thread: http://forums.novell.com/showthread.php?t=387795