ops$user i n oracle

[Radim Jarosek]

Hi all,

could anybody explain me %subject% ?
I think this for login from shell to sqlplus.
Is it right ?

Thanks for help

Radim

[James R. Ferguson]

Radim:

Yes, I believe that this is a user within ORACLE.

...JRF...

[John Palmer · Accepted solution]

The ops$ in Oracle is a database user identified 'externally'.

This means that the database does not have a password for the user but allows them to login directly from a shell prompt with 'sqlplus /'. Security is limited to the UNIX login and password.

The string 'OPS$' is configurable in the Oracle init file, OPS$ being the default.

[Radim Jarosek]

John:

Yes, you're right.

I have checked parameter ops$ and I have set it.
But still cannot logon from shell to sqlplus.

Radim

[John Palmer]

What error do you get when you type sqlplus /

If it's just 'sh: sqlplus: not found.' then you need to setup the relevant Oracle environment in the user's .profile.

Shell variables that you need are:-
ORACLE_SID
ORACLE_HOME
SHLIB_PATH (for Oracle 8)

You also need $ORACLE_HOME/bin added to your PATH variable.

[Radim Jarosek]

John :

Sorry for my delay, but I was busy.

The problem was that I didn't create user
"identified externally". I didn't know
what's it means.
So now I know it. :-)

Thanks for your help

Radim