Brconnet Error

[Former Member]

Hi Guys,

When i am tryin to execute Brconnect -f check, I get the following error at CMD.

BR0280I BRCONNECT time stamp: 2010-10-21 08.42.00

BR0301E SQL error -1017 at location db_connect-2, SQL statemen

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance GCD failed

BR0280I BRCONNECT time stamp: 2010-10-21 08.42.01

BR0301E SQL error -1017 at location db_connect-2, SQL statemen

'CONNECT system/*******'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance GCD failed

BR0806I End of BRCONNECT processing: ceejtbeb.chk 2010-10-21 0

BR0280I BRCONNECT time stamp: 2010-10-21 08.42.01

BR0804I BRCONNECT terminated with errors.

But i can schedule the check from BRTOOLS.

Regards

Abhishek

[former_member709110 · Accepted solution]

Hi,

What command did you use ... did you use something like this ...

brconnect -u system/<password> -c -f check

Regards,

Neel

[Former Member · Accepted solution]

Hi

I used brconnect -f check .

i tried connecting as connect /@<SID>

got error ORA-12154: TNS:Could not resolve the connect identifier. specified.

i tried connect sapr3/sap@<SID>

Got the same error.

R3trans -d output is fine.

Regards

Abhishek

[former_member227283 · Accepted solution]

Hi,

CAn you check is there any error in trans.log after you executed R3trans -d.

Thanks

Anil

[former_member709110 · Accepted solution]

Hi Abhishek,

Did you try the command i have given in the earlier post ...

brconnect -u system/<password> -c -f check

My understanding is brconnect -f check might not work without the -u option ...

Regards,

Neel

[former_member227283 · Accepted solution]

Hi,

Neel is right.

Otherwise you can simply excute the below command.

brconnect -u / -f check

Thanks

Anil

[Former Member · Accepted solution]

Hi Guys,

I m able to execute

Brconnect -u / -f check

But why dont brconnect -f check works.?

Thanks Neel and Anil.

How can i award multile points to you both.

[former_member227283 · Accepted solution]

Hi,

brconnect -f check is command whch doesn't contain credential for connecting the database i.e it was getting fail.

Award point to neel, he was on the right track.

Thanks

Anil

[Former Member · Accepted solution]

Hey Guys

I m getting following error after executing brconnect -u / -f check.

BR0280I BRCONNECT time stamp: 2010-10-21 12.31.37

BR0961I Number of conditions found in DBCHECKORA: 118

BR0280I BRCONNECT time stamp: 2010-10-21 12.31.37

BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:

'PREPARE stmt_5 STATEMENT FROM'

'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYP

= 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDER BY OBJNAME'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceejtvmo.chk 2010-10-21 12.31.37

BR0280I BRCONNECT time stamp: 2010-10-21 12.31.37

BR0804I BRCONNECT terminated with errors

Regards

Abhishek

[JPReyes · Accepted solution]

ORA-01031: insufficient privileges

You need to run sapdba_role.sql and sapconn_role.sql to ser the right permissions.

Read,

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Note 834917 - Oracle Database 10g: New database role SAPCONN

Regards

Juan

[Former Member · Accepted solution]

Dear all,

What is the name of Default user used by Brconnect?

Regards,

PC Patel

[Former Member · Accepted solution]

I suggest you must read Note 400241 - Problems with ops$ or sapr3 connect to Oracle

[Former Member]

Hi,

Not # 400241 will solve your problem.

I guess your OS is windows...Though " R3trans -d" returns 00, your brconnect will not work

above note will give the possibilities of error

Regards,

Chitra

[Former Member]

Hi

Please refer the below links which should resolve your issue and also there are lot of posts in SDN with same error. Just try with key word 'ORA-01017: invalid username/password; logon denied' and definetlt it will resolve the issue.

Regards,

Sharath

[former_member227283]

Hi Abhishek,

Run command

R3trans -d

and let us know the output as per log trans.log

Thanks

Anil