Jump to content
Sadikhov IT Certification forums
Sign in to follow this  

Database oracle 10g

Recommended Posts

I have a big problem


My database is in oracle 10g Windows server 2000 when I change the domain

Enterprise Manger don,t work


How to fix this problem




Share this post

Link to post
Share on other sites

Tried to see the log?

Because I know that when u install Oracle

u will specify the name of the DB which is the local machines name

if u change domain

lets say from DC1 to DC2

then the PC name will change from db.dc1.com

to db.dc2.com


Enterprise Manager cannot start if u specify db.dc1.com as the name for Oracle during installation...

Share this post

Link to post
Share on other sites

maybe you have to recreate the repository.

you can take a look for utility called emca in Oracle installation directory, and find how to use it.


here's the command to recreate the repository

emca -config dbcontrol db -repos recreate


you need to input some passwords,informations etc.


Hope it helps

Share this post

Link to post
Share on other sites

This is the best way to do it:


1. Fist you need to shutdown your databse


C:\ > sqlplus /nolog

SQL> conn / as sysdba

SQL> shutdown immediate


2. Second you need to shutdown your listener


SQL> host lsnrctl stop


Now go to your %ORACLE_HOME%db_1\NETWORK\ADMIN

Then edit your listener.ora and tnsnames.ora and replace the "HOST=your_oldhost_name" with "HOST=your_ newhost_name”, within them.


3. Third you can start your listener and you database


SQL> host lsnrctl start

SQL> startup


4. Now you can recreate the EM repository


SQL> host emca -config dbcontrol db -repos recreate


This will prompt you to some question that you need to answer such

Database SID

Listener port number

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

Do you wish to continue? [yes(Y)/no(N)]: < ======= there you enter Y

Then you wait.... till It's created . Then you can start you USE YOUR ENTERPRISE MANAGER.


5. Sometime #4 will created succefully but will generate error and won't start


Then you just need to retry step 4 and then it will work.







Share this post

Link to post
Share on other sites

An alternative way is to deconfigure and then reconfigure the Database Console with the repository create command. Run the following commands:


emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create


Note: 1521 is the default listener port

Edited by Mohamed Medhat

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this