Home » Infrastructure » Windows » Oracle Version Mismatch ? (Oracle 10g database, 10.2.0.4.0 , Windows 7 64 bit)
Oracle Version Mismatch ? [message #514103] Fri, 01 July 2011 08:41 Go to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Hi,

I have installed oracle 10g version 10.2.0.4.0 on Windows 7 64 bit from the following link.

http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html

After login to SQL* plus, when i see the version, it shows as 10.2.0.3.0. Is this correct?.

If not, please let us know, why it was so?.

Thanks and Regards,
Ramesh V

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514115 is a reply to message #514103] Fri, 01 July 2011 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
execute "select * from v$version;" and copy and paste it in the post as TEXT no image.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514119 is a reply to message #514115] Fri, 01 July 2011 12:21 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Michel,

Please find the requested.

19:02:27 SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

Thanks and Regards,
Ramesh V

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514127 is a reply to message #514119] Fri, 01 July 2011 13:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the result of "def".

Regards
Michel

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514155 is a reply to message #514127] Fri, 01 July 2011 22:18 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Michel,

Since i have installed oracle in my office, Will check and let you know.

Thanks and Regards,
Ramesh

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514327 is a reply to message #514155] Mon, 04 July 2011 01:32 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Michel,

11:44:48 SQL> def
DEFINE _DATE = "04-JUL-11" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR)
DEFINE _USER = "RAMESH" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000300" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE = "1002000300" (CHAR)
Thanks and Regards,
Ramesh V

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514329 is a reply to message #514327] Mon, 04 July 2011 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So, in the end, we can see you have a 10.2.0.3 unless there is a bug in the version of the package.

Regards
Michel

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514330 is a reply to message #514329] Mon, 04 July 2011 01:53 Go to previous messageGo to next message
atgramesh
Messages: 23
Registered: January 2011
Junior Member
Hi,

Ok. Thanks. Did you/anyone have any experience in this installation ?.

Thanks and Regards,
Ramesh V

Report message to a moderator

Re: Oracle Version Mismatch ? [message #514337 is a reply to message #514330] Mon, 04 July 2011 02:28 Go to previous message
Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No on this specific one but it does not change of any other one.

Regards
Michel

Report message to a moderator

Previous Topic: pls help to reduce the manual activity
Next Topic: Data from Oracle to Microsoft Word
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 22 17:48:45 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.