| Not able to create EM repository [message #348078] |
Mon, 15 September 2008 10:03  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I am using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 on Oracle Enterprise Linux
I am tring to create EM repository using
emca -config dbcontrol db -repos create
but I faced this error. The sysman account doesn't exist and I think so this account gets created when the repository is created.
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log.
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig updateReposVars
SEVERE: File/directory /u01/app/oracle/product/10.2.0/db_1/sysman/emdrep/config/repository.variables does not exist
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_03-07-11-PM.log for more details.
These are the contents of the log file
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig grantPrivsToDbsnmp
CONFIG: Exception while granting priviliges.
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00942: table or view does not exist
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1708)
at oracle.sysman.emcp.EMReposConfig.grantPrivsToDbsnmp(EMReposConfig.java:503)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:208)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Failed to grant priviliges to dbsnmp.
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig updateReposVars
SEVERE: File/directory /u01/app/oracle/product/10.2.0/db_1/sysman/emdrep/config/repository.variables does not exist
15-Sep-2008 15:07:30 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: STEINITO, oracleHome: /u01/app/oracle/product/10.2.0/db_1, and user: SYS
15-Sep-2008 15:07:30 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: Unlocking dbsnmp and sysman
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: ORA-06550: line 1, column 62:
PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
ORA-06550: line 1, column 62:
PL/SQL: Statement ignored
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-06550: line 1, column 62:
PLS-00201: identifier 'SYSMAN.MGMT_VIEW_PRIV' must be declared
ORA-06550: line 1, column 62:
PL/SQL: Statement ignored
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1708)
at oracle.sysman.emcp.EMReposConfig.unlockAccounts(EMReposConfig.java:566)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:235)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)15-Sep-2008 15:07:30 oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
15-Sep-2008 15:07:30 oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:239)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
Let me know what has to be done
|
|
|
|
| Re: Not able to create EM repository [message #348090 is a reply to message #348078] |
Mon, 15 September 2008 10:42  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Tried dropping the repository but was not successful too.
WARNING: java.io.IOException: /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager: not found
15-Sep-2008 16:19:57 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Stack trace:
java.io.IOException: java.io.IOException: /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager: not found
at java.lang.UNIXProcess.<init>(UNIXProcess.java:143)
at java.lang.Runtime.execInternal(Native Method)
at java.lang.Runtime.exec(Runtime.java:566)
at java.lang.Runtime.exec(Runtime.java:491)
at oracle.sysman.emcp.util.PlatformInterface.executeCommand(PlatformInterface.java:1347)
at oracle.sysman.emcp.util.PlatformInterface.executeCommand(PlatformInterface.java:1301)
at oracle.sysman.emcp.EMReposConfig.dropRepository(EMReposConfig.java:462)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:161)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)15-Sep-2008 16:19:57 oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=itourdb1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=STEINITO.STEINTRAVEL.IE))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_repos_drop_2008-09-15_04-19-57-PM.log
15-Sep-2008 16:19:57 oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
15-Sep-2008 16:19:57 oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_repos_drop_<date>.log for more details.
15-Sep-2008 16:19:57 oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/STEINITO/emca_2008-09-15_04-19-40-PM.log for more details.
15-Sep-2008 16:19:57 oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:173)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
|
|
|
|
|
|
|
|
|
|
| Re: Not able to create EM repository [message #348253 is a reply to message #348236] |
Tue, 16 September 2008 03:55 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
Same problem with me, i am unable to drop EM repository in Oracle 10g by using following:
emca -deconfig dbcontrol db -repos drop
It is hanging after getting password of sysman
|
|
|
|
| Re: Not able to create EM repository [message #348364 is a reply to message #348253] |
Tue, 16 September 2008 09:27 |
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
|
Senior Member |
|
|
Hi,
I am using 10.2.0.1. Oracle 10g on linux, Database is installed successfully, database can be accessed from remote client, everything is running fine except EM
I can log in the EM but when i am logging in successfully. it is showing me pending status of database, when i check the status of dbconsole and agent.
It seems that agent is having a problem
We tried to recreate repository, but it is hanging while dropping old repository
Is there any way that we could create agent again
emctl status dbconsole
TZ set to GB-Eire
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://p1.mo1.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
and agent status is showing following
TZ set to GB-Eire
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.1.0.4.1
OMS Version : 10.1.0.4.0
Protocol Version : 10.1.0.2.0
Agent Home : /home/u01/app/oracle/product/10.2.0/db_1/p1.mo1.com_db2
Agent binaries : /home/u01/app/oracle/product/10.2.0/db_1
Agent Process ID : 19510
Parent Process ID : 11189
Agent URL : http://p1.mo1.com:3938/emd/main
Started at : 2008-09-16 14:54:34
Started by user : oracle
Last Reload : 2008-09-16 14:54:34
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 42
Size of XML files pending upload(MB) : 29.26
Available disk space on upload filesystem : 87.77%
---------------------------------------------------------------
Agent is Running and Ready
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
