Install / Use Enterprise Manager Grid Control If Only Have Standard Edition Licenses?

Jul 27, 2011

can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.

View 2 Replies


ADVERTISEMENT

Enterprise Manager :: Install Error Grid Control 10.2.0.1 On Sun

Jan 7, 2010

I try to install the Grid Control 10.2.0.5 on Solaris 10 in an existing (empty) Database Oracle 10.2.0.4. All steps work without problems except

-- OMS Configuration (in Configutaion Assistants)

emca_repos_create15_25_32.log :

Quote:
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647)
[code].......

ORA_NLS10 is set to $ORACLE_HOME/nls/data of DB

Also tried to set to $ORACLE_HOME/nls/data of oms10g but get Problems to start opmn and later on it report also ORACLE_HOME and NLS Parameter set incorrectly. I checked MetaLink / Internet without success.

View 4 Replies View Related

Enterprise Manager :: Install Grid Control 11gR1 - SQLException Null Resultset

May 19, 2011

I'm trying to install Enterprise Manager Grid Control 11gR1 - Windows2003 32. On the "Connect to Oracle Database" step 5 when installing a new Enterprise Manager System, I get an Error window that states:

"ERROR: SQLException null Resultset

Cause: Verifying whether database is valid for this install, using the given credentials has failed.

Possible Reasons:
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down

View 16 Replies View Related

Enterprise Manager :: Config - Enter Price Manager Grid Control For All DB

Feb 8, 2010

we have 5 database servers in different locations,

1.main database 10g(production) ip-192.1.1.1
2.standby for production 10g ip- 192.1.1.2

both are linux

3.another database 10g windows
4. another database 9i windows

both are in same location

5.new database 10g in linux ip-192.1.1.3
some other location
i m having a system windows xp installed
i m monitoring, all 10g by oracle enterpric manager
linux os monitor by Putty software

and i m monitoring below 10g database by sqlplus. now how could i monitor all the database by oracle enterprise manager grid control installed in my system that windows OS installed.

View 4 Replies View Related

Enterprise Manager :: RAC Monitoring Through 12c Grid Control?

Jul 11, 2012

I have plan to monitor RAC database (2 instance) through 12c grid control.

Do i need to install agent on both the nodes.?

Do i need to configure both the instance.?

View 6 Replies View Related

Enterprise Manager :: Grid Control Installation - 10g

Aug 3, 2011

which i can install Grid Control For my 10g databases.

View 2 Replies View Related

Enterprise Manager :: Upgrade 11g Grid Control To 12c Cloud?

May 29, 2013

Now we have 11G grid control on linux x86_64 server and we are planning to upgrade this to 12c Cloud control,

What are the available options,

1) upgrade from 11g to 12c on the same server.

2) Build another linux server and install 12cloud.

which ever is easy to have 12c upgrade. oracle recommended url's to follow the installation.

View 4 Replies View Related

Enterprise Manager :: How To Add Standby Monitoring On Grid Control

Mar 5, 2011

I have primary database on RAC 10g and i have a standby, i want add this standby on Grid Control for monitoring this standby.

View 3 Replies View Related

Enterprise Manager :: Grid Control Database Instances Always Down

Jun 11, 2010

Installed Grid Control 10.2.0.2.0 on Windows Server 2003R2 32-bit. Immediately upgraded to 10.2.0.5.0. Both install and upgrade went fine, Grid Control can see its own database in the list of targets, looks good.

I then installed Oracle 11gR2 11.2.0.1.0 64-bit on Windows Server 2008R2 64-bit and created a new database. I then installed the 10.2.0.5.0 agent manually on the server via OUI. Agent install went fine, secured and started properly.

The problems I'm having is Grid Control can't seem to see the database instance. If I go to "Targets", GC can see the host just fine, shows that its up and can see targets for the listener (Up), the agent at port 3872 (Up), and the database instance (Down). Drilling down to the database instance, it shows that the instance is not up (though it is as I can connect to it from a different machine and run queries against not) and the Agent Connection to Instance is down with the error:
Failed to connect to database instance: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc...

Also, pulling up the "Alerts" tab for errors showed the following for Metrics "Access to Important Tables and Views", "DB Data Files Permissions", and "DB Control Files Permission":

Target: SR3
Type: Database Instance
Metric: Access To Important Tables And Views
Collection Timestamp: Jun 11, 2010 11:11:26 AM
Error Type: Collection Failure
Message: 1804 at c:oracleagent10g/sysman/admin/scripts/db/esaDbUtils.pl line 290.
There are also several "Missing Properties : [AdrHome,ConvertFromCharset,needCharsetConvert]" errors listed too.

I've looked into the 1804 error and from what I could find, its a perl-related issue with not being able to get the ORACLE_HOME information.

- I verified that ORACLE_HOME was set in the environment variables and even rebooted to make sure it was being picked up properly. That didn't work.
- I added "$ENV{ORACLE_HOME}='c:\oracle\product\11.2.0\dbhome';" to the esaDbUtils.pl file. That didn't work either.
- I added the GC security certificate to the trusted certificates on the target box in case it was some kind of SSL issue. I don't get the annoying "invalid certificate" warning, but it didn't fix it.

View 1 Replies View Related

Enterprise Manager :: Grid Control 10.2.0.5 Metrics List?

Jun 25, 2010

Any complete List iof possible Metrics from Grid Control after installarion? No User-Defined, only Standard Metrics. How can I find them, I just checked Documentation and Metalink - but no result.

Any list prepared before or can point to any "how to create".

View 2 Replies View Related

Enterprise Manager :: 11gR2 Grid Control - SVG Or Flash?

Sep 15, 2011

I'm trying to use 11gR2 Grid Control to manage several 10gR2 database targets. I'm unable to determine the correct mix of Adobe software plug-ins to use for displaying SQL execution plans in a more graphical style. My client OS is Windows 7 - I have tried to research plug-ins for Internet Explorer 8, I upgraded (and subsequently downgraded!) to IE 9; I installed Firefox 6.x, tried with Google Chrome and all with the same results.

I'm not seeing any relevant information from MyOracle support or on Google, but may not be asking the correct question. As far as I can determine, SVG 3.0 is needed, Adobe stopped development in 2009 and there is no variant available therefore for Windows 7.

View 2 Replies View Related

Enterprise Manager :: Monitoring Standby Database Using Grid Control

Mar 3, 2008

I'm monitoring and all my databases using grid control. Recently I added a dataguard configuration but the standby database shows me a lot of error simple because it's in MOUNT state. how I should configure grid control or the standby database so the errors disappear?

View 7 Replies View Related

Enterprise Manager :: Core.xxx Files Generated By Grid Control Agent?

Aug 2, 2010

I have a server with Red Hat EL 5.5 running an oracle database 10g R2 and an Oracle Agent 10.2.0.5The disk ran out of space and I realized that there are a lot of files stating with core.xxx such as :

-rw------- 1 gridagent oinstall 17M Aug 2 13:10 core.10348
-rw------- 1 gridagent oinstall 17M Aug 2 13:15 core.10827
-rw------- 1 gridagent oinstall 17M Aug 2 12:30 core.4129
-rw------- 1 gridagent oinstall 17M Aug 2 12:35 core.4772

What's that ?Why are those files generated at $AGENT_HOME/<HOST>_<SID>/sysman/log/ ?

There are more than 24 GB of those files

in nmc.log I can see lines such as:
NMC-00000 2010-08-02 13:25:39 [11760, nmcdbg.c,0440]TRC: Debug context enabled.
NMC-20020 2010-07-30 01:31:58 [23083, nmccole.c,0725]ERR: Could not collect using DSGA Collection method
NMC-20014 2010-07-29 01:31:56 [11258, nmccole.c,0822]ERR: Could not attach to the SGA

View 1 Replies View Related

Server Administration :: Convert Enterprise Edition DB To Standard Edition?

Nov 4, 2011

The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.

The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.

View 2 Replies View Related

Enterprise Manager :: Querying Grid Control Tables To Find Size And Name Of Database?

Sep 25, 2012

query to get the name and size of all the databases associated to grid..

I need to find this to do capacity planning in our environment.

View 6 Replies View Related

Replication :: Oracle Streams / Tried Schema Replication Through Enterprise Manager Grid Control

Feb 22, 2012

Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...

but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..

View 6 Replies View Related

Enterprise To Standard Edition

Sep 12, 2012

Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .

View 1 Replies View Related

Downgrade From Enterprise Edition To Standard

Feb 10, 2011

I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.

How can we check and be sure that a downgrade to SE would not be any problem?

Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE

How can we complete this list, or is there some script to make this easy?

View 7 Replies View Related

RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle

Mar 18, 2013

In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?

They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?

View 6 Replies View Related

Enterprise Manager :: Oracle 9i Enterprise Edition Installation Error / End Header Not Found

Feb 18, 2011

My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:

Not a zip file(End header not found)

View 1 Replies View Related

Enterprise Manager :: RAM Enough To Hold OEM Grid

Jan 19, 2013

With just 1.95 GB RAM in windows xp, would it be recommendable to use Oracle 11g OEM Grid control? Will the performance be poor?

View 1 Replies View Related

Enterprise Manager :: OEM Grid Installation

Nov 11, 2008

I am getting one error message while installing this OEM grid control in existing DB. this error come at last in configuration step. This is the error stack:

Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Checking SYS Credentials ... OK.
Checking DB Init Parameters ... OK.
Checking for Repos User ... Does not Exist.
Loading necessary DB objects ...
Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists.
DBMS POOL package exists.
Done Loading necessary DB objects
Creating repos user ... Done.
Creating EM Schema ... Failed.
Repository Creation failed. Failed to create repository schema.
Configuration assistant "Enterprise Manager Repository Creation Assistant" failed
--------
I am using oracle 10.1.0.3.0 on Windows XP.

what this error means? or any way that complete without it and later create manually.

View 1 Replies View Related

Enterprise Manager :: Unable To Login To OEM Grid?

Jan 20, 2012

I am able to login to the database as system user through putty session but I am unable to login using OEM grid control. I get the below error :

Database Error

ORA-01017: invalid username/password; logon denied

I know that we get this error if the user id or the password is invalid. But if the password is invalid, how come i am able to login through putty?

View 5 Replies View Related

Enterprise Manager :: Not Able To Login Into Oracle 10g Grid?

Mar 12, 2010

When i try to login into em it always give - [URL]... dba role is granted to the user and i have verified the passoword . I even tried with system user and it gave me same error.

Validation Error

Examine and correct the following errors, then retry the operation:Host Credentials - Connection to host as user system failed: ERROR: Wrong password for user

View 2 Replies View Related

Enterprise Manager :: Grid - Populating Target In Host?

Jul 31, 2010

In one of our cluster environment host 1 has 30+ targets. We are trying to add the targets in the grid. But while doing Agent Synchronization targets are not getting populated in the host..

Checked the log file of the same. Getting error as below..Not sure how to fix this.

2010-07-30 22:15:42,777 Thread-4158 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_db303pta.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:46,534 Thread-4675 target {dbb01pta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156)
2010-07-30 22:15:46,580 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_d01pt1_d01pt.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:46,581 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_dpta.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
2010-07-30 22:15:47,603 Thread-4166 target {tta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156)
2010-07-30 22:15:47,648 Thread-4166 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_dta_d22.xml, Line=0, Msg=LPX-00229: input source is empty (01006)

View 1 Replies View Related

Enterprise Manager :: Data Guard Installation At Grid

Jul 11, 2012

I configured EM grid control(11g) and install agent.when I configured standby database by data guard I got error messages.examine and correct the following error(s), then re-try the operation.

Remote Operation Error - install_driver(Oracle) failed: Can't load '/home/oracle/Oracle/Middleware/agent11g/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /home/oracle/Oracle/Middleware/agent11g/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied at /home/oracle/Oracle/Middleware/agent11g/perl/lib/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 203. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected at
[code]....

View 1 Replies View Related

Enterprise Manager :: How To Install 10g OEM DB Console On Windows

Dec 29, 2009

How I can get the heavy weight (Java) oem db console installed on my Windows XP desktop?

I used to have a 9i oem console before. But after reinstaling the OS on my laptop, I don't rememeber how I got the oem Java console installed in the first place.

I have a 10.2.0.1 db installed and web based oem console access to that db. But I want to be able to connect to other remote databases using the java console and manage/monitor the remote databases, like I used to before.

View 2 Replies View Related

Enterprise Manager :: How To Install Java Based OEM For 10g R2

Jan 20, 2010

I have oracle 10g R2 in my system with web based OEM.But i want to use Java based OEM console like in oracle 9i in my system with 10g....

View 8 Replies View Related

Server Administration :: Install Enterprise Manager Components Using OUI?

Oct 14, 2011

Using OUI i have removed the Enterprise Manager DBConsole component and now i need to reinstall them. After starting runinstaller i choose Advance and then Custom and i check the Enterprise Manager DBConsole and after i click on next it says cannot install on the same ORACLE_HOME. How can i reinstall the removed components using OUI. This is not Grid Control

View 2 Replies View Related

Enterprise Manager :: Install Oracle Snmp Agent On 11g?

Jun 22, 2010

How to install oracle snmp agent on 11g, RHEL5. Does it require to download and install or it's built in and requires just configuration ?

View 10 Replies View Related







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