on 02-22-2010 4:22 PM
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
Application is running fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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?
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.