It looks like there is a problem with replication and it cannot see the
remote server. The snp processes are internal jobs (sort of like cron) that
will execute procedures.
Jim
naveen_arora_at_my-dejanews.com wrote in message
<76f6vg$4uj$1_at_nnrp1.dejanews.com>...
>hi ,
>
>I have observed cpu-time=0 twice on my unix machine running ORACLE
>7.3.2, dbshut/dbstart solves the problem, but i am not able to get to
>any conclusion.
>
>The SNP0,SNP1,SNP2,SNP3 are eating away all CPU.(all user
>process are eating time, with small io and system process)
>
>the oracle server (on unix) is in multi-master configuraton with 2
>others(on NT), refresh interval is 1 minute, no of job_process=4, the
>shared memory is 40MB, job_queu_interval is 10 sec, the no of updates i
>think are not large.
>
>TRACE FILE SHOWS :
>
>
>
>*** SESSION ID:(9.3127) 1998.12.17.15.03.46.330 ORA-12012: error on auto
>execute of job 2 ORA-23324: error ORA-04052: error occurred when looking up
>remote object SURROGATE.SYS_at_MGMT2.WORLD ORA-00604: error occurred at
>recursive SQL level 3 ORA-12203: TNS:unable to connect to destination
>ORA-12203: TN, while creating deferror entry at "MGMT2.WORLD" with error
>-12203 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 585 ORA-06512: at line 1
Thu
>Dec 17 15:06:18 1998 Thu Dec 17 15:06:18 1998 *** SESSION ID:(9.3129)
>1998.12.17.15.06.18.270 ORA-12012: error on auto execute of job 2
ORA-23324:
>error ORA-04052: error occurred when looking up remote object
>SURROGATE.SYS_at_MGMT2.WORLD ORA-00604: error occurred at recursive SQL level
3
>ORA-12203: TNS:unable to connect to destination ORA-12203: TN, while
creating
>deferror entry at "MGMT2.WORLD" with error -12203 ORA-06512: at
>"SYS.DBMS_DEFER_SYS", line 585 ORA-06512: at line 1 Thu Dec 17 15:08:50
1998
>
>
>WHEREAS ALL REMOTE OBJECTS ARE PRESENT and LINKS ARE ACTIVE.
>
>thanks for any help.
>naveen
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 31 1998 - 06:43:35 CST
