SQL & PL/SQL :: Oracle Enterprise User

Feb 25, 2010

what is an oracle enterprise user , how ti different from a schema user or non schema user ? For connecting to database using enterprise user needs any special drivers or oracle clients ?

View 1 Replies


ADVERTISEMENT

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 :: Preventing A User To Login To OEM

May 25, 2011

Is there a way to prevent a user to login to OEM in oracle 10g?

View 6 Replies View Related

Enterprise Manager :: User Defined Metric Using SQL Code

Nov 25, 2012

How can I apply a user metric for DB (single database) using a script or cli?

clear my question:

Can I create a User Defined Metric using SQL code, and not via the graphical interface?

View 1 Replies View Related

Enterprise Manager :: RemoteOperationException ERROR - Wrong Password For User?

May 10, 2005

I have installed Oracle 10g on Windows XP. I created a database called orcl1 using DBCA and set the sys and system user passwords as "oracle". My windows xp operating system password is set as username:Bobby and password :welcome4all.
Yet at the startup/shutdown page in Enterprise Manager, when I enter HOST CREDENTIALS as username:Bobby,password :welcome4all

and credentials for target database as username:sys,password :oracle, I get RemoteOperationException:ERROR: WRONG PASSWORD FOR USER .I don't understand why? Am I doing something wrong?

View 30 Replies View Related

Enterprise Manager :: Export Dashboards Or Access Them Via Anonymous User?

Jan 28, 2013

We have OEM and within are some great metrics and dashboards, with key information.We want to post some of these dashboards and metrics on our wiki page and/or within our application dashboards (we use jaspersoft.com/)

We do not want to give our normal users the access into OEM, so is there a way to somehow export these dashboards or access them via an anonymous user somehow?Either the dashboards themselves would be great, or somewhere to export the data the dashboards user - as i can then create the dashboards myself using the data.

example of dashboards/info to use would be:
- General, Host CPU, Active Sessions, SQL Response Time, Space Summary, etc...

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

Security :: Authenticating Oracle User Based On Windows User ID?

Mar 11, 2011

We are trying to implement the following security to our database.

As of now, the access rights are same for all the windows users logging into the Oracle application with the same Oracle user Id.

But now, we want to improve our security by granting different levels of rights to the users based on their Network Id even though they use the same Oracle User Id to log into the application.

We are not looking for the users to be identified externally.

(CREATE USER "OPS$ORACLE-BASE.COMTIM_HALL" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$ORACLE-BASE.COMTIM_HALL";
)

View 3 Replies View Related

OS User Occupying Shared Memory As Oracle User

Dec 11, 2012

we are trying ti implement BMC monitoring tool for our oracle 11g2 RAC/solaris10 environment. for the purpose we create a user called bmcuser in OS level, this user connecting database to monitor, this user occupy shared memory as oracle. Explain why this user taking that much shared memory just to connect database using sqlplus.

oracle taking 55% bmcuser taking 44%,

SQL> show parameters memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3232M
memory_target big integer 3232M
shared_memory_address integer 0
SQL> show parameters sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3232M
sga_target big integer 0
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
6449 bmcuser 47M 44M sleep 23 10 0:57:31 0.2% PatrolAgent/1
[code]........

pga & uga usage sessionwise

SID     ORA_USR     OS_USR     S_PROG     S.MACHINE     S.PGA_MEM     S.PGA_MEM_MAX     S.UGA_M     S.UGA_M_MAX
252     (null)     oracle     oracle@racdev1.zakathouse.org (ARC3)     racdev1.     31054584     32168696     181056     181056
227     (null)     oracle     oracle@racdev1.zakathouse.org (ARC2)     racdev1.     31054584     32168696     181056     181056
177     (null)     oracle     oracle@racdev1.zakathouse.org (ARC0)     racdev1.     31054584     32168696     181056     181056
576     (null)     oracle     oracle@racdev1.zakathouse.org (LGWR)     racdev1.     16693544     21281064     181056     181056
326     (null)     oracle     oracle@racdev1.zakathouse.org (LMS0)     racdev1.     13753080     13753080     181056     181056
376     (null)     oracle     oracle@racdev1.zakathouse.org (LMS2)     racdev1.     13556472     13556472     181056     181056
[code]........

View 6 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 :: Oracle 11g R2 On RHEL5

Jul 23, 2010

I have installed Oracle 11g R2 on the RHEL 5 platform. Once the installtion is complete we need to run two scripts:
1: orainstRoot.sh
2: root.sh

As the root user.When we run the root.sh script is ask us to overwrite three variables yes/no? we did yes.After Running these scripts we opened the database, tried to run listner as well, everything is running fine but when we are trying to run the Emterprise Manager using command:

emctl start dbconsole

we are prompted with a path to check the logs
/u01/app/oracle/product/11.2.0/db_1/localhost_orcl11g/sysman/log

I do not know which file I have to check.What could be the reason we are not able to run the EM.I need it urgently as we ahve to generate the AWR reports for the client.

View 7 Replies View Related

Enterprise Manager :: Can't Able To Open In Oracle 10g

Nov 28, 2010

i have installed oracle 10g. but not able to start the Enterprise Manager, i am getting the error when ever i enter the url in the browser (//home:5560/ isql plus) .

View 5 Replies View Related

Enterprise Manager :: Console For Oracle 11g?

Sep 5, 2010

is Oracle Corporation provides Enterprise console for 11g, like oracle provides Enter prise console for 10g through which we can view/create/manage all the objects like tables,views,functions and procedures etc.

View 8 Replies View Related

Which User Can Set Up A New User In Oracle 11.2.0

Mar 21, 2011

Which user can I set up a new user in Oracle 11.2.0 ?

i connect with scott/tiger as normal (i cant connect with sysdba)

how i can create new user ?

how to connect with power user for this ?

View 1 Replies View Related

Oracle 10g RAC On Windows 2008 Enterprise Server

Oct 7, 2010

I'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?

View 4 Replies View Related

Oracle Enterprise Manager Connect Multiple DB?

Jul 16, 2008

Is that possible to make Oracle Enterprise Manager of 10gr2 connect to multiple oracle database?

View 1 Replies View Related

Export Graph From Oracle Enterprise Manager?

Aug 12, 2013

is there a way to export/download graphs that are shown on Oracle Enterprise Manager? I tried to find some buttons that make it possibile, but I'm unable to find them...

View 1 Replies View Related

Enterprise Manager :: Oracle Port Number

Feb 10, 2012

While connecting my oracle with My JDBC driver . i got an SQLException:

public class Orajdbc {
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection
[code]......

i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..

How to find port number of my Oracle Service?

View 1 Replies View Related

Enterprise Manager :: How To Start - Downloaded Oracle 11g

Oct 5, 2012

I have just downloaded Oracle 11g from the Oracle website.How do I start enterprise manager?

but once I get away from UNIX I don't have a clue what I am doing. What are the windows bits. I go to the oracle bin directory from a dos window and enter emctl commands, and I get "emctl" is not recognised as an ibternal or external command.

View 3 Replies View Related

Enterprise Manager :: Interpretation Of Oracle Metrics

Aug 23, 2011

When looking at some of the metrics available in OEM, I am puzzled by the interpretation:

1) Using the Host tab, and load metrics, I can get a metric for the Total I/O for the host .. I assume this is IOPS.

2) Using the Database tab, and the instance_throughput physreads_pc metric I can get a metric for the Physical Reads from the database instance per second.

3) We generally have several Oracle instances on the same server, and in all cases, the sum of the physical reads for each database is SIGNIFICANTLY higher that the total i/o for the host.

Am I interpreting the information incorrectly ? Does one of the metrics consider db_block_size ?

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 :: Connection Of Oracle Server With EM

Apr 5, 2011

I am trying to connect my oracle server with enterprise manager. But i have no network connection. What will be the probable listener config. ?

View 2 Replies View Related

Server Administration :: Oracle Rac Standard / Enterprise

Jul 15, 2011

10g Oracle Standard Edition RAC feature and how it is charged. I mean: is it free option for Standard Edition or payable?

I read something about Baby Rac on wiki and there was information that only with Engerprise Edition RAC is an extra-charge option for Standard Edition RAC is included.

[URL]......

Quote:Oracle Corporation includes RAC with the Standard Edition of Oracle Database (aka Baby RAC), but makes it an extra-charge option for the Enterprise Edition

We do have corporate licencing model in our firm, so we can evaluate what version of Oracle we need to install (One, Standard or Enterprise) bu there is no matter what version we chosed, because our licensing model give us possibility to install the highest version. So usually we were choosing the Enterprise Editions.

But only limitation for us is an options. We can't have additional option like partitioning, RAC, Oracle Tuning Pack, etc... in order to have additional option we need approval from our financial management.

I have idea to change one of our installation from Enterprise Edition to Standard Edition in order to have RAC option for free. Like i said. If we want to have RAC in our Enterprise Edition we need additional approval of money expense - but this is not easy. But our licensing model give us possibility to install Standard Edition of Oracle instead or Enterprise Edition and have RAC option include without additional expenses.

View 2 Replies View Related

Backup & Recovery :: Restore Database In Oracle 10g Enterprise?

Apr 13, 2011

I am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.

View 5 Replies View Related

Enterprise Manager :: Unable To Create EMCA In Oracle 11g

Mar 28, 2011

I am using Oracle 11g Rel1 on Window 2003 Server R2 Enterprise Edition x64 with SP2. I am trying to configure DB console using command throuth emca. But I am getting the below mentioned error. Even I tried after manually deleted the repository then tried to create using emca command.

==========================================================
Mar 28, 2011 3:11:16 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 28, 2011 3:16:16 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_53.log for more details.
Could not complete the configuration. Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_
53.log for more details.

C:Documents and SettingsAdministrator>
===========================================================

logfile attached for your reference.

View 1 Replies View Related

Enterprise Manager :: Backup In Oracle Management Server

Dec 6, 2009

when i want to do backup in oracle management server for my database (repository)that i created give me an error message

<< using perferred credentials , the following error occurred: ORA-01031 :insufficent privileges>>

View 1 Replies View Related

Enterprise Manager :: Oracle DB Consoleorcl Service Not Starting?

Dec 5, 2011

I saw this thread:[URL]....

and checked to see if I could start:[URL]........

using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:

"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?

I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.

-- Oracle version info:
SCOTT@orcl_11gR2> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

5 rows selected.

-- partial systeminfo (some lines like product key removed):
C:>systeminfo
OS Name: Microsoft Windows 7 Professional
OS Version: 6.1.7601 Service Pack 1 Build 7601

[code]...

View 1 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

Enterprise Manager :: Oracle Intelligent Agent Error

Jun 3, 2004

I'd install Oracle8i on Window -XP.I am facing following error for Oracle Intelligent Error while starting my computer.

Oracle Intelligent Agent Executable encountered a problem and needed to close.

> C:DOCUME~1ADMINLOCALS~1TempWER1.tmp.dir00dbsnmp.exe.mdmp
> C:DOCUME~1ADMINLOCALS~1TempWER1.tmp.dir00appcompat.txt

I'd already config two db. in my computer & I can access both db.

View 8 Replies View Related

ALL Scripts Which Automatically Get Run By DBCA In ORACLE 11G Enterprise Edition

Jan 19, 2013

which are ALL the scripts which automatically get run by DBCA in ORACLE 11G Enterprise Edition.

View 2 Replies View Related







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