on 08-27-2009 12:37 PM
Hi,
I am installing ECC 5.0 IDES in Redhat 5 with oracle 10.2.0.4 in i386 system. I am facing problem in Database Load phase. System is waiting long and not showing any progess. In command line, I am getting some lines but not ERROR
sapparam(1c):No profile used.
sapparam: SAPSYSTEMNAME neither in profile nor in commandline
Real group id set to 502.
sapparam: sapargv(argc,argv) has not been called.
502====group sapsys
I exported SAPSYSTEMNAME=IDS in root (installation account) and SAPSYSTEMNAME is present in both profiles (default, Instance) but still it is not processing and hangs at the same point.
Any help would be appreciated.
Regards,
Raju
Hi ,
Please post info from sapinst_dev.log & check in this file which command its going to execute .Also post latest log files which generated during installation.
Thanks..
Mohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi..
I checked but not found anything helpful. some useful info from sapinst_dev.log are
Process environment
===================
Environment Variables
=====================
SSH_AGENT_PID = 3448
HOSTNAME = test
TERM = xterm
SHELL = /bin/bash
DESKTOP_STARTUP_ID =
HISTSIZE = 1000
GTK_RC_FILES = /etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
WINDOWID = 52428881
SAPINST_EXEDIR_CD = /root/Desktop/Installation_Master_6.20_6.40_05_08/IM_LINUX_I386/SAPINST/UNIX/LINUX_32/.
USER = root
JRE_HOME = /usr/j2sdk1.4.2_14/jre
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:
LD_LIBRARY_PATH = /tmp/sapinst_exe.4439.1314444973:/oracle/IDS/102_32/lib:/usr/sap/IDS/SYS/exe/run:/sapmnt/IDS/exe
SSH_AUTH_SOCK = /tmp/ssh-eKWOiC3393/agent.3393
GNOME_KEYRING_SOCKET = /tmp/keyring-dOSXXm/socket
SESSION_MANAGER = local/test:/tmp/.ICE-unix/3393
SAPINST_JRE_HOME = /usr/j2sdk1.4.2_14/jre
PATH = /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/oracle/IDS/102_32/lib/:/usr/sap/IDS/SYS/exe/run:/oracle/IDS/102_32/bin:/root/bin
DESKTOP_SESSION = default
MAIL = /var/spool/mail/root
GDM_XSERVER_LOCATION = local
PWD = /root/Desktop/Installation_Master_6.20_6.40_05_08/IM_LINUX_I386/SAPINST/UNIX/LINUX_32
INPUTRC = /etc/inputrc
XMODIFIERS = @im=none
JAVA_HOME = /usr/j2sdk1.4.2_14
LANG = en_US.UTF-8
SAPINST_EXE_DIR = /tmp/sapinst_exe.4439.1314444973
SAPSYSTEMNAME = IDS
GDMSESSION = default
SSH_ASKPASS = /usr/libexec/openssh/gnome-ssh-askpass
SHLVL = 2
HOME = /root
GNOME_DESKTOP_SESSION_ID = Default
LOGNAME = root
DBUS_SESSION_BUS_ADDRESS = unix:abstract=/tmp/dbus-3olGY1jsXk,guid=7bc8584ee86b9c3709e89c70c3c1c600
LESSOPEN = |/usr/bin/lesspipe.sh %s
DISPLAY = :0.0
G_BROKEN_FILENAMES = 1
XAUTHORITY = /tmp/.gdmW4DU0V
COLORTERM = gnome-terminal
User: root, Id: 0
Effective user: root, Id: 0
Group: root, Id: 0
Effective group: root, Id: 0
Umask: 022
Resource Limits
===============
RLIMIT_CPU: maximum amount of CPU time in seconds current: unlimited maximum: unlimited
RLIMIT_FSIZE: maximum size of a file in bytes that may be created by a process current: unlimited maximum: unlimited
RLIMIT_DATA: maximum size of a process's heap in bytes current: unlimited maximum: unlimited
RLIMIT_STACK: maximum size of a process's stack in bytes current: 10485760 maximum: unlimited
RLIMIT_CORE: maximum size of a core file in bytes current: unlimited maximum: unlimited
RLIMIT_MEMLOCK: Locked-in-memory addess space. current: 32768 maximum: 32768
RLIMIT_NOFILE: one more than the maximum value that the system may assign to a newly created descriptor current: 1024 maximum: 1024
RLIMIT_OFILE: one more than the maximum value that the system may assign to a newly created descriptor current: 1024 maximum: 1024
RLIMIT_NPROC: maximum number of child processes per real user ID current: 24439 maximum: 24439
RLIMIT_RSS: maximum resident set size in bytes current: unlimited maximum: unlimited
RLIMIT_AS: maximum size of a process's total available memory, in bytes current: unlimited maximum: unlimited
Working directory: /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB
Some last lines are:-
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPCLUST.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPCLUST.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPCLUST.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4736
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPSLEXC.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLEXC.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLEXC.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4759
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPSLOAD.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLOAD.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLOAD.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4782
TRACE [iaxxcnclhd.cpp:60]
doHandleDoc() lib=iamodload module=CR3ldStep
ACTION_CANCEL requested
I also found 99 % CPU free and not executing any process.
Regards
Raju
Hi..
I checked but not found anything helpful. some useful info from sapinst_dev.log are below and cpu is 99% free.
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPCLUST.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPCLUST.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPCLUST.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4736
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPSLEXC.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLEXC.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLEXC.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4759
TRACE [iaxxbdbld.cpp:569]
CR3ldStep::createR3ldTskFiles lib=iamodload module=CR3ldStep
trying to generate task file: /sapmnt/IDS/exe/R3load -ctf I "/mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_3/EXP3/DATA/SAPSLOAD.STR" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL" "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLOAD.TSK" ORA -l "/tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSLOAD.log"
TRACE [syuxctask.cpp:1293]
CSyTaskImpl::start(bool) lib=iamodload module=CR3ldStep
A child process has been started. Pid = 4782
TRACE [iaxxcnclhd.cpp:60]
doHandleDoc() lib=iamodload module=CR3ldStep
ACTION_CANCEL requested
Hi..Markus,
Checked and got following --
idsadm 5297 4941 0 18:31 pts/1 00:00:00 /sapmnt/IDS/exe/R3load -ctf I /mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_1/EXP1/DATA/SAPSDIC.STR /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.TSK ORA -l /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.log
But corresponding log SAPSDIC.log show it is completed successfully. below is log
/sapmnt/IDS/exe/R3load: START OF LOG: 20110827173934
/sapmnt/IDS/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/sapmnt/IDS/exe/R3load: version R6.40/V1.4
/sapmnt/IDS/exe/R3load -ctf I /mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_1/EXP1/DATA/SAPSDIC.STR /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.TSK ORA -l /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.log
/sapmnt/IDS/exe/R3load: job completed
/sapmnt/IDS/exe/R3load: END OF LOG: 20110827173947
/sapmnt/IDS/exe/R3load: START OF LOG: 20110827183447
/sapmnt/IDS/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/sapmnt/IDS/exe/R3load: version R6.40/V1.4
/sapmnt/IDS/exe/R3load -ctf I /mnt/gg/Ester/IDES_ECC5_Linux_solaris/ECC5_export_Solaris_linux/51031332_1/EXP1/DATA/SAPSDIC.STR /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.TSK ORA -l /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPSDIC.log
/sapmnt/IDS/exe/R3load: job completed
/sapmnt/IDS/exe/R3load: END OF LOG: 20110827183447
Thanks
Raju
Hi..
I found following in sapinst_dir while i am successfully able to connect to oracle using sqlplus /nolog and also able to start it in mounted and open state. Listner also started. please see the log.........searched forum but could not found any solution....
/sapmnt/IDS/exe/R3load: START OF LOG: 20110827202713
/sapmnt/IDS/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/sapmnt/IDS/exe/R3load: version R6.40/V1.4
/sapmnt/IDS/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPAPPL0.cmd -l /tmp/sapinst_instdir/ECC50/SYSTEM/ABAP/ORA/NUC/DB/SAPAPPL0.log -stop_on_error
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034
DbSl Trace: CONNECT failed with sql error '1034'
(DB) ERROR: DbSlErrorMsg rc = 99
/sapmnt/IDS/exe/R3load: job finished with 1 error(s)
/sapmnt/IDS/exe/R3load: END OF LOG: 20110827202713
REgards,
Raju
Hi..
R3trans -d was showing error for environment variable DIR_LIBRARY and dbms_type I set these and executed with idsadm. it shows following problem in trans log ( oracle listner and oracle DB mounted manually with oraids).
Trans.log form idsadm
4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
4 ETW000
4 ETW000 date&time : 28.08.2011 - 11:01:00
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] Sun Aug 28 11:01:00 2011 103 0.000103
4 ETW000 [dev trc ,00000] db_con_init called 22 0.000125
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 57 0.000182
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/IDS/SYS/exe/run/dboraslib.so' ...
4 ETW000 35 0.000217
4 ETW000 [dev trc ,00000] Sun Aug 28 11:02:23 2011 83113211 83.113428
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/IDS/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 49 83.113477
4 ETW000 [dev trc ,00000] Library '/usr/sap/IDS/SYS/exe/run/dboraslib.so' loaded
4 ETW000 26 83.113503
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/IDS/SYS/exe/run/dboraslib.so
4 ETW000 40 83.113543
4 ETW000 [dev trc ,00000] Version of '/usr/sap/IDS/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.32)
4 ETW000 71 83.113614
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/IDS/SYS/exe/run/dboraslib.so
4 ETW000 34 83.113648
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/IDS/SYS/exe/run/dboraslib.so
4 ETW000 46 83.113694
4 ETW000 [dev trc ,00000] New connection 0 created 28 83.113722
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 30 83.113752
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 25 83.113777
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 25 83.113802
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 26 83.113828
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/IDS/102_32/ from environment
4 ETW000 316 83.114144
4 ETW000 [dev trc ,00000] -->oci_initialize 25 83.114169
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 2348 83.116517
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 60 83.116577
4 ETW000 [dev trc ,00000] Connecting as /@IDS on connection 0 ... 18 83.116595
4 ETW000 [dev trc ,00000] Allocating service context handle 38 83.116633
4 ETW000 [dev trc ,00000] Allocating server context handle 24 83.116657
4 ETW000 [dev trc ,00000] Attaching to DB Server IDS (con_hdl=0,svchp=0xa0d448c,svrhp=0xa0d4fec)
4 ETW000 67 83.116724
4 ETW000 [dev trc ,00000] Assigning server context 0xa0d4fec to service context 0xa0d448c
4 ETW000 70815 83.187539
4 ETW000 [dev trc ,00000] Allocating user session handle 42 83.187581
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0xa0d448c,srvhp=0xa0d4fec,usrhp=0xa0ddb80)
4 ETW000 44 83.187625
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
4 ETW000 3168 83.190793
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0xa0d4fec)
4 ETW000 28 83.190821
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0xa0d448c,srvhp=0xa0d4fec)
4 ETW000 23 83.190844
4 ETW000 [dev trc ,00000] Deallocating server context handle 0xa0d4fec 227 83.191071
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 51 83.191122
4 ETW000 [dev trc ,00000] Try to connect with default password 29 83.191151
4 ETW000 [dev trc ,00000] Connecting as SAPR3/<pwd>@IDS on connection 0 ...
4 ETW000 30 83.191181
4 ETW000 [dev trc ,00000] Allocating server context handle 17 83.191198
4 ETW000 [dev trc ,00000] Attaching to DB Server IDS (con_hdl=0,svchp=0xa0d448c,svrhp=0xa0d4fec)
4 ETW000 41 83.191239
4 ETW000 [dev trc ,00000] Assigning server context 0xa0d4fec to service context 0xa0d448c
4 ETW000 45416 83.236655
4 ETW000 [dev trc ,00000] Assigning username to user session 0xa0ddb80 24 83.236679
4 ETW000 [dev trc ,00000] Assigning password to user session 0xa0ddb80 30 83.236709
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0xa0d448c,srvhp=0xa0d4fec,usrhp=0xa0ddb80)
4 ETW000 28 83.236737
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1034
4 ETW000 3107 83.239844
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0xa0d4fec)
4 ETW000 27 83.239871
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0xa0d448c,srvhp=0xa0d4fec)
4 ETW000 24 83.239895
4 ETW000 [dev trc ,00000] Deallocating server context handle 0xa0d4fec 144 83.240039
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1034'
4 ETW000 35 83.240074
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1034 performing CON [dblink#1 @ 419]
4 ETW000 70 83.240144
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01034: ORACLE not available 25 83.240169
4 ETW000 ORA-27101: shared memory realm does not exist
4 ETW000 Linux Error: 2: No such file or directory [dblink#1 @ 419]
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'IDS'"
I am sorry for not getting proper format as code.
Regards.
RAJU
Hi ,
Please run R3trans -d if error code 12 then check trans.log for more details .Attach logs from trans.log to assist you furhter on this.
Thanks..
Mohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Execute
top d1c
and check if there are active processes.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.