Getting OEM working after moving the DB to new box.

Advertisement
November 30

Greetings All,
I am testing moving a database to a new box.
I installed Oracle 11gR2 Enterprise Edition on the new box and created a new DB called DEV01. The same name as the DB I am moving. When I was building the new DB I also increased the memory allocations (there is more RAM on the new box).
I then backed up to trace the spfile and control file on both the new (target) box and source box.
I modified the pfile and create control file (for the new box) accordingly for the multiple datafiles and maintained the new increased memory allocations.
I shutdown the new DB (target) and deleted all of the datafiles, spfiles, control files, redo, temp files. I retained the file structure.
I shutdown the source DB and copied the datafiles to the new box.
I then started nomount the new DB (target).
I created a new spfile from the pfile I modified above for the new box.
I created new control files from the modified file (mentioned above) on the new box.
I then shutdown and restarted the new DB so the new SPFILE and new controlfile would be used.
The relocated DB is fine, all schemas and data is there.
Basically I restored a DB on a new box using a cold backup without the SPFILE and CONTROL files, I recreated the SPFILE and CONTROL files.
Now my question:
Is there a better way to get the OEM functioning without going thru the process of using the emca with the –repos recreate parameter? I believe this will drop and recreate the SYSMAN account/schema. I’d like to avoid this because I have many jobs scheduled. If I were to recreate the SYSMAN I will lose all of the jobs.
Am I correct?
How do I get the OEM functioning on the new box?
Thanks for your time,
Bob
Edited by: Snyds on Feb 1, 2013 1:53 PM

Advertisement

Replay

Thanks for your response.
When I enter the emctl command as you suggested to check current settings the response is as if I requested help.
I also submitted the same emctl commad on my production system and got the same result.
So I then tried “emctl status dbconsole” and got the response below
C:\Users\Administrator>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://WIN-O2T4J174RNT:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
So I then submitted emctl start dbconsole and got the response below:
C:\Users\Administrator>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://WIN-O2T4J174RNT:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The service name is invalid.
At one point in time (last week, 2 days ago) I tried using emctl with the recreate option, It seemed to hang so I canceled it. The SYSMAN schema was still there afterwards, although the account was locked.
At this point it seems that I really messed things up. Fortunately this was a test.
Any suggestions regarding how to set things right at this point?
Thanks again,
Bob

View 5 Replies

How to make J2EE work after moving harddrive to different laptop -

November 30

Hi Everyone, After moving the harddrive from one laptop on which NWDW(developer workplace) is installed, to another laptop, my local J2EE engine is not working anymore with Red color.  I guess the hardware key is different for different laptops altho

View All Replies

[svn:fx-trunk] 13157: -revert a portion of my previous change so that asdoc will work properly - moved the proprietary automation swcs back into the libs directory .

November 30

Revision: 13157 Revision: 13157 Author:   [email protected] Date:     2009-12-22 10:15:18 -0800 (Tue, 22 Dec 2009) Log Message: -revert a portion of my previous change so that asdoc will work properly - moved the proprietary automation swcs back into

View All Replies

I have always been able to open e-mail photo attachments even after trnsferring them to the desktop or a thumbdrive, but after moving the last two

November 30

I have always been able to open e-mail photo attachments even after transferring them to the desktop or a thumbdrive, but after moving the last two to the desktop and trying to open them I get the message that ColorSync is unable to open files of thi

View All Replies

Second_Copy_Delete does not work after moving files

November 30

Hello Guru's - We had a problem the other night where we ran out of space on our archive directory drive. We moved some of the archive files (about 50) to create some space and keep the system running. When we moved the archive files back, they will

View All Replies

Dump is coming after Moving the request to Quality server.

October 11

Dear All, Dump is coming in a ABAP code after moving the same to quality server. Kindly refer the attached screenshot. Kindly suggest. Thanks and Regards Jaisee the below code, I have changed the value of l_age1 TYPE bsid-dmbtr to l_age1 TYPE p LENGT

View All Replies

I need to setup 7800 Series IP Phones in the CUCM 8.6.2 which by default are not support but will work after install the software. Anyone have document from Cisco as I remember I seen once before.

October 11

I need to setup 7800 Series IP Phones in the CUCM 8.6.2 which by default are not support but will work after install the software. Anyone have document from Cisco as I remember I seen once before.Hi Ali, I'll just add this reference to the good tips

View All Replies

How to recleaim disk space in HP UX after moving the dbf file to some other

November 30

Hi All, I have moved the datafiles from one mount point to another by - 1) take tablespace offline 2) move the file from the OS command 3) take tablespace online But still the space is not getting released from the mount point where the files were pr

View All Replies

Youtube HD won't work after downloading the latest version of Flashplayer (11.9.900.117)

November 30

I have a windows Vista, system: 32 bit, and I downloaded the latest version of adobe flash player (11.9.900.117) But since I did this I can no longer watch youtube vids on HD with internet explorer. They open with a low quality like 360 and when I wa

View All Replies

MS office report function does not work after building the appication

October 11

I use the MS office report function  with a custom excel template my application. It works properly in de developstate, but after building the application it does not work . I use office 2000  and Windows XPjmq wrote: I use the MS office report funct

View All Replies

Almost no applications work after updating the system to 10.6.8

November 30

A few days ago I upgraded my MacBook system to 10.6.8 and afterwards when restarting the computer the screen became blue. Nothing happened and I tried to re-restart it. After this almost no applications are working including VLC-player, appstore, Mai

View All Replies

IDT High Definition Audio CODEC has stopped working after intalling the udates.

November 30

hello sir/madam, right now i had updated my window...after installing the updates my system audio device has stopped working.. kindly help me in solving the problemHi, 1. Please write your notebook product number (p/n).     Resource:     How to Locat

View All Replies

IChat video is not working after installed the 10.6.4 update

October 11

Hi. I'd like to know, how to solve the problem for my iChat video that has stopped working after I installed the latest update. I dunno what's the problem but it shows that, when I clicked on the preferences for iChat on the Audio/Video, I got "This

View All Replies

Can't get my work email to load on my new phone

October 11

I can't get my work email onto my Droid X.   Anyone know the trick? Carl3 wrote: I can't get my work email onto my Droid X.   Anyone know the trick?  First quesiton I have is do you have authorization to access your work email from your Droid X? Just

View All Replies

Touchscreen stops working after a few seconds on new iPad 2

November 30

The touch screen would stop working completely a few seconds after turning on. The iPad is still running fine -- Home/Power/Volume buttons work perfectly. But not the touch screen. I can not control the iPad except turning it on/off or turning the vo

View All Replies

OEM Can't get to database after changing the port on the database

November 30

Hello OEM Gurus! I had to change the port on a database(11g) from 1521 to 1526. I adjusted the listeners to include the SID (finapp1t) in the listener listening on port 1526. I removed the SID from OEM (10g btw) and rediscovered it. It successfully r

View All Replies

I can't get my LastPass plugin working after following the advice at LastPass regarding Flash etc, and it is showing as active.

October 11

I have made sure that all my plug-ins including Flash are updated, I'm also running the latest version of the LastPass plugin. Everything appears to enabled properly, but I do not get the LastPass icon in the toolbar, and no access to my passwords.Ca

View All Replies

Why the flash player don't work after installing the video downloader add-on?

October 11

I've installed and uninstall the Firefox mobile app several times to try and fix this issue. Every time I add the video downloader add-on the flash player won't let me tap to play videos anymore. I've tried to completely enable the flash but still di

View All Replies

How to get things working after External Hard Drive Died

October 11

I had all of my iMovie videos (about 800 GB) on an external drive that died.  Fortunately it was backed up to another external drive using Time Machine.  I bought a new drive and couldn't figure out how to restore using Time Machine so i transfered t

View All Replies

Trace is still getting generated even after disabling the profile option Initialization SQL Statement - Custom

October 11

Hi All, we have a problem with profile option "Initialization SQL Statement - Custom". we have set this at user level. after some time, we have cleared the profile option value for this user. But we can still see the generated trace files are ge

View All Replies

Tags:

  1. arp mac aging best practices
  2. sap sq02
  3. labview daqパルス出力
  4. how empty bulk mail ipad1
  5. apple tv hulu no signal
  6. breakpoint reached on Lenovo G 50
  7. badi or bte in sap afab transaction
  8. claiming primary bt id status
  9. sap configure ke24
  10. cisco wlc dynamic interface
Copyrights 2017 Fcffair BigData Resource, All rights reserved