Tạo và phân quyền User trong Oracle Database

Link http://vn.tips4admin.com/post/2011/09/03/Tao-va-phan-quyen-User-trong-Oracle-Database.aspx I – Database User Accounts: Mỗi Database User Accounts gồm có: Một username duy nhất: Username được vượt quá 30 bytes, không bao gồm các kí tự đặc biệt và phải bắt đầu bằng một chữ cái. Một phương thức xác thực: Trên Oracle 11g hỗ trợ 3 kiểu xác thực người dùng là […]

Kiến trúc Oracle Database Server

Link http://vn.tips4admin.com/post/2011/08/14/Kien-truc-Oracle-Database-Server.aspx Oracle Database là hệ thống quản lý cơ sỡ dữ liệu quan hệ (RDBMS) được tích hợp để cho phép quản lý thông thông tin một cách toàn diện. Trong bài này, chúng ta sẽ phân tích qua về kiến trúc của Oracle Database Server như thế nào nhé .   I – Kết nối […]

MySQL Master-Master Replication, Heartbeat, DRBD, Apache, PHP, Varnish MegaHOWTO

Link http://www.iodigitalsec.com/mysql-master-replication-heartbeat-drbd-apache-php-varnish-howto/ I created this HOWTO while building a new development environment today. The intention is to take a single Apache2/Varnish/MySQL environment and scale it to two servers, with one effectively a “hot-standby” – increase redundancy and continuity whilst maintaining current performance. This HOWTO is based on Linux Debian-76-wheezy-64-minimal 3.2.0-4-amd64 #1 SMP Debian 3.2.60-1+deb7u3 x86_64 Our current […]

Installing and Configuring Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part II

Link: http://www.tecmint.com/oracle-12c-installation-in-centos-6/ In our previous article, we’ve shown you how to setup prerequisites for Oracle 12c installation. In this article we will cover installation and configuration of Oracle 12c in RHEL/CentOS/Oracle Linux 6.5, along with some Oracle post installation instructions. Requirements Installing Prerequisites for Oracle 12c in RHEL/CentOS/Oracle Linux 6.5 – Part I Installing Oracle 12c Database in […]

Setting Up Prerequisites for Oracle 12c Installation in RHEL/CentOS/Oracle Linux 6.5 – Part I

Link http://www.tecmint.com/setting-up-prerequisites-for-oracle-12c-installation/ Oracle database is the set of related data collections, we can call it as Relational database management system (RDBMS) or just Oracle. While comparing to any other database solution oracle is one of the powerful DBMS with many features such as tune-able, reliable and scalable. Oracle produce separate hardware for oracle software’s, but same can […]

Install Oracle Database 12 In Oracle Linux 6.5

Link http://www.unixmen.com/install-oracle-database-12-oracle-linux-6-5/ In this tutorial, I’d like to show you step by step latest Oracle installation in Oracle Linux 6.5 64bit. Normally Virtualbox is not that good to install a production Oracle database environments, but it can be  enough for Developers and testers. I suggest you to use minimum of 40GB VM hard disk, 4GB SWAP […]

Azure Websites, Cloud Services, and Virtual Machines comparison

Link http://azure.microsoft.com/en-us/documentation/articles/choose-web-site-cloud-service-vm/#custom Price calculator: http://azure.microsoft.com/en-us/pricing/calculator/ Overview Azure offers several ways to host web sites: Azure Websites, Cloud Services, and Virtual Machines. This article helps you understand the options and make the right choice for your web application. Azure Websites is the best choice for most web apps. Deployment and management are integrated into the platform, sites can scale quickly to […]

How to SVN ( Subversion ) Dump and Restore

http://tecadmin.net/how-to-svn-subversion-dump-and-restore/ As a system admin we know the importance of backup. This article will help you to how to Backup and Restore SVN (Subversion) repository on Linux. Eg 1. Backup (dump) SVN Repository # svnadmin dump /var/www/svn/myrepo > /backup/svn/myrepo.dump * Dumped revision 0. * Dumped revision 1. * Dumped revision 2. …. Eg 2. Compressed […]

How to Back Up and Restore a MySQL Database

http://webcheatsheet.com/sql/mysql_backup_restore.php Back up From the Command Line (using mysqldump) If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file. The dump file contains the SQL statements necessary to re-create the database. […]

Install plugin(order list) on OpenProject

https://www.openproject.org/topics/2041 gem ‘openproject-plugins’, :git => ‘https://github.com/opf/openproject-plugins.git’, :branch => ‘stable’ gem ‘openproject-pdf_export’, :git => ‘https://github.com/finnlabs/openproject-pdf_export.git’, :branch => ‘stable’ gem “openproject-costs”, git: “https://github.com/finnlabs/openproject-costs.git”, :branch => ‘stable’ gem ‘openproject-global_roles’, :git => ‘https://github.com/finnlabs/openproject-global_roles.git’, :branch => ‘stable’ gem “openproject-meeting”, :git => “https://github.com/finnlabs/openproject-meeting.git”, :branch => “stable” gem ‘openproject-my_project_page’, :git => ‘https://github.com/finnlabs/openproject-my_project_page.git’, :branch => ‘stable’ gem ‘openproject-documents’, :git => ‘https://github.com/opf/openproject-documents.git’, :branch => […]