Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12541 when connecting to Oracle10 on a (vmware host) fc2 linux

Re: ORA-12541 when connecting to Oracle10 on a (vmware host) fc2 linux

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 07 Feb 2005 09:24:15 +0100
Message-ID: <cu78g7$mse$2@news1.zwoll1.ov.home.nl>


Rock Theriault wrote:
> hi @ all
>
> within my studies i've got to "play" with databases. so i set up a
> oracle 10g server.
>
> operating system is a fedora core 2 linux (as vmware guest on a
> windows 2000 host). all my boxes are connected through a zyxel
> prestige 324 router. vmware uses bridged networking.
>
> oracle installation worked well.
>
> i set up a listener on port 1521 and started the database. i'm able to
> log into the database with sqlplus from the server succesfully.
> tnsping from the server
> also says that the listener works well.
>
> now my problem: if i try to connect to the database from everywhere
> else i get a ORA-12541 NO LISTENER error. i don't know why.
>
> i did a portscan with nmap of the server box: a) from the server with
> the result that port 1521/tcp oracle is open. b) from anywhere else
> with the result that port 1521 is closed.
>
> i checked the listener.ora and tnsnames.ora and sql.ora a view times.
> i think they are correct. linux iptables are stopped.
>
> i've got no idea anymore. i'm not sure if i only don't see the wood
> for the trees.
>
> hope anyone has an idea ...
>
> thanks uwe

try to ping your DC2 installation first. If that succeeds, it's time to configure your oracle network, using the netca utility on FC2.

-- 
Regards,
Frank van Bortel
Received on Mon Feb 07 2005 - 02:24:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US