topic Re: using ops$ as oracle database account. in Operating System - HP-UX

using ops$ as oracle database account.

ram_26 — Mon, 16 Aug 2004 20:47:19 GMT

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

Re: using ops$ as oracle database account.

Indira Aramandla — Mon, 16 Aug 2004 23:26:35 GMT

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

Re: using ops$ as oracle database account.

ram_26 — Tue, 17 Aug 2004 00:36:51 GMT

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

Re: using ops$ as oracle database account.

Michael Schulte zur Sur — Tue, 17 Aug 2004 00:56:13 GMT

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

Re: using ops$ as oracle database account.

ram_26 — Tue, 17 Aug 2004 02:21:14 GMT

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

Re: using ops$ as oracle database account.

Michael Schulte zur Sur — Tue, 17 Aug 2004 06:32:41 GMT

Hi,

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

hth,

Michael

Re: using ops$ as oracle database account.

Yogeeraj_1 — Tue, 17 Aug 2004 07:23:14 GMT

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

Re: using ops$ as oracle database account.

ram_26 — Tue, 17 Aug 2004 20:17:51 GMT

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

Re: using ops$ as oracle database account.

Brian Crabtree — Tue, 17 Aug 2004 21:58:45 GMT

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

Re: using ops$ as oracle database account.

Yogeeraj_1 — Tue, 17 Aug 2004 22:32:59 GMT

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

Re: using ops$ as oracle database account.

Indira Aramandla — Tue, 17 Aug 2004 23:28:34 GMT

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