Connecting to database ... Default DB connection failed

[Former Member]

All experts,

I have Create schema and tablescapes for example : SAP_PRD 5G unlimited .

after completion sap sourcing installation , i have done successfully dbimport on SAP_PRD schema. but SAP JAVA J3EE Engine is not working from configtool.

I am getting error like :- error occurred while scanning db.msg:error while connecting db.

Connecting to database ... Default DB connection failed

  FATAL: Main class "com.sap.engine.configtool.console.ConsoleConfigTool" cannot

be started:

  FATAL: java.lang.NullPointerException: while trying to invoke the method com.s

ap.engine.configtool.data.ClusterData.getTemplates() of an object loaded from st

atic field com.sap.engine.configtool.console.ConsoleConfigTool.clusterData

        at com.sap.engine.configtool.console.ConsoleConfigTool.loadTemplatesAndI

nstances(ConsoleConfigTool.java:153)

        at com.sap.engine.configtool.console.ConsoleConfigTool.main(ConsoleConfi

gTool.java:1167)

        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

2)

  FATAL: com.sap.engine.offline.OfflineToolStart will abort now with exitcode 2

Program terminated abnormally

Press any key to continue . . .

i have checked database level  JAVA schema and SAP Sourcing schema connected to SID and also i have upgrade configtool and assign all JVM parameters .

Please guide for configtool.

Regards,

Subhash N Bhalekar

[Former Member]

Dear All,

I am getting error as below in config tool:-

[Former Member]

Hi Subhash,

Could you refer this note

1561655 - Failed to start J2EE config tool due to scanning DB error

Regards,

Dhuvaraganathan M.

[Former Member]

Dear Dhuvaraganathan Mani,

Thanks For Quickly Reply.

I have delete tmp folder and also restart hardware & java instance but nor luck.

Thanks & Regars,

Subhash N Bhalekar

[Former Member]

Hi Subhash,

Thanks for reply.

Once again check in host file, its was pointing a correct IP or not ???

Regards,

Dhuvaraganathan M.

[nikhil_bose]

subhash,

Can you please check SAPJVMs are in same version?

http://wiki.scn.sap.com/wiki/display/TechTSG/(JSTTSG)(Kernel)Service-Exit67_OldJVM?original_fqdn=wik...

- Nikhil Bose

[Former Member]

Dear Nikhil Bose,

Thanks For Quickly Reply.

I have upgrade latest version  SAPJVMS on Application server .

Thanks & Regars,

Subhash N Bhalekar

[Former Member]

Hi,

It could be listener port problem. Can you update with the text from lsnrctl -status command. The port number maintained in config tool is 1521 and but originally it may be configured as 1527. Please check it once and update.

[Former Member]

Dear suresh,

I have check as below:-

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 22-NOV-2014 10:45

:24

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SOP.WORLD))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ

ction

Start Date                21-NOV-2014 18:17:15

Uptime                    0 days 16 hr. 28 min. 17 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   E:\SOP\product\11.2.0\dbhome_1\network\admin\listener.

ora

Listener Log File         E:\oracle\SOP\saptrace\diag\tnslsnr\amdhandev\listener

\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SOP.WORLDipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SOPipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amdhandev.amdhan.local)(PORT=1521)))

Services Summary...

Service "SOP" has 2 instance(s).

  Instance "SOP", status UNKNOWN, has 1 handler(s) for this service...

  Instance "sop", status READY, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

[Sriram2009]

Hi Subhash

Could you check this SAP Note & KBA's 1854060 ,    1785029 ,  1772037

BR

SS

[Former Member]

Dear S Sriram,

Thanks For Quick Reply.

I have check as below:-

Libraries have already been copied

Starting Console...

The system cannot find the path specified.

Program terminated abnormally

Press any key to continue . . .

[Former Member]

Hi experts,

Please help me for this issue.

[Sriram2009]

Hi

Could you pls update the latest log

BR

[Former Member]

Dear Experts,

Config tool connected form SAPSR3DB. When i change user during this possessor for sap sourcing i got same error message.

How to configure new schema for sap sourcing in Secure Store password for config tool ?

Regards,

Subhash N bhalekar

[Former Member]

Dear Experts,

I have created separate database and Schema for sap sourcing . In config tool i have set sap sourcing schema username & password and Url & ClassName . During this activity i am getting Error message as below :-

How to configure Sec.Store.Key or SecStore.properties for sap sourcing ? I thing this erre related to Sec.Store.Key or SecStore.properties file .

Regards,

Subhash N Bhalekar

[steven_bier]

Hi,

did you found a solution ?

Thanks

Steven

[former_member188883]

Hi Subhash,

Please check secure storage in config tool and ensure all the credentials are maintained correctly.

Regards,

Deepak Kori

[Former Member]

Dear Deepak Kori,

Thanks for quickly reply,

I have checked config tool parameters as below :-

ClassName:-oracle.jdbc.driver.OracleDriver

Password:-**********

Url:-jdbc:oracle:thin:@servername:1521:SID

User:-SAPSR3DB

Vai Secure Store:-

D:/usr/sap/SID/SYS/global/security/data/SecStore.properties

D:/usr/sap/SID/SYS/global/security/data/SecStore.key

SID

D:/usr/sap/SID/SYS/global/security/lib

jdbc/pool/SID

D:/usr/sap/SID/J02/exe/ojdbc6.jar

Configtool log as below :-

Error details: Error while connecting to DB.

Nov 21, 2014 1:01:39 PM  Error: com.sap.ASJ.cft.000205 Error occurred while scanning DB.

Error details: Error while connecting to DB.

Nov 21, 2014 2:11:03 PM  Error: com.sap.ASJ.cft.000205 Error occurred while scanning DB.

Error details: while trying to invoke the method java.util.Properties.putAll(java.util.Map) of an object loaded from field com.sap.engine.configtool.visual.ConfigTool.dbProperties of an object loaded from local variable 'this'

Regards,

Subhash N Bhalekar

[Former Member]

Hi Experts,

Please help me.

[former_member188883]

Hi Subhash,

Can you check whether DB is running or not ?

Also check latest log files from work directory.

Regards,

Deepak Kori

[Former Member]

C:\Users\sopadm>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 15:02:10 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 2639106048 bytes

Fixed Size                  2258032 bytes

Variable Size            1325403024 bytes

Database Buffers         1291845632 bytes

Redo Buffers               19599360 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> connect sapsr3db/sapsr3db@sop;

Connected.

SQL> connect sap_prd/password@sop;

Connected.

Regards,

Subhash N Bhalekar