cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Downgrade Maxdb - Please help

andre_jansevanrensburg
Explorer

on ‎11-09-2011 7:56 AM

0 Kudos

Hi all please shed some light on this issue

I am doing SAP sys copy using Backup restore.

The IM DVD i am using to run sapinst worked 100 % with version 7.6.

I recently went up to version 7.8 and now sapinst is unable to create the DB instance in the sys copy procedure.

In the sapinst i specify rdbms Version 7.6 but because my database install is allredy on 7.8 it tries to create the instance on 7.8 and fails.

Is there a way to uninstall version 7.8 run sapinst and then do the upgrade just before the restore

As per note 1469675 this is how i am supposed to do it, but the problem is that i dont get to the stage when i can upgrade ...

It tries to create the instance based on version 7.8 and fails.

Thank you for any replies

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
‎11-09-2011 9:14 AM
0 Kudos

> As per note 1469675 this is how i am supposed to do it, but the problem is that i dont get to the stage when i can upgrade ...

>

> It tries to create the instance based on version 7.8 and fails.

What installation master DVD are you using? The way describe in the note should work with the latest DVDs for you release.

Markus

Show replies
Show replies
andre_jansevanrensburg
Explorer
‎11-09-2011 9:53 AM
0 Kudos

Hi Thank you for the quick response

The IM that i am using is the one that was used when the system was installed :

SAP:ROOT-LABEL-BS200x-NW2004SSR2:700-1:IM-CD:*:AIX_PPC64

What one should i be using to do the sys copy

The system is Ecc 6.0 on AIX 5.3

Thank you

markus_doehr2
Active Contributor
‎11-09-2011 9:57 AM
0 Kudos

> The IM that i am using is the one that was used when the system was installed :

>

> SAP:ROOT-LABEL-BS200x-NW2004SSR2:700-1:IM-CD:*:AIX_PPC64

I'd try with the SR3 DVD:

51038621_1

Markus

andre_jansevanrensburg
Explorer
‎11-09-2011 11:55 AM
0 Kudos

Hi

Just tried SR 3 DVD

Still same problem

-

WARNING 2011-11-09 13:42:30.078 [syxxsyshlp.cpp:78]

syslib::printOSError(const iastring &, int, DWORD, const iastring &, CMessage::eLogMessage)

System call failed. Error 3 (No such process) in execution of system call 'getpwent' with parameter (), line (141) in file (syuxcgroup.cpp).

There is no classfactory for action:DB_CREATE Version :7.8

WARNING[E] 2011-11-09 13:42:30.215 [iaxabactorext.cpp:465]

CIaSdbActorExt::sdbSessionExecute_impl

MDB-07001 No action defined for actor.

WARNING[E] 2011-11-09 13:42:30.216

CJSlibModule::writeError_impl()

The dbmcli call for action DB_CREATE failed. SOLUTION: Check the logfile XCMDOUT.LOG.

WARNING[E] 2011-11-09 13:42:30.217

CJSlibModule::writeError_impl()

The dbmcli call for action DB_CREATE failed. SOLUTION: Check the logfile XCMDOUT.LOG.

ERROR 2011-11-09 13:42:30.640 [sixxcstepexecute.cpp:951]

FCO-00011 The step sdb_create_db_instance with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_ADA_DB|ind|ind|ind|ind|6|0|SdbPreInstanceDialogs|ind|ind|ind|ind|3|0|SdbInstanceDialogs|ind|ind|ind|ind|1|0|SDB_INSTANCE_CREATE|ind|ind|ind|ind|0|0|sdb_create_db_instance was executed with status ERROR .

markus_doehr2
Active Contributor
‎11-09-2011 11:59 AM
0 Kudos

> The dbmcli call for action DB_CREATE failed. SOLUTION: Check the logfile XCMDOUT.LOG.

>

> WARNING[E] 2011-11-09 13:42:30.217

> CJSlibModule::writeError_impl()

> The dbmcli call for action DB_CREATE failed. SOLUTION: Check the logfile XCMDOUT.LOG.

...and you put the sapdb.inf in the installation directory and restartede sapinst?

What's the content of that log?

Markus

andre_jansevanrensburg
Explorer
‎11-09-2011 12:13 PM
0 Kudos

No i don't have the .inf file in the directory.

> Subprocess starts at 20111109130853

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130855

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130924

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130925

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130927

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130928

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130928

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130928

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130928

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130928

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130928

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130929

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130929

Execute Command : /sapdb/programs/bin/dbmcli -R /sapdb/NBQ/db dbm_version

Start subprocess as user with uid: root

> Subprocess stops at 20111109130929

OK

VERSION = 7.8.02

BUILD = DBMServer 7.8.02 Build 023-121-242-871

OS = UNIX

INSTROOT = /sapdb/NBQ/db

LOGON = True

CODE = UTF8

SWAP = normal

UNICODE = YES

INSTANCE = (unknown)

SYSNAME = AIX 5.3

MASKING = YES

REPLYTREATMENT = none,zlib,auto

SDBDBM_IPCLOCATION = /var/lib/sdb/dbm/ipc

-

> Subprocess starts at 20111109130929

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130929

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130929

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130929

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130930

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130930

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130932

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130932

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130933

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130933

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130933

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130933

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130933

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130933

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130933

Execute Command : /sapdb/programs/bin/dbmcli -R /sapdb/NBQ/db dbm_version

Start subprocess as user with uid: root

> Subprocess stops at 20111109130934

OK

VERSION = 7.8.02

BUILD = DBMServer 7.8.02 Build 023-121-242-871

OS = UNIX

INSTROOT = /sapdb/NBQ/db

LOGON = True

CODE = UTF8

SWAP = normal

UNICODE = YES

INSTANCE = (unknown)

SYSNAME = AIX 5.3

MASKING = YES

REPLYTREATMENT = none,zlib,auto

SDBDBM_IPCLOCATION = /var/lib/sdb/dbm/ipc

-

> Subprocess starts at 20111109130934

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130934

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130934

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130934

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130934

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130935

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130935

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130935

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130936

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130936

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109130936

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130937

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109130958

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109130958

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109131547

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109131547

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109134227

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109134228

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

-

> Subprocess starts at 20111109134229

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas db_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109134229

OK

NBT /sapdb/NBT/db 7.8.02.23 fast offline

NBT /sapdb/NBT/db 7.8.02.23 quick offline

NBT /sapdb/NBT/db 7.8.02.23 slow offline

NBT /sapdb/NBT/db 7.8.02.23 test offline

-

> Subprocess starts at 20111109134229

Execute Command : /sapdb/programs/bin/dbmcli -n nbiqas inst_enum

Start subprocess as user with uid: root

> Subprocess stops at 20111109134229

OK

7.8.02.23 /sapdb/NBQ/db

7.8.02.23 /sapdb/NBT/db

andre_jansevanrensburg
Explorer
‎11-09-2011 12:19 PM
0 Kudos

IF i look at the .inf file

I don't see anything about version 7.8

[DB_START,7.1 7.2 7.3 7.4 7.5 7.6 7.7]

CLASS=EXECUTE

EXECUTABLE=@DBMCLI@

OPTIONS=-n @DBHOST@ -d @DBNAME@ -u @CONTROLUSER@,@CONTROLPASSWORD@ db_start

ACTOR_TYPE=INSTANCE_ACTOR_TYPE

markus_doehr2
Active Contributor
‎11-09-2011 12:26 PM
0 Kudos

So it seems you have already a database instance installed? Are you trying to do an MCOD installaton?

Markus

andre_jansevanrensburg
Explorer
‎11-09-2011 12:29 PM
0 Kudos

Hi

I am doing a SYS copy form PRD system to QAS.

So yes db instance is installed, i backup PRD database .... delete the QAS database .... and restore the PRD backup on QAS

markus_doehr2
Active Contributor
‎11-09-2011 12:35 PM
0 Kudos

> So yes db instance is installed, i backup PRD database .... delete the QAS database .... and restore the PRD backup on QAS

So you run two databases on one system.

Did you point to the MaxDB 7.6 DVD when asked?

Markus

andre_jansevanrensburg
Explorer
‎11-09-2011 12:47 PM
0 Kudos

Hi yes correct

I run NBT which i did not delete .

And i run NBQ - which is the one i am trying to recover.

While using sapinst i did point it to the 7.6 rdbms, but it does not unpack it, i think it sees the 7.8 version and tries to create the instance on 7.8 and fails

When i was on DB version 7.6 this process worked 100% many times

Only now that i am on version 7.8 i am having these problems.

markus_doehr2
Active Contributor
‎11-09-2011 1:16 PM
0 Kudos

I understand your frustration, I was dealing with likewise issues some time ago. Since MaxDB 7.8 changed the internal software structure to enable isolated installations and sapinst doesn't know about this, you have problems with those "old versions" of DVDs.

You can try the following:

- install a new database client using the maxdb-as* package using

./SDBINST
-profile "Runtime For SAP AS"
-i CL_<SID>
-private_datapath /sapdb/clients/<SID>/data
-path /sapdb/clients/<SID>

- start sapinst, select system copy and step one or two dialogs further

- stop sapinst

- put the sapdb.inf from the note to the installation directory

- restart sapinst

- "continue old installation"

Markus

Ask a Question