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

#1 (**permalink**) 02-25-2008, 02:44 AM

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

#2 (**permalink**) 02-25-2008, 02:44 AM

sonyav2@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode