| Selection of particular DB [message #477044] |
Tue, 28 September 2010 02:33  |
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 #477050 is a reply to message #477049] |
Tue, 28 September 2010 03:04  |
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 #477056 is a reply to message #477052] |
Tue, 28 September 2010 03:31 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
May I try?
muktha_22But 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
--------------------------------------
[Updated on: Tue, 28 September 2010 03:32] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Selection of particular DB [message #477068 is a reply to message #477065] |
Tue, 28 September 2010 05:13 |
|
Littlefoot
Messages: 21823
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 #477254 is a reply to message #477253] |
Wed, 29 September 2010 14:22 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 #477286 is a reply to message #477263] |
Wed, 29 September 2010 23:39 |
|
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
