Problem installing SolMan 4.0

[guillermo_m]

Hi to everyone!

I'm having a problem in the step 16 (Perform post-load activities) of the Solution Manager 4.0 installation on Windows 2003 and Oracle 10.0.2.

The Windows displays an error message "The procedure entry point longjmp could not be located in the dynamic library orauts.dll".

The SAPINST log record this:

INFO 2007-03-01 20:53:22

Copied file 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.64.xml'.

INFO 2007-03-01 20:53:22

Copied file 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.65.xml'.

INFO 2007-03-01 20:53:26

Copied file 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/keydb.xml' to 'D:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/keydb.33.xml'.

INFO 2007-03-01 20:53:26

Execute step setOraclePasswords of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0.

INFO 2007-03-01 20:53:39

Removing file D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-03-01 20:53:39

Creating file D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-03-01 20:53:39

Switched to user: gd0adm.

INFO 2007-03-01 20:53:39

Working directory changed to D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

INFO 2007-03-01 20:53:42

Switched to user: gd0adm.

INFO 2007-03-01 20:53:42

Creating file D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\brconnect.log.

INFO 2007-03-01 20:53:42

Switched to user: gd0adm.

INFO 2007-03-01 20:53:42

Working directory changed to D:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

INFO 2007-03-01 20:53:42

Output of C:\usr\sap\GD0\SYS\exe\uc\NTI386\brconnect.exe -u / -c -f chpass -o SAPSR3 -p XXXXXX is written to the logfile brconnect.log.

WARNING 2007-03-01 20:53:45

Execution of the command "C:\usr\sap\GD0\SYS\exe\uc\NTI386\brconnect.exe -u / -c -f chpass -o SAPSR3 -p XXXXXX" finished with return code 3. Output:

BR0801I BRCONNECT 7.00 (12)

BR0999E Loading of SQL client library orasql10.dll failed - please check Oracle configuration

BR0310E Connect to database instance GD0 failed

BR0280I BRCONNECT time stamp: 2007-03-01 20.53.45

BR0804I BRCONNECT terminated with errors

ERROR 2007-03-01 20:53:45

CJS-30023 Process call 'C:\usr\sap\GD0\SYS\exe\uc\NTI386\brconnect.exe -u / -c -f chpass -o SAPSR3 -p XXXXXX' exits with error code 3. For details see log file(s) brconnect.log.

ERROR 2007-03-01 20:53:45

FCO-00011 The step setOraclePasswords with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|setOraclePasswords was executed with status ERROR .

and the BRCONNECT log's shows this:

BR0801I BRCONNECT 7.00 (12)

BR0999E Loading of SQL client library orasql10.dll failed - please check Oracle configuration

BR0310E Connect to database instance GD0 failed

BR0280I BRCONNECT time stamp: 2007-02-25 14.40.47

BR0804I BRCONNECT terminated with errors

Could anyone help me with this error?

Thanks a lot for all your time!!!

Regards!

Guille

[Former Member · Accepted solution]

Also, this message might be an indicator, too:

> Loading of SQL client library orasql10.dll failed

Try looking at that file and what directory it is in.

Then look at your profile parameters and make sure it is looking in the right location for it.

Environment variables for Oracle are typically user-specific, so make sure the environment variable for the user you are logged in as are correct for ORA_HOME (or ORACLE_HOME, depending on version)

Message was edited by:

Joey Stephens

[guillermo_m]

Thank you very much for all your help.

The system is Windows 2003 32 bits.

The rights for the user seems to be OK.

Now, I attach the tnsnames.ora, listener.ora, trans.log and default.pfl

Thanks in advance again for all your help!!!

tnsnames.ora:

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

GD0.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = cuervo)

(PORT = 1527)

)

)

(CONNECT_DATA =

(SID = GD0)

(GLOBAL_NAME = GD0.WORLD)

)

)

listener.ora:

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = GD0.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = GD0)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = cuervo)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = GD0)

(ORACLE_HOME = D:\oracle\GD0\102)

)

)

trans.log:

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 07.03.2007 - 22:06:46

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] Wed Mar 07 22:06:49 2007 6859 0.006859

4 ETW000 [dev trc ,00000] db_con_init called 24 0.006883

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 35 0.006958

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 67299 0.074257

4 ETW000 [dev trc ,00000] using "C:\usr\sap\GD0\SYS\exe\uc\NTI386\dboraslib.dll"

4 ETW000 35 0.074292

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 17 0.074309

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 28 0.074337

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.46)

4 ETW000 46045 0.120382

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 30 0.120412

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 40 0.120452

4 ETW000 [dev trc ,00000] New connection 0 created 24 0.120476

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 38 0.120514

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

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

4 ETW000 30 0.120565

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 23 0.120588

4 ETW000 [dev trc ,00000] Prepending C:\usr\sap\GD0\SYS\exe\uc\NTI386 to Path.

4 ETW000 686 0.121274

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 335695 0.457387

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPGD0's password 26 0.457413

4 ETW000 [dev trc ,00000] Connecting as /@GD0 on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 25 0.457438

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 272 0.457710

4 ETW000 [dev trc ,00000] 0 UTF8 1 0244D2C8 024527FC 02452084

4 ETW000 34 0.457744

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 5381 0.463125

4 ETW000 [dev trc ,00000] Allocating server context handle 23 0.463148

4 ETW000 [dev trc ,00000] Attaching to DB Server GD0 (con_hdl=0,svchp=02451FD0,svrhp=02463844)

4 ETW000 9131 0.472279

4 ETW000 [dev trc ,00000] Wed Mar 07 22:06:58 2007 9049762 9.522041

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

4 ETW000 28 9.522069

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12154'

4 ETW000 20 9.522089

4 ETW000 [dev trc ,00000] Try to connect with default password 344 9.522433

4 ETW000 [dev trc ,00000] Connecting as SAPGD0/<pwd>@GD0 on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 33 9.522466

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 33 9.522499

4 ETW000 [dev trc ,00000] 0 UTF8 1 0244D2C8 024527FC 02452084

4 ETW000 42 9.522541

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=02463844) 12 9.522553

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02451FD0,srvhp=02463844)

4 ETW000 19 9.522572

4 ETW000 [dev trc ,00000] Deallocating server context handle 02463844 15 9.522587

4 ETW000 [dev trc ,00000] Allocating server context handle 14 9.522601

4 ETW000 [dev trc ,00000] Attaching to DB Server GD0 (con_hdl=0,svchp=02451FD0,svrhp=02463844)

4 ETW000 28 9.522629

4 ETW000 [dev trc ,00000] Wed Mar 07 22:07:07 2007 8985572 18.508201

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

4 ETW000 32 18.508233

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12154'

4 ETW000 20 18.508253

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12154 performing CON [dblink#3 @ 431]

4 ETW000 11283 18.519536

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#3 @ 431]

4 ETW000 21 18.519557

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

default.pfl:

SAPDBHOST = cuervo

j2ee/dbtype = ora

j2ee/dbname = GD0

j2ee/dbhost = cuervo

SAPSYSTEMNAME = GD0

SAPGLOBALHOST = cuervo

#----

---

1. SAP Central Service Instance for J2EE

#----

---

j2ee/scs/host = cuervo

j2ee/scs/system = 00

j2ee/ms/port = 3900

rdisp/bufrefmode = sendoff,exeoff

#----

---

1. SAP Messaging Service for ABAP

#----

---

rdisp/mshost = cuervo

rdisp/msserv = sapmsGD0

rdisp/msserv_internal = 3901

#----

---

1. SAP Central Service Instance for J2EE

#----

---

#----

---

1. SAP Messaging Service for ABAP

#----

---

login/system_client = 001

[Former Member]

pure 32 Bit environment?

regards

Peter

[guillermo_m]

I think so. Do you know how can I check this?

Thanx a lot for all your help!!!

[Former Member]

> I think so. Do you know how can I check this?

One way us to open up the Oracle Enterprise Manager and look for the SAP (or the username might be SAPR3, it's been a while since I have done SAP on Oracle) and make sure it has owner or sysadmin rights on the sap database. If SAP create dthe user, the rights should be fine. If the user already existed (i.e. you are someone else created it) sometimes the correct permissions aren't assigned at install.

I don't know if this is your issue, but often when installing SAP the issues wind up being one of these three problems:

- database/network user rights

- database/log filling up

- parameter file

[former_member204746]

please execute R3trans -d

and supply trans.log

[Former Member]

Have you verified that the user the service is trying has rights inside the database?

[guillermo_m]

I downloaded the ORACLE_10.2_Client and set the environmet variable in the PATH variable to it. But I still have the same problem.

I check the R3trans -x at the command prompt and i have this message:

C:\usr\sap\GD0\SYS\exe\uc\NTI386>R3trans -x

This is R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'GD0'"

R3trans finished (0012).

Could anyone know what's happening?

Thanks a lot for your help!!!

[Former Member]

brconnect should normaly use the Oracle Instant Client which will never load orasql10.dll, but oci.dll and oraociicus10.dll.

can you please check the existance of oci.dll (or better o*.dll) in directory

C:\usr\sap\GD0\SYS\exe\uc\NTI386\

refere to note 998004 for updating the instant client.

regards

Peter

[Former Member]

Hi Guille,

Is your Oracle 10 Client correctly installed? Can you try a "R3trans -d", and see if RC=000?

If those things are ok, have a look at your <sid>adm environment.

Regards,

JC Llanes.

[former_member204746]

also check ORACLE_HOME and ORACLE_SID environment variables.

make sure that file orasql10.dll exists on your disk.