Cannot find database in SAPMMC

[Yasin]

few days before i have modified the Instance profile and restarted SAP from SAPMMC it works fine,

after a few days we had to restart the server after that we cannot log in to the application

when i checked i cannot find the ORACLE DB in SAPMMC structure

Please advise how solve this.

[former_member185239]

Hi Yaso,

The problem is very simple. You are having a problem with your start profile or instance profile depending on the version of SAP Netweaver.

You need to make your service SAP<SID>_<xx> service to read the start or instance profile accordingly.

Open the services.msc and select the SAP<SID>_xx service , right click and click on properties.

Check the profiles which is getting used by the service. Open the profile and check the values which are responsible for starting the program.

With Regards

Ashutosh Chaturvedi

[Yasin]

Hi Ashutosh

OK what after open the profile and check the values which are responsible for starting the program !

which program

we have 3 services ,

SAPBQA_00

SAPBQA_01

SAPBQA_98

i assume our problem is on SAPBQA_00 please see attached

[former_member185239]

Hi Yaso,

Can you please attach the BQA_DVEBMGS00_sapbiqas and BQA_DVEBMGS00_sapbiqas.1

Yes , Start_program paarmeters are missing in your instance profile

With Regards

Ashutosh Chaturvedi

[Yasin]

Dear Ashutosh, files are bellow i only removed the hostname for privacy, i attached too

BQA_DVEBMGS00_sapbiqas

============================================

#parameter created

by: 10.05.2016 12:05:58

rdisp/tm_max_no = 2000

SAPSYSTEMNAME = BQA

SAPGLOBALHOST = sapbiqas

SAPSYSTEM = 00

INSTANCE_NAME = DVEBMGS00

DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

sec/libsapsecu = $(ssl/ssl_lib)

ssf/ssfapi_lib = $(ssl/ssl_lib)

DIR_CLIENT_ORAHOME = $(DIR_EXECUTABLE)

ssl/ssl_lib = $(DIR_EXECUTABLE)$(DIR_SEP)$(FT_DLL_PREFIX)sapcrypto$(FT_DLL)

PHYS_MEMSIZE = 24576

rdisp/elem_per_queue = 8000

abap/buffersize = 1000000

abap/shared_objects_size_MB = 300

rsdb/ntab/entrycount = 400000

rsdb/ntab/ftabsize = 500000

rsdb/ntab/irbdsize = 60000

rtbb/buffer_length = 120000

rsdb/cua/buffersize = 20000

zcsa/table_buffer_area = 200000000

zcsa/db_max_buftab = 20000

zcsa/presentation_buffer_area = 40000000

sap/bufdir_entries = 20000

rsdb/obj/buffersize = 100000

rsdb/obj/max_objects = 40000

icm/server_port_0 = PROT=HTTP, PORT=80$$, TIMEOUT=600, PROCTIMEOUT=1800

icm/server_port_1 = PROT=SMTP,PORT=25000,TIMEOUT=90

rdisp/wp_no_dia = 25

rdisp/wp_no_btc = 15

rdisp/wp_no_vb = 5

rdisp/wp_no_vb2 = 3

rdisp/wp_no_spo = 3

=====================================

BQA_DVEBMGS00_sapbiqas.1

================================

SAPSYSTEMNAME = BQA

SAPGLOBALHOST = sapbiqas

SAPSYSTEM = 00

INSTANCE_NAME = DVEBMGS00

DIR_CT_RUN = $(DIR_EXE_ROOT)\$(OS_UNICODE)\NTAMD64

DIR_EXECUTABLE = $(DIR_INSTANCE)\exe

sec/libsapsecu = $(ssl/ssl_lib)

ssf/ssfapi_lib = $(ssl/ssl_lib)

# *** PERMANENT 740 CHANGE ***

#DIR_CLIENT_ORAHOME = $(DIR_EXECUTABLE)

ssl/ssl_lib = $(DIR_EXECUTABLE)$(DIR_SEP)$(FT_DLL_PREFIX)sapcrypto$(FT_DLL)

PHYS_MEMSIZE = 12228

rdisp/elem_per_queue = 6000

rsdb/ntab/irbdsize = 45000

rsdb/cua/buffersize = 15000

zcsa/db_max_buftab = 15000

zcsa/presentation_buffer_area = 30000000

sap/bufdir_entries = 15000

rsdb/obj/buffersize = 75000

rsdb/obj/max_objects = 30000

rdisp/wp_no_dia = 15

rdisp/wp_no_btc = 5

rdisp/wp_no_vb = 3

rdisp/wp_no_vb2 = 2

rdisp/wp_no_spo = 2

#icm/server_port_0 = PROT=HTTP, PORT=80$$, TIMEOUT=600, PROCTIMEOUT=1800

icm/server_port_0 = PROT=HTTP, PORT=80$$, TIMEOUT=600, PROCTIMEOUT=1800

icm/server_port_1 = PROT=SMTP,PORT=25000,TIMEOUT=90

icm/host_name_full =

# *** PERMANENT 740 CHANGE ***

abap/buffersize = 800000

exe/icmbnd = $(DIR_CT_RUN)/icmbnd

#  ***  Merged from F:\Media\SUM12\abap\sapnames\START_DVEBMGS00_sapbiqas.BCK by Upgrade to 740

#.******************************************************************************************************************************

#.*                                                                                                                            *

#.*       Start profile START_DVEBMGS00_SAPBIQAS                                                                               *

#.*                                                                                                                            *

#.*       Version                 = 000001                                                                                     *

#.*       Generated by user =                                                                                           *

#.*       Generated on = 02.12.2014 , 21:30:17                                                                                 *

#.*                                                                                                                            *

#.******************************************************************************************************************************

DIR_PROFILE = \\sapbiqas\sapmnt\BQA\SYS\profile

_PF = $(DIR_PROFILE)\BQA_DVEBMGS00_sapbiqas

SETENV_00 = PATH=$(DIR_EXECUTABLE);%PATH%

#-----------------------------------------------------------------------

# Copy SAP Executables

#-----------------------------------------------------------------------

# Change for release 740

Start_Program_00 = immediate $(DIR_CT_RUN)$(DIR_SEP)sapcpe$(FT_EXE) pf=$(DIR_PROFILE)$(DIR_SEP)BQA_DVEBMGS00_sapbiqas

# Change for release 740

#Start_Program_01 = immediate $(DIR_CT_RUN)\sapcpe$(FT_EXE) pf=$(_PF)

_CPARG0 = list:$(DIR_CT_RUN)/sapcrypto.lst

# Change for release 740

#Start_Program_02 = immediate $(DIR_CT_RUN)\sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG0)

#-----------------------------------------------------------------------

# Start ABAP database

#-----------------------------------------------------------------------

_DB = $(DIR_CT_RUN)\strdbs.cmd

# Change for release 740

#Start_Program_02 = immediate $(_DB) BQA

Start_Program_03 = immediate $(DIR_CT_RUN)$(DIR_SEP)strdbs.cmd BQA

#-----------------------------------------------------------------------

# Start application server

#-----------------------------------------------------------------------

_DW = $(DIR_EXECUTABLE)\disp+work$(FT_EXE)

Start_Program_04 = local $(_DW) pf=$(_PF)

#-----------------------------------------------------------------------

# Start internet graphics server

#-----------------------------------------------------------------------

_IG = $(DIR_EXECUTABLE)\igswd$(FT_EXE)

# Start IGS

#Start_Program_05 = local $(_IG) -mode=profile pf=$(_PF)

# Start IGS

Start_Program_06 = local $(DIR_EXECUTABLE)$(DIR_SEP)igswd$(FT_EXE) -mode=profile pf=$(DIR_PROFILE)$(DIR_SEP)BQA_DVEBMGS00_sapbiqas

SETENV_01 = SECUDIR=$(DIR_INSTANCE)/sec

BQA_DVEBMGS00_sapbiqas.zip

BQA_DVEBMGS00_sapbiqas.1.zip

[former_member185239]

Hi Yaso,

You have to append the below parameters in profile  BQA_DVEBMGS00_sapbiqas from BQA_DVEBMGS00_sapbiqas.1

or rename the BQA_DVEBMGS00_sapbiqas to BQA_DVEBMGS00_sapbiqas_backup

and

BQA_DVEBMGS00_sapbiqas.1 to BQA_DVEBMGS00_sapbiqas

Take the restart of the sap services in services.msc and then you will able to see the database and node in MMC.

#.******************************************************************************************************************************

DIR_PROFILE = \\sapbiqas\sapmnt\BQA\SYS\profile

_PF = $(DIR_PROFILE)\BQA_DVEBMGS00_sapbiqas

SETENV_00 = PATH=$(DIR_EXECUTABLE);%PATH%

#-----------------------------------------------------------------------

# Copy SAP Executables

#-----------------------------------------------------------------------

# Change for release 740

Start_Program_00 = immediate $(DIR_CT_RUN)$(DIR_SEP)sapcpe$(FT_EXE) pf=$(DIR_PROFILE)$(DIR_SEP)BQA_DVEBMGS00_sapbiqas

# Change for release 740

#Start_Program_01 = immediate $(DIR_CT_RUN)\sapcpe$(FT_EXE) pf=$(_PF)

_CPARG0 = list:$(DIR_CT_RUN)/sapcrypto.lst

# Change for release 740

#Start_Program_02 = immediate $(DIR_CT_RUN)\sapcpe$(FT_EXE) pf=$(_PF) $(_CPARG0)

#-----------------------------------------------------------------------

# Start ABAP database

#-----------------------------------------------------------------------

_DB = $(DIR_CT_RUN)\strdbs.cmd

# Change for release 740

#Start_Program_02 = immediate $(_DB) BQA

Start_Program_03 = immediate $(DIR_CT_RUN)$(DIR_SEP)strdbs.cmd BQA

#-----------------------------------------------------------------------

# Start application server

#-----------------------------------------------------------------------

_DW = $(DIR_EXECUTABLE)\disp+work$(FT_EXE)

Start_Program_04 = local $(_DW) pf=$(_PF)

#-----------------------------------------------------------------------

# Start internet graphics server

#-----------------------------------------------------------------------

_IG = $(DIR_EXECUTABLE)\igswd$(FT_EXE)

# Start IGS

#Start_Program_05 = local $(_IG) -mode=profile pf=$(_PF)

# Start IGS

Start_Program_06 = local $(DIR_EXECUTABLE)$(DIR_SEP)igswd$(FT_EXE) -mode=profile pf=$(DIR_PROFILE)$(DIR_SEP)BQA_DVEBMGS00_sapbiqas

SETENV_01 = SECUDIR=$(DIR_INSTANCE)/sec

With Regards

Ashutosh Chaturvedi

[Yasin]

Dear Ashutosh

Problem solved i restored the old profile file by renaming it and it works fine

Thanks

[Yasin]

Dear Ashutosh

i didn't mark this thread as answer, i opened a new thread to reward points to u please go to link bellow and reply

[Former Member]

Hi,

please check if the ORACLE service and TNS listener services are running in your server manager, and check via sqlplus if you can access the database as SIDadm. Most likely just one of the services is not started yet...

Benedikt

[Yasin]

All oracle services are up, and the ORACLE DB is opened.