cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

R3trans -d error

Former Member

on ‎04-23-2016 8:50 PM

0 Kudos

Hi Friends,

i have upgraded my system from 11.2.0.4 to 12.1.0.2.0, I have already upgraded my KERNEL (721_EXT to patch 600), brtools (7.40), have done part of SSFS configuration as well till the time is asks me to check the output of R3trans -d. My database and listener is up and running. I am getting the below error:

sb54:orambd 4> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 14:36:44 2016

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4412407808 bytes

Fixed Size    2955064 bytes

Variable Size 1459620040 bytes

Database Buffers 2936012800 bytes

Redo Buffers   13819904 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

sb54:orambd 5> lsnrctl start LISTENER_MOB

LSNRCTL for HPUX: Version 12.1.0.2.0 - Production on 23-APR-2016 14:37:14

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /oracle/MBD/12102/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 12.1.0.2.0 - Production

System parameter file is /oracle/MBD/12102/network/admin/listener.ora

Log messages written to /oracle/MBD/diag/tnslsnr/sb54/listener_mob/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MBD.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MBD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sb54.shure.com)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=MBD.WORLD))

STATUS of the LISTENER

------------------------

Alias                     LISTENER_MOB

Version                   TNSLSNR for HPUX: Version 12.1.0.2.0 - Production

Start Date                23-APR-2016 14:37:14

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oracle/MBD/12102/network/admin/listener.ora

Listener Log File         /oracle/MBD/diag/tnslsnr/sb54/listener_mob/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MBD.WORLD)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MBD)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sb54.shure.com)(PORT=1527)))

Services Summary...

Service "MBD" has 1 instance(s).

  Instance "MBD", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

sb54:orambd 6> R3trans -d

This is R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'MBD'"

R3trans finished (0012).

sb54:orambd 7> vi trans.log

"trans.log" 16 lines, 1121 characters

4 ETW000 R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 23.04.2016 - 14:37:22

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000  [ dev trc,00000] Sat Apr 23 14:37:22 2016

4 ETW000  [ dev trc,00000] Loading DB library '/usr/sap/MBD/SYS/exe/uc/hpia64/dboraslib.so' ...

4 ETW000  [ dev trc,00000] Library '/usr/sap/MBD/SYS/exe/uc/hpia64/dboraslib.so' loaded

4 ETW000  [ dev trc,00000] Version of '/usr/sap/MBD/SYS/exe/uc/hpia64/dboraslib.so' is "721.02", patchlevel (0.600)

4 ETW000  [ dev trc,00000] dbs/ora/stmt_cache_size = 250

4 ETW000  [ dev trc,00000] Register application info.

4 ETW000  [dbsloci.c   ,00000] *** ERROR => Connect via table SAPUSER is not supported together with Oracle client rel. 12.1.0.2.0. Only Secure Connect method allowed.

2EETW169 no connect possible: "DBMS = ORACLE       --- dbs_ora_tnsname = 'MBD'"

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎04-24-2016 9:34 AM
0 Kudos

Thanks guys the issue has been resolved, the problem was with cd/usr/sap/SID/DVEBMGS41/exe directory...

Show replies
Show replies
Former Member
‎04-24-2016 8:12 AM
0 Kudos

Hi Sriram/Reagan,

I have resolved the issue now R3trans -d & R3trans -x is 000, but when I am trying to startsap, I am getting the below error::

sb54:mbdadm 21> R3trans -d                                                                             

This is R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

unicode enabled version

R3trans finished (0000).

sb54:mbdadm 22> R3trans -x

This is R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

unicode enabled version

R3trans finished (0000).

sb54:mbdadm 23> disp+work

--------------------

disp+work information

--------------------

kernel release                721

kernel make variant           721_EXT_REL

compiled on                   HP-UX B.11.31 U ia64 for hpia64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Oct  1 2015 13:19:07

update level                  0

patch number                  600

source id                     0.600

---------------------

supported environment

---------------------

database (SAP, table SVERS)   700

                              710

                              701

                              702

                              703

                              711

                              720

                              730

                              731

                              732

                             

operating system

HP-UX B.11.31

sb54:mbdadm 24> startsap

Checking MBD Database

Database is not available via R3trans

-------------------------------------------

Trying to start MBD database ...

Log file: /home/mbdadm/startdb.log

Starting Startup Agent sapstartsrv

Unknown webmethod: WaitforServiceStarted

Startup of Instance Service failed

See /home/mbdadm/startsap_DVEBMGS41.log for details

-------------------------------------------

sb54:mbdadm 25> vi /home/mbdadm/startdb.log

"/home/mbdadm/startdb.log" 48 lines, 1399 characters

------------------------------ Sun Apr 24 02:03:42 CDT 2016

LOGFILE FOR STARTING ORACLE

Trying to start MBD database ...

------------------------------ Sun Apr 24 02:03:42 CDT 2016

checking required environment variables

ORACLE_HOME  is >/oracle/MBD/12102<

ORACLE_SID   is >MBD<

------------------------------ Sun Apr 24 02:03:42 CDT 2016

check spfile or initora

------------------------------ Sun Apr 24 02:03:42 CDT 2016

check initora

------------------------------ Sun Apr 24 02:03:42 CDT 2016

checking V2 connect

TNS Ping Utility for HPUX: Version 12.1.0.2.0 - Production on 24-APR-2016 02:03:42

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:

/usr/sap/MBD/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

@

"/home/mbdadm/startdb.log" 48 lines, 1399 characters

------------------------------ Sun Apr 24 02:03:42 CDT 2016

LOGFILE FOR STARTING ORACLE

Trying to start MBD database ...

------------------------------ Sun Apr 24 02:03:42 CDT 2016

checking required environment variables

ORACLE_HOME  is >/oracle/MBD/12102<

ORACLE_SID   is >MBD<

------------------------------ Sun Apr 24 02:03:42 CDT 2016

LOGFILE FOR STARTING ORACLE

Trying to start MBD database ...

------------------------------ Sun Apr 24 02:03:42 CDT 2016

checking required environment variables

ORACLE_HOME  is >/oracle/MBD/12102<

ORACLE_SID   is >MBD<

------------------------------ Sun Apr 24 02:03:42 CDT 2016

check spfile or initora

------------------------------ Sun Apr 24 02:03:42 CDT 2016

check initora

------------------------------ Sun Apr 24 02:03:42 CDT 2016

checking V2 connect

TNS Ping Utility for HPUX: Version 12.1.0.2.0 - Production on 24-APR-2016 02:03:42

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:

/usr/sap/MBD/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 = sb54) (PORT = 1527))) (CONNECT_DATA = (SID = MBD) (GLOBAL_NAME = MBD.WORLD)))

OK (0 msec)

tnsping: V2 connect to MBD

:q!

sb54:mbdadm 26> vi /home/mbdadm/startsap_DVEBMGS41.log

"/home/mbdadm/startsap_DVEBMGS41.log" 16 lines, 422 characters

Trace of system startup/check of SAP System MBD on Sun Apr 24 02:03:46 CDT 2016

Called command: /usr/sap/MBD/SYS/exe/run/startsap start

-------------------------------------------

02:03:48

Starting Startup Agent sapstartsrv

-------------------------------------------

02:03:48

Startup of Instance Service failed

-------------------------------------------

02:03:48

See /home/mbdadm/startsap_DVEBMGS41.log for details

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

~

:q!

sb54:mbdadm 27>

Show replies
Show replies
Reagan
Advisor
Advisor
‎04-23-2016 11:33 PM
0 Kudos

>>sb54:orambd 6> R3trans -d

This is R3trans version 6.24 (release 721 - 31.07.15 - 14:39:42).

No surprise here. You are running R3trans under orambd. You should switch to mbdadm user and execute R3trans.

Show replies
Show replies
Sriram2009
Active Contributor
‎04-23-2016 9:33 PM
0 Kudos

Hi Kavish.

You have to setup the SSFS connection to DB. Refer the SAP Note for error message " ERROR => Connect via table SAPUSER is not supported together with Oracle client rel. 12.1.0.2.0. Only Secure Connect method allowed."

1622837 - Secure connection of AS ABAP to Oracle via SSFS

BR

SS

Show replies
Show replies
Ask a Question