Can Monitor 10.2.0.2 Databases Using OEM 11g

Feb 7, 2011

In my company we have few 10.2.0.2 databases and few 10.2.0.4 databases.Currently we are monitoring using OEM 10g (10.1.0.5.0) installed on a seperate server.

Planning to install OEM on a new server as part of server room renovation. let me know the process of installing OEM on a different server without loosing the historical data?Also wondering if the OEM 11g will support the current databases?

View 2 Replies


ADVERTISEMENT

Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies View Related

Flag Or Monitor CPU Utilization?

Dec 22, 2010

I have to run a resource extensive SQL. It utilizes CPU to a great extent. I've created a new user just to run this particular report. I need to ensure that this particular user doesn't uses more CPU.

Hence, I need to generate an alarm (email) only if a threshold is exceeded for a certain period of time (above x% for y minutes),(example more than 80% for 10 min.), so that I can either kill the process or continue running it depending on CPU usage.

Can I do it using scripts or OEM. I couldn't find any specific metrics to do it in latter. (I'd prefer scripts though. )

My system details are as follows:

1. Database: Oracle 10g R2
2. Unix: Sun OS 5.10

View 2 Replies View Related

How To Monitor Oracle Application R12

Jul 16, 2011

How can I monitor Oracle Apps R12 on Linux RHEL5. Application and database status.

View 2 Replies View Related

SQL & PL/SQL :: Monitor Jobs From Procedure?

Dec 31, 2010

We have a job table, and whenever jobs are added to this table the job processing procedure should be started.

In unix we have crontab facility where we can schedule to run for 24/7.

similarly do we have any option in oracle daatbase, to keep on running a prcedure in loop.

View 2 Replies View Related

Windows :: Monitor The Cpu Utilization On Xp?

Jul 16, 2010

how can we monitor the cpu utilization on windows xp.

View 2 Replies View Related

How To Monitor Drop User

Jan 31, 2013

How to monitor the DROP USER command?

OS: AIX, Oracle: 11.2.0.2

View 8 Replies View Related

How To Monitor Space Of Database In RAC And NON-RAC

Nov 17, 2012

I need to monitor the Database daily, so i need to check whether the size of the DB is increasing @ a slow rate or rather than that. I need to do it in RAC & NON-RAC.

View 3 Replies View Related

Monitor The Creation Of New Datafiles / Tempfiles?

Oct 15, 2012

I am looking for a way to monitor the creation of new datafiles / tempfiles.Let's say I am creating a new datafile of 8GB in size, and it takes a few minutes to create.

I have looked at v$session_longops, and several other system views, but cannot find any that indicate how the file creation is progressing.

I want to be able to display something simple, such as "72% complete".

View 1 Replies View Related

Client Tools :: SQL Monitor Alternative?

Jan 5, 2011

Many moons ago, at a previous employer, I had access to the SQL Monitor tool that came with TOAD. I could really use an alternative to this now, as we don't have TOAD here, and it would need to be free. I'm getting a problem with a forms update failing, and I really need to see what's actually being submitted to the database by the form. We're still stuck on Forms 6 by the way

View 2 Replies View Related

Replication :: How To Monitor Complete Refresh

Oct 29, 2008

I am using basic replication in oracle 10.2.0.3. My materialized view object contains around 3 million records. Usually we are using FAST refresh but in my materialized view having some problem that’s the reason I am going to Complete refresh.

If I start complete refresh it will take 8-12 hours to complete refresh.

My Question is: During Complete refresh how to monitor complete refresh running or not except using

v$mvrefresh.

Is there any way to monitor complete refresh because suppose target database not available/network problem/ dead lock occur in my database. I can’t able to track refresh.

Even there is no notification in alert log.

View 1 Replies View Related

Server Administration :: Monitor PGA Utilization?

Dec 28, 2011

I have a requirement to monitor the PGA utilization with time to time. Provide a good script which will effectively show the pga utilization.

View 2 Replies View Related

How To Monitor ALTER TABLESPACE Ddl Change

Jan 8, 2013

I can use trigger to monitor ALTER TABLESPACE ddl statement against a particular tablespace in a schema.

CREATE OR REPLACE TRIGGER HOT_MAIL_DDL_CHANGE
AFTER ALTER TABLESPACE <tbs_name>
ON SHANNURA.SCHEMA
BEGIN
INSERT INTO HOT_MAIL_DDL_AUDIT_LOG VALUES
(SYSDATE,
SYS_CONTEXT('USERENV', 'SESSION_USER'),
ORA_SYSEVENT,
ORA_DICT_OBJ_TYPE,
ORA_DICT_OBJ_NAME
          );
END;
/

I think, line no.2 isn't a valid statement. Or can I use AUDIT instead - in fact, I want to monitor/audit only ALTER TABLESPACE ddl statement and that too for a particular tablespace only.

View 3 Replies View Related

Security :: SQLs To Monitor User Access?

Jul 2, 2011

There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?

View 9 Replies View Related

Server Utilities :: How To Monitor Export And Import Job

Apr 28, 2012

how can i monitor the export and import job and how increase the export and import job performance.

can i monitor the export and import job by checking the log and dump file created by export and import and can its performance increase by configure parallism. m i right or not?

View 2 Replies View Related

How To Monitor Alert Log File (using Any Tool Or Manual)

May 10, 2013

1)How to monitor alert log file (using any tool or manual)?

2) What are the implications of a database with multiple data block sizes?

View 4 Replies View Related

Windows :: Tool To Monitor Oracle Host And Services?

Jun 29, 2010

What tool can be used to monitor Oracle host on Windows environment if the database goes down? I know about "Nagios" but like to know is there any other tool available?

View 6 Replies View Related

Networking And Gateways :: Logs Or Queries To Monitor Clients IP

Oct 13, 2012

Is there any logs or query where I can monitor client's IP previously connected to the database? I have created 2 listener with 10.1.2.x and 10.1.100.x network. I would like to separate the oracle traffic to the 10.1.100.x alone. As of now both can connect to the database. I like to monitor if everybody is already transferred to the 10.1.100.x network before I will disable the 10.1.2.x.

View 2 Replies View Related

Application Express :: Database Monitor Module Missing In 4.2.2?

Jul 4, 2013

When login as a administrator, am unable to find the above in SQL Workshop / Utilities. it's not drop from 4.2.2 , very useful functions. 

View 2 Replies View Related

Server Administration :: How To Monitor Instance Status And Log Switch Summary

Apr 27, 2012

how can i monitor the instance status and log switch summary.

View 8 Replies View Related

Call Interface :: Monitor Stream Activity With Strmmon Tool

Dec 20, 2012

I want to monitor the stream activity with strmmon tool. How to compile the strmmon.mk? I was seeing with visual studio command prompt but it does not work properly.

Oracle Version: 10.2.0.4
Server: Win 2008 R2

View 0 Replies View Related

Server Administration :: Monitor Increment Of Space Of Tablespace Based On Table?

Jun 9, 2011

How to check for the increment of a space of the tablespace based on the particular table. (i.e.) Say a scenario, if am trying to load the data for a particular table, for first I loaded some 10000 records and then again loading 50000 records ,so based on the icrement of the reocrds the tablespace size also increases gradually . so for this scenario how to monitor the increment of the space.

View 13 Replies View Related

Real Application Clusters :: Monitor Incident Or Regular Health Checkup Under Grid And Oracle User?

Apr 15, 2013

I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?

View 3 Replies View Related

Forms :: Dual Monitor Forms With Alerts / Messages

Apr 18, 2013

We have forms 11gr2 on win xp 32bit , weblogic linux server 64bit. We are converting 6i to 11g. Our system has many forms that span on 2 monitors. 1280x768 monitors, so some forms are 2560x768.

When alerts/messages pop up on the screen , they are positioned in the middle of both screens (guessing Oracle by default calculates width =2560/2, height =768/2).

Possible options:

1- is there a way to tell oracle to open alerts/messages a X Y coordinates? Maybe a config file on the server? Already file a Sr with Oracle tech support.
2- tried creating a form to do our messages. but this is flawed since when you call the new form to display the message, then the focus on current form is lost. when the message form is closed (then trigger when_window_activate fires)...this would be hell to try and control all our messages (we may have 20-30 on each big form. We have a total of 118 forms. Lots of messages with Y/N/Cancel options.
3- Maybe create a place holder for messages on all forms (bottom of screen)...thats the best idea we have so far.
4- Is there a way to do something with a java beans? We already have some knowledge with beans since we use image beans and pdf beans.

View 1 Replies View Related

Same Server Two Databases

Oct 3, 2012

I have a windows 2008 server.

I already installled oracle software for oracle_home C:/oracle/product/11.2.0/dbhome_1 for database DEV.

Now, I want to create new database with different oracle_home on same server with oracle_home as C:/oracle/product/11.2.0/dbhome_2 and SID as TEST.

Do I have to istall oracle software again ? if yes, what about inventoryfiles in C:\Program Files\Oracle\Inventory ? wont they be overwritten ?

View 3 Replies View Related

Multiple Databases With Same Name?

Nov 23, 2010

We are getting a consultant to upgrade an Oracle 9i installation to 11g R2. The current installation has 6 different databases installed on the same server. Each database is a different customer so for reasons of security we have requested that this be split into 6 virtual machines with one database per machine.

The consultant suggested that they could install the 11g database once and then just make copies (which would all have the same instance name. We are told that the TNS names can be configured so clients are directed to the right database.

View 3 Replies View Related

SQL & PL/SQL :: Sequence Can Be Used Across Databases?

Mar 19, 2012

As we can give grant on sequence and can use in different schema of same database, can same sequence be used across databases?

View 2 Replies View Related

Copy Data Between Databases

Oct 12, 2012

I want copy some tables from one database to another. Which of following is the fastest way:

- INSERT /*+APPEND*/ via database link
- Transportable Tablespaces
- datapump IMP/EXP (I supposed it's the slowest way)

View 2 Replies View Related

Oracle Example Databases And Tables

Oct 3, 2011

I'm just wondering because i didn't find any example / test databases for Oracle. Thus MS has its "northwind", mysql its "world" or "sakila".

Additionally, the tables view is quiet confusing, referring to all those generated tables (

[URL]........

I tried right-click + apply filter *remove generated* but it didn't work.

View 3 Replies View Related

SQL & PL/SQL :: How To Synch Two Oracle Databases

Aug 2, 2010

I have cloned the database into another using DBMS_METADTA API (export the metadata in xml form and recreate it on destination). I need to synch these two periodically. I need to update the XML to synchronize the databases.

I don't have 11g to use DBMS_METADATA_DIFF API.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved