DB installtion error

[Former Member]

Hi experts,

Could any one help me in solving this issue please............

I have installed CI and started DB installtion in windows 2003 server with oracle10g

At the database statistics i got struck and could not rectify why this error happens

brconnec.log shows

BR0801I BRCONNECT 7.00 (48)

BR0280I BRCONNECT time stamp: 2010-05-31 17.29.54

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TVS failed

BR0280I BRCONNECT time stamp: 2010-05-31 17.29.54

BR0804I BRCONNECT terminated with errors

In installtion log shows

WARNING 2010-05-31 17:29:54

Execution of the command "D:\usr\sap\TVS\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPTVS" finished with return code 3. Output: BR0801I BRCONNECT 7.00 (48)BR0280I BRCONNECT time stamp: 2010-05-31 17.29.54BR0301E SQL error -1017 at location db_connect-2, SQL statement:'CONNECT /'ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance TVS failed

ERROR 2010-05-31 17:29:54

CJS-00288 Could not update database statistics.<br>DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPTVS returned 3.<br>SOLUTION: See brconnect.log for details.

I have tried with notes 50088 and 400241 but the error remains same.

I have set environment variables correctly

Please help me in solving this issue.......

Regards,

Santhosh

[Former Member]

Can you check the following

If you are able to connect sqlplus using user/passwd@sid . I assume the listener control is running right?

Check TNS_ADMIN environment variable and check if the sqlnet.ora exists under the path given by $TNS_ADMIN.

Regards

Kausik

[Former Member]

Hi

i tried as you mentioned but it shows "no longer connected to oracle"

TNS ENV is already set to sepcified path..

Regards,

Santhosh

[former_member204746]

try this:

sqlplus "/ as sysdba"

insert into "OPS$SAP\TVSADM".SAPUSER values ('SAPSR3','Your_PasSwOrd');

exit;

[Former Member]

Hi

It is telling that table does not exist but if i check OPS user from database it is available....

All table exists and owner also availbale.

SQL> insert into "OPS$SAP\TVSADM".SAPUSER values ('SAPTVS','****************');

insert into "OPS$SAP\TVSADM".SAPUSER values ('SAPTVS','*************')

*

ERROR at line 1:

ORA-00942: table or view does not exist

[Former Member]

Hi,

You need to create table SAPUSER for OP$<SID>ADM user.

I would recommend go through the below note.

Refer the section "How to create user <SAPSID>ADM"

[Note 50088 - Creating OPS$ users on Windows NT/Oracle|http://service.sap.com/sap/support/notes/50088]

Regards.

Rajesh Narkhede

[Former Member]

Hi rajesh

OPS user is already created in the system.

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

-

---

OPS$TVSADM

Is any other has to be created ? plese let me know

Regards,

Santhosh

[Former Member]

Hi,

Thats fine...

What is the output of below command ?

SQL> DESC OPS$TVSADM.SAPUSER;

If you get message like "Table or View does not exist" mean, table is not created.

So create the table with below command.

SQL>CREATE TABLE OPS$TVSADM.SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2 (256));

If the table is already created, then Check if

SQL>SELECT USERID,PASSWD FROM OPS$TVSADM.SAPUSER;

Output should be similar to below:

USERID
-
PASSWD
-
SAPTVS-CRYPT
V01/0050RsfdDRa42Cv2caE7A1ZBPNPasFctS0GTKiCVKKA==

If you don't see any entry, add the entry for schema user for example "SAPTVS"

SQL> INSERT INTO "OPS$TVSADM".SAPUSER values ('SAPTVS','<NEW_PASSWORD>');
SQL> COMMIT;

Once done. Change the password of SAPTVS

SQL> ALTER USER SAPTVS IDENTIFIED BY <NEW_PASSWORD>;

Check result of "R3trans -d" as <SID>adm user.

Then check if it solved your problem...

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh

Thanks,

Output of below commands....

SQL> DESC OPS$TVSADM.SAPUSER;

Name Null? Type

-

---

-

---

-

---

USERID VARCHAR2(255)

PASSWD VARCHAR2(255)

SQL> SELECT USERID,PASSWD FROM OPS$TVSADM.SAPUSER;

no rows selected

SQL> INSERT INTO "OPS$TVSADM".SAPUSER values ('SAPTVS','************');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> ALTER USER SAPTVS IDENTIFIED BY *******;

User altered.

Then i tried R3 trans -d it shows error as below

C:\Documents and Settings\tvsadm>R3trans -d

This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'TVS'"

R3trans finished (0012).

please check and give solution

Regards,

Santhosh

[former_member204746]

try this command:

INSERT INTO "OPS$TVSADM".SAPUSER values ('SAPSR3','************');

good luck.

[Former Member]

Hi

Can you post "trans.log"

What is your schema user ?

SAPTVS or SAPSR3 ?

Regards.

Rajesh Narkhede

[Former Member]

Hi rajesh

My schema is SAPTVS

trans.log

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 04.06.2010 - 22:00:36

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Jun 04 22:00:38 2010 57540 0.057540

4 ETW000 [dev trc ,00000] db_con_init called 77 0.057617

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 64 0.057681

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 45 0.057726

4 ETW000 [dev trc ,00000] Fri Jun 04 22:00:39 2010 270576 0.328302

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 50 0.328352

4 ETW000 [dev trc ,00000] using "D:\usr\sap\TVS\SYS\exe\run\dboraslib.dll"

4 ETW000 44 0.328396

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 15 0.328411

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 27 0.328438

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)

4 ETW000 28909 0.357347

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 42 0.357389

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 36 0.357425

4 ETW000 [dev trc ,00000] New connection 0 created 24 0.357449

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 31 0.357480

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 23 0.357503

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 25 0.357528

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 28 0.357556

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\TVS\102 from environment

4 ETW000 13739 0.371295

4 ETW000 [dev trc ,00000] -->oci_initialize 15957 0.387252

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 124506 0.511758

4 ETW000 [dev trc ,00000] Got TNS_ADMIN=D:\usr\sap\TVS\SYS\profile\oracle from environment

4 ETW000 47 0.511805

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPTVS's password 18 0.511823

4 ETW000 [dev trc ,00000] Connecting as /@TVS on connection 0 ... 16 0.511839

4 ETW000 [dev trc ,00000] Allocating service context handle 56773 0.568612

4 ETW000 [dev trc ,00000] Allocating server context handle 67 0.568679

4 ETW000 [dev trc ,00000] Attaching to DB Server TVS (con_hdl=0,svchp=0225FC88,svrhp=022642BC)

4 ETW000 88 0.568767

4 ETW000 [dev trc ,00000] Assigning server context 022642BC to service context 0225FC88

4 ETW000 222261 0.791028

4 ETW000 [dev trc ,00000] Allocating user session handle 43 0.791071

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0225FC88,srvhp=022642BC,usrhp=022AFDB8)

4 ETW000 51 0.791122

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 53165 0.844287

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 30 0.844317

4 ETW000 [dev trc ,00000] Try to connect with default password 19 0.844336

4 ETW000 [dev trc ,00000] Connecting as SAPTVS/<pwd>@TVS on connection 0 ...

4 ETW000 26 0.844362

4 ETW000 [dev trc ,00000] Assigning username to user session 022AFDB8 15 0.844377

4 ETW000 [dev trc ,00000] Assigning password to user session 022AFDB8 22 0.844399

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0225FC88,srvhp=022642BC,usrhp=022AFDB8)

4 ETW000 29 0.844428

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 125850 0.970278

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 31 0.970309

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#1 @ 419]

4 ETW000 68302 1.038611

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#1 @ 419]

4 ETW000 45 1.038656

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TVS'"

Regards,

Santhosh

[Former Member]

Hi,

First of all, make sure that LISTENER is running...

1. lsnrctl status.

Then change the schema user password using brconnect.

brconnect -u / u2013f chpass u2013u SAPTVS

If above command doesn't work, the use below one. (system users password would be "Master Password" if you haven't changed it...)

brconnect -u system/<system_password> u2013f chpass u2013u SAPTVS

Also post the output of below command. (May be some OPS$ user is still missing...)

SQL> SELECT USERNAME,PASSWD FROM DBA_USERS;

Regards.

Rajesh Narkhede

[Former Member]

Hi ,

lsnrctl is already running..........

C:Documents and Settings vsadm>brconnect -u / -f chpass -u SAPTVS

BR0801I BRCONNECT 7.00 (48)

BR0154E Unexpected option value 'ûf' found at position 3

BR0154E Unexpected option value 'chpass' found at position 4

BR0154E Unexpected option value 'ûu' found at position 5

BR0154E Unexpected option value 'SAPTVS' found at position 6

BR0280I BRCONNECT time stamp: 2010-06-05 18.28.44

BR0804I BRCONNECT terminated with errors

C:Documents and Settings vsadm>brconnect -u system/******** -f chpass -u SAPT

VS

BR0801I BRCONNECT 7.00 (48)

BR0154E Unexpected option value 'ûf' found at position 3

BR0154E Unexpected option value 'chpass' found at position 4

BR0154E Unexpected option value 'ûu' found at position 5

BR0154E Unexpected option value 'SAPTVS' found at position 6

BR0280I BRCONNECT time stamp: 2010-06-05 20.11.14

BR0804I BRCONNECT terminated with errors

sql>SELECT USERNAME,PASSWORD FROM DBA_USERS;

USERNAME PASSWORD

-

-

---

-

-

---

OPS$TVSADM

OUTLN

OPS$SAPSERVICETVS

SYS

SYSTEM

SAPTVS

TSMSYS

DIP

DBSNMP

9 rows selected.

In the above command it shows some alpha numeric char's in the filed PASSWORD

R3trans-d is still giving return code 12

Regards,

Santhosh

Edited by: BSanthosh on Jun 5, 2010 4:45 PM

[Former Member]

Hi,

brconnect -u / -f chpass -u SAPTVS

My apologies... There is a syntax error in above command... use -o switch for SAPTVS user.

Please try with below command to change the password of SAPTVS.

brconnect -u system/<syst_pwd> -f chpass -o SAPTVS -p <new_sap_pwd>

OR

brconnect -u / -f chpass -o SAPTVS -p <new_sap_pwd>

Is password of OPS$TVSADM and OPS$SAPSERVICETVS is "EXTERNAL" ? It should be...

Regards.

Rajesh Narkhede

[Former Member]

Hi rajesh,

OPS$TVSADM and OPS$SAPSERVICETVS is shown as "EXTERNAL" others is of some numbers mixed with alphabets

I tried to change the password through 1st command it shows

C:\Documents and Settings\tvsadm>brconnect -u system/*********** -f chpass -o SAPT

VS -p ********

BR0801I BRCONNECT 7.00 (48)

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.28

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

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

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TVS failed

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.28

BR0804I BRCONNECT terminated with errors

2nd command was successfull

C:\Documents and Settings\tvsadm>brconnect -u / -f chpass -o SAPTVS -p ***********

BR0801I BRCONNECT 7.00 (48)

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.46

BR0828I Changing password for database user SAPTVS

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.46

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.52

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.52

BR0829I Password changed successfully in database for user SAPTVS

BR0830I Password changed successfully in table OPS$TVSADM.SAPUSER for user SAPTV

S

BR0280I BRCONNECT time stamp: 2010-06-06 16.19.52

BR0802I BRCONNECT completed successfully

The same error repeats..............

Regards,

Santhosh

[Former Member]

Hi,

Please execute "R3trans -d" and post "trans.log"

(every time trans.log may have different error messages... So post it every time...)

Also answer the below questions :

1. Is SAPService<SID> member of DBA group ?

2. Is this domain installation ?

3. Is CI and DB on the same host ?

Regards.

Rajesh Narkhede

[Former Member]

Hi,

1. SAPServiceTVS is a member in DBA group

2. Local installation

3. Same host

R3trans -d

C:\Documents and Settings\tvsadm>R3trans -d

This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'TVS'"

R3trans finished (0012).

trans.log

4 ETW000 R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 08.06.2010 - 08:50:51

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Jun 08 08:50:53 2010 11491 0.011491

4 ETW000 [dev trc ,00000] db_con_init called 46 0.011537

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 53 0.011590

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 46 0.011636

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 47379 0.059015

4 ETW000 [dev trc ,00000] using "D:\usr\sap\TVS\SYS\exe\run\dboraslib.dll"

4 ETW000 69 0.059084

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 29 0.059113

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 26 0.059139

4 ETW000 [dev trc ,00000] Tue Jun 08 08:50:54 2010 1706 0.060845

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.39)

4 ETW000 48 0.060893

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 48 0.060941

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 34 0.060975

4 ETW000 [dev trc ,00000] New connection 0 created 23 0.060998

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 30 0.061028

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 22 0.061050

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 25 0.061075

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 27 0.061102

4 ETW000 [dev trc ,00000] Got ORACLE_HOME=D:\oracle\TVS\102 from environment

4 ETW000 940 0.062042

4 ETW000 [dev trc ,00000] -->oci_initialize 252 0.062294

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 30217 0.092511

4 ETW000 [dev trc ,00000] Got TNS_ADMIN=D:\usr\sap\TVS\SYS\profile\oracle from environment

4 ETW000 48 0.092559

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPTVS's password 18 0.092577

4 ETW000 [dev trc ,00000] Connecting as /@TVS on connection 0 ... 16 0.092593

4 ETW000 [dev trc ,00000] Allocating service context handle 1172 0.093765

4 ETW000 [dev trc ,00000] Allocating server context handle 40 0.093805

4 ETW000 [dev trc ,00000] Attaching to DB Server TVS (con_hdl=0,svchp=0225FC88,svrhp=022642BC)

4 ETW000 105 0.093910

4 ETW000 [dev trc ,00000] Assigning server context 022642BC to service context 0225FC88

4 ETW000 60829 0.154739

4 ETW000 [dev trc ,00000] Allocating user session handle 46 0.154785

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0225FC88,srvhp=022642BC,usrhp=022AFDB8)

4 ETW000 52 0.154837

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 32095 0.186932

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 30 0.186962

4 ETW000 [dev trc ,00000] Try to connect with default password 20 0.186982

4 ETW000 [dev trc ,00000] Connecting as SAPTVS/<pwd>@TVS on connection 0 ...

4 ETW000 25 0.187007

4 ETW000 [dev trc ,00000] Assigning username to user session 022AFDB8 16 0.187023

4 ETW000 [dev trc ,00000] Assigning password to user session 022AFDB8 22 0.187045

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0225FC88,srvhp=022642BC,usrhp=022AFDB8)

4 ETW000 28 0.187073

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 28000

4 ETW000 25325 0.212398

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=022642BC) 28 0.212426

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0225FC88,srvhp=022642BC)

4 ETW000 27 0.212453

4 ETW000 [dev trc ,00000] Deallocating server context handle 022642BC 406 0.212859

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28000'

4 ETW000 62 0.212921

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 28000 performing CON [dblink#1 @ 419]

4 ETW000 15145 0.228066

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-28000: the account is locked [dblink#1 @ 419]

4 ETW000 45 0.228111

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TVS'"

Regards,

Santhosh B

Edited by: BSanthosh on Jun 8, 2010 6:24 AM

[Former Member]

Hi Santhosh,

***LOG BY0=>ORA-28000: the account is locked [dblink#1 @ 419] 4 ETW000 45 0.228111 2EETW169 no connect possible: 

First you check if SAPTVS user is locked...

SQL>SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;

If you find SATVS is locked, then unlock it..

SQL>ALTER USER SAPTVS ACCOUNT UNLOCK;

Second, there is still problem in OPS$ user or table...

I would recommend again go through the below note carefully. If needed drop OPS$ user and recreate it as per the note.

Section : ORA-01017: invalid username/password; logon denied

[SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle|http://service.sap.com/sap/support/notes/400241]

Below note also have sql script attached to create dbusers...

[SAP Note 50088 - Creating OPS$ users on Windows NT/Oracle|http://service.sap.com/sap/support/notes/50088]

Just download the script (oradbusr10.ZIP) and execute as per the instructions given in above note...

Hope, this will solve your problem..

Regards.

Rajesh Narkhede

[Former Member]

Hi rajesh

i did everything.......

error keeps on repeating so i started fresh DB installtion from first and as a same result i got struck in same step....

i could not solve the problem.....

really fedbup......

Regards,

Santhosh

[former_member362699]

Hello,

Please check the following firstly:

1, logon as <sid>adm
2, sqlplus /nolog
3, connect /

It should be connected if the OPS$ user has been configed correctly otherwise please follow note:400241 to correct it.

Thanks and regards,

Wen Ye

[Former Member]

Hi,

First check if your LISTENER and DATABASE related services are started and in automatic startup mode...

Then do "R3trans -d" and paste the "trans.log" from current directory...

Regards.

Rajesh Narkhede

[Former Member]

Hi ,

I tried r3trans -d it shows no error it finish with code 00000

but when i tried with database to connect manually by connect SAPTVS /<password>/@TVS it shows connected

Database is in startup and listner shows running.....

I have updated new DBA tool and retried but now it shows

brconnect.log

BR0801I BRCONNECT 7.00 (48)

BR0280I BRCONNECT time stamp: 2010-06-02 16.10.06

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

'CONNECT /'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance TVS failed

BR0280I BRCONNECT time stamp: 2010-06-02 16.10.06

BR0804I BRCONNECT terminated with errors

sapgui log

WARNING 2010-06-02 16:10:07

Execution of the command "D:\usr\sap\TVS\SYS\exe\run/brconnect -u / -c -f crsyn -o SAPTVS" finished with return code 3. Output: BR0801I BRCONNECT 7.00 (48)BR0280I BRCONNECT time stamp: 2010-06-02 16.10.06BR0301E SQL error -1017 at location db_connect-2, SQL statement:'CONNECT /'ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance TVS failed

ERROR 2010-06-02 16:10:07

CJS-00288 Could not update database statistics.<br>DIAGNOSIS: Command brconnect -u / -c -f crsyn -o SAPTVS returned 3.<br>SOLUTION: See brconnect.log for details.

Regards,

Santhosh

[former_member204746]

make sure that Windows OS user tvsadm and sapserviceTVS has Oracle group privileges.

[Former Member]

Hi,

Privilage is set fine and already added to oracle groups.

but the error repeats the same.....

Regards,

Santhosh

[former_member204746]

ok then. try this:

insert into "OPS$SAP\TVSADM".SAPUSER values ('SAPSR3','Your_PasSwOrd');

exit

[Former Member]

Error:ORA-01017: invalid username/password; logon denied.

'CONNECT /'ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance TVS failed

Reason: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.

Check the password of SAPSID(db schema owner).

Run R3trans -d to check if any connectivity problems exists between R/3 and Database. Once the command is issued you can see a file trans.log check that for any errors.

You can change password of SAPSID using BRTools...

Check out the below SAPnote it would be helpful for you....

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

Edited by: prateek_y on May 31, 2010 8:35 PM

[Former Member]

Hi

I tried even changing the password through brtools the same error repeates

i have read the note and tried as per given but i can connect with my password

connect SAPTVS/*******@TVS it shows connected as i give my own password.........

OPS$ user is created already i check by executing the commands stated in note everthing is showing........

while executing R3trans -d it shows

D:\usr\sap\TVS\SYS\exe\nuc\NTI386>r3trans -d

This is r3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'TVS'"

r3trans finished (0012).

in trans .log it shows as

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

4 ETW000 20707 0.302582

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 20 0.302602

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#1 @ 419]

4 ETW000 1758 0.304360

4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#1 @ 419]

4 ETW000 29 0.304389

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TVS'"

Environmental variables are set correct.

Regards,

Santhosh

[Former Member]

Try this

SQL> select username, account_status from dba_users;

if password change is required, use BR*tools only.

brconnect -c -u / -f chpass -o SYSTEM -password WhaTeVeR

Hope you will be able to solve the issue,also refer to 951167. Brtools way to change the password....

Brtools>8 - Additional functions>4 - Change password of database user-->

3 ~ Database owner to change password (owner)>Here Put your Schema Owner ( SAPBSD or SAPR3 etc)> C ( Continue)>Enter new password>C

May be you need to upgrade you Brtools patch level....

Something same as what you are getting...below ... Hope this time you will be able to login ...