startsap failed on use of SSFS database connection method

[former_member182657]

Dear Experts,

To use latest database connection method from OPS$ to SSFS i configured the system as per SAP Note   1639578 - SSFS as password storage for primary database connect

Current environment of system is with Oracle 11.2.0.3 with kernel 720_EXT .

After complete configuration and setting up of parameters rsdb_ssfs_connect 1,at <sid>adm  R3trans -d results 0000 as a successful connevction output .

But on execution of command startsap r3 dispatcher fails after some time,for analysis checked dev_w0 work process and found still showing Logon as OPS$-user to get SAPSR3's password.

For ref attached dev_w0 and trans.log files

Already followed link

and SAP Note ORA-01017 .

Kindly help me to resolve the issue.

Regards,

Gaurav

files.rar.txt.zip

[former_member182657 · Accepted solution]

Hi Divyanshu / Sriram,

Please accept my regards for giving your useful suggestions to me.

My issue has been resolved by manually setting parameter

setenv rsdb_ssfs_connect 1

under file .sapenv_sap<sid>.csh   (<sid>adm  user environment )

Once again thanks for your kind support to me.

Best Regards,

Gaurav

[divyanshu_srivastava3 · Accepted solution]

Great.. !!

[former_member182657]

@Divyanshu

Thanks for the revert i already checked .profiles for any missing or additional parameters but not able to trace what is missing and causing the issue as R3trans -d reverting with successful database connection as attached in my discussion.

Now as per the SAP Note 1639578 i already maintained the env variables in DEFAULT.PFL as well as under .sapenv.csh shell but still facing the same issue.

@S Sriram

Thanks for mentioning the document ,but unfortunately same document followed and checked for so many times to find out any missing configurations,and not helped me anymore.

Kindly support me further to resolve this strange issue .!!

Regards,

Gaurav

[divyanshu_srivastava3]

Hi Gaurav,

Add the switch parameter (rsdb/ssfs_connect) in instance profile.

Because this is the last profile that is read and if any parameter getting misread, the should overwrite the that, considering rest all is fine.

Try to start this again.

Regards,

Divyanshu

[former_member182657]

Hi Divyanshu,

Still same result.Any other things which we can check .

Regards,

Gaurav

[S_Sriram]

Hi Gaurav

Could you refer the SAP Note for connection issue "ORA-01017: invalid username/password; logon denied "                                                                          

1860519 - SAP fails to connect to the database

BR

SS

[divyanshu_srivastava3]

Hi Gaurav,

May be a quick compare, again considering the note was followed fully.

For sidadm

run the "env" command

run the "sapcontrol -nr <inst#> -function GetEnvironment"

And compare - if anything missing for instance, you need to set that in profile, since R3trans was working.

Other thing is to disable REMOTE_OS_AUTHENT and restart DB.

And quick match with:

Regards

[S_Sriram]

Hi Gaurav

Could you check this SCN link

BR

SS

[divyanshu_srivastava3]

Hi Gaurav,

Hope you are doing good.

If the error is shown in w0 and r3trans is clean then it should be some parameter missing/misread in profiles and environment of user.

I believe you must have already checked that and all prerequisites are met, however just recheck even in .dot profiles for any thing missing.

Regards