Mamat Zone

HOME | SITEMAP

Database Instance tidak bisa startup - ORA-011033: ORACLE initialization or shutdown in progress

Posted on 2012-12-28 14:07:39 by mamat, 0 Comments

Database Instance tidak bisa startup - ORA-011033: ORACLE initialization or shutdown in progress

Jika database tidak bisa distart lakukan langkah sebagai berikut:

> sqlplus /nolog

> SQL> connect / as sysdba

Connected.

> SQL> shutdown abort

ORACLE Instance shut down.

> SQL> startup nomount

ORACLE Instance started

> SQL> alter database mount;

> SQL> alter database open;


Jika masih mendapatkan error seperti di bawah ini, lakukan perintah berikutnya:

ORA-00600: internal error code, arguments: [kcratr1_lostwrt]


> SQL> startup mount

ORACLE ...more



Oracle Express ORA-12519 TNS no appropriate service handler found error

Posted on 2012-02-28 13:50:58 by mamat, 0 Comments

Fixing the ORA-12519: TNS:no appropriate service handler found error

1. Masuk ke /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

2. Login sebagai user oracle
Ketik:
su - oracle
3. Ketik:
./sqlplus

4. Masukan Username dan Password
Username : SYSTEM
Password : 112233 <-- kalau gak salah

5. Ketik command berikut:
alter system set processes=300 scope=spfile;
6. Restar Oracle
/etc/init.d/oracle-xe restart ...more



Oracle Data Pump in Oracle Database 10g (expdp and impdp)

Posted on 2012-02-09 13:59:56 by mamat, 0 Comments

Oracle Data Pump in Oracle Database 10g (expdp and impdp)

Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables.

Getting Started

For the examples to work we must first unlock the SCOTT account and create a directory object it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system.
...more



Memanggil ORA_HASH function dalam Trigger

Posted on 2012-01-02 18:42:52 by mamat, 0 Comments




Berikut ini adalah contoh memasukkan function ORA_HASH dalam trigger, keperluannya adalah ketika kita membuat atau mengupdate password otomatis akan merubah password yang dimasukkan menjadi hash.


CREATE OR REPLACE TRIGGER "TGR_HASH_PASSWORD"
BEFORE INSERT OR UPDATE ON T_LOGIN
FOR EACH ROW
DECLARE
NEW_TL_PASS VARCHAR2(64);
BEGIN
SELECT ORA_HASH(:NEW.TL_PASSWORD) INTO NEW_TL_PASS FROM DUAL;
:NEW.TL_PASSWORD := NEW_TL_PASS;
END;
...more



CROSS Query/Join Query Multiple Database ON Oracle

Posted on 2011-12-14 09:57:24 by mamat, 0 Comments

Di ORACLE ada fitur dengan nama database link, memungkinkan kita untuk melakukan query dari database lain.

Untuk melakukannnya kita perlu membuat DATABASE LINK terlebih dahulu.


SQL> create database link DATABASELINKNAME
2 connect to USERNAMEDB identified by PASSWORD
3 using
4 '(DESCRIPTION=
5 (ADDRESS=
6 (PROTOCOL=TCP)
7 (HOST=192.168.10.10)
8 (PORT=1521))
9 (CONNECT_DATA=
10 (SID=DEV)))'
11 /

Database link created.


Contoh Query

select ...more



Menampilkan seluruh Relasi dalam sebuah table di ORACLE

Posted on 2011-08-02 22:21:14 by mamat, 0 Comments


select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name
from all_constraints
where constraint_type='R' and OWNER='KAI3'
and r_constraint_name in (select constraint_name from all_constraints
where constraint_type in ('P','U') and table_name='T4_TABLE')
...more



Oracle Get kamus Data

Posted on 2011-07-15 03:08:59 by mamat, 0 Comments


SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, LAST_ANALYZED
FROM DBA_TAB_COLUMNS
WHERE OWNER = 'KAI'
ORDER BY TABLE_NAME

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH LAST_ANALYZED
------------- ------------------------ ---------------------------- -------------- ----------------
LAPORAN_SLA PEMASUKAN_PENAWARAN_AWAL TIMESTAMP(6) ...more



Alter Table Menambah Auto Increment pada table di Mysql

Posted on 2011-07-08 00:19:40 by mamat, 0 Comments

Berikut ini contoh menambahakan auto incremetn pada table yang mungkin lupa waktu create tidak diberi auto increment.


alter table TABLE_NM add COLUMN_ID Int NOT NULL AUTO_INCREMENT key;
...more