Home » RDBMS Server » Server Administration » Accessing Renamed database using OEM IN oracle 10g
Accessing Renamed database using OEM IN oracle 10g [message #186289] Mon, 07 August 2006 05:56 Go to next message
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 Go to previous messageGo to next message
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
Re: Accessing Renamed database using OEM IN oracle 10g [message #186893 is a reply to message #186643] Thu, 10 August 2006 01:20 Go to previous message
suresh3k
Messages: 9
Registered: August 2006
Location: CHENNAI
Junior Member
It's working fine, Thanks for your assistance - Suresh
Previous Topic: unable to startup
Next Topic: create table with index in different tablespace
Goto Forum:
  


Current Time: Sat Dec 03 12:26:34 CST 2016

Total time taken to generate the page: 0.09708 seconds