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

[former_member209809]

Dear Experts,

I have recently performed system copy by Backup/Restore method.

While scheduling any task in DB13 (online bkup,offline bkup,DB chk,etc) system is giving error as

    Job started

    Step 001 started (program RSDBAJOB, variant &0000000006438, user ID *****)

    Execute logical command BRCONNECT On host CMSAPPRDDBSRV

    Parameters: -u / -jid STATS20121105162457 -c -f stats -t ALL

    BR0801I BRCONNECT 7.20 (27)

    BR0805I Start of BRCONNECT processing: cejuvnah.sta 2012-11-05 16.24.59

    BR0484I BRCONNECT log file: K:\oracle\TCP\sapcheck\cejuvnah.sta

    BR0280I BRCONNECT time stamp: 2012-11-05 16.24.59

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

    'CONNECT /'

    ORA-01017: invalid username/password; logon denied

    BR0310E Connect to database instance TCP failed

    BR0280I BRCONNECT time stamp: 2012-11-05 16.24.59

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

    'CONNECT /'

    ORA-01017: invalid username/password; logon denied

    BR0310E Connect to database instance TCP failed

I have tried with Note    400241 and 50088 also running oradbuser.sql but still issue persist.

When i try to use BRTOOLS and perform DBcheck then it continues without fail but same is giving issue in SAP DB13.

OS:windows 2008 R2

Oracle : 11.2.0.2

SAP : ECC 6   

Your suggestions would be highly appreciated.

Thanks and Regards

Sumit

[Former Member]

Hi Sumit,

Are you able to connect to the database, by using command, below;

sqlplus /

If you can't, double check the OPS$ users and rights.

Best regards,

Orkun Gedik

[former_member209809]

Hi Orkun,

Thanks for your reply.

I am able to connect with sqlplus /

Thanks and Regards,

Sumit

[Former Member]

To be sure, execute the statements, below;

SQL> CREATE USER "OPS$DOMAIN\SIDADM" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
SQL> CREATE USER "OPS$DOMAIN\SAPSERVICESID" DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;
SQL> GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$DOMAIN\SIDADM";
SQL> GRANT CONNECT, RESOURCE, SAPDBA TO "OPS$DOMAIN\SAPSERVICESID";
SQL> CREATE TABLE "OPS$DOMAIN\SIDADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
SQL> INSERT INTO "OPS$DOMAIN\SIDADM".SAPUSER VALUES ('<DATABASE OWNER>', '<password>');
SQL> CREATE SYNONYM "OPS$DOMAIN\SAPSERVICESID".SAPUSER FOR "OPS$DOMAIN\SIDADM".SAPUSER;

SQL> CONNECT /
SQL> GRANT SELECT, UPDATE ON "OPS$DOMAIN\SIDADM".SAPUSER TO "OPS$DOMAIN\SAPSERVICESID";

SQL> CONNECT /as sysdba
SQL> GRANT CONNECT, RESOURCE TO "OPS$DOMAIN\SAPSERVICESID";
SQL> GRANT CONNECT, RESOURCE TO "OPS$DOMAIN\SIDADM";

Change the password at the OS level;

brconnect -c -u / -f chpass -o OPS$DOMAIN\SAPSERVICESID -p <password>
brconnect -c -u / -f chpass -o OPS$DOMAIN\SIDADM -p <password>

Additionally, check the SAPServiceSID is under the groups, below;

ORA_<SID>_DBA

ORA_<SID>_OPER

Best regards,

Orkun Gedik

[former_member209809]

Hi Orkun,

I have already tried creating OPS$ users manually and granting them roles which you have specified but still issue remains same in DB13.

Warm Regards,

Sumit

[former_member209809]

Hi Orkun,

I have already tried creating OPS$ users manually and granting them roles which you have specified but still issue remains same in DB13.

Warm Regards,

Sumit

[Former Member]

Hi Sumit,

Could you check the note, below;

1576837 - ORA-01017: invalid username/password;

Additionally, check the SAP service user at the OS level under services at control panel. It should be SAPService<SID>

Best regards,

Orkun Gedik

[volker_borowski2]

Hmm,

contradiction:

1) Do NOT assign SYSTEM as the default TS. Do assign the PSAPSIDUSR TS

2) Change the password for the schema User (SAPSR3 or SAPSID) to populate the SAPUSER table. Trying changing passwords for externally identified users make not so much sense...

Additional question:

3) Do you have a DOMAIN installation? Or do you have a local installation?

4) If you have the later, -> Do you have a standalone DB Server (CMSAPPRDDBSRV suggests so) ?

-> In this case it gets complicated without using DOMAIN Users.

5) if on standalone DB Server and execution through standalone gateway

-> You need to use an OPS$ User that corresponds to the User properties of the gateway!

Volker

[former_member636991]

Orkun Gedik,

It worked for me, Thanks alot!

it saved my life!

Thanks,

Faizan

[former_member636991]

Orkun write the same answer on this thread I would like to [] mark that question answered as well

http://scn.sap.com/thread/3343736

[UPDATED BY MODERATOR]