on 07-09-2014 7:45 PM
Dear experts,
we are performing activity on our quality server(ABAP+Java) in which we are moving from old operating system to new operating system.
OS - SUSE 10 to SUSE 11
In this process, we are keeping everything same hostname/ mount points/ etc
We are restoring our DB and starting it at new server.
We have performed this activity successfully on our DEV system without any concern. but we are facing below issues while starting our QA system.
I am aware that this is not the ideal method to perform this task, but as of now we are going ahead with this method.
ABAP instance is up fine but java is not able to start,
>> more std_bootstrap.o01
--------------------------------------------------
Bootstrap MODE:
<INSTANCE GLOBALS>
determined by parameter [ID0230973].
--------------------------------------------------
Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:477)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:147)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
----------==[ Caused by: ]==----------
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:365)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:130)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:214)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:46)
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:74)
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:474)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:147)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:946)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:307)
... 14 more
[Bootstrap module]> Problem occurred while performing synchronization.
As per 1866145 - Java is not starting due to a JDBC exception we have increased our processes and session values from 200 to 300 and 400 to 600 respectively, still isssue remains the same.
dev_control snippet
**********************************************************************
JControlStartJLaunch: program = /usr/sap/HRQ/DVEBMGS01/exe/jlaunch
-> arg[00] = /usr/sap/HRQ/DVEBMGS01/exe/jlaunch
-> arg[01] = pf=/usr/sap/HRQ/SYS/profile/HRQ_DVEBMGS01_hsea-pdc-s031
-> arg[02] = -DSAPINFO=HRQ_01_bootstrap
-> arg[03] = -nodeId=-1
-> arg[04] = -file=/usr/sap/HRQ/DVEBMGS01/j2ee/cluster/instance.properties
-> arg[05] = -syncSem=16482383
-> arg[06] = -nodeName=bootstrap
-> arg[07] = -jvmOutFile=/usr/sap/HRQ/DVEBMGS01/work/jvm_bootstrap.out
-> arg[08] = -stdOutFile=/usr/sap/HRQ/DVEBMGS01/work/std_bootstrap.out
-> arg[09] = -locOutFile=/usr/sap/HRQ/DVEBMGS01/work/dev_bootstrap
-> arg[10] = -mode=BOOTSTRAP
-> arg[11] = pf=/usr/sap/HRQ/SYS/profile/HRQ_DVEBMGS01_hsea-pdc-s031
-> arg[12] = -DSAPSTART=1
-> arg[13] = -DCONNECT_PORT=23275
-> arg[14] = -DSAPSYSTEM=01
-> arg[15] = -DSAPSYSTEMNAME=HRQ
-> arg[16] = -DSAPMYNAME=hsea-pdc-s031_HRQ_01
-> arg[17] = -DSAPPROFILE=/usr/sap/HRQ/SYS/profile/HRQ_DVEBMGS01_hsea-pdc-s031
-> arg[18] = -DFRFC_FALLBACK=ON
-> arg[19] = -DFRFC_FALLBACK_HOST=localhost
-> lib path = LD_LIBRARY_PATH=/sapmnt/HRQ/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/jre/lib/amd64/server:/sapmnt/HRQ/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/jre/l
ib/amd64:/sapmnt/HRQ/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/jre/../lib/amd64:/usr/sap/HRQ/DVEBMGS01/exe:/usr/sap/HRQ/DVEBMGS01/exe:/usr/sap/HRQ/DVEBMGS01/exe:/usr/
sap/HRQ/SYS/exe/run:/oracle/client/11x_64/instantclient:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib:/usr/sap/HRQ/DVEBMGS01/j2ee/os_libs:/usr/sap/HRQ/DV
EBMGS01/exe:/usr/sap/HRQ/DVEBMGS01/exe:/usr/sap/HRQ/DVEBMGS01/exe:/usr/sap/HRQ/SYS/exe/run:/oracle/client/11x_64/instantclient
-> exe path = PATH=/usr/sap/HRQ/SYS/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/bin:/usr/sap/HRQ/DVEBMGS01/j2ee/os_libs:/oracle/HRQ/112_64/bin:/usr/sap/HRQ/SYS/exe/jvm/
linuxx86_64/sapjvm_4.1.022/sapjvm_4/bin:.:/home/hrqadm:/usr/sap/HRQ/SYS/exe/run:/home/hrqadm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/us
r/lib/mit/bin:/usr/lib/mit/sbin
**********************************************************************
[Thr 140031216400160] JStartupICreateProcess: fork process (pid 23056)
[Thr 140031216400160] Thu Jul 10 01:32:40 2014
[Thr 140031216400160] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx_mt. 1647]
[Thr 140031216400160] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)
[Thr 140031216400160] [Node: dispatcher bootstrap] java home is set by profile parameter
[Thr 140031216400160] Java Home: /usr/sap/HRQ/SYS/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4
[Thr 140031216400160] JStartupICheckFrameworkPackage: can't find framework package /usr/sap/HRQ/DVEBMGS01/exe/jvmx.jar
**********************************************************************
JStartupIReadSection: read node properties [bootstrap_ID23097300]
-> node name : dispatcher bootstrap
-> node type : bootstrap
-> node execute : yes
-> jlaunch parameters :
-> java path : /usr/sap/HRQ/SYS/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4
-> java parameters : -Djco.jarm=1
-> java vm version : 4.1.022 21.1-b02
-> java vm vendor : SAP Java Server VM (SAP AG)
-> java vm type : server
-> java vm cpu : amd64
-> heap size : 256M
-> root path : /usr/sap/HRQ/DVEBMGS01/j2ee/cluster
-> class path : ./bootstrap/launcher.jar
-> OS libs path : /usr/sap/HRQ/DVEBMGS01/j2ee/os_libs
-> main class : com.sap.engine.offline.OfflineToolStart
-> framework class : com.sap.bc.proj.jstartup.JStartupFramework
-> registr. class : com.sap.bc.proj.jstartup.JStartupNatives
-> framework path : /usr/sap/HRQ/DVEBMGS01/exe/jstartup.jar:/usr/sap/HRQ/DVEBMGS01/exe/jvmx.jar
-> parameters : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID023097300
-> debuggable : yes
-> debug mode : no
-> debug port : 60000
-> shutdown timeout : 120 sec.
**********************************************************************
Dear All,
Respective issue is now resolved.
Since we have migrated to new server , new server ip address was not maintained in
sqlnet.ora , I am still wondering how ABAP isntance was running.
anyways , Thank you all for your co-operation and updated.
Appreciate it.
Warm Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I had the same issue, When I upgrade the kernel to version 721 exe, uc win 64 bit that kernel did not include the ojdbc14 driver files that were in the kernel directory 720 exe folder. I copied the contents from the backup kernel 720 folder to the kernel 721 exe folder and did not over write any existing files. This put the ojdbc14 and other driver files in the kernel directory and that resolved the issue once I restart the SUM software and restart the instance.
Sincerely Chad Hope this helps anyone else that runs into this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
I am not able to set password for SAPSR3DB although isstue still persists
hsea-pdc-s031:hrqadm 121> brconnect -u / -c -f chpass -o SAPSR3DB -p kop14#hrq -s java -OJS
BR0801I BRCONNECT 7.20 (36)
BR0280I BRCONNECT time stamp: 2014-07-10 09.14.04
BR0828I Changing password for database user SAPSR3DB ...
BR0280I BRCONNECT time stamp: 2014-07-10 09.14.04
BR0829I Password changed successfully in database for user SAPSR3DB
BR0280I BRCONNECT time stamp: 2014-07-10 09.14.04
BR1525I Setting password for database user SAPSR3DB in secure storage /usr/sap/HRQ/SYS/global/security/data/SecStore.properties ...
BR0280I BRCONNECT time stamp: 2014-07-10 09.14.07
BR1526I Password set successfully for database user SAPSR3DB in secure storage /usr/sap/HRQ/SYS/global/security/data/SecStore.properties
BR0280I BRCONNECT time stamp: 2014-07-10 09.14.07
BR0802I BRCONNECT completed successfully
----------------------------
I am able to connect using SAPSR3DB manually.
hsea-pdc-s031:hrqadm 51> sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 10 09:27:26 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sapsr3db
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> !date
Thu Jul 10 09:27:41 ICT 2014
------------------------------------
Is there any other way to check how can I connect ?
why this java is not able to connect.......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Divyanashu,
Please find attached.
I am still getting same errror.
[Jul 10, 2014 9:35:12 AM ] Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
.
.
.
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
.
.
.
Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
Warm regards,
Your replies are not really helpful for us. In order to help you, you need to supply more information.
Apart from the PSAPTEMP error message are there any other errors present in the alert log ?
Do you have these files present at the OS level under the ownership of hrqadm:sapsys ?
/sapmnt/HRQ/global/security/data/SecStore.key
/sapmnt/HRQ/global/security/data/SecStore.properties
/sapmnt/HRQ/global/security/lib
/oracle/client/10x_64/instantclient/ojdbc14.jar
Do ls -la against all the above files/directories and see if they are present.
Did you move the instance by manually copying the J2EE files ?
Check whether the SAPSR3DB user is locked or not.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear RB,
I have checked alert_log but unfortunately i dont see any other error. Please find attached txt file of last 2000 entries as file size is little too big 134 mb.
I checked below files, these are all present with hrqadm.sapsys
hsea-pdc-s031:hrqadm 86> ls -la /sapmnt/HRQ/global/security/data/SecStore.key
-rwxrwxr-x 1 hrqadm sapsys 21 Jun 25 2008 /sapmnt/HRQ/global/security/data/SecStore.key
hsea-pdc-s031:hrqadm 87> ls -la /sapmnt/HRQ/global/security/data/SecStore.properties
-rwxrwxr-x 1 hrqadm sapsys 758 Jul 10 08:50 /sapmnt/HRQ/global/security/data/SecStore.properties
hsea-pdc-s031:hrqadm 88> ls -la /sapmnt/HRQ/global/security/lib
total 0
drwxr-xr-x 4 hrqadm sapsys 96 Sep 9 2013 .
drwxr-xr-x 4 hrqadm sapsys 96 Jun 24 2008 ..
drwxr-xr-x 3 hrqadm sapsys 104 Sep 9 2013 engine
drwxr-xr-x 3 hrqadm sapsys 232 Sep 9 2013 tools
hsea-pdc-s031:hrqadm 89> ls -la /oracle/client/10x_64/instantclient/ojdbc14.jar
-rwxrwxr-x 1 hrqadm sapsys 1557777 Feb 11 2009 /oracle/client/10x_64/instantclient/ojdbc14.jar
hsea-pdc-s031:hrqadm 90>
All file system is manually sync from original server which is running on suse 10.
I am aware that this method is not SAP recommended but we have tried this method in our DEV envrionment and its working smoothly.
SAPSR3DB is not locked and I can connect if I use sqlplus and give its credentials.
SQL> select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SAPSR3DB OPEN
OUTLN OPEN
OPS$HRQADM OPEN
OPS$SAPSERVICEHRP OPEN
OPS$ORAHRP OPEN
OPS$HRPADM OPEN
OPS$ORAHRQ OPEN
SAPSR3 OPEN
SYS OPEN
SYSTEM OPEN
DIP EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
DBSNMP EXPIRED & LOCKED
ORACLE_OCM EXPIRED & LOCKED
APPQOSSYS EXPIRED & LOCKED
14 rows selected.
--------
hsea-pdc-s031:hrqadm 104> sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 10 09:01:41 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: SAPSR3DB
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> !date
Thu Jul 10 09:01:59 ICT 2014
----------
Regards,
Are you able to launch the ConfigTool ?
Were you able to start ABAP successfully ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear RB
Thanks for quick response.
Yes i am able to start ABAP successfully. its up and running fine.
ConfigTool - I am not able to connect.
SecStore - User credentials of SAPSR3DB adn j2ee_admin are correct but still its not conencting to DB.
I tried to change password
brconnect -u / -c -f chpass -o SAPSR3DB -p <pwd> -s java
but failed with return code 1.
"
/usr/sap/HRQ/SYS/global/security/data/SecStore.properties -key /usr/sap/HRQ/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask': 1
BR1527E Setting password for user SAPSR3DB in secure storage /usr/sap/HRQ/SYS/global/security/data/SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed
"
System.log of configtool says
#1.#005056933E010000000000051C3855160004FDC5C6449F43#1404925783612#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Er
ror#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection {3}: code={0,number,integer}
, state="{1}", message="{2}".#5#17002#<null>#Io exception: Got minus one from a read call#jdbc:oracle:thin:@hsea-pdc-s031:1527:HRQ#<null>#
Any suggestions?
warm regards,
Hi,
Please attach
Also check are you able to login to configtool
Java schema user password
Regards
Divyanshu
What DB are you using? Did you upgrade? I know Oracle from 10 to 11 has a complete different secure store...
Anyways, read my similar issue..might not be close, but might lead you different ways..I acutally found a missing file in my kernel that was the reason my config tool wouldn't load.
Sorry I see you are using brtools, so ya Oracle.
I had this help me also..
brconnect -u system/USER -c -f chpass -o SAPSR3DB -p PASSWORD -s java –OJS
In addition, you must set the special option "-OJS" (old Java system) for the BRCONNECT call, for example:
brconnect -u / -c -f chpass -o SAPSR3DB -p <password> -s java -OJS
Dear Divayanshu,
Please find attached logs.
STD*
--------------------------------------------------------------------------------
stdout/stderr redirect
--------------------------------------------------------------------------------
node name : server0 bootstrap
pid : 23334
system name : HRQ
system nr. : 01
started at : Thu Jul 10 01:33:44 2014
(CompilerOracle read from file /sapmnt/HRQ/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/jre/.hotspot_compiler)
--------------------------------------------------------------------------------------
I am able to connect using SAPSR3DB user via sqlplus but i am not able to connect via configtool.
I am not sure why its not connecting to DB ;-s
tried as per 1513450 - Configtool error - Cannot open secure store but its not working
Regards,
Bond
Dear Joshua,
I am unable to set it in secure store
sidadm 99> brconnect -u / -c -f chpass -o SAPSR3DB -p <pwd> -s java -OJS
BR0801I BRCONNECT 7.20 (36)
BR0280I BRCONNECT time stamp: 2014-07-10 03.02.49
BR0828I Changing password for database user SAPSR3DB ...
BR0280I BRCONNECT time stamp: 2014-07-10 03.02.49
BR0829I Password changed successfully in database for user SAPSR3DB
BR0280I BRCONNECT time stamp: 2014-07-10 03.02.49
BR1525I Setting password for database user SAPSR3DB in secure storage /usr/sap/HRQ/SYS/global/security/data/SecStore.properties ...
BR0278E Command output of '/usr/sap/HRQ/SYS/exe/run/brtools -f printpwd -U /usr/sap/HRQ/SYS/global/security/data/.java.pwf | /usr/sap/HRQ/SYS/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/bin/java -DSAPSYSTEMNAME=HRQ -classpath /usr/sap/HRQ/SYS/global/sltools/sharedlib/launcher.jar com.sap.engine.offline.OfflineToolStart com.sap.inst.secstore.AdjustSecureStoreFS /usr/sap/HRQ/SYS/global/sltools/sharedlib:/usr/sap/HRQ/SYS/global/security/lib/tools -sidSource HRQ -sidTarget HRQ -sec /usr/sap/HRQ/SYS/global/security/data/SecStore.properties -key /usr/sap/HRQ/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask':
Exception in thread "main" java.lang.UnsupportedClassVersionError: com/sap/inst/secstore/AdjustSecureStoreFS : Unsupported major.minor version 49.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:618)
at com.sap.engine.offline.FileClassLoader.findClass(FileClassLoader.java:702)
at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:600)
at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:578)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:79)
BR0280I BRCONNECT time stamp: 2014-07-10 03.02.49
BR0279E Return code from '/usr/sap/HRQ/SYS/exe/run/brtools -f printpwd -U /usr/sap/HRQ/SYS/global/security/data/.java.pwf | /usr/sap/HRQ/SYS/exe/jvm/linuxx86_64/sapjvm_4.1.022/sapjvm_4/bin/java -DSAPSYSTEMNAME=HRQ -classpath /usr/sap/HRQ/SYS/global/sltools/sharedlib/launcher.jar com.sap.engine.offline.OfflineToolStart com.sap.inst.secstore.AdjustSecureStoreFS /usr/sap/HRQ/SYS/global/sltools/sharedlib:/usr/sap/HRQ/SYS/global/security/lib/tools -sidSource HRQ -sidTarget HRQ -sec /usr/sap/HRQ/SYS/global/security/data/SecStore.properties -key /usr/sap/HRQ/SYS/global/security/data/SecStore.key -dbUser SAPSR3DB -useStdin -nomask': 1
BR1527E Setting password for user SAPSR3DB in secure storage /usr/sap/HRQ/SYS/global/security/data/SecStore.properties failed
BR0832E Changing password for user SAPSR3DB failed
BR0280I BRCONNECT time stamp: 2014-07-10 03.02.49
BR0804I BRCONNECT terminated with errors
its terminating with return code 1.
Regards,
Dear RB,
permissions along with users checked they are same as that of DEV system for /usr/sap/HRQ/SYS/global/security.
There is below error in system.log -
#005056933E010000000000055C9FD14A0004FDC7DB033264#1404934721580#/System/Database/sql/jdbc##com.sap.sql.jdbc.NativeConnectionFactory#######Thread[main,5,main]##0#0#Error#1#com.sap.sql.jdbc.NativeConnectionFactory#Java#com.sap.sql_0002#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection {3}: code={0,number,integer}, state="{1}", message="{2}".#5#17002#<null>#Io exception: Got minus one from a read call#jdbc:oracle:thin:@hsea-pdc-s031:1527:HRQ#<null>#
Any hint?
Regards,
Dear RB
126> more config.properties
#Generated by Config Tool
#Wed Jun 25 19:05:44 ICT 2008
rdbms.maximum_connections=5
system.name=HRQ
secstorefs.keyfile=/sapmnt/HRQ/global/security/data/SecStore.key
secstorefs.secfile=/sapmnt/HRQ/global/security/data/SecStore.properties
secstorefs.lib=/sapmnt/HRQ/global/security/lib
rdbms.driverLocation=/oracle/client/10x_64/instantclient/ojdbc14.jar
rdbms.connection=jdbc/pool/HRQ
rdbms.initial_connections=1
Oracle client 11 is also available in system.
Alert.log suggest below error -
Cannot re-create tempfile /oracle/HRQ/sapdata4/temp_2/temp.data2, the same name file exists
but i believe its not related to this.
regards,
Dear Divyanshu,
respective file is present
hsea-pdc-s031:hrqadm 115> ls -la /usr/sap/HRQ/SYS/global/sltools/sharedlib/checkKeyPhrase.jar
-rw-r--r-- 1 hrqadm sapsys 22299 Jul 10 00:12 /usr/sap/HRQ/SYS/global/sltools/sharedlib/checkKeyPhrase.jar
hsea-pdc-s031:hrqadm 116>
I have tried setting env BR_JAVA_HOME = $ORACLE_HOME/jdk and restarted system still the issue persists.
Please see below alerts log attached in blog.
Any other idea?
Warm regards,
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.