Oracle Useful Information

UNIX to VMS Translation Table

UNIX

VMS

NOTES

UNIX EXAMPLE

VMS EXAMPLE

crontab [ -le ]
at

SUBMIT filespec[,...] /QUEUE=queue-name[:]

These commands allow command scripts to be executed at given times, but both are fundamentally different implementations. VMS had a full batch queue system capabilities where queue characteristics (e.g. CPU, Elapsed time limits) can be set.

crontab -l
at now start.ksh

SUBMIT /CHAR=(33)/QUEUE=BLONG1/LOG=JOB.LOG/NAME="Batch Job" /NOTIFY/PARAMETERS=(1,2,3)
SHOW QUEUE/BATCH/FULL
SHOW SYSTEM/BATCH
SHPR PROCESS/CONT/BATCH=1234
DELETE/ENTRY=1234

$HOME

SYS$LOGIN

Home directory

.profile

LOGIN.COM

Login execution script. Both the .profile and LOGIN.COM reside in the users home directory. System administrators have access to global versions of these files which run before the users version.

/etc/passwd

SYS$UAF:authorize

User Authorization file

/tmp

SYS$SCRATCH

Temporary Areas

cat [filename...]

TYPE filespec[,...]

Displays the contents of a file or group of files on the current output device

cat oldfile.lis

TYPE /PAGE OLDFILE.LIS

cd [ dir ]

SET DEFAULT [device-name[:]][directory-spec]

Sets your default device and directory specifications or working directory

cd /home/user1

sd USER_DISK:[USER1]
sd user_disk:[000000]

chmod symbolic_mode_list file … chmod numeric_mode file …

SET PROTECTION[=(code)] filespec[,...] SET FILE filespec[,...] /PROTECTION[=(ownership[:access][,...])] SET FILE /ACL object-name

Change the security level of one or more files.

chmod 777 file1
chmod +rx file2
chmod 4755 oracle (sets the setuid bit on which allows other processes to run as the effective uid of the owner of the file)

SET PROT=W:RWED FILE1.TXT
SET ACL * /LIKE=(object_name=<sss>)

chown owner[:group] file …
chgrp owner file

SET FILE filespec[,...] /OWNER_UIC[=uic]

Change the file owner or group

chown oracle:dba /dbs1
chgrp dba /dbs2

SET FILE/OWNER=ORACLE ORA_DISK:[000000]*.*

cp source_file target_file

COPY input-filespec[,...] output-filespec

Creates a new file from one or more existing files

cp -p file1 file2
cp -r ./project1/* ./project2/.

COPY/REPLACE/LOG [.PROJECT1]*.*;* [.PROJECT2]*.*

date

SHOW TIME

Displays the current date and time.

date

SHOW TIME

df [-o specific_options] [special|directory]...

SHOW DEVICES /MOUNTED [device-name[:]]

Display disk and device information, including totals and free space

df -k

SHOW DEVICE /MOUNTED

$DISPLAY

SET DISPLAY

Set display to a client

export DISPLAY=11.111.11.11:0.0

SET DISPLAY/CREATE/NODE=nodea/TRANS=DECNET
SET DISPLAY/CREATE/NODE=11.111.11.11/TRANS=TCPIP

ed [ filename]

EDIT/EDT [file-name]

Standard Text Editor

ed newfile.lis

EDIT/EDT NEWFILE.TXT

export [ name[=value] ]

ASSIGN equivalence-name[,...] logical-name[:] DEFINE logical-name equivalence-name[,...]

Assign logicals/enviroinment variables.

export ORACLE_SID=db1

DEFINE ORACLE_SID db1
ASSIGN db1 ORACLE_SID

find path...expression

DIR

Find files with a given characteristic.These two are not generally equivalent, but the some UNIX find commands can be acheived with the VMS DIR command.

find . -mtime -1
find -name -print

DIR /SINCE=TODAY
DIR /EXCLUDE
DIR/SIZ=ALL

fuser -cu [device]

SHOW DEVICE/FILE
ANALYZE/SYSTEM
SDA> show summary
SDA>set proc/id=[id]
SDA> show process/channel

Identify processes using a file or file structure

fuser -cu /home

SHOW DEVICE /FILE

grep limited-regular-expression [ filename ... ]

SEARCH filespec[,...] search-string[,...]

Searches one or more files for the specified strings and displays the lines containing those strings.

grep -i "text" oldfile.lis

SEARCH *.TXT TEXT

id

F$USER

Current User. Two commands in VMS, but you can get the same information by VMS command
SHOW PROCESS/PRIV

id

UIC = F$USER SHOW SYMBOL UIC

kill [signum] pid ...

STOP [process-name]

Terminates execution of a command, an image, a command procedure, or a detached process or subprocess.

kill -9 12345

STOP /ID=20200896

lp [ -d dest ] [ file... ]

PRINT filespec[,...] /QUEUE=queue-name[:]

Queues one or more files for printing to an output queue.

lp -d lp0 myfile.lis

PRINT/QUEUE=LASER1 MYFILE.TXT

ls [ file... ]

DIRECTORY [filespec[,...]]

Provides a list of files or group of files.

ls *file*

DIR *FILE*.LIS;3

ls -l [ file... ]

DIRECTORY/FULL [filespec[,...]]

Provides information about a file or group of files.

ls -ltr /usr/users1/*file*

DIR/FULL USER_DISK:[USER1]*FILE*.LIS;
DIR/DAT/SIZE/CREATED/WIDTH=(filename=40)

lspv

show device

list Physical Devices

&nsp;

&nsp;

man

help

Display Help on a command

man -k system
man man

help dir

mkdir dir...

CREATE/DIRECTORY directory-spec[,...]

Creates one or more new directories or subdirectories.

mkdir ./newproject

CREATE/DIR/LOG [.NEWPROJECT]

more [filename …]

TYPE/PAGE filespec[,...]

Browse or page through a text file.

more oldfile.lis

TYPE/PAGE OLDFILE.LIS

nohup

SUBMIT

Run a file in background mode

nohup ksh file.ksh &

SUBMIT/SPAWN/DETACH

ps -ef
ps aux
ps av

MONITOR SYSTEM
SHOW SYSTEM /BATCH
SHOW SYSTEM /INTERACTIVE
SHOW PROCESS /CONTINUOUS/ID=pid

Displays status information about current processes

ps -ef | grep -v grep | grep 12345
ps -ef | grep oracle

SHOW PROCESS /ID=12345/CONT
show system /owner=oracle

PS1

SET PROMPT[=string]

VMS has a command to set the login prompt, UNIX has an environment variable PS1

export PS1="$ >"

SET PROMPT="$ >"

pwd

SHOW DEFAULT

Displays the current default device and directory.

pwd

SHOW DEFAULT

rcp source_file target_file

COPY input-filespec[,...] output-filespec

Copy files between nodes

rcp -p file1 file2

COPY /LOG file1.txt node1:"username password"::disk1:[username]file2.txt;

rdist -c name... [ login@]host[:dest ] rcp source_file1 dest_file

COPY input-filespec[,...] node["]username password["::]output-filespec

Copy files between remote nodes.

rcp -p file1 host1:/home/file2

COPY/LOG FILE1.TXT NODE"user1 user1"::[PROJECT2]FILE2.TXT

rm file…

DELETE filespec[,...]

Deletes one or more files from a mass storage disk volume. VMS also has the ability to PURGE files since each file created has a version number associated. As files are edited, new versions are created in VMS, whereas in UNIX, the file is overwritten.

rm -fr /temp/*

DELETE [TEMP…]*.*;*

rmdir dirname...

DELETE filespec[,...]

Remove directory Entries.Within VMS a DIRECTORY is a file, so there is no specific remove directory command. The protection of VMS directories needs to be set deleting the directory.

rmdir newproject
rm -r newproject

set file/protection=(s:rewd) newproject.dir;
DELETE NEWPROJECT.DIR;

Standard Output

SYS$OUTPUT

Can be directed to a file.

type/etc/passwd lsuser myuser

run sys$uaf:authorize SYSUAF > show myuser

List user details.

typeset -l FILE=UUU

F$EDIT(FILE,"UPCASE")

Convert to uppercase

typset -u FILE=uuu

F$EDIT(FILE,"LOWERCASE")

Convert to lowercase

uname

F$GETSYSI

Returns status and identification information about the local system

uname -a

NODE = F$GETSYI("NODENAME")
SH SYM NODE
show system

unset [ name ... ]

DEASSIGN [logical-name[:]]

Unassign logicals/environment variables

unset ORACLE_SID

DEASSIGN ORACLE_SID

uptime

show system/noprocess/full

Show how long the system has been up.

uptime

show system/noprocess/full

vi [ filename]

EDIT/TPU [file-name]

Enhanced Text Editors

vi newfile.lis

EDIT/TPU NEWFILE.TXT
EDIT/EDT newfile.txt

view [ filename]

EDIT/TPU/READ_ONLY [file-name]

Edit file read only.

view newfile.lis

EDIT/EDT/READ NEWFILE.TXT

who -u

SHOW USERS [username] /FULL

Displays the user name and node name of users on the system

who -u

SHOW USERS * /FULL

PURGE [filespec[,...]]

Deletes all but the highest numbered versions of the specified files.

PURGE/LOG/KEEP=3 OLDFILE.TXT

SHOW QUEUE [queue-name]

Displays information about queues and the jobs that are currently in queues

SHOW QUEUE/BATCH/FULL

SET PROCESS/PRIV=ALL

Enable all VMS provileges

ldd [filename ...]  

ANALYZE /IMAGE [filespec[,...]]  

List Dynamic Dependancies or Analyze a VMS executable

ldd oracle

ANALYZE /IMAGE ORACLE.EXE