SUM Error in PREP_INIT/DBCHK_INI!

[jorge_velasquez]

Hi Experts,

I am facing an error in phase PREP_INIT/DBCHK_INI!.

Windows OS : WAS ABAP

Linux OS: DB Server

After checking logs I found this in PHASES.LOG file:

1 ETQ201 Entering upgrade-phase "PREP_INIT/DBCHK_INI" ("20141027183353")
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
4 ETQ399 Environment variables:
4 ETQ399   dbs_ora_schema=SAPSR3
4 ETQ399   auth_shadow_upgrade=<null>
1 ETQ206 Executing pre-phase OS specific actions.
1 ETQ200 Executing actual phase 'PREP_INIT/DBCHK_INI'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'CHECK_UPGCOND;CHECK_MCOD;SET_DBENV'
3 ETQ121 20141027183354: PID 7848 execute 'E:\usr\sap\ERD\SYS\exe\uc\NTAMD64\sqlplus SYSTEM@ERD @E:\usr\sap\SUM\abap\bin\ORAGETNLS.SQL' in background, output written to 'E:\usr\sap\SUM\abap\log\ORAGETNLS.LOG'.
3 ETQ123 20141027183354: PID 7848 exited with status 0 (time 0.000 real)
4 ETQ399 20141027183354: WAITED for 1 processes to finish, 0 aborted.
1EETQ399 Last error code set is: Cannot open 'E:\usr\sap\SUM\abap\tmp\NLSLANG.DAT': The system cannot find the file specified.

1EETQ204 Upgrade phase "DBCHK_INI" aborted with severe errors ("20141027183354")

Also this in ORAGETNLS.LOG file:

SAPup> Starting subprocess in phase 'DBCHK_INI' at 20141027183353
    ENV: DBMS_TYPE=ora
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_SID=ERD
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=E:\usr\sap\ERD\SYS\exe\uc\NTAMD64;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\
    ENV: SAPSYSTEMNAME=ERD
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=//<hostname of server Linux DB>/ERD_DVEBMGS00
    ENV: rsdb_ssfs_connect=1

EXECUTING E:\usr\sap\ERD\SYS\exe\uc\NTAMD64\sqlplus.EXE SYSTEM@ERD @E:\usr\sap\SUM\abap\bin\ORAGETNLS.SQL

SQL*Plus: Release 11.2.0.3.0 Production on Mon Oct 27 18:33:54 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter password: ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor

Enter user-name:

I already check SYSTEM user and I can access with sqlplus with password given in SUM previously.

Any clue?

[Former Member]

Hello ,

You can run R3trans and check the output.

Run R3trans -X and check trans.log , you might get same error

ORA-12505: TNS:listener does not currently know of SID given in connect

Please check if in listener.ora file whether correct SID has been maintained. Ensure listener.ora is synchronized in both the places /sapmnt/profile/oracle as well as /oracle_home/network/admin location .

Regards,

Archana