Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
Oracle agent doesn 't start

Oracle agent doesn 't start

2006-11-09       - By Sascha Wehnert

 Back
Reply:     1     2     3  

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 (See http://ORA-28590.ora-code.com): agent control utility: illegal
   or badly formed command                                failed

Looking up ORA-28590 (See http://ORA-28590.ora-code.com) 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 (See http://ORA-28591.ora-code.com): agent control utility: unable to access parameter file
ORA-28590 (See http://ORA-28590.ora-code.com): 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 (See http://ORA-28590.ora-code.com): 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