on 11-13-2013 10:36 AM
HI,
Please help me to resolve ORA-01017: invalid username/password; logon denied. Due to this our SAP is not getting up.
When i am trying sql> conn / getting below error:
ERROR:
ORA-01017: invalid username/password; logon denied
Following checks i have done:
1. SYSTEM, SAPSR3, SAPSR3DB not locked.
2. Able to connect with SAPSR3, SAPSR3DB, and SYSTEM user.
3. OPS$user exist in system: SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';
getting OPS$DOMAIN\SOLADM output
4. SYNONYMS also exist properly:
OPS$DOMAIN\SAPSERVICESOL OPS$DOMAIN\SOLADM SAPUSER
5. Following parameter also set :
os_authent_prefix = ops$
SQLNET.AUTHENTICATION_SERVICES = (NTS)
5. OPS$ password also maintained in SAPUSER:
USERID
----------------------------
PASSWD
----------------------------
SAPSR3-CRYPT
V01/0010ZctvSB67Wv3u6Yw=
Still i am not able to understand why i am not able to connect. Also my database is in open mode.
Checked every thing from note: 400241 - Problems with ops$ or sapr3 connect to Oracle but no help.
Please suggest.
I believe the problem you have is with the OPS$ users.
If I were you I would drop all the OPS$ users and recreate them with the help of the ORADBUSR.SQL script attached to this SAP note.
50088 - Creating OPS$ users on Windows NT/Oracle
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
Please follow the sequence and try.
su - ora<SID>
export ORACLE_SID=<SID>
sqlplus / as sysdba
Please check and reply.
Regards,
MS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Refer to sap note 400241
Refer to following thread . most of the points are discussed ...
http://scn.sap.com/thread/3209017
Also suggest to
SQL> conn SAPSR3/SAP
SQL> conn system/manager
Step 1 - Reset password for system
brconnect -u system/manager -f chpass -o system -p manager
Step 2 - Reset password for SAPSR3
brconnect -u system/manager -f chpass -o SAPSR3 -p SAP
Hopefully above 2 steps should resolve the issue... and if you are working Oracle 11 do not use @ symbol if you are going with your own password..
Message was edited by: Kiran Challapalli
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
did you do a kernel upgrade to 7.20 ?
did you maybe activate SSFS ?
1622837 - Secure connection of AS ABAP to Oracle via SSFS
Best Regards
Marius
Also below error getting in R3trans -X :
*** ERROR => CONNECT failed with sql error '1017' 32 0.100417
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 25 0.100442
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 20 0.100462
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 19 0.100481
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 29 0.100510
4 ETW000 [dev trc ,00000] Try to connect with default password 18 0.100528
4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@SOL on connection 0 (nls_hdl 0) ... (dbsl 701 220409)
4 ETW000 29 0.100557
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
4 ETW000 30 0.100587
4 ETW000 [dev trc ,00000] 0 WE8DEC 0000000003BF7280 0000000003BFF4B0 0000000003C00C78
4 ETW000 31 0.100618
4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0000000003BFFCC8
4 ETW000 37 0.100655
4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0000000003BFFCC8
4 ETW000 40 0.100695
4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/<pwd>, svchp=0000000003C00B38, srvhp=0000000003C013B8, usrhp=0000000003BFFCC8)
4 ETW000 34 0.100729
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 4194 0.104923
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 50 0.104973
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 31 0.105004
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 23 0.105027
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 1017 19 0.105046
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=1017) 19 0.105065
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 1017 19 0.105084
4 ETW000 [dev trc ,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 28 0.105112
4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 1017 performing CON [dblink#4 @ 433] 54 0.105166
4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#4 @ 433]
4 ETW000 29 0.105195
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SOL'"
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.