Displaying XWindows

Today, I want to execute script which is displayed by XWindows (GUI, not command line) in Linux. I just do this step
- Start your “X-Manager Passive”
- Check, in what port your X-Manager run. For example, my X-Manager run on :0.0
- export your DISPLAY
bash>export DISPLAY=YOUR_IP:0.0
example
bash>export DISPLAY=10.21.108.89:0.0
- run my script
Tadaaaa, [...]

Read Full Post »

Add Disk di Volume Manager

Melihat daftar DEVICE yang ada di seluruh DiskGroup
fabric_2 belum di-assign ke DG manapun
root@hnawri # vxdisk -o alldgs list
DEVICE TYPE DISK GROUP STATUS
HDS99600_0 sliced bkup09 [...]

Read Full Post »

Defrag/Rebuild Index on MS SQL DB

Sometimes your index may be defragmanted. It could make your system run slowly. You should rebuild/defrag you index.
But what happend when you have a lot of index ?
Are you want to rebuild it one by one ?
So wasting time huh ? You may use my script to defrag your index on your MS SQL Database

IF [...]

Read Full Post »

Check usage resource in Oracle

Sometimes you want to check, which process that make your oracle database heavy and what program is it ?
You can use this script to check your Oracle DB process

SELECT s.status “Status”, s.serial# “Serial#”, s.TYPE “Type”, s.username
“DB User”, [...]

Read Full Post »

Alter Datafile from autoextend on to off

Sometimes you want to disable automatic extend on your datafile and extend its size. You may use this script
For example :
Datafile : your_dbfile.dbf size 2G autoextend on
You want to change it into 5G and disable the autoextend
Here we are

alter database datafile ‘your_dbfile.dbf ‘ resize 5G
alter database datafile ‘your_dbfile.dbf ‘ autoextend off
Just it

Read Full Post »

Check Freespace in Tablespace

Sometimes you want to see your freespace in your tablespace.
Here we are
column total_space format 9,999,999,999,999
column freespace format 9,999,999,999
(select tablespace,
datafile total_space,
freespace freespace
from
(select tablespace_name tablespace
from dba_tablespaces where status=’ONLINE’) a,
(select tablespace_name tablespace1, sum(bytes) datafile
from dba_data_files group by tablespace_name) b,
(select tablespace_name tablespace2, sum(bytes) freespace
from dba_free_space group by tablespace_name) c
where tablespace=tablespace1 and
tablespace1=tablespace2(+));

Read Full Post »

Kill all user process

Sometimes you want to kill all user process, you can’t do “kill -9 PID” for all process that users have.
You can use this trick
Example :
You (as root), want to kill all process which is had by user “oracle”.
Maybe you want to use this script before you shutdown immediate your Oracle DB
# ps -ef | grep [...]

Read Full Post »

Forget root password on MySQL

1. Shutdown your mysql database
2. Turn on your mysql db with this comman.
#safe_mysqld –skip-grant-tables &
3. Enter mysql without using password
#mysql -u root
4.Update your root’s password
#update user set password=password(‘passwd_baru’) where
user=’root’;
5. Shutdown your mysql
6. Turn on your mysql daemon
#safe_mysqld &

Read Full Post »