Oracle RDBMS Version
SELECT * FROM V$VERSION;
Version of OPATCH
$ perl $ORACLE_HOME/OPatch/opatch.pl version
Listener Version
$ lsnrctl version
Check Database 32-bit or 64-bit?
select length(addr)*4 ‘-bits’ word_length from v$process where ROWNUM =1;
Reader ModeIf you are using 32-bit oracle database on any 32-bit / 64-bit plateform then you can convert or migrate 32-bit database to 64-bit database.…
Reader ModeGet Hands-On training. Mail me at anup@indiandba.com for more details. We can use three methods to upgrade our oracle database. Export / Import Database…
Reader ModeHow to Find Oracle Applications version Version of a Oracle Applications Form (fmx) or report strings -a | grep Header alternatively you can also…
Reader ModeAn Oracle instance runs two types of processes – · Server Process · Background Process Before work user must connect to an Instance. When…
Reader ModeSun Solaris VersionTo check the version of you Solaris you can use the following file.$ cat /etc/release RedHat Linux VersionYou can check the version…
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
Responses