Hi Christian,
I suppose there is something wrong with one of the files
<indepdatapth>/config/SAG.upc
<indepdatapth>/config/SAG
<RUNDIRECTORY>/dbm.cfg
What is the name of your "First DBM Operator"? Is this the user SAGDBA?
(Or is this the SYSDBA?)
Check the name of the "firstDBM" with
dbmcli -d SAG -u SAGDBA,******** param_getvalue CONTROLUSERID
And please check the user data record of your "first DBM":
dbmcli -d SAG -u SAGDBA,******** user_get <firstdbmname>
The last line of the answer should be "USERTYPE=DBM".
Also check the configuration key which does contain the name of the
"first DBM" too:
dbmcli -d SAG -u SAGDBA,******** dbm_configget SAPDB12
I assume the the second and the third command delivers not the correct
information. In this case maintain the SAPDB12 key with
dbmcli -d SAG -u SAGDBA,******** dbm_configset SAPDB12 <firstdbmname>
If this doesn't work please send me (or to the list) the output of the
following commands
dbmcli -d SAG -u SAGDBA,******** user_getall
and a
dbmcli -d SAG -u SAGDBA,******** user_get <username>
for every name listed by the user getall.
Furthermore
dbmcli -d SAG -u SAGDBA,******** param_getvalue CONTROLUSERID
dbmcli -d SAG -u SAGDBA,******** dbm_configget SAPDB12
dbmcli -d SAG -u SAGDBA,******** dbm_configget SAPDB5
dbmcli -d SAG -u SAGDBA,******** -uSQL SAGDBA,******** -c sql_execute
select sysdba from dual
Regards Bernd
> -----Ursprüngliche Nachricht-----
> Von: JUNG, Christian [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 31. März 2006 10:35
> An: MaxDB Mailinglist (E-Mail)
> Betreff: SAP DB 7.4: util_connect and sql_connect don't work!
>
> Hi!
>
> Now I really got a problem. In my last mail I said that
> sql_connect doesn't
> work. Yesterday I found that util_connect either doesn't
> work. So I can't
> make any backups of the instance. That's annoying and I
> really need help for
> this issue!
>
> Here's the output of dbmcli:
>
> (DBA)
> ---8<---
> [EMAIL PROTECTED]:~> dbmcli -d SAG -u SAGDBA,********
> dbmcli on dws10 : SAG>sql_connect
> ERR
> -24988,ERR_SQL: sql error
> -4008,Unknown user name/password combination
>
> ---
> ---8<---
>
> (DBM)
> ---8<---
> [EMAIL PROTECTED]:~> dbmcli -d SAG -u SAGDBA,********
> dbmcli on dws10 : SAG>util_connect
> ERR
> -24988,ERR_SQL: sql error
> -4008,Unknown user name/password combination
>
> ---
> ---8<---
>
> Here's the output of xsql:
>
> ---8<---
> [EMAIL PROTECTED]:~> xsql -d SAG -u SAGDBA,********
> > select * from domain.info_versions
> Kernel | Runtime Environmen
> |
> --------------------------------------------------------------
> --------------
> ----------
> Kernel 7.4.3 Build 027-121-048-452 | X32/LINUX 7.4.3 Build
> 027-121-048-452 |
> * Ok
> ---8<---
>
> I tried a
>
> user_put SAGDBA password=<oldpassword>
>
> but this didn't help... :-(
>
>
> Bye
> Chris
>
>
> phone: +49 6898/10-4987
> fax: +49 6898/10-54987
> http://www.saarstahl.de
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
