Re: Can an O9.2 client see an O10g DB?

In article <cKGdnahF6PAolsjdRVn-sw_at_adelphia.com>, donoteventrytospamme_at_thisaddress.com says...
> In the Windows version of the the Oracle 9.1 SQL*Plus, the message I get
> when I try to connect to the Linux-based O10g database is:
>
> ORA-12541: TNS:no listener
>
> Over on the Linux box, I can run SQL*Plus with the instance's SID and get in
> without any problem, so the SID info seems OK.
>
> Any thoughts?
>
> Thanks.

I am in the midst of setting up a similar system. The 9i client will basically work with 10g, though I am having a problem connecting through the 9i Windows Enterprise Manager to the 10g DB using anything other than the SYS account. The EM will complain that any user needs SELECT ANY DICTIONARY rights even after that right has been granted.

Anyway, for your immediate problem, you might check to see if the listener is running. Try starting it with "lsnrctl start".

Might want to check out the last section of http://staff.in2.hr/denis/oracle/10g1install_fedora1_en.html Received on Sun Mar 14 2004 - 22:14:34 CST