SEO

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_Serv er
Path REG_SZ C:\oracle\ora9.2.0\bin;C:\oracle\ora9.2.0\Apache\P erl\5.00503\bin\mswin32-x86;C:\oracle\ora9.2.0\Apache\fastcgi

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_ho me
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_ho me1\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_ho me1\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_ho me1\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_ho me2
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_ho me2\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_ho me2\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_ho me2\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_ho me3
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\loca l.ocr
Local_Only REG_SZ TRUE

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SCR
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDB ConsoleARDB
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

(Have to admit I did not look at the complete listing you submitted ...)

First question - is this XP Home or Pro?

Second question - what happens when you stop the 9i Listener and just use
the 10g Listener? (It can handle both database instances.) Remember to
use the right port when doing that check.


--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

michel.kowalczyk@gmail.com wrote in
news:1130635486.542848.95260@z14g2000cwz.googlegro ups.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@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_Serv er
> Path REG_SZ
> C:\oracle\ora9.2.0\bin;C:\oracle\ora9.2.0\Apache\P erl\5.00503
> \bin\mswin32-x86;C:\oracle\ora9.2.0\Apache\fastcgi
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_ho me
> 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_ho me1\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_ho me1\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_ho me1\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_ho me2
> 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_ho me2\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_ho me2\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_ho me2\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_ho me3
> 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\loca l.ocr
> Local_Only REG_SZ TRUE
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SCR
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\SYSMAN\OracleDB ConsoleARDB
> 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.

Was there any reason you could not trim the OPs post?

(Just wondering .... to me it seems kinda silly to have to scroll down 3
pages to find a RTFM-style comment.)

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

Hi again,

1) I use Windows XP Pro SP1

2) Running one listener at a time:

I tried running the 9i db with the 9i listener. All is ok
running the 10g db with the 10g listener. Runs with problems as above
mentioned

I might have confused you with all these versions, but my final aim is
to get one version of 10g version running from TOAD. I don't need the
other versions. That is why I installed the listeners with the default
parameters. I run only one listener at a time because they all operate
on the same port. It was just installed to prove that an older version
works well.



regards
Michal

On Sun, 30 Oct 2005 03:35:19 -0800, michel.kowalczyk amused us by writing:

....
> other versions. That is why I installed the listeners with the default
> parameters. I run only one listener at a time because they all operate
> on the same port. It was just installed to prove that an older version
> works well.
>

You only NEED 1 listener on the server, regardless of the number of
database instances. It is normally configured to handle all database
instances, as the listener will only be involved at the very beginning of
the connection and then will get out of the way after it has told the
client and database instance which port to use for communication.

The higher version listener will handle the lower version database
instance, so running the 10g listener will allow access to the 9i and 10g
database. (This assumes the base config has not been modified to disable
that capability.)

Variations on this, of course, are in the docco.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting guarantees I will not respond further ***

michel.kowalczyk@gmail.com wrote:
> Hi again,
>
> 1) I use Windows XP Pro SP1
>
> 2) Running one listener at a time:
>
> I tried running the 9i db with the 9i listener. All is ok
> running the 10g db with the 10g listener. Runs with problems as above
> mentioned
>
> I might have confused you with all these versions, but my final aim is
> to get one version of 10g version running from TOAD. I don't need the
> other versions. That is why I installed the listeners with the default
> parameters. I run only one listener at a time because they all operate
> on the same port. It was just installed to prove that an older version
> works well.
>
>
>
> regards
> Michal

there are some hint's if you google ORA-12518 dealing with listener,
tnsnames
and network (you wrote you are using dhcp). Maybe you could check that.

regards

s.kapitza

<michel.kowalczyk@gmail.com> wrote in message
news:1130635486.542848.95260@z14g2000cwz.googlegro ups.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@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