Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)