.::: How To Disable ARCHIVELOG Mode :::.

When you run your database in NOARCHIVELOG mode, you disable the archiving of the redo log. The database control file indicates that filled groups are not required to be archived. Therefore, when a filled group becomes inactive after a log switch, the group is available for reuse by LGWR.

NOARCHIVELOG mode protects a database from instance failure but not from media failure. Only the most recent changes made to the database, which are stored in the online redo log groups, are available for instance recovery. If a media failure occurs while the database is in NOARCHIVELOG mode, you can only restore the database to the point of the most recent full database backup. You cannot recover transactions subsequent to that backup.

.::: How To Enable ARCHIVELOG Mode :::.

When you run a database in ARCHIVELOG mode, you enable the archiving of the redo log. The database control file indicates that a group of filled redo log files cannot be reused by LGWR until the group is archived. A filled group becomes available for archiving immediately after a redo log switch occurs.

The archiving of filled groups has these advantages:

•     A database backup, together with online and archived redo log files, guarantees that you can recover all committed transactions in the event of an operating system or disk failure.
•     If you keep an archived log, you can use a backup taken while the database is open and in normal system use.
•     You can keep a standby database current with its original database by continuously applying the original archived redo logs to the standby. 

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

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.

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

C:\Users\teguh.triharto>sqlplus

.::: How To Troubleshoot ORA-12638: Credential Retrieval Failed :::.

Hi Friends, today i faced very nasty situation in establishing network connection with Oracle database.

I created a user as per request from application team and i got response that they are not able to connect. when analyzing i found tnsping is not working.

I started looking at tnsnames.ora and compared that with what is there in server and its same. so as next step i looked at SQLNET.ORA file and added following line to make sure both the machines are in same domain

NAMES.DEFAULT_DOMAIN = klpcph.local

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