cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IDES SAP ERP 6.0 SR3 installetion problem on "Import abap" phase

Former Member

on ‎03-23-2011 8:38 AM

0 Kudos

Good day.

I'm new in SAP. I'm installing IDES SAP ERP 6.0 SR3 on Linux. It's my first installation. DB is Oracle 10.2.0.4. Patch 10.2.0.4 was in package list for this IDES. That is why I didn't install 10.2.0.5. I faced following issue on a Import abap phase:

All Import Monitor jobs are failed.

Last Errors in sapinst.log:

-----
...
Import Monitor jobs: running 1, waiting 1, completed 0, failed 110, total 112.
Loading of 'SAPDFACT' import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 0, failed 111, total 112.
ERROR 2011-03-23 09:36:32.244
CJS-30022  Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.
ERROR 2011-03-23 09:36:32.257
FCO-00011  The step runMigrationMonitor with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR ( Last error reported by the step :Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.).
-----

Errors in import_monitor.java.log:

----
Loading of <NAME> import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 0, failed 111, total 112
----

For example errors in SAP0000.log

----
/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110323093602
/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 23:24:14
/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110323093602
----

Each job log file contain above error.

As far as I understand R3load can't connect to the database. Command R3load -testconnect shows same error.

----
$ env ; /usr/sap/I02/SYS/exe/run/R3load -testconnect
DIR_LIBRARY=/usr/sap/I02/SYS/exe/run
HOSTNAME=idessrv2
dbs_ora_tnsname=I02
dbms_type=ORA
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
USER=i02adm
LD_LIBRARY_PATH=/usr/sap/I02/SYS/exe/run:/oracle/client/10x_32/instantclient
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
ORACLE_SID=I02
ORACLE_BASE=/oracle
KDEDIR=/usr
dbs_ora_schema=SAPSR3
TNS_ADMIN=/usr/sap/I02/SYS/profile/oracle
MAIL=/var/spool/mail/i02adm
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/i02adm/bin:/opt/j2re1.4.2_19/bin/:.:/home/I02adm:/usr/sap/I02/SYS/exe/run:/usr/bin:/usr/sbin:/usr/ucb:/usr/local/bin:/opt/quest/bin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/etc/vx/bin:/usr/ccs/bin
INPUTRC=/etc/inputrc
PWD=/home/i02adm
SAPDATA_HOME=/oracle/I02
LANG=en_US.UTF-8
SAPSYSTEMNAME=I02
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/i02adm
LOGNAME=i02adm
LESSOPEN=|/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES=1
_=/bin/env
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110323112804
/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 23:24:14
/usr/sap/I02/SYS/exe/run/R3load -testconnect 
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: DbSlErrorMsg rc = 99
/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110323112804
----

How can I determinate why r3load can't connect to oracle?

Before create this post I've reviewed a lot of posts on this forum and double check listnet and oracle. They are running, there is now errors in alert log file.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

markus_doehr2
Active Contributor
‎03-23-2011 4:04 PM
0 Kudos

> /usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

> DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

> DbSl Trace: CONNECT failed with sql error '1034'

> DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

> DbSl Trace: CONNECT failed with sql error '1034'

> (DB) ERROR: db_connect rc = 256

> DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

> DbSl Trace: CONNECT failed with sql error '1034'

> DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

> DbSl Trace: CONNECT failed with sql error '1034'

> (DB) ERROR: DbSlErrorMsg rc = 99

Your Oracle is not running.

Execute

sqlplus / as sysdba
shutdown abort
startup

and post the output.

Markus

Show replies
Show replies
Former Member
‎03-24-2011 7:33 AM
0 Kudos

It's running.

[orai02@idessrv2 ~]$ ps -fu $LOGNAME
UID        PID  PPID  C STIME TTY          TIME CMD
orai02    6464  6463  0 Mar22 pts/2    00:00:00 -bash
orai02    6493     1  0 Mar22 ?        00:00:03 /oracle/I02/102_32//bin/tnslsnr LISTENER -inherit
orai02    9734     1  0 Mar23 ?        00:00:01 ora_pmon_I02
orai02    9736     1  0 Mar23 ?        00:00:00 ora_psp0_I02
orai02    9738     1  0 Mar23 ?        00:00:00 ora_mman_I02
orai02    9740     1  0 Mar23 ?        00:00:02 ora_dbw0_I02
orai02    9742     1  0 Mar23 ?        00:00:03 ora_lgwr_I02
orai02    9744     1  0 Mar23 ?        00:00:17 ora_ckpt_I02
orai02    9746     1  0 Mar23 ?        00:00:01 ora_smon_I02
orai02    9748     1  0 Mar23 ?        00:00:00 ora_reco_I02
orai02    9750     1  0 Mar23 ?        00:00:04 ora_cjq0_I02
orai02    9752     1  0 Mar23 ?        00:00:01 ora_mmon_I02
orai02    9754     1  0 Mar23 ?        00:00:22 ora_mmnl_I02
orai02    9758     1  0 Mar23 ?        00:00:00 ora_qmnc_I02
orai02    9764     1  0 Mar23 ?        00:00:00 ora_q000_I02
orai02    9936     1  0 Mar23 ?        00:00:00 ora_q002_I02
orai02   11079  6464  0 10:43 pts/2    00:00:00 ps -fu orai02

[orai02@idessrv2 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 24 10:44:16 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size		    1268920 bytes
Variable Size		  314573640 bytes
Database Buffers	  289406976 bytes
Redo Buffers		    2924544 bytes
Database mounted.
Database opened.

Former Member
‎03-24-2011 8:51 AM
0 Kudos

It may sound a bit stupid, but have you tried to reboot your entire server?

Kind regards,

Mark

Former Member
‎03-24-2011 9:49 AM
0 Kudos

Yes, I did it.

I found following.

If don't set parameter dbs_ora_schema in my environment R3trans use SAPR3 user for connecting. I didn't find this user in database:

SQL> SELECT * FROM DBA_USERS WHERE USERNAME = 'SAPR3';
no rows selected

But user SAPSR3 exists. I used SAPSR3 as dbs_ora_schema. But saw same errors in the log.

When I execute R3trans -d I see following in the listener.log file. i think it's normal.

24-MAR-2011 12:42:34 * (CONNECT_DATA=(SID=I02)(GLOBAL_NAME=I02.WORLD)(CID=(PROGRAM=R3trans)(HOST=idessrv2)(USER=i02adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.18)(PORT=54517)) * establish * I02 * 0
24-MAR-2011 12:42:34 * (CONNECT_DATA=(SID=I02)(GLOBAL_NAME=I02.WORLD)(CID=(PROGRAM=R3trans)(HOST=idessrv2)(USER=i02adm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.18)(PORT=54518)) * establish * I02 * 0

Per trans log first program tries to login as OPS$-user user:

4 ETW000  [dev trc     ,00000]  Logon as OPS$-user to get SAPR3's password            12  0.010631
4 ETW000  [dev trc     ,00000]  Connecting as /@I02 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
...
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0x956eb08,srvhp=0x95802ec,usrhp=0x95adda0)
4 ETW000                                                                              24  0.028279
4 ETW000  [dboci.c ;    ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

And get first error while starting user session.

Then it tries to login as SAPR3:

4 ETW000  [dev trc     ,00000]  Try to connect with default password                  28  0.031237
4 ETW000  [dev trc     ,00000]  Connecting as SAPR3/<pwd>@I02 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000                                                                              12  0.031249
...
4 ETW000  [dev trc     ,00000]  Assigning username to user session 0x95adda0          11  0.042880
4 ETW000  [dev trc     ,00000]  Assigning password to user session 0x95adda0          18  0.042898
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0x956eb08,srvhp=0x95802ec,usrhp=0x95adda0)
4 ETW000                                                                             130  0.043028
4 ETW000  [dboci.c ;    ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

And fails again.

How can I determinate why it can't create session? As far as I understand it fails before user/password check step.

Former Member
‎03-25-2011 4:48 AM
0 Kudos

Might be issue with ur Export , kindly copy export dump from original DVD to Local server and try to start installation ....

Former Member
‎03-25-2011 6:17 AM
0 Kudos

Yes, looks like it was the issue with my export DVD. It was my mistake. Migration export was set to migration DVD1 but not to DVD1/EXP1 per note 1244548.

I set it to DVD1/EXP1 on the previous errors on Import ABAP phase.

Now I've reinstalled IDES, set correct path to Migration export ant apply 10.2.0.4 patch set. Import ABAP phase has been completed without errors.

Thanks for help!

sivakumar_kilari3
Active Contributor
‎03-23-2011 10:51 AM
0 Kudos

Start the database manually and start installation.

Thanks

Siva

Show replies
Show replies
Former Member
‎03-23-2011 10:58 AM
0 Kudos

I did it and got the same issue

Former Member
‎03-23-2011 11:00 AM
0 Kudos

Can you update your Oracle client software to a higher patch level and use the latest version of R3trans?

Kind regards,

Mark

Former Member
‎03-23-2011 11:07 AM
0 Kudos

Which of following clients do you suggets?

000005 51038966 ORACLE Client 11.2

000006 51039412 ORACLE Client V5 10.2.0.4

Please, can you give me sapnote nomber or any other guid about how to use the latest version of R3trans?

Thanks,

Philipp.

Former Member
‎03-23-2011 11:39 AM
0 Kudos

I would go for client 10.2.0.4 You can download client patches as well under http://service.sap.com/swdc -> database patches -> etc.

First try that before updating the R3trans.

Kind regards,

Mark

Former Member
‎03-23-2011 1:40 PM
0 Kudos

I've updated Oracle client. Nothing has changed. I've got the same issue.

Should I proceed with R3trans update? I'm not sure how can I do it.

Thanks,

Philipp

Former Member
‎03-24-2011 8:22 AM
0 Kudos

I've downloaded R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).

I've got same errors

...

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034             2112  0.030104
4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=1,svrhp=0x9643414)                          14  0.030118
4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0x962fdb0,srvhp=0x9643414)
4 ETW000                                                                                12  0.030130
4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x9643414                              99  0.030229
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1034'                         21  0.030250
4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1034                             13  0.030263
4 ETW000  [dev trc     ,00000]  Try to connect with default password                                      29  0.030292
4 ETW000  [dev trc     ,00000]  Connecting as SAPSR3/<pwd>@I02 on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
4 ETW000                                                                                14  0.030306
4 ETW000  [dev trc     ,00000]  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch
4 ETW000                                                                                14  0.030320
4 ETW000  [dev trc     ,00000]    0 UTF8                                                      1  0x962aee8  0x963059c  0x962fe24
4 ETW000                                                                                13  0.030333
4 ETW000  [dev trc     ,00000]  Allocating server context handle                                           7  0.030340
4 ETW000  [dev trc     ,00000]  Attaching to DB Server I02 (con_hdl=0,svchp=0x962fdb0,srvhp=0x9643414)
4 ETW000                                                                                16  0.030356
4 ETW000  [dev trc     ,00000]  Thu Mar 24 11:28:30 2011                                               13864  0.044220
4 ETW000  [dev trc     ,00000]  Assigning server context 0x9643414 to service context 0x962fdb0           15  0.044235
4 ETW000  [dev trc     ,00000]  Assigning username to user session 0x9670488                              11  0.044246
4 ETW000  [dev trc     ,00000]  Assigning password to user session 0x9670488                              19  0.044265
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=0x962fdb0,srvhp=0x9643414,usrhp=0x9670488)
4 ETW000                                                                                146  0.044411
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034             1998  0.046409
4 ETW000  [dev trc     ,00000]  server_detach(con_hdl=0,stale=1,svrhp=0x9643414)                           0  0.046409
4 ETW000  [dev trc     ,00000]  Detaching from DB Server (con_hdl=0,svchp=0x962fdb0,srvhp=0x9643414)
4 ETW000                                                                                0  0.046409
4 ETW000  [dev trc     ,00000]  Deallocating server context handle 0x9643414                               0  0.046409
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1034'                          0  0.046409
4 ETW000  [dev trc     ,00000]     set_ocica() -> OCI or SQL return code 1034                              0  0.046409
4 ETW000  [dblink      ,00433]  ***LOG BY2=>sql error 1034   performing CON [dblink#8 @ 433]              40  0.046449
4 ETW000  [dblink      ,00433]  ***LOG BY0=>ORA-01034: ORACLE not available                               14  0.046463
4 ETW000                        ORA-27101: shared memory realm does not exist
4 ETW000                        Linux Error: 2: No such file or directory [dblink#8 @ 433]
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'I02'"

sivakumar_kilari3
Active Contributor
‎03-23-2011 10:24 AM
0 Kudos

Can you paste SAP0000.log this log file here.

Thanks

Siva

Show replies
Show replies
Former Member
‎03-23-2011 10:41 AM
0 Kudos

Here is last error in last retry while installing

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110323093602

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 23 2008 23:24:14
/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error 

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110323093602

Edited by: Philipp Pushkar on Mar 23, 2011 11:41 AM

Edited by: Philipp Pushkar on Mar 23, 2011 11:42 AM

Former Member
‎03-23-2011 10:43 AM
0 Kudos

All log

cat SAP0000.log

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322033547

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -ctf I /storage/IDES_SAP_ERP_6.0_SR3_Inst_Export/51034985_1_back/EXP1/DATA/SAP0000.STR /tmp/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/DDLORA.TPL SAP0000.TSK ORA -l SAP0000.log -o D

/usr/sap/I02/SYS/exe/run/R3load: job completed

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322033547

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322033547

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322033548

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322040950

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322040951

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322045334

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322045335

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322225714

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322225715

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110322232753

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110322232757

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110323012738

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110323012738

/usr/sap/I02/SYS/exe/run/R3load: START OF LOG: 20110323093602

/usr/sap/I02/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

/usr/sap/I02/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Jan 23 2008 23:24:14

/usr/sap/I02/SYS/exe/run/R3load -i SAP0000.cmd -dbcodepage 4103 -l SAP0000.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/I02/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/I02/SYS/exe/run/R3load: END OF LOG: 20110323093602

sivakumar_kilari3
Active Contributor
‎03-23-2011 10:44 AM
0 Kudos

Read this note:

Note 491174 - Composite SAP note for ORA-01034

Thanks

Siva

Former Member
‎03-23-2011 10:48 AM
0 Kudos

I saw this note. I was rechecked eache case in this note few times.

Former Member
‎03-23-2011 9:31 AM
0 Kudos

Hi Philipp,

Can you please check the following:

as ora user: lsnrctl status

as sid user: R3trans -d (and post the output of the created log)

Kind regards,

Mark

Show replies
Show replies
Former Member
‎03-23-2011 9:39 AM
0 Kudos

[orai02@idessrv2 background]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-MAR-2011 12:42:32

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=I02.WORLD))

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date 22-MAR-2011 16:13:32

Uptime 0 days 20 hr. 29 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/I02/102_32//network/admin/listener.ora

Listener Log File /oracle/I02/102_32/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=I02.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=I02)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=idessrv2)(PORT=1527)))

Services Summary...

Service "I02" has 1 instance(s).

Instance "I02", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

=======================================

[i02adm@idessrv2 ~]$ cat trans.log

4 ETW000 /usr/sap/I02/SYS/exe/run/R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 23.03.2011 - 12:43:54

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: /usr/sap/I02/SYS/exe/run/R3trans -d

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

4 ETW000 [dev trc ,00000] Wed Mar 23 12:43:54 2011 59 0.000059

4 ETW000 [dev trc ,00000] db_con_init called 12 0.000071

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

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

4 ETW000 26 0.000117

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/I02/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 8170 0.008287

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

4 ETW000 16 0.008303

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

4 ETW000 19 0.008322

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

4 ETW000 69 0.008391

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

4 ETW000 25 0.008416

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

4 ETW000 37 0.008453

4 ETW000 [dev trc ,00000] New connection 0 created 20 0.008473

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 32 0.008505

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

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

4 ETW000 22 0.008543

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 24 0.008567

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 204 0.008771

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3028 0.011819

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 20 0.011839

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

4 ETW000 17 0.011856

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

4 ETW000 25 0.011881

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9569680 0x956ecec 0x956e574

4 ETW000 16 0.011897

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

4 ETW000 [dev trc ,00000] Allocating server context handle 11 0.011936

4 ETW000 [dev trc ,00000] Attaching to DB Server I02 (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4)

4 ETW000 35 0.011971

4 ETW000 [dev trc ,00000] Assigning server context 0x957fce4 to service context 0x956e500

4 ETW000 18014 0.029985

4 ETW000 [dev trc ,00000] Allocating user session handle 27 0.030012

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4,usrhp=0x95aa974)

4 ETW000 27 0.030039

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

4 ETW000 3262 0.033301

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x957fce4)

4 ETW000 15 0.033316

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4)

4 ETW000 13 0.033329

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x957fce4 117 0.033446

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

4 ETW000 28 0.033474

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 12 0.033486

4 ETW000 [dev trc ,00000] Try to connect with default password 28 0.033514

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

4 ETW000 15 0.033529

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

4 ETW000 15 0.033544

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9569680 0x956ecec 0x956e574

4 ETW000 14 0.033558

4 ETW000 [dev trc ,00000] Allocating server context handle 9 0.033567

4 ETW000 [dev trc ,00000] Attaching to DB Server I02 (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4)

4 ETW000 17 0.033584

4 ETW000 [dev trc ,00000] Assigning server context 0x957fce4 to service context 0x956e500

4 ETW000 13985 0.047569

4 ETW000 [dev trc ,00000] Assigning username to user session 0x95aa974 12 0.047581

4 ETW000 [dev trc ,00000] Assigning password to user session 0x95aa974 22 0.047603

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4,usrhp=0x95aa974)

4 ETW000 16 0.047619

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1034

4 ETW000 2625 0.050244

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x957fce4)

4 ETW000 15 0.050259

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x956e500,srvhp=0x957fce4)

4 ETW000 13 0.050272

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x957fce4 79 0.050351

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

4 ETW000 21 0.050372

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1034 8 0.050380

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

4 ETW000 67 0.050447

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01034: ORACLE not available 10 0.050457

4 ETW000 ORA-27101: shared memory realm does not exist

4 ETW000 Linux Error: 2: No such file or directory [dblink#5 @ 431]

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

Former Member
‎03-23-2011 9:44 AM
0 Kudos

PS. What should I do to make my posts good, not as one string?

Former Member
‎03-23-2011 9:51 AM
0 Kudos 
ORA-01034: ORACLE not available

Can you check if the database is open? From sqlplus enter: select open_mode from v$database;

You can post the logs in brackets to get them outlined.

Kind regards,

Mark

Former Member
‎03-23-2011 9:56 AM
0 Kudos 
SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE
Former Member
‎03-23-2011 10:06 AM
0 Kudos

Could be an issue with the LD_LIBRARY_PATH

Can you check if it's correctly set for the adm user?

Kind regards,

Mark

Former Member
‎03-23-2011 10:09 AM
0 Kudos 
[i02adm@idessrv2 ~]$ echo $LD_LIBRARY_PATH
/usr/sap/I02/SYS/exe/run:/oracle/client/10x_32/instantclient
Former Member
‎03-23-2011 10:14 AM
0 Kudos

Have you updated your Oracle client software? Are you running 32 or 64 bit?

Kind regards,

Mark

Former Member
‎03-23-2011 10:17 AM
0 Kudos

No, I've not updated Oracle client.

It's 32bit system.

Ask a Question