Pengalaman Mengurus Roya di Kantor BPN Tangerang Selatan (September 2015)

Tahukah anda bahwa Kantor BPN Kota Tangerang Selatan buka di hari Sabtu dan Minggu? 🙂 🙂 🙂

Ya! Pelayanan akhir pekan ini memang khusus ditujukan bagi Masyarakat umum. Secara umum, Pelayanan terbagi menjadi 2 yaitu :
1. Pendaftaran dan Pemrosesan dokumen – dari jam 09.00 s.d. 11.00
2. Penyerahan Produk / Sertifikat yang telah di proses – dari jam 12.00 s.d. 13.00

Belum lama ini saya datang ke BPN Kota TangSel untuk mengurus Penghapusan Hak Tanggungan terhadap Sertifikat Tanah/Rumah yang saya miliki, atau lebih dikenal dengan istilah Roya. Proses administrasi ini diperlukan untuk membuktikan bahwa kita sebagai Pemilik Tanah/Rumah sudah tidak lagi memiliki hutang dengan Bank, tentunya karena kita telah menyelesaikan pelunasan kredit pinjaman tersebut.

Adapun syarat-syarat yang diperlukan sbb:

Nah – semua informasi persyaratan dapat dengan mudah diperoleh dari Brosur resmi BPN yang tersedia di kantor tersebut.

Secara garis besar ada 3 “ruangan” yang perlu kita kunjungi. Pertama adalah…

View original post 488 more words

Advertisements

How to connect Form/Report dev6i to Oracle Database 12c

We have database 10.2.0.5, want to convert to 12.2.0.1, the step are:
– exp from 10.2.0.5
– imp to 12.2.0.1
import Oracle 12.2.0.1 has been completed.

And then the first problem is oracle form crash when connecting to oracle 12.2.0.1

After searching, the solution come from this website:
https://www.youtube.com/watch?v=V0Achdev4gA

CONNECT AS SYSDBA
CONNECT SYSTEM USER (SYSTEM/(OWN YOUR DATABASE PASSWORD))
SHUTDOWN IMMEDIATE;
STARTUP RESTRICT;
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;
SHUTDOWN;
STARTUP MOUNT;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

After solving the first problem, then the second problem is coming, ORA-28040: No matching authentication protocol

For second problem, this reference is the solution:
http://logic.edchen.org/how-to-resolve-ora-28040-no-matching-authentication-protocol/

Adding SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 to sqlnet.ora in 12.1 database server (not the old client).

Connecting successfulle but still got malformed TTC package message, will solved later ..

SQL*Plus: Release 8.0.6.0.0 – Production on Wed May 8 15:24:46 2019

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-5] [0]
[0x000000000] [0x000000000] [0] [0] [2080] []

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL>

XAMPP Solved : the procedure entry point ocistmtgetnextresult could not be located in the dynamic …

Notes . Noted

I’ve just got new laptop and when I re-installed the XAMPP I got this error :

the procedure entry point ocistmtgetnextresult could not be located in the dynamic …

So this was my setup when It’s error :

• I was using Windows 10 64 bit
• My PC using architecture 64 bit
• I installed XAMPP x86
• I used Oracle Install Client 12.2 64 bit, set into PATH environment

So after I configured php.ini (uncommented the extension)

extension=php_oci8_12c.dll 

that error occurred, after trial and error it was solved by doing these actions

1. Download 32 bit Oracle Install Client, and reset the PATH environment variable to that folder
2. Add oci.dll, oraociei12.dll, and oraons.dll to apache/bin folder. Replace the existing one
3. Restart the Apache

Basically, I change the oracle client according to the XAMPP/apache/php version (x86 v 64 bit)

View original post

How to access sharing folder using UTL_FILE (Oracle Database)

utl_fileDownload

When start service, run as user who can access the host system. See PDF file for details

PL/SQL: Sleep without using DBMS_LOCK

Oracle Deli

If you want to wait in your PL/SQL program (“sleep”) you may want to use the procedure “SLEEP” from the package “DBMS_LOCK“. While this function does exactly what you want, your DBA may not grant you access to this package, because it contains some other mighty and dangerous procedures.

But there is help! Here are some valid alternatives:

Option 1: APEX_UTIL.sleep

If APEX is installed you can use the procedure “PAUSE” from the publicly available package APEX_UTIL.

Example – “Wait 5 seconds”:

SET SERVEROUTPUT ON ;
BEGIN
    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
    APEX_UTIL.PAUSE(5);
    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));
END;
/

Option 2: java.lang.Thread.sleep

An other option is the use of the method “sleep” from the Java class “Thread”, which you can easily use through providing a simple PL/SQL wrapper procedure:

CREATE OR REPLACE PROCEDURE SLEEP

View original post 48 more words

How to fix Cannot load OCI DLL: D:\oracle\instantclient_10_2\oci.dll

We have Oracle database 11.2.0.4 (red hat linux 64bit) and the client connect from Windows 10 64bit

Firstable, on the client we are using Oracle client 10.2.0.5 32 bit and setting ORACLE_HOME by environment variables using this tutorial:
https://sikathabis.wordpress.com/2013/09/12/menjalankan-toad-dengan-oracle-client-basic-lite-for-windows/

But we have a problem, the toad cannot find the setting ORACLE_HOME, after we searching how to fix it, then we set the ORACLE_HOME on the regedit:

Second problem is show message “Cannot load OCI DLL: d:\oracle\instantclient_10_2\oci.dll” and then try to fix it by using Oracle Instant Client 32bit with same version Oracle Database 11.2.0.4, and …… the toad connected from windows 10

How to convert xml into text file [python]

import xml.etree.ElementTree as ET
tree = ET.parse(‘test.xml’)
notags = ET.tostring(tree.getroot(), encoding=’utf-8′,method=’text’)
f = open(‘test.txt’,’w’)
f.write(notags)
f.close()

reference : link1 | link2

How to Install DosBox with QBASIC

1. First you must download dosbox on this link
   https://www.dosbox.com/download.php?main=1
   If your Operating System (OS) Windows choose Windows, if your OS Mac OS X
2. Download QBASIC on this link http://www.qbasic.net/en/qbasic-downloads/compiler/qbasic-interpreter.htm
3. Extract zip file from point 2 to new folder example c:\oldDos\qbasic
4. Run DosBox , shortcut on the Desktop or programs
5. Type mount C c:\oldDos
6. Type c:\
7. Type CD\qbasic
8. Type Qbasic, now you can use Qbasic

 

Auto-backups of PLSQL source

Auto backups of plsql source

How to connect oracle 12c from toad 9.7

You must have Oracle Client 10g and then replace 12c
https://sikathabis.wordpress.com/2013/09/12/menjalankan-toad-dengan-oracle-client-basic-lite-for-windows/

Example
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclpdb)))