Link to home
Start Free TrialLog in
Avatar of daledog9
daledog9

asked on

Unable to configure DBconsole on Oracle 11.1.0.7.0

When configuring DB console on Oracle 11.1.0.7.0  (Linux 64bit installation of Oracle EBS R12) the repository is created successfully, but the configuration of the repsository fails with the following error message:

SEVERE: Error uploading configuration data to the repository

The log file shows the following:

CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptio
ns

        at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaCon
figuration.java:232)
        at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMRepos
Config.java:674)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.jav
a:535)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
istant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav
a:519)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
Jan 3, 2011 1:38:17 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /san01/oracle/PROD/db/tech_st/11.1.0/cfgtoollogs/
emca/PROD/emca_repos_config_<date>.log for more details.
Jan 3, 2011 1:38:17 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error uploading configuration data to the repository
Jan 3, 2011 1:38:17 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error uploading configuration data to the repository
Refer to the log file at /san01/oracle/PROD/db/tech_st/11.1.0/cfgtoollogs/emca/P
ROD/emca_2011_01_03_13_38_01.log for more details.
Jan 3, 2011 1:38:17 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration da
ta to the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
        at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
        at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.jav
a:535)
        at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
istant.java:1215)
        at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav
a:519)
        at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)

Sqlnet.ora and hosts file appear accurate

Thanks.




ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daledog9
daledog9

ASKER

Thank you,

The following solution (Recreating the password file) from the thread that you suggested has fixed my issue.  

SQL> show parameter remote_login_passwordfile
NAME TYPE VALUE
remote_login_passwordfile string EXCLUSIVE

SQL> select all t.* from v$pwfile_users t ;
USERNAME SYSDB SYSOP SYSAS
SYS TRUE TRUE FALSE

connect sys/manager_123@demo as sysdba
Warning: You are no longer connected to ORACLE.

/data/app/oracle/product/11.1.0/db_1/bin/orapwd file=/data/app/oracle/product/11.1.0/db_1/dbs/orapwdemo password=manager_123 force=y

connect sys/manager_123@demo as sysdba
Connected.