on 08-12-2014 11:21 AM
Dear All,
I have changed some profile parameters in RZ10 and performed a server restart. After restart, the database instance of ABAP system is disappeared. The service SAP<SID>_00 is started normally. The ABAP instance can be showed every time when SAPMMC start. The SQL Server is working normally. The database instance of Java system is connected. Only the database of ABAP is missing. Is there any service related to the database instance need to start? Can we add back the database to it in SAPMMC?
We have already run sapstartsrv.exe to uninstall the service and re-install it again. The situation is the same. ABAP instance is list without the database. We have also replaced the file in \usr\sap\BID\SYS\profile to previous version. It still not work.
Could you please help to advise the solution? Thanks.
The root cause has been found. The Start profile contents are merged with Instance profile in the system. However, after we changed parameter by RZ10. The parameter from Start profile is missing. After add the parameter manually, the instance can start normally.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
Go to user management of windows
Change SAPServiceSID user password.
Start Services manager.
Double click on Service SAP<SID>_<inst no> may be SAP<SID>_00.
Go to Password tab (I can not say exactly what in English OS, its second
tab in Win2K and NT it will be on main screen)
Change the password to recently given password for that user.
Restart your m/c and its done, u will get ur SAP System in MMC.
check following services are running fine
OracleServiceSID
SAPOsCol
SAPSID_00
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ng,
I want to what are those parameters that have changed your MMC setting ?
Divyanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Divyanshu,
I have changed the below parameter in the system.
Parameter | Old Value | New Value |
rsdb/ntab/entrycount | 20000 | 40000 |
rsdb/ntab/ftabsize | 20000 | 60000 |
rsdb/ntab/irbdsize | 4000 | 8000 |
abap/buffersize | 800000 | 1100000 |
rsdb/cua/buffersize | 3000 | 10000 |
zcsa/presentation_buffer_area | 4400000 | 20000000 |
sap/bufdir_entries | 2000 | 10000 |
ztta/short_area | 3200000 | 4000000 |
rdisp/plugin_auto_logout | 1800 | 3600 |
rdisp/max_arq | N/A | 2000 |
gw/max_conn | 500 | 2000 |
rdisp/tm_max_no | 200 | 2000 |
rdisp/max_comm_entries | 500 | 2000 |
gw/max_sys | 1000 | 2000 |
When uninstall the Service, the BIP ABAP instance in SAPMMC and the service SAPBIP_00 in Control Panel Services is removed.
When reinstall BIP service by sapstartsrv.exe, SAPBIP_00 will be added in Control Panel Services and Status is Started. However, BIP instance in SAPMMC still does not have database instance.
Refer the SAP link to bring back the SAP MMC
Changing the Configuration of the SAP MMC - SAP Microsoft Management Console: Windows - SAP Library
BR
SS
Remove these parameters from start profile, and set them in instance profile - is start profile was used in rz10.
Now, goto smp and look at these notes
1434966 - SAP MMC Snap-In does not start all instances of a system
You might be getting some logs and info like in event viewer when you start the system, share that.
Divyanshu
Hi
You just forget it SAP MMC, you can start the SAP instance by command line and check the instance status on the task manager, you can go the exe folder of BIP just type the command to start the SAP
Start the SAP system command -
startsap name=SID nr=(Instance number) SAPDIAHOST=(IP or Remote host name)
check and tell us the status
BR
SS
Hi Sriram,
After run the command, it shows:
STARTSAP failed
Details are written to \usr\sap\BIP\DVEBMGS00\exe\startBIP.log
Here is the content of startBIP.log
running sapstart.exe name=BIP nr=00 SAPDIAHOST=<IP Address> -wait
SAPSTART finished successfully on <IP Address>_BIP_00, but at least one process doesn't run correctly:
sapstart.exe=>sapparam(1c): No Profile used.
Thanks.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.