Oracle Architecture overview
The oracle 9i RDBMS contains a suite of software that includes required components, work-saving tools, utilities, and management software that is primarily user for DBA. More features for use with the Internet than prior releases for example, a new XML DB (database) feature provides an interface within the database for easily storing, updating, and displaying XML-formatted data.
Installation of GD
-Install zlib for gd
download zlib-1.2.3.tar.gz in /usr/local/src
tar -xzvf zlib-1.2.3.tar.gz
cd zlib-1.2.3
./configure –prefix=/usr/local –shared
make
make install
-Install libpng for gd
download libpng-1.2.20.tar.gz in /usr/local/scr
tar -xzvf libpng-1.2.20.tar.gz
cd libpng-1.2.20
./configure –prefix=/usr/local
make check
make install
Configure Postfix, Dovecot for SSL
–improvement for smtp over ssl authentication
#-issue server certifcate
# cd /usr/share/ssl/certs
# make mail.pem
# Country Name:US
# Province Name:NY
# Locality Name:Manhattan
# Organization Name :CIS
# Organization Unit Name:
# Common Name:mail.configureinstallsetup.com
# Email Address:admin@configureinstallsetup.com
# –>created as /isr/share/ssl/certs/mail.pem
use certificates of SSL of httpd
Installation Of Dovecot
-make group and user dovecot
useradd dovecot
-download dovecot
download dovecot-1.0.2.tar.gz to /usr/local/src
cd /usr/local/src
tar xzvf dovecot-1.0.2.tar.gz
-install dovecot
cd dovecot-1.0.2
./configure
make
make install
create /etc/pam.d/dovecot as
auth required pam_unix.so
account required pam_unix.so
How to install of Postfix mail server
-download postfix
downlad postfix2.4.3.tar.gz to /usr/local/scr
tar xzvf postfix2.4.3.tar.gz
-Install postfix
groupadd postfix
useradd -g postfix postfix
groupadd postdrop
make
make install
#inquiries are all defaults
How to enable dhcp services? First, you need to add component dhcp on the add and remove program. Check on the Dinamic Host Configuration Protocol(DHCP). Make sure you put the cd 2003 server on the cd-rom.
How to install skin on subdreamer screenshot.
1)Download skin from subdreamer.com
2)Extract the zip file “effect.zip”
Duplicating a Database using RMAN
Combine RAC, Linux and FireWire disk for low-cost development environment.
Toolbox:
Oracle 9i (9.0.1.4.0) Database Server with RAC option; Red Hat Linux 7.1.
Topics include:
Oracle database installation, Linux kernel versions, and kernel settings. You should have a good knowledge of Oracle database administration and Linux (or UNIX) operating system management, but whether you’re an established DBA and UNIX administrator or merely a DBA and Linux “newbie,” the basic advice and techniques here will save you lots of time and aggravation.
With the demands of a 24/7 marketplace, a highly available and scalable database is getting increasingly more important. In the past, you had to choose from one of two options in a cluster. High availability clusters were used to protect your database from hardware failure. Load balanced clusters with many nodes were used to support a much larger volume of traffic than single multi-processor implementations. Redundant components such as additional nodes, multiple interconnects, and arrays of disks helped provide high availability.
Taken from Microsoft.com
Large Active Directory® environments have a few
special tuning requirements.
On server computers, a large quantity of memory is helpful
in reducing disk I/O activity. Use of the /3GB switch gives x86 servers more
user mode virtual space and allows Active Directory to improve its caching.
Windows 2000 includes two settings:
·
Using the /3GB switch allows the main Active Directory cache a
maximum of 1024 MB.
Taken from microsoft.com
General Considerations
It is important to select the right hardware to satisfy the expected file server load, keeping in mind average load, peak load, capacity, growth plans, and response times. Hardware bottlenecks will limit the effectiveness of software tuning.
Consider the following issues when selecting hardware and setting up the operating system.
User-mode Settings
IIS Registry Settings
The following registry settings are found under this entry:
HKLM\System\CurrentControlSet\Services\Inetinfo\Parameters\
Performance Tuning for IIS 6.0
Selecting the Right Hardware for Performance
It is important to select the right hardware to satisfy the expected Web load (keeping in mind average load, peak load, capacity, growth plans, and response times). Hardware bottlenecks limit the effectiveness of software tuning. Consider the issues in Table 7 when selecting hardware.
taken from microsoft.com
Determining the Volume Layout
Whenever possible use separate volumes for each data type. For example, use one volume for the operating system and paging space, and one or more volumes for shared user data, applications, and log files.
Place different data types in separate volumes on different virtual disks. Using separate virtual disks is especially important for any data types that create heavy write loads, such as log files, so that a single set of disks (that compose the virtual disk) can be dedicated to handling the disk I/O created by the updates to the log files. Placing the paging file on a separate virtual disk can provide some minor improvements in performance, but typically not enough to make it worth the extra cost.
To gain some performance benefits while minimizing cost, it is often useful to combine different data types in one or more volumes on the same virtual disks. A common method is to store the operating system and paging space on one virtual disk and the user data, applications, and log files in one or more volumes on the remaining virtual disk.
The storage architecture covers many components in the driver stack as Figure 2 shows. The sections below discuss tuning guidelines for storage workloads.
Choosing Storage
The most important considerations in choosing storage systems are:
• Providing necessary storage space, bandwidth, and latency characteristics for current and future needs.
• Selecting an HW RAID type and backup procedure that provide the required performance and data recovery capabilities.
WHQL Certification
Choose a storage adapter with WHQL certification.
Estimate the Amount of Data to be Stored
When you estimate the amount of data to be stored on a new file server, you need to consider these issues:
• The amount of data currently stored on any file servers that will be consolidated onto the new file server.
• If the file server will be a replica member, the amount of replicated data that will be stored on the new file server.
• The amount of data that you will need to store on the file server in the future.
How to Performance Tuning For Networking On Windows 2003 Server.
Taken from Microsoft.com
Performance Tuning for Networking
The network architecture covers many components, interfaces, and protocols; Figure 1 illustrates some of them. The sections below discuss tuning guidelines for some of the components for server workloads.
Figure 1 Network Stack Components
The network architecture is layered, and the layers can be broadly divided into:
• The network driver and NDIS. These are the lowest layers. NDIS exposes interfaces for the driver below it and for the layers above it; for example, TCP/IP.
• The protocol stack. This implements protocols such as TCP/IP and UDP/IP. These layers expose the TDI interface for layers above them.
• System Drivers. These are typically TDI clients and expose interfaces to user-mode applications. The WinSock interface is exposed by Afd.sys.
• User-mode applications.
Tuning for network-intensive workloads can involve tuning for each of the layers. Some of the tunings are described below.
Choosing a Network Adapter
Network-intensive applications need high-performance network adapters. This section covers some considerations for choosing network adapters.
Step by step setting Oracle Environment Server On Linux (part 2)
Shutdown Oracle Instance (Shutdown Oracle instance before applying patch)
1. su - oracle
2. sqlplus /nolog
3. connect sys as sysdba
4. Password - oracle
5. shutdown
6. exit
To unzip OPatch files (p2617419)
1. Login as root
2. cd /home/patch
3. unzip p2617419_10102_GENERIC.zip (should see OPatch folder created)
Append
#Oracle Environment
export ORACLE_BASE=/home/opt/oracle
export ORACLE_HOME=/home/opt/oracle/product/9.2.0.4
export ORACLE_SID=TMS
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
Save file
Installation Procedures
What is Subdreamer CMS?
Taken from subdreamer.com : Subdreamer CMS is a powerful yet simple program used for creating websites. With it’s quick installation and easy to use admin interface you will have your website up and running within minutes.
Whether your goal is creating a simple website with a couple pages or a larger website with hundreds of pages, Subdreamer CMS will get you there by providing unbeatable content management tools. Download today and join the thousands of members that are already using Subdreamer CMS to power their websites!
How to install Subdreamer CMS?
Create database name on your mysql. The command on mysql as picture below.