cancel
Showing results for 
Search instead for 
Did you mean: 

ABAP Database is not available via R3trans

former_member182034
Active Contributor
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

csaba_goetz
Contributor
0 Kudos

Hello Ma Jamil,

- delete /home/lnxadm/trans.log and  run 'R3trans -d'

- attach trans.log and stopsap_DVEBMGS00.log

Best regards,

Adam Csaba Goetz

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

check status of oracle listener

Regards

Roman

csaba_goetz
Contributor
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

sorry adam,

this is old log, this log created when I tried to start sap without starting the listener.

anyways.... now system running after start the listener but still facing R3trans issue.

plz check my reply which i snt to Ratnajit

Regerds,

Answers (3)

Answers (3)

Former Member
0 Kudos

Hallo,

if you changed the hostname, have you also adjusted the hostname in the SAP profiles in /sapmnt/SID/profile?

Regards,

Thomas.

former_member189725
Active Contributor
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

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,

former_member189725
Active Contributor
0 Kudos

Please paste the tnsnames.ora from /sapmnt/LNX/profile/oracle and also the listener.ora file from /oracle/LNX/102_64/network/admin

Check the ports in the 2 files and also check the listener name.

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

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,


Former Member
0 Kudos

paste output from tnsping LNX

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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

Former Member
0 Kudos

try to start your SAP system

Regards

Roman

former_member182034
Active Contributor
0 Kudos

hi Roman,

no issue with startsap all

I m getting following when i stop sap with stopsap all

ABAP Database is not available via R3trans

Regards,

former_member189725
Active Contributor
0 Kudos

Can you please copy the stopsap script from other system where it is running fine.

Regards

Ratnajit

Former Member
0 Kudos

Please paste output from stopsap command. I'm sure you have everything working well

Regards

Roman

csaba_goetz
Contributor
0 Kudos

Hello Ma Jami,

Set TRACE environment variable to 1 for lnxadm (setenv TRACE 1) and execute stopsap all. Attach /home/lnxadm/stopsap.trc to the message.

Best regards,

Adam Csaba Goetz

former_member182034
Active Contributor
0 Kudos

hi Ratnajit and Roman,

please find attached stopsap file

Regards,

former_member182034
Active Contributor
0 Kudos

hi Adam,

Please find attached trace of stopsap.


Former Member
0 Kudos

Please paste output from stopsap command. I'm sure you have everything working well. In last check it only verifies that the database was shutdown successfully

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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,


Former Member
0 Kudos

Please start the system and then stop it. Paste the output of command stopsap and stopdb.log file

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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

Former Member
0 Kudos

You have no problems with connect to db. But you need to stop r3 before db. You may also stop SAP system with stopsap command

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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,


Former Member
0 Kudos

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

former_member189725
Active Contributor
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

hi Ratnajit,

I upgraded kernel patch from 278 to 291 but still facing same issue..

ABAP Database is not available via R3trans

and also modified the Listener.ora file but still

regards,

former_member189725
Active Contributor
0 Kudos

have you installed the SAP system with virtual hostname ?

Regards

Ratnajit

former_member182034
Active Contributor
0 Kudos

Dear,

I changed the computer name (saplinux) before installation.

mean I did not installed with virtual hostname.

Regards,

Former Member
0 Kudos

Check trans.log in current work directory. This is not necessarily the home directory of <sid>adm user

Regards

Roman