Dear All,


while installtion on Unix (IBM AIX 5.3 with ML-04) with Oracle 10.2.0.1.0 i m getting the error .

Error 7413 during creating table.

pls help

Not a good sign

06413, 00000, "Connection not open."
// *Cause: Unable to establish connection.
// *Action: Use diagnostic procedures to ascertain exact problem.

check the logfiles to see what happened.

Dave

Log file says :

***********************************************************************
Fatal NI connect error 6413, connecting to:
(DESCRIPTION=(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)(PROGRAM=/orapp/bin/ora
cle)(ARGV0=oraclebaan)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU=8192)(ADDRES
S=(PROTOCOL=beq)))')(ENVS='ORACLE_SID=baan'))(CONNECT_DATA=(SID=baan)(CID=(PROGR
AM=PIPE)@vindhya)(HOST=vindhya)(USER=root))))


i have also checked by TNSPING to baan database, its working fine.
Pls help

what do you have in the tabledef / db_resource?

Dave

Dear Dave,

tabledef6.1
*:*:oracle8(ORACLE_HOME=/orapp,ORACLE_SID=baan):N

db_resource
nls_lang:american_america.we8iso8859p1
nls_sort:binary
ora_default_tablespace:datspace
ora_temporary_tablespace:temp

With REgards
Deepak

So tnsping has very little to do with it. You are not connecting via a listener.

I believe that's due to the installer having problems with 10.2 are you
sure you have the latest installer?

Dave

That's the same Problem as in Oracle 9.2.0.7.
The OCI Connect-string was not build correctly.
set the following in the db_resource File :

oracle_server_home:/oracle/product/db_1
oracle_client_home:/oracle/product/db_1
oracle_local_template:(DESCRIPTION=(SDU=8192)(TDU=8192)(ADDRESS=(PROTOCOL=beq)(PROGRAM=?/bin/oracle)(ARGV0=oracle@)(ARGS='(DESCRIPTION=(LOCAL=YES)(SDU=8192)(TDU
=8192)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_HOME=?,ORACLE_SID=@'))(CONNECT_DA
TA=(SID=@)))

and try again

greetz
martin

Thanks martin, dave for your reply,
i have applied all the changed advised by you

but still i m facing the same problem.
contacted local baan support also, they are saying to install from latest media pack.

let me checck with latest media, will update on this post.

Deepak

Dear DAVE,MARTIN,

Baan had given the solution for this 200328,

VERSION(S):

BaanIV, BaanV with Oracle Patch 9.2.0.6.0 and 10.1.0.4
SSA ERP LN 6.1

SITUATION IDENTIFIED IN:

On a Linux and an AIX system

Oracle 9.2.0.6
Oracle 10.1.0.4

It is not known if it also happens on other Operating Systems.


ATTACHMENTS:

Not available.

SITUATION DESCRIPTION:

After installing Oracle Patch 9.2.0.6.0 or Oracle Patch 10.1.0.4 it is not possible to connect Baan with Oracle anymore. Connections will fail with ORA-06413 Connection Not Open errors. This only affect Baan since a Net 8 connection between the client PC and the database with SQL*Plus will work.

SOLUTION DESCRIPTION:

To solve this problem the "ipc_info file needs to be changed"

When you change the Oracle driver line in $BSE/lib/ipc_info from pipes protocol in sockets protocol, the connection works.
This is the used protocol for the traffic between the Baan Database driver an the Bshell.
The change does not influence the performance between the bshell and the driver.


EXAMPLE(S):

ipc_info

Old line:

oracle8 s 302 320 p ${BSE}/bin/ora8_srv6.1

or

oracle8 p ${BSE}/bin/ora8_srv6.1


Changed line:

oracle8 s ${BSE}/bin/ora8_srv6.1


Not Applicable

WORK-AROUND:

Not Apllicable

.

Warm Regards
Deepak

Yes, that's a good workaround. the FIX is to move to 9.2.0.7 or higher

Dave