Some thoughts gleaned from my years of Oracle Database Administration experience (version 5 through 12c). Primarily focused on Unix/Linux OS's, dealing with Very Large Databases (multi-terabyte). Some tables in excess of 700 gigabytes, ASM, RAC, and a lot of other fun things. I might even add some thoughts about third party Campaign Tools, such as Unica which I use to support. Who knows where we might end up.
Wednesday, January 25, 2012
Twin UID's
Just today our DBA support group came across this little feller: One of our Oracle 11R2 instances running on Linux using LDAP suddenly started to no longer allow users who were logging in via putty to execute CTAS's or SQL*Loader. Oddly however, they could execute SQL*Plus with no issues. After troubleshooting the issue it was found that a LDAP group was created with the same UID as Oracle's. Once the new group received a unique UID the problem went away.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment