Cannot start instance(MaxDB) during installing Netweaver 7.5

[former_member367733]

Hi experts,

I met a problem "cannot start instance" during installing NetWeaver 7.5 on Redhat7.3. Could you please help check why this happen?

OS info:

[root@mo-36ffb5ac4 sapdata]# cat /etc/*release

NAME="Red Hat Enterprise Linux Server"

VERSION="7.3 (Maipo)"

My installation log:

And I tried to start the instance manually. This is the following logs:

[root@mo-36ffb5ac4 bin]# ./dbmcli -d LDB -u sqdldb,pxE8FZt24001 db_online

Error! Connection failed to node (local) for database LDB: -24950,ERR_USRFAIL: User authorization failed

My system SID is LDS and DB's sid is LDB.

Many thanks.

BR

Alex

[BJarkowski · Accepted solution]

Hi,

1) You can try to start system manually from command line

2) If that won't help please provide us with dev_disp log file

Best regards

Bartosz

[former_member367733 · Accepted solution]

Hi Bartosz,

1) I tried start the instance in command line. The following are the result.

[root@mo-36ffb5ac4 data]# su - sqdldb

Last login: Fri Mar 10 10:57:51 UTC 2017 on pts/0

mo-36ffb5ac4:sqdldb 5> dbmcli -d ldb -U c db_online

OK

And I reran sapinst and same error popped up.

2) dev-disp.txt Hope I upload the proper file for you. If it is not correct, please contact me and tell me which I should upload.

Many Thanks.

BR

Alex

dev-disp.txt

[BJarkowski · Accepted solution]

Hi,

this step tries to start SAP Instance, not database. Database is already running.

Anyway I checked your log file. I think I know what is going on, but to double check can you please paste the content of /etc/hosts file?

Best regards

Bartosz

[former_member367733 · Accepted solution]

Hi Bartosz,

[root@mo-36ffb5ac4 ~]# cat /etc/hosts

127.0.0.1 mo-36ffb5ac4.mo.sap.corp mo-36ffb5ac4

127.0.0.1 localhost.localdomain localhost

127.0.0.1 localhost4.localdomain4 localhost4

# The following lines are desirable for IPv6 capable hosts

::1 mo-36ffb5ac4.mo.sap.corp mo-36ffb5ac4

::1 localhost.localdomain localhost

::1 localhost6.localdomain6 localhost6

I didn't change this file. I just ensure the hostname is correct.

[root@mo-36ffb5ac4 ~]# hostname

mo-36ffb5ac4

[root@mo-36ffb5ac4 ~]# hostname -f

mo-36ffb5ac4.mo.sap.corp

Do I must change this hosts file?

Many thanks.

BR

Alex

[BJarkowski · Accepted solution]

The problem is that your hostname is assosciated with the loopback interface, which is not correct. You should read SAP Notes prior to starting the install, for example:

2002167 - Red Hat Enterprise Linux 7.x: Installation and Upgrade

Anyway, to fix your issue please correct following entry in your /etc/hosts file (change 127.0.0.1 to your actual IP address):

127.0.0.1 mo-36ffb5ac4.mo.sap.corp mo-36ffb5ac4

Then continue with the installation process.

Best regards

Bartosz

[Isaias_SAP · Accepted solution]

You are correct 😉

Cheers!

Isaías

[former_member367733 · Accepted solution]

Hi Bartosz,

I changed the hosts file as you said. But when I reboot the server and continue my installation,the instance still cannot be started. Then I tried install a new system(I rebooted the server). But during I input the database id, there is error popped up. And I changed the file as popped solution. It still cannot work.

Please review my files.

127.0.0.1 localhost.localdomain localhost

10.9.36.29 mo-36ffb5ac4.mo.sap.corp mo-36ffb5ac4

127.0.0.1 localhost4.localdomain4 localhost4

Sorry for this inconvenience. I modified the file as the note said. But there is still errors popped up.

BR

Alex

[BJarkowski · Accepted solution]

Hi,

What is the outcome of following commands:

A) ping mo-36ffb5ac4.mo.sap.corp

b) hostname -s

Best regards

Bartosz

[former_member367733 · Accepted solution]

Hi Bartosz,

A>

ping mo-36ffb5ac4.mo.sap.corp

PING mo-36ffb5ac4.mo.sap.corp (127.0.0.1) 56(84) bytes of data.

64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.024 ms

B>[root@mo-36ffb5ac4 ~]# hostname -s

mo-36ffb5ac4

Many thanks

BR

Alex

[former_member367733 · Accepted solution]

Hi Bartosz,

I resolved this problem and successfully installed Netweaver 7.5.

Thank you very much for your help. Really appreciated.

BR

Alex

[BJarkowski · Accepted solution]

Great! Congratulation !

Best regards

Bartosz

[JamesZ]

Hi Alex,

"./dbmcli -d LDB -u sqdldb,pxE8FZt24001 db_online"

Do you have superdba or control user? sqdldb is not like a default db user.

Best regards,
James

[JPReyes]

If the DB is the issue dev_disp wont help it does not show database connection issues... can you post dev_w0?

https://blogs.sap.com/2013/06/20/logical-basic-abap-system-start-troubleshooting-sequence/

Regards, JP

[former_member367733]

Hi Juan,

Thank you very much for your answer. Bartosz has already helped me find out why the instance cannot be started. I missed one OS configuration step(modify the /etc/hosts file) before Netweaver installed. After I modified the file as the Notes 2002167, I met another problem.

Do you have clue to resolve this problem?

Thank you very much.

BR

Alex

[JPReyes]

Yes, the clue is on the text above...

Go to your host file (/etc/hosts) and add the entries required..

127.0.0.1 localhost

<ip of your host> <hostname>

this are basic requirements when setting up a system... read the installation guide.

Regards, JP

[former_member367733]

Hi Juan,

I did this as the solution in the error message. But the error still popped up. I don't know how to fix it.

Many thanks.

BR

Alex

[JPReyes]

change your entry for the reverse lookup to point to your host

127.0.0.1 mo-36ffb5ac4

Regards, JP

[former_member367733]

Hi Juan

I resolved this problem and successfully installed Netweaver 7.5.

Thank you very much for your help.

BR

Alex