Unable to start maxdb and sap application

[vvaruva]

Dear All,

When start sap system it gave error unable to start database.

I try to start database manually and it gave below error, please help in regards.

Must be called by root or effective user 7000 effective group 205

Error! Connection failed to node itrt51 for database APP:

Reading header from pipe:(0:NO ERROR(0)

Thanks &Regards

Vivek

[JamesZ]

Hi Vivek,

Which user you are using to start sap?

Are you able to manually start maxdb via below command?

dbmcli -d <dbsid> -u control,<password> db_online

Best regards,
James

[vvaruva]

Dear James,

I have tried with <SID>adm user to start the database.

The user <SID>adm is in 205 group.

I am new to MaxdB, please help me to understand this mechanism.

Thanks&Regards,

Vivek

[vvaruva]

Dear James,

For answer your query, I am not able to start the db with above command.

Regards

Vivek

[JamesZ]

Hi Vivek,

Can you show me with the screenshot of command below?

dbmcli -d <dbsid> -u control,<password> db_online

Best regards,

James

[vvaruva]

Dear James,

Please find below is the screen shot.

Thanks

Vivek

[JamesZ]

Hi Vivek,

Please check SAP note

1789865 

for the solution. As mentioned 'sdbverify -repair_permissions' should help for your case if you database version does meet the requirement.

Best regards,
James

[vvaruva]

Dear James,

Thanks for the support,

I have tried below solution with root user

To fix them, still logged as 'root', execute the command 'sdbverify -repair_permissions'

But getting below error.

host:/sapdb/programs/bin # sdbverify -repair_permissions

-bash: sdbverify: command not found

host:/sapdb/programs/bin #

Thanks &Regards,

Vivek

[JamesZ]

Hi Vivek,

Are you able to find sdbverify from directory /sapdb/programs/bin? Maybe the problem is caused by different shell for root user?

Best regards,
James

[vvaruva]

Dear James,

Yes I have found the sdbverify program in the same directory.

How do I change shell program for root user.

I am able to to execute sdbverify with sidadm user

Thanks &Regards,

Vivek

[JamesZ]

Hi Vivek,

What is your database version? I am not sure why root user is not able to execute sdbverify .
Can you try to run sdbverify  by giving full path?

Best regards,

James

[vvaruva]

Dear John,

Thanks for support,

I am able to execute with giving full path.

Please find below is the issue with the command

host:/sapdb/programs/bin # /sapdb/programs/bin/sdbverify -repair_permissions

Unknown option: repair_permissions

usage: sdbverify [-h|--help] [-v|--version] [-F|--file <file name>]

                [--set_corrupted_invalid]

        -h --help                       show this

        -v --version                    show version

        -F --file <file name>           check installed file

        --set_corrupted_invalid         set inconsistent packages to invalid

host:/sapdb/programs/bin #

Thanks&Regards,

Vivek

[JamesZ]

Hi Vivek,

As mentioned in the note, the option is only valid for specific database version. What is your maxdb version? Do you have access to SAP note content?

Best regards,
James

[vvaruva]

Dear John,

My DB version is 7.6.00.35

Thanks&Regards,

Vivek

[JamesZ]

Hi Vivek,

If so, option -repair_permissions is not valid for your version. You have to follow up note

1789865 to reinstall maxdb software. Because the maxdb permission file was changed or corrupted, we cannot manually fix this issue.

Best regards,

James

[Former Member]

hi Aruva,

Was there any activity carried out before you started facing this issue. And one more thing is did you have a dbm studio installed try to connect to DB using it.

Also whats the output of dbmcli -d <dbsid> -u control,<password> db_state.

also can you verify your db SID & are you able to login with SDB user.

Let us know the details.

Regards,

ram