Unix Command Notebook 22 September 2010
Posted by Tyo in Uncategorized.add a comment
A note for command that usually use on Unix:
1.infinite loop for monitoring space
while true; do df -g /mount1 ; sleep 10; done
2.Find file which modified more than 2 days ago
find /mount1 -name ‘*.123′ -mtime +2
3.Checking oracle connected user (showing pid,memory used, argument)
ps -ef -o pid,vms,args | grep oracle
4.Find file and delete it
find /mount1 -name ‘*.123′ -mtime +3 -exec rm {} \;
ORA-01244 on Physical Standby 14 September 2009
Posted by Tyo in Oracle.add a comment
Error Message: ORA-01244
and below are steps to resolve the problem.
First thing to do query v$datafile to check the unnamed datafile with this query:
select name from v$datafile; (lagi…)
A Day with Solaris 10 4 Desember 2008
Posted by Tyo in Uncategorized.1 comment so far
Installing Oracle 10g on many operating system has been my regular jobs for this 2 month. Most of this jobs using Solaris 10 as their operating system. Usually when doing installation, i have a backup from solaris people from many other vendors or their principal to do the setting for solaris 10. I just sit back and relax and watch them do the setting shmmax. It really enjoyable though 
.
Changing Hostname on Linux 21 Oktober 2008
Posted by Tyo in Linux.Tags: change linux hostname, hostname, Linux
1 comment so far
This post is only a reminder for me on “how to change Hostname in Linux”. Since I play a lot with VMWARE, and I already have the Linux OS template, so i don’t have to do linux installation all the time whenever i need to do new Oracle installation, just change the hostname and ip address and those Linux OS template is ready to use.
My Oracle Script Collection 15 Februari 2008
Posted by Tyo in Oracle.add a comment
1. Moving all tables in a schema
select ‘alter table ‘ || table_name || ‘ move tablespace users’ from user_tables;
2. Moving all indexes in a schema
select ‘ALTER INDEX ‘ ||Index_name || ‘ REBUILD TABLESPACE INDX’ from user_indexes;
3. Check Tablespaces size in a database
SELECT df.tablespace_name TABLESPACE, df.total_space TOTAL_SPACE,
fs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB,
(lagi…)
