OraFAQ Forum: General » Oracle version

Home » Other » General » Oracle version (Oracle , 11g,unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle version [message #518015]

Sun, 31 July 2011 09:23

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

Hi,

I have a doubt in Oracle database version i am using.

when i give sqlplus bala/pwd@DAM.SBC.COM from windows run prompt, i get

Quote:

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 31 19:42:05 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
-------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for HPUX: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

SQL>

I know` i am using Oracle 11G version but still i have doubt as why i see 10.2.0.1.0 version in sqlplus connection.

Quote:

SQL*Plus: Release 10.2.0.1.0

can somebody clarify this?

Report message to a moderator

Re: Oracle version [message #518016 is a reply to message #518015]

Sun, 31 July 2011 09:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

THANKS following Posting Guidelines!

issue following OS commands

id
env | sort

COPY commands & results then PASTE all back here

PATH environmental variable needs to be adjusted/fixed/corrected.

Report message to a moderator