Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> replication: what is default username?
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
![]() |
![]() |