Why no SAPR3 user in database

[Former Member]

I migrated a R/3 4.6C system from AIX to windows. R/3 system runs smoothly on windows platform with Oracle 10g. When I try to upgrade it to ECC6, it failed on DBCHK_PRE. Error information is shown below

>> 00:08:32  PREPARE: START OF PHASE DBCHK_PRE 
running D:\usr\sap\T01\SYS\exe\run\tp.exe pf=d:\usr\sap\put\bin\DEFAULT.TPP getdbinfo T01
Please check the logfile ORAGETNLS.LOG
in the directory d:\usr\sap\put\log for errors on
execution of script d:\usr\sap\put\bin\ORAGETNLS.SQL
Did ORAGETNLS.SQL execute correctly?

Error information in ORAGETNLS.LOG is shown as below.

SAPup>  Starting subprocess sqlplus.exe with id 460 at 20090325000833
Environment: dbs_ora_schema=SAPT01
Environment: dbs_ora_tnsname=T01
Environment: NLS_LANG=AMERICAN_AMERICA.WE8DEC
Environment: ORACLE_HOME=f:\oracle\product\10.2.0\db_1
Environment: ORACLE_SID=T01
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Mar 25 00:08:33 2009
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: 

I check the system and find there is no SAPR3 user in system as below.

SQL> select username from all_users;
USERNAME             
-
OPS$CCLEMON\SAPSERVICET01
SAPT01
OPS$CCLEMON\T01ADM
DBSNMP
TSMSYS
DIP
OUTLN
SYSTEM
SYS

R3trains -d runs smoothly with no error. My question is which user will execute ORAGETNLS.SQL? Thanks

James

[Former Member · Accepted solution]

Hi James,

During the PREPARE run, the ORAGETNLS.SQL SQL script is executed in the DBCHK_PRE phase on Windows NT/Oracle Please check Note 528339 - DBCHK_PRE: Permission denied with ORAGETNLS.SQL

ERROR:

ORA-01017: invalid username/password; logon denied Please check Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Thank you,

Shyam