Database

This category contains 15 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

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

Calculate Oracle Shared Pool

Sample to calculate the Oracle Shared Pool on IRBS2 scheme — Select SID from User Process select sid from v$process p, v$session s where p.addr=s.paddr and s.username=’IRBS2′; — Get the maximum session memory for this session: select sum(value) from v$sesstat s, v$statname n where s.statistic# = n.statistic# and n.name = ‘session uga memory max’ and … Continue reading

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

How to check your Oracle Database status (whether running properly or not)

As a Database Administrator you should know how to check whether your database can work properly or not. Here’s the steps that you can use to know whether your oracle database work properly or not (in Unix OS) Check whether the instance run well and database can be accessed Check whether the Oracle Process run … Continue reading

Archives

Twitter Updates

Error: Twitter did not respond. Please wait a few minutes and refresh this page.