Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
DISCOVERER Administrator, -Desktop: Identify connection DB-Instance after logon

Wenn starting DISCOVERER Administrator I have to connect with a DB Instance
Once connected I don't find a hint which system I'm connected with. In such conditions it becomes difficult, almost impossible to work with two DISCOVERER Adminstrator windows connected to two different systems like TEST and PROD.
I there a way you can identify the connected system?
Shall I really be forced to write a proper view just to identify the SID of the connected DB? Is there a more straightforward approach to gain windows session identification?
Same question about Discoverer Desktop.
Thanks for sharing your knowledge and advice,
LPNO
Best Answer
-
In Admin, you can see "Connected to" under Help/Database Information. I don't think there's a way to see it in Desktop, though. At least I haven't found it.
I suppose you could add a "dummy" Business Area in Prod with nothing but an empty folder called "This is PROD" (so you could see it if you edit/create a sheet) but you'd have to redo that if you needed to copy one to the other.
Answers
-
In Admin, you can see "Connected to" under Help/Database Information. I don't think there's a way to see it in Desktop, though. At least I haven't found it.
I suppose you could add a "dummy" Business Area in Prod with nothing but an empty folder called "This is PROD" (so you could see it if you edit/create a sheet) but you'd have to redo that if you needed to copy one to the other.
-
Ok, I like this idea. I will construct a report that shows me the system SID like:
select value from v$parameter where name like '%service_name%';