127 - Simple Oracle Backup & Restore

You just need to get a backup created, and you want to take the simpllest approach.

BACKUP :

Command to back up your entire database:

# rman target /
RMAN> backup database;

You should see a list of RMAN message displaying information.

To display information about your backup, use the list backup command as follows :

126 - ORA-19602 cannot backup or copy active file in NOARCHIVELOG mode

You attempted to use RMAN to backup your database and received the following error message:

RMAN-03009: failure of backup command on ORA_DISK_1 channel
ORA-196602: cannot backup or copy active file in NOARCHIVELOG mode

This message indicates that before you can create an RMAN online backup. you need to place your database
into archivelog mode.

Enabling Archivelog Mode :

125 - Delete oracle archivelogs 11g

If you want to delete archivelogs, use these command to delete them in RMAN.

# rman target / nocatalog.

1. 7 days ago

RMAN> delete archivelog until time 'sysdate-7';

2. All archivelogs

RMAN> delete archivelog all;

3. Archivelogs in terms of thread #

124 - To fix slow ssh login

If your login Linux are really slow, it may be that reverse DNS is not working correctly.
To fix the problem is to either add the IP address to /etc/hosts, or modify your sshd_config file by setting UseDNS to no:

# vi /etc/ssh/sshd_config

--------------------------------------------------------------------------

123 - ORA-01031: insufficient privileges

ORA-01031: insufficient privileges is that there is something wrong configuration.

1. Check sqlnet.ora

Comment out this line.

SQLNET.AUTHENTICATION_SERVICES=(NTS)

2. Check the OS user in terms of DBA group.

122 - Network Configuration Files

You can change the network configuration by editing a few files.

1. CentOS & RedHat OS

Host Name : /etc/sysconfig/network

Network Device : /etc/sysconfig/networking/devices/ifcfg-eth0  ifcfg-eth1

Host Name List : /etc/hosts

DNS Server : /etc/resolve.conf

DNS Files NIS : /etc/nsswitch.conf

After editing files, you need to execute the follwoing command :

121 - crontab examples

There are various examples :

120 - To install PHP 5.2.x & MySQL 5.1.x in CentOS 5.x

phpMyAdmin v3.x needs to have PHP 5.2 and later version. But CentOS 5.x has still PHP 5.1.x.
This is one of methods on PHP & MySQL upgrade processes for CentOS 5.x.

1. Check your software versions in terms of PHP & MySQL

# php -v
# yum list installed php*

# mysql -V
# yum list installed mysql*

2. Install third party repository

119 - To install the PECL uploadprogress library

IThe report of drupal site says that the upload progress module gives you an error.

The error is the following:

"Upload progress Not trained Your server is capable of displaying file upload progress,
but does not have the required libraries.
It is recommended to install the PECL uploadprogress library (prefered) or to install APC."

You need to install the PHP developer package.

$ sudo apt-get install php5-dev

118 - Disable Firewall on Linux Server

1. Redhat

Next enter the following three commands to disable firewall.

# service iptables save
# service iptables stop
# chkconfig iptables off

For IPv6

# service ip6tables save
# service ip6tables stop
# chkconfig ip6tables off

2. Ubuntu

Syndicate content