DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1

[Former Member]

hi

we have upgrade from 4.6d kernel to ERP 6 NON unicode

SAP is up and running

We want to do an export / import for unicode conversion

Export preparation failed at

/usr/sap/Q01/SYS/exe/run/R3ldctl -p /mnt/export/ABAP/DATA -l R3ldctlExport.log

Error log

DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

ERROR: DbSlConnect rc= 99

DbSl Trace: OCI-call 'OCIHandleAlloc' failed with rc=-2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

DbSl Trace: OCI-call 'OCIHandleAlloc' failed with rc=-2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

regards

[Former Member · Accepted solution]

I'm sorry It is

> R3load -testconnect E (This is to test your connectivity for export)

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: START OF LOG: 20081110150545

R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

R3load: version R7.00/V1.4 [UNICODE] --> this should be Not Unicode

Compiled Mar 22 2008 04:21:37

R3load -testconnect E

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) INFO: disconnected from DB

dbCodepage=<your system code page>

R3load: job completed

R3load: END OF LOG: 20081110150546

regards,

Vamshi.

[Former Member · Accepted solution]

hi Vamshi

here is what I got & it seems okey

q01adm> R3load -testconnect E

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: START OF LOG: 20081110232336

R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

R3load: version R7.00/V1.4

Compiled Oct 3 2008 23:16:23

R3load -testconnect E

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

dbCodepage=1100

(DB) INFO: disconnected from DB

R3load: job completed

R3load: END OF LOG: 20081110232343

regards

[Former Member]

Yeah Mark

I have tried running sapinst as both SIDadm and root as well both are struck at the same point

regards

[Former Member]

Jameel,

Try command as <sid>adm

R3ldctl (This should try to connect to your database and tries to read tables some tables)

This way you will know why it is failing. Check SAP notes with the version you are using for any bugs.If not raise a OSS msg. Ideally it should work if you have downloaded latest versions.

let me know the output.

regards,

Vamshi.

[Former Member]

Hi,

R3load -testconnect is working fine (Means database is up) but still your getting error So, check the corresponding tablespaces which it is trying to export now. Also check oracle parameters sessions and processes.

Please paste the log of R3trans -d and R3load -testconnection as user sidadm.

Thanks,

Kiran.

[Former Member]

hi all

it was wrong oracle client installation that caused the error

thanks for all your support

regards

[Former Member]

when I run export preparation as user SIDadm as you suggested

I get the same error message

Export preparation failed at

/usr/sap/Q01/SYS/exe/run/R3ldctl -p /mnt/export/ABAP/DATA -l R3ldctlExport.log

Error log

DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

ERROR: DbSlConnect rc= 99

DbSl Trace: OCI-call 'OCIHandleAlloc' failed with rc=-2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

DbSl Trace: OCI-call 'OCIHandleAlloc' failed with rc=-2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

DbSl Trace: OCI-call 'OCIEnvCreate(mode=0)' failed with rc=-1

DbSl Trace: OCI-call 'OCIErrorGet' failed with rc=-2

regards

[markus_doehr2]

sapinst must be run as root - it will switch automatically.

Since it runs manually as <sid>adm I have no clue why it does not when ran through sapinst...

Markus

[Former Member]

hi Mark

User Q01adm also gives the same error message

Env set as

LESSKEY=/etc/lesskey.bin

VNCDESKTOP=X

MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man

INFODIR=/usr/local/info:/usr/share/info:/usr/info

NNTPSERVER=news

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

DIR_LIBRARY_PATH=/usr/sap/Q01/SYS/exe/run

HOSTNAME=ai-sapupg

ORA_CRS_HOME=/opt/oracle/product/10gR2/crs

XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB

GNOME2_PATH=/usr/local:/opt/gnome:/usr

dbms_type=ORA

dbs_ora_tnsname=Q01

SHELL=/bin/bash

TERM=xterm

HOST=ai-sapupg

HISTSIZE=1000

PROFILEREAD=true

SSH_CLIENT=172.16.15.88 3723 22

NLS_LANG=AMERICAN_AMERICA.WE8DEC

WINDOWID=4194336

MORE=-sl

OLDPWD=/data/sapinstall

SSH_TTY=/dev/pts/3

ORA_ASM_HOME=/opt/oracle/product/10gR2/asm

THREAD=NOPS

XTERM_SHELL=/bin/bash

USER=q01adm

GROFF_NO_SGR=yes

LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:.cmd=00;32:.exe=01;32:.com=01;32:.bat=01;32:.btm=01;32:.dll=01;32:.tar=00;31:.tbz=00;31:.tgz=00;31:.rpm=00;31:.deb=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.zoo=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.tb2=00;31:.tz2=00;31:.tbz2=00;31:.avi=01;35:.bmp=01;35:.fli=01;35:.gif=01;35:.jpg=01;35:.jpeg=01;35:.mng=01;35:.mov=01;35:.mpg=01;35:.pcx=01;35:.pbm=01;35:.pgm=01;35:.png=01;35:.ppm=01;35:.tga=01;35:.tif=01;35:.xbm=01;35:.xpm=01;35:.dl=01;35:.gl=01;35:.wmv=01;35:.aiff=00;32:.au=00;32:.mid=00;32:.mp3=00;32:.ogg=00;32:.voc=00;32:*.wav=00;32:

LD_LIBRARY_PATH=/oracle/Q01/102_64/lib:/oracle/Q01/102_64/lib:/usr/sap/Q01/SYS/exe/run:/oracle/client/10x_64/instantclient

ORACLE_SID=Q01

XNLSPATH=/usr/X11R6/lib/X11/nls

ENV=/etc/bash.bashrc

HOSTTYPE=x86_64

ORACLE_BASE=/oracle

FROM_HEADER=

PAGER=less

CSHEDIT=emacs

dbs_ora_schema=SAPALG

XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/

MINICOM=-c on

PATH=/oracle/Q01/102_64/bin:.:/home/q01adm:/usr/sap/Q01/SYS/exe/run:/home/q01adm/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/java/jdk1.5.0_13/bin:/usr/java/jdk1.5.0_13/bin

MAIL=/var/mail/q01adm

TNS_ADMIN=/oracle/Q01/102_64/network/admin

CPU=x86_64

PWD=/data/sapinstall/installcd2/IM_LINUX_X86_64

INPUTRC=/home/q01adm/.inputrc

SAPDATA_HOME=/oracle/Q01

JAVA_HOME=/usr/java/jdk1.5.0_13

DB_SID=Q01

LANG=en_US.UTF-8

PYTHONSTARTUP=/etc/pythonstart

SAPSYSTEMNAME=Q01

PS1=

q01adm>

XTERM_VERSION=XTerm(208)

TEXINPUTS=::/home/q01adm/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:/home/q01adm/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX

HOME=/home/q01adm

SHLVL=4

QT_SYSTEM_DIR=/usr/share/desktop-data

OSTYPE=linux

LESS_ADVANCED_PREPROCESSOR=no

XCURSOR_THEME=Industrial

LS_OPTIONS=-N --color=tty -T 0

WINDOWMANAGER=/usr/X11R6/bin/gnome

GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0

LOGNAME=q01adm

MACHTYPE=x86_64-suse-linux

LESS=-M -I

G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252

CVS_RSH=ssh

GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0

SSH_CONNECTION=172.16.15.88 3723 172.16.3.193 22

ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal

XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share/:/opt/gnome/share/

LESSOPEN=lessopen.sh %s

PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/local/share/pkgconfig:/usr/lib64/pkgconfig:/usr/share/pkgconfig:/opt/kde3/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig

INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info

DISPLAY=:1.0

ORACLE_HOME=/oracle/Q01/102_64

LESSCLOSE=lessclose.sh %s %s

G_BROKEN_FILENAMES=1

COLORTERM=1

_=/usr/bin/env

regards

[markus_doehr2]

> User Q01adm also gives the same error message

above you sent the "R3load -testconnect" as ok...

Sapinst switches the user, it will start R3ldctl, R3szchck and R3load as <sid>adm.

Markus

[Former Member]

Hi Vamshi

I have the latest patches .Still I am facing this error message

regards

[Former Member]

Check right executable are used by SAP when using export process..I think you are executing from App server if so check your executable version is right "/usr/sap/Q01/SYS/exe/run/R3ldctl ".Last Check your Central Instance and Dialog instance export executables are same.

Hope this helps..

Regards,

Vamshi.

[Former Member]

Did you check all your mentioned below executables are non-unicode and have you checked files has right permissions.

set it to chmod 755 R3* in exe dir.Check whether executavbles

Check your Client libraries are right version and check its executable permissions. OCI errors are mostly related to client files incompatibility or permission problems.

Regards,

Vamshi.

[markus_doehr2]

Are you running the command as user "q01adm"?

Markus

[Former Member]

I am running as user root

regards

[Former Member]

Make sure you are using right R3ldctl Non-unicode version to export your database.

Also update following binaries with latest non-unicode versions R3trans,tp,R3szchk,R3load,R3ldctl,R3check,R3ta

Also set proper enviroment variables as root and also set proper permissions to the binaries.

Regards,

Vamshi.

[markus_doehr2]

I am running as user root

This can´t work.

"root" has not the proper environment set.

Use adm to run that.

Markus

[Former Member]

hi mark

root has proper env set

LESSKEY=/etc/lesskey.bin

VNCDESKTOP=X

MANPATH=/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man

INFODIR=/usr/local/info:/usr/share/info:/usr/info

NNTPSERVER=news

DIR_LIBRARY_PATH=/usr/sap/Q01/SYS/exe/run

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

HOSTNAME=ai-sapupg

ORA_CRS_HOME=/opt/oracle/product/10gR2/crs

XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB

GNOME2_PATH=/usr/local:/opt/gnome:/usr

dbms_type=ORA

dbs_ora_tnsname=Q01

SHELL=/bin/bash

TERM=xterm

HOST=ai-sapupg

HISTSIZE=1000

PROFILEREAD=true

SSH_CLIENT=172.16.15.88 3759 22

NLS_LANG=AMERICAN_AMERICA.WE8DEC

WINDOWID=4194336

MORE=-sl

SSH_TTY=/dev/pts/3

ORA_ASM_HOME=/opt/oracle/product/10gR2/asm

XTERM_SHELL=/bin/bash

USER=root

GROFF_NO_SGR=yes

LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:.cmd=00;32:.exe=01;32:.com=01;32:.bat=01;32:.btm=01;32:.dll=01;32:.tar=00;31:.tbz=00;31:.tgz=00;31:.rpm=00;31:.deb=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.zoo=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.tb2=00;31:.tz2=00;31:.tbz2=00;31:.avi=01;35:.bmp=01;35:.fli=01;35:.gif=01;35:.jpg=01;35:.jpeg=01;35:.mng=01;35:.mov=01;35:.mpg=01;35:.pcx=01;35:.pbm=01;35:.pgm=01;35:.png=01;35:.ppm=01;35:.tga=01;35:.tif=01;35:.xbm=01;35:.xpm=01;35:.dl=01;35:.gl=01;35:.wmv=01;35:.aiff=00;32:.au=00;32:.mid=00;32:.mp3=00;32:.ogg=00;32:.voc=00;32:*.wav=00;32:

LD_LIBRARY_PATH=/oracle/Q01/102_64/lib:/usr/sap/Q01/SYS/exe/run:/oracle/client/102x_64/instantclient

ORACLE_SID=Q01

XNLSPATH=/usr/X11R6/lib/X11/nls

ENV=/etc/bash.bashrc

HOSTTYPE=x86_64

ORACLE_BASE=/oracle

FROM_HEADER=

PAGER=less

CSHEDIT=emacs

dbs_ora_schema=SAPALG

XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/

MINICOM=-c on

PATH=/sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:

MAIL=/var/mail/root

TNS_ADMIN=/oracle/Q01/102_64/network/admin

CPU=x86_64

PWD=/data/sapinstall/installcd2/IM_LINUX_X86_64

INPUTRC=/etc/inputrc

SAPDATA_HOME=/oracle/Q01

JAVA_HOME=/usr/java/jdk1.5.0_13

LANG=POSIX

PYTHONSTARTUP=/etc/pythonstart

SAPSYSTEMNAME=Q01

XTERM_VERSION=XTerm(208)

TEXINPUTS=::/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX

HOME=/root

SHLVL=4

QT_SYSTEM_DIR=/usr/share/desktop-data

OSTYPE=linux

LESS_ADVANCED_PREPROCESSOR=no

XCURSOR_THEME=Industrial

LS_OPTIONS=-A -N --color=tty -T 0

WINDOWMANAGER=/usr/X11R6/bin/gnome

GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0

LOGNAME=root

MACHTYPE=x86_64-suse-linux

LESS=-M -I

CVS_RSH=ssh

GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0

SSH_CONNECTION=172.16.15.88 3759 172.16.3.193 22

ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal

XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share/:/opt/gnome/share/

LC_CTYPE=en_US.UTF-8

LESSOPEN=lessopen.sh %s

PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/local/share/pkgconfig:/usr/lib64/pkgconfig:/usr/share/pkgconfig:/opt/kde3/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig

INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info

DISPLAY=:2.0

ORACLE_HOME=/oracle/Q01/102_64

LESSCLOSE=lessclose.sh %s %s

G_BROKEN_FILENAMES=1

COLORTERM=1

OLDPWD=/data/sapinstall

_=/usr/bin/env

I tried updating R*.SAR files.It didn't work

when starting as user q01adm

I am getting this error message

could not connect to host local host on port 21200

sapinst as root is closed

regards

[Former Member]

I think....

If you are exporting your database using sapinst. You should be able to login as root .what i understand is sapinst internally connects to R3 database during export by setting environment variables dynamically to connect database and also creates <sid>adm files in the /tmp installation directory.

To check whether you are using right executables/enviromnets to connect database

check under <sid>adm

>R3load -e

Output should say successful.

regards,

Vamshi.

[Former Member]

Dear Mark

R3load -e as user Q01adm gives the below error message

R3load -e

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: missing command file name

Usage: R3load [options]

options:

-c <commit count> force commit after every <commit count> rows

(only for import)

-ctf I|E <str file> <tpl file> <task file> <dbs>

create task file

-create_queued_indexes create queued indexes (MaxDB only)

-tds <status> set default status in task file

-datacodepage <codepage> set codepage for data file

-dbcodepage <codepage> set DB codepage (as seen by R3load)

-e <command file> export

-extfile_required missing EXTFILE is an error

-h (or none) print help information

-i <command file> import

-imig 'dirty' export for incremental migration

-inplace perform inplace conversion (OS/400 only)

-k <key> migration key

-K [key] test migration key

-loadprocedure dbsl|fast|text|avoid [fastload argument]

-merge_bck try to merge TSK and TSK.bck file automatically

and continue with export/import

(WARNING: this can be dangerous if somebody fiddled

with the files or file system errors occurred)

-merge_only <task file> try to merge TSK and TSK.bck file automatically

-nametab <ddntt> <ddntf> alternative nametab for code page

conversion functions

-upg_nametab <ddntt> <ddntf> nametab names used during upgrade

-upg_ntabhdr <ddxtt> <ddxtf> nametab names used during upgrade

-nolog (SAP DB, DB6 only)

-notablelock (MaxDB, DB6 only)

-notransaction (INFORMIX only)

-nojournal (OS/400 only)

-o T|I|V|D|P omit tables, indexes, views, data or primary keys

-ops <file> <#FREELISTS> <#FREELIST GROUPS>

(OPS only)

-l <log file> use log file instead of stderr

-p <log file> use log file instead of stderr

-pipe use pipe instead of data files

-s <stat file> switch on printing of statistic information

-socket use sockets instead of data files

(WARNING: a conversion from nonUC to UC must be done

on the export side)

-discard don't output exported data

-continue_on_error (default for import)

-stop_on_error (default for export)

-t <time in seconds>

-testconnect [E|I] test DB connect (E == export, I == import)

-umg <SUMG file> name of XML file for transaction SUMG

('-umg NONE' to suppress the file and issue

errors instead)

-v show version

-where <file> use WHERE clauses in <file> when generating a TSK file

(<file> may only contain WHERE clauses for one table!)

-x <ctlfile> remove HEX 0 values from data using

description in <ctlfile>

-hint <hintfile> <read hintfile>

description in <hintfile>

(arguments in square brackets are optional)

is there a way you can check for error

I checked the profile files everythings looks fine

regards