//
you're reading...
Solaris

ORACLE Financials Administration – Common SOLARIS commands

these are the most common Solaris commande that I use:

df –h

(df = Disk Free) to show details of the disk space. I use this command to monitor disk space. The –h option returns output in human readable format.

prtdiag

Gives a summary of the processor version, CPUs etc. Useful when dealing with ORACLE sales teams or support.

find /s01/proddata/logs –mtime +50 –exec rm {} \;

this deletes files in /s01/proddata/logs which are more than 50 days old. There are several different forms of the find command, which allow you to specify file names etc.

ls –ltr

My favourite form of the ls command; other flavours are available

ls | wc –l

to give a count of files in the current dir.

ps -ef | grep FNDLIBR

to check if the Oracle Financials concurrent manager is running. It should return several processes, with additional information about the process.

pargs –e 1234

to display environment variables for a running process. Obtain the process id (here 1234) from the ps –ef command (above). This was useful when I had to re-start the Oracle Gateway listener with no documentation regarding the original environment variables used.

pargs –l 1234

to display the command line that was used to start the process.

/usr/sbin/logadm -f $ORACLE_HOME/config/alert.conf

to rotate the oracle alert log – this is scheduled to run daily on my production system.

lsnrctl status PRODDB    lsnrctl start PRODDB    lsnrctl stop PRODDB

to check the listener status, then start or to stop the listener for database PRODDB

About iantreasure

DBA with 25 years experience (SQL Server, Oracle).

Discussion

No comments yet.

Leave a comment