Base de Conocimientos

How to kill oracle datapump export job We can kill oracle datapump job by two methods, First method includes killing data pump job via data pump export prompt and another method includes running SQL package on SQL prompt as sysdba. //To simulate both the scenario, i am going to start oracle datapump export as below: [oracle@dbserver ~]$ expdp system/manager full=y directory=bkupdir dumpfile=Full_export.dmp logfile=Export_log.LOG Export: Release 11.2.0.3.0 – Production on Fri Apr 11 16:43:56 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.3.0 – 64bit Production Starting “SYSTEM”.”SYS_EXPORT_FULL_01″: system/******** full=y directory=bkupdir dumpfile=Full_export.dmp logfile=Export_log.LOG Estimate in progress using BLOCKS method… Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA Total estimation using BLOCKS method: 3.431 GB Processing object type DATABASE_EXPORT/TABLESPACE Process...

Configurando Database Mail en SQL Server 2012 El día hoy  les quiero compartir  un post sobre una utilidad de SQL Server bastante sencilla y muy práctica al momento  de ejecutar tareas, la misma consiste en  la configuración de correo de base de datos (Database Mail), para esto  inicialmente voy a crear un plan de mantenimiento sencillo el cual consiste en hacer respaldo de la base AdventureWorks2012 y posteriormente de haberse ejecutado  la tarea de forma exitosa  se envíe un correo a un o unos destinatarios predefinidos. Nota:  También se puede configurar para cuando  no sea exitosa Para hacer esto inicialmente vamos a crear un plan de mantenimiento, entonces procedemos a abrir  Management Studio y vamos al directorio de administración, luego a planes de mantenimiento. Con el botón derecho del ratón seleccionamos la opción de nuevo plan de mantenimiento,  y le colocamos un nombre Después de colocarle un nom...

FTP  (File Transfer Protocol) is probably the most popular method of uploading files to a server; a wide array of FTP servers, such as vsftpd, and clients exist for every platform. Pre-Flight Check These instructions are intended specifically for installing the vsfptd on CentOS 7. I’ll be working from a Liquid Web Self Managed CentOS 7 server, and I’ll be logged in as root. Step 1: Install vsftpd Warning: FTP data is insecure; traffic is not encrypted, and all transmissions are clear text (including usernames, passwords, commands, and data). Consider securing your FTP connection with SSL/TLS. As a matter of best practice we’ll update our packages: yum -y update Then let’s install vsftpd and any required packages: yum -y install vsftpd Step 2: Configure vsftpd For a refresher on editing files with vim see:  New User Tutorial: Overview of the Vim Text Editor Let’s edit the configuration file for vsftpd: vim /etc/vsftpd/vsftpd.conf Disallow anony...

Add a Linux User With Document Root Permissions Last updated on: 2016-06-24   Authored by: Rackspace Support This article will walk you through setting up a Linux user with read and write permissions for your web document root, usually the  /var/www/  directory. Connecting with this user via SFTP will let you upload your website content directly to the  /var/www/your/site/folder . For the purposes of this example we’ll use an account named “demo”. Be sure to replace “demo” in the examples with your preferred name. These commands require superuser privileges so they assume you are running them from an account with sudo privileges. Getting the group and directory We’ll need to know the group the web server process is running under as well as the location of your web server’s document root. This information can usually be found in the web server’s config file (like httpd.conf  or  apache2.conf  for apache). We’ve listed the default values...