Installation Get-Answers

[fid509]

Hello,
I followed the installation as described in the guide. I'm using an Oracle 9i database, Apache-Tomcat and Get-Answers 4.1.2. The installation of the Get-Answers Search Engine installed successful, I can connect to the database. The installation of Get-Answers was also successful. But all the targets using the bizdoc.BizDocAdapter adapter are "disconnected".I get connection refused errors in archway.log because anonymous connections are not allowed. I can connect to the database with SQLPlus and create tables, procedures, etc. So this is not a permission problem.Any help in solving this would be much appreciated.
Thx,Geert

[snippet from archway.log]
2005-08-23 09:46:05,948 ERROR [processWkEvents] GetitAnonymous(0) - Failure while initializing AdapterPool for 'rome' : com.peregrine.util.ResourceCreationFailureException The rome adapter failed to connect.
2005-08-23 09:46:05,948 ERROR [processWkEvents] GetitAnonymous(0) - The target rome does not support anonymous transactions. To enable anonymous transactions, define an anonymous identity for this Adapter in the configuration file.
2005-08-23 09:46:05,948 ERROR [processWkEvents] GetitAnonymous(0) - QMan.receive: sendDocQuery returned Error: The target rome does not support anonymous transactions. To enable anonymous transactions, define an anonymous identity for this Adapter in the configuration file.
2005-08-23 09:46:05,963 ERROR [processWkEvents] GetitAnonymous(0) - Tblcreate initialization failed.
2005-08-23 09:46:05,963 ERROR [processWkEvents] GetitAnonymous(0) - java.sql.SQLException: I/O-uitzondering: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
java.sql.SQLException: I/O-uitzondering: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
[snippet]

My local.xml contains this:
<rome>
        <romeDatabaseUrl>jdbc&#58;oracle&#58;thin&#58;@xxxxx.dbb.dexwired.net&#58;1521&#58;DB_PURT</romeDatabaseUrl>
        <romeDatabaseUser>SI01_ROME</romeDatabaseUser>
        <romeDatabasePassword>xxxx</romeDatabasePassword>
        <romeDatabaseType>Oracle</romeDatabaseType>
        <romeDatabaseDriver>oracle.jdbc.driver.OracleDriver</romeDatabaseDriver>
    </rome>

With 
Oracle Host&#58; syortstpurt.dbb.dexwired.net
Oracle port&#58; 1521
SID&#58;DB_PURT

[fid509]

Oops, found it. SID is not equal as the servicename for Oracle. DB_PURT is the servicename, PURT was the SID. To keep it simple ;-)