cancel
Showing results for 
Search instead for 
Did you mean: 

MAXDB installation issue

Former Member
0 Kudos

hi everyone,

i'm trying to install MaxDB 7.8 on HP-UX 11.31 parisc.

After unzipping the package i'm creating the sdb/sdba user and group. then I start the installation as root ./SDBSETUP and leaving all the default values and paths...the program is installing to the folder /sapdb.

When the installation finished i logged in as the su - sdb user and starting the x_server and running the db_create to create the default DB in MaxDB but i get this error:

create TST failed: create_demo_db.sh[58]: dbmcli: not found.

Then i'm setting the env variables:

export PATH=$PATH:/sapdb/MaxDB/db/bin:/sapdb/programs:/sapdb/data

export DEP=/sapdb/MaxDB/db

after that i successfully create the TST database. i go to /sapdb/MaxDB/db/bin and try manually to create one

$ dbmcli -d TEST -u dba,dba

Error! Connection failed to node (local) for database TEST:

database instance not found

it seems the instance is not available or not present, although i created it in the start with the installation: MaxDB dba,dba

does anyone know what the solution for this issue?

thanks,

Dzana

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> it seems the instance is not available or not present, although i created it in the start with the installation: MaxDB dba,dba

If you create the database with the name "MaxDB" then you can't connect to database "TEST". You need to use MaxDB as database name instead.

you can find out the database names with the command

dbmcli db_enum

Markus

Former Member
0 Kudos

hi,

sorry i did explain it a big confusing, the output i get is

$ dbmcli db_enum

OK

TST /sapdb/MaxDB/db 7.8.01.14 fast running

TST /sapdb/MaxDB/db 7.8.01.14 quick offline

TST /sapdb/MaxDB/db 7.8.01.14 slow offline

TST /sapdb/MaxDB/db 7.8.01.14 test offline

MAXDB /sapdb/MaxDB/db 7.8.01.14 fast running

MAXDB /sapdb/MaxDB/db 7.8.01.14 quick offline

MAXDB /sapdb/MaxDB/db 7.8.01.14 slow offline

MAXDB /sapdb/MaxDB/db 7.8.01.14 test offline

i have cretaed both DBs..one by installation and the second one by dbmcli - manually and then i also set the DBs online

$ dbmcli -d MAXDB -u dba,dba db_state

OK

State

ONLINE

also i verified the installation and it is ok.

the thing is that i'm using the MAXDB as a part of HP Data Protector integration and it cannot recognize the MAXDB instance for integration configuration. and i don't think this as DP issue :S

any idea?

Regards,

dzana

markus_doehr2
Active Contributor
0 Kudos

If that is to be used in the future for SAP system backups I suggest you install a small Netweaver system and try the integration with that.

Since the environment you set are only set for the shell and not permanently it's quite difficult to say, what the problem is here. And without any DP logs even more...

Markus

Former Member
0 Kudos

also i get this error when trying to connect to TST database using DB manager

*

-24988 SQL error sql_execute SELECT NUMERIC_VALUE FROM SYSDD.CONFIGURATION WHERE UPPER(DESCRIPTION) = u2018DATACACHE SIZEu2019; -4004,unknown table name or unknown schema:CONFIGURATION

*

Edited by: junkieBoog on Aug 24, 2011 2:36 PM

Edited by: junkieBoog on Aug 24, 2011 2:36 PM

Edited by: junkieBoog on Aug 24, 2011 2:36 PM

markus_doehr2
Active Contributor
0 Kudos

Did you load the system tables after you created the database?

Markus

Former Member
0 Kudos

yes, and i get

0,OK: everything works fine

0,/sapdb/MaxDB/db/bin/sdbsysload -R /sapdb/MaxDB/db -d TST -u dba,*

Installing tables for instances

Removing obsolete objects

Installing Loader tables

Installing messages and help

Installing SYSDBA tables

Installing comments for SYSDBA tables

Installing ODBC tables

Installing tables for WebAgent

Installing tables for Repository (WebDAV)

Installing DOMAIN tables

Installing comments for DOMAIN tables

Installing Views as replacement for SHOWs

Installing Database Manager tables

Installing SYSINFO tables

Installing comments for SYSINFO tables

Installing support for UDE (User Defined Extensions)

Installing additional triggers

Installing tables for JDBC Database Metadata

Installing tables for SQLDBC Database Metadata

Installing tables for DBAnalyzer

Installing tables for DQE

==================================

Installation successfully finished

but in the end i get the pop-out window with the same message -24988 SQL error ...

regards,

dzana

former_member229109
Active Contributor
0 Kudos

Hello,

"also i get this error when trying to connect to TST database using DB manager

*

-24988 SQL error sql_execute SELECT NUMERIC_VALUE FROM SYSDD.CONFIGURATION WHERE UPPER(DESCRIPTION) = u2018DATACACHE SIZEu2019; -4004,unknown table name or unknown schema:CONFIGURATION

"

The TST is database version 7.8. Correct?

The error that you receive is related to the DBM GUI and not to the database.

=> use the Database Studio to administrate newer Database Versions.

SAP MaxDB Library: maxdb.sap.com/doc/7_8/default.htm

-> Tools Documentation -> Database Studio

Regards, Natalia Khlopina

Former Member
0 Kudos

ok,

this partially solved my issue (i installed the Database studio and connected to the server)

the DBs (TST and MAXDB) created could be set online.

but when trying to create through the gui a new database i get the error

*-24965 Logon to operating system failed

-24994,ERR_RTE: Runtime environment error*

i just can't get the idea out of the head that the issue is related to the (wrong) installation, but i'm not sure.

this is the first time i'm installing MAXDB on unix.

i've done it on windows..and it is much easier

Dzana

markus_doehr2
Active Contributor
0 Kudos

> *-24965 Logon to operating system failed

> -24994,ERR_RTE: Runtime environment error*

So the authentication is based on the operating system user for that installation?

> i just can't get the idea out of the head that the issue is related to the (wrong) installation, but i'm not sure.

That's why I proposed to install a small system using the SAP installation DVDs to get the proper setting and installation

> i've done it on windows..and it is much easier

Windows "forgives" a lot more, e. g. switching back to NTLM authentication if it can't use Kerberos tickets - which can be a security flaw without you noticing it. On Unix systems authentication would simply fail. That's why Windows may appear easier but do you know, how the authentication was done when the same process worked on Windows?

Markus

Former Member
0 Kudos

Hi Markus and Natalia,

the issue i had turned out to be not a MaxDB issue.

after installing the Database Studio the databases are functioning perfectly. My problem is DP related though.

I want to thank you both for your help.

i will be working on MaxDB in the future and i suppose you're gonna hear from me again

regards,

Dzana

0 Kudos

Hi Natalia

Thanks for the comments, by installing DB studio fixed my issue

Edited by: Jose Uranga on Sep 16, 2011 6:29 PM

Former Member
0 Kudos

Could you solve your DP problems? We have similar problems.

Answers (0)