cancel
Showing results for 
Search instead for 
Did you mean: 

sql error 1017

Former Member
0 Kudos

Hi;

Our set up is:

CI and DB: AIX & ECC 6.0& Oracle

We are having one 32 bit win application server. Yesterday we have added another 64 bit win applciation server but at the time of starting the same it is giving the following error:

Fri Oct 30 12:46:58 2009

C Oracle Client Version: '10.2.0.4.0'

C application info callback registered

C Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.WE8DEC'

C Logon as OPS$-user to get SAPR3E's password

C Connecting as /@R3E on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 000000000991D050 0000000009925280 00000000099303C8

C Attaching to DB Server R3E (con_hdl=0,svchp=0000000009930288,srvhp=0000000009932698)

C

C Fri Oct 30 12:47:01 2009

C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000009930288, srvhp=0000000009932698, usrhp=0000000013931670)

C

C Fri Oct 30 12:47:02 2009

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C ORA-01017: invalid username/password; logon denied

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11239]

C Try to connect with default password

C Connecting as SAPR3E/<pwd>@R3E on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 000000000991D050 0000000009925280 00000000099303C8

C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3E/<pwd>, svchp=0000000009930288, srvhp=0000000009932698, usrhp=0000000013931670)

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

C ORA-01017: invalid username/password; logon denied

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11239]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#8 @ 433] [dblink 0433 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#8 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1502]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10621]

M

M Info for wp 0

M

I have check all windown environment variables and SAPR3E user status. All things are OK. Pl guide.

The following environment variables are set:

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=ORA

DBS_ORA_SCHEMA=SAPR3E

dbs_ora_tnsname=R3E

DIR_LIBRARY=
mmr3dev\sapmnt\R3E\SYS\exe\nuc\NTAMD64

JAVA_HOME=C:\j2sdk1.4.2_16-x64

NLS_LANG=AMERICAN_AMERICA.WE8DEC

ORACLE_SID=R3E

OS=Windows_NT

PROMPT=$P$G

SAPEXE=
mmr3dev\sapmnt\R3E\SYS\exe\nuc\NTAMD64

SAPLOCALHOST=mmkndr3prdas1

SAPSYSTEMNAME=R3E

Kindly suggest.

Regards,

Rahul.

Accepted Solutions (1)

Accepted Solutions (1)

former_member759680
Contributor
0 Kudos
ORA-01017: invalid username/password; logon denie

Check Note - 717677 first.

If ops$ user exists do this:

check the schema user that is locked, you can use the following commands:

sqlplus "/as sysdba"

select username,account_status from dba_users;

in case user is locked then unlock it using the command:

alter user <user_name> account unlock;

P.S. you can excute R3trans -d to get a more exact error.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi;

The said problem has been resolved after changing the SAP service owner to sidadm.

Thanks for your suuport.

Regards,

Rahul.

Former Member
0 Kudos

Thanks Rahul, was facing a similar problem with my DR system. The solution provided worked.

Former Member
0 Kudos

Hi;

The user is not locked and r3trans -d giving RC=0.

Regards,

Rahul.

former_member759680
Contributor
0 Kudos

Check Note - 717677

former_member185031
Active Contributor
0 Kudos

>>DBS_ORA_SCHEMA=SAPR3E

This is my system's variable

dbs_ora_schema=SAPSR3

Regards,

Subhash