Jercrash
24th October 2007, 14:47
I have an application server on Linux (with own Oracle DB) and try to connect to other Oracle DB on Windows 2003.

ora_storage:
*:743:T:private:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDAT742 INITRANS 3
*:743:I:private:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANIDX742 INITRANS 3
*:*:T:group:0214:5:PCTFREE 5 TABLESPACE baandat999 INITRANS 3
*:*:I:group:0214:5:PCTFREE 5 TABLESPACE baanidx999 INITRANS 3

ora_users:
sh743:ts:<password>:baan

Problem is that application server doesn't depend from "private" in the ora_storage and connect by group mode:
owner_execute ( baan.ttfrfa003743, mode 01, arg 0 ): Oracle login mode: group
ora_logon : name = 'baan', pwd = 0x8194818, ora_session 0x81f1628
using service name : 'BAAN_LN01'
oci_link_server ( dbase = 'BAAN_LN01' ) : # logon = 2 : OK
ora_logon : OCISvcCtx 0x821a108 Allocated
ora_error 1017 dbs_errno 540.
oci_unlink_server ( # logon = 2 ) : OK
ora_logon error: ora_session 0x81f1628 err 540
FATAL /view/port.6.1c.07.12/vobs/tt/servers/ORACLE_2/ora_native.c:#2192 :
Error ORA-1017

Even password db user "ts" on Oracle-Windows = password db user "baan" on Oracle-Llinux i still get the error. I want to connect through private mode (ts scheme), tryed to restart application server but it didn't solve the problem ....

Han Brinkman
29th October 2007, 14:13
Did you specify the second database in the session 'Database Definition' and also configured it in 'Tables by Databases'?

Looks like baan doesn't know how to connect. Can you connect from your server with sqlplus to that second instance?

Regards,
Han