Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP!! unable to create db repository

HELP!! unable to create db repository

From: <donkarnash_at_gmail.com>
Date: 20 May 2007 03:32:00 -0700
Message-ID: <1179657120.634278.59730@q75g2000hsh.googlegroups.com>


Hi I am trying to replicate OH on Solaris and I followed the doc from metakink. I did:
cp /u01/app/development_home /u01/app/test_home # chown -R oratest /u01/app/test_home
Then I was trying to recreate the db repository and did: drop user SYSMAN cascade;
drop user MGMT_VIEW cascade;
drop role MGMT_USER;
drop public synonym MGMT_TARGET_BLACKOUTS; drop public synonym SETEMVIEWUSERCONTEXT;

Then now when I
$ emca -config dbcontrol db -repos recreate

It fails and I see the following in the log file:

Dropping Roles/Synonymns/Tablespaces ... File - /tmp/CevOkIXOj7/ O5cTdVMCog.sql.Return code = 0.Done.
Unquiescing DB ... Temp File - /tmp/KQT4rVuwVM/W6sIa4mD4Q.sql. Return code = 0.Done.
Dropping Repository failed. Please check file /u01/app/oratest/product/ 10.2.0/db_1/cfgtoollogs/emca/mnistest/
emca_repos_drop_2007-05-18_01-29-07-PM.log for detailed errors.

May 18, 2007 1:29:17 PM oracle.sysman.emcp.util.PlatformInterface executeCommand

CONFIG: stty: : No such device or address
stty: : No such device or address
stty: : No such device or address
stty: : No such device or address

ORA-06550: line 1, column 7:
ORA-06550: line 1, column 7:

May 18, 2007 1:29:17 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oratest/product/10.2.0/db_1/sysman/ admin/emdrep/bin/RepManager -connect
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=my_host)
(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=test_db))) -repos_user SYSMAN
-action drop -verbose -output_file /u01/app/oratest/product/10.2.0/ db_1/cfgtoollogs/emca/mnistest/emca_repos_drop_2007-05-18_01-29-07- PM.log
May 18, 2007 1:29:17 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error dropping the repository
May 18, 2007 1:29:17 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer to the log file at /u01/app/oratest/product/10.2.0/db_1/ cfgtoollogs/emca/mnistest/emca_repos_drop_<date>.log for more details. May 18, 2007 1:29:17 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oratest/product/10.2.0/db_1/ cfgtoollogs/emca/mnistest/emca_2007-05-18_01-28-45-PM.log for more details.
May 18, 2007 1:29:17 PM 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:182)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:133)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at
oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java: 485)
at
oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java: 1141)
at
oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java: 469)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java: 418)

Any ideas ??
The listener is configured to port 1523 and I can tnsping and connect to the test_db. Received on Sun May 20 2007 - 05:32:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US