When running a Level 1 or Level 0 backup via OEM 13c, the following RMAN error causes the run to fail. (The RMAN script is being ran with proper sysdba credentials from OEM 13c.) RMAN-06169: could not read file header for datafile 2 error reason 5 Oracle documentation suggests reason 5 indicates 'Unable to open file'. However, if I execute the exact same RMAN statement directly on the server, the backup runs fine. We have removed the database from OEM and decommissioned the agent, the redeployed the agent as well as reinstated the database in OEM, but the error still occurred.

This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted. > ~~~End Step Output/Error Log~~~ > Error Log:BackupOp > error writing input to commandERROR: Invalid username and/or password > > ~~~End Step Output/Error Log~~~ I only have 2 backup jobs and both are affected by this. Not sure how much information here is useful but what I have been looking at is the SYS account the jobs are using is not locked out. select account_status from dba_users where username = 'SYS'; ACCOUNT_STATUS -------------------------------- OPEN The emagent.trc log is showing this pair of lines for every backup job since the first one failed. 2019-02-06 23:44:26,791 Thread-14472 ERROR command: failed to write to stdin of process 6228: (error=232, no message available) 2019-02-06 23:44:26,791 Thread-14472 ERROR command: nmejcc_feedInput: received -11 from process write Restarting the DBConsole service has no affect and the errors persist. I can manually run full and archivelog backups just fine as sysdba. I see no reason to blame RMAN since I can run the backup rman scripts just fine. I think this is just an EM issue.

I am running Oracle Enterprise Manager 13c (Version 13.5). The binary for OMS EMCTL had got corrupted displaying 0 bytes. To mitigate this issue, I installed EMCTL on a different location on the same server and copied the binaries to the original middleware binary location. However, when running the emctl utility I am greeted with "No OMS is found to be associated with the current Oracle Home". Have done all the internet recommendations from setting environmental variables, to changing the properties files (./sysman/config/emInstanceMapping.properties).

I have Oracle OEM 13c ( 13.4) and it was working fine. We have to reboot server due to memory issues and later on when we tried to restart oms, web tier was not coming up. Eventually we have found out that DemoIdentity & Trust certificates were expired so that was taken care. However, we have issues with console URL https e.g Console URL: https://db-oem-grid.mydomain.com:7802/em Does not work and it redirects to https://b-oem-grid.mydomain.com:7802/omsunavailable.html I see following message Enterprise Manager Cloud Control is not currently available. The EMGC_OMS server where Cloud Control runs, or some other component, might be down. httpd.conf has #[Listen] OHS_LISTEN_PORT Listen 7788 ssl.conf has following port #[Listen] OHS_SSL_PORT Listen 7802 .... #[VirtualHost] OHS_SSL_VH # SSL Engine Switch: # Enable/Disable SSL for this virtual host. SSLEngine on admin.conf has Listen 127.0.0.1:10006 #[VirtualHost] OHS_PROXY_VH WebLogicHost db-oem-grid.mydomain.com WebLogicPort 7301 Debug ERR From weblogic admin console I have configured SSL listen port for EMGC_OMS1 to 7301 EM console is working on weblogic port e.g. https://db-oem-grid.mydomain.com/em:7301/em However it does not work https://db-oem-grid.mydomain.com/em:7802/em ( 7802 was in ssl.conf) emctl status oms -details also shows console URL to https://db-oem-grid.mydomain.com/em:7802/em What is causing issue ? I am not sure whether some thing is wrong with http.conf, ssl.conf, mod_wl_ohs.conf and weblogic ports does ssl.conf port 7802 supposed to redirect to weblogic SSL port 7301 Our previous configuration before cert expiration was working fine and OEM URL was working fine too https://db-oem-grid.mydomain.com/em:7802/em Thanks for help.

Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log: > CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me. ###Listener.ora ADR_BASE_VLISTENER = D:\app\Administrator VLISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521)) ) ) ###lsnrctl status .... truncated .... Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521))) Services Summary... Service "prodbkp" has 1 instance(s). Instance "prodbkp", status READY, has 1 handler(s) for this service... Service "prodbkpXDB" has 1 instance(s). Instance "prodbkp", status READY, has 1 handler(s) for this service... The command completed successfully That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with sqlplus sys@prodbkp as sysdba just fine. Case should not be an issue with service names as per docs.oracle.com ###tsnnames.ora PRODBKP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = prodbkp) ) ) Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't _appear_ to have one. ###v$parameter output SQL> select value from v$parameter where name='service_names'; VALUE -------------------------------------------------------------------------------- prodbkp That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it. Basically everything looks right but something is still wrong. I cannot install Enterprise Manager __Environment__ - Windows Server 2008R2 - Oracle 11g

I am using oracle 10g with 4 instance with same server but one of them has failed to start Oracle Enterprise Manager and rest of three are working fine. Starting Oracle Enterprise Manager 10g Database Control .................................................................... failed. Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/vvs/sysman/log Here I posted error log file -> **emagent.log** 2018-07-31 11:10:55 Thread-4124031232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:10:55 Thread-4124031232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:18:41 Thread-4124375296 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:35:28 Thread-4124748032 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 12:03:41 Thread-4124952832 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 14:36:27 Thread-4125055232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 15:23:13 Thread-4124195072 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 18:19:37 Thread-4124940544 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) and when i am going to start agent is says agent is already running but while checking status it shows the agent is not running [oracle@vvs ~]$ emctl start agent TZ set to Asia/Calcutta Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. Agent is already running [oracle@vvs ~]$ emctl status agent TZ set to Asia/Calcutta Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent is Not Running And when I'm going to start OEM of this instance it failed but the rest of OEM instance stops working So please let me know how to solve this Problem edited data 2018-08-16 16:47:50 Thread-4090489664 ERROR http: 9: Unable to initialize ssl connection with server, aborting connection attempt 2018-08-16 16:47:50 Thread-4090489664 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://vvs:5502/em/upload/ : retStatus=-1 2018-08-16 16:47:50 Thread-4090489664 ERROR pingManager: Error in updating the agent time stamp file 2018-08-16 16:47:53 Thread-4087339840 ERROR command: nmejcn: error receiving response headers from http://vvs:5502/em/upload/

I joined a company as a fresher DBA and in testing server there is weird problem. My listener is running very well and developers can connect remotely to database but whenever I tried to start enterprise manager it shows me error like: > Listener status down. The listener "(Listener name)" is not running > using the Listener parameter file: > "D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin/listener.ora" on > Host: "(Hostname)" at Port: "1521". When I write emctl status dbconsole it shows me: > C:\Windows\system32>emctl status dbconsole Oracle Enterprise Manager > 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 > Oracle Corporation. All rights reserved. > https://(HOSTNAME):5500/em/console/aboutApplication Oracle Enterprise > Manager 11g is running. > Logs are generated in directory > D:\app\dbadmin\product\11.2.0\dbhome_1/(Hostname)_(Listenername)/sysman/log Here is my listener.ora file: (Listener Name) = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = (Hostname))(PORT = 1521)) ) ) lsnrctl status: LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 10-JUL-2018 14:33:08 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production Start Date 02-JUN-2018 19:18:22 Uptime 37 days 19 hr. 14 min. 57 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\listener.ora Listener Log File d:\app\dbadmin\diag\tnslsnr\ESTDEV03\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ESTDEV03)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "********" has 1 instance(s). Instance "*******", status READY, has 1 handler(s) for this service... Service "******" has 1 instance(s). Instance "******", status READY, has 1 handler(s) for this service... The command completed successfully. TNSPING Result: TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-JUL-2018 10:16:01 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = (Service Name)))) OK (20 msec) TNSNAMES.ORA File: # tnsnames.ora Network Configuration File: D:\app\dbadmin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. (Listener Name)= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = (service name)) ) ) (Listener Name) = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) I asked old DBA but he was not able to find a solution.
So can you please tell me where is a problem?

I need to connect to the Oracle Enterprise manager of a remote machine. But I dont know the port on which OEM is running on the remote machine. I have access to the machine from terminal though. Is there a command to see the port number OEM is running on. The remote machine is CentOS and I need to open the OEM on my local browser (I am running windows 10) I would really appreciate all the help. I am new to Oracle.

I have an alert message with tablespace usage that should recheck the status in Cloud Control 13c and send the email only once, but it sends every 30 minutes. It shows me the TS_USAGE error of the tablespaces when it grows over 95%. Can I have something configured to send only once when it happens and then some kind of clear notifications to send back that everything is ok, when I resize manually the tablespace and fix the issue? Kind regards.

Is there any way to split all the stats by user (schema) when looking at the Performance tab in the Oracle 11g Enterprise Manager? or effectively some other tool to retrieve that information - e.g. a running chart of #active sessions for user (that's probably easy by probing the v$session or similar). Or a running chart of I/O Megabytes per Second broken by user/schema.

Single instance DB. I can login to Oracle Enterprise Manger (OEM). However, on the Home Page it says: > Status - Agent Unreachable Most tasks such as checking RMAN status, adding datafiles, etc. can still be done through the OEM. I do not know how ***Agent Unreachable*** impacts the OEM in this case (DB Control) I checked status of the agent from $ORACLE_HOME/bin/emctl status agent, it showed: > The Agent is not Running So, I want to start the agent, but running the command $ORACLE_HOME/bin/emctl start agent is not working. The command is not available. In Oracle docs, it is mentioned that the command emctl start agent should be executed from AGENT_HOME/bin. However, I do not know the AGENT_HOME path. How can I start the OEM Agent or figure out what the underlying issue is?

I just installed Oracle 19c on Red Hat and would like a graphical way of managing users and tablespaces. I enabled EM Express but the new interface (omx) does not allow to manage users, and the old (emx) interface cannot be used because Flash is forbidden by our policy. I also discarded SQL Developer since it is too complex: I would like a simpler tool. Does oracle database include anything similar to the EM Database Control of oracle 10g?

It's easy to set the LifeCycle status ( and other properties ) with emcli, emcli set_target_property_value -property_records="sometestdatabase:rac_database:LifeCycle Status:Test" but getting the current values isn't clear - I'm not seeing a verb in the reference. Is the only way via SQL against the repository? Thanks Simon

Environment: - Oracle Enterprise Manager Cloud Control 13.4 - OMS console with third party certificate - Secured My situation is the following: 1. I am new in this client and apparently the former DBA added a third party certificate in the OMS console, which is near to expire. 2. I've been reading the documentation but I can't find the keystore or the wallet associated to this certificate. So far, I checked the following [oracle@hcbae2p01ora022 bin]$ $OMS_HOME/bin/emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : hcbae2p01ora022.hcbe.corp HTTP Console Port : 7788 HTTPS Console Port : 7803 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/app/oracle_em/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/app/oracle_em/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://hcbae2p01ora022.hcbe.corp:7803/em Upload URL: https://hcbae2p01ora022.hcbe.corp:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : hcbae2p01ora022.hcbe.corp Admin Server HTTPS Port: 7102 Admin Server is RUNNING Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: hcbae2p01ora022.hcbe.corp WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server Information BI Publisher Managed Server Name: BIP BI Publisher Server is Up BI Publisher HTTP Managed Server Port : 9701 BI Publisher HTTPS Managed Server Port : 9803 BI Publisher HTTP OHS Port : 9788 BI Publisher HTTPS OHS Port : 9851 BI Publisher is locked. BI Publisher Server named 'BIP' running at URL: https://hcbae2p01ora022.hcbe.corp:9851/xmlpserver/servlet/home BI Publisher Server Logs: /u01/app/oracle_em/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/ BI Publisher Log : /u01/app/oracle_em/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log As you can see for the information above, the console is secured in port 7803. I thought that the certificates should be stored in a wallet, but I can't find the wallet anywhere. I neither was able to find any command in emctl or in emcli that can show me where this certificate is stored. What I know is that the certificate is there, as I used the secdiag option of emctl [oracle@hcbae2p01ora022 bin]$ $OMS_HOME/bin/emctl secdiag openurl -url https://hcbae2p01ora022.hcbe.corp:7803/em Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Log file: /tmp/OpenPage_2023_02_21_13_45_115472876152891123503.log Opening page: https://hcbae2p01ora022.hcbe.corp:7803/em Using non-validating trust manager; all certificates will be blindly accepted. Proxy server is not set Using protocol: TLSv1 Negotiated protocol: TLSv1 Getting the certificate chain Details of cert# 1 in chain: Subject: EMAILADDRESS=xxxxxxx, CN=hcbae2p01ora022.hcbe.corp, OU=xxxxxxx, O=xxxxxxxxxx, L=xxxxxxxxxxxxxx, ST=xxxxxxxx, C=xx Issuer: CN=XXXXX CA, DC=cloud, DC=corp Valid from: Tue Mar 23 13:54:18 UTC 2021 Valid till: Thu Mar 23 13:54:18 UTC 2023 Serial#: 914345119400343461451536535824392411922746991 Public key: Sun RSA public key, 2048 bits modulus: 231855705770066152570314131577369954637603242446759578989206803754751294824351565914129743732110994827544588460966543883605976172129693569117661509357921588815183478850378089638600314229871995314771805178017341640817875936605315833364302707372595554647453833532393376815757155001416722179412428142624866504902792330046510191621551136336433918248638504659645288726326144907300691458403587891238454297424723893811783631933359920866785373444400398845738032568684675766778615996191586165668755883030522959798859689120112193205210100146390085495955132802650583693008692078856106184239283369895227655357520072938286 public exponent: 65537 Signature algorithm: SHA256withRSA Following headers are present in the response: Date : Tue, 21 Feb 2023 13:45:12 GMT Vary : Accept-Encoding Adf-Context-Id : fd3875f9-7da2-4e9a-bbe1-cdbc60ba6af8-00000002 X-Frame-Options : sameorigin X-ORCL-EMOA : true X-ORACLE-DMS-RID : 0:3:1 X-Content-Type-Options : nosniff, nosniff X-XSS-Protection : 1; mode=block, 1; mode=block X-ORACLE-DMS-ECID : fd3875f9-7da2-4e9a-bbe1-cdbc60ba6af8-00000002 Adf-View-Id : %2Flogon%2Fcore-uifwk-console-login Content-Type : text/html;charset=UTF-8 Cache-Control : no-store, no-cache, must-revalidate, post-check=0, pre-check=0, max-age=0 Response saved at : /tmp/hcbae2p01ora022.hcbe.corp_7803_2023_02_21_13_45_134697786630783685089.html [oracle@hcbae2p01ora022 bin]$ As you can see above, the certificate that allows me to access by https to the OMS console is stored somehow in OMS. But I can't find where exactly. I have tried to check all wallets in the server, but I could not find anything. I'd like to know how can I update this certificate with a new one that I have already in my hands. Is there a way to identify whether this certificate was included using emctl secure createca ? if so, how can I update the certificate stored there ? **UPDATE** Thanks to @Balazs Papp, I was able to find the wallet used by the OMS Console [oracle@hcbae2p01ora022 console]$ pwd /u01/app/oracle_em/gc_inst/user_projects/domains/GCDomain/config/fmwconfig/components/OHS/instances/ohs1/keystores/console [oracle@hcbae2p01ora022 console]$ orapki wallet display -wallet pwd Oracle PKI Tool Release 19.0.0.0.0 - Production Version 19.4.0.0.0 Copyright (c) 2004, 2020, Oracle and/or its affiliates. All rights reserved. Requested Certificates: User Certificates: Subject: EMAIL=xxxxxxxxxxxxx,CN=hcbae2p01ora022.hcbe.corp,OU=xxxxxx,O=xxxxxx,L=xxxxxxxxx,ST=xxx,C=xx Trusted Certificates: [oracle@hcbae2p01ora022 console]$ What I don't get is why it does not appear as a Trusted certificate ? If I copy this wallet to a different location, then I can use orapki to import the new certificate into the wallet, and then use emctl secure console -wallet to renew the certificate ? I have read somewhere that if there is a change in the certificate, such as the email address, you have to do it from scratch. Is that so ?

I am trying to generate email alerts from OEM to multiple email addresses. I have configured the SMTP server details from 'Setup' screen. And then I have added the email addresses under the 'Preferences' tab in OEM. To check if the alerts are working fine, I have shutdown database and restarted 3/4 times. But only once the alerts notification came and that too only to one email address and not to all the email ids mentioned. Please let me know why this is working in this way. Also, am I missing anything?? Do I need to add anything else to get the notification emails correctly for all the email ids?? Also, there is one screen for notification schedule. Do I have to define some schedule???

I have an Oracle 12c Database for my enterprise manager. I could not connect to enterprise manager because the database was closed. I opened listener. However, the database remained mounted mode. When I want to open the database in read & write mode, I get the error as follows: SQL> alter database open; > ERROR at line 1: > > ORA-00313: open failed for members of log group 3 of > thread 1 > > ORA-00312: online log 3 thread 1: > '/path/of/redo/redo03.log' > > ORA-27037: unable to > obtain file status > > Linux-x86_64 Error: 2: No such file or directory > Additional information: 3 When I go to the file location of redo03, there is no redo03. So it's logically, but not physically. There are some queries and results: SQL> col member format a50 SQL> select group#, type, member from v$logfile; GROUP# TYPE MEMBER ---------- ------- -------------------------------------------------- 3 ONLINE /path/of/redo/redo03.log 2 ONLINE /path/of/redo/redo02.log 1 ONLINE /path/of/redo/redo01.log 4 ONLINE /path/of/redo/redo04.log SQL> select group#, thread#, sequence#, bytes/1024/1024, members, status from v$log; GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS ---------- ---------- ---------- --------------- ---------- ---------------- 1 1 61525 50 1 INACTIVE 4 1 0 50 1 UNUSED 3 1 61527 50 1 CURRENT 2 1 61526 50 1 INACTIVE I tried doing this: create redo group 4. Drop redo group 3 and recreate redo group 3. There was no problem creating redo group 4. I used this command below: alter database add logfile thread 1 group 4 '/path/of/redo/redo04.log' size 50m; But when I want to drop group 3, it gives error as follows: SQL> ALTER DATABASE DROP LOGFILE GROUP 3; ALTER DATABASE DROP LOGFILE GROUP 3 * > ERROR at line 1: > > ORA-01623: log 3 is current log for instance dbname (thread 1) - > cannot drop > > ORA-00312: online log 3 thread 1: '/path/of/redo/redo03.log' I wanted to try disable the thread that redo group is connected to and after that I wanted to drop redo group 3. But it give error as follows: SQL> select thread#, status, enabled from v$thread; THREAD# STATUS ENABLED ---------- ------ -------- 1 OPEN PUBLIC SQL> alter database disable thread 1; alter database disable thread 1 * > ERROR at line 1: > > ORA-01109: database not open When I try to switch logfile, it gives error as follow: SQL> alter system switch logfile; alter system switch logfile * > ERROR at line 1: > > ORA-01109: database not open I tried to clear and drop the logfile group. It gives error as follow: SQL> alter database clear unarchived logfile group 3; alter database clear unarchived logfile group 3 * > ERROR at line 1: > > ORA-01624: log 3 needed for crash recovery of instance dbname (thread > 1) > > ORA-00312: online log 3 thread 1: > '/path/of/redo/redo03.log' And I tried to recover database and after that open with below command: rman taget / recover database; > Starting recover at 09-JUL-20 > > using channel ORA_DISK_1 > > starting media recovery > > RMAN-08187: WARNING: media recovery until SCN complete > Finished recover at 09-JUL-20 exit; sqlplus / as sysdba SQL> alter database open resetlogs; alter database open resetlogs * > ERROR at line 1: > > ORA-01194: file 1 needs more recovery to be consistent > > ORA-01110: data file 1: '/path/of/file/system01.dbf' exit; rman target / recover datafile 1; > Starting recover at 09-JUL-20 using target database control file > instead of recovery catalog allocated channel: ORA_DISK_1 channel > ORA_DISK_1: SID= device type=DISK > > starting media recovery media recovery failed > > RMAN-00571: > > =========================================================== > > RMAN-00569: > > =============== ERROR MESSAGE STACK FOLLOWS > =============== > > RMAN-00571: > =========================================================== > > RMAN-03002: failure of recover command at > > ORA-00283: recovery session canceled due to errors RMAN-11003: failure > during parse/execution of SQL statement: alter database recover if > needed datafile 1 > > ORA-00283: recovery session canceled due to errors > > ORA-00313: open failed for members of log group 3 of thread 1 > ORA-00312: online log 3 thread 1: '/path/of/file/redo03.log' > > ORA-27037: unable to obtain file status > > Linux-x86_64 Error: 2: No such file or directory Additional > information: 3 As a result; there is a redo group 3 logically but there is no physically file. I am sure that nobody has deleted the file because I checked it with the history command on linux system. I can't open the database because redo group 3 cannot find. I can't logfile switch, I can't disable thead, I can't delete redo group 3 and recreate it. Please can you help with this? Best regards,

I want to write a select SQL statement but I want it to run on all databases being monitored by Oracle Enterprise Manager. I also would like to know how to run 'alter statements' on all database being monitored by the OEM. For eg. I would like to block/remove all users that have left the company from the database.

Oracle's enterprise manager has a metric named "User Logon Time" and will show an alert if that exceeds a certain threshold. I would like to retrieve the numbers stored for this metrics directly using a SQL query. However, I cannot find any view where this is stored. I can find "Logons Per Sec", "Logons Per Txn", "Current Logons Count" in the DBA_HIST_SYSMETRIC_SUMMARY view and "logons cumulative" and "logons current" in the DBA_HIST_SYSSTAT view. The view DBA_HIST_METRIC_NAME also doesn't list any metric of that name. So where does the Enterprise Manager get that information from? I'm talking about this alert:

I have installed Oracle 12c Standard Edition on one of my Windows 7 LAN desktops. Installation went fine. I created ORCL Container and ORCLPDB pluggable database during install. I can log in to Oracle SQLPLUS using SYS & SYSTEM passwords. I can as well login to Oracle Web Enterprise Manager (It runs on https://(hostname):5500/em ) using SYS & SYSTEM passwords without specifying any database. However in case of Web Enterprise Manager the moment I choose a database container (See the screenshot, left side login prompt) despite entering correct userid/password it prompts for yet another weblogin prompt. I am clueless what to enter here. I tried SYS & SYSTEM passwords but it did not help. During installation, it asked for an additional admin password that too does not work here. I also tried unlocking XDB & Anonymous accounts and restarted Database & listener but it did not help. tnsnames.ora has entries for both ORCL & ORCLPDB. Does anyone have any idea what this login is for and how to proceed further? Thanks.

I got task - **"send me the query used in this metric?"** It is related to Job with status "FAILED". I find this failed Job but can't find with which query this metric detect this error.