Re: replication: what is default username?

On Sat, 06 Nov 1999 09:12:31 +0100, Joerg Blaese <jb_at_blaese.softpoint.de> wrote:

>Hi,
>I'm playing a little bit with advanced replication on a 8.0.3. server.
>The environment SEEMS TO BE set up properly, but
>scheduled jobs (dbms_refresh.refresh(...)) don't succeed, while the same
>job explicit started from either sql command or from replication manager
>succeeeds.
>The alert log of the background process shows the following error:
>
>Fri Nov 5 19:01:39 1999
>Fri Nov 5 19:01:39 1999
>*** SESSION ID:(9.61) 1999.11.05.19.01.39.636
>ORA-12012: error on auto execute of job 28
>ORA-01004: default username feature not supported; logon denied
>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 380
>ORA-06512: at "SYS.DBMS_IREFRESH", line 450
>ORA-06512: at "SYS.DBMS_REFRESH", line 182
>ORA-06512: at line 1
>
>is default username a configurable parameter of the database/instance?
>can I run the scheduled job as a dedicated user?
>
>TIA
>Joerg

Apparently you are using an Os authenticated user/OPS$ account and your database isn't configured to use that. Check your sqlnet.ora for
sqlnet.authentication_services = (NTS)
and your init.ora for
remote_os_authent = true

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Nov 06 1999 - 03:02:05 CST