on 07-28-2012 7:19 AM
After a server crash i will restart the database, but i become following error:
dbmcli -d sm1 -u control,control
ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'
Error! Connection failed to node (local) for database sm1:
Reading header from pipe:closed by serve
output of the command sdbregview -l
sapsm1:sm1adm 53> sdbregview -l
DB Analyzer /sapdb/programs 7.7.07.41 64 bit valid
Server Utilities /sapdb/programs 7.7.07.41 64 bit valid
PCR 7300 /sapdb/programs 7.3.00.60 valid
PCR 7301 /sapdb/programs 7.3.01.22 valid
PCR 7500 /sapdb/programs 7.5.00.52 64 bit valid
SAP Utilities /sapdb/programs 7.7.07.41 64 bit valid
Base /sapdb/programs 7.7.07.41 64 bit valid
Redist Python /sapdb/programs 7.7.07.41 64 bit valid
JDBC /sapdb/programs 7.6.06.05 valid
Messages /sapdb/programs MSG 0.8507 valid
ODBC /sapdb/programs 7.7.07.41 64 bit valid
SQLDBC 77 /sapdb/programs 7.7.07.41 64 bit valid
Database Kernel /sapdb/SM1/db 7.7.07.41 64 bit valid
Loader /sapdb/programs 7.7.07.41 64 bit valid
SQLDBC /sapdb/programs 7.7.07.41 64 bit valid
Fastload API /sapdb/programs 7.7.07.41 64 bit valid
SQLDBC 76 /sapdb/programs 7.6.06.22 64 bit valid
sapsm1:sm1adm 54>
What can i do ?
Hi Yashwanth,
thanks for your great help. After rename the both files dbm.shi and dbm.shi the
database worked again. The problem is solved.
Regards
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Voker,
Most likely this issue happens when the system is abnormally shutdown/restarted or after a Crash(due to power outage, for example) while the database is running.
MaxDB uses the OS file system to keep some shared files for the MaxDB internal communications. If the database is in ONLINE state and a OS restart is not properly done, the MaxDB cannot perform a 'clean' shutdown so these runtime files are not removed from the OS file system, causing the old runtime to be present at the new database startup.
Please do the following and let me know if the issue is resolved.
This should return ONLINE then.
Regards,
Yashwanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ratnajit,
thanks for your answer. The x_server was started.
but when i started the dbmcli command, i become the same error.
Best regards
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you check if the x_server is started properly ?
If required , restart the x_server
x_server stop
x_server start
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
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.