SSFS implementation: SQLNET.AUTHENTICATION_SERVICES

[Former Member]

Hello oracle-experts,

we successfully implemented SSFS. We also set the parameter SQLNET.AUTHENTICATION_SERVICES from NTS to NONE.

After this we are not able to start DB automatically via MMC.

Is this a known error? 

Thank you!

[former_member182657]

Hi Alex,

Share the R3trans -d results with trans.log file.

Regards,

Gaurav

[Former Member]

Hello!

This is the output of the comando r3trans -d

R3trans=>sapparam(1c): No Profile used.

R3trans=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

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

r3trans finished (0012).

The problem seems to be the db start skript of SAP system.

We see there

echo connect / as sysdba >> v9start.sql

echo startup >> v9start.sql

echo exit >> v9start.sql

As I unterstood correctly if we switch SQLNET.AUTHENTICATION_SERVICES from NTS to NONE the comando connect / as sysdba does not work anymore within db start script, is not?

Thank you!

[salome_szanto]

Hello Alex,
There must be some other entries in the trans.log, please attach the whole
-trans.log
-sapstart.log

Regards,
Salome

[Former Member]

Hello Salome/Oracle experts,

the content of sapstart.log is:

SAP-R/3-Startup Program

Starting at 2014/11/26 16:48:13

Startup Profile: "\\SERVERNAME\sapmnt\PR1\SYS\profile\START_DVEBMGS00_SERVERNAME"

Starting Programs

(2608) Execute: E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\sapcpe.EXE pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME

(8896) Execute: E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\sapcpe.EXE pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME list:E:\usr\sap\PR1\SYS\exe\jvm\NTAMD64\sapjvm_4.1.038/sapjvm_4.lst source:E:\usr\sap\PR1\SYS\exe\jvm\NTAMD64\sapjvm_4.1.038

(12808) Execute: E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\strdbs.cmd PR1

(5708) CreateProcess: E:\usr\sap\PR1\DVEBMGS00\exe\msg_server.EXE pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME

(9268) CreateProcess: E:\usr\sap\PR1\DVEBMGS00\exe\disp+work.EXE pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME

(8580) Execute: E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\sapcpe.EXE pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME list:E:\usr\sap\PR1\SYS\exe\jvm\NTAMD64\sapjvm_4.1.038\sapjvm_4.lst source:E:\usr\sap\PR1\SYS\exe\jvm\NTAMD64\sapjvm_4.1.038

(3868) Execute: E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\sapcpe.EXE list:E:\usr\sap\PR1\SYS\global\bootstrap\bootstrap.lst source:E:\usr\sap\PR1\SYS\global\bootstrap target:E:\usr\sap\PR1\DVEBMGS00\j2ee\cluster\bootstrap pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME

(7612) CreateProcess: E:\usr\sap\PR1\DVEBMGS00\exe\igswd.EXE -mode=profile pf=\\SERVERNAME\sapmnt\PR1\SYS\profile\PR1_DVEBMGS00_SERVERNAME