Skip to Content
author's profile photo Former Member
Former Member

MaxDB Upgrade, unable to establish DB instance session

Hi all, I am trying for to perform a SAP DB upgrade from 7.3.0.28 to version 7.5.0.21. My problem is that when I execute command SDBUPD the following messages appear on screen almost immediately and the update is terminated:

beginning to check sap db instances

start new instance update

cannot establish database instance session

I followed the instructions in the upgrade guide and notes mentioned but this issue is nowhere mentioned. I am not a database specialist so any help and/or suggestions are more then welcome.

Thanks in advance, Tiest

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    Posted on Jan 17, 2005 at 09:35 AM

    Dear Tiest,

    it seems there's a problem with your X_server (also called Vserver). It sounds like the VServer process is hanging. To check, you could either try:

    - stopping and restarting the Vserver (using: 'x_server stop' and 'x_server start')

    - to connect to localhost using dbmcli: 'dbmcli -n localhost -d <SID> -u <dbm-user>,<password>'

    If both don't work, you might need to perform the steps provided by OSS/CSS note 786635.

    Hope that helps.

    Regards,

    Roland

    P.S. Please also state the operating system (OS) you're using in your answer.

    Message was edited by: Roland Mallmann

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Tiest,

      apparently you stopped the database without checkpoint last time. I suggest you do the following before trying SDBUPD again:

      1. Move the database into OFFLINE mode:

      dbmcli -n localhost -d BSP -u control,control db_offline

      2. Move the database into COLD mode:

      dbmcli -n localhost -d BSP -u control,control db_cold

      3. Make a full data backup (for migration) in the COLD mode, using the Database Manager GUI.

      Regards,

      Roland

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2005 at 10:26 AM

    Roland, found it! When accessing the x_server properties the log on tab says: Local system account. Not able to change that, now what? Tiest

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2005 at 08:29 PM

    Hi,

    I am having the similar problem with the following error.

    C:\WINDOWS\system32>dbmcli -d J2E -u control,control db_stop

    Error! Connection failed to node (local) for database J2E: dbmsrv executable n

    found

    C:\WINDOWS\system32>dbmcli -d J2E -u control,control db_drop

    Error! Connection failed to node (local) for database J2E: dbmsrv executable n

    found

    C:\WINDOWS\system32>dbmcli -d J2E -u control,control db_offline

    Error! Connection failed to node (local) for database J2E: dbmsrv executable n

    found

    C:\WINDOWS\system32>

    Is there a way to completey drop the instance and start with new installation?

    thanks a lot

    --Satya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 02, 2005 at 08:37 PM

    Hello,

    this message just means that the dbmsrv.exe executable doesn't exist.

    When you run dbmcli -s db_enum

    You get the INSTROOT Path like c:\sapdb\J2E\db

    under c:\sapdb\J2E\db\pgm\ there should be a file dbmsrv.exe.

    Is it there ?

    You can run sdbverify to check your installation.

    Best regards, Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Stefan.

      I got this problem beause J2E was installed with older MaxDB version and I was trying to install EP which has newer MaxDB version. Andy things went bad from there.

      Can I just drop the whole J2E db and start from scratch?

      Here is the output of sdbverify.

      check dependencies... ok

      check rte registration of package... ok

      package data is consistent

      Database Kernel 7.5.00.07 32 bit in c:/sapdb/j2e/db

      -


      check files... failed

      c:/sapdb/j2e/db/env/QP.py not found

      c:/sapdb/j2e/db/sap/sphsapdb.dll not found

      c:/sapdb/j2e/db/bin/ireport.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/sqlver.map not found

      c:/sapdb/j2e/db/misc/drop_demo_db.cmd not found

      c:/sapdb/j2e/db/Support/Mapfiles/sqlwhat.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/tracesort.map not found

      c:/sapdb/j2e/db/cluster/sapdbmscsman.dll not found

      c:/sapdb/j2e/db/doc/FirstSteps/Perl/StateSAPDB.pl not found

      c:/sapdb/j2e/db/sap/sphsapdb.lst not found

      c:/sapdb/j2e/db/doc/FirstSteps/Python/demodbData.py not found

      c:/sapdb/j2e/db/env/kernprot.use not found

      c:/sapdb/j2e/db/pgm/libSQLDBC.dll not found

      c:/sapdb/j2e/db/misc/create_demo_db.cmd not found

      c:/sapdb/j2e/db/doc/FirstSteps/sapdbenv.cmd not found

      c:/sapdb/j2e/db/misc/SAP/DBTech/dbm.pm not found

      c:/sapdb/j2e/db/env/installib.py not found

      c:/sapdb/j2e/db/env/WA.py not found

      c:/sapdb/j2e/db/symbols/tracesort.pdb not found

      c:/sapdb/j2e/db/cluster/stop_clu.exe not found

      c:/sapdb/j2e/db/doc/FirstSteps/Precompiler/Makefile.mak not found

      c:/sapdb/j2e/db/env/PRECOM.py not found

      c:/sapdb/j2e/db/misc/puclst.exe not found

      c:/sapdb/j2e/db/doc/FirstSteps/Perl/HowToPerl.html not found

      c:/sapdb/j2e/db/symbols/systemrc.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/sql_run.map not found

      c:/sapdb/j2e/db/pgm/diagnose.exe not found

      c:/sapdb/j2e/db/symbols/dbmsrv.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/get_page.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/pchtab.map not found

      c:/sapdb/j2e/db/symbols/sapdbmscsman.pdb not found

      c:/sapdb/j2e/db/doc/FirstSteps/Perl/demodbData.pm not found

      c:/sapdb/j2e/db/doc/FirstSteps/ODBC/HowToODBC.html not found

      c:/sapdb/j2e/db/Support/Mapfiles/pu.map not found

      c:/sapdb/j2e/db/env/DBMVIEWS.py not found

      c:/sapdb/j2e/db/misc/sapdb/pythondef/dbm.pyd not found

      c:/sapdb/j2e/db/Support/Mapfiles/dbpinstall.map not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/StateSAPDB.java not found

      c:/sapdb/j2e/db/lib/python1.5/cmd.py not found

      c:/sapdb/j2e/db/env/XDDCOM.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/dbmsrv.map not found

      c:/sapdb/j2e/db/misc/pchtab.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/odbcreg.map not found

      c:/sapdb/j2e/db/pgm/libsqlcls.dll not found

      c:/sapdb/j2e/db/symbols/sysrc.pdb not found

      c:/sapdb/j2e/db/symbols/serv-clu.pdb not found

      c:/sapdb/j2e/db/pgm/pysapdb.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/sapdbmscsman.map not found

      c:/sapdb/j2e/db/pgm/sqlinst.dll not found

      c:/sapdb/j2e/db/pgm/quickknl.exe not found

      c:/sapdb/j2e/db/pgm/TableDefC.dll not found

      c:/sapdb/j2e/db/bin/sqlver.exe not found

      c:/sapdb/j2e/db/misc/sapdb/dbapi.py not found

      c:/sapdb/j2e/db/sap/updcol.exe not found

      c:/sapdb/j2e/db/symbols/sqlinst.pdb not found

      c:/sapdb/j2e/db/lib/python1.5/optlib.py not found

      c:/sapdb/j2e/db/symbols/kernel.pdb not found

      c:/sapdb/j2e/db/misc/repman.py not found

      c:/sapdb/j2e/db/lib/python1.5/UserList.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/service-clu.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/diagnose.map not found

      c:/sapdb/j2e/db/lib/python1.5/posixpath.py not found

      c:/sapdb/j2e/db/env/cserv.pcf not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/HelloSAPDB.java not found

      c:/sapdb/j2e/db/symbols/liboms.pdb not found

      c:/sapdb/j2e/db/cluster/SAPDBMSCSEx.dll not found

      c:/sapdb/j2e/db/misc/sapdb/loader.py not found

      c:/sapdb/j2e/db/pgm/StudioUtil.dll not found

      c:/sapdb/j2e/db/env/CNR3TAB.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/sqlfilter.map not found

      c:/sapdb/j2e/db/env/de/ODBCM.de not found

      c:/sapdb/j2e/db/misc/sapdb/__init__.py not found

      c:/sapdb/j2e/db/misc/sapdb/pythondef/loader.pyd not found

      c:/sapdb/j2e/db/symbols/sqlrun.pdb not found

      c:/sapdb/j2e/db/pgm/strt.exe not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/HelloSAPDB.class not found

      c:/sapdb/j2e/db/pgm/backup.exe not found

      c:/sapdb/j2e/db/cluster/serv_clu.exe not found

      c:/sapdb/j2e/db/env/en/ODBCM.en not found

      c:/sapdb/j2e/db/lib/python1.5/re.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/ODBC/Makefile.mak not found

      c:/sapdb/j2e/db/symbols/sqlfilter.pdb not found

      c:/sapdb/j2e/db/pgm/dbmext.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/kernel.map not found

      c:/sapdb/j2e/db/pgm/tracesort.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/liboms.map not found

      c:/sapdb/j2e/db/env/en/SQLM.en not found

      c:/sapdb/j2e/db/bin/pipe2file.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/sqlinst.map not found

      c:/sapdb/j2e/db/bin/xoldci.exe not found

      c:/sapdb/j2e/db/pgm/systemrc.exe not found

      c:/sapdb/j2e/db/doc/FirstSteps/ODBC/HelloSAPDB.c not found

      c:/sapdb/j2e/db/lib/python1.5/site.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/quickknl.map not found

      c:/sapdb/j2e/db/bin/xservice.exe not found

      c:/sapdb/j2e/db/pgm/dbmstop.exe not found

      c:/sapdb/j2e/db/pgm/dbpinstall.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/cpclnk.map not found

      c:/sapdb/j2e/db/misc/sapdbapi.py not found

      c:/sapdb/j2e/db/bin/xtracesort.exe not found

      c:/sapdb/j2e/db/symbols/start-clu.pdb not found

      c:/sapdb/j2e/db/misc/dbmaperl.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/libhsscopy.map not found

      c:/sapdb/j2e/db/symbols/dbpinstall.pdb not found

      c:/sapdb/j2e/db/bin/xsql.exe not found

      c:/sapdb/j2e/db/misc/instperl.pl not found

      c:/sapdb/j2e/db/pgm/service.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/dbmpyd.map not found

      c:/sapdb/j2e/db/cluster/SAPDBMSCSRes.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/dbmsrv-clu.map not found

      c:/sapdb/j2e/db/pgm/dbmsrv.exe not found

      c:/sapdb/j2e/db/symbols/service-clu.pdb not found

      c:/sapdb/j2e/db/env/SYSDBACOM.py not found

      c:/sapdb/j2e/db/symbols/service.pdb not found

      c:/sapdb/j2e/db/env/en/SQLMESS.en not found

      c:/sapdb/j2e/db/lib/python1.5/types.py not found

      c:/sapdb/j2e/db/symbols/cpcdrv.pdb not found

      c:/sapdb/j2e/db/bin/x_python.exe not found

      c:/sapdb/j2e/db/misc/sapdb/dbm.py not found

      c:/sapdb/j2e/db/lib/python1.5/UserDict.py not found

      c:/sapdb/j2e/db/pgm/pu.exe not found

      c:/sapdb/j2e/db/sap/grantxdb.dbm not found

      c:/sapdb/j2e/db/sap/saprfc.ini not found

      c:/sapdb/j2e/db/lib/python1.5/stat.py not found

      c:/sapdb/j2e/db/env/XDD.py not found

      c:/sapdb/j2e/db/env/XMLIMAPI.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/sysrc.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/systemrc.map not found

      c:/sapdb/j2e/db/doc/FirstSteps/Precompiler/HelloSAPDB.cpc not found

      c:/sapdb/j2e/db/symbols/sphsapdb.pdb not found

      c:/sapdb/j2e/db/env/ORADDSYN.py not found

      c:/sapdb/j2e/db/env/WEBDAV.py not found

      c:/sapdb/j2e/db/bin/x_diagnose.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/cons.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/cpcdrv.map not found

      c:/sapdb/j2e/db/lib/python1.5/ntpath.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/DemodbData.java not found

      c:/sapdb/j2e/db/misc/sapdb/pythondef/__init__.py not found

      c:/sapdb/j2e/db/symbols/cr_param.pdb not found

      c:/sapdb/j2e/db/pgm/renparam.exe not found

      c:/sapdb/j2e/db/pgm/kernel.exe not found

      c:/sapdb/j2e/db/bin/sqlrun.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/sapdbmscsex.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/service.map not found

      c:/sapdb/j2e/db/sap/dbpinstall.lst not found

      c:/sapdb/j2e/db/env/INFO.py not found

      c:/sapdb/j2e/db/symbols/slowci.pdb not found

      c:/sapdb/j2e/db/env/SYSINFOCOM.py not found

      c:/sapdb/j2e/db/env/dbanalyzer75.cfg not found

      c:/sapdb/j2e/db/env/ORADDCOM.py not found

      c:/sapdb/j2e/db/pgm/sqlfilt.exe not found

      c:/sapdb/j2e/db/pgm/libhsscopy.dll not found

      c:/sapdb/j2e/db/pgm/dbghelp.dll not found

      c:/sapdb/j2e/db/pgm/liboms.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/serv-clu.map not found

      c:/sapdb/j2e/db/pgm/sysrc.exe not found

      c:/sapdb/j2e/db/lib/python1.5/fnmatch.py not found

      c:/sapdb/j2e/db/env/lapps.py not found

      c:/sapdb/j2e/db/pgm/python15.dll not found

      c:/sapdb/j2e/db/misc/SAP/DBTech/loader.pm not found

      c:/sapdb/j2e/db/bin/xkernprot.exe not found

      c:/sapdb/j2e/db/cluster/strt_clu.exe not found

      c:/sapdb/j2e/db/misc/sapdb/pythondef/sql.pyd not found

      c:/sapdb/j2e/db/symbols/libhsscopy.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/sqlfiltern.map not found

      c:/sapdb/j2e/db/env/SHOWCMD.py not found

      c:/sapdb/j2e/db/pgm/sqlmsg.dll not found

      c:/sapdb/j2e/db/env/de/PRECOMM.de not found

      c:/sapdb/j2e/db/env/general.use not found

      c:/sapdb/j2e/db/symbols/get_page.pdb not found

      c:/sapdb/j2e/db/pgm/dbmstart.exe not found

      c:/sapdb/j2e/db/doc/FirstSteps/Python/HowToPython.html not found

      c:/sapdb/j2e/db/symbols/dbmsrv-clu.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/slowci.map not found

      c:/sapdb/j2e/db/cluster/dbmsrv_clu.exe not found

      c:/sapdb/j2e/db/pgm/lserver.exe not found

      c:/sapdb/j2e/db/lib/python1.5/exceptions.py not found

      c:/sapdb/j2e/db/misc/loaderaperl.dll not found

      c:/sapdb/j2e/db/Support/Mapfiles/libSQLDBC.map not found

      c:/sapdb/j2e/db/lib/python1.5/tempfile.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/DemodbData.class not found

      c:/sapdb/j2e/db/pgm/sqlfiltn.exe not found

      c:/sapdb/j2e/db/symbols/sapdbmscsres.pdb not found

      c:/sapdb/j2e/db/misc/netvault.txt not found

      c:/sapdb/j2e/db/symbols/lserver.pdb not found

      c:/sapdb/j2e/db/pgm/slowknl.exe not found

      c:/sapdb/j2e/db/cluster/service_clu.exe not found

      c:/sapdb/j2e/db/lib/python1.5/os.py not found

      c:/sapdb/j2e/db/env/APPS.py not found

      c:/sapdb/j2e/db/symbols/libSQLDBC.pdb not found

      c:/sapdb/j2e/db/doc/FirstSteps/ODBC/odbcexample.c not found

      c:/sapdb/j2e/db/doc/FirstSteps/index.html not found

      c:/sapdb/j2e/db/Support/Mapfiles/updcol.map not found

      c:/sapdb/j2e/db/symbols/cons.pdb not found

      c:/sapdb/j2e/db/misc/dbm.py not found

      c:/sapdb/j2e/db/env/SAPDBLOADER.py not found

      c:/sapdb/j2e/db/symbols/sapdbmscsex.pdb not found

      c:/sapdb/j2e/db/cluster/SAPDBMSCSMan.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/sapdbmscsres.map not found

      c:/sapdb/j2e/db/symbols/diagnose.pdb not found

      c:/sapdb/j2e/db/lib/python1.5/linecache.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/Precompiler/HowToEmbedSQL.html not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/HowToJava.html not found

      c:/sapdb/j2e/db/pgm/cr_param.exe not found

      c:/sapdb/j2e/db/misc/sapdb/sql.py not found

      c:/sapdb/j2e/db/symbols/backint.pdb not found

      c:/sapdb/j2e/db/doc/FirstSteps/Java/StateSAPDB.class not found

      c:/sapdb/j2e/db/env/repmanEx.py not found

      c:/sapdb/j2e/db/misc/updcol.exe not found

      c:/sapdb/j2e/db/bin/backint.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/pipe2file.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/libsqlcls.map not found

      c:/sapdb/j2e/db/Support/Mapfiles/lserver.map not found

      c:/sapdb/j2e/db/lib/python1.5/traceback.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/Python/HelloSAPDB.py not found

      c:/sapdb/j2e/db/lib/python1.5/lib-dynload/dummy.py not found

      c:/sapdb/j2e/db/pgm/stop.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/TableDefC.map not found

      c:/sapdb/j2e/db/bin/xci.exe not found

      c:/sapdb/j2e/db/symbols/sqlwhat.pdb not found

      c:/sapdb/j2e/db/symbols/pipe2file.pdb not found

      c:/sapdb/j2e/db/symbols/sqlfiltern.pdb not found

      c:/sapdb/j2e/db/bin/sqlwhat.exe not found

      c:/sapdb/j2e/db/env/en/DBM.en not found

      c:/sapdb/j2e/db/symbols/libsqlcls.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/slowknl.map not found

      c:/sapdb/j2e/db/env/SYSDBA.py not found

      c:/sapdb/j2e/db/bin/xsqlro.exe not found

      c:/sapdb/j2e/db/env/SYSINFO.py not found

      c:/sapdb/j2e/db/symbols/sqlver.pdb not found

      c:/sapdb/j2e/db/env/ORADDV.py not found

      c:/sapdb/j2e/db/env/ODBC.py not found

      c:/sapdb/j2e/db/misc/loader.py not found

      c:/sapdb/j2e/db/env/GARBAGE.py not found

      c:/sapdb/j2e/db/symbols/TableDefC.pdb not found

      c:/sapdb/j2e/db/doc/FirstSteps/Python/StateSAPDB.py not found

      c:/sapdb/j2e/db/lib/python1.5/string.py not found

      c:/sapdb/j2e/db/doc/FirstSteps/Python/HelloSAPDB-API.py not found

      c:/sapdb/j2e/db/pgm/slowci.exe not found

      c:/sapdb/j2e/db/Support/Mapfiles/sphsapdb.map not found

      c:/sapdb/j2e/db/pgm/cons.exe not found

      c:/sapdb/j2e/db/symbols/sql_run.pdb not found

      c:/sapdb/j2e/db/env/lsystab.py not found

      c:/sapdb/j2e/db/sap/lcinit.bat not found

      c:/sapdb/j2e/db/lib/python1.5/glob.py not found

      c:/sapdb/j2e/db/Support/Mapfiles/backint.map not found

      c:/sapdb/j2e/db/symbols/stop-clu.pdb not found

      c:/sapdb/j2e/db/Support/Mapfiles/cr_param.map not found

      c:/sapdb/j2e/db/env/CNR3DATA.py not found

      c:/sapdb/j2e/db/env/ORADD.py not found

      c:/sapdb/j2e/db/env/en/PRECOMM.en not found

      c:/sapdb/j2e/db/Support/Mapfiles/puclst.map not found

      c:/sapdb/j2e/db/env/AS.py not found

      check dependencies... ok

      check rte registration of package... ok

      package data is inconsistent

      Database Kernel 7.5.00.18 32 bit in c:/program files/sdb/7500

      -


      check files... ok

      check dependencies... ok

      check rte registration of package... ok

      package data is consistent

      VERIFICATION SUMMARY:

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

      INVALID PACKAGES: 0

      VALID PACKAGES: 15

      INCONSISTENT PACKAGES: 1

      TOTAL FILES: 970

      MISSED FILES: 253

      MODIFIED FILES: 0

      FILES WITH MODIFIED PERMISSIONS: 0

      C:\WINDOWS\system32>

  • Posted on Feb 02, 2005 at 08:58 PM

    Hello,

    the Database Kernel 7.5.00.07 32 bit in c:/sapdb/j2e/db

    is missing.

    To drop the database

    dbmcli -s -d J2E -u control,control

    >db_stop

    >db_drop

    But then all the data inside of the database is lost.

    with "sdbuninst -all" all the database software will be

    deleted when there is no other instance on that host.

    Best regards, Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Stefan,

      dbmcli -s -d J2E -u control,control

      Gives me the following problem

      C:\WINDOWS\system32>dbmcli -s -d J2E -u control,control

      Error! Connection failed to node (local) for database J2E: dbmsrv executable not found

      And "sdbuninst -all" complains that remove all instances before removing "Database Kernel"

      I don't have any other instance and no worry of loosing data. Please let me know if there is any other way to drop this database.

      thanks

      --Satya

  • Posted on Feb 02, 2005 at 09:38 PM

    Hello,

    have you checked the recycler wether the deleted SAP DB folder is still in it ? If so I would suggest to restore it. Then try the db_drop again.

    Since the database has a lot of registry keys, even if the files are deleted the new installation will fail due to the existance of these keys.

    The easiest way now would be to reinstall the kernel software. You neeed the database software anyway.

    Do you have the installation package on your server ?

    If so I would suggest to go to that folder and run this command: sdbinst -package "Database Kernel" -depend c:\sapdb\J2E\db

    This should work.

    Afterwards the connect to the database should work again.

    Hope that helps, Stefan

    PS: Unfortunately we are using the other guys case to discuss this issue. I am sorry for that.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2005 at 03:21 PM

    Hello Tiest van Gool:

    I had the same problem. I resolved it doing this:

    1- Control panel -> administrative tools -> Services

    2- Search XServer and Stop it (see the context menu)

    3- Start the set up's DB

    Surely works ok.

    Now, see if the active server is active when you start up your miniwas:

    C:\MiniWAS>REM =====================================================

    C:\MiniWAS>REM Set the Environment for the DB Connect

    C:\MiniWAS>REM =====================================================

    C:\MiniWAS>set DBMS_TYPE=ada

    C:\MiniWAS>set PATH=C:\sapdb\programs\bin;C:\sapdb\programs\pgm;C:\WINNT\system3

    2;C:\WINNT;C:\WINNT\System32\Wbem;;C:\MiniWAS;C:\sapdb\programs\bin;C:\sapdb\pro

    grams\pgm;C:\sapdb\programs\sap;C:\sapdb\programs\bin;C:\sapdb\programs\sap;C:\s

    apdb\programs\pgm

    C:\MiniWAS>REM =====================================================

    C:\MiniWAS>REM Start the Database (SAP-DB)

    C:\MiniWAS>REM =====================================================

    C:\MiniWAS>cmd /c strdbsBSP.cmd

    C:\MiniWAS>set DBNAME=BSP

    C:\MiniWAS>x_server

    18641 ERROR: XSERVER is already running!

    C:\MiniWAS>dbmcli -U c db_warm

    OK

    Database BSP successfully started !

    C:\MiniWAS>REM =====================================================

    C:\MiniWAS>REM Start SAP System

    C:\MiniWAS>REM =====================================================

    etc.etc.

    If the output say that x_server is not install, open a DOS console (start->run->type cmd), after that proceed as follows:

    C:\sapdb\programs\pgm>x_server -h start

    correct use of x_server is:

    install as service :: install

    remove service :: remove

    start server :: start

    stop server :: stop

    C:\sapdb\programs\pgm>x_server install

    19709 INFO: Service 'XServer' installed successfully

    C:\sapdb\programs\pgm>x_server start

    19720 INFO: XSERVER started

    Tell me if my help was helpfull.

    LUCK!!.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.