Oracle - Flash recovery area full

Errors in file /opt/oracle/diag/rdbms/cert/CERT/trace/CERT_m000_11268.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 98.96% used, and has 556750848 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Fri Apr 29 22:33:36 2011
Thread 1 cannot allocate new log, sequence 1253

-- The size was increased to 50 Gb.

[oracle@www oracle]$ du -m flash_recovery_area/
1       flash_recovery_area/CERT/archivelog/2011_04_30
168     flash_recovery_area/CERT/archivelog/2011_04_26
62      flash_recovery_area/CERT/archivelog/2011_04_24
50279   flash_recovery_area/CERT/archivelog/2011_04_29
126     flash_recovery_area/CERT/archivelog/2011_04_28
610     flash_recovery_area/CERT/archivelog/2011_04_27
20      flash_recovery_area/CERT/archivelog/2011_04_25
51263   flash_recovery_area/CERT/archivelog
1       flash_recovery_area/CERT/onlinelog
51274   flash_recovery_area/CERT
51274   flash_recovery_area/

Oracle - archiver error

sqlplus username/password

SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 30 10:00:40 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

Installing MediaWiki on Centos 5.6

1. Download mediawiki from   http://www.mediawiki.org/wiki/Download
2. mkdir /wiki
3. cp mediawiki-1.16.4.tar.gz /wiki
4. cd /wiki
5. gtar -zxvf mediawiki-1.16.4.tar.gz
6. cd mediawiki-1.16.4/
7. mv * ..
8. cd ..
9. rmdir mediawiki-1.16.4/
10. chmod 777 config
11. cd /etc/httpd/conf
12. vi httpd.conf (add the following)
1. Alias /wiki "/wiki"
   <Directory "/wiki">
       AllowOverride None
       Options None
       Order allow,deny
       Allow from all
   </Directory>
13. /sbin/service httpd  restart

Install mysql
# yum install mysql-server
# service mysqld start
---cut here---
Initializing MySQL database:  Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h www.centosraka.org password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                                      [  OK  ]
Starting MySQL:                                            [  OK  ]

--cut here---

# mysql_secure_installation

Install PHP

yum install php php-mysql



Login to mysql

# mysql --user=root -p
mysql> show databases;
mysql> create databases wikidb;
mysql> show databases;
mysql> create user 'wikiuser'@'localhost' identified by 'password';
mysql> grant all on *.* to 'wikiuser'@'localhost';

 
Setting up the Wiki Page


http://192.168.1.22/wiki/


Follow the messages and enter passwords


mv LocalSettings.php ..
cd ..
chmod 700 LocalSettings.php


Create an account on the wiki if required and you are all set.

sync with ntp time server - centos

# yum install ntp
# chkconfig ntpd on
# ntpdate pool.ntp.org
# /etc/init.d/ntpd start