Troubleshoot Fix EMCA Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) ORA-01031: insufficient privileges



The Eucharistic Miracles of the World
This error is generally comes with the emca OEM configuration. To fix this you have set following parameters. Also recreate the password file.
Error Description: [23-06-2011 05:15:18] Enter SYS user's password :
[23-06-2011 05:15:18]
[23-06-2011 05:15:18] Getting temporary tablespace from database...
[23-06-2011 05:15:18] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=
prod9))): ORA-01031: insufficient privileges (DBD ERROR: OCISessionBegin)
How to Fix?
Step 1. Rename the existing password file to another name. Password file is in $ORACLE_HOME/dbs directory.
Step 2 Recreate the password file
       Unix: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<systempassword> entries=5
       Windows: C:\> orapwd file=%ORACLE_HOME%\database\pwd%ORACLE_SID% password=<systempassword> entries=5
Step 3. Set following environment parameters
       export TNS_ADMIN=$ORACLE_HOME/network/admin
       export HOSTNAME=<HOSTNAME mentioned in listener.ora>
       export ORACLE_SID=PROD9
       export ORACLE_HOME= /data/oracle/product/11.1.0
Step 4. Try again with following command.
$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Jun 23, 2011 5:27:34 AM
EM Configuration Assistant, Version Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: prod9
Listener port number: 1522
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Jun 23, 2011 5:27:47 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /data/oracle/cfgtoollogs/emca/prod9/emca_2011_06_23_05_27_34.log.
Jun 23, 2011 5:27:49 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Jun 23, 2011 5:27:50 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jun 23, 2011 5:37:25 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jun 23, 2011 5:37:26 AM

Try it!!!!


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer