| Listener and Listener Targets in Enterprise Manager [message #240282] |
Thu, 24 May 2007 09:27  |
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 #240753 is a reply to message #240282] |
Fri, 25 May 2007 11:54  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
