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

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=125.204.31.14)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=
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 11.1.0.7.0 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!!!!
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google