cancel
Showing results for 
Search instead for 
Did you mean: 

SSFS with Oracle 12c on ExaData (distributed System)

Former Member
0 Kudos

Hello community,

i have question regarding SSFS with Oracle 12c on ExaData (distributed System).

I have installed ASCS and PAS on a standalone server and the Oracle database as a 3 node RAC on the ExaData.

R3trans -d is working from application- and database server witch <sid>adm user. No Problem:

4 ETW000 R3trans version 6.25 (release 742 - 01.02.16 - 13:15:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 08.03.2016 - 10:41:31

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]  Tue Mar  8 10:41:31 2016

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/<SID>/SYS/exe/run/dboraslib.so' ...

4 ETW000  [     dev trc,00000]  Library '/usr/sap/<SID>/SYS/exe/run/dboraslib.so' loaded

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/<SID>/SYS/exe/run/dboraslib.so' is "742.06", patchlevel (0.324)

4 ETW000  [     dev trc,00000]  read_con_info_ssfs(): DBSL supports extended connect protocol

4 ETW000                         ==> connect info for default DB will be read from ssfs

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

4 ETW000  [     dev trc,00000]  Oracle client version: 12.1.0.2.0, V2, default build, (dbsl 742 160216, UNICODE[2])

4 ETW000  [     dev trc,00000]  Installed Oracle client patches:

4 ETW000  [     dev trc,00000]  # Patch  20988771     : Created on 10 May 2015, 05:21:28 hrs PST8PDT

4 ETW000  [     dev trc,00000]  # Patch  19594959     : Created on 29 Sep 2014, 03:47:01 hrs PST8PDT

4 ETW000  [     dev trc,00000]  # Patch  11799748     : Created on 29 Sep 2014, 12:28:11 hrs CEST

4 ETW000  [     dev trc,00000]  # Patch  11742262     : Created on 29 Sep 2014, 12:28:17 hrs CEST

4 ETW000  [     dev trc,00000]  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

4 ETW000  [     dev trc,00000]  Connecting as SAP<SID>/<pwd>@<SID> on connection 0 (nls 0) ... (dbsl 742 160216, UNICODE[2])

4 ETW000  [     dev trc,00000]  OCIHandleAlloc(con=0): Service svc=2064028 created, rc=0

4 ETW000  [     dev trc,00000]  OCIServerAttach(con=0, svc=2064028): New server hdl. srv=2066690 attached to '<SID>'

4 ETW000  [     dev trc,00000]  OCISessionBegin(con=0, svc=2064028, srv=2066690='<SID>'): start session usr=2097d50='SAP<SID>', rc=0

4 ETW000  [     dev trc,00000]  Now 'SAP<SID>/<pwd>@<SID>' is connected: con=0, nls=0, session=598, time='2016-03-08 10:41:31'

4 ETW000  [     dev trc,00000]  DB instance <SID>1 is running on dbserver with ORACLE version 12.1.0.2.0 since FEB 29, 2016, 09:08:08.

4 ETW000  [     dev trc,00000]  con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8

4 ETW000  [     dev trc,00000]   # CharacterSet (DB)              NCharSet   svchp            srvhp            usrhp            nls TNS

4 ETW000  [     dev trc,00000]   0 UTF8                           UTF8       2064028          2066690          2097d50            0 <SID>                  

4 ETW000  [     dev trc,00000]   # CharacterSet (Env)             NCharSet   envhp            errhp            er2hp            bathp

4 ETW000  [     dev trc,00000]   0 UTF16                          AL16UTF16  203b200          2062010          2063090          2064110

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)

4 ETW000  [     dev trc,00000]     DbSlControl(DBSL_CMD_SAPRELEASE_SET,abap='740')

4 ETW000  [     dev trc,00000]  NTAB: Structure of NTAB on DB is VERS_B, unicodelg of executable is 2, unicodelg of SVERS in nametab is 2

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = '<SID>' --- SYSTEM = '<SID>'.

4 ETW690 COMMIT "0" "0"

4 ETW000  trace to file pointer closed

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

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time        : 08.03.2016 - 10:41:31

4 ETW000 function         : CONNECT

4 ETW000 buffersync       : YES

4 ETW000 clients          : default

4 ETW000 purgedocu        : YES

4 ETW000 commit           : 100000

4 ETW000 table cache      : dynamic

4 ETW000

4 ETW000  [     dev trc,00000]  Disconnecting from ALL connections:

4 ETW000  [     dev trc,00000]  Disconnecting con=0

4 ETW000  [     dev trc,00000]  OCISessionEnd(con=0, svc=2064028, srv=2066690='<SID>'): Close session usr=2097d50, rc=0

4 ETW000  [     dev trc,00000]  OCIServerDetach(stale1 con=0, svc=2064028, srv=2066690='<SID>') successfully detached

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0, svc=2064028): Server handle srv=2066690 freed

4 ETW000  [     dev trc,00000]  OCIHandleFree(con=0): Service hdl. svc=2064028 freed.

4 ETW000  [     dev trc,00000]  Disconnected from connection 0

4 ETW000  [     dev trc,00000]  statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000  [     dev trc,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 08.03.2016 - 10:41:31

Right now i tried to run brconnect as <sid>adm on the databaseserver and i got the following error:

>>>>> brconnect -u // -c -f check

BR0801I BRCONNECT 7.40 (21)

BR1528E Calling a function of library rsec5lib failed at location BrSsBrUsrPwdGet-2, return code 1

BR1301E Error message from rsec5lib: SSFS-4187: Record with key "BR_TOOLS/DEFAULT_DB_USER" not found in secure storage <-- SSFS-4182: Data file "/oracle/<SID>/security/rsecssfs/data/SSFS_<SIS>.DAT" does not exist (this is not an error per se: a non-existing data file is a valid situation and treated equally as one without entries) <-- SSFS

BR1529E Getting BR*Tools user name/password from secure storage /oracle/<SID>/security/rsecssfs/data/SSFS_<SID>.DAT failed

BR0806I End of BRCONNECT processing: cesrhpzb.log 2016-03-08 10:44:47

BR0280I BRCONNECT time stamp: 2016-03-08 10:44:47

BR0804I BRCONNECT terminated with errors

And now my question.

I read about creating some directories in this post

Create necessary directories

  1. K sidadm

cd /usr/sap/SID/SYS/global

mkdir /usr/sap/SID/SYS/global/security

mkdir /usr/sap/SID/SYS/global/security/rsecssfs

mkdir /usr/sap/SID/SYS/global/security/rsecssfs/data

mkdir /usr/sap/SID/SYS/global/security/rsecssfs/key

But this is only on the application server i think. But what about the ExaData?

brconnect looked for the .DAT file in the following directory:

/oracle/<SID>/security/rsecssfs/data


And this is because $SAPDATA_HOME is set /oracle/<SID>

Is correct up to here?


So which user should create the following directories (oracle, <SID>adm or ora<SID>):


/oracle/<SID>/security

/oracle/<SID>/security/rsecssfs

/oracle/<SID>/security/rsecssfs/data

/oracle/<SID>/security/rsecssfs/key


And which permissions should they have?!


I also tried to copy the existing SSFS_<SID>.DAT from /usr/sap/SID/SYS/global/security/rsecssfs/data to /oracle/<SID>/security/rsecssfs/data with user oracle and also with <SID>adm. Then i go the following error message:


>>>>>>> brconnect -u // -c -f check

BR0801I BRCONNECT 7.40 (21)

BR1528E Calling a function of library rsec5lib failed at location BrSsBrUsrPwdGet-2, return code 1

BR1301E Error message from rsec5lib: SSFS-4218: Record with key "BR_TOOLS/DEFAULT_DB_USER" not found in secure storage <-- SSFS-4215: Data file "/oracle/<SID>/security/rsecssfs/data/SSFS_<SID>.DAT" exists, but does not contain the requested entry

BR1529E Getting BR*Tools user name/password from secure storage /oracle/<SID>/security/rsecssfs/data/SSFS_<SID>.DAT failed

BR0806I End of BRCONNECT processing: cesrhrmr.log 2016-03-08 11:01:57

BR0280I BRCONNECT time stamp: 2016-03-08 11:01:57

BR0804I BRCONNECT terminated with errors

Did someone had the same problem and what would be the solution for this?!

Regards,

Sascha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hallo Sascha,

/oracle/<SID>/security

/oracle/<SID>/security/rsecssfs

/oracle/<SID>/security/rsecssfs/data

/oracle/<SID>/security/rsecssfs/key

are about getting brtools to support SSFS.

Refer to note http://service.sap.com/sap/support/notes/1764043


The directories should be owned by ora<sid> and need to have 700. SSFS_<SID>.DAT needs 600.

The file SSFS_<SID>.DAT should be created when you execute

brconnect -u / -c -f chpass -o 'BRT$ADM' -p <password> -s brtools

as per above note.


Regards

Thomas.

Former Member
0 Kudos

Hi Thomas,

thanks for that. Right now it worked correct on command line.

But now i have another problem. The jobs which are planned over db13 are still not running.

I checked and configured SAPXPG_DBDEST<db-server-hostname> in SM59. The connection test was succesfull.

I have no rsh installed on the db-server. The connection is working over ssh.

In the dev_rd logfile i found the following message:

Wed Mar  9 10:56:00 2016

*** ERROR => GwStartProgram: execvp failed (No such file or directory) [gwuxrd.c     472]

***LOG S34=> GwStartProgram, execvp failed ( 002 /usr/bin/rsh) [gwuxrd.c     479]

*****************************************************************************

*

*  LOCATION    SAP-Gateway on host qde4q0.de.t-internal.com / sapgw51

*  ERROR       Start of TP /usr/bin/rsh failed

*

*  TIME        Wed Mar  9 10:56:00 2016

*  RELEASE     742

*  COMPONENT   SAP-Gateway

*  VERSION     2

*  RC          667

*  MODULE      /bas/742_REL/src/krn/si/gw/gwuxrd.c

*  LINE        482

*  SYSTEM CALL execvp

*  ERRNO       2

*  ERRNO TEXT  No such file or directory

*  COUNTER     129

*

*****************************************************************************

*** ERROR => GwStartProgram: exit /usr/bin/rsh [gwuxrd.c     494]

Wed Mar  9 10:56:20 2016

child (pid=94585) exited with exit code 255

rsh is not correct here. Do you know where it comes from?

Because the SAPXPG_DBDEST<db-server-hostname> connection is confirgured with ssh.

The dev_rfc13 logfile show me following message:

**** Trace file opened at 20160309 105600 CET, by disp+work

**** Versions SAP-REL 742,0,324 RFC-VER U 3 1650044 MT-SL

======> CPIC-CALL: 'ThSAPOCMINIT', communication rc: CM_ALLOCATE_FAILURE_NO_RETRY (cmRc=1), taskhandler rc: GW_EXEC_FAILED (thRc=667)

Program (exec) could not be started

ABAP Programm: SAPLCRFC (Transaction: )

User: SGLOWACZ (Client: 300)

Destination: %_TCPIP_%1 (Handle: 1, DtConId: 56DD74697EC0F8F1E10000000694F3EB, DtConCnt: 0, ConvId: ,)

EPP RootContextId: 246E9602A1041EE5B9BB9025C700334C, ConnectionId: 00000000000000000000000000000000, ConnectionCnt: 0

EPP TransactionId: 56DD74677EC0F8F1E10000000694F3EB

Error RFCIO_ERROR_SYSERROR in /bas/742_REL/src/krn/rfc/abrfcpic.c : 1745

CPIC-CALL: 'ThSAPOCMINIT', communication rc: CM_ALLOCATE_FAILURE_NO_RETRY (cmRc=1), taskhandler rc: GW_EXEC_FAILED (thRc=667)

Program (exec) could not be started

DEST =%_TCPIP_%1

HOST =<db-server-hostname>

PROG =sapxpg

Regards,

Sascha

Former Member
Former Member
0 Kudos

Hi Thomas,

problem was solved with setting parameter gw/rem_start = SSH_SHELL in the DEFAULT profile.

Regards,

Sascha

Answers (0)