Ever wonder to find out the oracle query to find the oracle software version installed on a remote system, Here are the two queries will help you to find the oracle software versions, SELECT * FROM v$version; BANNER Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production "CORE 11.2.0.4.0 Production" TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCT VERSION STATUS NLSRTL 11.2.0.4.0 Production Oracle Database 11g Enterprise Edition 11.2.0.4.0 64bit Production PL/SQL 11.2.0.4.0 Production TN
This blog is fully for system admins and others who are facing issues with their day to day IT life. Which helps you to learn from your mistakes and issues here you can find lot of troubleshooting techniques and other information which helps you to get some idea to fix your issues..