Problem with DB-Connect

[christian_laber2]

Hello guys,

I'm within a SAP installtion I get a failure caused of this problem

M Wed Sep 10 15:10:54 2008

M calling db_connect ...

C Prepending C:\oracle\Q11\102 to Path.

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@Q11 on connection 0 (nls_hdl 0) ... (dbsl 640 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0000000013975110 000000001397D340 000000001399B6B8

C Attaching to DB Server Q11 (con_hdl=0,svchp=000000001399B578,svrhp=000000001399BE58)

C Starting user session (con_hdl=0,svchp=000000001399B578,srvhp=000000001399BE58,usrhp=000000001397DB58)

C Now '/@Q11' is connected (con_hdl 0, nls_hdl 0).

C *** ERROR => ORA-1403 when accessing table SAPUSER

[dbsloci.c 10922]

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=000000001399B578,usrhp=000000001397DB58)

C Now I'm disconnected from ORACLE

C Try to connect with default password

C Connecting as SAPR3/<pwd>@Q11 on connection 0 (nls_hdl 0) ... (dbsl 640 310805)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0000000013975110 000000001397D340 000000001399B6B8

C Starting user session (con_hdl=0,svchp=000000001399B578,srvhp=000000001399BE58,usrhp=000000001397DB58)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4385]

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

[dbsloci.c 10555]

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

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

B ***LOG BY2=> sql error 1017 performing CON [dblink#2 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#2 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

After an Oracle 10.2.0.1 installation I installed a 10.2.0.3 Patch before starting the SAP installer. I don't know if this information is importend or not!

Thanks

Christian

I

[Former Member]

Hi,

SAP supports 10.2.0.2 and 10.2.0.4 only.

[fidel_vales]

Hello,

>

> Hi,
> 
> SAP supports 10.2.0.2 and 10.2.0.4 only.

Good point, I miss this.

SAP does not support 10.2.0.3

Nevertheless, the current issue is not caused by the patch set level, but bad configuration of the ops$ user.

[fidel_vales]

Hi,

It looks like you have not configured the OPS$ connection and you changed the password.

SAP note 400241 (Problems with ops$ or sapr3 connect to Oracle) has a detailed explanation.

Create the ops$ user following one of this notes:

361641 - Creating OPS$ users on UNIX

50088 - Creating OPS$ users on Windows NT/Oracle