Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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