Helpful Unix Commands and Tools

for working with Oracle Databases and the Oracle Enterprise Manager

1) To run many of the Java-based Oracle tools you must first set up your display by typing in these lines at the UNIX prompt:

DISPLAY="<hostname>:0"

xhost +<hostname>

2) Tools you can run at the UNIX prompt by typing in the command:

Command: Name: Description:

runInstaller	Universal Installer	add/remove program components
emca	Enterprise Manager Configuration Assistant	setting up repository for OEM
lsnrctl	Listener control	start/stop/ listener, typing in help once in the utility you will see list of commands. within this utility you can start the intelligent agent by typing in dbsnp_start, dbsnp_stop stops the intelligent agent
netasst	Net Assistant	Assign databases to listener and create service names
dbassist	Database Configuration Assistant	Creating/deleting databases
oemctrl start oms		Starts Oracle Management Server Service
oemapp console	OEM Console	monitoring and administration -(sysman/oem_temp) is the login and initial password - requires oms service, listener and intelligent agent to be running and database with repository open
svrmgrl	Server Manager	command line administation environment
orapwd	Password Utility	create password for sys and system – usage: orapwd file=<path and name> password=<password for internal> entries=<# simul admin users>
sqlplus	SQL*Plus	Oracle programming environment

3) In the SQL*Plus utility –

To change a user password: ALTER USER <username> IDENTIFIED BY <new password>

To startup a database: STARTUP [pfile=...init...ora]

4) Parameter File Default Locations –

in NT, default parameter file location is %ORACLE_HOME%\database

in UNIX, $ORACLE_HOME/dbs

usually these just contain a link to ORACLE_HOME/admin/<sid>/pfile