Former Member

Feb 13, 2012 at 12:36 PM

SQL 1017 after upgrade to Oracle 11

187 Views

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