Instance profile deleted accidentally

[Former Member]

HI Gurus,

I have installed a new SAP Netweaver System and while making changes to instance profile I deleted the instance profile accidentally. I know I should have taken backup of the instance profile before making changes to it but unfortunately I didnt have any backup.

Below are my system details :

OS : Red Hat 5.4

DB : MAXDB

nr : 00

I have created instance profile manually as SID_DVEBMGS00_HOSTNAME and added below parameters manually :

SAPSYSTEMNAME = SAT

SAPSYSTEM = 00

SAPGLOBALHOST = cscbpccls500

ipc/shm_psize_10 = 150000000

INSTANCE_NAME = DVEBMGS00

DIR_CT_RUN = $(DIR_EXE_ROOT)/run

DIR_EXECUTABLE = $(DIR_INSTANCE)/exe

exe/saposcol = $(DIR_CT_RUN)/saposcol

rdisp/wp_no_dia = 10

rdisp/wp_no_btc = 4

rdisp/wp_no_vb = 4

rdisp/wp_no_vb2 = 2

rdisp/wp_no_spo = 1

rdisp/wp_no_enq = 1

login/no_automatic_user_sapstar = 0

But Still dispatcher is turned off. below is the error I found in dev_disp :

DpStartStopMsg: send start message (myname is >cscbpccls500_SAT_00 <)

DpStartStopMsg: start msg sent

Warning: tmpfs at /dev/shm is configured quite small with 1972 MB!

Minimum value is 8192 MB.

Recommended size is 75 % of RAM + swap.

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

CCMS: start to initalize 3.X shared alert area (first segment).

• ERROR => DpWPCheck: W0 (pid 32337) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32337) exited with exit code 255

• ERROR => DpWPCheck: W1 (pid 32338) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32338) exited with exit code 255

• ERROR => DpWPCheck: W2 (pid 32339) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32339) exited with exit code 255

• ERROR => DpWPCheck: W3 (pid 32340) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32340) exited with exit code 255

• ERROR => DpWPCheck: W4 (pid 32341) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32341) exited with exit code 255

• ERROR => DpWPCheck: W5 (pid 32354) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32354) exited with exit code 255

• ERROR => DpWPCheck: W6 (pid 32355) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32355) exited with exit code 255

• ERROR => DpWPCheck: W7 (pid 32356) died (severity=0, status=65280) [dpxxdisp.c 15662]

child (pid=32356) exited with exit code 255

Please help in solving the error.

Thanks,

Shobhit Garg

[Former Member · Accepted solution]

Dear sap_shobhit ,

Your error shows that u have not set correct schema. set the correct schema in your instance profile. check your any other server profile and add all the parameter to your instance profile.

From,

Ketan Kapadi

[Former Member · Accepted solution]

Hi Ketan,

I understand that but We have maintained parameter dbs/ada/schema = SAPR3 but its of no help.

Iam not sure how we can check that from database level, do you have any suggestions.

Thanks

Shobhit Garg

[Former Member · Accepted solution]

You can use XUSER command to display your schema users.

[Former Member · Accepted solution]

Hi Sunil,

Yes I think that could help...But I am not aware of XUSER much...Can u tell me in details, what I need to check and how to change them to correct values. We are using MAXDB..

HI Ketan.

Congrats for your first SAP points.

Thanks,

Shobhit Garg

[Former Member · Accepted solution]

Shobhit,

xuser list

will give you list of users and dbname

Regards,

[Former Member · Accepted solution]

HI Sunil,

Below is the output for XUSER :

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPSAT

UsernameUCS2:S.A.P.S.A.T. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SAT

Nodename :cscbpccls500

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SAT

Nodename :cscbpccls500

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SAT

Nodename :cscbpccls500

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SAT

Nodename :cscbpccls500

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

Are you able to understand anythin from this..I am afraid I dont have much expertise oin MAXDB

Thanks,

Shobhit Garg

[Former Member · Accepted solution]

maintain profile parameter

dbs/ada/schema = SAPSAT and then try starting SAP

Regards,

[Former Member · Accepted solution]

Hi,

Here are the parameters

SAPSYSTEMNAME = SAT
SAPSYSTEM = 00
INSTANCE_NAME = DVEBMGS00
DIR_CT_RUN = $(DIR_EXE_ROOT)/run
DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
exe/saposcol = $(DIR_CT_RUN)/saposcol
rdisp/wp_no_dia = 10
rdisp/wp_no_btc = 3
exe/icmbnd = $(DIR_CT_RUN)/icmbnd
icm/server_port_0 = PROT=HTTP,PORT=80$$
#-----------------------------------------------------------------------
# SAP Message Server parameters are set in the DEFAULT.PFL
#-----------------------------------------------------------------------
ms/server_port_0 = PROT=HTTP,PORT=81$$
rdisp/wp_no_enq = 1
rdisp/wp_no_vb = 1
rdisp/wp_no_vb2 = 1
rdisp/wp_no_spo = 1
*rsdb/dbid = SAT*
dbs/ada/schema = SAPSAT
ssl/ssl_lib = $(DIR_EXECUTABLE)$(DIR_SEP)$(FT_DLL_PREFIX)sapcrypto$(FT_DLL)
sec/libsapsecu = $(ssl/ssl_lib)
ssf/ssfapi_lib = $(ssl/ssl_lib)
login/accept_sso2_ticket = 1
login/create_sso2_ticket = 2
ipc/shm_psize_10 = 136000000
ipc/shm_psize_40 = 112000000

I suppose you are missing rsdb/dbid = SAT

Check once !

Regards,

[Former Member · Accepted solution]

Hi Gagan Deep,

Thanks a lot man...You are CHAMP.

Really owe you, setting the parameter rsdb/dbid = SAT in instance profile worked like GEM and system is now UP and running.

Thanks again, your replies were really helpful.

Regards,

Shobhit Garg

[Former Member · Accepted solution]

HI Gagan,

While runing SGEN connection to database was lost in between and the Database is not going UP now.

Even R3trans is not returnig any output.

When I am using startdb , its howing as starting ADA and would keep showing this only.

Any sugesstions.?

Thanks,

Shobhit Garg

[Former Member · Accepted solution]

You database log file may be full, run the log backup.

Also check whether your database has enough freespace.

[Former Member · Accepted solution]

Suggestion is to change log overwriting option in max db .

Better to use DBMGUI to do this.

Regards,

[Former Member · Accepted solution]

Thanks a lot Sunil and Gagan,

Can I have the commands or the steps on how to execute that.

Thanks,

Shobhit Garg

[Former Member · Accepted solution]

TO enable tover-write on log files

dbmcli> db_execute SET LOG AUTO OVERWRITE ON

TO disable over-write on log files

dbmcli> db_execute  SET LOG AUTO OVERWRITE OFF

Regards,

[Former Member · Accepted solution]

Shobhit, You need to search for your queries before you request for help.

Follow: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/9b/9afb9035ead14b9efa7e1b1887ef98/frameset.htm

[Former Member · Accepted solution]

Hi Gagan,

In oracle as we add mpre data files and logfiles , do we have any option of doing so in MAXDb. I think rather than overwriting old logfiles we shall be able to add new ones..right???

Thanks,

Shobhit

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Read and search about DBMGUI you will get all options.

http://help.sap.com/saphelp_nwmobile71/helpdata/en/45/a6296046480039e10000000a11466f/content.htm

Now this thread is turning into tution class.

Regards,

[Former Member]

Dear Dear Shobhit Garg,

I dont know the about MAXDB much normally in latest systme schema will be sap<sid> check other profile parameter also.

From,

Ketan Kapadi

[Former Member]

Dear Shobhit Garg,

Hey try to set your shm related parameter like ipc/shm_psize_* check from your other server and try to send share related memory parameter. try to configure from other server.

From,

Ketan Kapadi

SAP BASIS Consultant

[Former Member]

Hello Ketan,

Thanks that error is removed now.

But my work processes are still dying.

Below is the log from dev_w9...remember that we are using MAXDB

• ERROR => the connected user (SAPSAT) does not work with the right user/schema

[dbslsdb.cpp 4818]

C *** ERROR => application has to work with schema SAPR3 (dbs/ada/schema)

[dbslsdb.cpp 4820]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1449]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10563]

Thanks,

Shobhit Garg

[Former Member]

Shobit,

If you have any other system in landscape you may try to copy from there and change accordingly.

And also you must have .bkp file is same directory if you have changed parameter from SAP.

Regards,

[Former Member]

Hi Gagan,

We dont have .bak file for profile as its a fresh installation and we have not changed them from SAP level.

We dont have any other systems in our landscape.

Currently our workprocesses are dying showing taht some error with schema user.

We have maintained parameter dbs/ada/schema = SAPR3 but its of no help.

Please suggest.

Thanks,

Shobhit garg