S3L4M47 H4R1 R4Y4 – 2010 / 1431 H
Komen (1) “SELAMAT MENYAMBUT HARI RAYA AIDILFITRI”
KEPADA SELURUH UMAT ISLAM
PADA TAHUN 2010 @ 1431 H
~MAAF ZAHIR & BATIN~
Komen (1) “SELAMAT MENYAMBUT HARI RAYA AIDILFITRI”
[Database] Oracle 10g XE: Cara setup sendiri pada localhost
Aplikasi :
ORACLE 10g XE (Express Edition) Release 10.2.0.1.0 - Production on Thu Sep 2 23:14:25 2010.
Masalah :
Tak dapat access ke database home page ( http://127.0.0.1:8080/apex ) untuk table HR.
================================================================================
Penyelesaian:
================================================================================
1. Cuba login sebagai ‘sysdba‘ ke dalam Oracle. Buka ‘SQL Command Line’ daripada Oracle:
SQL>conn sys as sysdba
Login berjaya. Output yang diperolehi tanpa masalah. Tak ada masalah:
Connected to an idle instance.
2. Hidupkan database (pengkalan data).
SQL > startup
Output didapati mempunyai masalah, iaitu tiada fail ‘spfileXE.ora’:
ORA-01078: failure in processing system parameters ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.
4. Periksa listening pada aplikasi Oracle… buka
cmd dan taipkan:
lsnrctl stat
Contoh output yang masokis dapat:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production Start Date 02-SEP-2010 14:13:38 Uptime 0 days 1 hr. 27 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Windows7-64bit)(PORT=1521))) Services Summary... Service " CLRExtProc" has 1 instance(s). Instance " CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service " PLSExtProc" has 1 instance(s). Instance " PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully..
Daripada sini, dapat kesan PIPENAME takde berhubung…. HOST yang ke-3 ( localhost @ 127.0.01) bersama-sama port 8080 tak ada. hmmm.. kita abaikan dulu kat sini…
5. Dalam langkah 2 & 3 tadi, kita dapati tiada fail yang diperlukan untuk ‘startup‘ pengkalan data. Kita cuba init dengan fail Oracle yang ada.
Caranya..maximize balik SQL Command Line..masukkan arahan :
startup pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';
Maknanya lepas ni,’startup’ terus dari folder ni ( Kalau default, kat lain mcm error sebelum ni)
ok, database dah mount (mcm pendrive @ hdd pulak)… contoh output yang masokis dapat.
ORACLE instance started. Total System Global Area 503316480 bytes Fixed Size 1288264 bytes Variable Size 142608312 bytes Database Buffers 356515840 bytes Redo Buffers 2904064 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Huh..entah database mana pulak mount tu.. (Masokis ada test masuk localhost masa
ni. Tapi masih lagi tak dapat. Rasanya, bukan db HR yang mount) Tak apa… Sila abaikan dahulu.
6.Wekeh cun.. try buat fail baru..replace kat tempat yang masalah tadi kita tengok, jadi atau tak.., masuk SQL Command Line balik, taip:
SQL> create spfile='C:\oraclexe\app\oracle\product\10.2.0\server\dbs/spfileXE.ora' 2 FROM 3 pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora';
*Nota : Masukkan arahan baris per baris. Jangan serentak sekali gus… : P
Kemudian..kita restart balik Oracle :
SQL> shutdown immediate SQL> startup
7. Try masuk ke homepage database ( http://127.0.0.1:8080/apex/ ) balik.. uik, ada perkembangan..hehe.. dah
boleh access (dah tak paparkan ‘page not found’) tapi dia akan redirect ke http://127.0.0.1:8080/apex/apex pulak.. (tu pun xkuar apa-apa). Oh..!
8. kat langkah 5 ada database yang tak sengaja, mount masa proses tadi..Tujuan kita ialah hendak masuk pada homepage database tu. Table HR tu ialah pengkalan data yang default dipasang. So kita
akan setup balik sebagai default kepada database. Caranya… buka CMD, taipkan:
cd C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\
Kemudian..kita akan jalankan 1 skript .BAT yang memang sedia ada dan telah digubah semasa proses installasi. Pada cmd tu. masukkan
arahan:
XE.bat
Ni paparan penuh arahan tu..jangan keliru pula:
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Windows7>cd C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\
C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts>XE.bat
Adding user to ORA_DBA group...
Unable to create a create group, OS Error = 5
Creating Directories...
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\adump already exists.
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\bdump already exists.
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\cdump already exists.
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\dpdump already exists.
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\pfile already exists.
A subdirectory or file C:\oraclexe\app\oracle\admin\XE\udump already exists.
A subdirectory or file C:\oraclexe\app\oracle\product\10.2.0\server\dbs already exists.
A subdirectory or file C:\oraclexe\oradata\XE already exists.
Creating Instance...
Starting Instance...
Database creation in progress...
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and force - whether to overwrite existing file (opt),
OPERs (opt),
There are no spaces around the equal-to (=) character.
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 3 09:59:21 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter value for 1:
Skript ni sudah mempunyai maklumat diperlukan (Enter value 1 & 2) Jadi jangan risau. Tekan je enter..biarkan ia menjadi null. setiap kandungan skript ni berbeza pada setiap komputer..pasal script ni
generate masa memula install.
9. Kita ulang step 4. Nak lihat @ uji sama ada table HR sudah listen bersama-sama dengan localhost dan port yang betul (ikut step 4). Bawah ni output masokis:
Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Windows7>lsnrctl stat LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-SEP-2010 10:06:13 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production Start Date 03-SEP-2010 09:34:24 Uptime 0 days 0 hr. 31 min. 53 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Windows7-64bit)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "XEXDB" has 1 instance(s). Instance "xe", status READY, has 1 handler(s) for this service... Service "XE_XPT" has 1 instance(s). Instance "xe", status READY, has 1 handler(s) for this service... Service "xe" has 1 instance(s). Instance "xe", status READY, has 1 handler(s) for this service... The command completed successfully
10. Wokeh..semua dah siap. cuba masuk ke lamang sesawang http://127.0.0.1:8080/apex/ .
Amacam ? Wokeh..dah berjayakan…. hehe…taniah semua… Wassalam r0x!
********************************************************************************
Kesimpulan :
Masalah berjaya selesaikan…tapi melalui cara sendiri. Cara ni mungkin terlalu panjang. Rasanya ada cara lain. Masokis kongsi kat sini, untuk berkongsi balik macamna masokis susah-payah selesaikan
masalah ni… fuh..susah jugak nak uruskan Oracle ni 
********************************************************************************
0racle, Database, Pengaturcaraan, Pentabiran
| 
0racle, DIY, Personal, Sekuriti, VB
Oh..programming
~ HARI-HARI BUAT PROGRAMMING,BILALAH NAK JADI PROFESIONAL ~
[Tut] Celcom + Facebook
Assalamualaikum & salam sejahtera…
Untuk pengguna CELCOM yang mahu mengunakan akaun FB pada telefon bimbit sendiri : Cara => Taip 'F' kemudian hantar ke 32665 ( Cas RM1 / minggu / unlimited post) Untuk menamatkan servis ini pula: Cara => taip 'STOP FB' kemudian hantar 32665 (Cas RM2 pula dikenakan)
Nota:
Dulu masokis rasa, pasang FB pada HP ni memang leceh , mahal & habiskan kreadit. Tapi bila renung2 balik. Ni jelah cara masokis nak share @ dapatkan maklumat kalau offline. Tambahan pula ada kes penyamun sekitar rumah sewa baru-baru ni (Siap kuar paper..beb). Lagipun RM1 je telan.. nak post @ apa2 kat FB dah unlimeted. So..fikir2, xde hal la kan? ..r0x! Wassalam….
