Tuesday, September 24, 2013

.::: Daftar Isi / Table Of Contents Teguh Triharto Learning Centre :::.

Lembar halaman yg menjadi petunjuk pokok isi buku beserta nomor halaman

A table of contents, usually headed simply "Contents" and abbreviated informally as TOC, is a list of the parts of a book or document organized in the order in which the parts appear. The contents usually includes the titles or descriptions of the first-level headers, such as chapter titles in longer works, and often includes second-level or section titles (A-heads) within the chapters as well, and occasionally even third-level titles (subsections or B-heads). The depth of detail in tables of contents depends on the length of the work, with longer works having less.

Wednesday, September 11, 2013

.::: Definition : Oracle Database SQL Certified Expert & ID Card & Syllabus :::.


Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Retrieving Data Using the SQL SELECT Statement
  • List the capabilities of SQL SELECT statements  
  • Execute a basic SELECT statement 
  • Describe how schema objects work

.::: Study Kasus Praktis belajar SQL create & insert table Setelah Install Oracle Database (Create Data Warehouse):::.

SQL atau Structured Query Language) adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional. Bahasa ini secara de facto merupakan bahasa standar yang digunakan dalam manajemen basis data relasional. Saat ini hampir semua server basis data yang ada mendukung bahasa ini untuk melakukan manajemen datanya.

anda dapat juga download The Study Case & solution Lab Oracle & SQL Expert 

A. Management User
1. Loging Using system or sys as sysdba

C:\Users\teguh.triharto>sqlplus

.::: How To Using Aljabar(Algebra): union(gabungan), intersection(irisan), distinct (proyeksi), join/inner join/normal join/equal join(=),left outer join and right outer join In SQL :::.

Algebra (from Arabic al-jebr meaning "reunion of broken parts") is the branch of mathematics concerning the study of the rules of operations and relations, and the constructions and concepts arising from them, including terms, polynomials, equations and algebraic structures. Together with geometry, analysis, topology, combinatorics, and number theory, algebra is one of the main branches of pure mathematics. Algebra has numerous usages in daily life and is commonly taught in public schools.

.::: How To Using Query, Sub Query from one table or More in SQL :::.


=== 6. Query  and view ===
Query sebutan atau nama lain dari seleksi data yang merupakan bagian dari DML
Query as Selection data that one of DML


You can download The Study Case & solution Lab Oracle & SQL Expert

 == 6.1 seleksi satu tabel ==
== Selection from One Table ==
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT   field 1,...,field n, agregation function
FROM     table
WHERE      criteria
GROUP BY field 1,...,field n
HAVING      criteria_agregate_function
ORDER BY field
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

.::: How To Using min, max, avg, sum, count, Group by, order by, Having, where, comparison (=,<>,>,<,>= atau <=), Between, In, like / not like on Grouping, Sorting & Criteria Data In SQL Oracle :::.

=== Pengelompokan, pengurutan dan kriteria Data ===
=== How To Grouping, Sorting & Criteria Data ===

You can download The Study Case & solution Lab Oracle & SQL Expert 

== 5.1 pengelompokan data (group by) dan aggregation function ==
Sintak SQL
== 5.1.1 min() ==

 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT field 1,...,field n, MIN(name_field)
    FROM TABLE
    GROUP BY field 1,...,field m
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
== 5.1.2 max() ==
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT field 1,...,field n, MAX(name_field)
    FROM TABLE
    GROUP BY field 1,...,field m
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

.::: How To Insert, Update, Delete Data In DML(Data Manipulation language) SQL :::.

A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML

You can download The Study Case & solution Lab Oracle & SQL Expert 

=== 4.1 Memasukkan Data (Insert Data) ====
Sintak SQL
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
INSERT INTO name_table(field 1,...,Field n)
    VALUE(value_field 1,...,field n)
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

= Check Data Table =
select * from barang;
select * from suplier;
select * from customer;
select * from pasok;
select * from pembelian;

SQL> select * from barang;

.::: How To Create, Modify, Drop, Delete Table In DDL (Data Definition Language) SQL Oracle :::.

Cara Membuat, Memodifikasi, Menghapus Tabel dalam DDL

SQL adalah Structured Query Language. secara garis besar terdiri dari
1. DDL (Data Definition Language)
2. DML (Data Manipulating Language)
3. DCL (Data Control Language)
1. Study Kasus = Inventory

Tabel Barang = Menggambarkan entitas barang dan terdiri atas atribut yang berkaitan dengan entitas barang. Atribut barang meliputi : kode_barang,nama_barang,satuan_barang dan stok barang
Tabel Suplier = Menggambarkan entitas suplier dan terdiri atas atribut atribut yang berkaitan dengan suplier. Atribut suplier meliputi : kode_suplier, nama_suplier, alamat_suplier, kota_suplier dan telepon_suplier

Tuesday, August 27, 2013

.::: How to Check Host ID, UUID on Solaris & Check Solaris Version :::.

1. Check Host ID Solaris

The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change this hostid for whatever purpose. For example, you current machine is down for hardware failure and you purchased a new machine.

However, all your current running software are based on this old hostid, and you must bring the new machine up within a very short time. The quick solution is to change the new machine’s hostid to be as same as the old one.

.::: How To Enable VNCserver on Solaris 10 :::.

Abstract:
Open Systems have traditionally been accessed via Command Line. MIT create a fully object oriented, multi-tiered, open source windowing system called X Windows, which was quickly adopted by nearly all computing industry players. While X Windows is well suited for local area network technology, the need for wide area network technology was addressed through several different attempts, such as X11R6 "Broadway" and proxies leveraging compression. A lighter WAN suitable screen display protocol, referred to as Virtual Network Computing (VNC) is also commonly used for X displays.
bagaimana cara mensetting vncserver di solaris 10
Procedure:

.::: How To Setting NTP Server & Client In Solaris 10 :::.

Setting NTP ( Network Time Protocol) on Solaris 10

Example add the IP NTP Server (example 10.10.10.10) of the "server" and comment out `fudge 127.127.XType.0 stratum 0`

A. Configuring an NTP Server

1. Go to Directory # cd /etc/inet
Log :
root@teguht # cd /etc/inet
root@teguht # ls

.::: How To Setting SNMP On Solaris 10 :::.

Simple Network Management Protocol (SNMP) is an "Internet-standard protocol for managing devices on IP networks." Devices that typically support SNMP include routers, switches, servers, workstations, printers, modem racks, and more. It is used mostly in network management systems to monitor network-attached devices for conditions that warrant administrative attention. SNMP is a component of the Internet Protocol Suite as defined by the Internet Engineering Task Force (IETF). It consists of a set of standards for network management, including an application layer protocol, a database schema, and a set of data objects

Study Case change Snmp community from "public" to "teguht" on server root@teguht
Download SNMP Tester

A. Step by step setting & change SNMP on Solaris 10

1.    Login to Server Using "root"
Log :
root@teguht # id
uid=0(root) gid=0(root)
root@teguht #

:: How to Change the Hostid In Solaris :::.

bagaimana cara mengubah hostid di Solaris
The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change this hostid for whatever purpose. For example, you current machine is down for hardware failure and you purchased a new machine. However, all your current running software or License are based on this old hostid, and you must bring the new machine up within a very short time. The quick solution is to change the new machine’s hostid to be as same as the old one.

There are several ways to do so, including using a program to flush NVRAM which will change the hostid permanently. I did following experiment to change the Hostid in a Solaris 10 machine temperately. It adds several lines in the /etc/rc2.d/S20sysetup file. If you want to restore the original hostid, you just need to remove these lines and reboot the machine.

Example Change hostid from c93256a to 850168ae

No Item Hostid  Decimal Hex Value  Remak
1 Host ID Original c93256a 210969962 32 31 30 39 36 39 39 36 32  -
2 New Host ID 850168ae 2231462062 32 32 33 31 34 36 32 30 36 32 -

.::: How To Change IP Address Without Reboot In Solaris 10 :::.

bagaimana cara ubah IP tanpa Reboor/restart
Adding or editing the IP address on a Solaris 10 server is different from the previous versions of the OS (Solaris 9, Solaris 8 etc).

In the previous versions of the Solaris Operating System, you need to edit the /etc/hosts file and add/edit the entry for the IP address and the hostname.

Example:

    192.168.1.1   solaris-teguh

.::: Solaris Network Configuration :::.

Setting up Solaris networking often becomes challenging for the new sysadmins and new owners of Sun systems . This document details the steps involved in setting up of Solaris networking and can be used as a check list if you are already familiar with Solaris network configuration .

Table of contents :

.::: How To: Add a Static Route (persistent) in Sun Solaris :::.

Bagaimana menambahkan Static Router pada Solaris 8, 9, 10
To add a Static Route in Sun Solaris operating system, you can use the route command. This will dynamically update the Kernel IP Routing table. However, when a server is restarted, these routes will be lost. To prevent this from happening, add a startup script S76static-routes with all the route commands for the static route that needs to persist. This will ensure that the route gets added at boot time.


To use the route command,

.::: How To Setting Remote, Telnet, SSH, FTP, Xbrowser, IP, Hostname, Patch, Alias After Fresh Installation Solaris 10 :::.

Bagamana cara Setting Remote, Telnet, SSH, FTP, Xbrowser, IP, Hostnamem, Patch, Alias setelah Install Solaris 8, 9, 10
Solaris

Sample IP 10.10.10.10 netmask 255.255.255.0 gateway 10.10.10.1
1. Check Netmask

bash-3.00# more /etc/netmasks
#
# The netmasks file associates Internet Protocol (IP) address
# masks with IP network numbers.
#

.::: How to Install Solaris Packages, Patches & Bundle Recommended Patches 10_x86_Recommended.zip in Oracle Solaris 10 Include SUNWi15cs, SUNWi1cs :::.

Bagaimana Cara Install Solaris Packages, Patches & Install Bundle Recommended Patches 10_x86_Recommended.zip in Oracle Solaris 10(Ext Sun Solaris 10) 


1. Install Additional Solaris packages required

== Check Status Packages before Patch ==
root@teguht #pkginfo SUNWi15cs SUNQi1cs
ERROR: information for "SUNWi15cs" was not found
ERROR: information for "SUNQi1cs" was not found
root@teguht #

== Alternative 1 = Install packages Solaris ==
root@teguht #pkgadd -d /cdrom/cdrom0/Solaris_10/Product SUNWi15cs

Processing package instance <SUNWi15cs> from </cdrom/sol_10_910_x86/Solaris_10/Product>

Monday, August 26, 2013

.::: How To Backup, Extract, Display Content files with Tar, Compress & extract using Gzip, Gunzip(.gz) :::.

Solaris tar command to backup data on tape device. Tar name come from Tape ARchiver. It is both a file format and the name of the program used to handle such file. Tar archive files have names ending in ".tar". If an archive is compressed, the compression program adds its own suffix as usual, resulting in filename endings like ".tar.Z", ".tar.gz", and ".tar.bz2". Tar doesn't require any particular filename suffix in order to recognize a file as an archive. Tar was originally created for backups on magnetic tape, but it can be used to create tar files anywhere on a filesystem. Archives that have been created with tar are commonly referred to as tarballs.

1. Creating a tarball/new set of backup.

Friday, August 23, 2013

..::: How to Create a Backup Script Using the ROBOCOPY & Scheduling On Windows :::.

ROBOCOPY can be likened to an extension of XCOPY on steroids. Some of the more important features that make ROBOCOPY an attractive backup alternative are:
  • multi-threaded copying
  • mirroring or synchronisation mode between the destination and source
  • automatic retry and copy resumption
Applies To : Windows 7, Windows 8, Windows Server 2008, Windows Server 2012
Type : Copies file data.

.::: How to Delete a Windows Service On Windows :::.

If you are a fan of tweaking your system and disabling services, you might find that over time your Windows Services list becomes huge and unwieldy with a large number of services in the list that will never be enabled.

Instead of just disabling a service, you can alternatively completely delete the service. This technique can be especially helpful if you’ve installed some piece of software that doesn’t uninstall correctly, and leaves an item in the service list.

Important Note: Once you delete a service, it’s gone, and it’s going to be a pain to add it back. Use with caution.

.::: How To Install Oracle 12 On Windows Server 2012 (Include Uninstall Oracle Database) :::.

Oracle is a popular database product in the world, has many customers, and have complete feature as a database.

While Solaris 10 is an operating system that also famous for reliable, stable, and has a large user base. Combined they will produce a reliable server, with high performance.

Thursday, July 11, 2013

.::: Procedure Install Solaris 10 Using Partition Disk On VMware :::.

Solaris is a Unix operating system originally developed by Sun Microsystems. It superseded their earlier SunOS in 1993. Oracle Solaris, as it is now known, has been owned by Oracle Corporation since Oracle's acquisition of Sun in January 2010.

Solaris is known for its scalability, especially on SPARC systems, and for originating many innovative features such as DTrace, ZFS and Time Slider. Solaris supports SPARC-based and x86-based workstations and servers from Oracle and other vendors, with efforts underway to port to additional platforms. Solaris is registered as compliant with the Single Unix Specification.

Monday, July 8, 2013

.::: Study Kasus Praktis belajar SQL Setelah Install Oracle Database & Microsoft SQL Server :::.

ooooO
SQL atau Structured Query Language) adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional. Bahasa ini secara de facto merupakan bahasa standar yang digunakan dalam manajemen basis data relasional. Saat ini hampir semua server basis data yang ada mendukung bahasa ini untuk melakukan manajemen datanya.

anda dapat juga download The Study Case & solution Lab Oracle & SQL Expert 

A. Management User
<iframe width="560" height="315" src="https://www.youtube.com/embed/uFA4D313DBg" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>


C:\Users\teguh.triharto>sqlplus

.::: How To Install And Uninstall Oracle 11 On Unix Solaris Platform ( Step By Step Install And Uninstall Oracle, Database, Listener) :::.

Oracle adalah product database yang terkenal didunia, mempunyai banyak customer, dan memiliki feature lengkap sebagai sebuah database. Sedangkan Solaris 10 adalah sebuah Sistem operasi yang juga terkenal handal, stabil, dan mempunyai basis user yang besar. Gabungan keduanya akan menghasilkan sebuah server yang handal, dengan performance yang tinggi.

Artikel ini akan membahas instalasi Oracle 10g pada Solaris 10 x86(bisa digunakan untuk pada solaris sparc).

anda dapat juga download The Study Case & solution Lab Oracle & SQL Expert 

Video Instalasi & Uninstallasi Dapat Di download di
1. Download Video Install & Uninstall Oracle Database In Solaris 10
2. Download Video Install & Uninstall Oracle Database In Windows
3. Download Video Install Oracle, Database, Listener Using VMWare
4. Download Video Install Oracle, Database, Listener Using VMWare

Oracle 10 memerlukan :

.::: How To Install And Uninstall Oracle 11 On Windows Platform ( Step By Step Install And Uninstall Oracle, Database, Listener) :::.

Step By Step Install And Uninstall Oracle ( 8, 9, 10, 11), Database, Listener In Windows Platform
Oracle is a popular database product in the world, has many customers, and have complete feature as a database. While Solaris 10 is an operating system that also famous for reliable, stable, and has a large user base. Combined they will produce a reliable server, with high performance.

You can download The Study Case & solution Lab Oracle & SQL Expert 

This article will discuss the installation of Oracle 10g on Solaris 10 x86.
Oracle 10 requires:
- 1GB RAM (Recommendation)
- CPU 3 GHz
- Space: 20GB (Recommendation)
- A minimum of space for / tmp: 512MB (Recommendation)

.::: How To Backup And Restore Database Oracle Using RMAN ( Oracle Backup Tool ) And Fix ORA-19602 :::.

How To Backup And Restore Database Oracle Using RMAN Tool And Fix

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Cause:       You tried to copy or backup a file that was not closed cleanly, and the database was in NOARCHIVELOG mode. This is not allowed because when restored, the file will require redo application before it is usable, and redo is not currently being saved beyond the contents of the online redo logs.

Action:  Take the tablespace offline clean or close the database and retry the copy or backup. ( so Please Run Pre Backup Oracle Using SQL Command Before Backup)

You can download The Study Case & solution Lab Oracle & SQL Expert 

.::: How To Create / Delete User Account In PL / SQL Oracle, Microsoft SQL Server :::.

Question;

1. How to create / delete user in Sql / Oracle?
      <sample user : teguh  , password : triharto >
2. How can I set privilages while create a new user?
    <access to/from SQL>
3. How can I view all forms / tables?
4. How can I list the users already got account in Sql?
5. Check Privilage user ?
6. delete/drop role ?
7. Which is the best web site to learn oracle (for beginners)?

You can download The Study Case & solution Lab Oracle & SQL Expert 

Friday, July 5, 2013

.::: How To Install MySQL 5.5 on Solaris 10 :::.

MySQL (play /ma? ??skju?'?l/ "My S-Q-L", officially, but also called /ma? 'si?kw?l/ "My Sequel") is the world's most used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.

It is named after co-founder Michael Widenius' daughter, My. The SQL phrase stands for Structured Query Language.

The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

.::: Bagaimana Mencari/Mentracert IP Dan Port Pada Switch/Router Cisco ? :::.


Contoh Studi kasus
Server dengan IP 10.10.10.100/TEGUH05SRV tidak diketahui lokasi secara fisik dan tetap bisa diping. dikarenakan perubahan struktur organisasi/ganti orang, biasanya letak server 10.10.10.100 tidak diketahui tertetak dimana ? bagaimana mentracert port dan switch yang terkoneksi ke server 10.10.10.100/TEGUH05SRV ?

langkah langkah

1. Telnet ke gateway Router
   sample Telnet 10.10.10.1

2. Check Address Resolution Protocol
   #show ip arp

.::: How To Setting Administration & Testing After Instalation & Create Email Microsoft Exchange 2010 :::.

Microsoft Exchange Server is the server side of a client–server, collaborative application product developed by Microsoft. It is part of the Microsoft Servers line of server products and is used by enterprises using Microsoft infrastructure products. Exchange's major features consist of electronic mail, calendaring, contacts and tasks; that work with Microsoft Outlook on PC and Mac, wireless synchronization of email, calendar, contacts with major mobile devices and browser-based access to information; and support for data storage.

A. Install Pre-requisites Microsoft Exchange Server 2010

.::: How to Install Microsoft Exchange Server 2010 :::.


Microsoft Exchange Server is the server side of a client–server, collaborative application product developed by Microsoft. It is part of the Microsoft Servers line of server products and is used by enterprises using Microsoft infrastructure products. Exchange's major features consist of electronic mail, calendaring, contacts and tasks; that work with Microsoft Outlook on PC and Mac, wireless synchronization of email, calendar, contacts with major mobile devices and browser-based access to information; and support for data storage.

A. Install Pre-requisites Microsoft Exchange Server 2010

.::: How to Install Pre-requisites Microsoft Exchange Server 2010 & 2013 :::.

Microsoft Exchange Server is the server side of a client–server, collaborative application product developed by Microsoft. It is part of the Microsoft Servers line of server products and is used by enterprises using Microsoft infrastructure products. Exchange's major features consist of electronic mail, calendaring, contacts and tasks; that work with Microsoft Outlook on PC and Mac, wireless synchronization of email, calendar, contacts with major mobile devices and browser-based access to information; and support for data storage.

A. Install Pre-requisites Microsoft Exchange Server 2010
Software is required prior to install Exchange server 2010 :

Thursday, July 4, 2013

.::: Berapa Besar Tunjangan Sertifikasi IT ?(Studi Kasus Teguh Triharto Corporation) :::.

Sertifikasi profesional, kadang hanya disebut dengan sertifikasi atau kualifikasi saja, adalah suatu penetapan yang diberikan oleh suatu organisasi profesional terhadap seseorang untuk menunjukkan bahwa orang tersebut mampu untuk melakukan suatu pekerjaan atau tugas spesifik.

Sertifikasi biasanya harus diperbaharui secara berkala, atau dapat pula hanya berlaku untuk suatu periode tertentu. Sebagai bagian dari pembaharuan sertifikasi, umumnya diterapkan bahwa seorang individu harus menunjukkan bukti pelaksanaan pendidikan berkelanjutan atau memperoleh nilai CEU (continuing education unit).

Dan Ada beberapa keuntungan lainnya. yaitu mendapatkan tunjangan Sertifikasi seperti dikutip dari sumbernya.

.::: Introduction Blog teguhth.blogspot.com Learning Center :::.

.::: Introduction :::.
         Convey our gratitude to Allah SWT. http://teguhth.blogspot.com web blog can be launched. This website contains togethers history, study case, learn, lab, certification and other even can be downloaded. ( See How to watch and download the Video Online).

       Web was created in order as entertainment with a vision "Best of Sharing Knowledge Number 1 In The World & Number 1 In The Universe". expected to become an online Study Centre in the world today and in the future world (See also World Preview of the Technology The Future )

So I created this web blog may be useful,
                                                                                     
Southeast Asia, Asia, Earth, Sun, The Milky Way Galaxy
July 04, 2013



Teguh Triharto

Founder & CEO
http://teguhth.blogspot.com Powered By http://teguhtriharto.blogspot.com
My Certification http://teguhtriharto.blogspot.com/2011/08/teguhtriharto.html 

Popular Posts