RE: Oracle Hp OpenVMS
Date: Wed, 28 Oct 2009 14:43:44 -0500 (CDT)
> Once you're inside Oracle's walls (e.g. SQL*Plus, RMAN, lsnrctl, etc.) it's
> pretty much the same as on any other OS, but if you have to do anything at
> the OS level there is a big learning curve - even for simple things like
> changing directories, editing/manipulating files, checking filesystem space.
> The commands and options are VERY different from Unix. I'd say if the
> tuning you're being asked to do is within the database, e.g. tuning queries,
> Oracle parameters, etc., then you should be fine, but if it's tuning at the
> OS level that is needed, then run away unless you have lots of time to spend
> learning DCL.
Man, I miss DCL and logicals! I was a VMS guy from 4.7 to about 7.1. The problem with most things on VMS is that they try and make it Unix-like.
Some (very) quick tips:
Unix VMS ----------------------- ------------------------ $HOME SYS$LOGIN .bashrc OR .kshrc LOGIN.COM echo WRITE SYS$OUTPUT cd SET DEFAULT SYS$LOGIN echo $PWD SHOW DEFAULT vi EDIT/EDT or EDIT/TPU (TPU is generally preferred) alias up='cd ..' UP:=="SET DEFAULT [-]" ./myscript.sh _at_MYSCRIPT.COM cp COPY rm DELETE/LOG man HELP exit LOGOFF
I'm going from 10yo malted-barley-soaked memory, so hopefully those are close to correct. The MAJOR power, however, comes from VMS Logicals. It's like how soft links in Unix should really work, as they transcend simple filename substitution. "SHOW LOGICAL" is your friend!
You may want to use alias commands for your interactive sessions (VMS can make the distinction between interactive, batch, etc logins) in your SYS$LOGIN:LOGIN.COM to ease the transistion, e.g. CD:=="SET DEFAULT". Just beware that doing this in the Oracle owner's account can affect how Oracle itself runs if you should happen to override existing commands that it uses.
While much different from Unix, I *much* preferred DCL and the RMS filesystem on VMS. DCL is a very powerful scripting language, logicals are invaluable for system management and maintenance, security was never an afterthought, and DEC Rdb is what gave us all the new features of Oracle7. The very high overhead on process creation and the general kernel tunables (trying to tune NPAGEDYN via AUTOGEN -- groan!) however, left a lot to be desired, IMHO.
OK, trip down memory lane completed...