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 :
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 :
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 #
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 -------------------------------------------------------------------------- |
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.
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 :
There are various examples :
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 |
2. Install third party repository
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
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