Hi. I have problem with oracle after upgrade from 9.2.0.4.0 to 9.2.0.6.0

[Marcin_9]

I dit upgrade (applying patches) and now oracle is not listening on 8080 port. Do you know what I mean? Could you help somehow?

[Steven E. Protter]

Did you relink the binaries?

Sometimes this helps.

I'd also consider booting the box to see if things get cleared up.

There is a script called root.sh that might need to be re-run to properly enable the httpd server to serve the port.

May I ask why you upgraded? Did you run into a specific issue. WE are at 9.2.0.4.0 right now.

SEP

[Marcin_9]

Hi,
But there were not mentioned abaut relink binaries...

I had to install it as it was specyfic recommendation.

[Marcin_9]

Yes it was specific issue for us...

[Jean-Luc Oudart]

Is this for XDB ?
default prot=8080
Is there any other application using this port at the moment ?

also, could you try change this default port to somethingelse ?

Regards
Jean-Luc

[Marcin_9]

1.yes this is for xdb.
2. No no other application uses this port
3. it seems as it doesn't start for some reason :(

[Steven E. Protter]

lets see the log from the startup script for oracle.

My first response whenever an oracle app gives me a headache is to relink. It solves the problem about half the time.

Make sure also the oracle binary filesystem is not too full.

SEP

[Marcin_9]

Hi. there is nothing in alertlog for oracle related to this.
Before there were Listening on: ...... (PORT=8080))....
Listening on: .... (PORT=2100)).......
in listener.log
and now there is nothing abaut 8080

[Scott Minter]

Have you tried running:
lsnrctl status

What port does it show it is listening on?

[Jean-Luc Oudart]

Hi Marcin,

have you made changes to the init.ora file for this database ?
Do you have in init.ora file :
dispatchers="(PROTOCOL=TCP) (SERVICE=odmdbXDB)"
(odmdb is your database name)

Regards
Jean-Luc