Question
What is the maximum number of partitions you ever had in a partitioned table?
Less than 100
Between 100 and 500
Between 500 and 1000
Between 1000 and 2000
More than 2000
I never used partitioning
No idea or not applicable
Answer and see the results
Download PLATO
The free tool for auditing and tuning your database
Version 52 now available
Jul 12, 2010
The DBA-Village forum
Forum as RSS
as RSS feed
DBA Top 10
1 M. Cadot 146300
2 F. Pachot 130200
3 B. Vroman 77200
4 A. Kavsek 62650
5 P. Wisse 52900
6 T. Boles 52350
7 Z. Hudec 41600
8 A. Chavan 25700
9 A. Deledda 23200
10 V. Swamy 17625
About
DBA-Village
Site Statistics
Ever registered41903
Total active users26384
Act. users last 24h318
Act. users last hour15
Hits last week5251
Hits last month21266
Go up

do you use OEM web console for production db ?
Next thread: ONE STANDBY DB FOR MULTIPLE PRIARY DB
Prev thread: Lock on table

Message Score Author Date
hi guys, i am wondering do you guys use OEM we...... sze jie koh Feb 09, 2010
If you are on the same "local" network, then just ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts LKBrwn DBA> Feb 09, 2010
I have found this to be an issue as well. I h...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Tim Boles Feb 09, 2010
thanks alot guys! looks like tunnelling or a vp...... sze jie koh Feb 09, 2010

Follow up by mail Click here

Subject: do you use OEM web console for production db ?
Author: sze jie koh, Singapore
Date: Feb 09, 2010, 211 days ago
Os info: win xp
Oracle info: oracle 10g
Message: hi guys,

i am wondering
do you guys use OEM web console for production db ?


q1) i am having a few production dbs, none of the servers has public ip access.

if i were to access the webconsole, i would have to vnc inside the db server itself through (another server on the same network that has a public ip) and access the webconsole locally.

its so much of an hazzle.
any workaround for this ? what do you guys do ?

Regards,
Noob
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: do you use OEM web console for production db ?
Author: LKBrwn DBA>, United States
Date: Feb 09, 2010, 210 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: If you are on the same "local" network, then just connect to EM through any browser.
If you are outside the firewall, then you do need to connect to a local network machine using VPN and use that local browser.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: do you use OEM web console for production db ?
Author: Tim Boles, United States
Date: Feb 09, 2010, 210 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: I have found this to be an issue as well.

I have installed OEM Grid Control on one server that can access everything on that particular network.

Now my workstation can putty to that network so what I do is the following.

Create a tunnel using putty. Mapping a Source port and Destination port.

Example in Putty under Connection -> SSH -> Tunnels
Source port 1159
Desitnation localhost:1159

I can then access em using my IE at
https://localhost:1159/em/console/logon/logon

This is a pain because I have 3 different networks that do not talk to each other....so unless you think ahead and install OEM on different ports I can only look at one network at a time.

Regards
Tim Boles

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: do you use OEM web console for production db ?
Author: sze jie koh, Singapore
Date: Feb 09, 2010, 210 days ago
Message: thanks alot guys!

looks like tunnelling or a vpn is my only option out!

regards,
Noob
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here