avatar image
Former Member

Cannot start Oracle TNSListener service after upgrading

Hi All,
    Yestoday, we upgraded Oracle from 10.2.0.4 to 11.2.0.3 on PI QAS
system 'XQ1' under WINDOWS 64-bit platform.
    When we were running dbua.sap.ps1,there comes a warning "the
database is running on 10.2.0.3",please check the attachment '01-oracle
version 10203'.However,we are sure that it's version is 10.2.0.4.
    Then,we ingored the warning and continued,please check the
attachment '02-continue to upgrade'.
    During the upgrading procedure,we encounted a warning "table or view
doesnot exist',please check the attachment '03-ORA-00942 table or view
does not exist' and '04-Oracle_Server log file'.And,we ignored and
continued.
    After the upgrading,the upgrade result displayed successful
upgrading from 10.2.0.4 to 11.2.0.3,please check the attachment '05-
upgrade result' ,'06-upgrade result' and '07-upgrade result'.
    When running "lsnrctl start' to create TNSListener service in post-
upgrade steps,we cannot start the TNSListener service,please check the
attachment '08-Create TNSListener service','09-TNSListener service
cannot start' and '10-Start Listener with 'lsnrctl start''.

    Today,we rebooted the Windows server and found the TNSListener
service can start.However,we start the sap instance using SAP MMC.There
comes an issue "disp+work.EXE of java instance stopped",please check
the attachment ’11-java instance cannot start‘.
    Then,we rebooted the Windows server and found the TNSListener server
cannot start again,please check the attachment '09-TNSListener service
cannot start'.

    Who can help me?Thanks in advance!

Best regards,
Sciano

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 01, 2012 at 06:03 AM

    Hi Scanio,

    Could you check the windows event log related with the oracle listener, please? Additionally you should check listener trace under oracle directory to find out the problem.

    Moreover check the listener port has been allocated by another process with netstat -a -o

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Orkun,

          SAP consultant answers me as follows,and i'd like to share with you.

      ------------------------------------------------------------------------------------------------------------------------

           From the query I can see that the DB has been upgraded to 11g. I think

      it should be fine now. Enviroment variables should be the reason for

      TNSListener startup failed.

           I would loke to suggest monitoring the system and see if there is any

      problem happen. If any abnormal raised please feel free to contact SAP

      support. During oracle upgrade, ORACLE_HOME is also in different usage.

      So I think this problem can be considered to be resolved.

           For ora-00942 error, you can ignore it but please run following scripts

      after upgrade:

           /rdbms/admin/catnowrr.sql

           /rdbms/admin/catwrr.sql

      -----------------------------------------------------------------------------------------------------------------------    

          

      Best regards,

      Sciano

  • avatar image
    Former Member
    Jul 01, 2012 at 03:24 AM

    Sorry,the rest attachment

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 04, 2012 at 04:46 PM

    Hi.

    verify once ..10g listener services

    Before installing listener service stop the oracle 10g listener service in “services.msc”

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi tunga,

           Thanks for your reply!

           SAP consultants assumed that its reason was the Environment variable "ORACLE_HOME",and our issue had been resolved. Only having curious about the priority of system variable and user variable of Environment ,because in our case it seems the system variable has precedence over user variable.

      Best regards,

      Sciano

  • avatar image
    Former Member
    Jul 11, 2012 at 11:58 AM

    Hallo,

    have you checked the listener config file listener.ora in /oracle/DBSID/11.../network/admin?

    ORACLE_HOME is also defined in there. Maybe it's still pointing to 10g home?

    You should have an entry like:

    SID_LIST_LISTENER =

      (SID_LIST =

        (SID_DESC =

          (SID_NAME = YourSID)

          (ORACLE_HOME = /oracle/YourSID/112_64)

        )

      )

    You are also supposed to set

    ADR_BASE_LISTENER = /oracle/DBSID/saptrace

    in there but I guess this doesn't relate to your problem.

    Regards,

    Thomas.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Thomas,

           Thanks for your reply!

           SAP consultants assumed that its reason was the Environment variable "ORACLE_HOME",and our issue had been resolved. Only having curious about the priority of system variable and user variable of Environment ,because in our case it seems the system variable has precedence over user variable.

      Best regards,

      Sciano

Skip to Content