Re: SQL*Net TCP/IP and OPS$ accounts

In article <sd345.766068841_at_Victoria> sd345_at_city.ac.uk (COLLIER M P) writes:

> >Does anyone have any ideas why...
ops$name/password_at_T:machine:sid
/ _at_T:machine:sid
both machines.
connecting from a
version.
>
> Spot the deliberate mistake. The space in the line sqlplus / _at_T:machine:sid
> isn't there when I try it, the line should be sqlplus /_at_T:machine:sid.

1. For Oracle7, verify that REMOTE_OS_AUTHENT = TRUE in the database parameter file'(it's false by default).
2. For Oracle7, verify that OS_AUTHENT_PREFIX = OPS$ in the database parameter file (this is default).
3. For Oracle Net v1, verify that OPS$ logons are enabled with TCPCTL STAT (should be by default). OPS$ROOT is disabled by default.
4. For Oracle Net v2, I don't remember the syntax and have no manual nearby. Find a Net v2 manual. I think default behaviour is to accept OPS$ connections (same as v1).

hope this helps,

--

Magnus Lonnroth
Tech.Sales & Consultant
Oracle Sweden
Mail: mloennro_at_se.oracle.com