BR0301E SQL error -1017 at location db_connect-2 during DB13

[Former Member]

While executing the check database through DB13 following error is showing by this t-code

08.12.2009 08:00:30 Job started

08.12.2009 08:00:30 Step 001 started (program RSDBAJOB, variant &0000000000178, user ID 11001481)

08.12.2009 08:00:31 Execute logical command BRCONNECT On host eccect

08.12.2009 08:00:31 Parameters: -u / -jid CHECK20091013080000 -c -f check

08.12.2009 08:00:31 SXPG_COMMAND_EXECUTE(LONG)

08.12.2009 08:00:31 COMMANDNAME = BRCONNECT

08.12.2009 08:00:31 OPERATINGSYSTEM = ANYOS

08.12.2009 08:00:31 TARGETSYSTEM = eccect

08.12.2009 08:00:31 DESTINATION =

08.12.2009 08:00:31 BR0801I BRCONNECT 7.00 (33)

08.12.2009 08:00:31 BR0805I Start of BRCONNECT processing: cecbuhnj.chk 2009-12-08 08.00.31

08.12.2009 08:00:31 BR0484I BRCONNECT log file: /oracle/ECT/sapcheck/cecbuhnj.chk

08.12.2009 08:00:31 BR0280I BRCONNECT time stamp: 2009-12-08 08.00.31

08.12.2009 08:00:31 BR0301E SQL error -1017 at location db_connect-2,SQL statement:

08.12.2009 08:00:31 'CONNECT /'

08.12.2009 08:00:31 ORA-01017: invalid username/password; logon denied

08.12.2009 08:00:31 BR0310E Connect to database instance ECT failed

08.12.2009 08:00:31 BR0280I BRCONNECT time stamp: 2009-12-08 08.00.31

08.12.2009 08:00:31 BR0301E SQL error -1017 at location db_connect-2,SQL statement:

08.12.2009 08:00:31 'CONNECT /'

08.12.2009 08:00:31 ORA-01017: invalid username/password; logon denied

08.12.2009 08:00:31 BR0310E Connect to database instance ECT failed

08.12.2009 08:00:31

08.12.2009 08:00:31 BR0806I End of BRCONNECT processing: cecbuhnj.chk2009-12-08 08.00.31

08.12.2009 08:00:31 BR0280I BRCONNECT time stamp: 2009-12-08 08.00.31

08.12.2009 08:00:31 BR0804I BRCONNECT terminated with errors

08.12.2009 08:00:31 External program terminated with exit code 3

08.12.2009 08:00:31 BRCONNECT returned error status E

08.12.2009 08:00:32 Job finished

This ECT client i have made through system copy while restoring the backup of Production server on this client afterward make a new client 500 (production client ) to new client 590. every thing is working fine. but while executing DB13 commands as well as backup through BR tools this error comes.

Could somebody resolve this error , i will be very thankful

Ravi kant Arya

[Former Member]

Hi,

Execute the below queries at SQL*PLUS promp

select username from dba_users;

Here look for user OPS$ORA<SID>. If it is not created then create it using below query.

create user OPS$ORA<SID> identified by sap default tablespace SYSTEM temporary tablespace PSAPTEMP;

Create SAPUSER table for this user.

create table OPS$ORA<SID>.sapuser (USERID VARCHAR2(255),PASSWD VARCHAR2(255));

Insert the your schema user id (Standard is SAPSR3) & its password in the OPS$ORA<SID>.sapuser table

insert into OPS$ORA<SID>.sapuser values (u2018SAPSR3u2019,u2019sapu2019);

Grand the roles

grant connect, resource, SAPCONN to OPS$ORA<SID> with admin option;

Commit;

This will solve your issue.

Thanks,

Sachin Sable

[Former Member]

Thanks

Problem has been solved

Regards

Ravi Kant Arya

[Former Member]

Friends

a smal corretion here

its not OPS$ORA<SID>

but OPS$<SID>ADM User to be created.

I faced the same issue.

resolved by following the note '

SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

o Check whether creating the OPS$ mechanism in accordance with to

Note 50088 (WINDOWS) or Note 361641 (UNIX) solves the problem.

o The table SAPUSER must occur in the system only once and it must be

assigned to the user OPS$<sid>ADM. Use the following query to check

this:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

If the system returns an owner <owner> other than OPS$<sid>ADM, you

must delete the relevant SAPUSER tables:

DROP TABLE "<owner>".SAPUSER;

If the system does not return OPS$<sid>ADM, you must create the

table SAPUSER as <sid>adm and enter the password:

CREATE TABLE "OPS$<sid>ADM".SAPUSER

(USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>',

'<password>');

[Former Member]

Hi,

Go through SAP notes 400241 and 50088

Regards

Nick Loy

[Former Member]

Hi,

Need to delete the old entry for you OPS$<old sid> and recreate it for your new sid...

as specified in the note 400241 as mentioned above.

Mark

[Former Member]

Hi Ravi,

Have you checked notes 400241,776505 ?

Cheers...,

Raghu