Oracle, Web, Script, SQLserver, Tips & Trick

September 7, 2017

Example how to use expdp

Filed under: dos,oracle,oracle:10g — sikathabis @ 7:07 am

example

set ORACLE_SID=VBSUPG

expdp user/user FULL=y COMPRESS=N DUMPFILE=DMP:USER%U.dmp FILESIZE=2G PARALLEL=4 LOGFILE=DMP:expuser.log JOB_NAME=expuser

Advertisements

September 29, 2014

Cara upgrade Oracle Database 10g 10.2.0.1 menjadi 10.2.0.5

Filed under: oracle,oracle:10g — sikathabis @ 12:01 am
Tags: , ,

Secara garis besar dari dokumen readme.htm

  1. Matikan lsnrctl, matikan enterprise manager console, matikan database
  2. Installasi dari patch yg didownload (setup.exe), kemudian oracle homenya pilih ke lokasi oracle yg mau di patch
  3. Untuk upgrade database terdiri dari Interaktif mode dan manual mode:
    • Untuk interaktif Jalankan dbua pada CMD ~ README.htm#CJAGAIBC (jika ini tidak berhasil lakukan cara dibawah ini
    • Untuk manual (liat di readme.htm utk yg manual) ~ README.htm#CJGGABGI
      1. 10.5.2.1 Run the pre-ugrade information tool ini berfungsi utk pengecekan awal
      2. 10.5.2.2 Upgrading a release 10.2 Database terdiri dari nomor 1 s/d 15, tapi tidak semua dijalankan.  Jalankan nomor 1, 4, 5, 7, 10, 11 dan 15 (jika di perlukan)

Untuk detailnya silahkan baca dari readme.htm atau extract patch 10.2.0.5, ada file readme.htm

Attachment: Readme.htm, hilangkan extension .jpg

August 5, 2014

Oracle Developer 10g troubleshoot Installation (Windows 7)

Filed under: oracle,oracle:10g,windows — sikathabis @ 8:19 pm
Tags: , ,
Clipboard02

If error message show like this then

automatically manage custom size

Advanced System Settings – Advanced – Settings – Advanced – Change uncheck automatically manage – choose and fill the custom size

Reference : http://oracleplatform.blogspot.com/2008/02/oracle-developer-suite-10g-quick.html

February 28, 2013

How to reconfig enterprise manager (Oracle)

Filed under: oracle,oracle:10g — sikathabis @ 11:24 am
Tags: , ,

reconfig EM:

 

1. login ke 123.3.3.38 dgn user oracle

 

cd $ORACLE_HOME

emctl stop dbconsole

mv conven_VBSUPG conven_VBSUPG.OLD

 

sqlplus / as sysdba (more…)

February 19, 2013

Contoh parameter import pump (impdp)

Filed under: oracle,oracle:10g — sikathabis @ 1:04 pm
Tags: , ,

nohup sh 05-impnetlink.sh > 05-impnetlink.sh.out 2>&1 &

userid=’/ as sysdba’
DIRECTORY=DMP
NETWORK_LINK=rac
LOG=DMP:imp-nlik-full.log
FULL=Y
PARALLEL=32
EXCLUDE=STATISTICS
EXCLUDE=TABLESPACE:”LIKE ‘%'”
EXCLUDE=DIRECTORY:”LIKE ‘%'”
EXCLUDE=ROLE:”=’SELECT_CATALOG_ROLE'”
EXCLUDE=ROLE:”=’EXECUTE_CATALOG_ROLE'”
EXCLUDE=ROLE:”=’DELETE_CATALOG_ROLE'”
EXCLUDE=ROLE:”=’RECOVERY_CATALOG_OWNER'”
EXCLUDE=ROLE:”=’GATHER_SYSTEM_STATISTICS'”
EXCLUDE=ROLE:”=’LOGSTDBY_ADMINISTRATOR'”
EXCLUDE=ROLE:”=’AQ_ADMINISTRATOR_ROLE'”
EXCLUDE=ROLE:”=’AQ_USER_ROLE'”
EXCLUDE=ROLE:”=’GLOBAL_AQ_USER_ROLE'”
EXCLUDE=ROLE:”=’SCHEDULER_ADMIN'”
EXCLUDE=ROLE:”=’HS_ADMIN_ROLE'”
EXCLUDE=ROLE:”=’OEM_ADVISOR'”
EXCLUDE=ROLE:”=’OEM_MONITOR'”
EXCLUDE=ROLE:”=’WM_ADMIN_ROLE'”
EXCLUDE=ROLE:”=’JAVAUSERPRIV'”
EXCLUDE=ROLE:”=’JAVAIDPRIV'”
EXCLUDE=ROLE:”=’JAVASYSPRIV'”
EXCLUDE=ROLE:”=’JAVADEBUGPRIV'”
EXCLUDE=ROLE:”=’EJBCLIENT'”
EXCLUDE=ROLE:”=’JAVA_ADMIN'”
EXCLUDE=ROLE:”=’JAVA_DEPLOY'”
EXCLUDE=ROLE:”=’CTXAPP'”
EXCLUDE=ROLE:”=’XDBADMIN'”
EXCLUDE=ROLE:”=’AUTHENTICATEDUSER'”
EXCLUDE=ROLE:”=’OLAP_DBA'”
EXCLUDE=ROLE:”=’OLAP_USER'”
EXCLUDE=ROLE:”=’MGMT_USER'”
EXCLUDE=ROLE:”=’CWM_USER'”
EXCLUDE=SCHEMA:”=’XS$NULL'”
EXCLUDE=SCHEMA:”=’MDDATA'”
EXCLUDE=SCHEMA:”=’ORACLE_OCM'”
EXCLUDE=SCHEMA:”=’DIP'”
EXCLUDE=SCHEMA:”=’APEX_PUBLIC_USER'”
EXCLUDE=SCHEMA:”=’SPATIAL_CSW_ADMIN_USR'”
EXCLUDE=SCHEMA:”=’SPATIAL_WFS_ADMIN_USR'”
EXCLUDE=SCHEMA:”=’DBSNMP'”
EXCLUDE=SCHEMA:”=’SYSMAN'”
EXCLUDE=SCHEMA:”=’FLOWS_FILES'”
EXCLUDE=SCHEMA:”=’MDSYS'”
EXCLUDE=SCHEMA:”=’WMSYS'”
EXCLUDE=SCHEMA:”=’APPQOSSYS'”
EXCLUDE=SCHEMA:”=’APEX_030200′”
EXCLUDE=SCHEMA:”=’OWBSYS_AUDIT'”
EXCLUDE=SCHEMA:”=’OWBSYS'”
EXCLUDE=SCHEMA:”=’ORDDATA'”
EXCLUDE=SCHEMA:”=’ANONYMOUS'”
EXCLUDE=SCHEMA:”=’EXFSYS'”
EXCLUDE=SCHEMA:”=’XDB'”
EXCLUDE=SCHEMA:”=’ORDSYS'”
EXCLUDE=SCHEMA:”=’CTXSYS'”
EXCLUDE=SCHEMA:”=’ORDPLUGINS'”
EXCLUDE=SCHEMA:”=’OLAPSYS'”
EXCLUDE=SCHEMA:”=’SI_INFORMTN_SCHEMA'”
EXCLUDE=SCHEMA:”=’MGMT_VIEW'”
EXCLUDE=SCHEMA:”=’SYS'”
EXCLUDE=SCHEMA:”=’SYSTEM'”
EXCLUDE=SCHEMA:”=’LBACSYS'”
EXCLUDE=SCHEMA:”=’OUTLN'”

nara sumber : Ujang Jaenudin

January 19, 2012

Persiapan Installasi Oracle 10g R2 32 bit pada CentOS 5.4

Filed under: linux,linux:centos,oracle,oracle:10g — sikathabis @ 6:50 am
Tags: , , ,
Referensi cara pengInstallan ada dari 3 website yang paling mutakhir, yaitu :
1. http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnRHEL5.php
2. http://ivan.kartik.sk/oracle/install_ora10gR2_redhat.html
3. http://kamranagayev.com/2009/05/01/step-by-step-installing-oracle-database-10g-

PRAKATA
Tulisan ini ditujukan untuk orang yang mencari cara setting awal pada linux/centOs 5.4 untuk dapat Installasi Oracle Database di PC/SERVER/VMWARE/VIRTUALBOX, dan dianggap dalam hal ini untuk Installasi Oracle Database sudah bisa (tanpa perlu panduan).

KRONOLOGIS
Setelah hampir seminggu utak-atik OS linux bernama CentOS di VMWARE, akhirnya pilihan itu jatuh pada referensi no 3, dengan otomatis installation menggunakan shell script. Hanya saja saya memodifikasi script install.sh nya, karena terdapat masalah didalamnya terkait penggunaan karakter ” dan $ . Kemudian perubahan juga terjadi folder ORACLE_BASE-nya, disesuaikan dengan referensi nomor 1, yang terakhir perubahan pada installasi RPM … ditambahkan referensi dari nomor 1.Setelah proses Installasi selesai, ada juga settingan port, hostname pada listener dan tnsnames serta firewall yang harus di exception-kan port 1521.

Script otomatis sendiri terbagi menjadi 2 yaitu : install.sh dan install_zip.sh (pada attachment)
1. Install.sh untuk posisi source database oracle sudah ter-extract
2. Install_zip.sh untuk posisi source database oracle masih posisi dalam bentuk zip file

Langkah-langkah
1. Install CentOS, setelah selesai, rubah ip dengan ip statis, dengan cara click menu pada kiri atas, Click System – Administration – Network. Rubah IP dengan contoh : (more…)

January 5, 2012

exp query oracle

Filed under: oracle,oracle:10g,oracle:9i — sikathabis @ 2:36 am
Tags: , , ,

If you are using QUERY for export sometimes confusing with error on the syntax

this is the simple example form parfile and from command

parfile

query=”where to_char(tanggal,’YYYY’)=’2002′”

command

exp user/password@db query=\”where to_char(tanggal,’YYYY’)=’2002’\”

July 1, 2011

how to know oradata location / directory from cmd

Filed under: oracle,oracle:10g — sikathabis @ 11:31 pm
Tags: ,
How to know oracle data directory from cmd

select * from v$controlfile;

select * from v$tablespace;

select * from v$database;

select * from dba_tablespaces;

select distinct SEGMENT_TYPE from dba_segments;

select distinct CONTENTS from dba_tablespaces;

set pagesize 0 
set serveroutput off
spool _datadir_.txt 
select substr(file_name,1,instr(FILE_NAME,(select upper(VALUE)
from V$PARAMETER
where upper(name)='DB_UNIQUE_NAME'))-1)||(select upper(VALUE)
from V$PARAMETER
where upper(name)='DB_UNIQUE_NAME')||'\' LOKASI 
from dba_data_files where rownum=1;
spool off 
EXIT; 
select * from dba_data_files where rownum=1 and instr(file_name,'UNDO')>0;

select upper(VALUE)
from V$PARAMETER
where upper(name)='DB_UNIQUE_NAME'

select * from dba_data_files;

select * from dba_temp_files;

select NAME,VALUE from v$parameter where NAME ='control_files';

select * from v$CONTROLFILE_RECORD_SECTION

June 16, 2011

How to install Oracle 10g on Windows 7 32bit 64bit (Video)

Filed under: oracle,oracle:10g,windows — sikathabis @ 3:57 am
Tags: , ,

Bagaimana cara Install Oracle 10g pada windows 7 32 bit dan 64 bit

link download:
http://www.ziddu.com/download/15373260/HowtoinstallOracle10gonWindows732bit64bit.flv.html
Link youtube :
http://www.youtube.com/watch?v=2Thx4r4elH8

April 7, 2011

Examples of Using Data Pump Export

Filed under: oracle,oracle:10g — sikathabis @ 7:00 pm
Tags: ,

Performing a Table-Mode Export

Example 2–1 shows a table-mode export, specified using the TABLES parameter. Issuethe following Data Pump export command to perform a table export of the tablesemployees and jobs from the human resources (hr) schema:

Example 2–1 Performing a Table-Mode Export

expdp hr/hr TABLES=employees,jobs DUMPFILE=dpump_dir1:table.dmp NOLOGFILE=y

Because user hr is exporting tables in his own schema, it is not necessary to specify theschema name for the tables. The NOLOGFILE=y parameter indicates that an Export logfile of the operation will not be generated.

Data-Only Unload of Selected Tables and Rows

(more…)

Next Page »

Blog at WordPress.com.

Learning is not a spectator sport

Connor McDonald's Oracle blog

Teknologi Pendidikan

Just another WordPress.com weblog

KATAKAMI

Jurnalisme Yang Dapat Dipercaya

Qey050489's Blog

Ayo Bangkit sobat..!!!!!

B. S. Totoraharjo

Orang Bodoh Yang Tak Kunjung Pandai

culturekitchen foodlab

New Food and Art in Yogyakarta

Wahyu Catur Wibowo

Musafir Dunia Maya

SQL.... Still Learning

My Reference on SQL Server

arihdyacaesar

"A distance is getting far if your heart is impatient" -ean-

neinframe

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

Keluarga Andrivito

-- Andrivito's Journal --

DRK™

This site is about Latest NEWS, Articles, Videos, Books, Course, Presentations, Tips & Tricks related to I.T Pro's

Gaurav Saxena

|| तत् त्वम् असि ||

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