on 08-25-2008 10:56 PM
I am installing Maxdb 7.6.0.3 with Solution Manager SR4.
When comes to the phase 'Create Database Instance' the process hangs up, i have been waiting for more than 1 hour and nothing.Superdba password does not contain any @ symbol.
I can see the Datavolumnes and logvolumnes created on disk but the install doesnt go any further and even I cannot see the log file from sapinst, I need to check them a OS, it seems that sapinst hangs up.
I have tried to install the Database by myself but it hangs in the same point db activation.
krnelerr doesnt show any message
Here is the output of file XCMDOUT.log
> Subprocess starts at 20080825175148
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 db_enum
Execute Session Command : exit
> Subprocess stops at 20080825175148
OK
-
> Subprocess starts at 20080825175148
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 inst_enum
Execute Session Command : exit
> Subprocess stops at 20080825175148
OK
7.6.03.09 E:\sapdb\T08\db
-
> Subprocess starts at 20080825175148
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -R E:\sapdb\T08\db db_create T08 CONTROL,********
Execute Session Command : exit
> Subprocess stops at 20080825175150
OK
-
> Subprocess starts at 20080825175151
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 db_enum
Execute Session Command : exit
> Subprocess stops at 20080825175151
OK
T08 E:\sapdb\T08\db 7.6.03.09 fast offline
T08 E:\sapdb\T08\db 7.6.03.09 quick offline
T08 E:\sapdb\T08\db 7.6.03.09 slow offline
T08 E:\sapdb\T08\db 7.6.03.09 test offline
-
> Subprocess starts at 20080825175151
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********
Execute Session Command : param_startsession
Execute Session Command : param_init OLTP
Execute Session Command : param_checkall
Execute Session Command : param_commitsession
Execute Session Command : exit
> Subprocess stops at 20080825175154
OK
OK
OK
OK
-
> Subprocess starts at 20080825175155
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput CACHE_SIZE 262016
Execute Session Command : exit
> Subprocess stops at 20080825175155
OK
-
> Subprocess starts at 20080825175155
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput LOG_MIRRORED NO
Execute Session Command : exit
> Subprocess stops at 20080825175156
OK
-
> Subprocess starts at 20080825175156
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXUSERTASKS 50
Execute Session Command : exit
> Subprocess stops at 20080825175157
OK
-
> Subprocess starts at 20080825175157
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXCPU 8
Execute Session Command : exit
> Subprocess stops at 20080825175157
OK
-
> Subprocess starts at 20080825175157
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput LOG_IO_QUEUE 200
Execute Session Command : exit
> Subprocess stops at 20080825175157
OK
-
> Subprocess starts at 20080825175157
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MAXLOCKS 300000
Execute Session Command : exit
> Subprocess stops at 20080825175158
OK
-
> Subprocess starts at 20080825175158
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput CAT_CACHE_SUPPLY 10000
Execute Session Command : exit
> Subprocess stops at 20080825175158
OK
-
> Subprocess starts at 20080825175158
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput JOIN_MAXTAB_LEVEL4 64
Execute Session Command : exit
> Subprocess stops at 20080825175158
OK
-
> Subprocess starts at 20080825175158
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput _UNICODE YES
Execute Session Command : exit
> Subprocess stops at 20080825175159
OK
-
> Subprocess starts at 20080825175159
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput DEFAULT_CODE ASCII
Execute Session Command : exit
> Subprocess stops at 20080825175159
OK
-
> Subprocess starts at 20080825175159
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput PACKETSIZE 131072
Execute Session Command : exit
> Subprocess stops at 20080825175159
OK
-
> Subprocess starts at 20080825175159
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_directput MCOD NO
Execute Session Command : exit
> Subprocess stops at 20080825175200
OK
-
> Subprocess starts at 20080825175200
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********
Execute Session Command : param_startsession
Execute Session Command : param_checkall
Execute Session Command : param_commitsession
Execute Session Command : exit
> Subprocess stops at 20080825175201
OK
OK
OK
-
> Subprocess starts at 20080825175202
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 1 DATA E:\sapdb\T08\sapdata\DISKD0001 F 1280000
Execute Session Command : exit
> Subprocess stops at 20080825175202
OK
-
> Subprocess starts at 20080825175202
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 2 DATA E:\sapdb\T08\sapdata\DISKD0002 F 1280000
Execute Session Command : exit
> Subprocess stops at 20080825175203
OK
-
> Subprocess starts at 20080825175203
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 3 DATA E:\sapdb\T08\sapdata\DISKD0003 F 1280000
Execute Session Command : exit
> Subprocess stops at 20080825175203
OK
-
> Subprocess starts at 20080825175203
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 4 DATA E:\sapdb\T08\sapdata\DISKD0004 F 1280000
Execute Session Command : exit
> Subprocess stops at 20080825175204
OK
-
> Subprocess starts at 20080825175204
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_addvolume 1 LOG F:\sapdb\T08\saplog\DISKL001 F 819200
Execute Session Command : exit
> Subprocess stops at 20080825175204
OK
-
> Subprocess starts at 20080825175205
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********
Execute Session Command : param_startsession
Execute Session Command : param_checkall
Execute Session Command : param_commitsession
Execute Session Command : exit
> Subprocess stops at 20080825175205
OK
OK
OK
-
> Subprocess starts at 20080825175206
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_start
Execute Session Command : exit
> Subprocess stops at 20080825175211
OK
-
> Subprocess starts at 20080825175211
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_state
Execute Session Command : exit
> Subprocess stops at 20080825175211
OK
State
ADMIN
-
> Subprocess starts at 20080825175212
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** db_state
Execute Session Command : exit
> Subprocess stops at 20080825175212
OK
State
ADMIN
-
> Subprocess starts at 20080825175212
Execute Command : E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,********
Execute Session Command : util_connect
Execute Session Command : db_activate SUPERDBA,********
-
When I try to do it bymyself the command it says -24988,ERR_SQL: SQL ERROR
-104 DBM command impossible at this time.
Please advise.
Hi,
what does the machine do? Is there any I/O on the storage devcies? What OS do you use? Remember: creating data and log devices on file system basis can take a long time especially on older machines or slow storage (e.g. SCSI).
Please post the content of knldiag file; it contains error messages from the database which might be useful to determine the failure you ran into.
Regards
André
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, after waiting like 3 hours it went through, strange was that in the server console I only saw a 1% o 0% Cpu utilization during those 3 hours, but the DB kernel was working.
Thank you all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Daniel,
According your information, at that time you run 'db_activate SUPERDBA,********'.
At that step the data & log volumes will be created by database kernel.
-> Please update with output of the following commands :
A) E:\sapdb\programs\pgm\dbmcli.exe -n tecbwsap08 -d T08 -u CONTROL,******** param_getvolsall
B) x_cons T08 show io
x_cons T08 show active
< after 1min run those commands again to compare the results >
-> Please post the knldiag file.
Thank you and best regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.