Configtool not connecting to 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..

[prashb]

Manish,

Conifgtool uses SAP Java sceheme user defined by jdbc/pool/SID/User in secure store.

you have to change this sceheme password at DB level using the SQL statements.

Regards

Prashanth

[Former Member]

Hello,

Can you please let me know for which user ID we need to change the password.

Is it SAPSR3DB or sidadm..

I tried to change the password for both of these user,

If there is any other for which we need to change the password then please let me know

====Follwing results I am getting========

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

SQL>

Regards

Manish Gatha

[prashb]

Manish,

can you send the result of the following statement:

select username,account_status,lock_date from dba_users;

Regards

Prashanth

[Former Member]

The result is as below

SQL> select username,account_status,lock_date from dba_users;

USERNAME ACCOUNT_STATUS LOCK_DATE

-

---

-

---

-

---

OPS$XXXXXXXXSAP\SAPSERVICEEC6 OPEN

OPS$XXXXXXXXSAP\EC6ADM OPEN

SYS OPEN

SYSTEM OPEN

SAPSR3 OPEN

OUTLN LOCKED 02-MAY-08

TSMSYS EXPIRED & LOCKED 30-APR-08

DIP EXPIRED & LOCKED 30-APR-08

DBSNMP EXPIRED & LOCKED 02-MAY-08

9 rows selected.

PLease suggect

[prashb]

Manish,

from the output of dba_users, it seems that there is no Java scheme/user in the database. I think the Java DB is located in a different DB server, please check.

Regards

Prashanth

[Former Member]

Java database is on the same server

If you need further details..I can send you that also ..please let me know

[Former Member]

I guess it uses SAPSR3DB as user..I am not sure wheather we can create that