Home » SQL & PL/SQL » Client Tools » why is sqlplus -v different from select * from v$version ( EE, SLES SP3 (i586))
why is sqlplus -v different from select * from v$version [message #633102] Tue, 10 February 2015 23:48 Go to next message
Messages: 250
Registered: April 2014
Senior Member

path is as shown below
echo $PATH

all versions of sqlplus is as follow:
oracle@vmlinux:/u01/app/oracle/product/10.2.0/db_1/bin $ which -a sqlplus

when I try to invoke sqlplus from 10.2.1

oracle@vmlinux:/u01/app/oracle/product/10.2.0/db_1/bin $ ./sqlplus -v
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

invoking sqlplus from 11.2.0 home,

oracle@vmlinux:/u01/app/oracle/oracle/product/11.2.0/dbhome_1/bin $ which sqlplus

oracle@vmlinux:/u01/app/oracle/oracle/product/11.2.0/dbhome_1/bin $ ./sqlplus -v

SQL*Plus: Release - Production

when I login to db to found out the version:

SYS@o102>select * from v$version;

Oracle Database 11g Enterprise Edition Release - Production
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production

SYS@o102>SELECT name, value, issys_modifiable FROM v$parameter WHERE name='compatible';


why is sqlplus -v different from v$version?

the nearest forum threat I get is https://community.oracle.com/thread/2541899 but that is not applicable in my case.


[Edit MC: fix url]

[Updated on: Wed, 11 February 2015 01:20] by Moderator

Report message to a moderator

Re: why is sqlplus -v different from select * from v$version [message #633105 is a reply to message #633102] Wed, 11 February 2015 00:54 Go to previous message
Michel Cadot
Messages: 67880
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"select * from v$version;" gives the database version.
"sqlplus -v" gives the client version.

Previous Topic: SQL Developer connection issues.
Next Topic: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0
Goto Forum:

Current Time: Sun Jun 13 11:47:53 CDT 2021