System refresh - creation of OPS$ users

[former_member759680]

Hello,

We have SAP on Win+Oracle (10.2.0.4)

We successfully restored the database of our source system on our target

Target - Q5E

Source - P5E

To create OPS users I downloaded the script - oradbuser.sql from Note 50088-

I executed the query as per the instructions in teh script

sqlplus /nolog @oradbusr.sql SAPSR3 NT A92HOSTQ5E Q5E

However the new users created do not contain the Domain-

O$Q5EADM

O$SAPSERVICEQ5E

Outputs -

D:\Cap\Scripts\Refresh>sqlplus /nolog @oradbusr.sql SAPSR3 NT A92HOSTQ5E Q5E

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 22 17:07:38 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected.
old   6:   if length('&&1') = 5 then
new   6:   if length('SAPSR3') = 5 then
old   7:     if substr(upper('&&1'),1,5) = 'SAPR3' then
new   7:     if substr(upper('SAPSR3'),1,5) = 'SAPR3' then
old  11:       if upper('&&2') = 'NT' then
new  11:       if upper('NT') = 'NT' then
old  18:        :sDomain := upper('&&3');
new  18:        :sDomain := upper('A92HOSTQ5E');
old  19:         :sSapSid := upper('&&4');
new  19:         :sSapSid := upper('Q5E');
old  21:         :sSapSid := upper('&&3');
new  21:         :sSapSid := upper('A92HOSTQ5E');
old  37:     :sSchema := upper('&&1');
new  37:     :sSchema := upper('SAPSR3');
old  39:     if upper('&&2') = 'NT' then
new  39:     if upper('NT') = 'NT' then
old  46:       :sDomain := upper('&&3');
new  46:       :sDomain := upper('A92HOSTQ5E');
old  47:       :sSapSid := upper('&&4');
new  47:       :sSapSid := upper('Q5E');
old  49:       :sSapSid := upper('&&3');
new  49:       :sSapSid := upper('A92HOSTQ5E');
using following Parameters:
.
.  Oracle Version:                     10.2.0.4.0
.  Parametervalue os_authent_prefix:   O$
.  Schema Id:                          SR3
.  Database User (Schema):             SAPSR3
.  SAP R/3 Administrator:              O$Q5EADM
.  SAP R/3 Serviceuser:                O$SAPSERVICEQ5E
.  Domain/Host:                        A92HOSTQ5E
.
Connected.
Connected.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select username from dba_users ;
USERNAME
------------------------------
SYSTEM
SYS
ORACLE_OCM
O$A92HOSTP5E\SAPSERVICEP5E
O$Q5EADM
SAPSR3
DBSNMP
DIP
OUTLN
O$SAPSERVICEQ5E
O$A92HOSTP5E\P5EADM

[former_member759680]

Application is running fine.

[Former Member]

This doesn't matter.......you can run your applcation without domain ids also.

But if you face any issues relaated to security(policies) i'd suggest to create these users manually by following SAP Note 50088.

Regards,

Nick Loy

[Diggeshhjoshi]

Gautam,

is A92HOSTQ5E is your domain name ?

Here is how I will run script,

sqlplus /nolog @oradbusr.sql SAPSR3 NT COMPANY Q5E

"COMPANY" = domain name.

- Digesh Joshi

[former_member759680]

is A92HOSTQ5E is your domain name ? 

Here is how I will run script,

sqlplus /nolog @oradbusr.sql SAPSR3 NT COMPANY Q5E

"COMPANY" = domain name

Yes, A92HOSTQ5E is my domain name

And that is exactly how I ran the script.

Anything useful, you wanna add?

[nirmal_konchada]

Hi,

Just run the script without any parameter i.e. @oradbusr.sql

after running it will prompt you to enter the domain name and the prompt you for the SID

Try this............it may work

Nirmal.

[ps0907]

You may want to double-check that you are using the oradbusr.sql in the ZIP attachment on note 50088, which supports Oracle 10, and not the TXT attachment. The TXT attachment is the older version which worked fine up through Oracle 9. There is an IF test in the script on version that doesn't seem to work correctly when Oracle version is 10.x

Old version - TXT

if :bONNT = 1 then

>> if :sVersion > '8.1.0.0.0' then <--<<

:sR3user := sPrefix || :sDomain || '\' || :sSapSid || 'ADM';

:sSvcuser := sPrefix || :sDomain || '\' || 'SAPSERVICE' || :sSapSid;

else

:sR3user := sPrefix || :sSapSid || 'ADM';

:sSvcuser := sPrefix || 'SAPSERVICE' || :sSapSid;

end if;

else

The updated 10g script in the ZIP file handles the version check in a different manner.

[former_member759680]

Hello,

As per reply from Paul S, I deleted the users -

O$Q5EADM

O$SAPSERVICEQ5E

downloaded the .zip file attachment of Note 50088 and ran it again.

I still get the same users

O$Q5EADM

O$SAPSERVICEQ5E

And it did not give any error.

Are these 2 users ok? What issues would I face in future if the users do not contain the domain?