oracle database fit in server 2003

[9iguy]

Does anybody knows if oracle database can be installed in a server 2003 Operative System, I would like to migrate my OS 2000 server to 2003 server but I don´t know if I going to have any problems with my database connection or something like that.

I´m waiting for your help guys,

if it`s rightway would be great...

thanks.

 

[alexhu]

Yes - 9.2 only

Alex

 

[9iguy]

thanks alexhu.

I asked this, because I´ve just installed it (2003 and oracle 9i rel 2, and all the instalation ended succesfully, but when I create the tnsname.ora in a client with the "sqlnet easy config" tool, it seem like it connect perfectly to the database but suddenly it gives me a ora-12203 error, and it last about 15 min or more like that, and it happens with no reason. I thought that it could be an imcopatibility of Oracle with this new OS.

if you know why this could be happening, it would be very helpful.

thank.

 

[alexhu]

Is the listener running ?

Can you tnsping the database ?

Alex

 

[9iguy]

yes it`s runnig and sometimes I can tnsping but sometimes cannnot.

It seem to hang but the tells me:

tns-12535: TNS: operation time out

 

[9iguy]

yes it`s runnig and sometimes I can tnsping but sometimes cannnot.

It seem to hang (the tnsping) but then tells me:

tns-12535: TNS: operation time out.

is there a way to fix this?

 

[Turkbear]

Hi,
In general that type of error indicates that some
network problem is stopping communication between your client and the host server sometimes;since it works sometimes your configuration is probably OK..

TNS-12203 TNS:unable to connect to destination

Cause: Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.

Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.

Try a standard ping to the Database server to see if it is a Network and not an Oracle-related problem..

 

[9iguy]

thanks

I changed the name of the database server to the IP address and it is working well so far.

It seem there is another machine with the same name of the server in the network.

thank again