Hi,

I installed Oracle 10.2.0.1.0 on SLES10 and discovered some issues
I need some help with. Let's start with this one.

If I set START_ORACLE_DB_AGENT="yes" in /etc/sysconfig/oracle
I get

- Starting Agent...ORA-28590: agent control utility: illegal
  or badly formed command                     failed

Looking up ORA-28590 ends up in a hint to correct the syntax of the failed
agtctl but even if I run

ora10g:/opt/oracle/product/10.2/db_1/bin # ./agtctl --help

AGTCTL: Release 10.2.0.1.0 - Production on Thu Nov 9 15:42:57 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

I get:

ORA-28591: agent control utility: unable to access parameter file
ORA-28590: agent control utility: illegal or badly formed command

Environmentvariable TNS_ADMIN was set for test purposes to
$ORACLE_HOME/network/admin but didn't help:

ora10g:/opt/oracle/product/10.2/db_1/bin # echo $TNS_ADMIN
/opt/oracle/product/10.2/db_1/network/admin
ora10g:/opt/oracle/product/10.2/db_1/bin # ./agtctl

AGTCTL: Release 10.2.0.1.0 - Production on Thu Nov 9 16:03:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

AGTCTL> status
ORA-28590: agent control utility: illegal or badly formed command
AGTCTL>

tnsnames.ora looks like this:

ORA10G =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = ora10g.qstest.torexretail)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = ORA10G.qstest.torexretail)
  )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  )
  (CONNECT_DATA =
   (SID = PLSExtProc)
   (PRESENTATION = RO)
  )
)

Any ideas what could be wrong?
BTW: I am new to the whole Oracle stuff. Do I need the agent?

Kind regards,
i.A. Sascha Wehnert
--
Torex Retail Workforce Management Solutions GmbH

Berliner Straße 2, D-27721 Ritterhude
Tel. +49 (0) 4292 9909-0
Fax +49 (0) 4292 9909-88

Mailto:sascha.wehnert@(protected)
http://www.torexretail.de