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

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

.

Relevant Pages

  • Re: 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 ... > Oracle Homes in the registers but only one visible to the Home ...
    (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)