Home » RDBMS Server » Server Administration » 9i and 10g on single machine??
9i and 10g on single machine?? [message #260551] Mon, 20 August 2007 05:09 Go to next message
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 #260560 is a reply to message #260551] Mon, 20 August 2007 05:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check your pfile. You would not use same pfile for both databases.
What about if you give simply startup?
Re: 9i and 10g on single machine?? [message #260578 is a reply to message #260551] Mon, 20 August 2007 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How to have 2 diffrent versions in same machine

Use 2 different Oracle homes.
Start each database in his Oracle home.

Regards
Michel
Re: 9i and 10g on single machine?? [message #260643 is a reply to message #260551] Mon, 20 August 2007 10:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

ORA-01092: ORACLE instance terminated. Disconnection forced

check your pfile for undo_tablespace parameter is mention correctly.

Regards
Taj

Re: 9i and 10g on single machine?? [message #260662 is a reply to message #260551] Mon, 20 August 2007 11:26 Go to previous messageGo to next message
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 #260665 is a reply to message #260662] Mon, 20 August 2007 11:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On Windows, first open Services and check Oracle services (OracleService<SID>) properties.
Then, if your database doesn't start automatically with the service, in DOS box, you have the same parameters than in Unix: ORACLE_HOME and ORACLE_SID and PATH.

Regards
Michel
Re: 9i and 10g on single machine?? [message #260950 is a reply to message #260551] Tue, 21 August 2007 05:41 Go to previous messageGo to next message
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 #261028 is a reply to message #260950] Tue, 21 August 2007 09:41 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You still getting the same problem?
Post 100 lines from 9i alertlog database.
Re: 9i and 10g on single machine?? [message #261049 is a reply to message #261028] Tue, 21 August 2007 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not post it on line. Attach it in an ascii (txt) file.

Regards
Michel
Re: 9i and 10g on single machine?? [message #261546 is a reply to message #260551] Thu, 23 August 2007 00:45 Go to previous messageGo to next message
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 #261551 is a reply to message #260551] Thu, 23 August 2007 00:50 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
I have a problem.
Can u suggest something
Re: 9i and 10g on single machine?? [message #261735 is a reply to message #260551] Thu, 23 August 2007 08:23 Go to previous message
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.
Previous Topic: Instance Recovery
Next Topic: Help me for Connect SYSDBA
Goto Forum:
  


Current Time: Sun Dec 11 02:12:16 CST 2016

Total time taken to generate the page: 0.04222 seconds