on 02-09-2011 12:59 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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!
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.