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

michel.kowalczyk@xxxxxxxxx wrote in
news:1130635486.542848.95260@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

> 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
>
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
> inst_loc REG_SZ C:\Program
> Files\Oracle\Inventory ORACLE_SID REG_SZ
> ARDB ORA_CRS_HOME REG_SZ
> C:\oracle\product\10.1.0\db_3 ORACLE_HOME
> REG_SZ C:\oracle\ora9.2.0 ORACLE_HOME_NAME
> REG_SZ OraDb9i_home API REG_SZ
> C:\oracle\ora9.2.0\dbs ORACLE_GROUP_NAME
> REG_SZ Oracle - OraDb9i_home NLS_LANG
> REG_SZ NA
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES
> HOME_COUNTER REG_SZ 1
> DEFAULT_HOME REG_SZ OraDb9i_home
> LAST_HOME REG_SZ 0
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0
> NAME REG_SZ OraDb9i_home
> PATH REG_SZ C:\oracle\ora9.2.0
> NLS_LANG REG_SZ NA
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
> ID REG_SZ 0
> ORACLE_GROUP_NAME REG_SZ Oracle -
> OraDb9i_home ORACLE_HOME_NAME REG_SZ
> OraDb9i_home ORACLE_HOME REG_SZ
> C:\oracle\ora9.2.0 NLS_LANG REG_SZ
> ENGLISH_AMERICA.WE8ISO8859P1 ORACLE_BUNDLE_NAME
> REG_SZ Enterprise ORACLE_SID REG_SZ
> orcl ORACLE_HOME_KEY REG_SZ
> Software\ORACLE\HOME0 ORACLE_BASE REG_SZ
> C:\oracle SQLPATH REG_SZ
> C:\oracle\ora9.2.0\dbs MSHELP_TOOLS REG_SZ
> C:\oracle\ora9.2.0\MSHELP RDBMS_CONTROL
> REG_SZ C:\oracle\ora9.2.0\DATABASE RDBMS_ARCHIVE
> REG_SZ
> C:\oracle\ora9.2.0\DATABASE\ARCHIVE
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\HTTP_Server
> Path REG_SZ
> C:\oracle\ora9.2.0\bin;C:\oracle\ora9.2.0\Apache\Perl\5.00503
> \bin\mswin32-x86;C:\oracle\ora9.2.0\Apache\fastcgi
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home
> ORACLE_HOME REG_SZ
> C:\oracle\ora10.2.0.1 ORACLE_HOME_NAME REG_SZ
> OraDb10g_home1 ORACLE_GROUP_NAME REG_SZ
> Oracle - OraDb10g_home1 NLS_LANG REG_SZ
> ENGLISH_AMERICA.WE8ISO8859P1 ORACLE_BUNDLE_NAME
> REG_SZ Enterprise OLEDB REG_SZ
> C:\oracle\ora10.2.0.1\oledb\mesg StmtCacheSize
> REG_SZ 0 StatementCacheSize REG_SZ
> 0 ORACLE_SID REG_SZ ARDB
> OO4O REG_SZ
> C:\oracle\ora10.2.0.1\oo4o\mesg SQLPATH
> REG_SZ C:\oracle\ora10.2.0.1\dbs ORACLE_HOME_KEY
> REG_SZ
> SOFTWARE\ORACLE\KEY_OraDb10g_home1 MSHELP_TOOLS
> REG_SZ C:\oracle\ora10.2.0.1\MSHELP ORACLE_BASE
> REG_SZ C:\oracle RDBMS_CONTROL
> REG_SZ C:\oracle\ora10.2.0.1\DATABASE
> RDBMS_ARCHIVE REG_SZ
> C:\oracle\ora10.2.0.1\DATABASE\ARCHIVE ORA_ARDB_AUTOSTART
> REG_EXPAND_SZ TRUE ORA_ARDB_SHUTDOWN
> REG_EXPAND_SZ TRUE ORA_ARDB_SHUTDOWNTYPE
> REG_EXPAND_SZ immediate ORA_ARDB_SHUTDOWN_TIMEOUT
> REG_EXPAND_SZ 90
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
> TraceFileName REG_SZ C:\ODPNET.trc
> TraceLevel REG_SZ 0
> TraceOption REG_SZ 0
> StatementCacheSize REG_SZ 0
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OLEDB
> CacheType REG_SZ Memory
> ChunkSize REG_SZ 100
> DistribTX REG_SZ 1
> FetchSize REG_SZ 100
> OSAuthent REG_SZ 0
> PLSQLRset REG_SZ 0
> PwdChgDlg REG_SZ 1
> SchRstLng REG_SZ 10000
> UserDefFn REG_SZ 0
> DisableRetClause REG_SZ 1
> VCharNull REG_SZ 1
> TraceCategory REG_SZ 0
> TraceFileName REG_SZ c:\OraOLEDB.trc
> TraceLevel REG_SZ 0
> TraceOption REG_SZ 0
> SPPrmDefVal REG_SZ 0
> StmtCacheSize REG_SZ 0
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
> CacheBlocks REG_SZ 20
> FetchLimit REG_SZ 100
> FetchSize REG_SZ 4096
> HelpFile REG_SZ
> C:\oracle\ora10.2.0.1\oo4o\doc\oracleo.hlp PerBlock
> REG_SZ 16 SliceSize REG_SZ
> 256 TempFileDirectory REG_SZ c:\temp
> OO4O_HOME REG_SZ
> C:\oracle\ora10.2.0.1\oo4o
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home2
> ORACLE_HOME REG_SZ
> C:\oracle\product\10.2.0\db_2 ORACLE_HOME_NAME
> REG_SZ OraDb10g_home2 ORACLE_GROUP_NAME
> REG_SZ Oracle - OraDb10g_home2 NLS_LANG
> REG_SZ ENGLISH_AMERICA.WE8ISO8859P1
> ORACLE_BUNDLE_NAME REG_SZ Enterprise
> OLEDB REG_SZ
> C:\oracle\product\10.2.0\db_2\oledb\mesg StmtCacheSize
> REG_SZ 0 StatementCacheSize REG_SZ
> 0 OO4O REG_SZ
> C:\oracle\product\10.2.0\db_2\oo4o\mesg SQLPATH
> REG_SZ C:\oracle\product\10.2.0\db_2\dbs
> ORACLE_HOME_KEY REG_SZ
> SOFTWARE\ORACLE\KEY_OraDb10g_home2 MSHELP_TOOLS
> REG_SZ C:\oracle\product\10.2.0\db_2\MSHELP
> ORACLE_BASE REG_SZ
> C:\oracle\product\10.2.0 RDBMS_CONTROL REG_SZ
> C:\oracle\product\10.2.0\db_2\DATABASE RDBMS_ARCHIVE
> REG_SZ
> C:\oracle\product\10.2.0\db_2\DATABASE\ARCHIVE
>
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home2\ODP.NET
> TraceFileName REG_SZ C:\ODPNET.trc
> TraceLevel REG_SZ 0
> TraceOption REG_SZ 0
> StatementCacheSize REG_SZ 0
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home2\OLEDB
> CacheType REG_SZ Memory
> ChunkSize REG_SZ 100
> DistribTX REG_SZ 1
> FetchSize REG_SZ 100
> OSAuthent REG_SZ 0
> PLSQLRset REG_SZ 0
> PwdChgDlg REG_SZ 1
> SchRstLng REG_SZ 10000
> UserDefFn REG_SZ 0
> DisableRetClause REG_SZ 1
> VCharNull REG_SZ 1
> TraceCategory REG_SZ 0
> TraceFileName REG_SZ c:\OraOLEDB.trc
> TraceLevel REG_SZ 0
> TraceOption REG_SZ 0
> SPPrmDefVal REG_SZ 0
> StmtCacheSize REG_SZ 0
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home2\OO4O
> CacheBlocks REG_SZ 20
> FetchLimit REG_SZ 100
> FetchSize REG_SZ 4096
> HelpFile REG_SZ
> C:\oracle\product\10.2.0\db_2\oo4o\doc\oracleo.hlp
> PerBlock REG_SZ 16
> SliceSize REG_SZ 256
> TempFileDirectory REG_SZ c:\temp
> OO4O_HOME REG_SZ
> C:\oracle\product\10.2.0\db_2\oo4o
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home3
> ORACLE_HOME REG_SZ
> C:\oracle\product\10.1.0\db_3 ORACLE_HOME_NAME
> REG_SZ OraDb10g_home3 ORACLE_GROUP_NAME
> REG_SZ Oracle - OraDb10g_home3 ORACLE_BUNDLE_NAME
> REG_SZ Enterprise NLS_LANG
> REG_SZ ENGLISH_AMERICA.WE8ISO8859P1 SQLPATH
> REG_SZ C:\oracle\product\10.1.0\db_3\dbs
> ORACLE_HOME_KEY REG_SZ
> SOFTWARE\ORACLE\KEY_OraDb10g_home3 ORACLE_BASE
> REG_SZ C:\oracle\product\10.1.0 MSHELP_TOOLS
> REG_SZ C:\oracle\product\10.1.0\db_3\MSHELP
> RDBMS_CONTROL REG_SZ
> C:\oracle\product\10.1.0\db_3\DATABASE RDBMS_ARCHIVE
> REG_SZ
> C:\oracle\product\10.1.0\db_3\DATABASE\ARCHIVE
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Ocr
> ocrconfig_loc REG_SZ
> C:\oracle\product\10.1.0\db_3\cdata\localhost\local.ocr
> Local_Only REG_SZ TRUE
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SCR
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDBConsoleARDB
> EMDROOT REG_SZ
> C:\oracle\ora10.2.0.1 ORACLE_HOME REG_SZ
> C:\oracle\ora10.2.0.1 EMSTATE REG_SZ
> C:\oracle\ora10.2.0.1\COMPUTERNAME_ARDB CONSOLE_CFG
> REG_SZ dbconsole ORACLE_SID
> REG_SZ ARDB TIMEOUT REG_SZ
> 15 TRACE_LEVEL REG_SZ 16
>

> Why 10G won't work on my computer ??

PEBKAC

http://tahiti.oracle.com contains the installation Guides.

http://asktom.oracle.com contains many free clues.
.

Relevant Pages

  • 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)
  • 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)
  • 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)