Home » RDBMS Server » Enterprise Manager » Not able to create EM repository
Not able to create EM repository [message #348078] Mon, 15 September 2008 10:03 Go to next message
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 Go to previous messageGo to next message
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 #348198 is a reply to message #348090] Tue, 16 September 2008 00:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Manually drop and Create OEM repository.
Re: Not able to create EM repository [message #348236 is a reply to message #348198] Tue, 16 September 2008 03:12 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
Both the steps I mentioned earlier were done manually using emca
Re: Not able to create EM repository [message #348252 is a reply to message #348236] Tue, 16 September 2008 03:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Drop manually means
1. connect with sqlplus
2. drop all public synonym related to SYSMAN.
3. drop mgmt_user user
4. drop mgmt_view user
5. drop sysman user

then run EMCA and create new REPOSITORY.

if still fail then contact oracle support for further investigation.
Re: Not able to create EM repository [message #348253 is a reply to message #348236] Tue, 16 September 2008 03:55 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Metric for locked accounts
Next Topic: CaptureBaseline Param locale not provided
Goto Forum:
  


Current Time: Tue Jul 22 17:18:20 CDT 2014

Total time taken to generate the page: 0.11319 seconds