on 08-23-2011 4:03 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
> *-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
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.