cancel
Showing results for 
Search instead for 
Did you mean: 

maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe')

Former Member
0 Kudos

Hi Basis and Upgrade Expert,

Currently i am doing an CRM 4.0 to CRM 7.0 upgrade and i am now in Configuration phase and it is stuck.

The error which i am facing is

p19637dtw261:sccadm> more PCMDIMP.ELG

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

              • LIST OF ERRORS AND RETURN CODES *******

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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CMDFILE IMPORT ERRORS and RETURN CODE in SAPLB70104.SCC

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe') or dbms_type ('ORA')"

1 ETP111 exit code : "12"

Infact this error we are facing for the first time in our Pre Prod system.

We had not faced this error in our DEV and QA systems.

Our system details is as follows

OS : AIX 5.3

DB : 10.2.0.4

Please help me in fixing this issue.

Regards,

Anil.

Accepted Solutions (0)

Answers (1)

Answers (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

What is the value of environment variable DIR_LIBRARY for user <sid>adm ?

Thanks

Sunny

Former Member
0 Kudos

Hi Sunny and others,

My DIR_LIBRARY and dbms_tye value from sccadm is as follows

DIR_LIBRARY=/usr/sap/SCC/SYS/exe/run

dbms_type=ORA

Also my database is up and running.

Regards,

Anil

former_member188883
Active Contributor
0 Kudos

Hi Anil,

Can you share the log details from file SAPLB70104.SCC

Regards,

Deepak Kori

volker_borowski2
Active Contributor
0 Kudos

Hi,

you did not do all preparations for the upgrade.

The new release uses the new oracle instantclient (which is not in you DIR_LIB obviously),

so you need to follow the instructions from the upgrade notes to support this mixed environment

(old system running client 9, new release using client 10).

Volker

Former Member
0 Kudos

Hi Deepak and others,

Please find the log file below

p19637dtw261:sccadm> tail -100 SAPLB70104.SCC

4 ETW000 > import

4 ETW000 > buffersync=no

4 ETW000 > file='/usr/sap/put/abap/data/RB70104.SAP'

4 ETW000 > continuation='/usr/sap/put/abap/data/RB70104_#.SAP'

4 ETW000 > client cascade yes

4 ETW000 > repeatimport=yes

4 ETW000 > importtruncated = yes

4 ETW000 > including 'NOTHING'

4 ETW000 R3trans was called as follows: /usr/sap/put/abap/exe/R3trans -u 26 -w /usr/sap/put/abap/tmp/SAPLB70104.SCC /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 active unconditional modes: 26

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe') or dbms_type ('ORA')"

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP110 end date and time : "20111212063423"

1 ETP111 exit code : "12"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP101 transport order : "SAPKB70104"

1 ETP102 system : "SCC"

1 ETP108 tp path : "/usr/sap/put/abap/exe/tp"

1 ETP109 version and release : "372.04.40" "701"

1 ETP198

4 ETW000 /usr/sap/put/abap/exe/R3trans version 6.13 (release 640 - 26.10.11 - 13:00:00).

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

4 ETW000

4 ETW000 date&time : 12.12.2011 - 08:47:29

4 ETW000 control file: /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 > #pid 4722720 on p19637dtw261 (sccadm)

4 ETW000 > import

4 ETW000 > buffersync=no

4 ETW000 > file='/usr/sap/put/abap/data/RB70104.SAP'

4 ETW000 > continuation='/usr/sap/put/abap/data/RB70104_#.SAP'

4 ETW000 > client cascade yes

4 ETW000 > repeatimport=yes

4 ETW000 > importtruncated = yes

4 ETW000 > including 'NOTHING'

4 ETW000 R3trans was called as follows: /usr/sap/put/abap/exe/R3trans -u 26 -w /usr/sap/put/abap/tmp/SAPLB70104.SCC /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 active unconditional modes: 26

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe') or dbms_type ('ORA')"

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP110 end date and time : "20111212084729"

1 ETP111 exit code : "12"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP101 transport order : "SAPKB70104"

1 ETP102 system : "SCC"

1 ETP108 tp path : "/usr/sap/put/abap/exe/tp"

1 ETP109 version and release : "372.04.40" "701"

1 ETP198

4 ETW000 /usr/sap/put/abap/exe/R3trans version 6.13 (release 640 - 26.10.11 - 13:00:00).

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

4 ETW000

4 ETW000 date&time : 12.12.2011 - 10:47:52

4 ETW000 control file: /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 > #pid 6095006 on p19637dtw261 (sccadm)

4 ETW000 > import

4 ETW000 > buffersync=no

4 ETW000 > file='/usr/sap/put/abap/data/RB70104.SAP'

4 ETW000 > continuation='/usr/sap/put/abap/data/RB70104_#.SAP'

4 ETW000 > client cascade yes

4 ETW000 > repeatimport=yes

4 ETW000 > importtruncated = yes

4 ETW000 > including 'NOTHING'

4 ETW000 R3trans was called as follows: /usr/sap/put/abap/exe/R3trans -u 26 -w /usr/sap/put/abap/tmp/SAPLB70104.SCC /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 active unconditional modes: 26

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe') or dbms_type ('ORA')"

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP110 end date and time : "20111212104752"

1 ETP111 exit code : "12"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP101 transport order : "SAPKB70104"

1 ETP102 system : "SCC"

1 ETP108 tp path : "/usr/sap/put/abap/exe/tp"

1 ETP109 version and release : "372.04.40" "701"

1 ETP198

4 ETW000 /usr/sap/put/abap/exe/R3trans version 6.13 (release 640 - 26.10.11 - 13:00:00).

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

4 ETW000

4 ETW000 date&time : 12.12.2011 - 10:54:53

4 ETW000 control file: /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 > #pid 6381618 on p19637dtw261 (sccadm)

4 ETW000 > import

4 ETW000 > buffersync=no

4 ETW000 > file='/usr/sap/put/abap/data/RB70104.SAP'

4 ETW000 > continuation='/usr/sap/put/abap/data/RB70104_#.SAP'

4 ETW000 > client cascade yes

4 ETW000 > repeatimport=yes

4 ETW000 > importtruncated = yes

4 ETW000 > including 'NOTHING'

4 ETW000 R3trans was called as follows: /usr/sap/put/abap/exe/R3trans -u 26 -w /usr/sap/put/abap/tmp/SAPLB70104.SCC /usr/sap/put/abap/tmp/SAPKKB70104.SCC

4 ETW000 active unconditional modes: 26

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/put/abap/exe') or dbms_type ('ORA')"

1 ETP176 IMPORT OF COMMANDFILE ONLY

1 ETP110 end date and time : "20111212105453"

1 ETP111 exit code : "12"

1 ETP199 ######################################

4 EPU202XEND OF SECTION BEING ANALYZED

p19637dtw261:sccadm>

Regards,

Anil

Former Member
0 Kudos

Hi Eric/Deepak/Database SAP and others,

Can you Guys please help me in resolving this issue.

Regards,

Anil.

Former Member
0 Kudos

Hi

try this one..

change environment varialble DIR_LIBRARY to "/usr/sap/put/abap/exe" and retry the upgrade.

regards,

saperrors.com

Former Member
0 Kudos

Hi,

But i am not sure if i give environment variable for DIR_LIBRARY to /usr/sap/put/abap/exe and what implication it will cause later.

Regards,

Anil

Former Member
0 Kudos

Hi,

Could you provide "R3trans -d" trans.log output, here? The problem might be caused by the symbolic links.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Dec 12, 2011 11:02 PM

Former Member
0 Kudos

Hi Anil,

Sounds good to verify the oracle steps as Volker advised.

See the planning section of the guide --> database specific aspects --> Check the oracle client and NLS_NCHAR_CHARACTERSET parameter as per the Notes mentioned there in the guide.

Also in Preparation section --> 'Making Preparations at the Database Level'

Thanks

Former Member
0 Kudos

This note might be helpful to you;

Note 836517 - Oracle database 10g: Preparation for SAP upgrade

Former Member
0 Kudos

Hi Orkun / DatabaseSAP and others,

I did a oracle client comparison (10x_64) between SCC and UCC (where we have done the CRM upgrade successfully)and found that it is fine

p19637dtw261:sccadm> cd instantclient_10202

p19637dtw261:sccadm> ls -ltr

total 485560

-rwxrwxr-x 1 orascc dba 70110326 Feb 25 2006 libociei.so_old

-rwxrwxr-x 1 orascc dba 70110326 Feb 25 2006 libociei.so

-rwxrwxr-x 1 orascc dba 4796980 Feb 25 2006 libnnz10.so

-rwxrwxr-x 1 orascc dba 24077164 Feb 25 2006 libclntsh.a_old

-rwxrwxr-x 1 orascc dba 24077164 Feb 25 2006 libclntsh.a

-rwxrwxr-x 1 orascc dba 5972886 Feb 25 2006 libocci.a

-rwxrwxr-x 1 orascc dba 22795273 Feb 25 2006 libocijdbc10.so

-rwxrwxr-x 1 orascc dba 1540330 Feb 25 2006 ojdbc14.jar

-rwxrwxr-x 1 orascc dba 1593906 Feb 25 2006 classes12.jar

-rwxrwxr-x 1 orascc dba 23503095 Mar 27 2006 libclntsh.so

p19637dtw261:sccadm>

p22837dev482:uccadm> cd instantclient_10202

p22837dev482:uccadm> ls -ltr

total 301592

-rwxrwxr-x 1 oraucc dba 70110326 Feb 25 2006 libociei.so

-rwxrwxr-x 1 oraucc dba 4796980 Feb 25 2006 libnnz10.so

-rwxrwxr-x 1 oraucc dba 24077164 Feb 25 2006 libclntsh.a

-rwxrwxr-x 1 oraucc dba 5972886 Feb 25 2006 libocci.a

-rwxrwxr-x 1 oraucc dba 22795273 Feb 25 2006 libocijdbc10.so

-rwxrwxr-x 1 oraucc dba 1540330 Feb 25 2006 ojdbc14.jar

-rwxrwxr-x 1 oraucc dba 1593906 Feb 25 2006 classes12.jar

-rwxrwxr-x 1 oraucc dba 23503095 Mar 27 2006 libclntsh.so

p22837dev482:uccadm>

Also the symbolics link are fine

Regards,

Anil Shenoy

Former Member
0 Kudos

Hi Basis Expert,

Thanks for your support.

Finally this issue is fixed.

Regards,

Anil.

Former Member
0 Kudos

Hi Anil,

What exactly was the issue and what you did to resolve the problem ?

It would help all our colleagues if we bump into similar issue.

Thanks

Former Member
0 Kudos

Hi DatabaseSAP,

The issue was with the R3trans file in SCC (/usr/sap/put/abap/exe and exenew)

The file size was less when compare to our UCC system. So i copied the R3trans file from UCC /usr/sap/put/abap/exe and exenew to SCC /usr/sap/put/abap/exe and exenew

Regards,

Anil