livecache 7.5 homogeneous copy to already existing maxdb 7.5

[Former Member]

I am trying to do homogeneous copy of scm4.1 system which has livecache into a system where maxdb 7.6(for content server) is already there. Can somebody suggest what changes are required for such situation.

original server:

dbmcli>version

OK

version,os,dbroot,logon,code,swap

"7.5.0","UNIX","/sapdb/TLX/db",True,ASCII,1

---

[Former Member]

With version 7.6 I understand from the note 979401: Adaptive computing with MaxDB/LiveCache can be used and the process is simplified. I am working on this method.

[former_member229109]

Hello Anantha Papagiri ,

-> Please update with more details of your project:

Source system: scm 4.1

APO database ?

liveCache version 7.5 build ?

OS of the liveCache server?

Target system:: scm 4.1

APO database ?

< liveCache version 7.5 build ? > ??

OS of the liveCache server?

The MAXDB software of the version 7.5 < or 7.4.3 > is supported for the liveCache instance in SCM 4.1

-> As I understood you correctly you would like to use the MAXDB version 7.6 for the

LVC instance in SCM 4.1. It's not supported.

Please review the liveCache homepage at https://www.sdn.sap.com/irj/sdn/livecache

-> Release-Dependent: SCM 4.1

-> You could go with your project if you will upgrade the system to SCM 5.0.

Please overview the SAP notes to see the helpful information:

1090836 Installing liveCache OneDB Server in an SCM system

1019272 Migration to liveCache OneDB Server

-> As you saw in note 979401:

"Use MacDB/liveCache as of Version 7.6.00 Build 24 in the adaptive computing environment.

"

The liveCache software of the version 7.6 is supported in SCM 5.0

The liveCache software of the version 7.7 is supported in SCM 5.1

Thank you and best regards, Natalia Khlopina

[Former Member]

With few tries, I have came back to Maxdb version 7.5.00.32. The realized that I can't restore the backup and had to install APO kernel 7.5.00.39 using SDBINST (of APO) and then only use backup/restore method 457425 The OS is AIX 5.2 in source and 5.3 in target system.

Now the database is up and running.

1) Is this procedure correct. ie Maxdb 7.5.00.32 and putting APO Kernel 7.5.00.39 over it and using APO kernel.

After doing the restore, I see that I am not able to login with users SAPR3 or SUPERDBA with default passwords.

2) For Users like SAPR3 etc are defined under Instance -> Configuration -> Database User and got transferred to the target system. But in source system using dbmcli I am able to login using SAPR3 while I am not able to login with the same method in target machine.

3) In Instance -> Configuration -> Database Administrators, I could see only one user control that I defined in the process of restore. I saw in one of the restore screens the admin user is DBADMIN being shown as user that would be restored as part of restore, but I couldn't find.

How to get these corrected so that LC10 can use the userid SAPR3 for login...

Thanks and Regards,

Giridhara

[Former Member]

Sorry I missed the last step (point 3) of the note 457425. After I did that I got the SUPERDBA & DOMAIN userid's. Now the question is about SAPR3 login through dbmcli. Not sure why it was working in source system while it was not working in the target system.

[former_member229109]

Hello Giridhara, Sorry for the delay.

A) As I understood after you run the last step (point 3) of the note 457425,

you are able to connect to the liveCache with superdba user &

in DBMGUI :: Instance -> Configuration -> Database Administrators,

you could see now two users control & superdba.

After you run::

dbmcli -d <database_name> -u <dbm_user>,<password> load_systab -u <sysdba_user>,<password> -ud <domain_user_password>

( the loading system tables could be done, when livecache is in 'online'

Or 'warm' mode. )

=> the upc files were maintained with the superdba, domain users data.

=>

You will see 3 users with the command:

dbmcli -d <database_name> -u <dbm_user>,<password> user_getall

B) The SAPR3 user is the standard liveCache user, it's SQL user & you should be able to connect to the database using SQLStudio of dbmcli command::

dbmcli -d <database_name> -u control,<password>

<enter>

dbmcli on <database_name> >sql_connect sapr3,<sapr3-pwd>

<enter>

dbmcli on <database_name> >sql_release

dbmcli on <database_name> >exit

C) Please review the SAP note 877203.

D) "Brief description of the user types'" in database is available in the SAP note 25591

&& see the documentation at

http://maxdb.sap.com/currentdoc/default.htm -> Basic Information

-> Glossary -> User ->

< -> See also: Concepts of the Database System, Users, Authentication and Authorizations < -> Changing the Passwords of Standard Users > >

Thank you and best regards, Natalia Khlopina

[former_member229109]

Hello Anantha Papagiri,

-> Please review the SAP notes for the Homogenous copy of the liveCache &&

System Landscape Copy for SAP SCM :

457425 Homogenous liveCache copy using backup/restore

877203 Post steps after the Homogenous liveCache copy

886103 System Landscape Copy for SAP SCM

->"to do homogeneous copy of scm4.1 system which has livecache into a system where maxdb 7.6(for content server) is already there."

What do you mean? You could run the System copy SCM 4.1 to SCM 4.1 & the content server is running by himself. And if you need, you could run the content server copy too using the SAP note::

129352 Homogeneous system copy with MaxDB (SAP DB)

< SAP note:: 1014782 FAQ: MaxDB system copy >

Thank you and best regards, Natalia Khlopina

[Former Member]

I hope, I didn't give proper description of the problem...

ServerB has content server 7.6.00

ServerA has SCM4.1(LiveCache7.5).

I would like to do copy of ServerA to create new Instance on ServerB which will finally have Content SErver 7.6.00 as well as SCM4.1(with Livecache 7.5).

I would like to know what things are needed tobe considered for doing this.

Regards,

Giridhara Tadikonda

[former_member229109]

Hello Giridhara Tadikonda,

If I understood you correctly, the target system and the target liveCache instance

will be installed on the server, where you have installed/run the Content server

with database instance of the version 7.6.

In general you could have two or more MAXDB database instances of the different

Versions running on the same server, if you have enough OS resources on the server

< memory, CPU … >.

See the SAP note:

327578 New software structure as of SAP DB version 7.2.4

&&

links :

http://maxdb.sap.com/currentdoc/44/118d969c471a75e10000000a1553f6/content.htm

http://maxdb.sap.com/currentdoc/87/dba841c0dae234e10000000a1550b0/content.htm

As you know the independent database software is downward compatible.

For the installation of the SCM 4.1 or liveCache please follow the SCM 4.1 & liveCache

Installation guides.

First, please review the liveCache homepage at https://www.sdn.sap.com/irj/sdn/livecache

Release-Dependent: SCM 4.1 ->

"Matrix of released OS platforms for SCM 4.1 - SAP liveCache Technology 7.5.0"

Please pay attention that to do the homogeneous liveCache copy you should have the

same OS on the source & target servers.

< See SAP note::

457425 Homogenous liveCache copy using backup/restore >

Otherwise follow the SAP note 632357

Thank you and best regards, Natalia Khlopina