The snippet searches for a patchset entry in comps.xml to get the patch version rather than the base version (for releases prior to 11gR2 where out-of-place patching occurs). If a patchset cannot be found, it looks for the base version. Depending on the major release, the information about the edition is either in globalvariables.xml (11g, 12c) or in context.xml (10g).
\nWhen you call this \u201cohversion\u201d function, you get both the Oracle version and the edition of your current ORACLE_HOME.
\nIf you\u2019re using the bash as user shell, you may want to take one step forward and\u00a0 include this information in a much fancier bash prompt than the prompt by default:<\/p>\n
function ora_prompt ()\r\n{\r\n PSERR=$?;\r\n colylw='\\033[0;33m';\r\n colcyn='\\033[0;36m';\r\n colured='\\033[4;31m';\r\n colugrn='\\033[4;32m';\r\n coluylw='\\033[4;33m';\r\n colrst='\\033[0m';\r\n PS1=\"\\n# [ \\u@\\h:${colcyn}$PWD${colrst} [\\\\t] [${colylw}\\$(ohversion) SID=${coluylw}${ORACLE_SID:-\\\"not set\\\"}${colrst}] \\$( if [[ \\$PSERR -eq 0 ]]; then echo \\\"${colugrn}0${colrst}\\\" ; else echo \\\"${colured}\\$PSERR${colrst}\\\";fi) ] #\\\\n# \"\r\n}\r\n\r\nexport PROMPT_COMMAND=ora_prompt<\/pre>\n![\"2015_06_05_16_22_56_sso0419i\"](\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2015\/06\/2015_06_05_16_22_56_sso0419i.png\")
<\/a>Although this prompt may seem long, it has several advantages that save you a lot of typing:
\n\u2022 The newline character inside the prompt let\u2019s you start typing commands on an almost empty line so you don\u2019t have to worry about how long your command is.
\n\u2022 The full username@host:path can be copied and pasted quickly for scp commands.
\n\u2022 The time inside the square brackets is helpful to track timings.
\n\u2022 The indication of the current environment (version, edition, SID) lets you know which environment you\u2019re working on.
\n\u2022 The leading number is the exit code of the last command ($?). It\u2019s green when the exit code is zero and red for all other exit codes.
\n\u2022 Hash characters before and after the prompt mitigate the risk of copying and pasting the wrong line by mistake inside your session.<\/p>\nNote: this post originally appeared on IOUG Tips & Best Practices Booklet 9th edition.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you are an Oracle customer who has several database versions running, you have to deal with scripts that become more and more complex to maintain. Depending on the version or the edition of your database, you may want to … Continue reading