Archive | November 2009

Peta Jakarta

Bagi yang membutuhkan peta Jakarta bisa mendownload program flash Peta Jakarta disini:

Jakarta Map

(file nya cukup besar, tapi sangat berguna buat cari jalan di Jakarta. Enjoy)

Cara Menggunakan:

  • Ekstrak file zip
  • Jalankan StartMe.exe

Tidak perlu diinstall karena program ini menggunakan flash.

Screen Shot:

Advertisements

Disable Autoplay of CDs and USB Drives

Go to Start Menu -> Run and type in:
gpedit.msc
You will see the Group Policy window. You should select Administrative Templates -> System in the tree view:


Read More…

Create Logical Standby Database on Oracle Database 9i

Primary:
=======

SQL> Grant LOGSTDBY_ADMINISTRATOR to SYS with admin option;
SQL> Grant SELECT_CATALOG_ROLE to SYS with admin option;

SQL> ALTER DATABASE FORCE LOGGING;

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=/oracle/RP1/oraarch
2> MANDATORY’ SCOPE=BOTH;

SQL> ALTER SYSTEM SET LOG_PARALLELISM=1 SCOPE=SPFILE;

SQL> SELECT DISTINCT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED
2> ORDER BY OWNER, TABLE_NAME;

SQL> SELECT COLUMN_NAME, DATA_TYPE FROM DBA_LOGSTDBY_UNSUPPORTED
2> WHERE OWNER=’[owner]’ AND TABLE_NAME = ’[table_name]’;

SQL> SELECT OWNER, TABLE_NAME, BAD_COLUMN FROM DBA_LOGSTDBY_NOT_UNIQUE
2> WHERE TABLE_NAME NOT IN (SELECT TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED);

SQL> SELECT SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI FROM V$DATABASE;
SUP SUP
--- ---
NO NO

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;
Read More…

Create Oracle Data Guard Physical Standby using RMAN

PRIMARY
=======
pastikan database dalam mode:
– archivelog
– force logging
– listener bisa tnsping ke primary dan standby

$ RMAN target /
RMAN> backup database plus archivelog;
RMAN> backup current controlfile for standby format='/oracle/9.2.0/dbs/stby_cfile.%U';
RMAN> exit

$ sqlplus '/ as sysdba'
SQL> create pfile='/oracle/9.2.0/dbs/initORAprim.ora' from spfile;

# change parameter
SQL> alter system set log_archive_dest_2='service=standby reopen=60' scope=both;
SQL> alter system set log_archive_dest_state_2='enable' scope=both;
SQL> alter system set fal_client='primary' scope=both;
SQL> alter system set fal_server='standby' scope=both;
SQL> alter system set standby_archive_dest='location=/oracle/oradata/stbyarch' scope=both;
SQL> alter system set standby_file_management='AUTO' scope=both;
SQL> alter system set log_archive_start=TRUE scope=spfile;

SQL> shutdown immediate
SQL> startup

[create directory structure on standby]

[copy all backupfile from primary to RMAN backup directory in standby]
Read More…

WARNING:Could not set the asynch I/O limit to 64 for SQL direct I/O. It is set to 0

Problem:

I’ve got so many trace file generated every a few second that contains some of these WARNING:

WARNING:Could not set the async I/O limit to 64 for SQL direct I/O. It is set to 0
WARNING:Could not set the async I/O limit to 128 for SQL direct I/O. It is set to 0

Solution:

  1. Download patch 8217795 from Oracle Metalink. And apply patch.
  2. Change parameter file:
    alter system set disk_asynch_io=false scope=spfile;
  3. Restart database

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

If you get WARNING while starting up your database:

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

You can do these steps based on Metalink Document: 428441.1

SQL> connect / as sysdba
SQL> alter system reset aq_tm_processes scope=spfile sid='*';
SQL> shutdown immediate;
SQL> startup;

It works for me…