SAP MAXDB - livecache resotre error 4107 "conf_parameter_error"

[Former Member]

Hi,

I started Production to sanbox  SCM,system copy, we currently using online backup, we successfully recovered oracle with point int ime reovery,

for livecache, I installed new livecache server  7.6 and stared recovery using maxdb 7.8

while recovering i got below issue once recover started.

as per note i select reinitialise option and i am recovering from medium.

Notes:

129352 - Homogeneous system copy with MaxDB (SAP DB)
457425 - Homogeneous liveCache copy using backup/restore
632357 - Backing up liveCache data for SCM 4.0 or higher-

command medium_put "complete" "D:\restore\LCBackup" FILE DATA 0 8 NO NO "" NONE

        216 DBMSrv   DBM Server client connection (established at 2013-08-24 19:16:33): PID 5436 on computer ORATSTSAP001V.global.corp

        283 DBMSrv   command user_response ...

     -24946 DBMSrv   ERR_TOOMANYPARAM: too many parameters

        283 DBMSrv   command db_activate ...

0x00001428 ERR     -24988 DBMSrv   ERR_SQL: SQL error

0x00001428 ERR     -24778 DBMSrv   -9414,System error: Configuration parameter error

0x00001428 ERR     -24778 DBMSrv   17,Servertask Info: because Error in backup task occured

Regards,

Prem

[former_member188883 · Accepted solution]

Hi Premkumar,

There is one parameter file for each MaxDB instance - the currently active one.

It's the file /sapdb/data/config/<SID>.

As your current file seems to be have some problem , you may rename it and run a

param_restore 1   ( 1 - Last updated version )

to get the last backed up version of it back.

Note :If you modified the volume configuration before the file got problem and no backup version of the parameter file had been created since than,  restoring the old version will make your database unstartable.

The missing volume configuration parameters would then need to bee added manually again.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hello Deepak,

thanks for you reply, after restore, i got below issue.

i am unable to create xuser and i am not able to login from LC10, thrown an error, dbm aborted.

1. 1. Connect. test with "dbmcli db_state"                         Unsuccessful

      dbmcli_command_execute_error

      Error! Connection failed to node ORATSTSAP001V.global.corp for database LCS:

      -24691,ERR_EXIT: The DBM server must be aborted.

      -24700,ERR_DBMSRV_NOSTART: Could not start DBM server.

      -24832,ERR_SHMNOTAVAILABLE: Shared memory not available

      -24827,ERR_SHMALLOCFAILED: ID H:\sapdb\wrk\LCS.dbm.shi, requested size 2600

      10,Opening shared memory file H:\sapdb\wrk\LCS.dbm.shi failed, rc = 5.

      -24832,ERR_SHMNOTAVAILABLE: Shared memory not available

      External program terminated with exit code 2

   2. Connect. test with command mode "dbmrfc db_state"            Unsuccessful

      dbm_system_error

      Name and Server     : LCS - ORATSTSAP001V.global.corp

      DBMRFC Function     : DBM_EXECUTE

      Command             : db_state

      Error               : DBM Error

      Return Code         :         -2

      Error Message       : ERR_EXIT: The DBM server must be aborted

   3. Connect. test with session mode "dbmrfc db_state"            Unsuccessful

      dbm_system_error

      Name and Server     : LCS - ORATSTSAP001V.global.corp

      DBMRFC Function     : DBM_CONNECT

      Error               : DBM Error

      Return Code         :         -2

      Error Message       : ERR_EXIT: The DBM server must be aborted

   4. Connect. test with "native SQL"  ( LDA )                     Successful

As per SAP note, I have renamed both files into _old, but no luck.

and db state is online from command line.

after system copy , i was trying to create xuser , xuser list shows no entry and unable to create any user. it throws an error fatal

FATAL: Close xuser entry failed:

Regards,

Prem

[yashwanthkumar_kethineed · Accepted solution]

Hello Prem,

As per which SAP note you renamed (both ??) files into _old  ??

From what you posted, it looks like the liveCache IPC (interprocess communication) is not working correctly.

Do the following steps if not done yet:

• Stop the liveCache in LC10
• Look for the running x_server processes and stop them : you can stop the x_server processes with folowing commands:

        /sapdb/programs/bin/sdbgloballistener -S 7200 stop

        /sapdb/programs/bin/sdbgloballistener -S 7210 stop

• Terminatel all the liveCache kernel process own by sdb

        ps -ef   grep sdb

• Look for any dbmsrv processes and terminate them:

        ps -ef   grep dbmsrv

• Remove/rename the memory mapped files of the liveCache instance:

       rm /var/lib/sdb/dbm/ipc/*.shi  AND *.shm

• Check and make sure there is no kernel process running:

        ps -ef   grep kernel

• Check the pid files in the directory:

        /sapdb/data/pid/* and /sapdb/data/ppid/*

        If there files in there, remove them

• Check if you have enough free space in wrk directory

        df -k /sapdb/data/wrk/<instance name>

• If possible reboot the liveCache server
• After reboot start the globallistener:

        /sapdb/programs/bin/sdbgloballistener

• Start liveCache from LC10

If the liveCache is restarted without any problems in LC10, then go ahead and try creating xuser entries. See SAP note: 39439

Regards, yashwanth

[Former Member · Accepted solution]

Hi Yaswanth,

It is basically windows environment., the problem is i am not able to integrate LC10 to livecahce, i performed your steps, even though i got below error.

0x000010b0 ERR     -24832 DBMSrv   ERR_SHMNOTAVAILABLE: Shared memory not available

2013-08-26 19:40:15 0x000010b0 ERR     -24700 DBMSrv   ERR_DBMSRV_NOSTART: Could not start DBM server.

                    0x000010b0 ERR     -24832 DBMSrv   ERR_SHMNOTAVAILABLE: Shared memory not available

                    0x000010b0 ERR     -24827 DBMSrv   ERR_SHMALLOCFAILED: ID H:\sapdb\wrk\LCS.dbm.shi, requested size 2600

                    0x000010b0 ERR          6 RTEIPC   Creating shared memory file H:\sapdb\wrk\LCS.dbm.shi failed, rc = 183.

2013-08-26 19:40:15 0x000010b0 INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 4228 on computer ORATSTSAP001V.global.corp).

Regards,

Prem

[yashwanthkumar_kethineed · Accepted solution]

Hello Prem,

Which OS user are you logged in as ?

The problem could be that the OS user you logged in do not have permissions to create the shared memory file in the directory H:\sapdb\wrk\

Login as <sid>adm user and try to start the liveCache.

If you are logged in as <sid>adm user and still getting the same issue, run the program "sdbverify"

from command line and post the results. Program is located under /sapdb/programs/bin directory.

Regards, Yashwanth

[Former Member · Accepted solution]

Hello Yaswanth,

I am working on windows env, and i am unable to capture the result for sdbverify commend.

but i gave SIDadm permission to that folder, no help. it is not working. do we have anything to do.

Regards,

Prem

[yashwanthkumar_kethineed · Accepted solution]

Hello Prem,

Did you try redirecting the output to a text file ? Run

sdbverify > sdbverifyout.txt

Do no modify any permissions manually.

In the very beginning of this thread, you posted - "for livecache, I installed new livecache server  7.6 and stared recovery using maxdb 7.8" - I do not understand this statement can you give me more details on how you did the system copy ?

Regards, Yashwanth