Skip to Content
author's profile photo Former Member
Former Member

Java Stack not connecting with DB after Oracle Upgrade

Oracle Upgrade Java Stack not connecting with DB

Hi I have just performed the Oracle Upgrade on the Server from 10g to
11g and after the Upgrade the ABAP Stack has come up but the Java Stack
is not getting connecting with the DB.

When I try to connect to the Configtool it gives me the error that
check if the DB is running or not.

I have followed the following link on the SCN and changed the password for the SAPSR3DB user

http://scn.sap.com/thread/3447030

When I used the command entered here to change the password of the SAPSR3DB it changed but it did not let me use the

-s java -RDB option

i.e.

brconnect -u system/password -c -f chpass -o SAPSR3DB -p password -s java -RDB

I am not able to connect to the Configtool

I am doing this on the Dev server and then I have to perform this on
the Production Server
I am attaching the log file i.e. log_bootstrap

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

INFO: Loading tool launcher...
INFO: [OS: HP-UX] [VM vendor: SAP AG] [VM version: 1.5.0_14] [VM type: SAP Java 64-Bit Server VM]
INFO: Main class to start: "com.sap.engine.bootstrap.Bootstrap"
INFO: Loading 23 JAR files: [/usr/sap/<SID>/SYS/global/security/lib/tools/iaik_jce.jar, /usr/sap/<SID>/SYS/global/security/lib/tools/iaik_ssl.jar, /usr/sap/<SID>/SYS/global/security/lib/tools/iaik_jsse.jar, /usr/sap/<SID>/SYS/global/security/lib/tools/w3c_http.jar, /usr/sap/<SID>/SYS/global/security/lib/tools/iaik_smime.jar, ./bootstrap/sap.com~tc~je~extramile.jar, ./bootstrap/sap.com~tc~je~bootstrap~impl.jar, ./bootstrap/sap.com~tc~sec~secstorefs~java~core.jar, ./bootstrap/sap.com~tc~logging~java~impl.jar, ./bootstrap/sap.com~tc~bl~opensql~implStandalone.jar, ./bootstrap/sap.com~tc~bl~offline_launcher~impl.jar, ./bootstrap/sap.com~tc~exception~impl.jar, ./bootstrap/sap.com~tc~bl~iqlib~impl.jar, ./bootstrap/sap.com~tc~bl~config~impl.jar, ./bootstrap/sap.com~tc~je~offlineconfiguration~impl.jar, ./bootstrap/sap.com~tc~je~flightrecorder.jar, ./bootstrap/sap.com~tc~je~cfs~container~standalone_impl.jar, ./bootstrap/sap.com~tc~bl~deploy~offline~impl.jar, ./bootstrap/jdbc.jar, ./bootstrap/jperflib.jar, ./bootstrap/sap.com~tc~sapxmltoolkit~sapxmltoolkit.jar, ./bootstrap/iaik_jce.jar, ./bootstrap/sap.com~tc~bl~jdsr~jdsr.jar]
INFO: Start

* Configuring bootstrap...
Found bootstrap properties file [/usr/sap/<SID>/DVEBMGS00/j2ee/cluster/bootstrap/bootstrap.properties]
* Done for 471 ms

* Memory available to the bootstrap JVM: 2 GiB / 2863333376 bytes

-----[Bootstrap Module started]--------[Thu Jul 24 15:50:53 IST 2014]-------

+------------[Bootstrap synchronization activities information]-----------+
| Runtime Binaries: [X] Native files: [X] Instance Properties: [X] |
| Nodes Structure: [X] Cluster File System: [X] Online bootstrap: [ ] |
+-------------------------------------------------------------------------+

None of the startup parameters passed: [-DSAPSTART=1, -DSAPSYSTEM=00, -DSAPSYSTEMNAME=<SID>, -DSAPMYNAME=mtspidev_<SID>_00, -DSAPPROFILE=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS00_mtspidev, -DFRFC_FALLBACK=ON, -DFRFC_FALLBACK_HOST=localhost] is known to the bootstrap. Activating the default mode - synchronize all (-all).
* Properties used for initialization: {element.resynch=detect, Logging properties = {log[defaultTrace]=FileLog, .logs=log[defaultTrace],log[consoleLog], log[defaultTrace].pattern=../../work/log_bootstrap.log, /.severity=Info, log[consoleLog].formatter=formatter[ConsoleFormatter], formatter[ConsoleFormatter]=TraceFormatter, log[consoleLog]=com.sap.engine.bootstrap.logging.BootstrapConsoleLog, log[defaultTrace].cnt=3, formatter[BootstrapFormatter]=TraceFormatter, log[defaultTrace].formatter=formatter[BootstrapFormatter], formatter[ConsoleFormatter].pattern=%m, log[defaultTrace].limit=5242880, .severity=Info, formatter[BootstrapFormatter].pattern=[%24d] %m}, debug=no, Watchdog properties = {watchdog.timeout=90000, watchdog.check_interval=2000}}
* Bootstrap initialized for 729 ms

* Watchdog [90000 ms] checking every [2000 ms] started.

* Initializing DB connection...
SecStoreFS object initialized.
setDefaultFilenames () called, filename = "/usr/sap/<SID>/SYS/global/security/data/SecStore.properties".
File version = "7.00.000.001", software version = "7.00.000.001".
File version = "7.00.000.001", software version = "7.00.000.001".
setDefaultKeyFilename () called, filename = "/usr/sap/<SID>/SYS/global/security/data/SecStore.key".
Check record okay.
Existing store opened.
File version = "7.00.000.001", software version = "7.00.000.001".
Entering setDefaultsFromProperties()
com.sap.sql.trace.j2ee.cnt is 10
com.sap.sql.trace.j2ee.limit is 10000000
Exiting setDefaultsFromProperties()
Component: [internal/unkown] of type [unkown]
Message: [Exception occurred:]
com.sap.engine.bootstrap.SynchronizationException: Database connection initialization failed. Check if the database is running and the database properties.
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:114)
at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:156)
----------==[ 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:432)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:178)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:48)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:127)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:262)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:39)
at com.sap.engine.bootstrap.HelperImpl.getConfigurationHandlerFactory(HelperImpl.java:38)
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:111)
at com.sap.engine.bootstrap.Bootstrap.initializeSynchronizer(Bootstrap.java:74)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:229)
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:585)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:156)
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:790)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
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.connect.factory.DriverPooledConnectionFactory.createVendorConnection(DriverPooledConnectionFactory.java:50)
at com.sap.sql.connect.factory.DriverPooledConnectionFactory.getPooledConnection(DriverPooledConnectionFactory.java:37)
at com.sap.sql.connect.datasource.DBDataSourceImpl.createPooledConnection(DBDataSourceImpl.java:674)
at com.sap.sql.connect.datasource.DBDataSourceImpl.newPooledConnection(DBDataSourceImpl.java:624)
at com.sap.sql.connect.datasource.DBDataSourceImpl.getPooledConnection(DBDataSourceImpl.java:164)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:208)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:376)
... 14 more


[Bootstrap]> Problem occurred while performing synchronization. For more details see the logs above.

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

Help is appreciated.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 24, 2014 at 09:56 AM

    Hi Aps,

    -After changing the password of SAPSR3DB by the help of below command

    brconnect -u system/password -c -f chpass -o SAPSR3DB -p password -s java -RDB


    , did you try to maintain the same password in secure storage of configtool.

    - Also try to logon to oracle with the SAPSR3DB

    sqlplus /nolog

    sql> connect SAPSR3DB/<password>

    With Regards

    Ashutosh Chaturvedi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2014 at 07:12 AM

    Hi Folks,

    I am now able to connect the JAVA Stack with the DB as the SAP MMC and the following command gives all green with the sapcontrol, but some how I am not able to connect with the configtool

    When I select the option of connect with the DB it tells me that the

    Error When scanning the DB

    Error while connecting with the DB

    and then when I press OK on that window another window opens with the following message:

    Error occured while loading the secure store

    Msg: File "/usr/sap/<SID>/SYS/global/security/data/secstore.properties" does not exist although it should

    When I went to the particular location the file is present

    Help is appreciated

    Thanks

    APS


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.