4 Replies Latest reply: Apr 20, 2013 7:26 AM by KR10822864 RSS

    couple of questions

    950800
      Hello,

      1) How to find whether Oracle Server Software or Oracle client software is installed on the machine?

      2) What is the difference between regular patchset and PSU?

      Thanks a lot for your help in advance
        • 1. Re: couple of questions
          sulimo
          1) see whether oracle binary (oracle.exe if windows), exists
          2) http://swervedba.wordpress.com/2011/05/30/oracle-patch-sets-psu-and-cpu

          HTH
          • 2. Re: couple of questions
            %bala%
            You can open windows registry(regedit) and look for oracle software. If you find oracle entry there, you will get all required inforamtion.
            • 3. Re: couple of questions
              KR10822864
              947797 wrote:
              Hello,

              1) How to find whether Oracle Server Software or Oracle client software is installed on the machine?

              2) What is the difference between regular patchset and PSU?

              Thanks a lot for your help in advance
              How do I ask a question on the forums?
              SQL and PL/SQL FAQ
              • 4. Re: couple of questions
                KR10822864
                1) How to find whether Oracle Server Software or Oracle client software is installed on the machine?
                $sqlplus "/as sysdba"

                SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 19 08:24:42 2013

                Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


                Connected to:
                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                $sqlplus at client side i hope you may find the difference (actually am not installed client yet thats why am not able show you the results with comparison)
                2) What is the difference between regular patchset and PSU?
                refer below link.
                http://osamamustafa.blogspot.in/2013/04/describe-oracle-patches.html