dbHome must be a valid ORACLE_HOME directory.. Error

[Former Member]

Dear All;

I am installing SAP ERP 6.0 on Suse Linux, but I am stuck at the installation phase create/check table spaces with the error:

dbHome must be a valid ORACLE_HOME directory..

This is the log file:

INFO 2013-06-18 09:58:16.900

Authorizations set for /home/orauhr/stopdb.

INFO 2013-06-18 09:58:16.900

Authorizations set for /home/orauhr/stopdb.

INFO 2013-06-18 09:58:17.394

Execute step checkStepPreconditions of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBMCOD|ind|ind|ind|ind|2|0|NW_OraTablespace2|ind|ind|ind|ind|2|0

ERROR 2013-06-18 09:58:17.469

CJS-00030 Assertion failed: Component OraDatabaseTablespaces2: Context parameter dbHome must be a valid ORACLE_HOME directory.

ERROR 2013-06-18 09:58:17.470

MUT-03025 Caught ESAPinstException in Modulecall: Component OraDatabaseTablespaces2: Context parameter dbHome must be a valid ORACLE_HOME directory..

ERROR 2013-06-18 09:58:17.528

FCO-00011 The step checkStepPreconditions with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBMCOD|ind|ind|ind|ind|2|0|NW_OraTablespace2|ind|ind|ind|ind|2|0|checkStepPreconditions was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: Component OraDatabaseTablespaces2: Context parameter dbHome must be a valid ORACLE_HOME directory..).

I am not sure, but I think it is related to user privileges on the system. Could this be the reason?

Best Regards

~Amal Aloun

[Reagan · Accepted solution]

Hello

Please provide the environment settings for the user orasid user

su - orasid

env

Also can you provide the contents of control.xml file please ?

Thanks

RB

[Former Member · Accepted solution]

Dear Reagan;

for orasid the following parameters reside under env:

LESSKEY=/etc/lesskey.bin

NNTPSERVER=news

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

share/info:/usr/info
MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man
ORA_CRS_HOME=/oracle/product/10gR2/crs
HOSTNAME=
GNOME2_PATH=/usr/local:/opt/gnome:/usr
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
HOST=
SHELL=/bin/bash
TERM=xterm
PROFILEREAD=true
HISTSIZE=1000
MORE=-sl
ORA_ASM_HOME=/oracle/product/10gR2/asm
GROFF_NO_SGR=yes
JRE_HOME=/usr/lib64/jvm/java/jre
USER=orauhr
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:c      d=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:*.bm      p=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=0      1;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aif      f=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
ORACLE_SID=UHR
XNLSPATH=/usr/X11R6/lib/X11/nls
ENV=/etc/bash.bashrc
ORACLE_BASE=/oracle
HOSTTYPE=x86_64
FROM_HEADER=
PAGER=less
CSHEDIT=emacs
XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/
MINICOM=-c on
MAIL=/var/spool/mail/orauhr
PATH=/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:/oracle/product/10.2/db_1/bin:/usr/l      ocal/bin
CPU=x86_64
JAVA_BINDIR=/usr/lib64/jvm/java/bin
INPUTRC=/etc/inputrc
PWD=/home/orauhr
JAVA_HOME=/usr/lib64/jvm/java
LANG=en_US.UTF-8
PYTHONSTARTUP=/etc/pythonstart
SDK_HOME=/usr/lib64/jvm/java
TEXINPUTS=:/home/orauhr/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
QT_SYSTEM_DIR=/usr/share/desktop-data
JDK_HOME=/usr/lib64/jvm/java
SHLVL=1
HOME=/home/orauhr
LESS_ADVANCED_PREPROCESSOR=no
OSTYPE=linux
LS_OPTIONS=-N --color=tty -T 0
XCURSOR_THEME=Industrial
WINDOWMANAGER=/usr/X11R6/bin/gnome
GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
LESS=-M -I
MACHTYPE=x86_64-suse-linux
LOGNAME=orauhr
GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0
CVS_RSH=ssh
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share      /:/opt/gnome/share/
ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/local/share/pkgconfig:/usr/lib64/p      kgconfig:/usr/share/pkgconfig:/opt/kde3/lib64/pkgconfig:/opt/gnome/lib64/pkgconf      ig:/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig
LESSOPEN=lessopen.sh %s
INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
ORACLE_HOME=/oracle/product/10.2/db_1
LESSCLOSE=lessclose.sh %s %s
G_BROKEN_FILENAMES=1
JAVA_ROOT=/usr/lib64/jvm/java
COLORTERM=1
_=/usr/bin/env

Best Regards

~Amal

[former_member206552 · Accepted solution]

Hi Amal,

i just went throught the guide and they use /oracle/DBSID/102_64 as an example,

Home directory for Oracle instance

/oracle/<DBSID>/<102_32 or 102_64>

the solution to this tread was to re-install oracle (http://sap.ittoolbox.com/groups/technical-functional/sap-basis/dbhome-has-to-be-a-valid-oracle_home-...)

but you can as a test just create synbolic link and retry and if it works

ln -s /oracle/product/10.2/db_1 /oracle/DBSID/102_64

Best Regards

Marius

[Reagan · Accepted solution]

Hello Amal

ORACLE_HOME=/oracle/product/10.2/db_1

You have a non standard Oracle installation for SAP.

The ORACLE_HOME should be /oracle/SID/102_64

Regards

RB

[former_member218805]

Hi Amal,

First of all, you should make sure to use Software Provisioning Manager (SWPM) to avoid the possibility of this being a bug. The tool can be downloaded from http://service.sap.com/sltoolset (please refer to note #1680045).

Also, please note the Oracle RDMBS installation should take place only when sapinst prompts you to do so. As per the installation guide, you should not install the RDBMS beforehand. Please refer to the Installation Guide under:

https://service.sap.com/~sapidb/011000358700001414082012E

NOTE

Do not install the Oracle database software before you run the installer

Best Regards,

Alessandro Parolin

[former_member188883]

Hi Amal,

Please check whether you have a valid mount point /oracle/SID/112_64 incase your database version is Oracle 11g and it has right permission for read/write.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Dear Deepak;

I checked the mount point /oracle/SID/112_64 and it has read right permissions, but I am still getting the same error.

I am using Oracle 10.g

Best Regards

~Amal

[former_member206552]

Hi Amal,

during sapinst did you specify it correctly ?

you can also have a look at limits

It's seems that the issue  trigger by  ulimits parameters for oracle user ora<sid>.

The error message I got was:

OraDataFileCreateParams.checkParams: dataFileParams.sapdataDir is not

convertible to a positive integer and does not match

/^\sSAPDATA(\d+)\s$/gi.

ERROR 2011-03-01 19:40:25.97 [iaxxinscbk.cpp:244]

CJS-00030 Assertion failed: Component OraDbBuild: Context parameter

tDataFileInfo, row[13] does not describe valid data file parameters.

To fix this issue, You should have a look in the file /etc/security/limits, you must have for oracle user ora<sid> the definition below:

[...]

ora<sid>:

        fsize = -1

        data = -1

        stack = -1

        fsize_hard = -1

        cpu_hard = -1

        data_hard = -1

        stack_hard = -1

        core_hard = 2097151

[...]

If not, update the file. Then logout, after that login and restart your installation process.

source : http://scn.sap.com/thread/1178819

also make sure the env as the oraSID user is correct

Best Regards

Marius

[Former Member]

Amal

read right permissions is not enough

Check also ora<SID> user ulimit settings.

Regards

a

[former_member188883]

Hi Amal,

As your database is 10g your oracle database home should be /oracle/SID/102_64.

Check for the same. Incase missing create one.

Additionally please Check your oraInst.loc file (see note 350251), adapt it so that

inventory_loc=/oracle//oraInventory

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Amal

which orahome did you declared?

This thread should help you http://scn.sap.com/thread/2140649

a

[Former Member]

Dear Andrea;

ORACLE_HOME=/oracle/product/10.2/db_1

Best Regards

~Amal

[Former Member]

Hi Amal

ive lost the track ...

BTW you have to install your sw as Marius Burger said to /oracle/ZZZ/112_64 and so

ORACLE_HOME=/oracle/ZZZ/112_64

Regards

a