//
you're reading...
Grid Infrastructure, Oracle, RAC

ORA-12537 and Role Separation in 11gR2 RAC

In 11gR2 when you set up your cluster and RAC database with different OS users, you may get ORA-12537 when connecting to the database through SCAN listener. Listener and SCAN listeners are started in grid infrastructure home, which is owned by a different OS user from RDBMS home owner. In such configuration two things can cause ORA-12537:

1) Grid owner cannot see RDBMS home binary

As grid owner, do “ls -l <RDBMS Home>/bin/oracle”. If getting “permission denied” then this is access problem.

2) The permission “-rwxr-x–x” is wrong as it’s missing suid bit, oracle binary should have permission of 6751

/u01/app/oracle/product/11.2.0/dbhome_1/bin >ls -l oracle
-rwsr-s–x 1 oracle asmdba 228934980 Jul 25 14:35 oracle

Fixing these two issues can solve ORA-12537 error.

Advertisements

About Hong Wang

I am an Oracle DBA, working in Oracle database since version 7.3. Worked in both application development and production support. Many experiences in real world complicate problems and database projects. This blog serves as a collections of notes I write on my database studies as well as issues I encountered/solved. Your comments are well welcome.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: