cancel
Showing results for 
Search instead for 
Did you mean: 

error ORA: 01017

former_member409456
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Reagan
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

Hi Tarun,

Please follow the sequence and try.

su - ora<SID>

export ORACLE_SID=<SID>

sqlplus / as sysdba

Please check and reply.

Regards,

MS

former_member409456
Participant
0 Kudos

HI,

We have Windows server 2003 with Oracle 11g. We have sidadm user.

Also i can see in environment variable ORACLE_SID=SOL is set.

Former Member
0 Kudos

Ok

from windows command prompt just you

try set ORACLE_SID=SOL

then

sqlplus / as sysdba

and check it.

Regards,

Manas

former_member409456
Participant
0 Kudos

HI Manas,

Already tried but not working.

former_member188883
Active Contributor
0 Kudos

Hi Tarun,

Have you performed system copy on the affected system recently.

In such a case please change the dbs_ora_schema = < value defined in source system >.

Post this check the results.

Hope this helps.

Regards,

Deepak Kori

former_member409456
Participant
0 Kudos

HI Deepak,

We have not performed system copy.

Last week we have changed Host Name and IP address of our  source system.

After This we are facing this problem.

former_member188883
Active Contributor
0 Kudos

Hi Tarun,

Have you update the new hostname in TNSNAMES.ORA, LISTENER.ORA as well as all the SAP profile files, Environment files ?

If not please do so and check the results.

Regards,

Deepak Kori

former_member409456
Participant
0 Kudos

HI Deepak,

I have maintained host name every where like tnsnames.ora, listner, start profile, instance profile, default profile. But still getting error code 12 while R3trans -x.

former_member188883
Active Contributor
0 Kudos

Hi Tarun,

Are you able to start and stop oracle database manually ?

Regards,

Deepak Kori

former_member409456
Participant
0 Kudos

HI Deepak,

I am able to start and stop the database.

Right now it is in OPEN mode.

Problem is whenever i am trying start SAP dispatcher is going down.

Also trying SQL> conn / it is giving error ORA-01017

Former Member
0 Kudos

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

former_member409456
Participant
0 Kudos

Hi Kiran,

i am able to connect with SYSTEM user and SAPSR3 user.

SAPSR3 user password i have given in lower case and you are suggesting in upper case. Is there any difference?

Regards,

Tarun

former_member206552
Active Contributor
0 Kudos

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

former_member409456
Participant
0 Kudos

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'"

Reagan
Advisor
Advisor
0 Kudos

Hello

Have you tried changing the password for the SAPSR3 schema user using BRTools ?

brconnect -u / -f chpass -o SAPSR3 -p SAPuserPa21

Regards

RB

former_member409456
Participant
0 Kudos

HI,

I tried "brconnect -u / -f chpass -o SAPSR3 -p SAPuserPa21" and message that password updated for OPS$  user successful but when i am trying SQL>conn / still saying ORA-01017 error