Unregistering a Location

Just noticed this script, which I think many people might not be aware of. Ok it is not something you would need every day, but in some cases you may find yourself in need of it...

In <OWB_HOME>/owb102/owb/misc you find 3 scripts:

  • unregister_location.sql
  • wb_env_util.plb
  • wb_env_util.pks
The only one you care about is the SQL one... Now use this only (like the script says) when you cannot get to the control center anymore. Say the database got deleted (runtime that is), but your location in the client still says it is registered. Since you cannot go to the control center an unregister, you need to do something. That is where unregister_location.sql comes in...

Before running it do read the script, it nicely tells you which user to use it in (Repository Owner).

Oh and for those of you new to 10.2, you should not declare this the default to unregistering a location... 10.2 has this capability in the Control Center Manager and you do not have to go to the browser... So it is already quite a bit simpler. Remember just use this one when you are really stuck.

Comments:

This is not working. I got the message location not avaialable.

Posted by guest on June 14, 2011 at 08:12 AM PDT #

Are you unregistering when you are connected to the database with a user who has the location registered? Can you include what you did and the exact error.

Cheers
David

Posted by David on June 16, 2011 at 01:47 AM PDT #

David,

I really appreciate your comment and time.

I agree with you 100%. But present situation is DBA refreshed the development database from production and dropped all DB links.

SQL> @C:\OWB10g\owb\misc\unregister_location.sql;
===========================================================================
WARNING:
This script should be used ONLY when a location cannot be unregistered by using
OWB UI or Scripting. This can happen when the Control Center/Runtime Repository
where this location was registered is crashed, or deleted, or just cannot be
reached any more.
===========================================================================
Enter Location Name (ctrl/c to cancel): L_XXX_XXXXXXX
Location L_XXX_XXXXXXX does not exist

PL/SQL procedure successfully completed.

SQL>

Posted by guest on June 16, 2011 at 02:20 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today