Home » RDBMS Server » Enterprise Manager » ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA
ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652870] Tue, 21 June 2016 05:29 Go to next message
Tiana0000
Messages: 10
Registered: January 2014
Location: Nigeria
Junior Member
Good Day All,

I'm having issues installing Enterprise Manager oracle 11g.
So far this is what I've done...

1) ---- Deinstall EM ----

C:\Users\Administrator>emca -deconfig dbcontrol db -repos drop
 
STARTED EMCA at Jun 20, 2016 6:57:48 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
Database SID: SUN6DB
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
 
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 20, 2016 6:58:02 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\Administrator\cfgtoollogs\emca\SU
N6DB\emca_2016_06_20_18_57_47.log.
Jun 20, 2016 6:58:02 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
erformed.
Jun 20, 2016 6:58:02 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jun 20, 2016 7:00:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jun 20, 2016 7:00:40 PM

2) ----.Set environment variables ---------

set ORACLE_HOSTNAME=INFOR10SERVER
set ORACLE_UNQNAME=SUN6DB
set ORACLE_SID=SUN6DB
set ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_3

3) ---- Added Global_name to listener.ora --------------

SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
   (SID_NAME = orcl)
   (GLOBAL_DBNAME = orcl.yourdomain.com)
)
)

4) ---- Restarted Listener--

./lsnrctl stop
./lsnrctl start
 
C:\Users\Administrator>lsnrctl status
 
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 21-JUN-2016 09:19
:14
 
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=INFOR10SERVER.ndic-ng.co
m)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date                21-JUN-2016 09:17:51
Uptime                    0 days 0 hr. 1 min. 24 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Administrator\product\11.2.0\dbhome_3\network\a
dmin\listener.ora
Listener Log File         c:\app\administrator\diag\tnslsnr\INFOR10SERVER\listen
er\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=INFOR10SERVER.ndic-ng.com)(PORT=1521
)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "SUN6DB" has 2 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
  Instance "sun6db", status READY, has 1 handler(s) for this service...
Service "SUN6DBXDB" has 1 instance(s).
  Instance "sun6db", status READY, has 1 handler(s) for this service...
The command completed successfully

5) ----Then rerun the installation with emca------

C:\Users\Administrator>emca -config dbcontrol db -repos  create
 
STARTED EMCA at Jun 21, 2016 9:19:49 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
Database SID: SUN6DB
Listener port number: 1521
Listener ORACLE_HOME [ C:\app\Administrator\product\11.2.0\dbhome_3 ]: C:\app\Ad
ministrator\product\11.2.0\dbhome_3
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
 
You have specified the following settings
 
Database ORACLE_HOME ................ C:\app\Administrator\product\11.2.0\dbhome
_3
 
Local hostname ................ INFOR10SERVER
Listener ORACLE_HOME ................ C:\app\Administrator\product\11.2.0\dbhome
_3
Listener port number ................ 1521
Database SID ................ SUN6DB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
 
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jun 21, 2016 9:20:41 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\Administrator\cfgtoollogs\emca\SU
N6DB\emca_2016_06_21_09_19_49.log.
Jun 21, 2016 9:20:49 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 21, 2016 9:25:21 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jun 21, 2016 9:25:21 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at C:\app\Administrator\cfgtoollogs\emca\SUN6DB\emca
_repos_create_<date>.log for more details.
Jun 21, 2016 9:25:21 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at C:\app\Administrator\cfgtoollogs\emca\SUN6DB\emca_2016_
06_21_09_19_49.log for more details.
Could not complete the configuration. Refer to the log file at C:\app\Administra
tor\cfgtoollogs\emca\SUN6DB\emca_2016_06_21_09_19_49.log for more details.

So so...
The refereed file C:\app\Administrator\cfgtoollogs\emca\SUN6DB\emca_repos_create_<date>.log has the error below:

Quote:

.........
........
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

ERROR:
ORA-24450: Cannot pre-process OCI statement


After researching the error code I got the below solution.

Error Cause:
An error occurred during statement pre-processing. E.g., SQL statement has invalid usage of N" or Q" literals.
Action:
Correct the SQL statement.

Please statement am I to correct? Thanks
Re: ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652881 is a reply to message #652870] Tue, 21 June 2016 10:37 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
I don't think there is anything you can do at this stage, except for logging a call with Oracle Support.

Good luck and let us know what they say.
Frank
Re: ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652882 is a reply to message #652870] Tue, 21 June 2016 10:45 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
It may not be possible to fix this. Release 11.2.0.1 is long out of support. Is there a reason for using it? If you have a proper licence with a support contract you can download the terminal 11g release, 11.2.0.4, and the problem may no longer exist.
Re: ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652960 is a reply to message #652882] Thu, 23 June 2016 02:52 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Come to think of it, why don't you install OEM 12c, or even better, the latest 13c release.
Both can manage Oracle database 11g targets.
Re: ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652982 is a reply to message #652960] Thu, 23 June 2016 05:54 Go to previous message
Tiana0000
Messages: 10
Registered: January 2014
Location: Nigeria
Junior Member
Thanks for the suggestion, will try that now.
Previous Topic: EM 12c Cloud Control Install
Next Topic: Platform to central administration
Goto Forum:
  


Current Time: Tue Nov 26 06:03:09 CST 2024