Home » Infrastructure » Unix » get DB version
get DB version [message #98606] Thu, 27 January 2005 06:50 Go to next message
CHANDU
Messages: 23
Registered: March 2002
Junior Member
Hi,
I am trying to get the version of oracle which I am using in a differnt way i.e being a super user

root#su - oracle -c "sqlplus -v"

I am not getting the version from this command what is wrong with this?

I also tryed
root#su - oracle -c sqlplus -v

In both the case it complains as ..
-bash: sqlplus: command not found

If I use
root#su - oracle -c "pwd"

it print's
/export/home/oracle
(which is infact home dir of user oracle)

Thanks
Chandu.B.S
Re: get DB version [message #98613 is a reply to message #98606] Mon, 31 January 2005 23:51 Go to previous message
Frank Naude
Messages: 4566
Registered: April 1998
Senior Member
Hi,

"sqlplus" is in the $ORACLE_HOME/bin directory. Specify the full path or set your PATH environment variable.

Best regards.

Frank
Previous Topic: File transfer from unix to windows
Next Topic: How to get number of lines from a file into a shell variable
Goto Forum:
  


Current Time: Sat Jan 16 13:04:05 CST 2021