| 9i and 10g on single machine?? [message #260551] |
Mon, 20 August 2007 05:09  |
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
|
Member |
|
|
Hi,
I am trying to install oracle 9i and oracle 10g on a Windows 2k server.This is a test environment only.
I have installed both oracle home on different drives.
I have installed both 9i and 10g databases
I checked 10g database is started
But trying to start 9i databse,the instance starts and then
SQL> startup pfile='C:\oracle\product\9.2.0\database\orcl92pfile.ora';
ORA-25138: HASH_JOIN_ENABLED initialization parameter has been made obsolete
ORACLE instance started.
Total System Global Area 121634816 bytes
Fixed Size 1247636 bytes
Variable Size 92276332 bytes
Database Buffers 25165824 bytes
Redo Buffers 2945024 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Pls give me your suggetion.How to have 2 diffrent versions in same machine
Regards
Ram
|
|
|
|
|
|
|
|
|
|
| Re: 9i and 10g on single machine?? [message #260662 is a reply to message #260551] |
Mon, 20 August 2007 11:26  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Since I am not that used to Oracle on Windows, I will just brush on this.
When you have multiple versions of Oracle installed in the same machine, you have to make sure the environment is set correctly.
In UNIX, I would check the ORACLES_SID & ORACLE_HOME before I try to fire up the databases.
When firing 9 db
ORACLE_SID = SID
ORACLE_HOME = ?/9.2.0
When firing 10 db
ORACLE_SID = SID
ORACLE_HOME = ?/10.2.0/db_1
|
|
|
|
|
|
| Re: 9i and 10g on single machine?? [message #260950 is a reply to message #260551] |
Tue, 21 August 2007 05:41 |
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
|
Member |
|
|
Hi,
Still i am facing the issue
1. I installed both 9i and 10g in different homes and different drives
2. The PATH,ORACLE_HOME and ORACLE_SID was given separately from cmd line
Please help
Ram
|
|
|
|
|
|
|
|
| Re: 9i and 10g on single machine?? [message #261546 is a reply to message #260551] |
Thu, 23 August 2007 00:45 |
ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka
|
Member |
|
|
Hi,
I managed to install both the databases.But there appears to be some conflict with the listeners.The database control in 10g is pointing to 9i listener and is not opening.
I checked in services(control panel) both 9i and 10g listener s up.
How to resolve the conflict?
How to redirect different clients to use 9i and 10g?
Can u suggest something
Regards
Ram
|
|
|
|
|
|
| Re: 9i and 10g on single machine?? [message #261735 is a reply to message #260551] |
Thu, 23 August 2007 08:23 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Let's see how your listener.ora files(s) looks like ??
If you have 2 of them (you should)... post both. And also the relative path of them.
Maybe later on you can merge these 2 files and save them in both locations.
On UNIX, I save it in a different location (/var/opt/oracle) and have soft link from 2 different location (ORACLE_HOME9/network/admin and ORACLE_HOME10/network/admin). Well that is UNIX so let's leave it there. The listener.ora is a merged file for both environment (9i and 10g).
Rule of thumb, use the 10g executable and path for 10g database and use 9i executable and path for 9i database.
Later.
--
Sanjay B.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
