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

michel.kowalczyk_at_gmail.com wrote in
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
>
>
>
> 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. Received on Sat Oct 29 2005 - 21:16:49 CDT