From: Henning Sommerkamp [mailto:[EMAIL PROTECTED]]

> When trying to connect to a Database on Linux, which has been 
> restored from a backup media  from scratch, I am able to connect 
> do this via dbmcli an execute some select statemens.
> But it is impossible to Conenct via JDBC.
> Then this Exception arieses:

> com.sap.dbtech.jdbc.exceptions.JDBCDriverException: SAP 
> DBTech JDBC: Cannot
> connect to jdbc:sapdb://192.168.0.3/certidb [Restart required]

> I did already restart the DB several times, and db_state is "warm".
> I am able to register this DB from a remote Computer with DBMGui and
> everything seems fine.
> Anyway, it is impossible to Login from SQLStudio: -709 
> CONNECT: (database not running) What am i doing wrong?

Please check your connect parameters again. If there is a 
typo in your database oder node name this error may occur. 
The -709 has also the meaning "database does not exist".

Check the database state immediately before and after the
connect. Maybe your database crashes during the connect.
Check your knldiag and knldiag.err for suspect entries 
during the connect time.

The dbmcli and the DBMGui does not connect to the database
itself. They connect to a executable beside the database
-> the DBMServer (dbmsrv). After this the DBMServer may 
perform a local connect to the database (e.g. for a 
sql_execute). Also the DBM user ("first database manager
operator") can not connect to the database directly with
JDBC or ODBC.

Bernd
-- 
SAP Labs Berlin

Reply via email to