Operating System - HP-UX
1748169 Members
3979 Online
108758 Solutions
New Discussion юеВ

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

 
Marcin_9
Frequent Advisor

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

Ok. I will check it
Jean-Luc Oudart
Honored Contributor

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

furthermore, if you want to change the default port number for XDB (XML Database)(http is 8080 and ftp is 2100) please refer to Metalink Note:209564.1 : "XDB: Utility package to change the HTTP and FTP ports used by XML DB."

Regards
Jean-Luc
fiat lux
Marcin_9
Frequent Advisor

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

Yes I got it in init.ora file
Jean-Luc Oudart
Honored Contributor

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

Have you tried to stop / re-start your listener and check with lsnrctl status (if you use default listener) ?

Regards
Jean-Luc
fiat lux
Indira Aramandla
Honored Contributor

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

Hi Marcin,

ORACLE XML DATABASE is a a new feature of release 9.2. This new feature includes a HTTP server, which serves port number 8080 by default. This HTTP server registers itself with the listener, after the database has been started and port number 2100 (related to FTP). These components come together.
The entry in inidr.ora dispatchers='(PROTOCOL=TCP) (SERVICE=ORACLE9XDB)'.

And this should be seen in your LSNRCTL STATUS command.

It is possible the change the port numbers 8080 and 2100. You need to log into Enterprise Manager as SYSDBA, bring up the XML database configuration tab and change the http-port to something other than 8080.

As jean mentioned I attached the document that describes how to alter the ports which an XML DB uses for HTTP and FTP


Indira A
Never give up, Keep Trying
Marcin_9
Frequent Advisor

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

I agree with you all... But it doesnt start..., even if I reboot machine and stop/start database and listener
Marcin_9
Frequent Advisor

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

is it crutial?
(SERVICE=ORACLE9XDB)'.
because I got (SERVICE=XDB)'.
Jean-Luc Oudart
Honored Contributor

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

Hi Marcin

as per previous post this must be XDB
what is your dbname ?

Regards
Jean-Luc
fiat lux
Marcin_9
Frequent Advisor

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

Aha!
Marcin_9
Frequent Advisor

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

Thanks ...
The problem was in listener.ora.
There must be additional line
with IP of the server.