RE: 10g on Win32
- From: "Larry Elkins" <elkinsl@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 13:39:07 -0600
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@xxxxxxxxx
214.954.1781
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Justin Cave (DDBC)
Sent: Thursday, March 25, 2004 12:35 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jared.Still@xxxxxxxxxxx
Sent: Thursday, March 25, 2004 11:04 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
