SAP instance start issue

[Former Member]

Hi All ,

We have done a copy of our sap system in another environment . (Doing it first time)

Once the process got over, when we try to initiate the sap machine by using command sidadm> startsap pf=/sapmnt/SID/profile/SID_DVEBMGS00_ip-253-23-50-568 ,got below error .

Database db must be started first

Log on to remote server and start database

So tried to start database (Database is sybase) by using command  startdb  , this is the log file error details .

starting database SID ...

checking required environment variables

check if Sybase ASE processes are running

ASE instance not available

There are no Sybase processes running -

Database is probably already stopped.

check if Sybase Backupserver is running

Backupserver instance not available

Database not available

parse level 0: identified message 'Database 'master' is now online.'

parse level 1: identified message 'Database 'tempdb' is now online.'

parse level 2: identified message 'Database 'sybsystemprocs' is now online.'

/usr/sap/SID/SYS/exe/run/startdb was killed or interrupted. Terminating.

Please any input , what could be the issue .

Regards ,

Prabin

[Former Member]

Thanks all for your valuable inputs .

[former_member185239]

Hi Prabin,

You need to check the below values in your instance and default profile.

SAPLOCALHOST = <it will  a name of the host where CI is running>

SAPDBHOST = <it will be name of the host where database is running>

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

We have changed SAPLOCALHOST and SAPDBHOST as per our new hostname in default.PFL file in /usr/sap/SID/SYS/profile.

When we login to SID and execute the command <startsap> it gives the below error:

No instance profiles found

Thanks

Prabin

[former_member185239]

Hi Prabin,

Check the below things

1. check the naming convention of the profiles

   instance profile

   <SID>_<Instancename>_<newhostnameaftermigration>

2. open the hosts file located at /etc folder and maintain the correct entry for the new hostname.

3. Maintain the SAPLOCALHOST and SAPDBHOST environment variable for sidadm user.

With Regards

Ashutosh Chaturvedi

[former_member200876]

Hi Prabin

you should change server hostname before change SAP profiles

follow these steps before start the system again

• first change hosts ( login as root ) to the new host name

• go to network setting in Linux and change the host name from (old host name to the new hostname - ( login as root )
• Then go to terminal and start sap (login as SIDadm) using command " startsap all "

BR.
M. Ezzat

[Former Member]

Hi M. Ezzat

We are able execute startsap & stopsap command successfully from cmd  after maintaining the proper hostname.

That means SAP instance is up now , But while connecting from SAPGUI we are still facing issue .

Error details

**************************************************

Sapgui 730 [Build 9034] Wed Apr 20 16:02:58 2016

: 'connection to partner '63.45.136.59:sapdp11' broken

WSAECONNRESET: Connection reset by peer

Do you want to see the detailed error description?

'

**************************************************

Sapgui 730 [Build 9034] Wed Apr 20 16:03:00 2016

: 'connection to partner '63.45.136.59:sapdp11' broken

Time Wed Apr 20 16:02:58 2016

Component NI (network interface)

Release 730

Version 40

Module nixxi.cpp

Line 5086

Method NiIRead: P=63.45.136.59:3211; L=11.11.11.626:58995

Return Code -6

System Call recv

Error No 10054

Error Text WSAECONNRESET: Connection reset by peer

Counter 1

'

We have turned off the firewall in SAP instance & we are able to telnet the port 3211 from our local machine.  

Thanks.

Regards,

Prabin

[former_member200876]

Hi Prabin


     you should Chang GUI connection setting , you should edit the new connection setting :

application server IP ( it must be new one )
Instance number . ( it should be the old one )
System ID ( it should be the old one )

BR.

M. Ezzat

[Former Member]

We have already done the SAPGUI setting as mentioned by you . 

Thanks

Prabin

[former_member200876]

Hi Prabin

try to retrieve all changes to SAP profiles  , no need to do any changes in SAP profile or Parameters

BR.

M. Ezzat

[Sriram2009]

Hi Prabin.

I think once you are change the host name at OS level, SAP system will not start. You have to perform the SAP standard System copy method (Homogeneous system Copy method) to bring another environment.

You can clone the system with same hostname and SID in the private network(Not on live network.).

Regards

SS

[former_member200876]

Hi Prabin

as i understand your OS level is Linux , first kindly you should know that SAP system depend on host name to start , so you need to do some steps before start the system again

• first change hosts ( login as root ) to the new host name

• go to network setting in Linux and change the host name from (old host name to the new host name - ( login as root )

• Then go to terminal and start sap (login as SIDadm) usinf command startsap all

BR.
M. Ezzat