on 11-21-2014 6:58 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Subhash,
Could you refer this note
1561655 - Failed to start J2EE config tool due to scanning DB error
Regards,
Dhuvaraganathan M.
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
subhash,
Can you please check SAPJVMs are in same version?
- Nikhil Bose
Dear Nikhil Bose,
Thanks For Quickly Reply.
I have upgrade latest version SAPJVMS on Application server .
Thanks & Regars,
Subhash N Bhalekar
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>
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 . . .
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
Hi Subhash,
Please check secure storage in config tool and ensure all the credentials are maintained correctly.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.