unix commands & unix scripts @ coolcommands.com - the search engine for unix sysadmins

LVOware PRATTICO Consulting

Sunday May 27, 2012

Who's Online

Newest Member
beyondimagem

Hit Counter

9133552 Visitors

cool Statistics

Category Search coolcommands.com

Select Category:

	Submitted by: lvo
coolcommand how to find which version of Oracle you have
Description How do I check the Oracle version from the command prompt: Enter in sqlplus (you'll see the version number) # su - oracle oracle# sqlplus OR Version information is stored in a table called v$version. In this table you can find version information on Oracle, PL/SQL, etc. To retrieve the version information for Oracle, you execute the following SQL statement: select * from v$version where banner like 'Oracle%'; It should return something like this: Banner -------------------------------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
Example select * from v$version where banner like 'Oracle%';

Random coolcommands

coolcommand: restvg - how to retsore a user volume group in IBM AIX
Example: restvg -q -f /mydata/myvg
[show me the details]

coolcommand: how to turn off color syntax highlighting in vi
Example: :syntax off
[show me the details]

coolcommand: how to increase the queue_depth on a hdisk in IBM AIX
Example: chdev -l hdisk2 -a queue_depth=8 -P
[show me the details]

coolcommand: lscfg - microcode firmware level on IBM RS/6000
Example: lscfg -pv | grep alte
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts