Skip to Content
avatar image
Former Member

Why no SAPR3 user in database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 24, 2009 at 09:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded