Problems in a SAP Linux installation

[eloisadazpalaci]

Hi ,

We have installed a new dialog instance in S.O Linux , we have our

central instance in S.O Unix and the Data Base is oracle with S.O Unix .The central instance ,the dialog instance and the Data Base are in

differents servers.

When we try to start the new dialog instance the startsap tell us

******************************************************************

Database is not available via R3trans

Database D01 must be started on remote server

Log on to remote server and start database

******************************************************************

We execute a R3trans -d in the new dialog instace (Linux) and the

return code is 000 but the trace tell us that there is an error when we

read table SVERS the error is:

**********************************************************************

OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data

1869 0.123994

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND

**********************************************************************

Whe we do the same in the central instance (Unix) the R3trans tell us

that there is not problems and the system start without problems .

Thaks a lot for your help.

[eloisadazpalaci]

Hi ,

Yes the /etc/services have the entries , but we have start again the instalation and the R3trans go well .

Thanks .

[Former Member]

do you have the entries in the /etc/services file?

regards, M.

[eloisadazpalaci]

Hi ,

The enviorement dbs_ora_schema is the same .

Thanks on advanced

[eloisadazpalaci]

Hi martin ,

In your system you have the same errors in the Rtrans -d ?

*************************************************************************************************************************

SELECT VERSION FROM SVERS

4 ETW000 13 0.198135

4 ETW000 [dev trc ,00000] DbSlRead(): table='SVERS' 23 0.198158

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=1403=OCI_ERR_NOT_FOUND

*************************************************************************************************************************

And in the tables DDNTT , DDNTF , TADIR and PATCHHIST with the error rc=1403=OCI_ERR_NOT_FOUND .

Thanks a lot on advanced.

[Former Member]

Can you do a sidadm> echo $dbs_ora_schema on both the CI and the dialog instance?

Cheers Michael

[eloisadazpalaci]

Hi Martin ,

1. Did you install the oracle client software on the server of the dialog instance?

2. Did you mount the profile directory plus it's subdirectories on the dialog instance? -> /sapmnt/adm environment settings in the dialog instance are the same that in the central instance

4º The data base support the central instance connections and we start only the R3trans -d and this fail when is going to read table SVERS .

5º We deactivate the DNS and put the maquines in the /etc/hosts .

Thanks a lot on advanced.

[martin_juen2]

Hi.

I think i went wrong - the R3trans was successful. It was only the "problem" with the SVERS select in the trans.log file.

I checked this on my systems - we have this message too. So i do not think that this will be the problem.

What about the files in the profile/oracle directory? Are they there on the dialog instance?

Can you check the environment of the <sidadm> user on the dialog instance. Maybe something on a firewall?

regards, Martin

[eloisadazpalaci]

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

15 0.031790

4 ETW000 [dev trc ,00000] Oracle Client

Version: '10.2.0.4.0'

700 0.032490

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='',

nchar='')

37 0.032527

4 ETW000 [dev trc ,00000] application info callback

registered

9 0.032536

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=0=OCI_DEFAULT)

returned 0 (for default NLS ha

ndle)

4

ETW000

3954 0.036490

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo):

connection handle 0 -> 'AME

RICAN_AMERICA.US7ASCII'

4

ETW000

568 0.037058

4 ETW000 [dev trc ,00000] charset='', chset='US7ASCII',

UNI_ASC=FALSE/FALSE

12 0.037070

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's

password

16 0.037086

4 ETW000 [dev trc ,00000] Connecting as /@D01 on connection 0

(nls_hdl 0) ... (dbsl 701 2

20409)

4

ETW000

13 0.037099

4 ETW000 [dev trc ,00000] Nls CharacterSet

NationalCharSet

EnvHp ErrHp ErrHpBatch

4

ETW000

302 0.037401

4 ETW000 [dev trc ,00000] 0

US7ASCII

0x67bc340 0x67c3de0 0x67c7a38

4

ETW000

12 0.037413

4 ETW000 [dev trc ,00000] Allocating service context handle for

con_hdl=0

32 0.037445

4 ETW000 [dev trc ,00000] Allocating server context

handle

37 0.037482

4 ETW000 [dev trc ,00000] Attaching to DB Server D01

(con_hdl=0,svchp=0x67c7968,srvhp=0x6

7c8978)

4

ETW000

98 0.037580

4 ETW000 [dev trc ,00000] Assigning server context 0x67c8978 to

service context 0x67c7968

42632 0.080212

4 ETW000 [dev trc ,00000] Allocating user session

handle

134 0.080346

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin

(con_hdl=0, usr='/',svchp

=0x67c7968, srvhp=0x67c8978, usrhp=0x680bdf0)

4

ETW000

55 0.080401

4 ETW000 [dev trc ,00000] Mon Aug 16 14:23:25

2010

12799 0.093200

4 ETW000 [dev trc ,00000] Assigning user session 0x680bdf0 to

service context 0x67c7968

17 0.093217

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=52,

stmth_p=0x67d2428)

48 0.093265

4 ETW000 [dev trc ,00000] BEGIN

DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

4

ETW000

14 0.093279

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=300,

con_hdl=0, stmth_p=0x67d242

8, vp=0x2ab6338c8b60,ip=0x2ab6338c70f4,rlp=(nil),rcp=(nil))

4

ETW000

115 0.093394

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=300,

con_hdl=0, stmth_p=0x67d242

8, vp=0x2ab6338c8ca0,ip=0x2ab6338c70f6,rlp=(nil),rcp=(nil))

4

ETW000

60 0.093454

4 ETW000 [dev trc ,00000] CbApplInfoGet() failed (ignored

1).

10 0.093464

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54,

stmth_p=0x67d3480)

7 0.093471

4 ETW000 [dev trc ,00000] BEGIN

DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4

ETW000

10 0.093481

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l= 20,

con_hdl=0, stmth_p=0x67d348

0, vp=0x2ab6338c7140,ip=(nil),rlp=(nil),rcp=(nil))

4

ETW000

18 0.093499

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d3480)

1856 0.095355

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE

ROWNUM<2

4

ETW000

99 0.095454

4 ETW000 [dev trc ,00000] Connected to session

348.

1475 0.096929

4 ETW000 [dev trc ,00000] Now '/@D01' is connected: con_hdl=0,

nls_hdl=0, session_id=348.

17 0.096946

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d3480)

13 0.096959

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT =

BINARY

4

ETW000

27 0.096986

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d3480)

954 0.097940

4 ETW000 [dev trc ,00000] SELECT USERID,PASSWD FROM

SAPUSER WHERE USERID IN (:A0,:

A1)

4

ETW000

20 0.097960

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=256,

con_hdl=0, stmth_p=0x67d348

0, vp=0x2ab6338f7a39,ip=(nil),rlp=(nil),rcp=(nil))

4

ETW000

72 0.098032

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=256,

con_hdl=0, stmth_p=0x67d348

0, vp=0x7fff2d7ac430,ip=(nil),rlp=(nil),rcp=(nil))

4

ETW000

15 0.098047

4 ETW000 [dev trc ,00000] Got SAPR3's password from OPS$-

user

1349 0.099396

4 ETW000 [dev trc ,00000] Disconnecting from connection

0 ...

23 0.099419

4 ETW000 [dev trc ,00000] Rolling back

transaction ...

27 0.099446

4 ETW000 [dev trc ,00000] Closing user session

(con_hdl=0,svchp=0x67c7968,usrhp=0x680bdf0

) 948 0.100394

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE

1136 0.101530

4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@D01 on

connection 0 (nls_hdl 0) ... (

dbsl 701 220409)

4

ETW000

23 0.101553

4 ETW000 [dev trc ,00000] Nls CharacterSet

NationalCharSet

EnvHp ErrHp ErrHpBatch

4

ETW000

13 0.101566

4 ETW000 [dev trc ,00000] 0

US7ASCII

0x67bc340 0x67c3de0 0x67c7a38

4

ETW000

10 0.101576

4 ETW000 [dev trc ,00000] Assigning username to user session:

con_hdl=0, usrhp=0x680bdf0

8 0.101584

4 ETW000 [dev trc ,00000] Assigning password to user session:

con_hdl=0, usrhp=0x680bdf0

27 0.101611

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin

(con_hdl=0, usr=SAPR3/<pw

d>, svchp=0x67c7968, srvhp=0x67c8978, usrhp=0x680bdf0)

4

ETW000

606 0.102217

4 ETW000 [dev trc ,00000] Assigning user session 0x680bdf0 to

service context 0x67c7968

4931 0.107148

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=52,

stmth_p=0x67d1dc8)

26 0.107174

4 ETW000 [dev trc ,00000] BEGIN

DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

4

ETW000

31 0.107205

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l=300,

con_hdl=0, stmth_p=0x67d1dc

8, vp=0x2ab6338c8b60,ip=0x2ab6338c70f4,rlp=(nil),rcp=(nil))

4

ETW000

20 0.107225

4 ETW000 [dev trc ,00000] - oci_bind ( 1: SQLT_STR, l=300,

con_hdl=0, stmth_p=0x67d1dc

8, vp=0x2ab6338c8ca0,ip=0x2ab6338c70f6,rlp=(nil),rcp=(nil))

4

ETW000

13 0.107238

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54,

stmth_p=0x67d2428)

8 0.107246

4 ETW000 [dev trc ,00000] BEGIN

DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4

ETW000

10 0.107256

4 ETW000 [dev trc ,00000] - oci_bind ( 0: SQLT_STR, l= 20,

con_hdl=0, stmth_p=0x67d242

8, vp=0x2ab6338c7140,ip=(nil),rlp=(nil),rcp=(nil))

4

ETW000

16 0.107272

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d2428)

1078 0.108350

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE

ROWNUM<2

4

ETW000

20 0.108370

4 ETW000 [dev trc ,00000] Connected to session

348.

900 0.109270

4 ETW000 [dev trc ,00000] Now 'SAPR3/<pwd>@D01' is connected:

con_hdl=0, nls_hdl=0, sessi

on_id=348.

4 ETW000

21 0.109291

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d2428)

11 0.109302

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT =

BINARY

4

ETW000

12 0.109314

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d2428)

978 0.110292

4 ETW000 [dev trc ,00000] SELECT VALUE FROM

V$NLS_PARAMETERS WHERE PARAMETER IN ('

NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET') ORDER BY PARAMET

4

ETW000

19 0.110311

4 ETW000 [dev trc ,00000]

ER

4

ETW000

10 0.110321

4 ETW000 [dev trc ,00000] Database NLS settings:

AMERICAN_AMERICA.US7ASCII

929 0.111250

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d2428)

40 0.111290

4 ETW000 [dev trc ,00000] SELECT UPPER

(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(ST

ARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

4

ETW000

13 0.111303

4 ETW000 [dev trc ,00000] DB instance D01 is running on

oracle2desa with ORACLE version 1

0.2.0.2.0 since AUG 01, 2010, 11:11:20

4

ETW000

932 0.112235

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0,

stmth_p=0x67d2428)

15 0.112250

4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR

(CREATED,'YYYYMMDDHHMMSS

') FROM V$DATABASE

4

ETW000

79 0.112329

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle

0)

3460 0.115789

4 ETW000 [dev trc ,00000] build_stmt: reallocating stmt buffer:

256 -> 2000 characters

6233 0.122022

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=26,

stmth_p=0x67d2428)

69 0.122091

4 ETW000 [dev trc ,00000] SELECT VERSION FROM

SVERS

[martin_juen2]

Hi.

1. Did you install the oracle client software on the server of the dialog instance?

2. Did you mount the profile directory plus it's subdirectories on the dialog instance? -> /sapmnt/<SID>/profile/oracle

3. Are the <sid>adm environment settings correct on the dialog instance server?

4. Unlikely: does the database have enough possible connections for the di's work processes?

5. What about a nslookup of the db server / ci server on the di server

please try and post 🐵

regards, Martin

[eloisadazpalaci]

The file trans.log give us the nest trace in the dialog instance

(Linux):

*****************************************************************************************************************

4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).

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

4 ETW000

4 ETW000 date&time : 16.08.2010 - 14:23:24

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

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

4 ETW000 [dev trc ,00000] Mon Aug 16 14:23:24

2010

218 0.000218

4 ETW000 [dev trc ,00000] db_con_init

called

22 0.000240

4 ETW000 [dev trc ,00000] create_con

(con_name=R/3)

47 0.000287

4 ETW000 [dev trc ,00000] Loading DB

library '/usr/sap/D01/SYS/exe/run/nuc/linuxx86_64/db

oraslib.so' ...

4

ETW000

50 0.000337

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen

("/usr/sap/D01/SYS/exe/run/nuc/linux

x86_64/dboraslib.so"), hdl 0

4

ETW000

31089 0.031426

4 ETW000 [dev trc ,00000]

Library '/usr/sap/D01/SYS/exe/run/nuc/linuxx86_64/dboraslib.so'

loaded

4

ETW000

18 0.031444

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from

library /usr/sap/D01/SYS/exe/r

un/nuc/linuxx86_64/dboraslib.so

4

ETW000

46 0.031490

4 ETW000 [dev trc ,00000] Version

of '/usr/sap/D01/SYS/exe/run/nuc/linuxx86_64/dboraslib.

so' is "700.08", patchlevel (0.42)

4

ETW000

90 0.031580

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from

library /usr/sap/D01/SYS/exe/

run/nuc/linuxx86_64/dboraslib.so

4

ETW000

12 0.031592

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from

library /usr/sap/D01/SYS/exe

/run/nuc/linuxx86_64/dboraslib.so

4

ETW000

56 0.031648

4 ETW000 [dev trc ,00000] New connection 0

created

29 0.031677

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

47 0.031724

4 ETW000 [dev trc ,00000] db_con_connect

(con_name=R/3)

41 0.031765

4 ETW000 [dev trc ,00000] find_con_by_name found the following

connection for reuse:

10 0.031775