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


<michel.kowalczyk@xxxxxxxxx> wrote in message
news:1130635486.542848.95260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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@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


.

Relevant Pages

  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Compiling and running DBD for Oracle 10g without installing Oracle
    ... I recently had to compile the DBD modules for Oracle 10g on machines, ... perl, DBI etc. of recent enough version ... Oracle 10g installation disk for your architecture (available at ...
    (perl.dbi.users)
  • Asp.net/vb and Oracle
    ... setup on other machines where I have installed the Oracle 9i client, ... Oracle 9.0 odbc drivers will connect to my oracle database when debugging. ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Cannot locate Oracle Home after 10G installation. Getting ORA-12518
    ... phenomenon with the installation of Oracle 10.1 and 10.2 Enterprise. ... TOAD fails to see anything and there is no Home Selector ... Homes in the registers but only one visible to the Home Selector ...
    (comp.databases.oracle.server)
  • RE: Asp.net/vb and Oracle
    ... Oracle Provider for OLE DB components, as well as the orcle Data Provider for ... setup on other machines where I have installed the Oracle 9i client, ... Oracle client and networking components were not found. ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)