Monthly Archives: luglio 2013

How to solve ORA-00257 archiver error
  • 31
    Lug

How to solve ORA-00257 archiver error

In order to solve the above error the solutions are (considering database 10g and above.) 1.) Increase the free space where archiver archives the archivelog. The location where archiver archives the log is determined by parameter file pfile or spfile. This can be determined by loging into sqlplus and issuing SQL> show parameter log_archive_dest If archive destination is...

Read More
Windows Server 2008 R2 - Tools Command Line
  • 29
    Lug

Windows Server 2008 R2 – Tools Command Line

Microsoft makes provisions of the tools to perform operations at the command line. The most famous are Robocopy.exe (copy / sync files and folders), Calcs.exe (management of permissions on files and folders), Dnscmd.exe (add / remove DNS records), etc. .. Unlike previous versions, if you  need to use these tools on Windows Server 2008 R2 it is not...

Read More
Partitioning Table MS-SQL Server 2008.
  • 25
    Lug

Partitioning Table MS-SQL Server 2008.

Starting of 2005 version, was introduced the concept of table partitioning (as in Oracle.) At the time of choosing the type of partitioning, you have to be careful about the choice: LEFT or RIGHT. From my experience I would recommend to use the partitioning Left, or with values ​​less than the value of partitioning. This must be done...

Read More
Administering Oracle Real Application Clusters
  • 22
    Lug

Administering Oracle Real Application Clusters

  The Server Control (SRVCTL) utility  allows  you to start and stop database and instances, manage configuration information, move or remove instances and services. Allows you to reallocate a service from one named instance to another named instance; the relocated service is temporary until you modify the configuration. An example: Problem: We need to redistribute existing services. Solution:...

Read More