ORA-01017: invalid username/password; logon denied - in DB13

[Former Member]

Hello,

We have upgraded successfully from SAP 4.7 / Oracle 9i to ECC 6.0/

Oracle 10g but now the jobs from DB13 are failing. Please find the

error details below.

We have followed the correction steps mentioned in notes: 400241,

437648 and 134592. But the same error persists.

Please help us resolve the issue ASAP.

Error Details:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000201, user ID PWCBASIS)

Execute logical command BRCONNECT On host eccdev

Parameters: -u / -jid CHECK20081107160528 -c -f check

BR0801I BRCONNECT 7.00 (32)

BR0805I Start of BRCONNECT processing: cdzezhoc.chk 2008-11-07 16.05.30

BR0484I BRCONNECT log file: /oracle/DEV/sapcheck/cdzezhoc.chk

BR0280I BRCONNECT time stamp: 2008-11-07 16.05.30

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance DEV failed

BR0280I BRCONNECT time stamp: 2008-11-07 16.05.30

BR0301E SQL error -1017 at location db_connect-2,SQL statement:

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance DEV failed

BR0806I End of BRCONNECT processing: cdzezhoc.chk2008-11-07 16.05.30

BR0280I BRCONNECT time stamp: 2008-11-07 16.05.30

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Please help me resolve this issue....

Thanks

[Former Member · Accepted solution]

The OS are ? How you import the SAPDBA role? Can you say the command line your executed, also on Linux you can check Note 776505 - BR*Tools fail with ORA-01017 / ORA-01031 on Linux

Are you able to connect sqlplus as "sysdba" user ? As "system" user?

Regards.

[Former Member · Accepted solution]

Hi

1. We have upgrade our system to ECC 6.0 SR3, Oracle 10.2 on Solaris 10 OS.

2. We have import the sapdba role as follows:

***********************************************************************

eccdev:oradev 13% sqlplus /nolog @sapdba_role DEV

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Nov 10 15:11:01 2008

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

Disconnected from Oracle Database 10g Enterprise Edition Release

10.2.0.2.0 - 64

bit Production

With the Partitioning and Data Mining options

*********************************************************************

3. We are able to connect to sysdba from system user also.

Please suggest ASAP, please let me know for any other details.

Thanks

[Former Member · Accepted solution]

Try to execute on OS level "brtools" under ORASID and SIDADM users, are you able to star on one of them ?

If yes try to check for testing tablespaces using "space management"

Regards.

[Former Member · Accepted solution]

Hi ,

Yes am able to execute brtools from both the users, viz <sid>adm and ora<sid>. And also able to execute all the scripts from there itself.

For your refrence, find the logs form /usr/sap/DEV/DVEBMGS00/work/dev_w0 file.

Thu Nov 20 13:22:34 2008

M kernel runs with dp version 241(ext=110) (@(#) DPLIB-INT-VERSION-241)

M length of sys_adm_ext is 364 bytes

M ***LOG Q01=> ThInit, WPStart (Workproc 0 1 10354) [thxxhead.c 1290]

M ThInit: running on host eccdev

M calling db_connect ...

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPPRD's password

C Connecting as /@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 10595f0a0 105966b40 10596a4e8

C Attaching to DB Server DEV (con_hdl=0,svchp=10596a418,srvhp=10596c748)

C Starting user session (con_hdl=0,svchp=10596a418,srvhp=10596c748,usrhp=105967358)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11145]

C Try to connect with default password

C Connecting as SAPPRD/<pwd>@DEV on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 10595f0a0 105966b40 10596a4e8

C Starting user session (con_hdl=0,svchp=10596a418,srvhp=10596c748,usrhp=105967358)

C

Please suggest,

Kshitiz Goyal

[Former Member · Accepted solution]

And also able to execute all the scripts from there itself

are you able to backup from OS level using Brtools? try to redo log backup for testing ...

Regards.

[Former Member · Accepted solution]

Hi Sergo,

Yes am able to backup the redo log files from brtools utility.

regards

[Former Member · Accepted solution]

Can you check the owner and perrmisions on brtools, brconnect and other br*

Are on Solaris the saproot.sh script?

Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Regadrs.