Oracle, Web, Script, SQLserver, Tips & Trick

January 12, 2020

Script to generate DDL from all schema except sys, system, etc.

Filed under: oracle — sikathabis @ 11:35 pm
Tags: ,
set heading off;
set echo off;
Set pages 1000;
set long 50000;
SET linesize 150;
spool d:\exec_Myddl.sql;
select 'set heading off; set echo off;Set pages 1000;set long 50000; SET linesize 150; spool d:\My_ddl.sql;' from dual;
select 'select DBMS_METADATA.GET_DDL(''TABLE'','''||table_name||''','''||owner||''') from dual;' from all_tables
where owner not in ('SYS','SYSTEM','SYSMAN','DBSNMP','OUTLN','MDSYS','ORDDATA','APPQOSSYS','GSMADMIN_INTERNAL','XDB',
'DBSFWUSER','WMSYS','OJVMSYS','CTXSYS','LBACSYS','OLAPSYS','LBACSYS','DVSYS','HR','DEV_WLS','DEV_OPSS',
'DEV_IAU','DEV_STB','SCOTT','DEV_WLS_RUNTIME','ORDSYS');
select 'spool off;' from dual;
spool off;
@d:\exec_myddl.sql;
/

NOTE: The exec_mydll.sql file is automate to generate script DDL, and the result is my_ddl.sql

November 18, 2019

How to disable second hard disk on VMWARE

Filed under: linux,vmware — sikathabis @ 11:48 pm
Tags: ,
Problem: The file (vmdk) from the second hard drive was accidentally deleted

I’ve tried to troubleshoot with open vmx files, There’s two scsi
First, scsi0:0
Second, scsi0:1

1. Change
scsi0:1.present = “TRUE
with
scsi0:1.present = “FALSE

(more…)

August 29, 2019

How to kill Anydesk (full screen with keyboard locked) ~ Windows

Filed under: dos,windows — sikathabis @ 9:05 am
Tags: , ,

Sometimes I’m using anydesk with fullscreen mode, and keyboard locking with another application happened, I tried to kill anydesk with task manager or kill manually on the task bar is useless. Then I try to another way to kill anydesk, with CMD run as administrator, and it works.

Follow this instruction to solve the problem.

Run as administrator on CMD
On CMD
type taskkill /IM anydesk.exe
if not success then taskkill /IM anydesk.exe /F

July 22, 2019

How to unlock weblogic

Filed under: Uncategorized — sikathabis @ 9:39 am
Tags:

–Erase lok file ~ Hapus file lok

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/tmp
rm *.lok

–Erase inside ldap folder ~ hapus file didalam folder ldap

cd /home/oracle/Middleware/user_projects/domains/<domain_name>/servers/AdminServer/data
rm -rf ldap/

–find Middle id (like search in task manager on windows) ~ cari id Middle

ps -ef | grep Middle

kill -9

–start weblogic

sh /home/oracle/Middleware/user_projects/domains/<domain_name>/bin/startWebLogic.sh

June 20, 2019

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

Filed under: Uncategorized — sikathabis @ 3:40 am

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:
20150921_112718-1

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

May 8, 2019

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

Filed under: dev6i,oracle,oracle:12c — sikathabis @ 2:21 am
Tags: , , ,

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>



April 19, 2019

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

Filed under: Uncategorized — sikathabis @ 3:10 pm

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

April 13, 2019

How to access sharing folder using UTL_FILE (Oracle Database)

Filed under: Uncategorized — sikathabis @ 3:07 pm

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

July 6, 2018

PL/SQL: Sleep without using DBMS_LOCK

Filed under: Uncategorized — sikathabis @ 11:50 am

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

February 2, 2018

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

Filed under: oracle,toad — sikathabis @ 7:34 am
Tags: , ,

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:
Clipboard03
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

Next Page »

Blog at WordPress.com.

HyperHCI Tech Blog

HyperHCI Tech Publish trending technology Blogs on Virtualization, Hyper-converged Infrastructure HCI, Nutanix, VMware, Google, Cloud, AWS, Azure etc.

Pureblood

DONT WANNA BE NUMBER ONE

Teknologi Pendidikan

Just another WordPress.com weblog

BLOG KATAKAMI

Jurnalisme Yang Dapat Dipercaya

Tonk Kosonk Baonk Bunyinya

Penampungan Serapah Tanpa Sumpah

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Desa Yang Mencintai Desa dan Kebudayaannya

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

arihdyacaesar

"Tuhan tidak menuntut kita untuk menang. Tuhan hanya meminta kita untuk berjuang tanpa henti.” -ean-

neinframe

Street Photography is like a box of a chocolates, you're never know what you're gonna get - Thomas Leuthard -

Be a good Moeslim

Menuju Pribadi Muslim Sejati yang Bertaqwa

TuanSUFI

Manajemen Sholat, renungan spiritual, Teknologi Informasi

Pelangi di khatulistiwa....

Mari berbagi kebaikan, pengalaman dan senyum denganku

Angkasa13

Ceritanya saya, Pikirannya saya, Hatinya saya

sikathabis

sikathabis semua informasi disini