Uninstalling MaxDB

Hello,

sorry for the late response.

It seems that there are still database instances registered on your server.

Please run this command in a dos-box to find out what is installed:

dbmcli inst_enum

dbmcli db_enum

inst_enum just writes out the installed software.

db_enum writes out database instances which are on the host.

To get rid of the database instances you can run this command:

dbmcli -d DB1 -u control,control db_stop

dbmcli -d DB1 -u control,control db_drop

DB1 has to be replaced by the true database name.

Hope that helps,

Stefan

Hi,

I have the same problem and this is what I get when I do what you recommend: -

Microsoft Windows 2000 [Version 5.00.2195]

(C) Copyright 1985-2000 Microsoft Corp.

H:\>cd c:

C:\

H:\>c:

C:\>dbmcli inst_enum

'dbmcli' is not recognized as an internal or external command

operable program or batch file.

Hello,

that only means that dbmcli is not in your PATH variable.

The standard path on Windows is \sapdb\programs\pgm

dbmcli should be in that folder.

Best regards, Stefan

Hello,

I assume it might have something to do with the directory C:\program files\....

Maybe the installer cannot handle this directory right.

When you sort the installation directory after date and time which files was updated at last ?

Please paste the last lines from sapinst_dev.log into this case.

Best regards, Stefan

Hello,

it seems to stop/hang in this phase:

DatabaseSchemaOperations|ind|ind|ind|ind|ind|0|CreateDbSchema

In this phase the database schema ( SQL user ) is created inside of the database.

That means the database has to be up and in Online mode.

Please run these commands to check wether this is the case or not:

In a dos-box

c:\sapdb\programs\pgm\dbmcli db_enum

c:\sapdb\programs\bin\x_cons DJ1 show state

c:\sapdb\programs\bin\x_cons DJ1 show ac

Please paste the output into this case.

Is there a file called XCMDOUT.log in the installation directory or in the directory c:\sapdb\programs\pgm\ ?

if so please paste the last lines also into this case.

Best regards, Stefan

Hello,

I don't think it has something to do with the Operating system.

Please restart the installation.

It should start hanging imediately right ?

When it hangs run the statement again:

c:\sapdb\programs\bin\x_cons DJ1 show ac

Then we can see if something is going on in the database.

Check then also again the file xcmdout.log.

It is also possible to create the user by hand and then set the step to ok. But this should be our next step.

Best regards, Stefan

Hello,

this looks also strange to me.

I would suggest to create the user by hand. Then we will see if the installation continues.

To create the user by hand proceed as follows:

1.) Stop SAPINST.

2.) Run this command in a dos-box

dbmcli -d DJ1 -u control,control -uSQL superdba,admin sql_execute create user sapdj1db password sap dba not exclusive defaultcode unicode

When this was succesfull start sapinst with the option :

...\sapinst.exe SAPINST_SKIP_ERRORSTEP=true

inside of the installation directory.

Hope that helps,

Stefan

Hello,

the password I gave you ( sap ) was just some kinde of a default password. In general the password which is used for the user sap<sid>db should be the password which was asked at the beginning of the installation. There was a "general password". This password should be used here.

You can change the password with this command:

dbmcli -d DJB -u control,control -uSQL superdba,admin sql_execute alter password sapdjbdb <new password>

Then try to continue with the installation.

Best regards, Stefan

Hello,

yes there are problems with special characters.

In the maxDB environment druing the installation we had them most of the times during the creation of the user since the password is not quoted.

That is the reason why I didn't come up with that. But good to know.

Thank you for the information.

Best regards, Stefan

Hello,

I came across this thread while searching for some answers. I tried installing the same package and encountered some problems. Then I upgraded the RAM from 1Gb to 1.5Gb, sucessfully uninstalled the whole thing (thanks to the tips on this forum) and tried reinstalling from scratch. But I am getting stuck at "Load Java Database Content". I don't see an error but it's sitting there for more than 100 minutes (Installation Progress: The task is running). It says "INFO: table CAF_RT_TYPMMP created" on the status bar at the bottom of the installation window.

<b>If I click on "Log View" I see the following (tail):</b>

PHASE 2006-02-21 14:42:09

JLoad Run

INFO 2006-02-21 14:42:14

Copying file C:/Documents and Settings/Neela Kumar/My Documents/My Received Files/NetWeaverFiles/NWInstall/NWSneakPreviewSP15/SneakPreviewContent/JDMP/IMPORT.XML to: C:/Program Files/sapinst_instdir/NW04SR1/WEBAS_COPY/ONE_HOST.

INFO 2006-02-21 14:42:14

Copying file C:/Documents and Settings/Neela Kumar/My Documents/My Received Files/NetWeaverFiles/NWInstall/NWSneakPreviewSP15/SneakPreviewContent/JDMP/IMPORT.XML to: C:/Program Files/sapinst_instdir/NW04SR1/WEBAS_COPY/ONE_HOST.

INFO 2006-02-21 14:42:14

Creating file C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST\IMPORT.XML.

INFO 2006-02-21 14:42:21

Creating file C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST\jload.java.log.

INFO 2006-02-21 14:42:21

Working directory changed to C:/usr/sap/J2E/JC00/j2ee/sltools.

INFO 2006-02-21 14:42:21

Working directory changed to C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST.

INFO 2006-02-21 14:42:21

Output of C:\j2sdk1.4.2_10/bin/java.exe '-classpath' './sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;c:\sapdb\programs\runtime\jar\sapdbc.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jce.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/w3c_http.jar' '-Duser.timezone=Europe/Berlin' '-showversion' '-Xmx512m' 'com.sap.inst.jload.Jload' '-sec' 'J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key' '-dataDir' 'C:/Documents and Settings/Neela Kumar/My Documents/My Received Files/NetWeaverFiles/NWInstall/NWSneakPreviewSP15/SAP_NetWeaver_04_SR_1_Installation_Master\IM01_NT_I386\..\..\SneakPreviewContent\JDMP' '-job' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/IMPORT.XML' '-log' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.log' is written to the logfile C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.java.log.

-

<b>sapinst_dev.log file has the following (tail):</b>

TRACE [iaxxcwalker.cpp:296]

CDomWalker::processStep()

Executing installation step J2EE_SystemCopy_OneHost|ind|ind|ind|WebAS|640|0|J2EE_SystemCopy|ind|ind|ind|ind|ind|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|J2EE_SERVER_CORE|ind|ind|ind|ind|ind|0|JloadRun|ind|ind|ind|ind|ind|0|removeSTAfiles

TRACE [iaxxccntrl.cpp:493]

CController::stepExecuted()

The step removeSTAfiles with key J2EE_SystemCopy_OneHost|ind|ind|ind|WebAS|640|0|J2EE_SystemCopy|ind|ind|ind|ind|ind|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|J2EE_SERVER_CORE|ind|ind|ind|ind|ind|0|JloadRun|ind|ind|ind|ind|ind|0|removeSTAfiles has been executed successfully.

TRACE [iaxxcwalker.cpp:296]

CDomWalker::processStep()

Executing installation step J2EE_SystemCopy_OneHost|ind|ind|ind|WebAS|640|0|J2EE_SystemCopy|ind|ind|ind|ind|ind|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|J2EE_SERVER_CORE|ind|ind|ind|ind|ind|0|JloadRun|ind|ind|ind|ind|ind|0|runJava

TRACE [synxccuren.cpp:780]

CSyCurrentProcessEnvironmentImpl::getEffectiveUser(iastring&)

effective user corresponds to real user

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

nodeType: 'UNKNOWN'

INFO 2006-02-21 14:42:21 [synxcpath.cpp:834]

CSyPath::createFile()

Creating file C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST\jload.java.log.

TRACE [synxctask.cpp:66]

CEnvironmentJanitor::CEnvironmentJanitor()

Changing current processenvironment

INFO 2006-02-21 14:42:21 [syxxccuren.hpp:347]

CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(iastring)

Working directory changed to C:/usr/sap/J2E/JC00/j2ee/sltools.

TRACE [synxctask.cpp:85]

CEnvironmentJanitor::~CEnvironmentJanitor()

Restoring current processenvironment

INFO 2006-02-21 14:42:21 [syxxccuren.hpp:347]

CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(iastring)

Working directory changed to C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST.

INFO 2006-02-21 14:42:21

CJSlibModule::writeInfo_impl()

Output of C:\j2sdk1.4.2_10/bin/java.exe '-classpath' './sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;c:\sapdb\programs\runtime\jar\sapdbc.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jce.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/J2E/SYS/global/security/lib/tools/w3c_http.jar' '-Duser.timezone=Europe/Berlin' '-showversion' '-Xmx512m' 'com.sap.inst.jload.Jload' '-sec' 'J2E,jdbc/pool/J2E,C:\usr\sap\J2E\SYS\global/security/data/SecStore.properties,C:\usr\sap\J2E\SYS\global/security/data/SecStore.key' '-dataDir' 'C:/Documents and Settings/Neela Kumar/My Documents/My Received Files/NetWeaverFiles/NWInstall/NWSneakPreviewSP15/SAP_NetWeaver_04_SR_1_Installation_Master\IM01_NT_I386\..\..\SneakPreviewContent\JDMP' '-job' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/IMPORT.XML' '-log' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.log' is written to the logfile C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_COPY\ONE_HOST/jload.java.log.

-

<b>XCMDOUT.log has the following (tail):</b>

> Subprocess stops at 20060221131543

OK

State

ONLINE

-

> Subprocess starts at 20060221131546

Execute Command : c:\sapdb\programs\pgm\dbmcli.exe -n VARSHA -d J2E -u CONTROL,******** db_online

Execute Session Command : exit

> Subprocess stops at 20060221131546

OK

-

> Subprocess starts at 20060221131548

Execute Command : c:\sapdb\programs\pgm\dbmcli.exe -n VARSHA -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : sql_execute SELECT KERNEL FROM DOMAIN.VERSIONS

Execute Session Command : exit

> Subprocess stops at 20060221131549

OK

OK

END

'Kernel 7.5.0 Build 018-123-079-776'

-

> Subprocess starts at 20060221131550

Execute Command : c:\sapdb\programs\pgm\dbmcli.exe -n VARSHA -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : sql_execute SELECT VALUE FROM DBPARAMETERS WHERE DESCRIPTION='_UNICODE'

Execute Session Command : exit

> Subprocess stops at 20060221131551

OK

OK

END

'YES'

-

> Subprocess starts at 20060221131555

Execute Command : c:\sapdb\programs\pgm\dbmcli.exe -n VARSHA -d J2E -u CONTROL,********

Execute Session Command : sql_connect SUPERDBA,********

Execute Session Command : sql_execute CREATE USER SAPJ2EDB PASSWORD ******** DBA NOT EXCLUSIVE DEFAULTCODE UNICODE

Execute Session Command : exit

> Subprocess stops at 20060221131555

OK

OK

-

<b>Checked the x_cons on the DB and is as follows:</b>

C:\sapdb\programs\bin>x_cons J2E show ac

SERVERDB: J2E

ID UKT Win TASK APPL Current Timeout Region Wait

tid type pid state priority cnt try item

C:\sapdb\programs\bin>x_cons J2E show state

SERVERDB: J2E

The SERVERDB state is ONLINE

C:\sapdb\programs\bin>

I would appreciate some help.

Regards,

Kalyan