Home » Other » General » Selection of particular DB (oracle 10.1.0.2.0 - windows)
Selection of particular DB [message #477044] Tue, 28 September 2010 02:33 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi,

I have oracle 9 and 10g. When I select particular Database, it is not detecting the correct one.

Set oracle_sid=orcl
Sqlplus /nolog
SQL*plus: Release 9.2.0.1.0- production ......

But the Database ORCL is not in 9i, it is in 10g.

please help me to get a correct Database name.

Thanks a lot
Re: Selection of particular DB [message #477048 is a reply to message #477044] Tue, 28 September 2010 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you now choose to use 10.1 which an unsupported version? Choose 10.2 or better 11.2!

Also set ORACLE_HOME or install a listener and use net connection.

Regards
Michel
Re: Selection of particular DB [message #477049 is a reply to message #477048] Tue, 28 September 2010 02:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your SQL*Plus is 9i, you must query v$version to see the release of the database. To see the database name, query v$database.
Re: Selection of particular DB [message #477050 is a reply to message #477049] Tue, 28 September 2010 03:04 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi,

Thanks for your answers.

1) As 11G is only supports in WINDOWS 7. I'm not able to have them.

2) Yes with the command V$version , it shows the correct Database version name (10g).
But why SQL*plus took 9i instead of 10g?
please tell me the reason for it....
And the solution for this.

Thanks
Re: Selection of particular DB [message #477052 is a reply to message #477050] Tue, 28 September 2010 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Still don't understand what you say. Waht does this mean? You are in Windows 7 but can't download 11g or you are not in Windows 7 and so it is useless (from your understanding) to download 11g?

2) Read my previous answer and add PATH to it.

Regards
Michel
Re: Selection of particular DB [message #477056 is a reply to message #477052] Tue, 28 September 2010 03:31 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
May I try?
muktha_22
But why SQL*plus took 9i instead of 10g?

This is because 9i's SQL*Plus' directory is - in the PATH environment variable - placed before 10g's SQL*Plus' directory. So, either use its full path, for example:
C:\> C:\Oracle\product\10.2.0\client_1\BIN\sqlplus scott/tiger@ora10
     --------------------------------------
(I underlined the path) or modify the PATH environment variable and place 10g in front of 9i, or create a desktop icon(s) which will start version you want.

[Updated on: Tue, 28 September 2010 03:32]

Report message to a moderator

Re: Selection of particular DB [message #477064 is a reply to message #477052] Tue, 28 September 2010 04:54 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Thanks for your opinion.

But, As I had mentioned i'm using 9 and 10g. Which means in windows XP (Because it is not supports with windows 7).

Thanks
Re: Selection of particular DB [message #477065 is a reply to message #477064] Tue, 28 September 2010 05:00 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You do realise that 11g was released long before windows 7 so there is no way it is only supported on windows 7?
Re: Selection of particular DB [message #477068 is a reply to message #477065] Tue, 28 September 2010 05:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Me again ...

I *think* that the OP says that he uses MS Windows XP as operating system. According to that fact, he installed Oracle 9i and 10g.

If he had MS Windows 7, he would have to install Oracle 11g because combinations of older Oracle versions and MS Windows 7 aren't certified.


But, why all the discussion, Windows this and Oracle that? The question was why, when he executes SQLPLUS.EXE at the command prompt, SQL*Plus 9i is used and not 10g one. Because, well, PATH and stuff.
Re: Selection of particular DB [message #477253 is a reply to message #477068] Wed, 29 September 2010 14:20 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Thanks a lot
Re: Selection of particular DB [message #477254 is a reply to message #477253] Wed, 29 September 2010 14:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe but you didn't answer to my questions:

Quote:
1) Still don't understand what you say. Waht does this mean? You are in Windows 7 but can't download 11g or you are not in Windows 7 and so it is useless (from your understanding) to download 11g?

If you don't do it, I wonder why I should answer your future ones.
Show a little respect towards us and do not just send an "End of Topic" signal.

Regards
Michel

[Updated on: Wed, 29 September 2010 14:24]

Report message to a moderator

Re: Selection of particular DB [message #477263 is a reply to message #477254] Wed, 29 September 2010 16:06 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

You suggested me to use 11G.

But i'm using Windows XP. Which can't have get 11G installed (I tried also)

Thanks for your cares.
Re: Selection of particular DB [message #477286 is a reply to message #477263] Wed, 29 September 2010 23:39 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can have 11g on Windows.
On my laptop with XP SP3 Professional Edition, I have 8.1.7, 9.2, 10.2, 11.1 and 11.2, no problem (or almost I have some disconnections after some idle time on socket but there is a XP patch I never tested).
Use "Microsoft Windows (32-bit)" download.

Regards
Michel

[Updated on: Wed, 29 September 2010 23:41]

Report message to a moderator

Previous Topic: Oracle Licensing Issue
Next Topic: Creating PFILE from SPFILE.
Goto Forum:
  


Current Time: Fri Mar 29 09:20:12 CDT 2024