Home » Other » General » Oracle version (Oracle , 11g,unix)
Oracle version [message #518015] Sun, 31 July 2011 09:23 Go to next message
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?

Re: Oracle version [message #518016 is a reply to message #518015] Sun, 31 July 2011 09:26 Go to previous messageGo to next message
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.
Re: Oracle version [message #518017 is a reply to message #518016] Sun, 31 July 2011 09:32 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Quote:
$ id
uid=2800(bala) gid=102(smith)



Is this what you were looking for ?

Re: Oracle version [message #518019 is a reply to message #518017] Sun, 31 July 2011 10:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you are using V10 software on Windows client to access V11 DB on HPUX
Re: Oracle version [message #518020 is a reply to message #518017] Sun, 31 July 2011 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is this what you were looking for ?

"env | sort" is missing but it obvious you have 2 home with 2 different versions a client in 10.2 and a server in 11.1.

Regards
Michel

Re: Oracle version [message #518021 is a reply to message #518020] Sun, 31 July 2011 11:10 Go to previous message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Thats correct.Now it is clear for me. Thank you for your answers.

[Updated on: Sun, 31 July 2011 11:10]

Report message to a moderator

Previous Topic: informatica project
Next Topic: Oracle link Firebird
Goto Forum:
  


Current Time: Thu Mar 28 09:20:06 CDT 2024