SQL 1017 after upgrade to Oracle 11

[Former Member]

Hello Team,

We have just upgraded our server to Oracle 11.2.0.3 from 10.2.0.4

DB has started well without issues but we are getting ORA-01017 in R3trans

======================================================================

4 ETW000 Allocating service context handle for con=0 14 0.005235

4 ETW000 Allocating server context handle 8 0.005243

4 ETW000 Attaching to DB Server DD1 (con=0,svchp=110a68038,srvhp=110a6da38) 31 0.005274

4 ETW000 Assigning server context 110a6da38 to service context 110a68038 78330 0.083604

4 ETW000 Allocating user session handle 24 0.083628

4 ETW000 Starting user session: OCISessionBegin(con=0, usr='/',svchp=110a68038, srvhp=110a6da38, usrhp=110a67440)

4 ETW000 20 0.083648

4 ETW000 OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 5330 0.088978

4 ETW000 OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 30 0.089008

4 ETW000 ORA-01017: invalid username/password; logon denied

4 ETW000 13 0.089021

4 ETW000 *** ERROR => CONNECT failed with sql error '1017' 10 0.089031

4 ETW000 set_ocica() -> SQL error code 1017 6 0.089037

4 ETW000 -->oci_get_errmsg (con=0, rc=1017) 13 0.089050

4 ETW000 OCIErrorGet -> SQL error code: 1017 7 0.089057

4 ETW000 ORA-01017: invalid username/password; logon denied

4 ETW000 11 0.089068

4 ETW000 Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

4 ETW000 11 0.089079

4 ETW000 Connecting as SAPSR3/@DD1 on connection 0 (nls 0) ... (dbsl 700 131011, non-unicode)

4 ETW000 11 0.089090

4 ETW000 Assigning username to user session: con=0, usrhp=110a67440 7 0.089097

4 ETW000 Assigning password to user session: con=0, usrhp=110a67440 23 0.089120

4 ETW000 Starting user session: OCISessionBegin(con=0, usr=SAPSR3/, svchp=110a68038, srvhp=110a6da38, usrhp=110a67440)

4 ETW000 12 0.089132

4 ETW000 OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 9214 0.098346

4 ETW000 OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 20 0.098366

4 ETW000 ORA-01017: invalid username/password; logon denied

4 ETW000 12 0.098378

4 ETW000 *** ERROR => CONNECT failed with sql error '1017' 11 0.098389

4 ETW000 set_ocica() -> SQL error code 1017 6 0.098395

4 ETW000 -->oci_get_errmsg (con=0, rc=1017) 7 0.098402

4 ETW000 OCIErrorGet -> SQL error code: 1017 7 0.098409

4 ETW000 ORA-01017: invalid username/password; logon denied

4 ETW000 11 0.098420

4 ETW000 ***LOG BY2=>sql error 1017 performing CON 33 0.098453

4 ETW000 ***LOG BY0=>ORA-01017: invalid username/password; logon denied

4 ETW000 12 0.098465

======================================================================================

Steps Performed

1> Changed the password of users SAPSR3 to SAP, through

1> alter user sapsr3 identified by sap;

INSERT INTO "OPS$DD1ADM".SAPUSER VALUES ('SAPSR3','SAP');

2> brconnect -u system/manager -f chpass -o sapsr3 -p sap

2> Checked Note 361641 - Creating OPS$ users on UNIX

sqlplus /NOLOG @oradbusr. sql SCHEMAOWNER UNIX SAP_SID x

3> Checked Note  1519872 - SAP Database User Profile SAPUPROF

sqlplus / as sysdba @sapuprof_profile

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

sqlplus /nolog @sapdba_role SR3

Has anyone faced a similar error... Kindly suggest

Thanks,

Vijay

[Former Member]

Hi Vijay,

Set this parameter.

sec_case_sensitive_logon=FALSE

This should solve your problem.

Br,

Venky

[Former Member]

Hi,

Through BRTOOLS reset the password for Schema SAPSR3 using option 8 (additional options).

you should be able to connect now.

Go through this SAP Note if you still face the issue.

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

Regards,

Venkata S Pagolu.

[former_member184473]

Hello Vijay,

Which is the database owner?

select owner from dba_tables where table_name='T000';

Regards,

Eduardo Rezende

[Former Member]

It is SAPSR3

Thanks,

Vijay

[Former Member]

Hi,

What's the ytem response to this ?

SQL> show sqlcase

Mark

[Former Member]

alter user sapsr3 identified by sap;
INSERT INTO "OPS$DD1ADM".SAPUSER VALUES ('SAPSR3','SAP')

You set the password to sap and to SAP in SAPUSER? Passwords are case sensitive now. Always use brtools to change the password.

Cheers Michael