Cannot start Oracle TNSListener service after upgrading

[zhang_jiwen]

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

[Former Member · Accepted solution]

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

[zhang_jiwen · Accepted solution]

Hi Orkun,

      Thanks for quick reply!

      We checked carefully and found that the Environment Variable 'ORACLE_HOME' of User Variable poinited to 11G,'ORACLE_HOME' of System Variable pointed to 10G.Then,we modified 'ORACLE_HOME' of System Variable to point to 11G,and it's ok now(both the TNSListener service and java instance start).

      However,we are confused: doesnot user variable have priority over system variable?

Best regards,

Sciano

[Former Member · Accepted solution]

Hi Scanio,

User environment variables appended into system variables, not replaced. In this case the answer is system variable priority higher than user priority.

Check the link, below;

http://support.microsoft.com/kb/100843

Best regards,

Orkun Gedik

[zhang_jiwen · Accepted solution]

Hi Orkun,

    Thanks again.

     I have read the article you linked to me,it said that"These variables take precedence over system environment variables. The user path is appended to the system path. " Only "path" user variable is appende to system variable.However, in our case,it's “ORACLE_HOME" not ”path“.

Best regards,

Sciano

[Former Member · Accepted solution]

Hi Scanio,

Yes, it is correct. But as a rule of thumb, ORACLE_HOME parameter shouldn't be defined under system variables.

Best regards,

Orkun Gedik

[zhang_jiwen · Accepted solution]

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

[Former Member]

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.

[zhang_jiwen]

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

[Former Member]

Hi.

verify once ..10g listener services

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

[zhang_jiwen]

Hi tunga,

       We checked carefully and found that the Environment Variable 'ORACLE_HOME' of User Variable poinited to 11G,'ORACLE_HOME' of System Variable pointed to 10G.Then,we modified 'ORACLE_HOME' of System Variable to point to 11G,and it's ok now(both the TNSListener service and java instance start).

      We assumed that Enviroment variables should be the reason for  TNSListener startup failed.

      What's the result if not stop the oracle 10g listener service before installing 11g listener service?

      Thanks and regards.

Sciano

[Former Member]

Hi.

[Former Member]

Hi .

pls provide full screen of below lik

10-Start Listener with 'lsnrctl start'.gif

[zhang_jiwen]

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

[zhang_jiwen]

Sorry,the rest attachment

[zhang_jiwen]

Sorry,the rest attachment

[zhang_jiwen]

Sorry,the rest attachment