Feeds:
Posts
Comments

in administrator console:
powercfg -h off

Advertisements

I am so tired copy and paste sql script using Notepad++ with column editing fiture (http://www.youtube.com/watch?v=1p7rMCGt_30). So I decide to create python script for doing this job.

import time
from datetime import date

f1=open('c:\\python27\\txt1.txt','r')
f2=open('c:\\python27\\txt2.txt','w')
ym=201300
month=1
year=2013
day='01'
for line in f1:
        month=month+1
        year=year+(month-1)/12
        if month>12:
                month=1
        ym=ym+1
        x=line.replace('201301',str(ym))
        f2.write(x.replace('2013-02-01',str(year)+'-'+str(month).zfill(2)+'-01'))
f1.close()
f2.close()

Happy scripting 😀

To convert from a UNIX (Epoch) date to Oracle date
TO_DATE(‘1970-01-01’, ‘YYYY-MM-DD’) + UNIX_date_in_millis / 86400000 = Oracle_date

And to convert the other way
(Oracle_date – TO_DATE(‘1970-01-01’, ‘YYYY-MM-DD’) )* 86400000 = UNIX_date_in_millis

I don’t remember why I needed this so long ago.

one thing that the SAP Documentation does not mention, when you want to enable the Dashboards Cache is :

Go to the CmcApp and then look for the “Application” option, right click > properties

After that, check the cache option, and all the pain will be paid 😀

Tingkat: Pemula
DB Version: 10.2.0.1 above

Database yang sudah ter-create dapat kita clone menggunakan DBCA. Hasil clone ini akan disimpan sebagai template.

Pertama, jalankan dbca:

dbca-001.jpg

Klik tombol Next, maka kita masuk ke step 1. Pastikan Manage Templates terpilih. Kemudian klik tombol Next:

blog-0002.jpg

Pada step 2, Pilih Create a database template dan From an existing database (structure as well as data), kemudian klik tombol Next:

blog-0003.jpg

Pada step 3, Pilih Database instance yang ingin kita clone, kemudian klik tombol Next:

blog-00041.jpg

Tentukan Nama template pada bagian Name, kemudian tentukan pula dimana kita akan menyimpannya, isi dibagian Template datafile, setelah itu klik tombol Next:

blog-0005.jpg

Step 5 akan ada pilihan, apakah lokasi file yang ada sekarang akan kita simpan atau akan menggunakan lokasi file standar dari oracle. Terakhir klik tombol Finish:

blog-00061.jpg

Klik tombol OK untuk memulai proses clone:

blog-0007.jpg

Tampak pada gambar proses clone sedang berjalan:

blog-0008.jpg

Proses clone selesai:

blog-0009.jpg

In this Document


This document is being delivered to you via Oracle Support’s Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Warehouse Builder – Version: 11.1
Information in this document applies to any platform.

Goal

How to start the Warehouse Builder Repository Listener ?

Solution

With Warehouse Builder 11g, the “Start and Stop OWB Browser Listener” were removed from the Windows Program Groups.
  1. To start the Warehouse Builder Browser Listener:
    1. Open a Command-box.
    2. Navigate to owb_homeowbbinwin32 (/owb_home/owb/bin/unix for Unix ).
    3. Run the startOwbbInst.bat (startOwbbInst.sh for Unix)
      The first time you invoke this listener, select and re-confirm a password for an oc4jadmin account
      D:Oracleowb11owbbinwin32>startOwbbInst.batD:Oracleowb11owbbinwin32>call setowbenv.bat
      2007-12-03 10:21:30.230 NOTIFICATION Auto-unpacking D:Oracleowb11owbj2eeowbb.war…
      2007-12-03 10:21:30.360 NOTIFICATION Unjar D:Oracleowb11owbj2eeowbb.war in D:Oracleowb11owbj2eeowbb
      2007-12-03 10:21:43.439 NOTIFICATION Finished auto-unpacking D:Oracleowb11owbj2eeowbb.war
      03-dec.-2007 10:21:43 com.evermind.server.XMLApplicationServerConfig randomizeJtaAdminPassword
      INFO: Updating JtaAdmin account
      07/12/03 10:21:44 Set OC4J administrator’s password (password text will not be displayed as it is entered)
      Enter password:
      Confirm password:
      The password for OC4J administrator “oc4jadmin” has been set.
      07/12/03 10:22:19 The OC4J administrator “oc4jadmin” account is activated.
      07/12/03 10:22:30 Oracle Containers for J2EE 10g (10.1.3.0.0) initialized

      Subsequent start will look like this :

      D:Oracleowb11owbbinwin32>startOwbbInst.batD:Oracleowb11owbbinwin32>call setowbenv.bat
      07/12/03 10:31:35 Oracle Containers for J2EE 10g (10.1.3.0.0) initialized
    4. The Command-box will remain open until the Warehouse Builder Browser Listener is stopped.
  2. To stop the Warehouse Builder Browser Listener:
    1. Open a Command-box.
    2. Navigate to owb_homeowbbinwin32 (/owb_home/owb/bin/unix for Unix ).
    3. Run stopOwbbInst.bat (stopOwbbInst.sh for Unix)
      Each time you stop this listener, the password has to match what was supplied in the first start.
      D:Oracleowb11owbbinwin32>stopOwbbInst.batD:Oracleowb11owbbinwin32>call setowbenv.bat
      Enter password:
      D:Oracleowb11owbbinwin32>

Additional steps are described in the Warehouse Builder Installation and Administration Guide 11g Release 1 (11.1) : Chapter 1 Installation Overview and Requirements – Launching Warehouse Builder Components – page 1-19 .