Skip to Content

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

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

Former Member
Not what you were looking for? View more on this topic or Ask a question