Home » RDBMS Server » Enterprise Manager » Listener and Listener Targets in Enterprise Manager
Listener and Listener Targets in Enterprise Manager [message #240282] Thu, 24 May 2007 09:27 Go to next message
arronrumsey
Messages: 3
Registered: May 2007
Location: London, UK
Junior Member
I have an Oracle 10gR2 database running on my computer which is connected to a LAN and our IPs are assigned via DHCP.

My IP has changed since I first created the database and so I installed the Microsoft Loopback adaptor and changed the
C:\oracle\product\10.2.0\db_1\<HOSTNAME>_<SID>
and the
C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_<HOSTNAME>_<SID>
directories.
I have also deleted and created a new Listener with the updated configuration.

However, within Enterprise Manager Database Control, it is still using the old Listener and Agent details/configuration, with the old host IP address and so is not being able to connect to the DB properly.

Where is Enterprise Manager picking this old information up from?

How can I update/change the information that Enterprise Manager uses?

My tnsnames.ora file is:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

RUMSEY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cer00574)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RUMSEY)
(INSTANCE_NAME = RUMSEY)
(GLOBAL_NAME = RUMSEY)
)
(HS = OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

My listener.ora file is:

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = RUMSEY)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = RUMSEY)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
)
)

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

SAVE_CONFIG_ON_STOP_LISTENER = TRUE

TRACE_LEVEL_LISTENER = ADMIN


#----ADDED BY TNSLSNR 24-MAY-2007 11:12:12---
LOGGING_LISTENER = ON
#--------------------------------------------

The output from "LSRNCTL> services" is:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cer00574)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
(ADDRESS=(PROTOCOL=beq)(PROGRAM=extproc)(ENVS='ORACLE_HOME=C:\oracle\product\10.2.0\db_1,ORACLE_SID=PLSExtProc')(ARGV0=extprocPLSExtP roc)(ARGS='(LOC
AL=NO)'))
Service "RUMSEY" has 2 instance(s).
Instance "RUMSEY", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:266
LOCAL SERVER
(ADDRESS=(PROTOCOL=beq)(PROGRAM=oracle)(ENVS='ORACLE_HOME=C:\oracle\product\10.2.0\db_1,ORACLE_SID=RUMSEY')(ARGV0=oracleRUMSEY)(ARGS= '(LOCAL=NO)'))
Instance "rumsey", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:125 refused:0 state:ready
LOCAL SERVER
(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\oracle.exe)(ARGV0=oraclerumsey)(ARGS='(LOCAL=NO)'))
Service "RUMSEYXDB" has 1 instance(s).
Instance "rumsey", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: CER00574, pid: 9928>
(ADDRESS=(PROTOCOL=tcp)(HOST=cer00574.cerillion.com)(PORT=3032))
Service "RUMSEY_XPT" has 1 instance(s).
Instance "rumsey", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:125 refused:0 state:ready
LOCAL SERVER
(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\oracle.exe)(ARGV0=oraclerumsey)(ARGS='(LOCAL=NO)'))
The command completed successfully

[Updated on: Thu, 24 May 2007 09:33]

Report message to a moderator

Re: Listener and Listener Targets in Enterprise Manager [message #240481 is a reply to message #240282] Fri, 25 May 2007 00:49 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

hi,

I think you need to reconfigure the EM.

You have to recreate the EM repository ( using emca utility) whenever your IP address gets changed..

Regards..

Dipali
Re: Listener and Listener Targets in Enterprise Manager [message #240753 is a reply to message #240282] Fri, 25 May 2007 11:54 Go to previous messageGo to next message
arronrumsey
Messages: 3
Registered: May 2007
Location: London, UK
Junior Member
I have tried to do lots of things with emca: recreating repository, creating repository, etc.

I have since reinstalled Enterprise Manager from my computer and reinstalled it.

Therefore I now need to configure EM with the database on my computer.
However, when I try to do this using dbca and emca, I obtain the following error:

"Failed to unlock all EM-related accounts."

I have unlocked the SYSMAN and DBSNMP users but I still get this same error.
Re: Listener and Listener Targets in Enterprise Manager [message #310908 is a reply to message #240753] Wed, 02 April 2008 15:54 Go to previous messageGo to next message
gunalmel
Messages: 5
Registered: May 2007
Junior Member
I had the same problem in configuring Enterprise Manager for 11g DB on Windows Server 2003. I have changed SYS, DBSNMP, SYSMAN passwords such that all characters would be alphanumeric. Then dropped and recreated enterprise manager dbconsole with emca. This worked for me.
Re: Listener and Listener Targets in Enterprise Manager [message #311006 is a reply to message #240282] Thu, 03 April 2008 04:01 Go to previous message
arronrumsey
Messages: 3
Registered: May 2007
Location: London, UK
Junior Member
Ok, thank you for your help.
Previous Topic: Reason of Alert message from production
Next Topic: Logging to wrong DB
Goto Forum:
  


Current Time: Sat Dec 03 20:19:27 CST 2016

Total time taken to generate the page: 0.11060 seconds