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

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

 

 

Thanks

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

absolutely

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.

********************************************************************************

****************************************

**BE CAREFULL THIS CAN CHANGE YOU EM PORT, OBSERVE TO KNOW WHEN YOU START IT**

********************************************************************************

****************************************

Enjoy!!!

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  

×