Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-942 when accessing table SAPUSER Error on WP

Hi gurus, this is my landscape: I have an SAP PRD Server with Windows 2008 and Oracle 11i, 606 (came upgrade from 4.7) and works fine. We have an SAP Stand-by Server with a stand-by database, this is ok. Database replicate changes fine with Oracle Data Guard, when we run switchover on Stnad-by Server, everything is ok, database open fine.

My problem is when I try to start up SAP, SAP does not start up, and problem is with workprocess. I add OPS$ from stand-by in dba_users and fine, when I run r3trans -d, it finish with no error. I upgrade kernel, I check tsnames.ora, database password, etc, and they are fine.

I can connect to database with OPS$SAPServiceSID and OPS$SIDadm fine. When I check log (work) I can see following error in WP:

File: dev_w1

.

.

Wed Jul 02 10:16:47 2014

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\PSQ\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'D:\usr\sap\PSQ\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'D:\usr\sap\PSQ\DVEBMGS00\exe\dboraslib.dll' is "720.00", patchlevel (0.522)

C  Prepending D:\usr\sap\PSQ\DVEBMGS00\exe to Path.

C  Register application info.

C Wed Jul 02 10:16:49 2014

C  Oracle client version: 11.2.0.3.0, (dbsl 720 030114, non-unicode)

C  Detailed Oracle client (patch) info not available.

C Wed Jul 02 10:16:52 2014

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.WE8DEC'

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

C  Connecting as /@SR3 on connection 0 (nls 0) ... (dbsl 720 030114, non-unicode)

C  Attaching to database server SR3 (con=0, svchp=0286E7F0, srvhp=0639BCE0)

C Wed Jul 02 10:16:53 2014

C  Starting user session: OCISessionBegin(con=0, usr='/', svc=0286E7F0, srv=0639BCE0, usr=063AACA0)

C     OCIStmtExecute() failed with -1=OCI_ERROR

C     SQL error 942:

C  Could not read session ID from V$MYSTAT. rc=-1.

C  Now '/@SR3' is connected: con=0, nls=0, session=-1, time='2014-07-02 10:16:53'

C     OCIStmtExecute() failed with -1=OCI_ERROR

C     SQL error 942:

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

[dbsloci.c    16660]

C  Disconnecting from connection 0 ...

C  Closing user session (con=0, svc=0286E7F0, usr=063AACA0)

C  Disconnected (con=0) from ORACLE.

C  Info: 99=DBSL_ERR_DB, oerr=942, try to connect with default password.

C  Connecting as SAPSR3/<pwd>@SR3 on connection 0 (nls 0) ... (dbsl 720 030114, non-unicode)

C  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=0286E7F0, srv=0639BCE0, usr=063AACA0)

C Wed Jul 02 10:18:27 2014

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

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

C  Server handle (con=0,svchp=0286E7F0,srvhp=0639BCE0) detached

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

[dbsloci.c    15709]

B  ***LOG BY2=> sql error 1017   performing CON [dbsh         1246]

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

B  ***LOG BY2=> sql error 1017   performing CON [dblink       544]

B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink       544]

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

M  in_ThErrHandle: 1

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

M  ......

I add some files with commands output.

Some suggestion? ...

Best regards.

sqlplus outp1.jpg (53243 B)
tnsping output.jpg (55739 B)
Tags:
Former Member
replied

Hello

First check whether the SAPUSER table is present or not.

Follow this SAP note 400241 - Problems with ops$ or sapr3 connect to Oracle

Regards

RB

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question