Skip to Content

System refresh - creation of OPS$ users

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 22, 2010 at 04:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • avatar image
    Former Member
    Feb 23, 2010 at 08:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2010 at 09:01 AM

    Application is running fine.

    Add comment
    10|10000 characters needed characters exceeded