Home » RDBMS Server » Server Administration » How to install oracle 10g software in a windows platform server
How to install oracle 10g software in a windows platform server [message #352469] Tue, 07 October 2008 21:35 Go to next message
tons@orafaq
Messages: 2
Registered: June 2008
Junior Member
Hi!

I installed oracle 10g software in windows server 2003 with an existing oracle 9i database but different oracle homes. The current oracle_home for 9i is 'c:\oracle\ora920' while for 10g its 'c:\oracle\product\10.2.0'. Unfortunately,
the oracle 9i database was affected wherein I can't connect to 9i database. Due to tns can't resolve error something. let's say, when I tried to connect in 9i database using sql plus. It uses the version of 10g sqlplus. I was to supposed to create 10g database without affecting 9i database.

Are there any ways how to do this without affecting the performance of the other database?
Re: How to install oracle 10g software in a windows platform server [message #353097 is a reply to message #352469] Sat, 11 October 2008 06:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

before connect to oracle 9i set ORACLE_HOME/ORACLE_SID/PATH variable

then you can able to use oracle 9i sqlplus.
Re: How to install oracle 10g software in a windows platform server [message #353429 is a reply to message #353097] Mon, 13 October 2008 20:00 Go to previous messageGo to next message
tons@orafaq
Messages: 2
Registered: June 2008
Junior Member
Hello,

Thanks for the advise.
Re: How to install oracle 10g software in a windows platform server [message #353546 is a reply to message #353429] Tue, 14 October 2008 02:48 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
Still if you face errors, check whether the proper listener has been started
Previous Topic: sppurge.sql keeps generating archives in spite of killing the process
Next Topic: AWR - oracle 10g is not running.. please help (2 threads merged by bb)
Goto Forum:
  


Current Time: Fri Nov 29 17:31:15 CST 2024