on 07-04-2012 7:53 AM
Dear,
I am getting following issue when I execute stopsap all.
ABAP Database is not available via R3trans
while trans.log is not updating when i run R3trans -x.
please check the permission and guide me.
saplinux:lnxadm 14> ls -lrt /home/lnxadm/*
-rwxrwxr-x 1 lnxadm sapsys 25 May 18 2007 /home/lnxadm/rfcexec.sec
-rwxrwxr-x 1 lnxadm sapsys 1552 Jul 3 12:15 /home/lnxadm/trans.log
-rwxrwxr-x 1 lnxadm sapsys 1428 Jul 3 16:39 /home/lnxadm/dev_sapstart
-rwxrwxr-x 1 lnxadm sapsys 29907 Jul 4 11:51 /home/lnxadm/startsap_.log
-rwxrwxr-x 1 lnxadm sapsys 2861 Jul 4 11:51 /home/lnxadm/startdb.log
-rwxrwxr-x 1 lnxadm sapsys 5596 Jul 4 11:52 /home/lnxadm/stopsap_.log
-rwxrwxr-x 1 lnxadm sapsys 3380 Jul 4 11:53 /home/lnxadm/startsap_DVEBMGS00.log
-rwxrwxr-x 1 lnxadm sapsys 1301 Jul 4 11:53 /home/lnxadm/stopdb.log
-rwxrwxr-x 1 lnxadm sapsys 460 Jul 4 11:53 /home/lnxadm/stopsap_DVEBMGS00.log
Regards,
Hello Ma Jamil,
- delete /home/lnxadm/trans.log and run 'R3trans -d'
- attach trans.log and stopsap_DVEBMGS00.log
Best regards,
Adam Csaba Goetz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Adam,
fyi... I can login but getting following issues.
- delete /home/lnxadm/trans.log and run 'R3trans -d'
[root@saplinux ~]# rm /home/lnxadm/trans.log
trans.log is deleted.
- attach trans.log and stopsap_DVEBMGS00.log
please find attached log files.
Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /home/lnxadm/startsap_DVEBMGS00.log
/usr/sap/LNX/SYS/exe/run/startsap: line 1733: cd: /root: Permission denied
why I am getting Permission denied issue.
Regards,
Hello Ma Jami,
R3trans gets SQL error 12541 while connecting to database. Refer to SAP note 609332 and check the configuration. You shold also:
- Stop the listener and start it with oralnx user 'lsnrctl start'
- Check the connection with 'R3trans -d'
Best regards,
Adam Csaba Goetz
Hallo,
if you changed the hostname, have you also adjusted the hostname in the SAP profiles in /sapmnt/SID/profile?
Regards,
Thomas.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The sap is started I believe , and you have upgraded the oracle client when it was running I believe.
Stop the sap system . stopsap r3
then cleanipc <instance_number> remove.
Then stop the oracle and listener. (sql> shutdown immediate)
Start the oracle and the listener.(sql> startup)
Start the sap . startsap r3
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Ratnajit,
I did follow your steps but still facing same issue
Checking LNX Database
------------------------------
ABAP Database is running
Stopping the SAP instance DVEBMGS00
----------------------------------
Shutdown-Log is written to /home/lnxadm/stopsap_DVEBMGS00.log
Instance on host saplinux stopped
Waiting for cleanup of resources............
Running /usr/sap/LNX/SYS/exe/run/stopdb
Trying to stop LNX database ...
Log file: /home/lnxadm/stopdb.log
LNX database stopped
/usr/sap/LNX/SYS/exe/run/stopdb completed successfully
Checking LNX Database
------------------------------
ABAP Database is not available via R3trans (why DB is not available via R3trans)
when i start listener via lsnrctl start then getting below issue.
Instance "LNX", status UNKNOWN, has 2 handler(s) for this service...
Regards,
hi Ratnajid,
tnsnames.ora
saplinux:lnxadm 6> cat tnsnames.ora
################
# 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 $
################
LNX.WORLD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = saplinux)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = LNX)
(GLOBAL_NAME = LNX.WORLD)
)
)
Listener.ora
# 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 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = LNX.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = LNX)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = saplinux)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = LNX)
(ORACLE_HOME = /oracle/LNX/102_64)
)
(SID_DESC =
(SID_NAME = LNX)
(ORACLE_HOME = /oracle/LNX/102_64)
)
)
Regards,
saplinux:lnxadm 20> tnsping LNX
TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 04-JUL-2012 14:18:07
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/usr/sap/LNX/SYS/profile/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = saplinux) (PORT = 1527))) (CONNECT_DATA = (SID = LNX) (GLOBAL_NAME = LNX.WORLD)))
OK (0 msec)
Regards
hi Roman,
the out of stopsap_.log
Checking LNX Database
------------------------------
ABAP Database is not available via R3trans
Checking LNX Database
------------------------------
ABAP Database is running
Checking LNX Database
------------------------------
ABAP Database is running
Checking LNX Database
------------------------------
ABAP Database is running
... sqlplus startup and shutdown commands are working find.
Regards,
hi Roman,
saplinux:lnxadm 3> stopsap db
Checking LNX Database
ABAP Database is running
/usr/sap/LNX/SYS/exe/run/stopdb completed successfully
Checking LNX Database
ABAP Database is not available via R3trans
saplinux:lnxadm 4> stopsap r3
ABAP Database is not available via R3trans
Stopping the SAP instance DVEBMGS00
Shutdown-Log is written to /home/lnxadm/stopsap_DVEBMGS00.log
Instance DVEBMGS00 was not running!
Shutdown of instance failed
please find attached logs of stopsap and stopdb.
Regards,
Message was edited by: ma jamil
Dear Roman,
yes, i knew now system is running fine but why I am getting below issues like.
1. ABAP Database is not available via R3trans
2. Instance "LNX", status UNKNOWN, has 2 handler(s) for this service..
3. /usr/sap/LNX/SYS/exe/run/startsap: line 1733: cd: /root: Permission denied
please explain.
fyi...
, I just started learning about SAP on linux a week ago mean I am beginner.
Regards,
1. ABAP Database is not available via R3trans
In you situation this is not issue. During execution startdb/stopdb status of database is checked (before and after action performed).
Checking LNX Database
------------------------------
ABAP Database is running - DB is running All OK
Stopping the SAP instance DVEBMGS00
----------------------------------
Shutdown-Log is written to /home/lnxadm/stopsap_DVEBMGS00.log
Instance on host saplinux stopped
Waiting for cleanup of resources............
Running /usr/sap/LNX/SYS/exe/run/stopdb - Shutdown DB
Trying to stop LNX database ...
Log file: /home/lnxadm/stopdb.log
LNX database stopped
/usr/sap/LNX/SYS/exe/run/stopdb completed successfully - All OK
Checking LNX Database
------------------------------
ABAP Database is not available via R3trans - DB is not available because it was stopped before
2. Instance "LNX", status UNKNOWN, has 2 handler(s) for this service..
An UNKNOWN
status means that the instance is registered statically in the listener.ora file rather than dynamically with service registration. Therefore, the status is not known. This is also not issue.
About 2 handlers try to execute command lsnrctl services. This is also not issue.
3. /usr/sap/LNX/SYS/exe/run/startsap: line 1733: cd: /root: Permission denied
Please paste full log to explain this error. Paste startsap script also. I think the cause of the problem is su <sid>adm (missing -) instead of su - <sid>adm
Regards
Roman
I suggest you upgrade the kernel . There seems to be an issue with stopsap script .
Also ,modify the listener.ora as below after stopping it
********************************************************************
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = LNX.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = LNX)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = saplinux)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = LNX)
(ORACLE_HOME = /oracle/LNX/102_64)
)
)
********************************************************************
Regards
Ratnajit
Check trans.log in current work directory. This is not necessarily the home directory of <sid>adm user
Regards
Roman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.