Enterprise Manager :: Preventing A User To Login To OEM
May 25, 2011Is there a way to prevent a user to login to OEM in oracle 10g?
View 6 RepliesIs there a way to prevent a user to login to OEM in oracle 10g?
View 6 RepliesI 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?
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
I have a RAC cluster with several databases on it. One of my DB's, when starting the OEM in Internet Explorer, will never open the HOME page. I get the login page, and enter sys/password > SYSDBA. The progress bar on the bottom of browser will slowly move for a period of time, then I get the infamous 404 screen. dbconsole IS started...even stopped and restarted....
Thinking I need to drop and recreate the OEM repository using emca....have the commands to use oin a standalone world, but need some pointers for RAC world.
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?
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?
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...
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 Relatedi 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.
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
How to start EM on windows 7?
View 3 Replies View RelatedMy 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)
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.
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 RelatedI created an externally authenticated user in database. And can login without password with below syntax.
SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"
This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.
connect scott[proxy_user]/password_for_scott@TESTDB
So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?
- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?
- i have created a login form in one canvas.
- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query
SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;
[code]...
Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .
I have a mainform through which one can access 3 different application(say a ,b,c)i have made three push buttons by clicking it the main menu of the respeective application is called.The three applcication have different users(user a,user b,userc)and have different database on the same version(db1,db2,db3 on 111g).I am using formservlet and i am calling the main form. configuration.I dont want the user to enter the username and password so i have hardcored it in formsweg.cfg file. my problem is that i login to the main form as 'user a' so i can access the application'a'.but now if i want to access applicatin 'b' how can i can i login as 'user b'?
View 6 Replies View RelatedI'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 RelatedI wanted to restrict the Users to login to DB using Application like TOAD or PL/SQl Developer .
But the users can login to DB using sql*plus.
We can get this info once user looged in to DB.
SQL> select SID,USER#,USERNAME,SERVER,MODULE from V$SESSION where USERNAME='LIVE4LEARN';
SIDUSER#USERNAMESERVERMODULE
12418265LIVE4LEARNDEDICATEDSQL*Plus
23018265LIVE4LEARNDEDICATEDPL/SQL Developer
43718265LIVE4LEARNDEDICATEDPL/SQL Developer
54018265LIVE4LEARNDEDICATEDPL/SQL Developer
Can we make this check done before login process and allow users to login when module not in ('TOAD','PL/SQL Developer').
I have designed a Login form which takes username, password and connect string is hardcoded.I have compiled it, made an fmx file. created a shortcut to desktop. given the BIN path in shortcut.
when i want to lauch it, oracle's default login popup is shown.It can be by passed while defining username/password@string in shortcut properties but it reveals the password. every one can access it. I want to launch my own form without logging in to oracle. how can i avoid default login popup?
I just create a user and tried to log in but it gives the following error, why?
SQL*Plus: Release 10.1.0.4.2 - Production on Tue Sep 27 10:57:55 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create user user1 identified by user1;
User created.
SQL> conn user1
Enter password: *****
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
How can i get the Current user log in on my system using global variable.
View 6 Replies View Related10.2.0.3 on Linux
I reset a user password and the user is unable to login as you can see below
[oracle@testdb 10.2.0]$ sqlplus sys/manager as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:21 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> alter user sysman identified by oracle;
User altered.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options
[oracle@testdb 10.2.0]$ sqlplus sysman/oracle
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:32 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR: ORA-01017: invalid username/password; logon denied
User unable to login even after password reset
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]....
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 RelatedI 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.
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 :@
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 ?
We have a production database on 11.2.0.2 version. The application user was prompted to change the password after his password expired.
USERID NTIMESTAMP# ACTION# RETURNCODE
------------------------------ --------------------------------------------------------------------------- ---------- ----------
M500796 13-DEC-11 06.11.06.065209 PM 100 28001
After changing the password he is not able to logon. The aud$ table does not show any occurrence of 1017, therefore it is not a question of Invalid password.
LVV> show parameter SEC_CASE_SENSITIVE_LOGON
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
I have two table APPLICATION_1 and APPLICATION_2, where user's login date is captured.There will be multiple records for each user.Same user may or may not be present in both tables.
The requirement is to find those users who have not logged-in in the last 3 years.
-- Test Case
DROP TABLE application_1;
DROP TABLE application_2;
CREATE TABLE application_1
(
seq NUMBER ,
user_id VARCHAR2(30),
[code].....
Using the below query I'm able to get the desired output.
SELECT user_id, MAX(login_date) last_login_date FROM (
SELECT user_id, MAX(login_date) login_date FROM application_1 GROUP BY user_id
UNION ALL
SELECT user_id, MAX(login_date) login_date FROM application_2 GROUP BY user_id
) GROUP BY user_id
[code].....