R3trans -d works, but Startsap fails on it.

[matej_koudelka]

Hello experts,

Im tryint to figure out curious problem in our sap system.

Its running on oracle - distributed setup.

When i run R3trans -d on instance host, it works fine (0000 return code). But when i run startsap, it immediately fails on R3trans check.

The database is up, listener is running.

Any ideas ?

smbttccip:tteadm 1> R3trans -d

This is R3trans version 6.25 (release 742 - 25.02.15 - 20:15:02).

unicode enabled version

R3trans finished (0000).

smbttccip:tteadm 2> startsap

Checking TTE Database

Database is not available via R3trans

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

Database TTE must be started first

Log on to remote server and start database

smbttccip:tteadm 3>

trans.log from running R3trans -d in attachment.

Thanks for assistance.

translog.txt.zip

[former_member204080 · Accepted solution]

Hi,

Could you please also share details if you have done any changes to the system recently (Kernel ,SBP etc)

Regards,

Murali

[matej_koudelka · Accepted solution]

Hello Murali,

Yes there has been plenty of work done on the system recently, since it was not used for some time.

We have upgraded Oracle from 11203 to 11204, upgraded kernel from 721 - 740.

After these we did fresh system copy and activated SSFS.

All of these were done recently and sadly could be the cause (even though they everything seemed successful)

Regards,

Matej

[former_member204080 · Accepted solution]

HI Matej,

Did you try giving startsap <Profile name>(if you have any virtual name like prd-scs-d01 ) or startsap <Instance> (DVEBMGS00 etc) and check

Is it also returning same error

Regards,

Murali

[Reagan · Accepted solution]

>>We have upgraded Oracle from 11203 to 11204, upgraded kernel from 721 - 740.<<

Quick question. Why did you update the kernel from 720 release to 740?

Your problem should be somewhere in the kernel area.

Check the SAP note 1969546 - Release Roadmap Kernel 740 and see if you have the system with the correct NW version to put the 740 kernel.

[Former Member]

I remember once I encountered the same issue with the same log message. to resolve this issue I executed "sapcontrol -nr <Systemnumber> -host <myhostname> -prot NI_HTTP -function Start" instead of startsap command after that the system started properly.

Regards,
Shanthosh

[Former Member]

SAP Startup Troubleshooting Guide for Netweaver Application Server - Application Server Infrastructu...

youcan use the above mentioned link in troubleshooting this issue further.

Regards,
Shanthosh

[matej_koudelka]

Using sapcontrol like this brought some parts of the instance up, but dispatcher shut down. Investigating logs now...

[Former Member]

Which database you are using.. please confirm.

[matej_koudelka]

The system runs on Oracle 11.2.0.4

[former_member230159]

Dear Matej,

"dispatcher shut down" ..

Could you paste the logs for dev_disp, dev_w0 here ?

Also at what time did this disp down issue occurred ?

In addition to this I would recommend to read the wiki link provided by Shanthosh  (SAP Startup Troubleshooting Guide for Netweaver Application Server - Application Server Infrastructu...) as it contains possible causes and solutions to such problems.

Regards,

Manjunath

[Former Member]

good news!!! attach the dispatcher log if incase you need further help.

Regards,
Shanthosh

[matej_koudelka]

Hey everybody, the issue has been worked out.

The cause was poorly done Kernel update, I have deleted the Kernel and uploaded it again, fixed permissions and seems like everything is working again.

Thanks for assists

[matej_koudelka]

Thanks everybody for the replies, let me sumarize it up rather than replying to every post.

Database : DB is up and running, Listener is running also.

CI : R3trans -d (or -x for that matter) works, return code is 0000. Startsap fails on R3trans check tho.

Kernel 742 - We upgraded kernel due to the fact that the source system for the system copy was already running on it and had SSFS activated.

Profiles - SAPDBHOST parameter is correctly set in default profile, I just tried to set it in instance profile as well - still doesnt work.

R3trans -d check works from all hosts.

SSFS implementation - yes, we have reseted the password, just tried it again and the result is still the same. If we had wrong password in ssfs storage the R3trans -d check would fail from CI.

[Former Member]

Have the /sapmnt and /usr/sap file systems mounted on DB host.. Can you please check and confirm.\

Regards,

Karthik

[matej_koudelka]

Both file systems are mounted correctly.

[Former Member]

Hi,

Have you tried the solution which was provided by shantosh..

Please confirm,

[Reagan]

You are not providing the complete details for us to help you.

You said you replaced 720 kernel with 740 kernel and refreshed the system with the copy of the source system which is already running on 740 kernel.

What about the profiles? On newer releases there is no START profile as it is merged with the instance profile.

Run this command as tteadm and provide the output

sapcontrol -nr 00 -function GetVersionInfo

Replace 00 with the correct system number

[manumohandas82]

Would you mind sharing your startup profile and Default profile .  [ You could comment or edit your and hostname / ip adress  and share ]

Thanks ,

Manu

[Former Member]

Check for parameter named "SAPDBHOST" in DEFAULT.PFL.

Entry should be as

SAPDBHOST = 

Also,

Check DEFAULT.PFL if the file name is "DEFAULT" only then name it to DEFAULT.PFL.

[Former Member]

This message was moderated.

[former_member202590]

Hi Matej,

Since you said its a distributed system, please check the R3trans from all the hosts specially from your ASCS instance.

It must be some problem there.

Please let us know the configuration as well.

Thanks

AMIT

[Former Member]

Hi Mateja,

Can you check the SAPDBHOST & j2ee/dbhost parameter is correctly set.\ in Defualt and instance profiles.

If its not set do add it in your default profile.

As the above error is more happening in distributed environment and DB resides on different host.

Do add this parameter and update us if you still see the issue.

Regards,

Ram

[Former Member]

Hello Matej,

Please check the following sap link.

Regards

Anand

[former_member204080]

Hi Matej,

After SSFS implementation did you reset your schema password

Could you please try below

1.From SIDADM run below command

brconnect -u / -p init<SID>.sap -f chpass -o <schema user> -p <password>

If you run from SIDADM it will update the new password in SSFS key file also .This will work if you are on latest kernel

If not you need to manually update using below

rsecssfx put DB_CONNECT/DEFAULT_DB_USER <schemausername> -plain

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <pwd>

Please try to start after doing above

Regards,

Murali

[matej_koudelka]

Hi,

yes i have tried those as well, the result is still the same.

I feel like this will be some sort of silly issue (wrong profile parameter or something), otherwise i see no reason for R3trans test to work one way, and fail the other one.

[Former Member]

This message was moderated.