Schema owner for ECC 5.0 IDES

[Former Member]

Hi,

When I am trying to start ECC 5.0, the work processes are dying below is the error.

OS: Windows, DB: Oracle.

Now I'm connected to ORACLE
C  *** ERROR => ORA-1403 when accessing table SAPUSER
 [dbsloci.c    10114]
C  Disconnecting from connection 0 ...
C  Closing user session (con_hdl=0,svchp=0493EFF4,usrhp=07FC1E64)
C  Now I'm disconnected from ORACLE
C  Try to connect with default password
C  Connecting as SAPR3/<pwd>@CC5 on connection 0 ...
C  Starting user session (con_hdl=0,svchp=0493EFF4,srvhp=07FB9234,usrhp=07FC1E64)
C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
 [dboci.c      3721]
C  *** ERROR => CONNECT failed with sql error '1017'
 [dbsloci.c    9750]
B  ***LOG BY2=> sql error 1017   performing CON [dbsh#1 @ 1200] [dbsh    1200 ]
B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#1 @ 1200] [dbsh    1200 ]
B  ***LOG BY2=> sql error 1017   performing CON [dblink#1 @ 419] [dblink  0419 ]
B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink  0419 ]
M  ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c   1270]
M  in_ThErrHandle: 1
M  *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   9377]

Based on these errors I have looked at Notes: 400241, 50088.

The problem is, even though schema owner is listed as SAPSID, why is SAPR3 being used to connect to Oracle.

I have tried creating the users using note 50088, but to no avail.

I have tried creating the users with schema owner as SAPSID. Above is the error message that I get.

When trying to create the users with owner as SAPR3, I get the below error,

ERROR at line 1:
ORA-00959: tablespace 'PSAPUSER1D' does not exist
ORA-06512: at line 114

Regards,

Vishi

[Former Member]

Hi,

Whats the output of

select owner from dba_tables where table_name like '%SAPUSER';

Then use the query SELECT * FROM OPS$SIDADM.SAPUSER;

[Former Member]

Hi all,

Thanks for all your suggestions. I have tried everything that has been suggested here.

But the problem still persists.

Trans.log shows SAPSID, whereas dev_w0 shows SAPR3.

Logs are exactly the same as in my previous post.

Why am I getting this ERROR => ORA-1403 when accessing table SAPUSER,

this error says that the table SAPUSER does not contain any entries. that is not the case.

SQL> SELECT * FROM "OPS$DLWSDV11\CC5ADM".SAPUSER;

USERID

-

---

PASSWD

-

---

SAPCC5-CRYPT

V01/0040ZctvSB67Wv0mgPmxhGH0L9+3LcqSBoFQ

Any Ideas.

Regards,

Vishnu

[former_member189725]

Please login as user sapservicecc5 and change the environment dbs_ora_schema=SAPCC5.

Login as cc5adm , then open brtools .

Change the password of SAPCC5 user.

[Former Member]

Hi,

Really appreciate your suggestions, Thanks.

I am unable to login with sapservicecc5 into the server. I am able to with sidadm.

Let me see if I can look up the variable under registry.

When I search for the parameter dbs_ora_schema under windows registry, the values are all set to SAPCC5

Regards,

Vishnu

[Former Member]

Hi,

SAPR3 doesnt occur anywhere in the registry, where is the sapservicesid picking it up from.

why is it showing in dev_w0 logs, where else can I check?

Regards,

Vishnu

[former_member189725]

Please check in your profile parameter dbs/ora/schema if the schema is set to SAPR3.

Edited by: Ratnajit Dey on Nov 30, 2011 11:39 AM

[Former Member]

Hallo,

sqlplus /nolog @sapdba_role.sql CC5

I also suggest updating the password as per Volker's recommendation for user SAPCC5.

There are plenty of notes around what can go wrong and how to fix it, eg

1576837 - ORA-01017: invalid username/password;

Even if many of them relate to brbackup, the underlying connection attempts are the same.

Regards,

Thomas.

[former_member189725]

Please follow the SAP note 50088 and check your configuration.

In Windows with Oracle db , the work process have the owner sapservice<sid>. Check in the schema OPS$DLWSDV11\SAPSERVICECC5 if the sapuser table has the user id SAPCC5.

Also check the environment of SAPSERVICECC5 , if the variable dbs_ora_schema has the value SAPCC5.

You can check if the windows service SAP<SAPSID>_<Instance_ID> has the user SAPSERVICECC5.

Login as user SAPSERVICECC5 and execute R3trans -x.

[Former Member]

> The problem is, even though schema owner is listed as SAPSID, why is SAPR3 being used to connect to Oracle.

Where is it listed as 'SAPSID' ?

Check the value for environment variable 'dbs_ora_schema' - If it is SAPR3 then the oracle schema is 'SAPR3', not 'SAPSID'

Thanks

[Former Member]

Hi,

When I do a select owner for table "T000", I get the owner as SAPSID.

I have also looked at Note: 573042, it doesn't help.

Regards,

Vishi

[Former Member]

Hello,

Did you verify the value for the env variable 'dbs_ora_schema' ?

You can also verify when you log on to SAP, Menu bar --> System --> Status --> database data --> owner

Thanks

[Former Member]

Hi,

The problem is that recently, MS updates were applied to the OS, the same was not informed to me,

and as a result, the system rebooted, which shutdown the instances. The env variable has not been set.

I am unable to bring up the instance.

The same instance was running fine. According to the notes that I found, probably the schema owner is

SAPSID, not SAPR3, strangely, when I create the OPS$ users with owner as SAPSID as schema owner,

I can create the users. Then when I try to start SAP, the system is taking the schema owner as SAPR3.

I am unable to figure out what the problem could be.

Regards,

Vishi

[former_member188883]

Hi,

Can you maintain the environment variable db_ora_schema = SAP<SID> for sidadm user.

Post this check R3trans -d works or not.

Regards,

Deepak Kori

[former_member189725]

login as <sid>adm .

open a command prompt .

run the command 'set'

check the environment variable dbs_ora_schema if its set to sap<sid> or sapr3 , then this is the schema.

Now run sqlplus /nolog

connect /

show user

select * from SAPUSER;

The userid value is the schema user.

You can also verify the existence of the schema user by running

select USERNAME from dba_users;

by connecting as

sqlplus "/as sysdba"

[Former Member]

Hi Deepak,

Even after maintaining the variable, r3trans -d throws a return code 12.

I believe the schema owner is SAPSID, why the wp logs show as SAPR3.

Regards,

Vishnu.

[former_member188883]

Hi,

Please share the following

1) Output of command select username from dba_users;

2) Login with sidadm user and open a command prompt. Run command "set".

Share the output.

3) Share the trans.log post command R3trans -d.

4) Whats your database SID ?

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

1)

SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
OPS$DLWSDV11\CC5ADM
OPS$DLWSDV11\SAPSERVICECC5
SAPCC5

2)

C:\Documents and Settings\cc5adm>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\cc5adm\Application Data
CLASSPATH=C:\Program Files\Java\j2re1.4.2_13\bin;C:\j2sdk1.4.2_13\bin
CLIENTNAME=N1011215XPLT
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DLWSDV11
ComSpec=C:\WINDOWS\system32\cmd.exe
CPIC_MAX_CONV=500
DBMS_TYPE=ora
DBS_ORA_SCHEMA=SAPCC5
DBS_ORA_TNSNAME=CC5
DEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\DesktopPro
tection
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\cc5adm
JAVA_HOME=C:\j2sdk1.4.2_13
JRE_PATH=C:\Program Files\Java\j2re1.4.2_13\bin\java.exe
LOGONSERVER=\\MD1PRDFDC02
NSR_AVOID_ARCHIVE=YES
NUMBER_OF_PROCESSORS=8
ORACLE_HOME=D:\oracle\cc5
ORACLE_SID=CC5
OS=Windows_NT
Path=D:\oracle\cc5\bin;D:\oracle\CC6\102\bin;C:\Program Files\Legato\nsr\bin;D:\
oracle\cc5\jre\1.4.2\bin\client;D:\oracle\cc5\jre\1.4.2\bin;C:\Program Files\Win
dows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:
\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Dell\SysMgt\oma\bin;C:\Progra
m Files\Dell\SysMgt\RAC4;C:\Program Files\Dell\SysMgt\oma\oldiags\bin;C:\WINDOWS
\system32;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\WINDOWS\system32\Windows
PowerShell\v1.0;D:\oracle\cc5\bin;D:\usr\sap\CC5\SYS\exe\run
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1;.PSC1
PERL5LIB=D:\oracle\CC6\102\perl\5.8.3\lib\MSWin32-x86;D:\oracle\CC6\102\perl\5.8
.3\lib;D:\oracle\CC6\102\perl\5.8.3\lib\MSWin32-x86;D:\oracle\CC6\102\perl\site\
5.8.3;D:\oracle\CC6\102\perl\site\5.8.3\lib;D:\oracle\CC6\102\sysman\admin\scrip
ts
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 4 Stepping 9, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0409
ProgramFiles=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
SAPDATA_HOME=D:\oracle\cc5
SAPEXE=D:\usr\sap\CC5\SYS\exe\run
SAPINST_JRE_HOME=C:\Program Files\Java\j2re1.4.2_13
SAPLOCALHOST=dlwsdv11
SAPSYSTEMNAME=cc5
SESSIONNAME=RDP-Tcp#1
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\cc5adm\LOCALS~1\Temp\1
TMP=C:\DOCUME~1\cc5adm\LOCALS~1\Temp\1
USER=cc6adm
USERDNSDOMAIN=JDA.CORP.LOCAL
USERDOMAIN=JDA
USERNAME=cc5adm
USERPROFILE=C:\Documents and Settings\cc5adm
VSEDEFLOGDIR=C:\Documents and Settings\All Users\Application Data\McAfee\Desktop
Protection
windir=C:\WINDOWS

3)

C:\Documents and Settings\cc5adm>r3trans -d
This is r3trans version 6.09 (release 640 - 05.04.04 - 14:45:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o
ra_tnsname = 'CC5'"
r3trans finished (0012).

4)

CC5

Regards,

Vishi

[former_member189725]

Please provide the output of

Now run sqlplus /nolog

connect /

show user

select * from SAPUSER;

Also paste the trans.log .

[Former Member]

Hi,

SQL> show user;
USER is "SYS"

SQL> select * from SAPUSER;
select * from SAPUSER
              *
ERROR at line 1:
ORA-00942: table or view does not exist

Regards,

Vishi

[former_member189725]

Do not connect as sysdba.

Just run sqlplus /nolog

connect /

show user will give the output as OPS$ user.

Then run the query.

[former_member188883]

Hi,

Share the full trans.log

Regards,

Deepak Kori

[volker_borowski2]

Hi Deepak,
> 
> Even after maintaining the variable, r3trans -d throws a return code 12. 
> I believe the schema owner is SAPSID, why the wp logs show as SAPR3.
> 
> Regards,
> Vishnu.

Because the SAP runs with NT Account SAPServiceSID and when interacting you use sidadm in Windows.

So SAPServcieSID is not yet aware of that Environment change you did for sidadm.

Make sure the Environment is correct for sidadm

Execute "ntenv2reg", this will transfer the environemnet of sidadm to a Registry section that will be read by SAPServcieSID.

But this will nevertheless not work as long as you still get the error with r3trans as sidadm.

1) Execute ORADBUSR.SQL

2) Execute sapdba_role.sql

3) set DB Password for DB User SAPSID in brtools

4) Ensure Oracle Listener is running correctly

5) Retry R3trans as sidadm

6) When 5) works, execute ntenv2reg

7) restart the SAP Services in WIndows MMC

😎 Start SAP with MMC

Volker

[Former Member]

Hi,

I have tried suggestions from you all of you, Thank you.

However the problem still persists. I am quite unable to figure out, why it is showing SAPR3 in wp trace.

Below are the error details from dev_w0 log, trans.log

dev_w0:

 Logon as OPS$-user to get SAPR3's password
C  Connecting as /@CC5 on connection 0 ...
C  Attaching to DB Server CC5 (con_hdl=0,svchp=0493EFF4,svrhp=07FB9234)
C  Starting user session (con_hdl=0,svchp=0493EFF4,srvhp=07FB9234,usrhp=07FC1E64)
C  Now I'm connected to ORACLE
C  *** ERROR => ORA-1403 when accessing table SAPUSER
 [dbsloci.c    10114]
C  Disconnecting from connection 0 ...
C  Closing user session (con_hdl=0,svchp=0493EFF4,usrhp=07FC1E64)
C  Now I'm disconnected from ORACLE
C  Try to connect with default password
C  Connecting as SAPR3/<pwd>@CC5 on connection 0 ...
C  Starting user session (con_hdl=0,svchp=0493EFF4,srvhp=07FB9234,usrhp=07FC1E64)
C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
 [dboci.c      3721]
C  *** ERROR => CONNECT failed with sql error '1017'
 [dbsloci.c    9750]
B  ***LOG BY2=> sql error 1017   performing CON [dbsh#1 @ 1200] [dbsh    1200 ]
B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#1 @ 1200] [dbsh    1200 ]
B  ***LOG BY2=> sql error 1017   performing CON [dblink#1 @ 419] [dblink  0419 ]
B  ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink  0419 ]
M  ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c   1270]
M  in_ThErrHandle: 1

Trans.log"

4 ETW000  [dev trc     ,00000]  Thu Nov 24 23:48:32 2011                           80178  0.132260
4 ETW000  [dev trc     ,00000]  Assigning server context 02C0982C to service context 02C08C24
4 ETW000                                                                              57  0.132317
4 ETW000  [dev trc     ,00000]  Allocating user session handle                        47  0.132364
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=02C08C24,srvhp=02C0982C,usrhp=02C123F4)
4 ETW000                                                                             165  0.132529
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000                                                                            6620  0.139149
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1017'
4 ETW000                                                                              31  0.139180
4 ETW000  [dev trc     ,00000]  Try to connect with default password                  73  0.139253
4 ETW000  [dev trc     ,00000]  Connecting as SAPCC5/<pwd>@CC5 on connection 0 ...
4 ETW000                                                                              27  0.139280
4 ETW000  [dev trc     ,00000]  Assigning username to user session 02C123F4           19  0.139299
4 ETW000  [dev trc     ,00000]  Assigning password to user session 02C123F4           28  0.139327
4 ETW000  [dev trc     ,00000]  Starting user session (con_hdl=0,svchp=02C08C24,srvhp=02C0982C,usrhp=02C123F4)
4 ETW000                                                                              31  0.139358
4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000                                                                            7326  0.146684
4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1017'
4 ETW000                                                                              31  0.146715
4 ETW000  [dblink      ,00419]  ***LOG BY2=>sql error 1017   performing CON [dblink#1 @ 419]
4 ETW000                                                                             141  0.146856
4 ETW000  [dblink      ,00419]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#1 @ 419]
4 ETW000                                                                              27  0.146883
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'CC5'"

Should I go back looking at Note: 400241.

Regards,

Vishnu

[former_member189725]

Login to the OS as user SAPSERVICE<SID> (not as <SID>ADM).

Check the environment variable dbs_ora_schema , that must be SAPR3.

change it to SAPCC5.

Login as <sid>adm

login as sqlplus "/as sysdba"

check if a synonym exist with the name SAPUSER

if not follow sap note 50888

start brtools, change the password of SAPCC5.