Configtool not connecting to the database

[Former Member]

Hello All,

I am stucked up in following issue.

Its very urgent...

We are unable to connect to configtool.It says........ unable to connect the database.User/password not corrrect.....

I tried to change the password of user in config tool secure Store-->jdbc/pool/<SID>/Password

But its not working,

I want to know which usrid is used by configtool to connect the database and if we change the password and where else its password is maintined and how to change it.

Points will be awarded..

Manish

[Former Member · Accepted solution]

Hi

The user id that is used to connect configtool is SAPSR3DB (present in Configtool and Oracle).

This is Java schema user-id.

So change the passwod in ConfigTool and also change it at Oracle level.

Use the BRTools utility to change the SAPSR3DB password.

[Former Member · Accepted solution]

Hello Deepak,

I changed the password for user SAPSR3DB using BRtools and also changed the same in secure store in field

jdbc/pool/<SID>/password

But its not working mentioning the same reason that check user/password

Any Idea about possible solution

Would be highly appriicated

Manish

[Former Member · Accepted solution]

Hello Deepak,

I used BRTOOLS without error..but didnt work..

Then i used SQL statements and getting following error.

==========================================

C:\Documents and Settings\ec6adm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jun 25 12:23:07 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> alter user SAPSR3DB identified by cts123$;

alter user SAPSR3DB identified by cts123$

*

ERROR at line 1:

ORA-01918: user 'SAPSR3DB' does not exist

=============================

Please suggest

Manish Gatha

[Former Member · Accepted solution]

Hi

Use this query:

desc dba_users;

select <username> from dba_users;

The user end with DB is the user for Java database.

Change the password according to the password you had given in Configtool.

If you are not able to connect, then select the option 'NO" in the popup.

Select the Overwrite RDBMS configuration

In URL put this jdbc:oracle:thin:@<host name>:<SID>

User Put the username you get from the query

Password Put the password you changed above.

[Former Member · Accepted solution]

Hello,

I am not getting any user record where user name ends with "DB".I guess you are pointing towards SAPSAR3DB.

If yes then do we need to create it again? if yes then how

Please find below the result

SQL> select username from dba_users;

USERNAME

-

---

OPS$CTSINPUNSAP\SAPSERVICEEC6

OPS$CTSINPUNSAP\EC6ADM

SYS

SYSTEM

SAPSR3

OUTLN

TSMSYS

DIP

DBSNMP

Please suggest

9 rows selected.

[Former Member · Accepted solution]

Hi

Use this query to create the user:

CREATE USER SAPSR3DB IDENTIFIED BY SAPSR3DB DEFAULT TABLESPACE PSAPSR3DB

TEMPORARY TABLESPACE PSAPTEMP;

Then use this note to import the roles:

134592 Importing the SAPDBA role ( sapdba_role.sql)

But before that check the tablespace with the name PSAPSR3DB is present.

use this query:

select TABLESPACE_NAME from dba_tablespaces;

[Former Member · Accepted solution]

Hai,

As there is no SAPSR3DB user in the database. Use SAPSR3 and reset the password as mentioned previously.

And also update jdbc/pool/SID/User as SAPSR3 in the configtool secure store and check.

Also check whether you can able to login into offlinecfgeditor or not by clicking on offlinecfgeditor.bat

Thanks and Regards,

[Former Member · Accepted solution]

Hello Venkata/Deepak

Thanks a lot SAPSR3 connects but i am stuck up in other problem.

I am not able to see any more options after getting connected I can only see secure store option as earlier..

I tried the option File---->Reload data from DB

And getting the error message ---Error While Connecting to DB"

Point are rewarded---Please suggest further

Manish