Articles Comments

AskDba.org Weblog » Archive for November 2009

11gR2 – SysAsm vs SysDba

November 30th, 2009 | Add a Comment

SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with SYSDBA role , you used to get a warning which was only recorded in alert log (Refer to my earlier post here). But things have changed in 11gR2. While trying to dismount a Diskgroup, I found following errors SQL> alter diskgroup flash_arc mount; alter diskgroup flash_arc mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15260: permission denied on ASM disk group Above error indicates that I do not have permission on the ASM Diskgroup.  As per 11gR2 documentation, SYSASM privilege is used for carrying out administration tasks on ASM Diskgroups. SYSDBA privilege can be used only for creating/deleting aliases and querying ASM dictionary views.  Frankly speaking, you should unlearn the habit of connecting as “/ … Read entire article »

Filed under: ASM, database, oracle

ORA-27146 Errors while starting up Database

November 27th, 2009 | Add a Comment

Short post on a issue faced by me, while starting up a cloned database SQL> startup nomount ORA-24323: value not allowed ORA-27146: post/wait initialization failed This database environment was cloned and was being started for first time after cloning. Running hcve scripts on system indicated that OS kernel parameters were adequately sized. SHMMNI set to 1000 is adequate SHMSEG set to 120 is adequate SEMMNI set to 700 is adequate SEMMNS set to 2000 is adequate MAX_THREAD_PROC set to 256 is adequate NFLOCKS set to 1450 is adequate My Oracle Support articles suggested this issue is related to semaphores setting. As settings were correct, I attempted to start instance by commenting processes parameter in init.ora (setting was 1000). This time database started. I modified the processes parameter back to 1000 and attempted to restart the Database. It started  again!! I am clueless … Read entire article »

Filed under: database, oracle