cancel
Showing results for 
Search instead for 
Did you mean: 

DBACOCKPIT - connect to remote Oracle DB

Former Member
0 Kudos

Hallo,

I need help. I want to use Solution Manager DBACOCKPIT for accessing to remote

databases (ERP prod, ERP test, BW prod, BW test, Enterprise Portal prod and

Enterprise Portal test). I was successful with ERP prod, ERP test and BW prod.

For connecting to ABAP system databases I use user SAPSR3. But in BW test

connection doesn't work. Problem is in user and I don´t know reason, because

I think, that the password is OK.

-- ERROR Database connection %_OBT_OSTRBWT1: SQL error 1017 ORA-01017: invalid username/password; logon denied

Which user do I use for Java system database (EP)? I tried SAPSR3, SAP...

Nothing doesn´t work.

I looked at a lot of notes (1028624, 1261329, 1139623, 1025707), but nothing

helped.

I´m helpless.

Thanks for some help.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can find out the schema user with:

select username from dba_users where username like '%SAP%'

(Run sqlplus / "as sysdba" as <sid>adm on the host of your BW java system).

You'll proably find it is SAP<SID>DB

Best of luck,

Marcel.

Former Member
0 Kudos

Hi Marcel,

thanks for your reply. Your sql command confirmed, that BW test (this is Abab system) user is SAPSR3 and EP test and prod ( java systems) users are SAP<sid>DB. But with this users I have same problem.

-- ERROR Database connection %_OPT_EPTEST: SQL error 1017 ORA-01017: invalid username/password; logon denied

It is unlikely that I have wrong password.

Former Member
0 Kudos

I guess first confirm the password is correct by just starting sqlplus and logging in an the schema user.

e.g.

sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 10 07:28:10 2011

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

Enter user-name: sapsr3

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

SQL>

The Oracle error code is defintely unahppy with the user / password combination

You could perfrom a temporary test by setting up the connection using user system if you know the password.

But if you do this only set up the DB connection and test it then change it back don't do anything in else in dbacockpit!

Former Member
0 Kudos

I tried it in all systems. And you are right. I cannot logon with my password. I didn´t install this systems I only took over them. I took over passwords too. And it seems, that their are different in some systems.