Skip to Content
author's profile photo Former Member
Former Member

SAP upgrade to 11.2.0.4 - DBUA results on error "sp02 -0640:not connected".

Hi,

I am new on SAP WORLD and i´m trying to upgrade SAP database from 11.2.0.3 to SAP 11.2.0.4

I am following this SAP NOTE:

Database Upgrade Guide

Upgrade to Oracle Database 11g Release 2 (11.2): UNIX

For Oracle Patch Set Release 11.2.0.4

I have executed "./dbua.sap.sh -q" with success.

So i tried to execute the DBUA with this steps:

bash

export DISPLAY=10.1.4.175:0.0

export IHRDBMS=/oracle/XYZ/11204

export OHRDBMS=/oracle/XYZ/112_64

export ORACLE_HOME_SRC=/oracle/XYZ/112_64

export ORACLE_HOME_TGT=/oracle/XYZ/11204

cd $ORACLE_HOME_TGT/sap/ora_upgrade/post_upgrade

./dbua.sap.sh

After WELCOME page appeared with sucess, i pressed NEXT and recieved:

"sp02 -0640:not connected".

I checked TRACE.LOG (attached on discussion) generated and discovered this message error:

[Thread-7] [ 2016-08-10 20:06:39.803 BRT ] [OracleHome.initOptions:1253] executing: startup nomount pfile='/oracle/XYZ/11204/dbs/init

[Thread-7] [ 2016-08-10 20:06:39.847 BRT ] [SQLEngine.done:2189] Done called

[Thread-7] [ 2016-08-10 20:06:39.848 BRT ] [OracleHome.initOptions:1262] ORA-01041: internal error. hostdef extension doesn't exist

I do not know if i am missing something in the SAP note. If someone could suggest anything to check the enviroment, i will be glad.

Best regards,

Sergio

trace.TXT.zip (4.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

14 Answers

  • Best Answer
    Posted on Aug 10, 2016 at 11:50 PM

    Hello Sergio,

    Please validate whether the system time is properly set at the OS level. If not, do so and reboot the server. Also make sure the init or spfile under $ORACLE_HOME/dbs are clean.

    Best regards,

    Thiago

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2016 at 08:53 PM

    Hi,

    I have:

    • Recreated orapwdECH file om ORACLE_HOME_SOURCE 11.2.0.3;
    • Discover a depreciated parameter (remote_login_password) on SPFILE of ORACLE_HOME_SOURCE and deleted from it;
    • Shutdown listener and RDBMS of ORACLE_HOME_SOURCE;
    • Startup RDBMS of ORACLE_HOME_SOURCE;
    • Set environment variables to run DBUA.sap.sh;
    • Runned DBUA.sap.sh;

    On Welcome page i have pressed NEXT an got again error sp02 -0640:not connected".

    I have checked DBUA log and found the error ORA-01041: internal error. hostdef extension doesn't exist

    Really do not know what do do now. Maybe i can execute ORACLE DBUA as oracle note explains, to see i can found a reason for this problem. Only one thing: where is ORACLE ALERT.LOG of instance 11.2.0.4? I could not found alert.log of it. And i think it´s strange 11.2.0.4 INIT and PWD files of 11.2.0.4 have "randonic names" (ex: initDBUA4718262.ora instead of initECH.ora).

    I´m upolading some files of last execution.

    Regards,

    Sergio


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I don't see any errors in the pre-upgrade status. This task was run on 11.08. I assume that there were no changes in database objects afterwards. I think you can go with the DBUA run and post if you have any errors reported.

      Regards,

      Ganesan

  • Posted on Aug 11, 2016 at 08:05 AM

    Hi Sergio,

    The error is caused by startup nomount:

    startup nomount pfile='/oracle/XYZ/11204/dbs/init


    The pasted command is not complete, can you show us with the complete one?

    Please check which pfile is used to start instance.

    Best regards,
    James

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 11, 2016 at 06:37 PM

    Hi Sergio,

    Could you please confirm below:

    1. Your database is up and running from old Oracle Home /oracle/XYZ/112_64

    2. You haven't set ORACLE_HOME to /oracle/XYZ/11204 before running this dbua.

    3. You don't need to set IHRDBMS & OHRDBMS environment variable. Only ORACLE_HOME_TGT & ORACLE_HOME_SRC are sufficient to run dbua

    Thanks,

    Manish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2016 at 11:36 PM

    Hi,

    I have done the following test suggested by K GANESAN

    I have added the following line to sqlnet.ora : SQLNET.AUTHENTICATION_SERVICES = (NONE)

    After it, i have repeated DBUA : ./dbua.sap.sh

    I have noticed that message error changed


    FROM:


    Initializing Database Options with for dummy

    sid=DBUA2642116 using initfile=/oracle/ECH/11204/dbs/initDBUA2642116.ora using pwdfile=/oracle/ECH/11204/dbs/orapwDBUA2642116

    ORA-01041: internal error. hostdef extension doesn't exist

    TO:


    Initializing Database Options with for dummy

    sid=DBUA2642116 using initfile=/oracle/ECH/11204/dbs/initDBUA2642116.ora using pwdfile=/oracle/ECH/11204/dbs/orapwDBUA2642116

    ORA-01017: invalid username/password; logon denied

    Best regards,

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      It seems that your password file (pwdfile=/oracle/ECH/11204/dbs/orapwDBUA2642116)is not a good one. You need to re-create password file using ORAPWD utility. Try to follow the procedure mentioned in the link. Rename the present password file before creating a new one with the same name. After creating the new password file, DBUA should work. Hope this can help you.

      Creating and Maintaining a Password File

      Regards,

      Ganesan

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2016 at 12:44 AM

    Hi James,

    Thanks for the feedback.

    My $ORACLE_SID is seted with value "XYZ".

    May be "initDBUA0507753.ora" is an strange name, but i saw that DBUA have generated both PWD and INIT with this name in TARGET ORACLE HOME dbs directory.

    Cause this is the first time i am updating this SAP environment, i really doesn´t know if this issue is common on SAP oracle database upgrades.

    Best regards,

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I just mentioned that (DBUA) password files is not a good one. You need to create the password file for the existing system, the file name will be "pwd<SID>.ora" in dbs directory. When you run DBUA, it will create a copy of password file from the existing system. Also check, OS user executing DBUA has all access rights on Oracle binary. (I had the same issue last year during upgrade in Windows platform, and I solved it by granting full control to executing user on the Oracle directory). If you still have access issues, let us know, you still have a way to upgrade it "Manually".

      Regards,

      Ganesan

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2016 at 12:28 PM
    Re: SAP upgrade to 11.2.0.4 - DBUA results on error "sp02 -0640:not connected".

    Sergio CoutinhoGlass

    Sergio Coutinho Aug 12, 2016 2:19 PM (in response to K GANESAN)

    Hi K.Ganezan,

    I will proceed with this action plan you suggested me.

    But before it, i would like to show you DBS directory of 11.2.0.3 and 11.2.0.4 releases:

    A) This is DBS directory of actual release 11.2.0.3 (112_64 - ORACLE_HOME_SOURCE):

    -rw-rw---- 1 oraech dba 1544 Aug 11 18:51 hc_ECH.dat

    -rw-r----- 1 root sapinst 641 Nov 4 2015 initECH.1.ora

    -rw-r-x--- 1 root sapinst 1528 Nov 4 2015 initECH.2.ora

    -rw-r-x--- 1 root sapinst 1668 Nov 4 2015 initECH.3.ora

    -rw-r----- 1 root sapinst 641 Nov 4 2015 initECH.4.ora

    -rw-r-x--- 1 root sapinst 1528 Nov 4 2015 initECH.5.ora

    -rw-r-x--- 1 root sapinst 1668 Nov 4 2015 initECH.6.ora

    -rw-r----- 1 root sapinst 641 Nov 4 2015 initECH.7.ora

    -rw-r-x--- 1 root sapinst 1528 Nov 4 2015 initECH.8.ora

    -rw-r-xr-x 1 oraech dba 1867 Jun 27 23:00 initECH.ora

    -rw-r-x--- 1 root sapinst 1668 Nov 4 2015 initECH.ora.SAPINST-ORIG

    -rw-r-xr-x 1 oraech dba 29947 Nov 4 2015 initECH.sap

    -rw-r--r-- 1 oraech dba 2851 May 15 2009 init.ora

    -rw-r----- 1 oraech dba 24 Nov 4 2015 lkECH

    -rw-r----- 1 oraech dba 2560 Nov 11 2015 orapwECH

    -rw-r--r-- 1 oraech dba 1867 Jun 27 23:00 sapECH.ora

    -rw-r--r-- 1 oraech dba 1867 Jun 27 23:00 sapECH.ora.bkp2

    -rw-r----- 1 oraech dba 24559616 Jun 28 01:44 snapcf_ECH.f

    -rw-r----- 1 oraech dba 4608 Aug 11 18:45 spfileECH.ora

    -rw-r----- 1 oraech dba 4608 Jul 2 12:47 spfileECH.ora.bkp2


    B) This is DBS directory of future release 11.2.0.4 (ORACLE_HOME_TARGET):


    drwxr-x--- 2 oraech dba 4096 Aug 8 18:37 core_8222


    << many core_NNNN directories >>


    drwxr-x--- 2 oraech dba 4096 Aug 8 18:54 core_9972

    -rw-r----- 1 oraech dba 143 Aug 11 00:01 initDBUA0153361.ora

    -rw-r----- 1 oraech dba 143 Aug 11 00:02 initDBUA0253120.ora

    -rw-r----- 1 oraech dba 143 Aug 11 19:05 initDBUA0507753.ora

    -rw-r----- 1 oraech dba 143 Aug 11 02:09 initDBUA0909869.ora

    -rw-r----- 1 oraech dba 143 Aug 10 23:10 initDBUA1046410.ora

    -rw-r----- 1 oraech dba 143 Aug 11 02:12 initDBUA1212960.ora

    -rw-r----- 1 oraech dba 143 Aug 11 02:12 initDBUA1233265.ora

    -rw-r----- 1 oraech dba 143 Aug 11 00:17 initDBUA1701703.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:17 initDBUA1718394.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:17 initDBUA1724787.ora

    -rw-r----- 1 oraech dba 143 Aug 10 23:18 initDBUA1804938.ora

    -rw-r----- 1 oraech dba 143 Aug 12 01:19 initDBUA1956290.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:21 initDBUA2113391.ora

    -rw-r----- 1 oraech dba 143 Aug 11 21:24 initDBUA2403690.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:24 initDBUA2437775.ora

    -rw-r----- 1 oraech dba 143 Aug 11 21:25 initDBUA2509925.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:25 initDBUA2544446.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:25 initDBUA2550492.ora

    -rw-r----- 1 oraech dba 143 Aug 11 20:26 initDBUA2642116.ora

    -rw-r-xr-x 1 oraech dba 29947 Nov 4 2015 initECH.sap

    -rw-r--r-- 1 oraech dba 2851 May 15 2009 init.ora

    -rw-r----- 1 oraech dba 1536 Aug 11 21:25 OLD_orapwDBUA2509925

    -rw-r----- 1 oraech dba 1536 Aug 11 00:01 orapwDBUA0153361

    -rw-r----- 1 oraech dba 1536 Aug 11 00:02 orapwDBUA0253120

    -rw-r----- 1 oraech dba 1536 Aug 11 19:05 orapwDBUA0507753

    -rw-r----- 1 oraech dba 1536 Aug 11 02:09 orapwDBUA0909869

    -rw-r----- 1 oraech dba 1536 Aug 10 23:10 orapwDBUA1046410

    -rw-r----- 1 oraech dba 1536 Aug 11 02:12 orapwDBUA1212960

    -rw-r----- 1 oraech dba 1536 Aug 11 02:12 orapwDBUA1233265

    -rw-r----- 1 oraech dba 1536 Aug 11 00:17 orapwDBUA1701703

    -rw-r----- 1 oraech dba 1536 Aug 11 20:17 orapwDBUA1718394

    -rw-r----- 1 oraech dba 1536 Aug 11 20:17 orapwDBUA1724787

    -rw-r----- 1 oraech dba 1536 Aug 10 23:18 orapwDBUA1804938

    -rw-r----- 1 oraech dba 1536 Aug 12 01:19 orapwDBUA1956290

    -rw-r----- 1 oraech dba 1536 Aug 11 20:21 orapwDBUA2113391

    -rw-r----- 1 oraech dba 1536 Aug 11 21:24 orapwDBUA2403690

    -rw-r----- 1 oraech dba 1536 Aug 11 20:24 orapwDBUA2437775

    -rw-r----- 1 oraech dba 5120 Aug 12 01:19 orapwDBUA2509925

    -rw-r----- 1 oraech dba 1536 Aug 11 20:25 orapwDBUA2544446

    -rw-r----- 1 oraech dba 1536 Aug 11 20:25 orapwDBUA2550492

    -rw-r----- 1 oraech dba 1536 Aug 11 20:26 orapwDBUA2642116

    So, i will :

    1. Recreate PWD file on actual ORACLE_HOME_SOURCE 11.2.0.3 (orapwECH);
    2. Purge all "initDBUA*.*" and "orapwDBUA*" on ORACLE_HOME_TARGET 11.2.0.4;
    3. Change permissions on ORACLE_HOME_SOURCE and ORACLE_HOME_TARGET;

    chmod -R 755 /oracle/ECH/11203

    chmod -R 755 /oracle/ECH/11204

    Could i proceed with this action plan? We have an window maintenance, so i am afraid i need to wait sometime before could apply it.

    You have mentioned that it´s possible to upgrade it "manually". Could you show me some note or instruction about how to do it?

    I have found a metalink note called "Complete Checklist for out-of-Place Manual Upgrade from Previous 11.2.0.N Version to the Latest 11.2.0.N Patchset (Doc ID 1276368.1)". Is something like that you could provide to me?

    Best regards, and thank you for your help!


    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I think you already installed Oracle target version as a SAP relevant installation. So, for me, there should be no special scripts for SAP in DBUA. I dont find any document to justify about SAP scripts in DBUA. In every version, you can see preupgrade, upgrade and post upgrade scripts. For sure, in our CRM production system, we upgraded oracle manually in Windows platform while we used DBUA in DEV & QAS last year. I dont have any issues after the manual upgrade.

      As suggested by James, you can try to do all possibilities to do the upgrade using DBUA, before going with manual upgrade as a last option. If you have oracle DBA at your site, you can also discuss with them. If you have any more query, feel free to update us.

      Regards,

      Ganesan

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2016 at 08:54 PM

    PSC

    Another files ..


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I don't see any issues regarding the settings for the upgrade. The issue seems DBUA is not getting restarted properly after the first run. I also suggest you to open an incident with SAP for further assistance. But before that, i would like you to give one more try.If you find the file "$ORACLE_HOME/cfgtoollogs/dbua/logs/Welcome_ECH.txt", backup and remove it.

      Then try to run "./dbua.sap.sh" again. If it doesn't work, you can raise an incident with SAP as suggested by James. It is really strange, dbua could not start dummy instance when we don't have any issues until this step.

      Regards,

      Ganesan

  • author's profile photo Former Member
    Former Member
    Posted on Aug 14, 2016 at 09:53 PM

    Hi,

    I can resume the problem in this manner

    A) WITHOUT "SQLNET.AUTHENTICATION_SERVICES = (NONE)" :


    ORA-01041: internal error. hostdef extension doesn't exist

    B) WITH "SQLNET.AUTHENTICATION_SERVICES = (NONE)" :


    ORA-01017: invalid username/password; logon denied


    obs: The PWD file was recreated on ORACLE_HOME_SOURCE/dbs


    Reggards,

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2016 at 09:39 AM

    Hi,

    It seems that the error is "ORA-01041". Could you check what is the parameter "SQLNET.AUTHENTICATION_SERVICES" value in "sqlnet.ora" file? Could you try to set this parameter to "NONE" and try to restart DBUA again?

    Regards,

    Ganesan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.