on 12-10-2015 7:16 AM
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
Hi Jithin,
Could you share log file sapinst_ora_environment.log,as the issue could be related with the wrong environment variable value .
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jithin,
Check the controlfile folder. if missing create the folder for controlfile.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.