Wednesday, August 14, 2019

How to find Oracle Database and Oracle WebLogic Server Version?

There are several ways to find Oracle Database and Oracle WebLogic Version

Oracle Database
1. Select v$instance for only Database version

SQL> select version from V$INSTANCE;

2. Select v$version table in database

SQL> Select * from v$version;
Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version – Production

Identifying Your Oracle Database Software Release

·         10 is the major database release number
·         1 is the database maintenence release number
·         0 is the application server release number
·         1 is the component-specific release number
·         0 is the platform-specific release number

3.  Search for “Enterprise Edition” in alert_SID.log file
$cat alert_ORCL.log |grep "Enterprise Edition"
Oracle Database 11g Enterprise Edition Release - 64bit Production

Oracle Weblogic:

1.Find WebLoic version from WebLogic Jar file using below command

For ex:-
$cd /u01/home/ wls1211/wlserver_12.1/server/lib/
java -cp weblogic.jar weblogic.version

2. Check registry.xml under $MW_HOME and search for earch for “component name=”WebLogic Server””

For ex: cat /u01/home/ wls1211/registry.xml | grep 'component name="WebLogic Server"'
<component name="WebLogic Server" version="" InstallDir="/u01/home/oracle/Agile/wls1211/wlserver_12.1">

3. You can also find version by searching “WebLogic Server” in WebLogic Admin server logfile

Satishbabu Gunukula, Oracle ACE


  1. This comment has been removed by a blog administrator.

  2. About NCERT Psychology is the science of behavior and mind, including conscious and unconscious phenomena, as well as feeling and thought. NCERT 12th ClassPsychology Book Students NCERT Psychology Book in Class XII Provide in Your Collages, Every Year Government Collages free Distortion in Subject Wise new Textbooks for Students,But Any Problem Books not Available in Collage Don’t Worry,NCERT Class XII Text books for Accountancy,Biology,BusinessStudies,Chemistry,Economics,English,Geography,Hindi,History,Mathematics,Physics,PoliticalScience,Psychology,Sanskrit,Sociology,Urdu etc.

  3. Thank you very much for writing such an interesting article on this topic. This has really made me think and I hope to read more. Can you write somethins about crystal shops?