Enterprise Manager :: OEM And Privilege To See Users Schemas

Apr 19, 2010

I connect to an Oracle-10g database using OEM, and if I click to see the list of users, roles, storage options, ... everything is ok, but if I click to see the list of schemas, I get "1031: insufficient privileges" error.

The user account I use has the SELECT_ANY_DICTIONARY privilege and SELECT_CATALOG_ROLE role granted, and if I try to do "select * from dba_tables" in the SQL*Plus, I get a result.

The matter is even more strange because, if I use the SYSTEM account, I get the same error (!!!).

Do I need any other privilege/role to see the user's schemas with OEM?

View 2 Replies


ADVERTISEMENT

Enterprise Manager :: Copy Users Without Using EM DB-control?

Aug 13, 2013

Is that possible to copy users without using EM DB-control?

View 1 Replies View Related

Enterprise Manager :: Configure Enterprise Manager In Windows 2003 Server?

Aug 21, 2010

I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...

View 1 Replies View Related

PL/SQL :: Unique Schemas - Users List

Aug 5, 2013

find the below task. I have unique schemas. and every schema we have many tables.I would like to know

1. I have Scott schema and here I have 10 tables. EMP,DEPT,SALGARDE ( and these tables having different priviliges).

2. another schema MACIN having table DEPT, SALS, GRADE ( having different priviliges) Now I would like to know Schema 1 having permissions to see the tables and he is doing some modifications,inserting,deleting .... on tables containing in MACIN schema.like this it is happening in vice verse in max schemas. now I would like to know who all are having access to login to another schema and what are the priviliges they have till now on what  tables they applied changes...is it possible to figure out? if yes how can we?

View 6 Replies View Related

Client Tools :: Checking Users Execute Privilege On ALIAS LIBRARY

Nov 19, 2012

I want to check if a user has execute previlege on ALIAS LIBRARY,is there any table in which i can check this

View 7 Replies View Related

Enterprise Manager :: Unable To Connect To Enterprise Manager Console?

Dec 20, 2010

i have already give the grant option cnnect,resource to scott but it is not connecting to enter prise manager console of Oracle database 11gR1. i am getting this error while connecting "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information"

when i am giving scott the dba rights then it is connecting. but i cann't give dba rights to scott.so, how/what is the specific command to give permission scott for connecting to enter prise manager console.

View 1 Replies View Related

Enterprise Manager :: Oracle Enterprise Manager Communication Error?

Feb 2, 2010

We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.

Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."

I get the same error when i try to configure a host or a database.

Don't know what is wrong

View 4 Replies View Related

Enterprise Manager :: How To Start Enterprise Manager On Windows 7

Mar 21, 2013

How to start EM on windows 7?

View 3 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 :: 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 :: Can't Open Enterprise Manager

May 11, 2011

i have change my database name successful but after that when i open my enterprise manager i can open it but i cannot do anything in enterprise manager . i cannot show any tabs there.. i have attached my this enterprise manager login page here

View 12 Replies View Related

PL/SQL :: How To Grant Privilege On User1 Based On Privilege Of User2

Jun 20, 2013

I have 2 users in my oracle DB. They both have very different privileges and they both have too many different privileges. Now I want to grant user 1 the same privilege that user2 has while user1 keeps his existing privilege. How can this be done without manually comparing their difference and manually grant user 1 each privilege that he doesn't have? Or second option, can I override user 1's privilege with user 2's privileges?

View 2 Replies View Related

SQL & PL/SQL :: Direct Privilege Vs Privilege Through Roles

May 30, 2010

As we all know, privileges granted to a user through role are not visible from within a stored procedure. What is the reasoning behind this design?

Moreover, privileges granted through role are visible from anonymous PL/SQL block. Why such discrimination between anonymous PL/SQL and stored PL/SQL?

View 3 Replies View Related

Enterprise Manager :: JDK 1.6.0 SR6?

May 6, 2011

I'm trying to install OMS on AIX and one of the prerequisites is JDK 1.6.0 SR6 but I couldn't find it in the IBM site, can some one tell me where can I download JDK 1.6.0 SR6?

View -1 Replies View Related

Enterprise Manager Cannot Start

Sep 2, 2013

I am trying to start enterprise manager without success. i used to work after installation of db 10g but do day when i run the command below it fails. also i donot see any thing useful in the logs that am being directed to directory /oracle/Ora10R2/Orahome/localhost.localdomain_dse/sysman/log

[oracle@cdsdb ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.2.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Starting Oracle Enterprise Manager 10g Database Control .....
[code]....

View 1 Replies View Related

Enterprise Manager :: EM Port For Second DB

Jul 2, 2010

I have two databases on the same oracle 11g install. The first (ORCL) database uses the default port for EM (1158). However, I don't know what the second one uses. I go to the portlist.ini file, but it only has the entry for the default (ORCL) database.

View 3 Replies View Related

Enterprise Manager :: OEM Is Not Working

Sep 24, 2010

I tried to start my oem managing but got the following error.

[oracle@Eagle2 ~]$ emctl start dbconsole
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.

View 19 Replies View Related

Enterprise Manager :: How To Use OEM Remotely

Oct 21, 2011

How can I use OEM remotely?

my DB server is on 172.17.1.4 IBM-AIX

and my computer is 172.17.1.53

Because I am tired of using sqlplus :@

View 2 Replies View Related

Enterprise Manager :: Listener Is Getting Down?

Apr 25, 2010

When i run EM ,in my explorer show these
SID = ORCL

instance is open agent is up but ...listener is down .my listener is active and run.... however i can connect to DataBase and execute DDL or DML transactions.How i could resolve it ?

View 6 Replies View Related

Cannot Find Enterprise Manager After Installation

Aug 15, 2013

I have install oracle 11g database enterprise edition But i cannot find the Oracle Enterprise Manager after the installation. i want the gui based Oracle Enterprise Manager i have access the the web base Oracle Enterprise Manager but not the gui based.how to use and download the GUI Based Oracle Enterprise Manager ....

View 1 Replies View Related

Enterprise Manager Configuration Failed

Jul 29, 2013

when i install a db using the Assistant Configuartion Database i get no error exept this:

Enterprise manager configuration failed due to the following error - Listener is not up. Start the listener and run EM configuration again. Refer to the log file at C:\Oracle\cfgtoollogs\dbca\emConfig. Log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\Oracle\product\11.1.0\db_1\bin\emca script.

So I try lsnrctl start and i get:

C:\Windows\system32>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:26:25
Copyright © 1991, 2010, Oracle. All rights reserved.
TNS-01106: Il listener con nome LISTENER � stato gi� avviato

So I try lsnrctl status and i get:

C:\Windows\system32>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:23:34
Copyright © 1991, 2010, Oracle. All rights reserved.
Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

[code]...

The file "server.xml" in E:\app\Andrea.Rimoldi\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\ does not exist...

Is there any way to retrieve or recover this file?

View 11 Replies View Related

Enterprise Manager :: How To See Process Running In OEM

Jan 20, 2010

when I run the form and do some action intheform (call procedure , etc..) how can to see what is the process in running in OEM? Do it have any way to monitor it?

View 1 Replies View Related

Enterprise Manager :: OEM Installation In Linux

May 23, 2010

I am trying to install OEM but the GUI asks for weblogic server home.i checked many documents in net but none has weblogic installation procedure. Is it the sequence of installation ?

View 2 Replies View Related

Enterprise Manager :: Job Submission Failure

Mar 27, 2012

am trying to create a backup job in my UAT/testing instance, but with little success. I'm trying to create a backup job to disk (backup is to be stored in a drive local to the DB server) and it seems simple enough, but I keep getting the following error:

The job submission has failed for the following reason

ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error ORA-06512: at "SYSMAN.DECRYPT", line 5 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 408 ORA-06512: at SYSMAN.MGMT_CREDENTIAL", line 1007 ORA-06512: at "SYSMAN.MGMT_CREDENTIAL", line 1400 ORA-06512: at SYSMAN.MGMT_JOBS", line 295 ORA-06512: at "SYSMAN.MGMT_JOBS", line 78 ORA-06512: at line 1

In "Recovery Settings", I have a "Flash Recovery Area Location" defined (path local to the DB -i.e. the server that the DB resides on), a "Flash Recovery Area Size" of 4 defined, and a Flashback Retention Time of 24 hours defined. Everything else is riding default values.

In "Backup Settings", there's nothing defined. Everything here is riding default values. As I understand it, not specifying a Disk Backup Location is fine so long as the Flash Recovery Area is defined. All the local services are turned on (scheduling, etc.).

If it's relevant, I mirrored the recovery/backup settings in UAT to the same as PROD, but changed what I needed to in order to accommodate the UAT environment (e.g. paths, etc.)

View 1 Replies View Related

Enterprise Manager :: Managing OEM Remotely

Aug 23, 2013

I want to manage my database remotely, through Internet. Is it possible to do that with OEM? Where can I find information related to this? Is there another monitoring software that allows me to perform this?

View 10 Replies View Related

Enterprise Manager :: Daemon Not Running?

Feb 18, 2009

enctl is started but its status shows that EM Daemon is not running.What does it mean?And how can i reolve this error.

oracle@srv603484:~> emctl start dbconsole
TZ set to US/Pacific
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

[code]...

View 6 Replies View Related

Enterprise Manager :: OEM 10g Backup Notification

Oct 16, 2007

I have been starting to use OEM 10g and am configuring backups through the maintenance portion. Is there a way to get backup success / failure notification sent to an email address?

View 8 Replies View Related

Enterprise Manager :: Oracle DB Console

Jun 20, 2006

I suddenly started getting this error message "Error

java.lang.Exception: IOException in sending Request :: Connection refused: connect ". on the dbconsole of my database. Any clue where to proceed or how to find whats causing this error.

View 7 Replies View Related

Enterprise Manager :: Cannot Edit Listener

May 14, 2010

i am learning oracle technologies,i downloaded and installed 11g and log in as sys as sysdba in enterprise manager,in em certain tasks ask for password again, for example in main page when you want to edit the listener it asks for password, the problem is what kind a password does it want?, i tried os password and sys or system password but it did not work, it also happens when you try to shutdown the database,it asks for os and below it asks for another password,

View 2 Replies View Related

Enterprise Manager :: GUI Utility For Debugging?

Apr 14, 2010

I worked on SQL Server used a GUI,SQL Server Profiler, to debug queries. In ORACLE how to debug queries.Is there any GUI utility for debugging?.Can i see all the queries run by a specific user?.

View 1 Replies View Related







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