Moving SAP Content Server / SAPDB (MaxDB) 7.5.0.26 standard installation

[mohan_khedagi2]

Hi,

I am trying to move the contents of SAP Content Server/Maxdb installation from C:drive to SAN attached storage F: drive.

For which I am following OSS note 576063 and SAP document SAP Content Server in MSCS environment (May 2003 ver 1.1),which explains to do the above step before configuring for Cluster environment.

As per the note, I did following :

1.Set database to offline and stopped X server

2.Copied files to shared drive xcopy c:\sapdb F:\sapdb /s /e

3.Changed the Instance - independent data directory and configured the new work directories.

4.Unregistered the Instance root directory and registered with new Drive path

But, when I tried to register the DB root directory with the following command :

dbmcli -d SDB -u control,control db_reg -R F:\sapdb\SDB\db

it gives following error message :

Error! Connection failed to node (local) for database SDB: database instance not found

I tried with "-s" option also in the above command, gives same error message.

I would appreciate if anybody can suggest to fix this issue ?

Thanks much,

Mohan

[roland_mallmann · Accepted solution]

Hi,

if you've not already done so, please open an official SAP message on queue BC-DB-SDB.

How do the following commands return:

- dbmcli db_enum

- dbmcli inst_enum

- sdbverify (see note 546737)

Regards,

Roland

[mohan_khedagi2]

Hi,

Thanks for your response, I could fix this issue by tweaking around in the registry with the new Drive path information for this instance.This allowed me to login to database and could carry on further steps as per the document and make it work.

Regards,

Mohan

[former_member229109]

Dear Mr. Khedagi,

It's NOT recommended to change the database registry manually to avoid any further problems. Please use the installation/upgrade

Tools SDBINST/SDBUPD as it was recommended in the installation

or upgrade guides. Or DBMGUI or dbmcli tools.

-> SAP note : 767598 Available documentation

Please review my replay above, after you will run:

dbmcli -s -R F:\sapdb\SDB\db db_create SDB control,control

==> you will be able to logon as control user to the SDB database

using dbmcli or DBMGUI tool, so you will be able to run:

dbmcli -s -d SDB -u control,control db_reg -R F:\sapdb\SDB\db

Please follow the SAP note 546737, and use the sdbverify tool to check

The installed database software ( 'sdbverify -h' => review the options

Of the sdbverify tool ).

->

sdbregview -l

< list of all installed database packages/versions >

->

sdbverify --set_corrupted_invalid

< set inconsistent packages to invalid >

->

SDBINST -package "<Database Kernel>"

< run from the downloaded & unpacked MAXDB .SAR file of the current database version directory to install/register the

package which was set invalid >

->

sdbregview -l

Thank you and best regards, Natalia Khlopina

[mohan_khedagi2]

Hi Roland,

Here are the screen outputs of :

1. dbmcli db_enum

OK

So,I tried dbmcli db_enum -s

OK

.M750026 F:\sapdb\SDB\db 7.5.0.26 slow offline

.M750026 F:\sapdb\SDB\db 7.5.0.26 quick offline

.M750026 F:\sapdb\SDB\db 7.5.0.26 fast offline

2. dbmcli inst_enum

OK

7.5.0.26 F:\sapdb\SDB\db

3. Tried sdbverify (it's pretty long 😞

As per the note,got the IndepProgpath as:

C:\Documents and Settings\sapsvc>dbmcli dbm_getpath IndepProgPath

OK

C:\sapdb\programs

So,ran sbdverify from C:\sapdb\programs :

C:\sapdb\programs>sdbverify

Base 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Loader 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

PCR 7104 7.1.04.45 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Server Utilities 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

JDBC 7.6.00.00 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

PCR 7300 7.3.00.54 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

PCR 7301 7.3.01.18 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

ODBC 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

DB Analyzer 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

PCR 7240 7.2.04.17 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

PCR 7500 7.5.00.26 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

PCR 7403 7.4.03.39 32 bit in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

check rte registration of package... ok

package data is consistent

PCR 7250 7.2.05.24 in c:/sapdb/programs

-

---

check files... ok

check dependencies... ok

package data is consistent

Database Kernel 7.5.00.26 32 bit in c:/sapdb/sdb/db

-

---

check files... ok

check dependencies... ok

check rte registration of package... failed

package data is inconsistent

VERIFICATION SUMMARY:

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

INVALID PACKAGES: 0

VALID PACKAGES: 14

INCONSISTENT PACKAGES: 1

TOTAL FILES: 432

MISSED FILES: 0

MODIFIED FILES: 0

FILES WITH MODIFIED PERMISSIONS: 0

Please note that the installation had gone through successfully and we were using this instance,but now we wanted to move the contents and configuration from C: drive to SAN storage.

Appreciate if you can suggest to fix this issue...

Thanks,

Mohan

[former_member229109]

Dear Mr. Khedagi,

A)

You would like to move the contents of SAP Content Server/Maxdb installation

from C:drive to SAN attached storage F: drive.

As you wrote above, you run the following steps:

1.Set database to offline and stopped X server

-> OK

2.Copied files to shared drive xcopy c:\sapdb F:\sapdb /s /e

-> OK

3.Changed the Instance - independent data directory and configured the new work directories.

-> Please provide more details, what was done. How about data & log volumes?

< Please review the SAP note 604680, steps 11. & 12.>

4.Unregistered the Instance root directory and registered with new Drive path

But, when I tried to register the DB root directory with the following command :

dbmcli -d SDB -u control,control db_reg -R F:\sapdb\SDB\db

-> Please run first:

dbmcli -s -R F:\sapdb\SDB\db db_create SDB control,control

-> After that:

dbmcli -s -d SDB -u control,control db_reg -R F:\sapdb\SDB\db

B)

Could you please provide the information after that:

-> What outputs you will get when you will run the following commands on

the database server:

dbmcli -s inst_enum

dbmcli -s db_enum

sdbregview -l

sdbuninst -l

xinstinfo

xinstinfo SDB

dbmcli -s dbm_getpath indepdatapath

dbmcli -s -d SDB -u control,control param_getdevsall

C)

Please see the SAP note 546737.

***

You are the official SAP customer & alredy reported the same question/problem in the SAP message 790290/2006. Correct?

Thank you and best regards, Natalia Khlopina