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.
Showing posts with label Oracle Linux LDAP UID CTAS sqlplus sql loader. Show all posts
Showing posts with label Oracle Linux LDAP UID CTAS sqlplus sql loader. Show all posts
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:
Posts (Atom)