| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10g on Win32
Win2K Pro, 8i R3, 9iR1, 9ir2, and 10g.
I've been struggling with some of these issues, and have things working. When I installed, 9.2 listener was running and TNS_ADMIN was pointing to the 9.2 network\admin directory. Here I was manually tweaking listener.ora and tnsnames.ora in the 10g network\admin directory. After setting TNS_ADMIN to the 10G directory, everything is fine. I use IPC for everything, and with the 10G listener I can connect to all 4 versions of the databases. But, I can't connect to 8.1.7.0.0 using the 10G version of SQL*Plus -- I get the error message you refer to. I think I remember someone saying that it could connect to the latest release of 8.1.7.
Trickier was OEM. In the emoms.properties file was a connect string, fully
qualifying everything -- e.g.
"oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\
=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=LARRY)(PORT\=1521)))(CONNECT_DATA\=(SERVICE
_NAME \=O10G)))". I finally just yanked it out altogether. One issue that
I'm working on is that with the listener.ora and tnsnames.ora only
specifying IPC I could not connect through OEM (I tweaked the connect string
above to an IPC type of connect, as well as numerous changes in the
listener.ora and tnsnames.ora files, no luck). I had to go ahead and
configure a TCP/IP listener location, and create a tcp/ip entry in addition
to the IPC entry in the tnsnames.ora file. In fact, I had a draft email
ready to send asking if anyone knows if you have to have a tcp/ip based
entries to use OEM. That's the only way I've been able to get it to work.
And I was up all night working on it. I'm still going through other
configuration files, docs, etc to try to get the answer.
Regards,
Larry G. Elkins
elkinsl_at_flash.net
214.954.1781
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Justin Cave (DDBC)
Sent: Thursday, March 25, 2004 12:35 PM
To: oracle-l_at_freelists.org
Subject: RE: 10g on Win32
The lack of an entry in the Oracle Home Selector is certainly an issue.
On both the systems I installed, the new 10g Enterprise Manager complains that the "database status is unavailable", so EM won't allow me to do anything other than start & stop the database. The 10g listener also seems to have problems with the 8.1.7 and/or 9.2 databases on my development system, though I haven't spent a lot of time dealing with this particular issue.
I also noticed that if I tried to connect to an 8.1.7 system from a 10g client, it complains about an unsupported connection type-- I believe it's the same error you get if you try to connect a 9.2 client to an Oracle 7 system. I thought that 10g -> 8.1.7 was supported, though.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jared.Still_at_radisys.com
Sent: Thursday, March 25, 2004 11:04 AM
To: oracle-l_at_freelists.org
Subject: 10g on Win32
Just wondering what others experiences are installing this version.
Did you perhaps find that there is no new version of the Oracle Home Selector?
And that even if you hack the registry so that the old OHS can find the new Oracle 10g registry entries, it still does not set the PATH correctly?
There are at least 2 OH path entries now for 10g. The standard OH/bin and now the OH/jre/bin. OHS does not correctly alter the PATH by moving both entries to the front of the list.
I say 'at least two' because during installation it occurred that the PATH
on
my laptop would exceed 1023 characters and I chose to ignore the error.
Perhaps a re-install would fix this.
sigh... silly me. I thought the days of worrying about PATH size were over.
Jared
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Thu Mar 25 2004 - 14:21:25 CST
-----------------------------------------------------------------
 |
 |