Search This Blog

Saturday, October 31, 2015

MS. Project / Primavera trainer in bandung

Hery Purnama 081223344506, is trainer of Project Management with MS. Project or Primavera P6, methodology and project management 

Contact :

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Noor Hotel Bandung Boutique Hotel

Noor Hotel Bandung , prestisius boutique hotel in bandung, Jl. Madura no.06 Bandung.

www.noorhotels.com


The Classy Islamic Boutique Hotel with Green Concept, beautifully designed rooms, friendly service and attentive to every detail are some of the benefits of The Noor Bandung.

Located at the intersection of business and commercial district, in the heart  of Bandung, The Noor Bandung is near to popular shopping centres especially famous factory outlets in Riau Road area, the heaven for shopaholics, restaurants and other entertainment places, Taking five minutes on foot from the hotel, there is a famous Mosque, Istiqomah and it only takes 15 minutes driving from the Hussein Sastranegara International Airport to the hotel.


Review by


Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Friday, October 30, 2015

Android Studio Freelance trainer Jakarta

Hery Purnama is trainer for training " Android Application Development with Android Studio ", for inquiry please contact

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Hometown : Bandung

Freelance Python Trainer di Jakarta, Bandung, Bali

Hery Purnama, 081223344506 is freelance trainer for training "Programming with Python ", inquiry please contact

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse PythonTrainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Freelance Java Trainer

Hery Purnama, 081223344506, Freelance Java Web/ Java Mobile Trainer in Jakarta, Bandung, Indonesia,
For inquiry for inhouse training, please contact :

HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse Java Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Freelance Trainer C++ di Jakarta, Bandung

Hery Purnama 081223344506, is freelance IT Trainer for programming with C++ , Inquiry please

contact

HERY PURNAMA
MCDBA, CPMP, ITILF
C++ Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Thursday, October 29, 2015

Mysql DBA freelance Trainer Bandung

Hery Purnama, 081223344506, MySql DBA trainer , topics, mysql server configuration, mysql backup recovery, mysql performance tuning, mysql clustering

for detail syllabuss and inquiry please contact


Hery Purnama
MCDBA, CPMP, ITILF

Freelance IT Trainer


Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Training Oracle DBA di Bandung

Terima kasih kepada peserta dari PT. PJB service surabaya yang telah mengikuti pelatihan Oracle 11g Administration workshop I  di sisindotek bandung, semoga bermanfaat

Regards,

Hery Purnama

MCDBA, CPMP, ITILF

Oracle DBA freelance trainer

Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Project Management based on Prince2 , jakarta bandung trainer

PRINCE2 trainer, Project Management training Jakarta , bandung, bogor, bekasi, karawang, makasar, yogya, surabaya, balikpapan

Contact

HERY PURNAMA
Inhouse IT Trainer
Call/sms/WA :
081.223344.506 , 022.91299407
PinBB : 7DC633AA
Email/YM : info@inhousetrainer.net / inhousetrainer@yahoo.com
http://www.inhousetrainer.net
facebook.com/inhousetrainer
twitter.com/inhousetrainer


Office : Bandung

Wednesday, October 28, 2015

Tutorial Backup Recovery Oracle 11g , Enterprise Manager


Berikut yang perlu anda lakukan untuk melakukan backup restore, recovery di Oracle 11g menggunakan Enterprise Manager dimana meliputi konfigurasi (Flash Recovery Area + Mode Archive, Recovery Setting, Backup Setting), silahkan Anda praktekkan


Flash Recovery Area dan mode ARCHIVELOG 


Flash Recovery area dibutuhkan saat anda melakukan proses backup recovery untuk mode archivelog. Flash recovery area juga dikenal dengan istilah fast recovery area

Lokasi Flash Recovery Area seharusnya tidak berada satu tempat dengan database working area

Berikut konfigurasi flash/fast recovery area dan Archivelog Mode

 

1.         Melalui Command prompt perbesar size dari backup and recovery area, dengan perintah

sqlplus system/<password>

alter system set db_recovery_file_dest_size=8G scope=both;

exit

 

2.         Buat folder flash_recovery_area melalui command prompt, contoh:

C:\> set ORACLE_BASE=d:\app\administrator\

cd $ORACLE_BASE

mkdir flash_recovery_area

 

 

3.         Log in ke  Enterprise Manager Database Console melalui browser , gunakan username SYS SYSDBA. Click Login.

 

4.         Click Availability setelah login web

 

5.         Pilih  Recovery Settings di  Backup/Recovery Settings section.

 

6.         Recovery Setting Page muncul dan perhatikan settingan yang tertera

Flash Recovery Area Location: d:\app\administrator\flash_recovery_area
Flash Recovery Area Size: 8 GB

 

7.         Scroll ke atas . Check ARCHIVELOG Mode untuk mengubah ke mode Archivelog. Click Apply.

 

8.         Untuk verifikasi isikan user dan password windows (OS) login Anda. Click Continue.

 

9.         Sebuah pesan akan muncul, untuk menyelesaikan perubahan mode maka anda perlu shutdown database, Click Yes untuk  shut down instance dan melakukan restart.

 

10.       Untuk restart database anda akan diminta isikan user dan password windows dan database anda . Click OK.

 

11.       Restart Database:Confirmation page akan muncul. Click Yes untuk  shut down instance dan melakukan kembali restart.

 

12.       Halaman restart database kembali muncul. Click Refresh untuk login ke Enterprise Manager Database Control dan  login kembali ke Enterprise Manager begitu  database telah selesai restart.

 

Backup Settings and Policy

Anda dapat mensetting backup dan beberapa policy terkait lokasi backup, bagaimana proses backup, waktu melakukan backup dan lainnya.

1.

Click Availability di home page.

 

2.

Pilih  Backup Settings dibagian Backup/Recovery Setup section.

 

3.

Scroll ke the Host Credentials di halaman Backup Settings. Isikan operating system username dan password. Scroll ke atas ke bagian Disk Settings.

 

4.

Biarkan nilai tetap 1 di Parallelism field. Disk Backup Location field biarkan tetap null agar menggunakan settingan flash recovery area untuk backup. Pilih Backup Set untuk Disk Backup Type. Click Test Disk Backup.

 

5.

Sebuah pesan sukses akan muncul apabila proses test disk backup berhasil. Selanjutnya anda akan configure backup policy settings. Click Policy to access the Policy page.

 

6.

Pilih  Automatically backup the control file and server parameter file (SPFILE) with every backup and database structural change.
Pilih Optimize the whole database backup by skipping unchanged files such as read-only and offline datafiles that have been backed up.
Pilih Enable block change tracking for faster incremental backups.
Isikan nama file Block Change Tracking file. Lalu scroll kebawah kebagian Retention Policy section.

 

7.

Pilih Retain backups that are necessary for a recovery to any time within the specified number of days (point-in-time recovery) biarkan saja nilai hari tetap 31 days. Di bagian Archivelog Deletion Policy, Pilih Delete archivelogs after it has specified number of backups dan biarkan nilai tetap terisi "1 backup". Click OK. Anda akan diarahkan kembali ke halaman availability.

 

DBID dan DB_UNIQUE_NAME

Jika anda kehilangan control file atau SPFILE, Enterprise Manager dapat mengembalikannya dari backup sepanjang anda masih mengetahui DB_UNIQUE_NAME dan DBID database anda, silahkan ingat atau catat informasi DB_UNIQUE_NAME dan DBID anda terlebih dahulu

Untuk mengetahuinya lakukan tahapan berikut

1.

Click Server tab. Click Initialization Parameters di  Database Configuration region.

 

2.

The Current property page muncul. Ketik db_unique_name dibagian Name field dan click Go.

 

3.

Baris record akan muncul  db_unique_name di kolom Name, dan nilai db_unique_name akan terlihat silahkan catat/ ingat

Click Database Instance link untuk kembali ke Server page.

 

Untuk mengecek nilai DBID:

1.

Click Control Files di Storage region pada halaman Server.

 

2.

Pada halaman control file yang muncul . Pilih Advanced property link.

 

3.

Database ID field berisi nilai DBID akan muncul. (Note: Nilai berbeda untuk setiap mesin, silahkan catat juga).

Click the Database Instance link untuk kembali ke halaman server

 

Whole Database Backup

Keseluruhan content database mencakup datafile, redolog file, control file, parameter file dapat anda backup dengan menggunakan "Whole Database Backup"

1.

Click Availability tab. Pilih Schedule Backup dibagian Manage.

 

2.

Halaman Schedule Backup page akan muncul. Di bagian Customized Backup, Pilih Whole Database. Isikan username dan password di bagian host credential. Click Schedule Customized Backup.

 

3.

Halaman Schedule Customized Backup: Options akan muncul . Pilih  Full Backup di bagian Backup Type. Pilih Online Backup di bagian Backup Mode. Pilih Also back up all archived logs on disk dibagian Advanced. Click Next.

 

4.

Halaman Schedule Backup: Settings akan muncul . Pilih Disk or Tape sesuai yang telah anda tentukan sebelumnya. Click Next.

 

5.

Halaman Schedule Backup: Schedule page akan muncul . biarkan saja nilai default Job Name. Pilih  One Time (Immediately) untuk menjalankan backup job immediately atau isikan waktu eksekusi yang anda rencanakan , Click Next.

 

6.

Halaman Schedule Backup: Review akan muncul. Click Submit Job.

 

7.

Backup Submit Successful message akan muncul . Click View Job untuk lihat status dari backup.

 

8.

Scroll ke bagian bawah halaman. Didalam table anda akan melihat status dari setiap proses backup can view the status of the backup akan success apabila setiap fase selesai. Perlu diketahui bahwa proses ini akan memakan waktu . Lakukan Refresh halaman browser untuk melihat progress Job .

Sebelum melanjutkan tahap berikutnya pastikan (Prebackup, Backup, and Post Backup) telaj selesai (successful).

Click Database tab untuk kembali ke Database Home page.

 

Restore dan Recovery dengan "Whole Database"

Pada bagian ini anda akan belajar by using melakukan recovery dengan enterprise Manager.

1.

Pilih Perform Recovery  di bagian Manage dari halaman Availability.

 

2.

Halaman Perform Recovery akan appears. Di bagian bawah Recovery Scope, pilih Whole Database. Pilih  Recover to the current time or a previous point-in-time. Isikan user dan password OS anda  di bagian Host Credentials. Click Recover.

 

3.

Pada halaman  Confirmation yang muncul berisi indikasi bahwa instance akan di shut down dan di restart. Click Yes untuk lanjutkan.

 

4.

Halaman  Recovery Wizard yang muncul yang mengindikasikan instance akan di shut down dan  restart (Note: Anda harus menunggu beberapa menit untuk proses ini sampai complete). Click Refresh untuk lanjutkan tahap Recovery Wizard.

 

5.

Selanjutnya halaman Database Instance akan menampilkan database dalam kondisi Mounted state. Click Perform Recovery.

 

6.

Enter user dan password OS host credentials and click Continue.

 

7.

Database Login window yang muncul .isi informasi Login database dengan user sys as sysdba

 

8.

Halaman Perform Recovery akan muncul.Pada bagian pilihan Recovery Scope pilih Whole Database dan  click Recover kembali untuk mengulang tahapan Recovery wizard.

 

9.

Halaman Perform Whole Database Recovery: Point-in-time akan terlihat. Pilih Recover to the current time. Click Next.

 

10.

Halaman Perform Whole Database Recovery: Rename akan terlihat. Pilih No. Restore the files to the default location atau Yes. Jika anda ingin file restore ditempatkan di lokasi lain. Click Next.

 

11.

Halaman Perform Whole Database Recovery: Review akan terlihat. Review informasi akan munculu dan click Submit.

 

12.

Halaman  Processing: Perform Whole Database Recovery akan muncul.

 

13.

Lalu anda akan menerima konfirmasi bahwa aktifitas recovery sudah sukses. Click Open Database.

 

14.

Click OK.

 

15.

Isikan informasi login seperti yang sering anda lakukan . Click Login. Selanjutnya anda akan masuk kembali ke halaman Availability.

Proses recovery selesai

Selamat mencoba, semoga bermanfaat

 



Penulis,

Hery Purnama

Freelance Oracle DBA Trainer
www.inhousetrainer.net

http://freelance-it-trainer.blogspot.co

Call/WA/SMS : 081.223344.506
PinBB : 7DC633AA
Email/YM : inhousetrainer@yahoo.com

 

 

 

 

 

Membuat Database Oracle 11g secara Manual di Windows

Berikut cara membuat database baru di Oracle 11g R2 secara manual tanpa DBCA, ikuti tahapannya :

Tahap 1 SIAPKAN ENVIRONMENT VARIABLE
C:\>set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_sisindotek
C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
C:\>set ORACLE_SID=MYORA

Tahap 2 BUAT DIREKTORI YANG DIBUTUHKAN

C:\>mkdir C:\app\Administrator\db\myora\admin\adump
C:\>mkdir C:\app\Administrator\db\myora\admin\dpdump
C:\>mkdir C:\app\Administrator\db\myora\admin\pfile
C:\>mkdir C:\app\Administrator\db\myora\diag
C:\>mkdir C:\app\Administrator\db\myora\flash_recovery_area
C:\app\Administrator\db\myora\oradata

Tahap 3 BUAT PARAMETER FILE
berikan nama initmyora.ora dan simpan di folder {ORACLE_HOME}\database\

db_name='MYORA'
db_block_size=8192
memory_target=500m
processes=100
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
compatible ='11.1.0'
audit_trail ='db'
db_recovery_file_dest_size=5g
db_recovery_file_dest='C:\app\Administrator\db\myora\flash_recovery_area'
audit_file_dest='C:\app\Administrator\db\myora\admin\adump'
diagnostic_dest='C:\app\Administrator\db\myora\diag'
control_files = ('C:\app\Administrator\db\myora\oradata\control1.ctl', 'C:\app\Administrator\db\myora

\oradata\control2.ctl', 'C:\app\Administrator\db\myora\oradata\control3.ct




Tahap 4 BUAT WINDOW SERVICE

C:\>oradim -NEW -SID myora -STARTMODE manual
Instance created.
 
C:\>sc query oracleservicemyora
 
SERVICE_NAME: oracleservicemyora
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE,PAUSABLE,ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0




Tahap 5 Konek ke Instance dan buat spfile
C:\>sqlplus
 
SQL*Plus: Release 11.1.0.1.0 Production on Wed May 23 07:39:54 2012
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Enter user-name: /as sysdba
Connected to an idle instance.
 
SQL> create spfile from pfile;
 
File created.




Tahap 6 - START INSTANCE DALAM MODE NOMOUNT

SQL> startup nomount
ORACLE instance started.
 
Total System Global Area  523108352 bytes
Fixed Size                  1375704 bytes
Variable Size             314573352 bytes
Database Buffers          201326592 bytes
Redo Buffers                5832704 bytes



Tahap 7 - BUAT DATABASE
gunakan script berikut


CREATE DATABASE MYORA
    USER sys IDENTIFIED BY sys
    USER system IDENTIFIED BY system
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 200
    MAXINSTANCES 1
    MAXLOGHISTORY 500
LOGFILE
GROUP 1 (
    'C:\app\Administrator\db\myora\oradata\redo01a.rdo',
    'C:\app\Administrator\db\myora\oradata\redo01b.rdo'
    ) SIZE 50M,
GROUP 2 (
    'C:\app\Administrator\db\myora\oradata\redo02a.rdo',
    'C:\app\Administrator\db\myora\oradata\redo02b.rdo'
    ) SIZE 50M,
GROUP 3 (
    'C:\app\Administrator\db\myora\oradata\redo03a.rdo',
    'C:\app\Administrator\db\myora\oradata\redo03b.rdo'
    ) SIZE 50M
DATAFILE 'C:\app\Administrator\db\myora\oradata\system01.dbf' SIZE 100M AUTOEXTEND ON
NEXT 50K
MAXSIZE 100M
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'C:\app\Administrator\db\myora\oradata\sysaux01.dbf' SIZE 200M
UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\app\Administrator\db\myora\oradata\undotbs01.dbf' SIZE 300M AUTOEXTEND OFF
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\app\Administrator\db\myora\oradata\temp01.dbf' SIZE 200M REUSE AUTOEXTEND OFF
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8;



Tahap 8 Buat data dictionary object
Jasalankan catalog.sql dan catproc.sql yang ada di folder RDBMS oracle home andag


SQL> @%ORACLE_HOME%\rdbms\admin\catalog.sql
SQL> @%ORACLE_HOME%\rdbms\admin\catproc.sql
SQL> connect system/system
SQL> @%ORACLE_HOME%\sqlplus\admin\pupbld.sql


Tahap 10 enabled archive

SQL> connect /as sysdba
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
 
Total System Global Area  523108352 bytes
Fixed Size                  1375704 bytes
Variable Size             314573352 bytes
Database Buffers          201326592 bytes
Redo Buffers                5832704 bytes
Database mounted.
SQL> alter database archivelog;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     12
Next log sequence to archive   13
Current log sequence           13



Oleh :

Hery Purnama
Freelance IT Trainer
http://freelance-it-trainer.blogspot.com
http://www.inhousetrainer.net
Call/SMS/WA : 081223344506
PinBB : 7DC633AA
email : inhousetrainer@yahoo.com


Tuesday, October 27, 2015

Trainer freelance Prince, ITIL, COBIT, TOGAF, PMBOK, PMO, ITPM , jakarta bandung

Freelance trainer for soft skill FRAMEWORK topics : PRINCE, ITIL, COBIT, TOGAF, PMBOK, PMP, ITPM, PMO, SQA 

JAKARTA, BANDUNG, MAKASAR, BALI, MEDAN, INDONESIA, MALAYSIA, SINGAPORE

for inquiry please contact :


Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Trainer MS. Access di jakarta, bandung, bekasi, bali, medan, indonesia


Hery Purnama, 081223344506, freelance trainer MS.Access Database Fundamental or Programming MS.Access VBA Macro, Bandung - Jawa Barat

Details : www.inhousetrainer.net
   

Friday, October 23, 2015

Trainer Oracle DBA workshop 1

Hery Purnama 081223344506 , freelance trainer for  Oracle DBA topics , fundamental PL/SQL, workshop I, workshop II ,  Performance tuning.

other details please access http://inhousetrainer.net
   

Thursday, October 22, 2015

Trainer Web Java ajax with xml and json

Hery Purnama , 081.223344.505 , freelance Trainer for training web java , ajax, xml or json

Inhouse trainer for location Jakarta, bandung, surabaya, balikpapan, makasar, menado and other city in Indonesia, singapore, malaysia

For inquiry please contact
+62.81223344506
PinBB 7dc633aa

inhousetrainer@yahoo.com
inhousetrainer.net

Cari trainer ITIL, COBIT , PMBOK, PMO, ITPM, TOGAF , CPMP

Hery Purnama, 081.223344.506 , freelance certified trainer for PMBOK, ITIL V.3/2011, ITPM, TOGAF, CPMP, PMP

Location Jakarta , Bandung, Medan, Semarang, Makasar, Surabaya, Ambon, Indonesia

for inqury please contact
HERY PURNAMA

Freelance IT Trainer
Call/WA : 081.223344.506
pinBB : 7DC633AA

inhousetrainer@yahoo.com
www.inhousetrainer.net
http://freelance-it-trainer.blogspot.com

"..Dedicated to share..."

Inhouse training CATIA 3D V5 di ESDM jakarta

Terima kasih kepada staff dan manajemen LITBANG ESDM jakarta dan Sciencom training center Jakarta atas undangan mengajar CATIA 3D V5 yang berlangsung selama 4 hari

Semoga bermanfaat

Hery Purnama, MCDBA, CPMP, ITILF
CATIA Freelance Trainer
081.223344.506
http://inhousetrainer.net

Hometown : Bandung - Jawa Barat
   

Tuesday, October 13, 2015

catia v5 trainer freelance

Hery Purnama , 081223344506, catia 3d trainer, mechanical design, drafting, modelling, structure analysis

freelance trainer for catia v5

Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

PMBOK Freelance Trainer Jakarta, Bandung

Project Management Body of Knowledge , PMBOK trainer, for inquiry please contact HERY PURNAMA 081.223344.506 , Other topics are PMO , ITPM, ITIL, COBIT, TOGAF, PRINCE


Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Monday, October 12, 2015

Google play excel vba macro

zu y aaTutorial excel vba maco is available in google play. download at https://play.google.com/store/apps/details?id=net.inhousetrainer.excelmacro

Regards,

Hery Purnama
MCDBA, CPMP, ITILF
Tel/WA : 081.223344.506
pinBB : 7DC633AA

www.inhousetrainer.net
inhousetrainer@yahoo.com


Hometown : Bandung

Create a Keystore for Phonegap Signing your build using a java utility called "keytool"


1)    Find keytool (it comes with java). I found mine at: C:\Program Files (x86)\Java\jre6\bin

  2)  Open command prompt and enter the following commands

        cd C:\Program Files (x86)\Java\jre6\bin

    (use whatever dir you found the keytool in)

        keytool -genkey -v -keystore C:\DIR\APPNAME.keystore -alias APPNAME -keyalg RSA -keysize 2048 -validity 10000

    (Change DIR and APPNAME to something appropriate)

  3)  Enter the keystore password (remember this)
    Answer the questions about yourself: your name, organization, location, etc.
    DONE: The keystore will be created for your app

Remaining Steps:

    1. Upload that to PhoneGap Build.
    2. Unlock the keystore for 1 hour by entering your keystore password
    3. Build the app

This will create a release version of the .apk that can be uploaded to Google Play.



By Hery Purnama
Freelance IT Trainer

Sunday, October 11, 2015

Saturday, October 10, 2015

Adobe Dreamweaer CS 5.5 , not responding some how

Issue

When you try to open a document in Dreamweaver CS5 or CS5.5, it takes anywhere from 30 seconds to several minutes for Dreamweaver to open it. Dreamweaver stops responding until the document opens.
To the top
Solution

Disable Dreamweaver's Resolve To IP Address feature using the instructions for your operating system.
===========

Mac OS

Quit Dreamweaver.
In the Finder, navigate to the following location:



/Users/Your User Name/Library/Preferences


Open the Adobe Dreamweaver CS5 Prefs file (CS5) or the Adobe Dreamweaver CS5.5 Prefs file (CS5.5) in TextEdit.
Locate the [REMOTE DOWNLOAD] section in the file. It looks similar to the following:



[REMOTE DOWNLOAD]

remotedownloadcachesize=50

remotedownloadallow=TRUE


At the bottom of this section, add a line that says: resolveremoteurltoipaddress=FALSE

The [REMOTE DOWNLOAD] section now looks like the following:



[REMOTE DOWNLOAD]

remotedownloadcachesize=50

remotedownloadallow=TRUE

resolveremoteurltoipaddress=FALSE


Save the file, and then quit TextEdit.

Windows

Disclaimer: These steps require you to modify the Windows registry, which contains critical information about your system and applications. Before modifying the registry, always make a backup copy of it. Adobe doesn't provide support for problems that arise from improperly modifying the registry. For information about the Windows registry, see the documentation in Windows or contact Microsoft Technical Support or your computer's manufacturer.

Exit Dreamweaver.
Choose Start > Run (Windows XP) or click Start (Windows 7/Vista).
Type regedit and then press Enter.
In the left pane of the Registry Editor, navigate to one of the following registry keys:



CS5.5: HKEY_CURRENT_USER\Software\Adobe\Dreamweaver CS5.5\Remote Download



CS5: HKEY_CURRENT_USER\Software\Adobe\Dreamweaver CS5\Remote Download


Click to select the Remote Download key on the left.
Choose Edit > New > String Value.
Name the new string value: ResolveRemoteURLToIPAddress
Double-click the new ResolveRemoteURLToIPAddress string value.
Enter FALSE for the value data, and then click OK.
Exit the Registry Editor.


source from : https://helpx.adobe.com/dreamweaver/kb/hang-opening-document-dreamweaver-cs5.html
Requoted by :


HERY PURNAMA
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Office :
Graha Rifai , Jl. Pelajar Pejuang 45 No.23 Lt.2
Bandung - Jawa Barat

Thursday, October 8, 2015

Install , download Catia V6r2009 , JS0Group.dll

Solved ! : Download and install Catia V6r2009.
What is Catia 3D ? CATIA, powered by Dassault Systèmes' 3DEXPERIENCE platform, delivers: A Social design environment built on a single source of truth and accessed through powerful 3D dashboards that drive business intelligence, real-time concurrent design and collaboration across all stakeholders including mobile workers.

>> How to get the software ? you can download from
http://getintopc.com/softwares/3d-cad/catia-v6-free-download/

>> and then start to install the software by using this guidance :
1. http://cadhelpcenter.blogspot.co.id/2010/04/step-by-step-installation-process-of.html
2. https://www.youtube.com/watch?v=2w5ZP0J6QHI

>> when you meet the step that warn you to copy js0group.dll into instalation folder : x:\Program Files\Dassault Systemes\B205\intel_a\code\bin , you can download JS0Group.dll from this link :
http://www.4shared.com/file/mzQgIsFI/JS0GROUP.htm

Hope can help you to start to learn catia v6r2009


Post by :

HERY PURNAMA (Catia 3D Trainer)
MCDBA, CPMP, ITILF
Inhouse IT Trainer
http://www.inhousetrainer.net
info@inhousetrainer.net , inhousetrainer@yahoo.com
Call/ SMS/WA :  081.223344.506 , 022.91299407 | PinBB : 7DC633AA

Blog :
inhousetrainer.blogspot.com
freelance-it-trainer.blogspot.com

Social Net :
facebook.com/inhousetrainer
twitter.com/inhousetrainer
instagram.com/inhousetrainer

Office :
Graha Rifai , Jl. Pelajar Pejuang 45 No.23 Lt.2
Bandung - Jawa Barat