cancel
Showing results for 
Search instead for 
Did you mean: 

SAP installation failing on phase create database.

former_member186228
Active Participant
0 Kudos

Hi,

We are installing SAP on Red hat 6.1 and our database is Oracle 11.2.0.3. Installation is getting stuck on phase create database. While checking log found that oracle database not starting. Alert log getting below error,

****************** Large Pages Information *****************

Parameter use_large_pages = auto

Total Shared Global Region in Large Pages = 318 MB (100%)

Large Pages used by this instance: 159 (318 MB)

Large Pages unused system wide = 0 (0 KB) (alloc incr 4096 KB)

Large Pages configured system wide = 159 (318 MB)

Large Page size = 2048 KB

Time taken to allocate Large Pages = 0.000000 sec

***********************************************************

Huge page setting is  as follow,

[root@testosmig trace]# grep Huge /proc/meminfo

AnonHugePages:     43008 kB

HugePages_Total:     159

HugePages_Free:       89

HugePages_Rsvd:       89

HugePages_Surp:        0

Hugepagesize:       2048 kB

Please suggest how to proceed

Regards,

Jithin

Accepted Solutions (0)

Answers (6)

Answers (6)

former_member182657
Active Contributor
0 Kudos

Hi Jithin,

Could you share log file sapinst_ora_environment.log,as the issue could be related with the wrong environment variable value .

Regards,

former_member186228
Active Participant
0 Kudos

Hi Gaurav,

Below is the Value..

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[root@testosmig AS-ABAP]# cat sapinst_ora_environment.log

2015-12-10, 00:12:26 SAPINST Current process environment:

COLORTERM=gnome-terminal

CVS_RSH=ssh

DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-R1NgUHR2wX,guid=d3aca20d053e0234fc01b2e900000049

DISPLAY=192.168.2.67:1.0

GNOME_DESKTOP_SESSION_ID=this-is-deprecated

GNOME_KEYRING_SOCKET=/tmp/keyring-hH6Irs/socket

GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2

G_BROKEN_FILENAMES=1

HISTCONTROL=ignoredups

HISTSIZE=1000

HOME=/root

HOSTNAME=testosmig

JAVA_HOME=/opt/IBMJava2-amd64-142

KDEDIRS=/usr

KDE_IS_PRELINKED=1

LANG=en_US.UTF-8

LD_LIBRARY_PATH=/tmp/sapinst_exe.2524.1449686454/jre/lib/amd64/server::/tmp/sapinst_exe.2524.1449686454/jre/lib/amd64::/tmp/sapinst_exe.2524.1449686454

LESSOPEN=|/usr/bin/lesspipe.sh %s

LOGNAME=root

LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:

MAIL=/var/spool/mail/root

ORBIT_SOCKETDIR=/tmp/orbit-root

PATH=/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/opt/IBMJava2-amd64-142/bin:/root/bin:/opt/IBMJava2-amd64-142/bin:/root/bin

PWD=/dump/70PM_LINUX_X86_x64

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

QTLIB=/usr/lib64/qt-3.3/lib

REMOTEHOST=192.168.2.67

SAPINST_EXEDIR_CD=/dump/70PM_LINUX_X86_x64/.

SAPINST_EXE_DIR=/tmp/sapinst_exe.2524.1449686454

SAPINST_JRE_HOME=/tmp/sapinst_exe.2524.1449686454/jre

SELFEXTRACTOR_EXECUTABLE_NAME=/dump/70PM_LINUX_X86_x64/./sapinst

SESSION_MANAGER=local/unix:@/tmp/.ICE-unix/1987,unix/unix:/tmp/.ICE-unix/1987

SHELL=/bin/bash

SHLVL=2

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SSH_AUTH_SOCK=/tmp/keyring-hH6Irs/socket.ssh

SYSLIB_SWITCH_ONLY_EFFECTIVE_ACCOUNT=FALSE

TERM=xterm

USER=root

WINDOWID=62914564

SAPINST: End of current process environment.

Further environment variables that where set (possibly overwriting the previous ones):

ORACLE_HOME=/oracle/DEV/112_64

ORACLE_SID=DEV

SAPINST: End of environment log.

[root@testosmig AS-ABAP]#

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Regards

Jithin

Former Member
0 Kudos

Jithin,

If anything goes wrong doing the startup there should be process traces in the background dump directory. The path is normally something like /oracle/SID/saptrace/diag/rdbms/sid/SID/trace. Can you find any files there with suffix '.trc'? Also, what is in the alert_SID.log?

Mark

former_member215439
Participant
0 Kudos

Hi Jithin,

     Check the controlfile folder. if missing create the folder for controlfile.

former_member186228
Active Participant
0 Kudos

Hi, James,

Control File folder is already exist in the respective location.

Regards,

Jithin

former_member215439
Participant
0 Kudos

Hi,

     Just to confirm, you're doing a system copy?

former_member186228
Active Participant
0 Kudos

Hi,

Yes James,

former_member182657
Active Contributor
0 Kudos

Hi,

If possible try to restart the system to execute again & share sapinst_dev.log file ? In addition share the value for parameter ORACLE_HOME .

Regards,

former_member186228
Active Participant
0 Kudos

Hi Gaurav,

We have restarted the system and tried but still  database not starting.

ORACLE_HOME=/oracle/DEV/112_64

Please find sapinst_dev.log

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

TRACE      2015-12-10 00:12:22.171 (root/sapinst) [iaxobsqlex.cpp:630] COraSQLExecute::executeSQLStatement_impl(...)

Temporary SQL script file: <ora_stmt_scr_tmp.sql>

TRACE      2015-12-10 00:12:22.173 (root/sapinst) [syuxcuser.cpp:2006] bool CSyUserImpl::isExistingOnOS()

checking existence of account user="devadm" uid="502" succeeded with true.

TRACE      2015-12-10 00:12:22.173 (root/sapinst) [syxxccache.cpp:419] CSyAccountCache::addToCache(const IaPtr<CSyAccountImpl> account)

inserted account (devadm, 502, USER) into the accountcache.

TRACE      2015-12-10 00:12:22.173 (root/sapinst) [syuxcgroup.cpp:764] bool CSyUserImpl::isExistingOnOS()

checking existence of account group="dba" gid="505" succeeded with true.

TRACE      2015-12-10 00:12:22.173 (root/sapinst) [syxxccache.cpp:419] CSyAccountCache::addToCache(const IaPtr<CSyAccountImpl> account)

inserted account (dba, 505, GROUP) into the accountcache.

TRACE      2015-12-10 00:12:22.174 (root/sapinst) [iaxohsqlx.hpp:933] COraSQLScriptExec<LoggingStrategy>::prepareTemporaryScript

Temporary SQL script file: <ora_scr_tmp.sql>

TRACE      2015-12-10 00:12:22.174 (root/sapinst) [syuxcuser.cpp:612] PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

account user="devadm" uid="502" exists with parameter gid="504"

TRACE      2015-12-10 00:12:22.174 (root/sapinst) [syuxcgroup.cpp:764] bool CSyUserImpl::isExistingOnOS()

checking existence of account group="sapsys" gid="504" succeeded with true.

TRACE      2015-12-10 00:12:22.174 (root/sapinst) [syxxccache.cpp:419] CSyAccountCache::addToCache(const IaPtr<CSyAccountImpl> account)

inserted account (sapsys, 504, GROUP) into the accountcache.

TRACE      2015-12-10 00:12:22.175 (root/sapinst) [syuxcuser.cpp:612] PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

account user="devadm" uid="502" exists with parameter gid="504"

TRACE      2015-12-10 00:12:22.175 (root/sapinst) [syuxcuser.cpp:612] PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

account user="devadm" uid="502" exists with parameter gid="504"

TRACE      2015-12-10 00:12:22.175 (root/sapinst) [syuxcuser.cpp:612] PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

account user="devadm" uid="502" exists with parameter gid="504"

TRACE      2015-12-10 00:12:22.184 (root/sapinst) [syuxctask.cpp:229] CChildApplicationImpl::doStart()

A child process has been started. Pid = 2669

TRACE      2015-12-10 00:12:26.450 (root/sapinst) [syuxctask.cpp:539] CUnixProcessManager::sap_waitpid()

Child process 2669 returned 0

TRACE      2015-12-10 00:12:26.450 (root/sapinst) [iaxohsqlx.hpp:842] COraSQLScriptExec<LoggingStrategy>::executeScript()

Executable started and waited successfully. Return code = 0

TRACE      2015-12-10 00:12:26.450 (root/sapinst) [iaxohsqlx.hpp:855] COraSQLScriptExec<LoggingStrategy>::executeScript()

COraSQLScriptExec<LoggingStrategy>::executeScript: Script executed with error message.

TRACE      2015-12-10 00:12:26.470 (root/sapinst)

OraSqlStatement3.execute: Result of SQL:

{errorMessage: "ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\nDisconnected\n", executionWasSuccessful: false}

TRACE      2015-12-10 00:12:26.472 (root/sapinst)

OraSqlStatement3.execute: Going to execute 'STARTUP NOMOUNT'

TRACE      2015-12-10 00:12:26.473 (root/sapinst)

_objectContainsFunction: found function checkValid

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Regards

Jithin

Former Member
0 Kudos

Somewhat off-topic but still worth mentioning: 11.2.0.3 is out of support since the end of August. If you want continued support at no extra charge for an Oracle 11 installation (until May 2017) you must install 11.2.0.4 - see note 2098528.

Mark

former_member186228
Active Participant
0 Kudos

Hi Mark,

This is a sandbox system.

Regards,

Jithin

Former Member
0 Kudos

Hi,

I can't actually see an error in your alert log extract. Can you post the last part of the file ora_sql_results.log in the installation directory?

Regards,

Mark

former_member186228
Active Participant
0 Kudos

Hi Mark,

Please find the output of ora_sql_result.log.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 12:39:45 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Disconnected

SAPINST: End of output of SQL executing program /oracle/DEV/112_64/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-12-09, 12:39:47 SAPINST ORACLE stop logging

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

2015-12-09, 12:39:48 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 12:39:48 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

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

2015-12-09, 12:57:55 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 12:57:57 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Disconnected

SAPINST: End of output of SQL executing program /oracle/DEV/112_64/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-12-09, 12:58:00 SAPINST ORACLE stop logging

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

2015-12-09, 12:58:00 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 12:58:00 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

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

2015-12-09, 15:06:39 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 15:06:41 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Disconnected

SAPINST: End of output of SQL executing program /oracle/DEV/112_64/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-12-09, 15:06:43 SAPINST ORACLE stop logging

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

2015-12-09, 15:06:44 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 9 15:06:44 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

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

2015-12-10, 00:12:22 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 10 00:12:23 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Disconnected

SAPINST: End of output of SQL executing program /oracle/DEV/112_64/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-12-10, 00:12:26 SAPINST ORACLE stop logging

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

2015-12-10, 00:12:26 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 10 00:12:26 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

It is hanging here.

We also tried to start database (nomount) from sqlplus. But it is not starting.

Regards,

Jithin M

Former Member
0 Kudos

Jithin,

Let's start with the simple things: make absolutely certain that ORACLE_SID and especially ORACLE_HOME are set correctly in the environment of the user who attempts to start up the Oracle instance (in SAPINST context normally the <sid>adm), i.e.: ORACLE_HOME points to the symbolic link "112_64" and not to "11203", no trailing slash in the path, etc.

Regards,

Mark

former_member186228
Active Participant
0 Kudos

Hi Mark,

ORACLE_HOME is point to correct location "/oracle/DEV/112_64.