Re: replication: what is default username?

HI!

It really seems that the environment is not set up properly. Have a look at your database links,users,passwords and connect strings (tnsnames.ora)

The error
> ORA-01004: default username feature not supported; logon denied
comes up if you try to connect like sqlplus /@othersideinstance and the switch REMOTE_OS_AUTHENT=YES is not set in init.ora! For this you need the same user on both sides.

Hope this helps

Thorsten

Joerg Blaese schrieb:
>
> 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
Received on Sat Nov 06 1999 - 04:37:32 CST