Jump to content

burleson

Members
  • Content count

    13,363
  • Joined

  • Last visited

Community Reputation

0 Neutral

1 Follower

About burleson

  • Rank
    Advanced Member

Recent Profile Visitors

3,055 profile views
  1. Hi Temur, It sounds like all you need to do is to get the agent process started.
  2. Thanks for posting the solution! Take care. . .
  3. Hi, Have you verified that the agent process is running? If you Google for “oracle OEM agent unreachable” you will see hundreds of pages from folks with the same problem! It can be caused by dozens of configuration issues and by bugs. If you need a patch you are out of luck. This forum is intended for answering questions but you need an expert to work with you in detail to resolve your problem! Since you let your support lapse, you can use a 3rd party to assist you. If you call 800-766-1884 you can get a certified DBA to help you troubleshoot the issue. See details here: http://www.dba-oracle.com/emergency_oracle_support.htm Good luck!
  4. Hi, This may be a bug, but I would check MOSC: http://support.oracle.com Also, see note 1080647.1 Also, note that you may need to add the “log on as a batch job” privilege. Also see here: https://www.google.com/amp/s/mohamedazar.com/2010/04/07/host-credentials-oracle-em/amp/
  5. The latest patch of Oracle server 11.2.0.4

    Hi, I always download patches from MOSC: http://support.oracle.com Good luck!
  6. Hi Temur, and welcome to the forum! The first step is to see if you can connect via sqlplus. Here are my notes on diagnosing connections issues: http://www.dba-oracle.com/teas_prae_util23.htm http://www.dba-oracle.com/t_troubleshooting_sql_net_connectivity_errors.htm Good luck!
  7. Oracle 12 : xml file with several declarations

    Hi Davenne, and welcome to the forum! I’m not a XML guru, but I did find this page that lists deprecated features in 12c: http://oradb-srv.wlv.ac.uk/ora12c/ADXDB/changes.htm#CJAJEECB If this does not help, I would search the MOSC forums or open a service request: http:/support.oracle.com Please post the solution when you find it! Good luck!
  8. WCC silent install

    Hi leonid, and welcome to the forum! We have little experience installing WCC, but I found this: https://docs.oracle.com/cd/E29542_01/install.1111/b32474/silent_install.htm#ASINS235 Good luck!
  9. Oracle Discoverer - report definition comparison?

    Hi, If you ave purchased an AWR license, then you can extract some SQL from the dba_hist_sqltext table: Please read: http://www.dba-oracle.com/t_extract_sql_file.htm Brware, the AWR SQL thresholds determine what statements are kept: http://www.dba-oracle.com/t_tuning_sql_statspack_awr.htm Good luck!
  10. Hi, Micheal Armstrong-Smith is the leading expert in your area. He is very nice, and he is well qualified to advise you: http://ascbi.com/contact.htm Say hello to him from me!
  11. Hi, and welcome to the forum! You can use SQL*Plus to take vanilla SQL and create an attractive report: http://www.dba-oracle.com/t_sql_plus_column_format.htm Good luck!
  12. Hi Kusr o, and welcome to the forum! First, gather the SQL execution plan for the statement, so that you can see how Oracle is accessing the data: http://www.dba-oracle.com/t_sql_execution_plan_tips.htm I suspect that you will see a full table scan. Next, you want to try a matching function-based index: http://www.dba-oracle.com/t_function_based_indexes.htm Good luck!
  13. Archivelog error

    Hi Renan and welcome to the forum! Your message says that the Oracle instance is not running. The startup command should get the instance running. Also, note this on the shared memory realm: http://www.dba-oracle.com/sf_ora_27101_shared_memory_realm_does_not_exist.htm Try these steps to get into archive log mode: http://www.dba-oracle.com/concepts/archivelog_archived_redo_logs.htm Good luck!
  14. Performance query question

    Hi Laurel and welcome to the forum! The main objective is to get an identical execution plan on 12c and 10g! I any surprised that stored outlines do not work for you, but hints are optimizer directives that can change execution plans. http://www.dba-oracle.com/t_sql_execution_plan_finished_query.htm I would play around with hints. The 10g database to replicate the 12c plan. http://www.dba-oracle.com/t_sql_hints_tuning.htm Without seeing the plans, I suspect that the poor performance in 10h is due to an unnecessary full table scan. Have a look at your optimizer_index_cost_adj parameter parameter on 10g. Good luck!
  15. Deadlock and need help to understand the Oracle Trace File

    Hi and welcome to the forum! This forum is a place to ask questions, but we cannot provide services here. Here are my notes on diagnosing deadlocks: http://www.dba-oracle.com/t_ora_00060_deadlock_detected_while_waiting_for_resource.htm You may want to start a service request on MOSC: http://support.oracle.com Good luck
×