Error in Livecache

[Former Member]

Trying to get into dbmcli and get the following error

c5f3n3:lccadm> dbmcli -d LCC -u control,control

Error! Connection failed to node (local) for database LCC:

database not found

We had some issues with this Livecache and did a sapuninst -all and re-installed everything but now I cannot connect using dbmcli or dbmgui.

If I try to do a DB setup I get this:

c5f3n3:lccadm> SDBSETUP

cannot load wxWidgets properly: Can't load './Wx.so' for module Wx: ld.so.1: SDBRUN: fatal: libgtk-1.2.so.0: open failed: No such file or directory at DynaLoader.pm line 230.

at SDB::Common::Require.pm line 114

We have no data in the Livecache so there is no impact to our business, just trying to get it fixed. Please advise if you have any input. Thanks

Message was edited by:

Doyle Tipler

[former_member229109]

Hello Doyle,

-> Did you check the uninstall log after you run

'sapuninst -all'? Was you able to uninstall the database

successfully?

-> How did you 'reinstalled everything' after that?

-> Please logon to the database server & update with the output of the following commands:

dbmcli -s inst_enum

dbmcli -s db_enum

sdbregview -l

xinstinfo LCC

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia

Here are the checks you asked for. seems like the serverdb did not get intalled.

c5f3n3:lccadm> dbmcli -s inst_enum

OK

7.6.01.05 /sapdb/LCC/db

c5f3n3:lccadm> dbmcli -s db_enum

OK

Server Utilities /sapdb/programs 7.6.01.05 64 bit valid

DB Analyzer /sapdb/programs 7.6.01.05 64 bit valid

PCR 7300 /sapdb/programs 7.3.00.55 valid

PCR 7301 /sapdb/programs 7.3.01.18 valid

PCR 7500 /sapdb/programs 7.5.00.39 64 bit valid

SAP Utilities /sapdb/programs 7.6.01.05 64 bit valid

APO LC APPS /sapdb/LCC/db/sap 5.00.008 64 bit valid

Base /sapdb/programs 7.6.01.05 64 bit valid

Redist Python /sapdb/programs 7.6.01.05 32 bit valid

JDBC /sapdb/programs 7.6.00.30 valid

Messages /sapdb/programs MSG 0.4211 valid

ODBC /sapdb/programs 7.6.01.05 64 bit valid

Database Kernel /sapdb/LCC/db 7.6.01.05 64 bit valid

Loader /sapdb/programs 7.6.01.05 64 bit valid

SQLDBC /sapdb/programs 7.6.01.05 64 bit valid

Fastload API /sapdb/programs 7.6.01.05 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.01.05 64 bit valid

PCR 7403 /sapdb/programs 7.4.03.44 64 bit valid

c5f3n3:lccadm> xinstinfo LCC

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

Installationpath of serverdb <LCC> not found!

ERR 20010 RTE Could not open file /sapdb/data/config/LCC for read, rc = 2

When we did the uninstall it showed as fine on the screen, I did not check any logs though. We just ran sdbinst to install it and chose server:client.

Thanks for your help.

[former_member229109]

Hello Doyle,

Thank you for the update.

-> How did you 'reinstalled everything' after that?

-> Please logon to the database server as root user & update with

the output of the 'sdbverify' command:

cd /sapdb/programs/bin

./sdbverify > sdbverify.txt

< check the 'sdbverify.txt' file, if you have 'inconsistent'

installed database packages. >

As I see, that the liveCache instance was not created. Correct?

Did you run the 'SDBINST' tool to reinstall the database software?

The /sapdb/data/config/LCC is the binary configuration file &

it was created by the initialization of the database parameters,

when you were creating the database instance.

As you run 'sdbuninst -all' => the database software & configuration

Files under /sapdb/data/config were deleted.

You could use DBMGUI to create the database instance.

Start DBMGUI; click 'Create' & follow the 'Next' steps.

Thank you and best regards, Natalia Khlopina

[Former Member]

sdbverify shows everything consistent.

When I tried to create the DB insance using DBMGUI it doesnt seem to like any logon info I give it. I tried both control and superdba with their default passwords. Does the instance not get created when you run sapinst? I'll look for a note on creating an instance to see if I'm doing it incorrectly.

[Former Member]

I got the right user this time and am creating the instance. If I do a restore from a previous backup, will it restore all the data volumes and log volumes config's or do I need to re-do the config as well?

[former_member229109]

-> What version of the DBMGUI do you have?

->> Please give answer on the question :

How did you 'reinstalled everything'?

Did you use 'SDBINST' tool?

-> Could you please update with 'VERIFICATION SUMMARY' of the 'sdbverify' run?

***

You started DBMGUI ( version? ), run 'create', -> Next,

'Blank'+next ->

Database server < type name >

Database name <Name >

Then you asked the logon user/pwd ( Logon information for Server )

-> Did you pass this step?

Thank you and best regards, Natalia Khlopina

[former_member229109]

-> "If I do a restore from a previous backup,..."

Did you run the liveCache instance of the version 7.6.01 build 05 & a previous data backup was created before you uninstalled the liveCache?

If you have created the data backup of the liveCache version 7.6.01 build 05 => You could use it.

And at the 'Parameter Initialization' step => select 'restore parameters from a backup medium' ...

-> Is it answer on the next posted question?

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

DBMGUI version 7.6

YEs, I used the sdbinst tool.

sdbverify summary

VERIFICATION SUMMARY:

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

INVALID PACKAGES: 0

VALID PACKAGES: 18

INCONSISTENT PACKAGES: 0

TOTAL FILES: 366

MISSED FILES: 0

MODIFIED FILES: 0

FILES WITH MODIFIED PERMISSIONS: 0

Ok, I was able to create the instance, so yes I got past the step in your question. Now all I have left is to get the users created. There is no superdba or control user currently.

[former_member229109 · Accepted solution]

1) Did you have the data backup of the liveCache version 7.6.01 build 05,

which you used to recreate the LCC liveCache instance using DBMGUI?

2) "There is no superdba or control user currently."

What do you mean?

What user/pwd did you use when you was asked by the Create

database Instance Wizard for the 'DataBase Manager Operator'?

Thank you and best regards, Natalia Khlopina

[Former Member]

We did have the backup and used it.

Well, at first these users did not exist. When I tried to dbmcli connect using superdba or control, it would not work. Then I ran db_activate superdba,admin and that worked so I loaded the systab.

The problem know is my dbm user is saplcc and I want it to be control. As I stated earlier I could not create the instance using those ID's so I used saplcc. Now it seems that may have been a mistake. Is there any way to do a switch on the dbm user? When I connect using dbmgui I cannot use control user.

I have been using note 25591 as a guide.

[former_member229109]

SAP Standard Users in liveCache::

dbm ( Database Manager operator ) user - CONTROL( default password - control );

SYSDBA (UserDatabase System Administrator) User - SUPERDBA ( default password - admin);

Database administrator for the SAP system with the ID <SAPSID>

(database user of the type DBA) - SAP<SAPSID> ( default password - sap);

-> Please update the ticket with output of the SQL statement:

select * from users

< You could start the liveCache in online as DBM user ( saplcc in

your case ) & use the SQLStudio, logon as superdba user. >

Thank you and best regards, Natalia Khlopina

[Former Member]

Here is the output

dbmcli on LCC>sql_execute select * from users

OK

END

'SAPLCC';'';'SAPLCC';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20070116';'00151734';'

20070116';'00151734';'20070116';'00151734';'LCC';'c5f3n3';0;'NO';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20070116';'001517

33';'20070116';'00151742';'20070116';'00151733';'LCC';'c5f3n3';10;'NO';(null)

[former_member229109]

Please run on the c5f3n3 server:

1)

dbmcli -d LCC -u saplcc,<pwd> db_offline

dbmcli -d LCC -u saplcc,<pwd> db_drop

2)

mv /sapdb/data/config/LCC.upc /sapdb/data/config/LCC.upc.old

mv /sapdb/data/wrk/LCC/dbm.upc /sapdb/data/wrk/LCC/dbm.upc.old

3)

dbmcli -s -R /sapdb/LCC/db db_create LCC control,control

4)

dbmcli -s -d LCC -u control,control db_state

dbmcli -d LCC -u control,control

<enter>

dbmcli on LCC>db_admin

dbmcli on LCC>db_activate superdba,admin

...

< load the system tables when liveCache will be online... >

dbmcli on LCC>load_systab -u superdba,admin

• Please update with results.

• See Note 767598 for information about the location of the MaxDB/liveCache

documentation.

Regards, Natalia Khlopina

[Former Member]

I got up to the 3rd line of step 4) and got an error:

c5f3n3:lccadm> dbmcli -d LCC -u control,control

dbmcli on LCC>db_admin

ERR

-24994,ERR_RTE: Runtime environment error

1,Check knldiag! Kernel died before reaching ADMIN state (OS error code 11000)

[former_member229109]

-> Check the errors in knldiag & knldiag.err files.

[Former Member]

strange, I can't seem to find the knldiag file. There is no LCC directory under /sapdb/data/wrk. I did find this path /sapdb/data.orig/wrk/LCC. Seems like some pointers were messed up at some point or something, but those files don't show me anything after yesterdays' date. So nothing from today.

Any thoughts?

[former_member229109]

Check & update with output of the following commands:

dbmcli -d LCC -u control,control param_directget RUNDIRECTORY

xinstinfo LCC

-> How you was able to run ?:

mv /sapdb/data/wrk/LCC/dbm.upc /sapdb/data/wrk/LCC/dbm.upc.old

[Former Member]

I get:

c5f3n3:lccadm> dbmcli -d LCC -u control,control param_directget RUNDIRECTORY

ERR

-24979,ERR_XPNOTFOUND: parameter not found

c5f3n3:lccadm> xinstinfo LCC

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/LCC/db

ERR 20010 RTE Could not open file /sapdb/data/config/LCC for read, rc = 2

I was not able to run that mv command because the files were not there. Sorry, meant to ask about that too. I thought maybe the db_drop deleted it.

[former_member229109]

Yes, after 'db_drop' command the configuration files of the database

instance will be lost. But after you run the recommended command:

dbmcli -s -R /sapdb/LCC/db db_create LCC control,control

=> You should be able to logon to the created liveCache instance

LCC ( which has to be listed with 'dbmcli -s db_enum' command)

as control user.

You should have the User container file /sapdb/data/config/LCC.upc

=> Now you should be able to use the DBMGUI to create the liveCache

instance. When you will be asked the DataBase Manager Operator

please use control user & control password.

Then run 'Parameter Initialization' step. After parameters will be

initialized /sapdb/data/config/LCC file will be created.

And you could finish the database creation using DBMGUI.

[Former Member]

I can connect to dbmcli with control user, but when I go to DBMGUI to create the DB I try using control user in the initial screen that asks for "Login information for Server" as control and it gives me error:

24875 The OS user is not a member of the database admin user group [user_system]

Is the Login information the DBM Operator? This is where I through I went wrong last time. I do see the LCC.upc file where you stated but cannot read it.

[former_member229109]

When you go to DBMGUI to create the database &

in the initial screen that asks for "Login information for Server"

< I already wrote you from the beginning:

"You started DBMGUI ( version? ), run 'create', -> Next,

'Blank'+next ->

Database server < type name >

Database name <Name >

Then you asked the logon user/pwd ( Logon information for Server )

-> Did you pass this step?" ... I didn't get answer from you. >

=> you need to give the OS logon user/pwd, as I wrote you before.

If you installed the database software & owner of the database is sdb with group sdba ( by default ) => You need user in sdba group, which could run the

Database administration on the server. Please check the file /etc/opt/sdb

=> You will see the SdbOwner & SdbGroup, please check, if 'lccadm' user in

'SdbGroup' & use it for "Login information for Server".

[Former Member]

I thought I had answered that question already. Previously I was able to get past that screen by entering lccadm as user and it worked. This time I am not able to get past that becasue I do not know what login info to provide it.

When I check that sdb file it shows this:

[Globals]

IndepData=/sapdb/data

IndepPrograms=/sapdb/programs

SdbOwner=sdblcc

SdbGroup=sdb_np

Does this mean I should use sdblcc? I do not know the logon info for this user "sdblcc" as it is always locked.

[former_member229109]

Please check, that 'lccadm' user in sdb_np group & use it for "Login information for Server", as I wrote you above. I saw, that you was able to logon as user lccadm.

[Former Member]

ok, I hve done that. I used lccadm

Now it is asking me to initialize. I say yes based off your earlier answer?

[former_member229109]

Ok, the next step you will see:

Initialize the database instance '<server>:LCC'

-> Check the box -> click next

Database Manager Operator:

User Name: control

Password : Control

<Next>

Parameter Initialization:

Initialize parameters with default values

Or

Restore parameters from backup medium

< I understood, you could choose the

'Restore parameters from backup medium'. Correct? >

=> So check it + Next

Create medium, then select it + Next

Adjust Parameters

< check the settings + Next >

Volumes

< check settings + next

Creation Mode

?? Would you like create instance for recovery

or

Create and start instance ??

If you would like to check 'Create and start instance'

=> Use DBA user

user Name superdba

Password: admin

C. Pwd : admin

--> Next

[Former Member]

ok, I have done as you stated and am currently waiting on window where it is still

"activating the db instance..." It has been saying that for over 30 minutes. I'll wait to see if it stops on it's own.

Once that is complete, do I still need to do this from your previous message:

dbmcli on LCC>db_activate superdba,admin

...

< load the system tables when liveCache will be online... >

dbmcli on LCC>load_systab -u superdba,admin

[former_member229109]

1)

If you checked 'Create and start instance' with

user Name superdba

Password: admin

C. Pwd : admin

==> Then you are running 'db_activate superdba,admin' now.

< You could check the database logs dbm.prt & knldiag, and also use 'x_cons' tool for monitoring. For example, run 'x_cons LCC sh io' with period 1min & see the results. Run 'x_cons <LC-name> help' or see the documentation about

x_cons - database tool at http://dev.mysql.com/doc/maxdb/ >

2)

When it's will be done, please load system tables with command

dbmcli -d LCC -u control,control load_systab -u superdba,admin

3)

Please let me know where ( or how ) you are going to use this liveCache Instance? I need answer on this question to give you further steps.

[Former Member]

Thanks you, I see it move and now it completed that so I am loading systab.

This livecache is for our Consolidation system so I will check integration with system (need to create saplcc user) to ensure the system can talk to it. Is there anything I need to do additional to this?

Message was edited by:

Doyle Tipler

[former_member229109]

Please review the SAP Note No. 877203, if you will do the Homogenous liveCache copy using backup/restore < note 457425 >.

Please review the SAP note:

886103 System Landscape Copy for SAP SCM

Question: How are going to create the Consolidation system or it was already

created?

• To make sure that the lcinit script works with the correct user 'SAPLCC' you should run the commands to check the liveCache user in the upc container:

dbmcli -d LCC -u control,control

dbmcli on LCC>sql_execute user-type=SAP select user from dual

< ... Should return this user.

When an error returns ( unkown user/password ),then no user is set. >

To set the 'SAPLCC' user run on the liveCache server:

dbmcli -d LCC -u control,control user_sap saplcc,sap

• Please review the SAP Note No. 640107 & 305634.

If it's brand new installation & you created the productive client, in which you have active Planning version. For the LCA connection in the "Postprocessing" field of the "Initialize liveCache" subarea of the "Administration reports" tab, enter the report name "/SAPAPO/DELETE_LC_ANCHORS" < Please read SAP Note No. 640107 with attention. >.

Please review the document at service.sap.com/scm -> mySAP SCM Technology -> Information on SCM 4.1 and prior releases

Information on SCM 4.1 and prior releases you will find <here>.

-> Click on <here> -> Backup and Recovery ->

"Checklist for Initialization of SAP APO liveCache"

• Setup the LCA/LDA/LEA connections correctly in LC10-Integration.

Run initialization of the liveCache in LC10 transaction using LCA connection. The lcinit script will be running with 'Init' & saplcc user will be created in liveCache, as one of the steps of the liveCache initialization in LC10 transaction, you could see it in the lcinit.log after the LC initialization will be finished.

For SAP liveCache documentation in English:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/0271f49770f0498d32844fc0283645/frameset.htm

-> Database Administration in CCMS: SAP liveCache -> liveCache Assistant

-> liveCache: Monitoring -> Administration -> Operating -> Initialize liveCache

Message was edited by:

Natalia Khlopina

[Former Member]

Ok, that was what I needed. The livecahce is up and running and om13 is clean (all green). Thanks a bunch for your help. You have the answers as always!