on 08-07-2006 10:59 AM
Hello All,
I'm trying to upgrade from NW04 (6.40) to NW04s SR1 (7.00).
Currently I am at Installation phase of PREPARE.
System Details :
"
Source System
SAP Release : WAS-ABAP 6.40 + BW 3.5
DB Version : Max-DB 7.5 Build 27
OS Version : Suse Linux-9 (Kernel2.6.5.7.244)
Target System
SAP Release : WAS-ABAP 7.00 + BW 7.0
DB Version : Max-DB 7.6 Build 18
OS Version : Suse Linux-9 (Kernel2.6.5.7.244 + Glibc-2.3.3-98.61)
"
I am getting error in the SHDINST_DB_PREP sub-phase of Installation. I have initiated the PREPARE processes(SAPup,(UA)Upgrade Assitant Server, UA-GUI)with the <SID>ADM login. The error that I get is as follows:
ERROR by create user SAPACPSHD (i.e. SAP<SID>SHD)...
The Error log has the following details:->
-
Set environment variable 'DBROOT' to '/sapdb/programs'
> Subprocess starts at 20060802100025
Execute Command : dbmcli -n g8t45 -d ACP -U c -USQL w
Start subprocess as user with uid: acpadm
Execute Session Command : sql_execute SELECT USERNAME FROM DOMAIN.USERS WHERE USERNAME = 'SAPACPSHD'
> Subprocess stops at 20060802100025
Must be called by root or effective user 502 effective group 501 Error! Connection failed to node g8t45 for database ACP: Reading header from pipe:(0:NO ERROR(0)
-
for your information. When I issue the stopsap command with <SID>ADM login then the SAP instance are successfully shut-down but the Max-DB database does not go down and again I get the same error message which is :
"
Must be called by root or effective user 502 effective group 501 Error! Connection failed to node g8t45 for database ACP:
"
Please help me.
Regards,
Premkishan
Hi,
I'd really suggest you open a CSS message for this issue, if you've not already done so.
Regarding "Must be called by root or effective user 502 effective group 501". Can you tell me which user/group is 501/502 on your system?
Regards,
Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prem,
ok. We've got several possibilities now.
- can you tell me if a simple 'dbmcli' call (from the commandline) works? If yes, you should get a 'dbmcli>' prompt, which you can leave by typing 'exit'
- is the <sid>adm user a member of the 'sdba' group? If not, please change that accordingly and retry.
- what does the command 'sdbverify' show (see note 546737)? If you get errors, please post them.
Regards,
Roland
Hello Roland,
1) The dbmclie call(from the commandline) does NOT work.
I again get the same error message as follows:
-
<i>acpadm@g8t45:/usr/sap/ACP/SYS/exe/run> dbmcli
Must be called by root or effective user 502 effective group 501
Error! Connection failed to node (local) for database (no dbname): Reading header from pipe:(0:NO ERROR(0)</i>
-
2) YES, <sid>adm is included in 'sdba' group.
3) sdbverify output is attached in file mysdbverify.
It consists of toomany permission and group changes.
Please go through it and revert back to me .
I am sending the mysdbverify file to your SAP mail Id.
Thanking you in advance.
Regards,
Prem
Hi Roland,
Thanks a lot for the information of sdbverify and also for your suggestion for executing SDBINST to restore the Mode and Group changes.
Finally I am able to get not error with the sdbverify .
Now I want to ask you one more thing pertaning to Max-DB.
We have TNS-Listener in Oracle Terminolgy, so do we have something similar to that for Max-DB.
As after issuing startsap from <sid>adm the database is started but I get an error message saying <b><i>" ABAP Database is not available via R3trans"</i></b>.
Hence I am not able to start my SAP Application.
Please help me !
Regards,
Prem
Hello Roland,
thanks a lot for the info and the help.
I have resolved the issue.
The problem was that while connecting to Database SAP was using SAP<SID>SHD(shadow user for database schema) instead of SAP<SID>.
Hence I change the password of SAP<SID> and then set the xuser for <SID>adm and sqd<SID> home using the xuser utility with SAP<SID> as the user .
Regards,
Prem
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.