Tuesday 14 May 2013

You may also use a Oracle command oerr to check out what the error is all about. oerr is only available on the Linux and Unix platforms.

You may also use a Oracle command oerr to check out what the error is all about. oerr is only available on the Linux and Unix platforms.

oracle@xps:~$ oerr ora 19809
19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
//*Action:The error is accompanied by 19804. See message 19804 for further
//        details.

oracle@xps:~$ oerr ora 19804
19804, 00000, "cannot reclaim %s bytes disk space from %s limit"
// *Cause: Oracle cannot reclaim disk space of specified bytes from the
//         DB_RECOVERY_FILE_DEST_SIZE limit.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archivelog deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.

JDK Installation on Linux

JDK Installation on Linux


This document describes  how to install JDK on linux operating system.

Host Name : mwlr.mserver.com
User Name : root

Get the software from  :-
http://www.oracle.com/technetwork/java/javase/downloads/jdk6-downloads-1637591.html

 Select operation system version and download it software to server.  Run as follows.

[root@mw Middleware]# ./jdk-6u33-linux-i586-rpm.bin
Unpacking...

its done.njy

How to Change mount point name in Linux

How to Change mount point name in Linux

Here is steps to change to mount point name /home to /m01.


[root@moshe bea]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_moshe-lv_root
                       50G  9.6G   38G  21% /
tmpfs                 1.9G  288K  1.9G   1% /dev/shm
/dev/sda1             485M   52M  408M  12% /boot
/dev/mapper/vg_moshe-lv_home
                      633G  198M  600G   1% /home



Step 1 :
 [root@moshe ~]# umount /home



Step 2:

[root@moshe ~]# mkdir /m01

Step 3:
 Modify /home to /m01 in the file /etc/fstab.

root@moshe ~]# vi /etc/fstab
[root@moshe ~]# cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Tue Feb 12 09:27:54 2013
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_moshe-lv_root /                       ext4    defaults        1 1
UUID=93acbca6-0fdf-4798-9312-6303540cb185 /boot                   ext4    defaults        1 2
/dev/mapper/vg_moshe-lv_home /m01                   ext4    defaults        1
2

Drop Database in Oracle 10g

Drop Database in Oracle 10g

It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles, redologs, controlfiles and init parameter files.

$ sqlplus / as sysdba
SQL> Shutdown immediate;
SQL> Startup Mount Exclusive Restrict;
SQL> Drop Database;

RMAN: Archivelogs lost what to do


RMAN: Archivelogs lost

Problem: I have lost some of the archivelog files without taking backup. If I run the rman to backup available archive logs, it throws error that the archivelog_seq# is not available.

Solution: run the following command.

RMAN> change archivelog all validate;

Now you run the backup archivelog command. RMAN will backup the available archivelogs successfully.

FIX- ORA-04042: procedure, function, package, or package body does not exist

 FIX- ORA-04042: procedure, function, package, or package body does not exist


ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

Soln:

SQL> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

How to determine row count for all tables in an Oracle Schema?

How to determine row count for all tables in an Oracle Schema?

Set heading off
Set feedback off
Set pagesize 0
Set termout off
Set trimout on
Set trimspool on
Set recsep off
Set linesize 100
Column d noprint new_value date_
Column u noprint new_value user_
Spool tmp
Select 'Select '''||table_name||' : ''||count(*) from '||table_name||';',
    to_char(sysdate, 'YYYYMMDDHH24MISS') d, user u
from user_tables
order by table_name
/
Spool off
Spool count_&user_._&date_
@tmp.LST
Spool off