Translate this Page

 

Berikut adalah cara setting Connection SQL Server to Oracle :

  • Install Oracle Client di SQL Server Machine
  • Modify regedit, file dll yang digunakan tergantung versi oraclenya. Disini saya menggunakan Oracle 10g :

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]

            - “OracleXaLib”=”oraclient10.dll”

            - “OracleSqlLib”=”orasql10.dll” 

            - “OracleOciLib”=”oci.dll

  • Restart Server dimana SQL  Server terinstall
  • Create Connection to Oracle Server using ODBC, Continue reading »
 

In our finance database (Oracle EBS 11.5.9), I found there is a big snapshot log. I found AP.MLOG$_AP_INVOICE_DISTRIBUT has size more than 21 GB and still growing. The size of the tablespace APD is 26 GB, so that snapshot log has consume more than 80% of tablespace APD.

First of all, I analyze which is the master table that used this snapshot log.

 

SELECT MASTER, log_table, snapshot_id

  FROM dba_snapshot_logs

 WHERE log_table = ‘MLOG$_AP_INVOICE_DISTRIBUT’;

  Continue reading »

 

To get to single user mode, if you’re using LILO, type:
Code:

        linux single

at the boot prompt and hit ENTER.

If you’re using GRUB, hit ENTER at the countdown screen (booting kernel-whatever in 10 seconds…), select your kernel from the menu (the line that starts with “kernel”) and hit e. At the end of the line, add:
Code:

     single Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha