83 questions
0
votes
0
answers
24
views
Oracle Enterprise Manager Plugin for Grafana limiting rows
I want to visualize versions of a specic subset of database hosts. The query returns ~350 target_names and a target_property and is working just fine.
When using "Oracle Enterprise Manager App&...
0
votes
1
answer
89
views
How to change Oracle's Enterprise manager 12c runtime properties from a webservice call?
I work with Oracle SOA Suite (Oracle fusion middleware 12c and 11g), combined with weblogic 12c, Azure pipelines, git repository, and SOAtest from parasoft as testtool.
I want to be able to change ...
0
votes
1
answer
31
views
OSB logging - Delay between WAF and OSB middleware
My problem is that I have a delay in my service when trying to hit OSB
I don't know if the problem is from middleware or WAF(network)
To insure that the problem is not from middleware I need to know ...
0
votes
1
answer
1k
views
error when add target host linux 7.9 on OEM 13.5
when I manually add target host on OEM 13.5, it's false at "Agent Deployment":
Execution of command cd /u01/app/oracle/oemagent/ADATMP_2023-06-12_08-53-25-AM;/u01/app/oracle/oemagent/...
0
votes
1
answer
219
views
Oracle job alert for DBMS job
I am trying to create an alert for a dbms scheduler job if it is running for a duration longer than expected. For example, if a job that usually takes 2 hours to run is now running for more than 2.5 ...
1
vote
1
answer
827
views
cant open oracle enterpise manager on oracle database 21c
I have problem with login in enterprise manager. I have windows 10 Education.Database successfully installed but still unable to log into http.
Po wydaniu polecenia lsnrctl:
lsnrctl status | findstr ...
0
votes
2
answers
2k
views
OEM 13 Error: Check if all adaptive features parameters are unset
I have error when try to install OEM 13.5 on Oracle 21c
error image
Prerequisite Name = Check if all adaptive features parameters are
unset
Prerequisite Detailed Name = Check if all adaptive features ...
1
vote
1
answer
3k
views
Oracle EM Express not showing all options
Why I cant see options like 'create user' in Eterprise Manager. I have Oracle database 19C.
My EM Express is showing just the performance.
Bellow you can see in image that in 11g you can create ...
0
votes
1
answer
830
views
Error updating CLOB in oracle : ORA-00600: [kcfrbd_2]
I get this error when I want to update clob field.If the updated text is short, there is no problem, but when I want to enter a long data, I get an error. I try to update one column with clob data ...
2
votes
1
answer
2k
views
How to upgrade Oracle Enterprise Manager Database Console without upgrade the database version itself?
Maybe the question is not so clear.
I'm not sure about the relations of these Oracle's components.
We have an Oracle 11g with an OEM dbconsole on it.
Is dbconsole and databse control are actualy the ...
0
votes
1
answer
462
views
SOA Composite deployment taking long time, sending servers in critical state
I recently deployed a soa composite application on em (Enterprise Manager) but it took 1 hour to deploy (it got deployed successfully after an hour) which resulted in admin and other server to go in ...
0
votes
1
answer
428
views
Oracle Data Masking Clarification
Hi I am looking at the possibility of implementing the Oracle Data Masking Package but require some clarification. I am looking to mask just my non-production data. In the process of doing this does ...
1
vote
1
answer
244
views
Oracle Enterprise Manager export real time monitoring for more databases in separate window
I am using Oracle Cloud Manager 13c.
I have many databases, but I would like to track the CPU load of only five or six important ones.
I see the Performance Hub where I can see the load and also ...
1
vote
0
answers
903
views
Frequent OEM agent down alert
We are getting frequent agent down alerts from OEM for oracle database servers. When login to the server and check the agent will be running without issues. How can we stop these false alerts?
0
votes
1
answer
96
views
Monitor Table for duplicate inserts in Oracle 11g
We have a table in Oracle 11g DB which has millions of records. For a few months, we have noticed that duplicate records are getting inserted into the table. Is there any way to alert via email when ...
-1
votes
1
answer
964
views
Are there any ready-to-use VMs having Oracle Database and EM Cloud Control?
The thing is that I am studying Oracle database administration, and I want to test everything out on a VM where it has Oracle Database 12c edition, along with Enterprise Manager Cloud Control.
Are ...
1
vote
0
answers
536
views
Oracle Enterprise Monitor behind nginx proxy keep redirecting infinitely
I am trying to setup OEM behind nginx reverse proxy. Here is my nginx config.
location ~* "^/em/(.*)" {
add_header X-debug-message "Just for testing" always;
proxy_redirect ...
0
votes
1
answer
978
views
How to delete jobs from MGMT_JOB in oracle?
I created two jobs through Enterprise Manager. Now I want to delete these jobs. I am trying delete jobs with this query but getting error
set linesize 300;
column job_name format a50;
column ...
0
votes
1
answer
1k
views
How to delete schedule jobs through Enterprise Manager oracle
I am using oracle database 11g. I created 2 schedule jobs of backup through Enterprise Manager. Now when I delete jobs then I am getting following error
The specified job, job run or execution is ...
1
vote
1
answer
187
views
different response time when executing a specific query
I've been trying to figure out a performance issue for a while and would appreciate if someone can help me understand the issue.
Our application is connected to Oracle 11g. We have a very big table ...
0
votes
0
answers
388
views
How to alter your homepage in Oracle's enterprise manager
How can I change my starting page after logging in to Oracle's enterprise manager?
Everytime I log in to Oracle's Enterprise Manager (SOA 12c) to inspect the flow traces of my middleware projects I ...
6
votes
10
answers
36k
views
Getting "Unable to check for available memory." on Oracle DB 18c
I am trying to create a database in order to complete my self learning, but unfortunately I got unexpected error "Unable to check for available memory.", I am doing it using Database ...
0
votes
1
answer
1k
views
How to get the DDL/Source code of a function in Oracle Enterprise Manager (OEM)
Sometimes we are unable to fetch a source code via dbms_metadata.get_ddl the package then we can use OEM as another way to generate DDL
0
votes
1
answer
512
views
How to set the Database Host Name during Oracle enterprise manager installation
I'm trying to install Oracle Database for the first time and I'm facing many problem. I, following this guide, but I can't understand what should I set in the form shown in section 14. What is the ...
0
votes
0
answers
230
views
Oracle Enterprise Manager Database Express 12c Japanese Login Page
I installed "Enterprise Manager Database Express 12c" to my Oracle Database 12c Standart Edition.
When I try to login main page I get an error which is shown as below link
login page
error page
1
vote
1
answer
487
views
Oracle Enterprise Manager Cloud Control 12c RAC
We've just provisioned a 2 node Oracle 12c RAC with the help of an outside vendor, and we have very little internal knowledge or experience of Oracle (2 guys used to use Oracle 9i elsewhere).
I've ...
0
votes
0
answers
216
views
How to schedule each step of jobset separately by schedule job element in soa suite bpel 12c using Enterprise scheduler service(ESS)?
I want to schedule a jobset step separately in oracle SOA suite 12c in jdeveloper.
For example I want to schedule the first step to be run today at 15:00 pm and second step to be run tomorrow.
Is it ...
0
votes
0
answers
912
views
Oracle Database remote access of sqlplus via linux
I have a Oracle Database installed on remote linux server (say 192.168.0.142 ) and I am able to connect via db client like sqldeveloper. However I have a use case where I want to access 'sqlplus' of ...
6
votes
1
answer
2k
views
Triggered SMS through SOA/UMS not getting Sender Address from sdpmessagingdriver-smpp driver configuration settings
DESCRIPTION:
We are using sdpmessagingdriver-smpp driver deployed on SOA server
to send SMS messages.
We have configured SMPP driver properties with "Sender Address" &
"Default Sender Address".
...
0
votes
1
answer
5k
views
"Invalid source address" exception when sending SMS using SMPP Server
Everything was working fine for us from last 8 months and suddenly we started getting this error.
We configured SMPP driver properties in Oracle EM console and sending SMS using UMS integrated with ...
0
votes
3
answers
6k
views
Oracle 11g Enterprise Manager Login Fail Internal Error has Occured
I have installed Oracle 11g on my Windows 10 machine. I followed all preinstallation requirements.
When trying to log in to the Enterprise manager via this link:
https://localhost:1158/em
I get the ...
2
votes
1
answer
10k
views
ORA-02065: illegal option for ALTER SYSTEM
I'm new to Oracle. I was learning Backup and Recovery. For that, I did
$ sqlplus system/password
SQL> alter system set db_recovery_file_dest_size=8gb scope=both;
But I got error this error:-enter ...
0
votes
0
answers
270
views
Receiving error message when creating user using EM Express
Need help, when using Oracle EM Express to add user I'm receiving error messages listed below. I don't have any table space listed and I am logged in as SYSTEM or SYS.
ORA-01031: insufficient ...
1
vote
1
answer
2k
views
How to fix SSLHandshakeException
We are getting the below error when i try to parse the wsdl in Enterprise manager. How do i fix this.
The WSDL document could not be parsed.The following error occured while parsing the WSDL location ...
2
votes
1
answer
1k
views
Oracle Monitoring on AWS: EM Express vs Cloud Control
I am looking for general advice from anyone who has experience monitoring Oracle RDS databases in AWS. The system that I am working with will involve several enterprise Oracle RDS databases (on the ...
0
votes
1
answer
2k
views
Oracle 11g Agent Connection to Instance Status Failed
I was installing the Oracle 11g Standard Edition by using below URL :
http://dbaora.com/install-oracle-11g-release-2-11-2-on-centos-linux-7/
After installation is completed all is good I can able to ...
0
votes
1
answer
2k
views
can't open oracle enterprise manager with firefox version 45
when my oracle enterprise manager starts it is not visible on browser and when I'm trying to attempt it through Firefox i get the this error :
An error occurred during a connection to oracle2017:...
0
votes
0
answers
285
views
Oracle 10g Enterprise manager charts issue
Heloo,
Database is Oracle Database 10g Release 10.2.0.5.0 - 64bit Production.
RAC with 2 nodes.
In EM on activity i have situations like below:
Why are gaps in chart with active sessions.
In this ...
1
vote
1
answer
12k
views
How to force accept a SQL Plan Baseline?
In Oracle (looking at this in Oracle Enterprise Manager) I have a particular SQL Plan Baseline which is set to Enabled = YES.
However, I can't get the ACCEPTED = YES to work. According to the ...
1
vote
1
answer
1k
views
Tables with no rows in oracle
When I create any new tables in oracle 11g enterprise manager or sql plus
it results in something like this:
-there is no row count (no event zero)
When I insert data to the table by SQL*plus, it ...
0
votes
1
answer
780
views
Oracle enterprise manager cloud control 13c extensibility download agent failed
I am using Oracle enterprise manager cloud control 13c
It has no agent for oracle db 12 for Linux machines and I trie to download it using the extensibility -> self update -> agent software and ...
2
votes
0
answers
5k
views
Error occurred during activation of changes after deployment in EM
I am stuck with a error while activating my deployment in weblogic server (version - 12.2.1).
I am deploying EAR of ADF application to weblogic through em and shows a below error message.
Using Oracle ...
0
votes
1
answer
677
views
Recreate Enterprise Manager 11g (RAC)
Due to a supposed bad installation of the repository of Enterprise manager, I want to recreate it using:
emca -config dbcontrol db -repos recreate -cluster
I have seen in a successful simulation (...
0
votes
1
answer
4k
views
Oracle Enterprise Manger Agent not working, making it not possible to configure EM DB console
I have installed oracle database 11gR2 on Oracle linux 7.2. However, oracle enterprise manager was not working. I tried to figure our what was wrong and a long search, i came across a blog that ...
1
vote
2
answers
2k
views
Installing Oracle Enterprise Manager Cloud Control 12c on 11gR2
Installing Oracle Enterprise Manager Cloud Control 12c
The progress just halts at 52% with this message
Configuration assistant "Repository Configuration" is in progress log file shows.
oracle....
0
votes
1
answer
214
views
Oracle Enterprise Manager rounding tablespace size?
Does Oracle Enterprise Manager round values or am I missing something in my SQL query?
OEM is showing the tablespace size for SYSAUX as 2GB. But, when I query the dba_data_files table, I get 1940 MB. ...
1
vote
1
answer
618
views
Oracle query results don't match Enterprise Manager values
I am trying to get the size of all tablespaces on an Oracle database.
I have tried 2 ways of getting the info.
Option 1 gives me good values, but it doesn't give return any values when the ...
1
vote
0
answers
1k
views
Oracle Enterprise Manager throttling target's metric collection
I have Oracle Enterprise Manager 12c installed managing a 2-node-RAC with multiple cluster databases.
I recently added the recovery catalog, OEM repository and the listener on the corresponding (third)...
0
votes
0
answers
238
views
Oracle hide user from EM views
Oracle 10gr2. I'm trying to hide user ADMIN from Enterprise Manager SYS.DBA_USERS and SYS.ALL_USERS views. All through sqlplus / as sysdba.
I am using this code
EXECUTE DBMS_METADATA....
0
votes
1
answer
775
views
Enterprise Manager Errors on Oracle 10g2 on Linux
I have installed an instance of Oracle Enterprise Manager Database Control 10g Release 10.2.0.1.0 in Centos 6.5
Attempts to launch the Enterprise Manager agent with the command:
emctl start ...