Re: Cannot locate Oracle Home after 10G installation. Getting ORA-12518

<michel.kowalczyk_at_gmail.com> wrote in message news:1130635486.542848.95260_at_z14g2000cwz.googlegroups.com...
> Hi,
>
> I am running Windows XP SP1 With DHCP. And I had the following
> phenomenon with the installation of Oracle 10.1 and 10.2 Enterprise.
>
> On my laptop that already has Oracle 9.2 db, I installed 10.2.0.1
> without any errors. Only to be surprised with the following problem:
>
> 1) When I log in using sqlplus "/ as sysdba" then it logs on correctly
> to the newly created database in 10G.
>
> 2) If I use sqlplus username/password_at_database_name then it fails with
> the error
> ORA-12518: TNS:listener could not hand off.
>
> 3) When I open the Home Selector, Oracle only sees the 9.2 home
>
> 4) TOAD also sees only one home.
>
> I uninstalled 9.2 and 10G. Cleaned registers and all Oracle folders,
> and started a fresh install of 10.2 only. When I finished I got the
> same result. TOAD fails to see anything and there is no Home Selector
> since there is only one home.
>
> After some more investigation, I decided to install 10.0.1 and see if
> this version works. I double checked the home location, options etc..
> but the results were the same. So I went for the 9.2 installation, with
> this installation I got the Home Selector but it sees only the 9.2
> Home. Then I installed 10.2.0 a second time ending me up with 4 Oracle
> Homes in the registers but only one ( 9i) visible to the Home Selector
> and TOAD fails also to see all 10G Homes. I have posted the fragment
> related to Oracle DBs of my registers also.
>
> Why 10G won't work on my computer ??
>
> Thanks in advance
> Michal
>
>

Regarding TOAD : what version do you have ? I had problems with 10g and TOAD versions lower than 8.5, now i'm using 8.5 + Oracle 8i client + Oracle 9i client + Oracle 10g client all on the same workstation (Windows 2000 Professional) but in different Oracle homes of course. TOAD finds all homes and switching between them works fine.

Matthias Received on Sun Oct 30 2005 - 07:22:43 CST