ERROR:" ORA-24450: Cannot pre-process OCI statement" while running EMCA [message #652870] |
Tue, 21 June 2016 05:29 |
|
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
|
|
|
|
|
|
|