.::: 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.

.::: 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 

.::: 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 :

.::: 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