Archive

Archive for August, 2011

ora-01653 unable to extend table in tablespace

August 27, 2011 Leave a comment

I got the below error message when i tried to insert a record into table.

ora-01653 unable to extend table in tablespace

Now we need to query the dba_data_files tables and see autoextend is off or not.

select file_name,tablespace_name,autoextensible from dba_data_files
where tablespace_name=’TBS_DS_OWNER’

If value of “AUTOEXTENSIBLE” column is NO, check how many bytes are used by Oracle and max size of the tables space by using following queries.

how many bytes used by oracle:

SELECT
tablespace_name,
SUM(bytes/1024/1024)
FROM
dba_segments
GROUP BY
tablespace_name;

Max  size of the tablespace:

select tablespace_name,sum(bytes)/1024/1024 “Max Size in MB” from dba_data_files
where tablespace_name=’TBS_DS_OWNER’
group by tablespace_name

If the difference between this value and max size value is small then we need to add datafile or increse the size of the the datafile to insert more records.

Thanks

Advertisements
Categories: ora-errors

oracle dataguard setup using enterprise manager grid control 11g

August 21, 2011 Leave a comment

In this article i will explain steps used to create physical stand by database using Oracle enterprise manager grid control 11g.

Log into 11g grid control usign sysman.

Primary Database details:

Database Instance: ukdgpdv1.ukatru.com

Instance Name : ukdgsdv1

dg — dataguard

s–standby

Thanks

Uma

Categories: Dataguard

Raw Device Setup on linux– oracle 10gr2 and 11gr1 for ocr and voting disks

August 6, 2011 Leave a comment

Raw Device Setup

This step is only necessary if you want ocr and voting disks on raw devices without using any cluster file system(OCFS2,GPS,NFS,..)

[root@oral7001 iscsi]# fdisk -l

Disk /dev/sda: 16.1 GB, 16106127360 bytes
255 heads, 63 sectors/track, 1958 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14        1958    15623212+  8e  Linux LVM

Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        2610    20964793+  83  Linux

Disk /dev/sdc: 1073 MB, 1073741824 bytes
34 heads, 61 sectors/track, 1011 cylinders
Units = cylinders of 2074 * 512 = 1061888 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sdc1               1        1011     1048376+  83  Linux

Disk /dev/sdd: 1073 MB, 1073741824 bytes
34 heads, 61 sectors/track, 1011 cylinders
Units = cylinders of 2074 * 512 = 1061888 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sdd1               1        1011     1048376+  83  Linux

Disk /dev/sde: 1073 MB, 1073741824 bytes
34 heads, 61 sectors/track, 1011 cylinders
Units = cylinders of 2074 * 512 = 1061888 bytes

Device Boot      Start         End      Blocks   Id  System
/dev/sde1               1        1011     1048376+  83  Linux

Edit the /etc/sysconfig/rawdevices file, adding the following lines.I am using iscsi disks and hence used udev rules for persistent naming conventions.

[root@oral7001 iscsi]# ls -tlr
total 0
drwxr-xr-x 2 root root 80 Aug  6 12:06 oral7001_crs1
drwxr-xr-x 2 root root 80 Aug  6 12:09 oral7001_crs2
drwxr-xr-x 2 root root 80 Aug  6 12:10 oral7001_crs3

[root@oral7001 sysconfig]# cat rawdevices
# raw device bindings
# format:  <rawdev> <major> <minor>
#          <rawdev> <blockdev>
# example: /dev/raw/raw1 /dev/sda1
#          /dev/raw/raw2 8 5
/dev/raw/raw1   /dev/iscsi/oral7001_crs1/part1
/dev/raw/raw2   /dev/iscsi/oral7001_crs2/part1
/dev/raw/raw3  /dev/iscsi/oral7001_crs3/part1

[root@oral7001 sysconfig]# chkconfig –list | grep raw
rawdevices      0:off   1:off   2:off   3:off   4:off   5:off   6:off
[root@oral7001 sysconfig]# chkconfig –levels 345 rawdevices on

Start the rawdevices service using the following command.

[root@oral7001 sysconfig]# service rawdevices restart
Assigning devices:
/dev/raw/raw1  –>   /dev/iscsi/oral7001_crs1/part1
/dev/raw/raw1:  bound to major 8, minor 49
/dev/raw/raw2  –>   /dev/iscsi/oral7001_crs2/part1
/dev/raw/raw2:  bound to major 8, minor 65
/dev/raw/raw3  –>   /dev/iscsi/oral7001_crs3/part1
/dev/raw/raw3:  bound to major 8, minor 33
done

[root@oral7001 tmp]# cat raw_set_permissions.sh
chown oracle:oinstall /dev/raw/raw1
chown oracle:oinstall /dev/raw/raw2
chown oracle:oinstall /dev/raw/raw3
chmod 600 /dev/raw/raw1
chmod 600 /dev/raw/raw2
chmod 600 /dev/raw/raw3

Note : Installing Oracle Clusterware files on raw or block devices is no longer supported.

Thanks

Categories: oracle-install

Removing a node from Oracle RAC 11gR2

August 5, 2011 Leave a comment

In this article we will see how to remove an unreachable or destroyed node from an existing 11gr2 cluster.

The example below is based on 11.2.0.2 Release.

I have 2 node oracle rac on esxi and i am powering off second node and you can see the following message in the first node log file.

cd /u01/app/root/product/11.2.0/grid/log/oral8001

[cssd(11407)]CRS-1601:CSSD Reconfiguration complete. Active nodes are oral8001 .
2011-08-05 10:54:11.301
[crsd(11662)]CRS-5504:Node down event reported for node ‘oral8002’.
2011-08-05 10:54:11.488
[crsd(11662)]CRS-2773:Server ‘oral8002’ has been removed from pool ‘Free’.

Assumption is node2 is completely dead and we are deleting it from the existing cluster.Now node2 is not reachable then use node1 to do the cleanup process.

$ ./olsnodes -s -t
oral8001        Active  Unpinned
oral8002        Inactive        Unpinned

[root@oral8001 bin]# ./crsctl delete node -n oral8002
CRS-4661: Node oral8002 successfully deleted.

$ pwd
/u01/app/root/product/11.2.0/grid/oui/bin

$ ls
addLangs.sh  attachHome.sh  filesList.bat         filesList.sh  resource      runInstaller     runSSHSetup.sh
addNode.sh   detachHome.sh  filesList.properties  lsnodes       runConfig.sh  runInstaller.sh

$ ./runInstaller -updateNodelist ORACLE_HOME=/u01/app/root/product/11.2.0/grid “CLUSTER_NODES={oral8001}” CRS=true
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB.   Actual 2391 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
‘UpdateNodeList’ was successful.

$ ./olsnodes -s -n
oral8001        1       Active

if you have any database instances on this node use dbca and select instance management and delete the instance.

 

Thanks

Categories: oracle-install
%d bloggers like this: