MaxDB startup error: "Error! XUser not found!"

[former_member214698]

After server accidentally shutdown, the MaxDB of CE 7.2 can not startup. The JdbcCon,log shows the error. And startdb shows Error! XUser not found!

com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot conn

ect to jdbc:sapdb://lu0413v0/ACC [Restart required].

at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.createException(SQLE

xceptionSapDB.java:156)

at com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseExce

ption(SQLExceptionSapDB.java:146)

at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:241)

at com.sap.sql.connect.factory.DriverPooledConnectionFactory.createVendo

rConnection(DriverPooledConnectionFactory.java:50)

at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledCo

nnection(DriverPooledConnectionFactory.java:37)

at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnectio

n(DBDataSourceImpl.java:674)

at com.sap.sql.connect.datasource.DBDataSourceImpl.newPooledConnection(D

BDataSourceImpl.java:624)

at com.sap.sql.connect.datasource.DBDataSourceImpl.getConnection(DBDataS

ourceImpl.java:104)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSo

urceImpl.java:199)

at com.sap.inst.jdbc.connect.JdbcCon.connectViaSecureStore(JdbcCon.java:

at com.sap.inst.jdbc.connect.JdbcCon.connectViaSecureStore(JdbcCon.java:

217)

at com.sap.inst.jdbc.connect.JdbcCon.connect(JdbcCon.java:353)

at com.sap.inst.jdbc.connect.TestConnect.mainIntern(TestConnect.java:78)

at com.sap.inst.jdbc.connect.JdbcCon.main(JdbcCon.java:553)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:16

1)

Error: Couldn't connect to DB

com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot conn

ect to jdbc:sapdb://lu0413v0/ACC [Restart required].

"<SID>adm# startdb" returns error:

startdb.log:

... ...

-

---

Mon Aug 1 20:02:24 CEST 2011

Starting XServer

/usr/sap/ACC/SYS/exe/run/startdb: line 153: /sapdb/clients/ACC/bin/x_server: No such file or directory

-

---

Mon Aug 1 20:02:24 CEST 2011

Starting database

Starting Database Instance...

Error! XUser not found!

Opening Database...

Error! XUser not found!

Many Thanks!

[markus_doehr2 · Accepted solution]

> Starting XServer

>

> /usr/sap/ACC/SYS/exe/run/startdb: line 153: /sapdb/clients/ACC/bin/x_server: No such file or directory

Is that file existing? ( /sapdb/clients/ACC/bin/x_server)

And what's the output of

xuser list

of user accadm?

Markus

[former_member214698 · Accepted solution]

Hi Markus,

/sapdb/clients/ACC/bin/x_server doesn't exist. But why it was not a problem before? I was able to restart MaxDB before this hardware failure that caused server reboot.

output of "xuser list". Anything wrong with it? Thanks!

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPDBJ2EE

UsernameUCS2 :S.A.P.D.B.J.2.E.E. . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2 :?????????

Long Password :?????????

Dbname :ACC

Nodename :lu0413v0

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2 :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2 :?????????

Long Password :?????????

Dbname :ACC

Nodename :lu0413v0

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :w

Username :SUPERDBA

UsernameUCS2 :S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2 :?????????

Long Password :?????????

Dbname :ACC

Nodename :lu0413v0

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Dbname :ACC

Nodename :lu0413v0

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :control

Username :CONTROL

UsernameUCS2 :C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2 :?????????

Long Password :?????????

Dbname :ACC

Nodename :scserv

Sqlmode :<unspecified>

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

[markus_doehr2 · Accepted solution]

> /sapdb/clients/ACC/bin/x_server doesn't exist. But why it was not a problem before?

maybe due to your hardware failure??

> output of "xuser list". Anything wrong with it? Thanks!

This looks good.

Try the following:

logon as accadm and execute

x_server start
dbmcli -U c_J2EE db_online

Does the database start?

Markus

[former_member214698 · Accepted solution]

Hi Markus, using your commands above database can start and CI started fine.

Is there a fix to this problem? Should I copy x_server into /sapdb/clients/ACC/bin directory?

I also checked the license, the output doesn't confirm it. DO you think the error is related to the license issue?

lu0413v0:accadm 140> env

...

SAPSYSTEMNAME=ACC

DIR_LIBRARY=/usr/sap/ACC/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/ACC/SYS/exe/run:/usr/sap/ACC/SYS/exe/uc/linuxx86_64:/sapdb/clients/ACC/lib

dbms_type=ADA

lu0413v0:accadm 141> saplicense -show

• SAPLICENSE (Release 720) ERROR ***

ERROR: Can not set DbSl trace function

DETAILS: DbSlControl(DBSL_CMD_IMP_FUNS_SET) failed with return code 20

RC-INFO: error loading dynamic db-library - check environment for:

dbms_type = <db-type> (e.g. ora)

DIR_LIBRARY = <path to db-dll> (e.g. /usr/sap/SID/SYS/exe/run)

LD_LIBRARY_PATH = <path do db and sap libs> (e.g. /oracle/SID/lib

Thanks!

Edited by: syu on Aug 3, 2011 12:49 AM

[markus_doehr2 · Accepted solution]

If this was working earlier is the filesystem containing /sapdb/client corrupt? Or did you install anything?

Markus

[former_member214698]

The suggested commands can start database.