Re: Oracle Agent and getting rid of ORCL

Hi Bill,
Looks like your IA is dependent on the ORCL instance. Look at the listener section of your other parameter files, see if you can find this reference:--(CID=(PROGRAM=F:\orant\agentbin\DBSNMP.EXE).

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)))):

Let me know if that is the case.

Hope that helps.

Cheers,

Andrew kaluma

Bill Buchan wrote:

> 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 Tue Dec 22 1998 - 05:13:54 CST