Oracle Agent and getting rid of ORCL

From: Bill Buchan <bbuchan_at_ossian.net>
Date: Mon, 21 Dec 1998 09:24:15 -0000
Message-ID: <75l3vv$nph$1@phys-ma.sol.co.uk>

Can anyone help me out here? I'm running out of ideas - any assistance would be much appreciated! I am running OEM 1.5.5 on my client and Oracle Intelligent Agent 8.0.4.1.1 on the server. It seems to run okay but I want to get rid of ORCL (which was created during installation) - and keep my other instances. As a first step I stop the OracleServiceORCL. However when this happens, every time I try to run an OEM job on the server the local agent crashes with a Dr. Watson. A file called orant\Net80\Agent\sqlnet is written each time that this happens and looks like this:

---

Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o
racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=F:\orant\agentbin\DBSNMP.EXE)(HOST=ORACLES VR)(USER=SYSTEM))))   VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.4.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.4.0.0 - Production
  Time: 17-DEC-98 17:20:15
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o
racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\cpqdbg.exe)(HOST=ORACLES VR)(USER=SYSTEM))))   VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.4.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.4.0.0 - Production
  Time: 17-DEC-98 17:21:16
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 0
    nt OS err code: 0

---

Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o
racle80orcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\drwtsn32.exe)(HOST=ORACL ESVR)(USER=SYSTEM))))   VERSION INFORMATION:
 TNS for 32-bit Windows: Version 8.0.4.0.0 - Production  Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.4.0.0 - Production
  Time: 17-DEC-98 17:21:17
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 0
    nt OS err code: 0

I have removed any reference to ORCL in the listener.ora and tnsnames.ora files, and I have changed ORACLE_SID in the registry to another instance. Where is it picking ORCL up from? If I restart OracleServiceORCL everything works okay again.

Can anyone help me get rid of ORCL!?

Many thanks
- Bill Buchan Received on Mon Dec 21 1998 - 03:24:15 CST