Re: Remote OS Authentication in Oracle

Configuring OS authentication on Linux

1. Set setuid on $ORACLE_HOME/bin/oracle

 cd $ORACLE_HOME/bin

 chmod 6751 oracle

 This is done to avoid the following error :

 ERROR:
 ORA-01034: ORACLE not available
 ORA-27121: unable to determine size of shared memory segment  Linux Error: 13: Permission denied

2) chmod -R 775 /u01/app/oracle

3) Connect to your database as sysdba

   Verify the initialization parameter os_authent_prefix value. ( we suppose it's ops$)

4) Create a user :

   SQL > create user ops$user1 identified externally;

   SQL > grant connect to ops$user1;

5) At the os level, as root , create the user1 user:

   useradd user1

   passwd user1

6) export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

       export PATH=$PATH:$ORACLE_HOME/bin

       export ORACLE_SID=DEV1

       sqlplus /

Hope this will help.

Rachid.

"Oracle DBA" <maheshselvaraj_at_gmail.com> wrote in message news:1166663648.577988.27800_at_80g2000cwy.googlegroups.com...
> Hi,
>
> Please let me know how to connect with the remote server in oracle as
> OS User.
>
> ex:- sqlplus /@remote_database
>
> Regards
> Mahesh S
>
Received on Thu Dec 21 2006 - 18:02:29 CST