Comments
| OS Authentication - A guide to configuring OS authentication on UNIX/Linux and Windows servers. |
Sergey said... Great! Very helpfull article! |
Joaquin Martinez said... Just a heads-up: On windows, you can supress the domain name from the usernames if you set the registry key OSAUTH_PREFIX_DOMAIN under your Oracle home (HOMEn where n is your oracle home number) to False. You can usee this effect in column OSUSER in v$session. |
Tim... said... Cool. Thanks for the tip.Cheers Tim... |
Matt said... Have you tried to attach a data pump job using OPS$ account? I could not do it. |
Rob said... coulnd't get ops$ variables to work, couldn't log in as the ops$test12 user I created ,either on unix or on windows ( yes, I added NTS to sqlnet.ora). |
Selvam Chinnasamy said... I heared OS authentication many times. But i don't have any practical exposure. After reading this document, I understood the difference between OS and pwd authentication. Good presentation |
Patrick said... This is the first time I've seen it explained clear and simple! Thanks! |
RAJESHKUMAR G said... is it possible communicate with osdba,osoper group? as per documentation. i faced[jay@rac3 bin]$ ./sqlplus / ./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory [root@rac3 ~]# chmod -R 755 /u01/app/oracle/product/10.2.0/db_1/ [jay@rac3 bin]$ $ORACLE_HOME/bin/relink all SQL> [jay@rac3 bin]$ ./sqlplus / SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 27 14:15:38 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied Enter user-name: [jay@rac3 bin]$ ls -l $ORACLE_HOME/bin/oracle -rwxr-xr-x 1 oracle oinstall 93300109 May 27 14:05 /u01/app/oracle/product/10.2.0/db_1/bin/oracle [root@rac3 ~]# chmod -R 6751 /u01/app/oracle/product/10.2.0/db_1/ [jay@rac3 bin]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x 1 oracle oinstall 93300109 May 27 14:05 /u01/app/oracle/product/10.2.0/db_1/bin/oracle [jay@rac3 bin]$ [jay@rac3 bin]$ ./sqlplus / SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 27 14:19:09 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> desc user_users; Name Null? Type ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) SQL> show user; USER is "OPS$JAY" SQL> select username from user_users; USERNAME ------------------------------ OPS$JAY |
RAJESHKUMAR G said... is it possible communicate without osdba,osoper group?i wrong typed it in previous comment. |
RAJESHKUMAR G said... hi tim,Preparing to Use Operating System Authentication To enable operating system authentication of an administrative user: 1. Create an operating system account for the user. 2. Add the account to the OSDBA or OSOPER operating system defined groups. else, we will get this error message, sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory regards, RAJESHKUMAR GOVINDARAJAN. |
ERICK said... Hellos with an OS account can I log on PLSQL DEVELOPER !THANKS |
Tim... said... Hi.Never tried. If you can, you will have to have SQL*Developer running on the same machine as the database. Cheers Tim... |
imran said... good work!! |
Mohamed Amin said... thanks for all your work , but why the link to •Selecting an Authentication Method is not found. please check it.Thanks |
Tim... said... Hi.Oracle change their URLs sometimes. I've corrected the link to the current location of their documents. Thanks for spotting this. Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!