composite unique constraint mysql

alter table room_new add unique key(room_no,rack_no,slot_no)

stealthpuppy / Script Corner

stealthpuppy / Script Corner

Index on Miscellaneous Items (JL Comp)

Index on Miscellaneous Items (JL Comp)

www.oracledba.co.uk

www.oracledba.co.uk

Joomla! Extensions Directory - Tools

Joomla! Extensions Directory - Tools

How to drop a dismounted ASM disk group?

Problem :

I was not able to Mount or Drop ASM disk group.

SQL> select group_number, name, STATE from v$asm_diskgroup;

GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
3 RAC_DATA1 DISMOUNTED
4 RAC_DATA2 DISMOUNTED
3 RAC_DG1 MOUNTED
4 RAC_DG2 MOUNTED

SQL> drop diskgroup RAC_DATA1;
drop diskgroup RAC_DATA1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "RAC_DATA1" does not exist or is not mounted

SQL> alter diskgroup RAC_DATA1 mount;
alter diskgroup RAC_DATA1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

Solution


I have followed ML Note:268481.1
Re-creating ASM Instances and Diskgroups

I have used force option while creating diskgroups

Complete checklist for manual upgrades to 10gR2

I referred the following Metalink Notes for the same.

316889.1
233436.1

How to calculate folder size in Linux

du -ahc folder_name

Solaris User Profile Customization

Edit /etc/profile

#User Profile Customization
PS1="\u@\h\w>"
export PS1
TERM=vt100
export TERM

It will set prompt as USER@HOSTNAME

How to find out which version of Linux

How to determine if Linux is 64bit ?

uname -a

Linux snook.srv.bang.indorion.org 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17 EDT 2006 i686 i686 i386 GNU/Linux

x86_64 GNU/Linux indicates I have 64bit CPU. If you use see i386/i486/i586/i686 it is a 32 bit CPU.

How to find out which version of Linux you are running ?
Method 1

ls /etc/*release*
ls /etc/*version*

This will give you a file that contains the version.
cat file_that_ls_found

Method 2

uname -a (prints all information)

uname -r (prints the kernel release)

uname -v (prints the kernel version)

uname -o (prints the operating system)

Oracle Edition Version Check

select * from v$version;

select * from PRODUCT_COMPONENT_VERSION;

SET SERVEROUT ON
EXEC DBMS_OUTPUT.PUT_LINE (DBMS_DB_VERSION.VERSION);

query CRS version

srvctl -V
export ORACLE_SID=+ASM

select status from v$instance;

select * from v$version;

crsctl query crs softwareversion
crsctl query crs activeversion

cemutlo -w

The cemutlo command is used by the EM agent to query CRS version.

Enter your search terms Submit search form