Category Archives: Database
We need to install Oracle 11G and ASM point of view both node need to see same disk, generally multipath point of view when nodes come up its possible to see different LUN with different mapth name and its cause an issue for install oracle
There is an file under /etc/multipath which name is bindings , you can see that world wide name of disks and multipath names there.
What i did , take the one of node config file information as a baseline and copy it to other, then everything become okay, we do not have any issue of Oracle ASM configuration time about disk.
Related configuration is like below, hope its help for all
[root@kahin02-11g ~]# cat /etc/multipath/bindings
# Multipath bindings, Version : 1.0
# NOTE: this file is automatically maintained by the multipath program.
# You should not need to edit this file in normal circumstances.
# alias wwid
Connected server i couldn’t find enterprise manager and PL/SQL Developer already open and after some search ;
First need to get tablespace name 🙂
select * from dba_data_files
If you know the name of your tablespace type like below
select * from dba_data_files t where t.TABLESPACE_NAME = ‘xxxxxx’
Need to be resize then continue like below , this process will increase the size 50G not additional 50G 🙂
ALTER DATABASE DATAFILE ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\XXYPURFOLDER\YOUR_DATA_FILE.ORA’ RESIZE 50G;
Here you should be careful because you can touch the block limit of related datafile and need to be create additional one like below
To add additional datafile to tablespace then use such command below
ALTER TABLESPACE USERS_EK ADD DATAFILE ‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\XXYPURFOLDER\YOUR_DATA_FILE2.ORA’ SIZE 20G;
And you have to wait , i guess its writing 0 to all file and go !