on 02-10-2010 5:02 AM
Dear all !
My OS : Linux RHEL 4U7 32bit
Oracle 10G R2 32bit 10.2.0.2
when system running but power off suddenly
and when power on ->
i am having problem as below when i start instance SAP (Databse Oracle Started)
Step 1 : I login user (ora<sid>) of Oracel to start up database
Database startup -> OK
then i tried to shutdown database -> OK too
and start up again -> OK
Query -> OK
I think Database do not problem
Step 2: start listener -> OK
Step 3: i login user (<sid>adm) and startup instance SAP (command : startsap r3) with error:
*******************************************************************************************
Checking SED Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
11:11:48 10.02.2010 LOG: Effective User Id is root
***********************************************************************
This is Saposcol Version COLL 20.90 700 - Intel x86 with Linux, PL:75, Aug 29 2006
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 6870) is already running .....
************************************************************************
saposcol already running
ABAP Database SED must be started first
********************************************************************************************
Please help me to resolve this problem
Thanks for your advice
Dear all
1. output listener.ora :
***********************************************************************************************************************************************************
listener.ora Network Configuration File: /oracle/SED/102_32/network/admin/listener.ora
Generated by Oracle configuration tools.
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/SED/102_32)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sapsed.fes.com.vn)(PORT = 1527))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
***********************************************************************************************************************************************************
2. output tnsname.ora:
***********************************************************************************************************************************************************
tnsnames.ora Network Configuration File: /oracle/SED/102_32/network/admin/tnsnames.ora
Generated by Oracle configuration tools.
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
SED.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapsed)(PORT = 1527))
)
(CONNECT_DATA =
(SID = SED)
(GLOBAL_NAME = SED.WORLD)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
***********************************************************************************************************************************************************
Attention : I noticed that all of the group sapinst -> converted -> group 501 (I do not know the cause because I do not convert them)
example :
-rw-r-x--- 1 root sapinst 4291 Jan 18 12:17 initSED.2.ora (previously)
-rw-r-x--- 1 root 501 4291 Jan 18 12:17 initSED.2.ora (presently)
thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/SED/102_32)
(PROGRAM = extproc)
what is a reason of keeping SID_NAME = PLSExrProc
it should SID_NAME = SED
Replace the above entry
then STOP database , Stop listner again start listner first then start database and run R3trans -d let us know what output come to re3trans command .
ouput should be return code 0
Thanks
Anil
Dear all
My problem was resolved following :
I copy content of listener.ora and tnsname.ora of another system and then i changed SID
I started isntance SAP -> OK
thanks so much to Anil and others helped me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear all !
1. output of tnsping SED :
***********************************************************************************************************************************************************
TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 11-FEB-2010 13:51:24
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/SED/102_32/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = sapsed)(PORT = 1527))) (CONNECT_DATA = (SID = SED) (GLOBAL_NAME = SED.WORLD)))
OK (0 msec)
***********************************************************************************************************************************************************
2. output startsap_.log
***********************************************************************************************************************************************************
Checking SED Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
saposcol already running
ABAP Database SED must be started first
**********************************************************************************************************************************************************
---> output above repeats many
3. output trans.log
*******************************************************************************************************************************************************
4 ETW000 R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 11.02.2010 - 13:49:36
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] Thu Feb 11 13:49:36 2010 159 0.000159
4 ETW000 [dev trc ,00000] db_con_init called 27 0.000186
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 55 0.000241
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SED/SYS/exe/run/dboraslib.so' ...
4 ETW000 63 0.000304
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/SED/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 16430 0.016734
4 ETW000 [dev trc ,00000] Library '/usr/sap/SED/SYS/exe/run/dboraslib.so' loaded
4 ETW000 56 0.016790
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so
4 ETW000 41 0.016831
4 ETW000 [dev trc ,00000] Version of '/usr/sap/SED/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.73)
4 ETW000 94 0.016925
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so
4 ETW000 38 0.016963
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/SED/SYS/exe/run/dboraslib.so
4 ETW000 68 0.017031
4 ETW000 [dev trc ,00000] New connection 0 created 44 0.017075
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 46 0.017121
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 38 0.017159
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 37 0.017196
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 39 0.017235
4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 480 0.017715
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 42 0.017757
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3789 0.021546
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 48 0.021594
4 ETW000 [dev trc ,00000] Connecting as /@SED on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 51 0.021645
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 43 0.021688
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9511ea0 0x951750c 0x9516d94
4 ETW000 40 0.021728
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 40 0.021768
4 ETW000 [dev trc ,00000] Allocating server context handle 52 0.021820
4 ETW000 [dev trc ,00000] Attaching to DB Server SED (con_hdl=0,svchp=0x9516d20,svrhp=0x9528504)
4 ETW000 88 0.021908
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
4 ETW000 4712 0.026620
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12505'
4 ETW000 49 0.026669
4 ETW000 [dev trc ,00000] Try to connect with default password 62 0.026731
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@SED on connection 0 (nls_hdl 0) ... (dbsl 700 110706)
4 ETW000 39 0.026770
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 56 0.026826
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9511ea0 0x951750c 0x9516d94
4 ETW000 47 0.026873
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x9528504)
4 ETW000 37 0.026910
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x9516d20,srvhp=0x9528504)
4 ETW000 37 0.026947
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x9528504 45 0.026992
4 ETW000 [dev trc ,00000] Allocating server context handle 48 0.027040
4 ETW000 [dev trc ,00000] Attaching to DB Server SED (con_hdl=0,svchp=0x9516d20,svrhp=0x9528504)
4 ETW000 60 0.027100
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
4 ETW000 1538 0.028638
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12505'
4 ETW000 41 0.028679
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12505 performing CON [dblink#3 @ 431]
4 ETW000 131 0.028810
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12505: TNS:listener does not currently know of SID given in connect descriptor [dblink#3 @ 431]
4 ETW000 39 0.028849
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SED'"
*******************************************************************************************************************************************************
thansk for your help
Edited by: myfriend280985 on Feb 11, 2010 7:53 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You are already out of the oracle client error , you are getting know some different error
ETW000 88 0.021908
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12505
4 ETW000 4712 0.026620
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12505'
paste the content of tnsname.ora and listner.ora in forum.
Thanks
Anil
hi Anil
output:
*********************************************************************************************************************************************************
TERM=vt100
HOME=/home/sedadm
SHELL=/bin/csh
USER=sedadm
LOGNAME=sedadm
PATH=/oracle/SED/102_32/bin:/usr/java/j2sdk1.4.2_12/bin:.:/home/sedadm:/usr/sap/SED/SYS/exe/run:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
HOSTTYPE=i386-linux
VENDOR=intel
OSTYPE=linux
MACHTYPE=i386
SHLVL=1
PWD=/home/sedadm
GROUP=sapsys
HOST=sapsed
REMOTEHOST=10.86.254.202
MAIL=/var/spool/mail/sedadm
HOSTNAME=sapsed
INPUTRC=/etc/inputrc
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:.cmd=01;32:.exe=01;32:.com=01;32:.btm=01;32:.bat=01;32:.sh=01;32:.csh=01;32:.tar=01;31:.tgz=01;31:.arj=01;31:.taz=01;31:.lzh=01;31:.zip=01;31:.z=01;31:.Z=01;31:.gz=01;31:.bz2=01;31:.bz=01;31:.tz=01;31:.rpm=01;31:.cpio=01;31:.jpg=01;35:.gif=01;35:.bmp=01;35:.xbm=01;35:.xpm=01;35:.png=01;35:.tif=01;35:
G_BROKEN_FILENAMES=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
KDEDIR=/usr
LANG=en_US.UTF-8
SUPPORTED=en_US.UTF-8:en_US:en
LESSOPEN=|/usr/bin/lesspipe.sh %s
SAPSYSTEMNAME=SED
DIR_LIBRARY=/usr/sap/SED/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/SED/SYS/exe/run:/oracle/client/10x_32/instantclient
JAVA_HOME=/usr/java/j2sdk1.4.2_12
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=SED
dbs_ora_schema=SAPSR3
ORACLE_SID=SED
DB_SID=SED
ORACLE_BASE=/oracle
TNS_ADMIN=/usr/sap/SED/SYS/profile/oracle
ORACLE_HOME=/oracle/SED/102_32
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/SED
*******************************************************************************************************************************************************
thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Eviornment variable are looking fine..
Can you also post trans.log and all startsap_.log file from home directory of SIDADM user.
Also post out put of tnsping SED
One more thing you can do, if you have backup of Kernel (SAR files), re-upgrade it... or Upgrade it with latest version..
At least R3Tools...
(I guess there may be some problem with kernel/R3tools because of sudden power down...)
Regards.
Edited by: Rajesh Narkhede on Feb 11, 2010 12:15 PM
Edited by: Rajesh Narkhede on Feb 11, 2010 12:16 PM
Dear Rajesh Narkhede and Anil Bhandary
i am having more information after i did anythings below:
1. @ Rajesh
I did your comments
2. @ Anil
I type command ls -ltr and check softlink created for instantclient -> softlink not lose but I did to follow you
and outout command of R3trans -d below :
sapsed:sedadm 1> R3trans -d
This is R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SED'"
R3trans finished (0012).
output command of ldd `which dboraslib.so`| grep libclnt below :
sapsed:orased 1> ldd `which dboraslib.so`| grep libclnt
libclntsh.so.10.1 => /oracle/SED/102_32/lib/libclntsh.so.10.1 (0x00f38000)
But error remain
thanks for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear all
output of commands following :
1. What is the output of this in Linux, as root user:
find / -name libclntsh.so.10.1
---> [root@sapsed ~]# find / -name libclntsh.so.10.1
/oracle/SED/102_32/lib/libclntsh.so.10.1
/oracle/client/10x_32/instantclient_10202/libclntsh.so.10.1
2. What is the output of this in Linux, as <sid>adm user:
ldd `which dboraslib.so`| grep libclnt
---> [root@sapsed ~]# su - sedadm
sapsed:sedadm 1> ldd `which dboraslib.so`| grep libclnt
libclntsh.so.10.1 => not found
maybe this problem !!!
thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It seems that there is some linking problem for "libclntsh.so.10.1"...
Just log in as ora<SID>
go to $ORACLE_HOME/bin directory
give #relink all command
It will resolve any linking problem or oracle binaries...
then stop all (listner, database, sap, etc ) and start it again with sequence LISTENER, DATABASE, SAP...
Regards.
Rajesh Narkhede
Hi,
---> root@sapsed ~# find / -name libclntsh.so.10.1
/oracle/SED/102_32/lib/libclntsh.so.10.1
/oracle/client/10x_32/instantclient_10202/libclntsh.so.10.1
2. What is the output of this in Linux, as <sid>adm user:
ldd `which dboraslib.so`| grep libclnt
---> root@sapsed ~# su - sedadm
sapsed:sedadm 1> ldd `which dboraslib.so`| grep libclnt
libclntsh.so.10.1 => not found
just to resolve your problem you can do the following steps
1. login to OS with orased
2. goto folder /oracle/client/10x_32
cd /oracle/client/10x_32
3. give command ls -ltr and check is there softlink created for instantclient , if there is no softlink then create the softlink as below
4. give the command as below
ln -s /oracle/client/10x_64/instantclient_10202 instantclient
5. check again the softlink is created or not , it should be look as below
instantclient -> /oracle/client/10x_64/instantclient_10202
6. now agin the check the command as gaurav provided earlier
ldd `which dboraslib.so`| grep libclnt
if it shows the proper out , then R3trans -d should work now
Other wise the best option is to RELINK the oracle binaries as said y RAJESH
Thanks
Anil
Edited by: Anil Bhandary on Feb 11, 2010 5:47 AM
There seems to be a problem with file libclntsh.so.10.1
What is the output of this in Linux, as root user:
find / -name libclntsh.so.10.1
And expanding on Gaurav 's idea (I hadn't thought of ldd command):
What is the output of this in Linux, as <sid>adm user:
ldd `which dboraslib.so`| grep libclnt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear all!
I did anythings in Note of Anil but can't not start instance SAP
thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
One thing you can check...
Please backup your /sapmnt/<SID>/profile/oracle directory...
and copy sqlnet.ora, tnsnames.ora files from /oracle/<SID>/102_64/network/admin to /sapmnt/<SID>/profile/oracle
The try it should work...
Actually files from the both location should be identical..
Regards.
Rajesh Narkhede
Dear all !
I checked at operating system level 5
All file systems properly mounted -> Yes
File /usr/sap/SED/SYS/exe/run/dboraslib.so existing -> Yes
Please help me
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear !
i don't change any in /sapmnt/<SID>/exe and others
when system running but power off suddenly
and when power on -> error
I don't use storage
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
when system running but power off suddenly
and when power on -> error
In case of a sudden power off, you may have lost some files or mount points.
This happens hardly ever, but it does happen sometimes.
Did you check at operating system level?
All file systems properly mounted?
File /usr/sap/SED/SYS/exe/run/dboraslib.so existing?
Dear all!
More extra information :
logs trans.log file
***********************************************************************************************************************************************************
sapsed:sedadm 6> cat trans.log
4 ETW000 /sapmnt/SED/exe/R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 10.02.2010 - 15:25:51
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: /sapmnt/SED/exe/R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Wed Feb 10 15:25:51 2010 160 0.000160
4 ETW000 [dev trc ,00000] db_con_init called 28 0.000188
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 54 0.000242
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SED/SYS/exe/run/dboraslib.so' ...
4 ETW000 64 0.000306
4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= libclntsh.so.10.1: cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)
4 ETW000 521 0.000827
4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SED/SYS/exe/run/dboraslib.so'
4 ETW000 45 0.000872
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SED/SYS/exe/run') or dbms_type ('ORA')"
*******************************************************************************************************************************************************
Thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear all
1. logs in dev_w0 file :
***********************************************************************************************************************************************************
M Mon Feb 8 14:50:25 2010
M *** WARNING => ThSndDelUser: delete client/user 001/THUYNTT (T21) on server sapsed_SED_00
A
A Tue Feb 9 01:01:42 2010
A generated report /1BCF41/TVBUR with fingerprint DE242C52C7D4C5E3BA15E33C1DACA942| 19389
A
A Tue Feb 9 01:04:29 2010
A generated report SAPLWR22 with fingerprint 29FEBE593B0E9B336D237F2372D2737B| 334343
A
A Tue Feb 9 01:15:21 2010
A generated report SAPLSPROJECT_SOLAR_BASIS with fingerprint 5D513EF9B44B2B54C20F800CDC13862C| 25503
A
A Tue Feb 9 01:16:29 2010
A generated report PCA_TP_FIND with fingerprint A1135F2B8B458780F9FCEFC0E0AAB613| 150491
A
A Tue Feb 9 01:16:37 2010
A generated report %_CGSTC with fingerprint 0FE0BE95B30588F6093A9E326DA8C64F| 6139
A generated report SAPLPCA_SD with fingerprint EB573F780694FE352ECB3C162968BA9B| 18232
A
A Tue Feb 9 01:16:38 2010
A generated report SAPLPCA_TPVAR with fingerprint 94C32444EE6435B18C5ABC5A7E88CBE1| 13820
A
A Tue Feb 9 14:01:04 2010
A generated report SAPLKAPS with fingerprint 4BF4F7B8EF5F62C200D1989D75775C7A| 21814
A
A Tue Feb 9 14:01:11 2010
A generated report SAPLKALL with fingerprint 64BF7719421A90917D38DEE90FEFA77A| 76530
X
X Tue Feb 9 14:13:21 2010
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
X
X Tue Feb 9 14:13:22 2010
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
X
X Tue Feb 9 14:13:23 2010
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
X
X Tue Feb 9 14:15:02 2010
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
X
X Tue Feb 9 14:15:10 2010
X <EsMap> EsMapSearchAlloc: No more free Extended Memory Slots 0/1 rc=1
A
A Tue Feb 9 15:26:02 2010
A generated report /1BCF41/TVPT with fingerprint 59DB37C5D9459C6510C10DF54CD7C7A1| 15909
A
A Tue Feb 9 15:31:30 2010
A generated report /1BCF41/T087G with fingerprint 8F1ED0BA04D126653333B29C7992ACFF| 15685
A
A Tue Feb 9 16:20:53 2010
A Negative refCount for object x SAPLSDIFRUNTIME .
A Negative refCount for object v DD05M .
A Negative refCount for object x SAPLSDTB .
A Negative refCount for object v DDFTX .
A Negative refCount for object x SAPLSENA .
A Negative refCount for object x CL_GUI_CONTAINER==============CP .
***********************************************************************************************************************************************************
2. Output command R3trans -d
*******************************************************************************************************************************************************
This is /sapmnt/SED/exe/R3trans version 6.14 (release 700 - 18.09.06 - 09:35:00).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SED/SYS/exe/run') or dbms_type ('ORA')"
/sapmnt/SED/exe/R3trans finished (0012).
*******************************************************************************************************************************************************
Thanks for your advice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear all!
my database running -> OK
Step 1: I login user ora<sid> and start database following:
ora<sid> # sqlplus / as sysdba
sql > startup; -> OK (database Open)
and then I tried to shutdown databse with command
sql > shutdown immediate -> OK
my database do not at Mount mode
Step 2: start listener -> OK
Step 3: start instance SAP -> with error
I don't find dev_w0 log, where ? please show me path
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
goto to following path /usr/sap/<SID>/DVEBMGS<NN>/work/
AS well can u check the below command
R3trans -d
check the ouput , if you get the error for above command then paste the error present in trans.log file.
file will in the location from where you have run the above command
Thanks
Anil
Edited by: Anil Bhandary on Feb 10, 2010 8:20 AM
Hi,
As BABU said check your database status.
it might be sudden restart of your OS , you database may have gone in recovery mode.
If your database is in recovery mode , the startup command provided by BABU will make instant recover of your database.
once database is started you can start you SAP , using startsap command.
Thanks
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
From the error log understand that SED is your SID. Please check if the database is completely open or in mount state.
Also, check the error log in dev_w0 and paste the log here. Before that, please start the database manually and see if it is completely opening the database or only up to mount state.
To shutdown the database
sqlplus /nolog
conn / as sysdba
Shutdown Immediate
To start the database
Sqlplus /nolog
conn / as sysdba
Startup
See if it says database opened and then you start the SAP. Even then any issue comes up then check the log in dev_W0 abd paste it here.
Thanks & Regards,
Sharath Babu M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.