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

restarting DBUA after it failed once

I am trying to upgrade oracle from 10G to 11G R2 for SAP ECC with DBUA and it failed with error below after 11% completed

ORA-00119 invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name LISTENER_S2D

I tried with ignoring this message, it ended up with error ORA-01034 - oracle not available, finally DBUA terminated .

When I tried to rerun DBUA , I am getting following message:

"All components of the selected database have been already been upgraded, select another databse to perform upgrade"

Please let me know how I can restart the DBUA

Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 19, 2011 at 05:30 PM

    Hello Abu,

    Please let me know how I can restart the DBUA

    Well .. restore and recover your old database database is the only solution, if an interuption occured in the upgrade process.

    Then you can try it again with DBUA. You can also try to continue by performing a manual upgrade (and not through DBUA) - but in this case you need to know what to do.

    ORA-00119 invalid specification for system parameter LOCAL_LISTENER

    ORA-00132: syntax error or unresolved network name LISTENER_S2D

    I tried with ignoring this message

    Bad idea ... you have defined a SQL*Net name with init parameter LOCAL_LISTENER, which is used to register the database at the defined listener. Oracle can not resolve that name to a hostname/port/service and so your database will not start .. that's the reason why you get an ORA-01034 afterwards.

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      you need to add the following entry to tnsnames.ora before starting dbua.sap.sh

      LISTENER_DBSID.WORLD = (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = hostname)(PORT = portno.))

      make sure you give the port no. where the old oracle 10 was registered.

      regards

      Pankaj

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2011 at 09:15 AM

    I think you can use ORATAB file.

    Check oracle version mentioned for your SID.

    Regards,

    Nirav Shah.

    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.