IT

This category contains 2 posts

Menampilkan Tipe Autentikasi User di Oracle

Hari ini ada seseorang yang bertanya apakah sebagai Oracle Database Administrator kita dapat melihat asal akses user dan tipe autentikasinya, apakah password yang digunakan internal atau eksternal (OS authentication, LDAP, etc) Jawaban saya adalah ya kita bisa melihatnya. Oracle telah memberikan kita tools untuk melakukan administrasi & monitoring user. Dalam kasus ini kita menggunakan view … Continue reading

Scheduler Job

If your application use Oracle DB to do routine job, you may use Oracle Scheduler instead of crontab or windows scheduler Oracle use dictionary dba_scheduler_* to keep scheduler information. Here’s the sample if you want to check whether your application use Oracle Job or not SELECT * FROM dba_scheduler_jobs MGMT_CONFIG_JOB RLM$SCHDNEGACTION RLM$EVTCLEANUP WHITELIST_HOUSEKEEP DUMP_WHITELIST CLEANUP_WHITELIST … Continue reading

Add datafile on RAC on rawdisk

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 KSTATE LENGTH … Continue reading

How to hide primary user information from another user on Oracle

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 … Continue reading

What is Snoop / Tethereal ?

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 … Continue reading

Can’t Start Oracle Listener

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: … Continue reading

How to do Backup and Restore on MySQL

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 … Continue reading

Can’t Remote Login on Oracle

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 ? … Continue reading

Automatic telnet on shell programming

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 … Continue reading

FTP from shell

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

Archives

Twitter Updates

Error: Please make sure the Twitter account is public.