Anuj Singh Oracle DBA
Monday, 14 March 2011
OEM troubleshooting commands
›
https://apt-lnx-tst-01.site:1158/em/console/aboutApplication ...
Friday, 11 March 2011
Unix AT command
›
unix at command unix at to set Unix AT job bash-3.00$ at -t 201103111805 at> cd /apps/documentum/dba/log/0000717c/sysadmin/dm_clean at...
Friday, 4 March 2011
How to review Oracle patch log file ...
›
To put line number on this file ... awk '{print NR $0}' patch.10.2.0.4.log >patch10_number.log grep -i "error" patch10_...
Thursday, 3 March 2011
Is session Tracing on for Oracle session ?
›
sql_trace—Shows- (TRUE/FALSE) if SQL tracing has been enabled in the session sql_trace_waits- If session tracing is enabled, you can have t...
Friday, 25 February 2011
Oracle text index re create script
›
spool index_scripts.lst set long 2000000000 set head off set pagesize 10000 select ctx_report.create_index_script ('username.text_index_...
netstat linux
›
apt-lnxtst-01:/etc/init.d # netstat -planet Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address ...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
›
Mysql database error apt-lnxtst-01:/etc/init.d # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
‹
›
Home
View web version