Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> replication: what is default username?

replication: what is default username?

From: Joerg Blaese <jb_at_blaese.softpoint.de>
Date: Sat, 06 Nov 1999 09:12:31 +0100
Message-ID: <3823E2EF.B49D8AB8@blaese.de>


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 - 02:12:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US