Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cannot locate Oracle Home after 10G installation. Getting ORA-12518

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

From: <michel.kowalczyk_at_gmail.com>
Date: 29 Oct 2005 18:24:46 -0700
Message-ID: <1130635486.542848.95260@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


Received on Sat Oct 29 2005 - 20:24:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US