Accessing Renamed database using OEM IN oracle 10g [message #186289] |
Mon, 07 August 2006 05:56 |
suresh3k
Messages: 9 Registered: August 2006 Location: CHENNAI
|
Junior Member |
|
|
I have created a database using DBCA.
Then I renamed the database.
But the new database cannot be accessed through OEM.Still it is pointing to older one in OEM.
Pl. Clarify it.
environment: Oracle10gR1 on Windows
|
|
|
Re: Accessing Renamed database using OEM IN oracle 10g [message #186643 is a reply to message #186289] |
Tue, 08 August 2006 17:05 |
Vamshee
Messages: 32 Registered: February 2005
|
Member |
|
|
Hi Suresh
Whenever we change the ORA SID of the database, a new EM has been created.
You can do this from the command line using this command
c:>set ORACLE_SID=ORCLNEW
c:>emca -config dbcontrol db
STARTED EMCA at Jun 8, 2006 11:10:05 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: ORCLNEW
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):
Give the above the information and it will configure the new EM for you.
You can get on to ur new EM from the address it gives and it will be under your Start Menu
P.S: Once you are done with this...its good to delete the old EM, to avoid confusion..
Follow these steps:
c:>set ORACLE_SID=ORCLOLD
c:>emca -deconfig dbcontrol db
Thanks
Vamshee
|
|
|
|