Re: Please Help, Oracle 10g, TNS-PROTOCOL ADAPTER ERROR

From: <fitzjarrell_at_cox.net>
Date: 20 Jan 2006 10:02:40 -0800
Message-ID: <1137780160.477668.174270@g44g2000cwa.googlegroups.com>

sonyav2_at_yahoo.com wrote:
> i already have oracle 9i on my system and i loaded 10g and get above
> error in sqlplus. something is conflicting. when i set oracle home to
> 9i i get sqlplus in 9i working but when i set the home to 10g i get tns
> protocol adapter error. also tnsping gives no listener.
>
> thanks

It is highly likely your 10g listener failed to start due to your 9i listener using port 1521. Check your listener.ora file for your 10g installation and see if it's configured to use port 1521 (my guess is it will be). Changing this port assignment should get your 10g listener running..

David Fitzjarrell Received on Fri Jan 20 2006 - 12:02:40 CST