on 07-19-2012 12:35 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please check if the OS users SAPSERVICE<SID> and <SID>ADM are assigned to groups dba and oper.
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Have you check whether listner is up ???
Secondly, use tnsping <SID> command the paste the output.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.