Skip to content
Advertisements

Archive for

Unable to determine local host from URL REPOSITORY_UR : Oracle EM

I tried to start my dbconsole ,its not working following message occur when i start a dbconsole…

Unable to determine local host from URL REPOSITORY_URL=http://ace-brokers.ace-in
s.com:%EM_UPLOAD_PORT%/em/upload/

So I fixed for these above problem here and then ,it’s working fine..

C:\Documents and Settings\Administrator>set oracle_home=d:\oracle\product\10.2.0\db_2

C:\Documents and Settings\Administrator>set oracle_sid=broker

C:\Documents and Settings\Administrator>emca -config dbcontrol db -repos recreate

STARTED EMCA at Apr 4, 2010 11:53:46 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: broker
Database Control is already configured for the database broker
You have chosen to configure Database Control for managing the database broker
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:
Password for SYSMAN user: Email address for notifications (optional): mazar@ace
ins.com
Outgoing Mail (SMTP) server for notifications (optional): mazar@ace-ins.com
—————————————————————–

You have specified the following settings

Database ORACLE_HOME ……………. D:\oracle\product\10.2.0\db_2

Database hostname ……………. ace-brokers.ace-ins.com
Listener port number ……………. 1521
Database SID ……………. broker
Email address for notifications …………… mazar@ace-ins.com
Outgoing Mail (SMTP) server for notifications …………… mazar@ace-ins.com

—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 4, 2010 11:56:12 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\db_2\cfgtoollog
s\emca\BROKER\emca_2010-04-04_11-53-46-AM.log.
Apr 4, 2010 11:56:21 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Apr 4, 2010 11:56:23 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …
Apr 4, 2010 12:01:39 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 4, 2010 12:01:40 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Apr 4, 2010 12:03:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 4, 2010 12:03:46 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Apr 4, 2010 12:04:26 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 4, 2010 12:04:26 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://ace-brokers.ace-ins.com:550
1/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 4, 2010 12:04:26 PM

C:\Documents and Settings\Administrator>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://ace-brokers.ace-ins.com:5501/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
——————————————————————
Logs are generated in directory D:\oracle\product\10.2.0\db_2/ace-brokers.ace-in
s.com_broker/sysman/log

Advertisements

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

Today morning, when i tried to startup our production database, it shows following errors

SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’

I was struggled with these erros and finally i was fixed this errors with help of Mr.Surachart opun http://surachartopun.com . He given solutions and fixed easily. Thanks Mr.Surachart.

How was i did it?

My tnsnames file :

BROKER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BROKER)
    )
  )

and My listener.ora file.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

 and now i tired to startup my db, the below error shown.

SQL> STARTUP
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ‘LISTENER_BROKER’

So i fixed in tnsnames.ora file and then now its working.

LISTENER_BROKER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress )(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BROKER)
    )
  )

After i fixed this listener_broker in tnsnames.ora file, the database up sucessfully.

SQL> STARTUP
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size                  2005192 bytes
Variable Size             369100600 bytes
Database Buffers         1526726656 bytes
Redo Buffers               14770176 bytes
Database mounted.
Database opened.

SQL> select name from v$database;

NAME
———
BROKER