ABAP Database must be started on remote server

[Former Member]

Hi.

I've installed a dialog instance on SuSe linux with the central instance and db (Oracle 9.2.0.8) running on the same AIX server

The installation was ok but from the DI it is not possible to connect to db. i've made a R3trans -x and below is the trans.log file

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 16.06.2010 - 14:09:27

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Wed Jun 16 14:09:27 2010 126 0.000126

4 ETW000 [dev trc ,00000] db_con_init called 13 0.000139

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 56 0.000195

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SBX/SYS/exe/run/dboraslib.so' ...

4 ETW000 31 0.000226

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/SBX/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 6899 0.007125

4 ETW000 [dev trc ,00000] Library '/usr/sap/SBX/SYS/exe/run/dboraslib.so' loaded

4 ETW000 12 0.007137

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so

4 ETW000 13 0.007150

4 ETW000 [dev trc ,00000] Version of '/usr/sap/SBX/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.276)

4 ETW000 77 0.007227

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so

4 ETW000 9 0.007236

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SBX/SYS/exe/run/dboraslib.so

4 ETW000 22 0.007258

4 ETW000 [dev trc ,00000] New connection 0 created 15 0.007273

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 16 0.007289

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 16 0.007305

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 11 0.007316

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 12 0.007328

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/client/92x_64 from environment

4 ETW000 216 0.007544

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 20 0.007564

4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

4 ETW000 9 0.007573

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=0)' failed: rc = -1

4 ETW000 245 0.007818

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 15 0.007833

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

4 ETW000 20 0.007853

4 ETW000 [dblink ,00430] ***LOG BY2=>sql error -1 performing CON [dblink#6 @ 430]

4 ETW000 65 0.007918

4 ETW000 [dblink ,00430] ***LOG BY0=>Cannot get Oracle error text. [dblink#6 @ 430]

4 ETW000 9 0.007927

Any help would appreciated. Thx

[audunlea_hansen]

As <SID>adm user, try 'R3trans -d -v'

Do 'tnsping <SID>' report anything else than OK?

In RHEL5 linux I've seen read/exec acsess to libs have been revoked from <SID>adm during DB-patching. To check this, I use 'ldd tnsping' as <SID>adm. Check access rights on any libs that are reported as not found.

Regards Audun

[Former Member]

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data

[Former Member]

Hi Markus.

There is a note that says, that it is not supported to go higher on the client than the db rel. ?

i am on db rel. 9.2.0.7 and same level on the client.

the note states that going on a higher level on the db server would not require upgrade on the client.

But not the other way around.

NLS is set for sbxadm.

Henri

[markus_doehr2]

> i am on db rel. 9.2.0.7 and same level on the client.

You wrote initially:

I've installed a dialog instance on SuSe linux  with the central instance 
and db (Oracle 9.2.0.8) running on the same AIX server

> the note states that going on a higher level on the db server would not require upgrade on the client.

> But not the other way around.

Yes, that's right.

> NLS is set for sbxadm.

NLS? And NLS_33? And what's its value?

Markus

[Former Member]

saplinuxtest1:sbxadm 58> ls -l /oracle/client/92x_64

total 12

drwxrwxrwx 5 orasbx dba 4096 2006-01-30 17:21 jdbc

drwxrwxrwx 2 orasbx dba 4096 2006-01-30 17:20 lib

drwxrwxrwx 3 orasbx dba 4096 2006-01-30 17:20 ocommon

I've just patched the oracle client to rel. 9.2.0_64 but that did not help.

[markus_doehr2]

> I've just patched the oracle client to rel. 9.2.0_64 but that did not help.

Use 9.2.0.8 - not an older version.

Is ORA_NLS33 set for sbxadm?

Markus

[markus_doehr2]

> 4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/client/92x_64 from environment

> 4 ETW000 216 0.007544

> 4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 20 0.007564

> 4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

> 4 ETW000 9 0.007573

> 4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIEnvCreate(mode=0)' failed: rc = -1

> 4 ETW000 245 0.007818

> 4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code -1 15 0.007833

> 4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIErrorGet' failed: rc = -2

> 4 ETW000 20 0.007853

> 4 ETW000 [dblink ,00430] ***LOG BY2=>sql error -1 performing CON [dblink#6 @ 430]

> 4 ETW000 65 0.007918

> 4 ETW000 [dblink ,00430] ***LOG BY0=>Cannot get Oracle error text. [dblink#6 @ 430]

> 4 ETW000 9 0.007927

What Oracle client version do you use?

Please post

ls -l /oracle/client/92x_64

Markus

[JPReyes]

Are you logged on as <sid>adm?

[Former Member]

Yes, and i can run startsap but no connect to remote db.