SSFS-1560: Could not open lockfile

[Former Member]

Hi together,

SSFS was installed during the installation but R3trans -d get an error:

E:\>R3trans -d

This is R3trans version 6.24 (release 742 - 18.11.14 - 20:14:09).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = '<SID>'"

R3trans finished (0012).

OS: Windows Server 2012R2

DB: Oracle 11.2.0.4

SAP: AS Java 7.4

So I started to configuring SSFS according to note 1639578.

The security folder under global was already there including the subfolders.

I set the following parameters in the DEFAULT.PFL and in den enviroment:

RSEC_SSFS_DATAPATH $(DIR_GLOBAL)\security\rsecssfs\data

RSEC_SSFS_KEYPATH $(DIR_GLOBAL)\security\rsecssfs\key

rsdb_ssfs_connect 1

But when I configuring the SSFS storage I got teh following error:

E:\>rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3DB -plain

SSFS-1560: Could not open lockfile;

open($(DIR_GLOBAL)\security\rsecssfs\data\SSFS_AS1.LCK) == 2 (No such

file or directory) [17=EEXIST,13=EACCES,2=ENOENT,22=EINVAL,20=ENOTDIR]

In this directory only the SSFS_<SID>.DAT file is located. With the date from the installation.

Have anybody experience on this?

best regards

Karsten

[JamesZ · Accepted solution]

Hi Karsten,

Why the user is SAPSR3DB? ssfs should be used for abap, not for java

What is the DIR_GLOBAL value as mentioned in the note？

Best regards,
James

[Former Member · Accepted solution]

Hi James,

I changed the Windows enviroment variabale:

Old:

RSEC_SSFS_DATAPATH $(DIR_GLOBAL)\security\rsecssfs\data

RSEC_SSFS_KEYPATH $(DIR_GLOBAL)\security\rsecssfs\key

New:

RSEC_SSFS_DATAPATH \\<hostname>\saploc\<SID>\SYS\global\security\rsecssfs\data

RSEC_SSFS_KEYPATH \\<hostname>\saploc\<SID>\SYS\global\security\rsecssfs\key

No it works.

Thanks for your help.

best regards

Karsten

[Former Member]

"R3trans -d" is not meant for Java systems.

No need to worry, as long as your Java application server is up and running.

regards

[former_member215439]

Hi,

What is your database status?

kindly check your TNSLISTENER in SERVICES.MSC and CMD> LSNRCTL STATUS

James

[Former Member]

Hi James,

thanks for your quick response.

The TNSLISTNER is running. Checked in service.msc and LSNRCTL STATUS:

E:\>LSNRCTL STATUS

LSNRCTL for 64-bit Windows: Version 11.2.0.4.0 - Production on 13-APR-2016 09:00:48

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=<SID>.WORLD))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Production

Start Date                12-APR-2016 21:15:58

Uptime                    0 days 11 hr. 44 min. 50 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   E:\oracle\<SID>\11204\network\admin\listener.ora

Listener Log File         E:\oracle\<SID>\saptrace\diag\tnslsnr\<hostname>\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\<SID>.WORLDipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\<SID>ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=FQDN)

(PORT=1521)))

Services Summary...

Service "<SID>" has 2 instance(s).

  Instance "<SID>", status UNKNOWN, has 1 handler(s) for this service...

  Instance "<SID>", status READY, has 1 handler(s) for this service...

The command completed successfully

I have also restarted the whole system but it doesn't help.

best regards

Karsten

[former_member215439]

Hi Karsten,

How bout in database instance, is your database open?

James.

[Former Member]

Hi James,

yes database is open:

SQL> select status from v$instance;

STATUS

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

OPEN

The AS Java is also running.

best regards

Karsten