Home » RDBMS Server » Enterprise Manager » Unable to determine local host from URL REPOSITORY_URL (Oracle 10.2.0.1.0 windows 2003 server)
Unable to determine local host from URL REPOSITORY_URL [message #408622] Wed, 17 June 2009 01:49 Go to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi All

C:\Documents and Settings\Administrator.sriram>emctl getemhome
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
EMHOME=D:\oracle\xxxxxx/machine_name.domailname_ORACLE_SID

So i have already configured Dbcontrol......But

C:\Documents and Settings\Administrator.sriram>emctl  status dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://sriram.domainname:%EM_UPLOAD_PORT%/em/
upload/
 .


Do i need to reconfigure the DB CONTROL? Please suggest Or give any link....

Regards
Sriram
Re: Unable to determine local host from URL REPOSITORY_URL [message #408691 is a reply to message #408622] Wed, 17 June 2009 05:54 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to recreate the repository with the following:

set ORACLE_HOME=<your_oracle_home_name>
set ORACLE_SID=<your_sid_name>
 
emca -config dbcontrol db -repos recreate

[Updated on: Wed, 17 June 2009 05:56]

Report message to a moderator

Re: Unable to determine local host from URL REPOSITORY_URL [message #408703 is a reply to message #408691] Wed, 17 June 2009 06:29 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thank you ebrain for your replay....

Quote:
You may want to recreate the repository with the following:



No, what I am asking is why such error?

Where might be the cause?


And one more i executed your code at another Oracledb(10.1.0.2.0)

Z:\>emca -config dbcontrol db -repos recreate
Incorrect usage:
Its giving me the parameters might be the version difference.....right?

Thanks
Sriram

[Updated on: Wed, 17 June 2009 06:46]

Report message to a moderator

Re: Unable to determine local host from URL REPOSITORY_URL [message #408739 is a reply to message #408703] Wed, 17 June 2009 07:46 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to review the DB Console logs for clues as to why you are receiving that error.

ramoradba wrote on Wed, 17 June 2009 07:29

And one more i executed your code at another Oracledb(10.1.0.2.0)

Z:\>emca -config dbcontrol db -repos recreate
Incorrect usage:
Its giving me the parameters might be the version difference.....right?

Correct, that syntax is for the version that was referenced in your original post (10gR2).
Re: Unable to determine local host from URL REPOSITORY_URL [message #408745 is a reply to message #408739] Wed, 17 June 2009 09:16 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/html/B12013_03/structure.htm#sthref100

Very first time getting this error? Did you change hostname or
IP address? What about log file?

Thanks
Re: Unable to determine local host from URL REPOSITORY_URL [message #409599 is a reply to message #408745] Tue, 23 June 2009 04:42 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi ebrain & g.babu thanks for the help....Yes babu first time getting this kind of error.

Here is the issue

C:\>emca -config dbcontrol db -repos recreate

STARTED EMCA at Jun 23, 2009 2:35:58 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.2.0\db_1

Database hostname ................ sriram
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jun 23, 2009 2:36:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-06-23_02-35-57-PM.log.
Jun 23, 2009 2:36:59 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5540 is already in use.
Jun 23, 2009 2:36:59 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5520 is already in use.
Jun 23, 2009 2:36:59 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5500 is already in use.
Jun 23, 2009 2:36:59 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 1830 is already in use.
Jun 23, 2009 2:36:59 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jun 23, 2009 2:38:39 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Jun 23, 2009 2:38:43 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jun 23, 2009 2:38:44 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 23, 2009 2:38:45 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jun 23, 2009 2:38:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.
Jun 23, 2009 2:38:45 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-06-23_02-35-57-PM.log for more details.
Could not complete the configuration. Refer to the log file at D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-06-23_02-35-57-PM.log for
 more details.

C:\>D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-06-23_02-35-57-PM.log

C:\>set oracle_sid=orcl


C:\>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://sriram:5500/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory D:\oracle\product\10.2.0\db_1/sriram_orcl/sysman/log

C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
http://sriram:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The service name is invalid.

More help is available by typing NET HELPMSG 2185.


C:\>NET HELPMSG 2185

The service name is invalid.


EXPLANATION

You tried to start a service that is not configured on this system.

ACTION

Check the spelling of the service name or
check the configuration information for the service using the Services option from Server Manager.


 At the  log [QUOTE] ORA-20001: SYSMAN already exists..
ORA-06512: at line 17
[/QUOTE]


Thank you
sriram
Re: Unable to determine local host from URL REPOSITORY_URL [message #409606 is a reply to message #409599] Tue, 23 June 2009 05:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check here.
Re: Unable to determine local host from URL REPOSITORY_URL [message #409653 is a reply to message #409606] Tue, 23 June 2009 07:19 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Re: Unable to determine local host from URL REPOSITORY_URL Tue, 23 June 2009 05:19
ebrian

You may want to check here.




Thank you ebrain for the link specified.... i droped the sysman user and
drop user sysman cascade;
drop public synonym SETEMVIEWUSERCONTEXT;
drop role MGMT_USER;
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop user MGMT_VIEW;

And then,

emca -deconfig dbcontrol db
emca -config dbcontrol db -repos create


Its working now.


Regards sriram.
Re: Unable to determine local host from URL REPOSITORY_URL [message #409732 is a reply to message #409653] Tue, 23 June 2009 14:01 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for the feedback.

Babu
Previous Topic: ORA-12505
Next Topic: OEM Alert
Goto Forum:
  


Current Time: Thu Apr 18 11:56:50 CDT 2024