cancel
Showing results for 
Search instead for 
Did you mean: 

ops$user i n oracle

SOLVED
Go to solution
Radim Jarosek
Regular Advisor

ops$user i n oracle

Hi all,

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

Thanks for help

Radim
5 REPLIES
James R. Ferguson
Acclaimed Contributor

Re: ops$user i n oracle

Radim:

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

...JRF...
John Palmer
Honored Contributor
Solution

Re: ops$user i n oracle

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
Regular Advisor

Re: ops$user i n oracle

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
Honored Contributor

Re: ops$user i n oracle

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
Regular Advisor

Re: ops$user i n oracle

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