cancel
Showing results for 
Search instead for 
Did you mean: 

Dispatcher went down after upgrading the oracle verion from11.2.1 to 11.2.2

Former Member
0 Kudos

Dear experts

our system is windows2008 server ECC6.0 EhP5with oracle 11g,we have upgraded the oracle version from 11.2.0.1 to 11.2.0.2 it has been completed successfully and I have restored the last offline backup of ECC system successfully after that we are trying to start sap server it went down,R3trans is showing error 12

please find the error log details

After doing a system copy. We are facing this issue. R3trans -d gives the below error:

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

ETW000  \[dev trc ,00000\]  charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 12  0.497779

4 ETW000  \[dev trc ,00000\]  Logon as OPS$-user to get SAPSR3's password 742  0.498521

4 ETW000  \[dev trc ,00000\]  Connecting as /@DEC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE\[2\])

4 ETW000 53 0.498574

4 ETW000  \[dev trc ,00000\]     OCIHandleAlloc(OCI_HTYPE_SVCCTX, con=0, svchp=0BC3FA68) 38935  0.537509

4 ETW000  \[dev trc ,00000\]  Allocating server context handle 36  0.537545

4 ETW000  \[dev trc ,00000\]  Attaching to database server DEC (con=0, svchp=0BC3FA68, srvhp=0BC442F0)

4 ETW000 50  0.537595

4 ETW000  \[dev trc ,00000\]  Assigning server context 0BC442F0 to service context 0BC3FA68         138442  0.676037

4 ETW000  \[dev trc ,00000\]     OCIHandleAlloc(OCI_HTYPE_SESSION, con=0, usrhp=0BD5EED0) 48  0.676085

4 ETW000  \[dev trc     ,00000\] Starting user session: OCISessionBegin(con=0, usr='/', svc=0BC3FA68, srv=0BC442F0, usr=0BD5EED0)

4 ETW000 24  0.676109

4 ETW000  \[dev trc ,00000\]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 3359  0.679468

4 ETW000  \[dev trc ,00000\]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 77  0.679545

4 ETW000  \[dev trc ,00000\]     ORA-01017: invalid username/password; logon denied

4 ETW000 24  0.679569

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

4 ETW000  \[dev trc ,00000\]     set_ocica() -> SQL error code 1017 18  0.704234

4 ETW000  \[dev trc ,00000\]  -->oci_get_errmsg (con=0, rc=1017) 14  0.704248

4 ETW000  \[dev trc ,00000\]     OCIErrorGet -> SQL error code: 1017 59  0.704307

4 ETW000  \[dev trc ,00000\]     ORA-01017: invalid username/password; logon denied

4 ETW000 21  0.704328

4 ETW000  \[dev trc ,00000\]  Info: 99=DBSL_ERR_DB, oerr=1017, try to connect with default password.

4 ETW000 59  0.704387

4 ETW000  \[dev trc ,00000\]  Connecting as SAPSR3/

<pwd>@DEC on connection 0 (nls 0) ... (dbsl 720 220612, UNICODE\[2\])

4 ETW000 20  0.704407

4 ETW000  \[dev trc ,00000\]  Assigning username to user session: con=0, usrhp= 0BD5EED0 13  0.704420

4 ETW000  \[dev trc ,00000\]  Assigning password to user session: con=0, usrhp=0BD5EED0 21  0.704441

4 ETW000  \[dev trc ,00000\]  Thu Jul 19 13:49:51 2012 57857  0.762298

4 ETW000  \[dev trc ,00000\]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=0BC3FA68, srv=0BC442F0, usr=0BD5EED0)

4 ETW000 23 0.762321

4 ETW000  \[dev trc ,00000\]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 2955  0.765276

4 ETW000  \[dev trc ,00000\]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 73  0.765349

4 ETW000  \[dev trc ,00000\]     ORA-01017: invalid username/password; logon denied

4 ETW000 23 0.765372

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

4 ETW000  \[dev trc ,00000\]     set_ocica() -> SQL error code 1017 11  0.765399

4 ETW000  \[dev trc ,00000\]  -->oci_get_errmsg (con=0, rc=1017) 11  0.765410

4 ETW000  \[dev trc ,00000\]     OCIErrorGet -> SQL error code: 1017 54  0.765464

4 ETW000  \[dev trc ,00000\]     ORA-01017: invalid username/password; logon denied

4 ETW000 22 0.765486

4 ETW000  \[dev trc ,00000\]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 12  0.765498

4 ETW000  \[dblink ,00000\]  ***LOG BY2=>sql error 1017   performing CON 32  0.765530

4 ETW000  \[dblink ,00000\]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied 15  0.765545

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

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

When we check connect /@<SID>  throws and error :

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

Where as the following combinations get connected:

connect OPS$DT-SAP-CRM\SAPSERVICE<SID> /Password

OPS$DT-SAP-CRM\<SID>ADM /Password

SAPSR3/Password

The above 3 pairs are working well, only connect /@<SID> is giving 1027 error.

I have followed all the steps in Note 400241

As per the note we have added:

REMOTE_OS_AUTHENT = TRUE

os_authent_prefix = ops$

We also deleted and recreated the OPS$ users. Still we are facing the same issue. The connect /@<SID> is failing and R3trans is also failing with this error.

We are on Windows 2008 server with oracle DB

Kindly suggest how this can be addressed.

regards

krishna

Accepted Solutions (1)

Accepted Solutions (1)

paul_power
Active Contributor
0 Kudos

Hello Krishna,

Have you tried to perform following as described in note 361641?

To change the password for the SAPR3 or SAP<SID> user you have to use
the following command:

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

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

then test R3trans

regards,

Paul

Answers (3)

Answers (3)

former_member189725
Active Contributor
0 Kudos

Please check if the OS users SAPSERVICE<SID> and <SID>ADM are assigned to groups dba and oper.

Regards

Ratnajit

Former Member
0 Kudos

hi,

just check the few thiings.

1. what is your listener name? during the upgrade process listener enter the local listener name as LISTENER_SID. that might not be the same as your old listener.

2 if the same then check listener is Up.

3. TNSPING  SID. that system is resloving the hostname.

4. check database is open with sysdba user .

if all above then

try to DB  with OPS user, might be the you need to grant the role to OPS user.

u need to run the role.sql script.

regards,

Meenakshi

Former Member
0 Kudos

Hi ,

Have you check whether listner is up ???

Secondly, use tnsping <SID> command the paste the output.

Regards