OCI error

[ileola]

I and trying to start an SAP instance which runs an oracle database (10.2.0.2) and i get the following error message

**********************
ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 21138 0.444405
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment
4 ETW000 51 0.444456
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate' failed: rc = -1
4 ETW000 2212 0.446668
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -1 performing CON [dblink#2 @ 419]
4 ETW000 52774 0.499442
4 ETW000 [dblink ,00419] ***LOG BY0=>'OCI_ERROR' [dblink#2 @ 419] 31 0.499473
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'IBI'"
**********************
can anyone shed any light on these OCI errors ?

The database is mounted

[Thomasps]

Check the "IBI" TNS connect string, may be used by a DB link? Why the database in MOUNT state not in OPEN?

[pareshjavkar]

Hi,

Why is DB in mounted stage, throw some light on working of your APplication

[ileola]

Thanks -
database unmounted - shutdown and then started - still get same error message

[Thomasps]

Did you check the TNS connectivity "IBI" and DB links?

[ileola]

thanks Thomasps

can you shed more light on what you mean by TNS connectivity IBI and DB links

I've checked the tnsnames.ora file and it lloks OK - the port number in the tnsnames.ora and the listener.ora files are the same

[pareshjavkar]

tnsping IBI

[Thomasps]

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'IBI'"

I think it is trying to make a connection thru the TNS entry 'IBI' and failing. Consult your DBA and ask him to check the connectivity.

[ileola]

thanks Thomasps