Assume you have two servers srv1 & srv2.
You want to add 5GB datafile on your tablespace DATA
1. Check the server mode. Which one is the master
vxdctl -c mode
root@srv2 # vxdctl -c mode
mode: enabled: cluster active – SLAVE
master: srv1
srv1 is a master
Check volume
TY NAME ASSOC [...]
Archive for the ‘Technology’ Category
Add datafile on RAC on rawdisk
Posted in Oracle on June 3, 2008 | Leave a Comment »
How to hide primary user information from another user on Oracle
Posted in Oracle on May 30, 2008 | Leave a Comment »
Sometimes you have to create user for your colleague/client that have privillege(s) to do select on primary user’s table. Unfortunately, your primary user’s password is not secure enough and you can’t change that password because many application connect to that database using that user, so you think you want to hide information about that primary [...]
What is Snoop / Tethereal ?
Posted in Solaris on April 4, 2008 | Leave a Comment »
Snoop is an executable binary that puts your system’s interface(s) in promiscuous mode. By being in promiscuous mode, snoop captures all packets on you network, in either real time or capture file format. What makes snoop so powerful is the detail of information it provides and the flexibility of the tool.
Tethereal is a network protocol [...]
Can’t Start Oracle Listener
Posted in Oracle on April 1, 2008 | Leave a Comment »
Someone on indo-oracle mailing list ask why he/she can’t start his/her listener
LSNRCTL> START
Starting /oracle/app/oracle/product/920/bin/tnslsnr: please wait…
TNSLSNR for HPUX: Version 9.2.0.6.0 – Production
System parameter file is /oracle/app/oracle/product/920/network/admin/listener.ora
Log messages written to /oracle/app/oracle/product/920/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.177.6.32)(PORT=1521)))
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.177.6.32)(PORT=1521)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
HPUX Error: 13: Permission denied
Listener failed to start. See the [...]
How to do Backup and Restore on MySQL
Posted in MySQL on March 27, 2008 | Leave a Comment »
It’s easy to do backup & restore on MySQL.
The simplest way to do it, you can use mysqldump
Here it is
To backup
go to $MYSQL_HOME/bin
#mysqldump -u username -p password -B database_name >> sqlfile.sql
To restore
- enter your mysql database
- create the database
- use the database
- source sqlfile.sql
For example :
I have employee database on mysql
My MySQLusername & password are [...]
Can’t Remote Login on Oracle
Posted in Oracle on March 3, 2008 | Leave a Comment »
Sometimes you want to log on to your database server from another server. For example in Oracle Dataguard you want to log on to standby from the primary server.
When you want to log on, you may usually type
#sqlplus sys@STANDBY as sysdba
What if you can’t log on to STANBY instance like this ?
oracle@standby-server$ sqlplus /nolog
SQL*Plus: Release [...]
Automatic telnet on shell programming
Posted in Shell Programming on February 15, 2008 | 1 Comment »
Sometimes you want to execute script on your another server automatically without rsh. What you usually do is telnet to that server and execute the script. But how to make it automatic ?
You can use the tricky method bellow
Asume your server target is 198.10.10.2 and you want to execute
/home/hnawri/alarm.sh
(sleep 1
echo username
sleep 1
echo password
sleep 1
echo “/home/hnawri/alarm.sh”
sleep [...]
FTP from shell
Posted in Shell Programming on January 27, 2008 | Leave a Comment »
Maybe it can help you to do automatic ftp from your shell script
ftp -in IP_ADDRESS << EOF
user username password
prompt off
cd $destination_dir
lcd $local_dir
put $files
bye
EOF
Get Oracle Query Result from Shell
Posted in Shell Programming on January 27, 2008 | Leave a Comment »
If you want to get data from Oracle using shell, you can use this script
$SQLPLUS -s $ORACLE_USER/$ORACLE_PASSWD@$ORACLE_SID << EOF >> $FILE
@$SQL_SCRIPT
exit
EOF
In order to avoid feedback and title heading, you may add
set heading off
set feedback off
on your $SQL_SCRIPT
Show Hidden Files on Windows
Posted in Daily Activities, Technology on January 2, 2008 | Leave a Comment »
Hmm, previously my computer’s sister hit by brontox.
Some files/folders are hiden by the virus.
The “Folder Option” tools didn’t work.
Hmm, I’ve got a way to unhide the files/folders.
Just open the “regedit” and go to this path
HKEY_CURRENT_USER
- Software – Microsoft – Windows – Current Version – Explorer – Advanced
Do change(s) on some parameter on that path.
Don’t worry, [...]
