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
Site Statistics
Ever registered41903
Total active users26384
Act. users last 24h318
Act. users last hour15
Hits last week5251
Hits last month21266
Go up

Enteprise Manager
Next thread: Datafile in recover mode after RMAN backup
Prev thread: Convert Rows into Columns

Message Score Author Date
Hi, I am trying to create Em on the new box,10g...... Stan M Feb 09, 2010
Try the below, Set your ORACLE HOME(f:\OraHome\...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Ragu Ponnusamy Feb 09, 2010
Thanks it worked... Stan M Feb 09, 2010

Follow up by mail Click here


Subject: Enteprise Manager
Author: Stan M, South Africa
Date: Feb 09, 2010, 211 days ago
Os info: Windows 2003 Server
Oracle info: 10.1.0.4
Message: Hi,

I am trying to create Em on the new box,10g portal has been installed and the db home is in the infra home but when creating the Em it picks up the wrong home as shown below.

C:\>set ORACLE_HOME=f:\OraHome\infra

C:\>set ORACLE_SID=test1


emca -config create

C:\>emca -config create

STARTED EMCA at Tue Feb 09 10:16:01 GMT+02:00 2010
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: test1
Service name: test1.test.gov.za
Email address for notification:
Email gateway for notification:
Password for dbsnmp:
Password for sysman:
Password for sys:

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ F:\OraHome\portal
Enterprise Manager ORACLE_HOME ................ F:\OraHome\portal

Database host name ................ oracle-340s
Listener port number ................ 1521
Database SID ................ test1
Service name ................ test1.soc.gov.za
Email address for notification ...............
Email gateway for notification ...............

-----------------------------------------------------------------
Do you wish to continue? [yes/no]:
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Enteprise Manager
Author: Ragu Ponnusamy, India
Date: Feb 09, 2010, 210 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Try the below,

Set your ORACLE HOME(f:\OraHome\infra\bin)in windows environment variables path as a first env variable and then try it. It should be prior to F:\OraHome\portal Home.

My Computer -> System Properties -> Advanced -> Environment Variables -> path

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

Subject: Re: Enteprise Manager
Author: Stan M, South Africa
Date: Feb 09, 2010, 210 days ago
Message: Thanks it worked
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here