Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted May 12, 2016

Oracle SRVCTL Issue in 11.2.0.4

By David Fitzjarrell

Every once in a while Oracle produces interesting behavior, and has done so with release 11.2.0.4 using the Grid infrastructure. On AIX an issue was reported regarding an unexplained group ownership change. Let's look at the situation and see what Oracle did.

The reported behavior involves either the srvctl or crsctl utility and creates problems when either a database (using srvctl) or CRS (using crsctl) is started. Error messages that can be received include the following:


ORA-15025: could not open disk "/dev/griddisk/griddisk12"
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied

Both utilities will change the group ownership of the 'oracle' executable from its original setting to 'oinstall', or some variant of it, making any disk unreadable to the Oracle process. Oracle Support has filed this as Bug 19436183. Interestingly it doesn't affect the setUID and setGID bits on that file. Doing a bit of research uncovers a similar issue with Linux, filed as Bug 14197338. The latter bug shows no workaround or resolution, and it has been reported to change the group ownership to the entire group list that the 'oracle' user is assigned; Bug 19436183 provides the workaround of manually changing the group ownership back to its original value. That bug also reports that using sqlplus to start the database does not affect the group ownership, although that will require starting each node individually rather than having the convenience of using srvctl to start the entire RAC cluster.

Remember that Bug 19436183 also reports that using crsctl to start CRS results in the same issue; it would seem that starting the Cluster services in 11.2.0.4 will need to be completed, then the group ownership of the Oracle executable changed so that sqlplus can be used to finally start the databases. For a non-RAC implementation (using ASM) this isn't as inconvenient as it becomes for a RAC implementation, since RAC clusters can span from 2 to 255 nodes starting each instance with sqlplus could be a tedious task, indeed. As stated previously no fix is reported for either bug, however apparently there have been no reports to Oracle Support that Version 12.1.0.x is affected. Since 11.2.0.4 is the latest release of 11.2 it's possible that this is the terminal release of that version, and that users might seriously consider upgrading to 12.1.0.2 to rid themselves of this issue.

See all articles by David Fitzjarrell



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM