General
cancel
Showing results for 
Search instead for 
Did you mean: 

using ops$ as oracle database account.

ram_26
Occasional Contributor

using ops$ as oracle database account.

hi,

Im using hp-ux11i and oracle 9i Rel2 database

I have a user "ops$ods_admin" when i try to issue a command

$ sqlplus ops$ods_admin/password

it is saying that parameter not set....

how can i proceed further... this i am using for my OS authentication in scripts....

Please help me its very urgent...

--ram
10 REPLIES
Indira Aramandla
Honored Contributor

Re: using ops$ as oracle database account.

Hi Ram,

OPS$ accounts are a way to use operating-system userids as the basis for ORACLE usernames. Instead of users being authenticated by Oracle, users are authenticated by the operating system.

Once the OPS$ accounts have been created, you will have to define the OS_AUTHENT_PREFIX parameter in the init.ora to define the prefix used in the Oracle usernames:
OS_AUTHENT_PREFIX=OPS$

The default value of this parameter is "OPS$" for backward compatibility with previous versions of Oracle where the prefix had to be "OPS$".

Set the REMOTE_OS_AUTHENT parameter to TRUE in the init.ora:
REMOTE_OS_AUTHENT=TRUE

Invoke any ORACLE tool and use a '/' to indicate OPS$ accounts will be used. For example, if you type:

sqlplus /

I Hope this helps.


Indira A
Never give up, Keep Trying
ram_26
Occasional Contributor

Re: using ops$ as oracle database account.

Hi Indira,

Thnx for ur response but it seems it is not working... those two parameters are already in init.ora file... but still the same....

is there any thing do i need to set in unix side....

thnx in advance.

--ram
Michael Schulte zur Sur
Honored Contributor

Re: using ops$ as oracle database account.

Hi,

$ods_admin is an environment variable for the shell. If you use bourne shell and have -u acivated, then it complains about $ods_admin not set.
try sqlplus ops\$ods_admin/password

hth,

Michael
ram_26
Occasional Contributor

Re: using ops$ as oracle database account.

hi micheal,

Thnx for ur valuable information.

Where as i have old unix box there i use to login as "csh" and issue command says

$ORACLE_HOME/bin/sqlplus /@ods

In my new unix box I have created a user which uses csh and try to issue the same command which says invalid userid and password.

do i need to set anything else in csh....?

thnx in advance
--ram
Michael Schulte zur Sur
Honored Contributor

Re: using ops$ as oracle database account.

Hi,

you want to login as ods_admin, right?
Try sqlplus "ods_admin@ods"

hth,

Michael
Yogeeraj_1
Honored Contributor

Re: using ops$ as oracle database account.

hi,

can you please post the output of:

echo $LOGNAME

The output must be: ODS_ADMIN for it to work as you wish.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
ram_26
Occasional Contributor

Re: using ops$ as oracle database account.

Hi Michael,

I would like to connect to oracle by issuing statement as

sqlplus /@ods9i


Hi Yogeeraj,

When I issue $LOGNAME the result is "oracle", how can I change this to ods_admin.. please let me know.

thnx
--ram
Brian Crabtree
Honored Contributor

Re: using ops$ as oracle database account.

Ram,

To use external authentication, you just want to issue it as:

sqlplus /

However, setting REMOTE_OS_AUTHENT will open up a large security hole in your database. Anyone with a username of 'ods_admin' (or any OS authenticated user) would be able to access your user from any machine that they configured a TNS entry to connect to your database.

Thanks,

Brian
Yogeeraj_1
Honored Contributor

Re: using ops$ as oracle database account.

hi ram,

you should create an user ("ods_admin") at the OS level and modify the profile so that it matches that of the "oracle" user.

then it will work.

best regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: using ops$ as oracle database account.

Hi Ram,

Yes as Yogeeraj said, you have to create the user at the OS level and define the profile to set ORACLE_HOME, ORACLE_SID...... and all the other environment variables.

And you will hav ehte same user created in the oracle database as well. Then when you logon to the server as that user all you need to do is

sqlplus / without any userid or password as the authentication is already done at the OS level.


Indira A
Never give up, Keep Trying