DBA with linux

intora file location /test/TEST/testdb/tech_st/11.1.0/dbs

adpatch   log file location /test/TEST/testapps/apps_st/appl/admin/TEST/log


strings -a APListXml.xml |grep '$Header'




[applerpp@finprod10 AP_Diag]$ cd $AP_TOP
Find file in Unix
[applerpp@finprod10 12.0.0]$ find . -name apgdfalb.pls
./patch/115/sql/apgdfalb.pls
[applerpp@finprod10 12.0.0]$ cd patch/115/sql/
Find Version of File
[applerpp@finprod10 sql]$ strings -a apgdfalb.pls | grep '$Header'
/* $Header: apgdfalb.pls 120.1 2008/03/10 09:49:15 serabell noship $ */

[testappl@finprod10 sql]$ strings -a apgdfalb.pls |grep '$Header'
/* $Header: apgdfalb.pls 120.1.12010000.30 2011/01/30 06:53:42 gagrawal ship $ *

$ORACLE_HOME
/test/TEST/testapps/tech_st/10.1.2

TRACE FILE LOCATION
$FORMS_TRACE_DIR

 /test/TEST/testinst/apps/TEST_finprod10/logs/ora/10.1.2/forms



ls -l
du -h
pwd cd ..
cd


To find environment variable

printenv

$appl_top

background_dump_dest

core_dump_dest

user_dump_dest



Kill process
cd /data/ERPP/erppdb/tech_st/11.1.0/admin/ERPP_finprod10/diag/rdbms/erpp/ERPP/trace
tail -100f  alert.log


list oracle process
ps -ef |grep LOCAL=NO

command is to see oracle instance process on linux server
ps- ef | grep pmon
export ORACLE_SID=orcl

ps -ef|grep testora|grep LOCAL=NO
kill -9 PID

kill all proesses
kill -9 ps -ef|grep LOCAL=NO|grep INSTANCE NAME|awk ‘{print $2}’`

Loaction of arch log
Prod
/data/ERPP_dbarch1/database/ERPP/arch
Test
/test/ERPP_dbarch2/database/ERPP/arch

zip the files
gzip *.arc