Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Hi Temur, It sounds like all you need to do is to get the agent process started.
  3. Yesterday
  4. Do you know how we can get access to view reports generated by other users? As a conversion/migration team, we need to have access to all reports that need to be converted. Is there an administrative method for getting access?
  5. So I has been confirmed through tests that the EUL_ACCESS_PRIVS table only identifies who the report is shared with. To continue our test, UserB saved the report as his own and shared it with User A and User C. Now when we run the report above it shows the following: WORKBOOK_NAME EU_USERNAME WORKBOOK_KEY ReportA UserB ReportA ReportA UserC ReportA ReportA UserA ReportA1 ReportA UserC ReportA1 This shows that the report can be saved with the same name, but the key shows that it is a different version. The original owners of the report do not appear in this query, but if we look in the EUL5_DOCUMENTS table, we see the 2 entries representing the owners of the reports ( ReportA UserA and ReportA UserB). Google is an amazing thing. I just searched for "desc EUL5_QPP_STATS" and found the following query from you...
  6. I entered the command emctl status agent Output: Agent is not running. emctl stop agent or emctl start agent Output: list of all commands of emctl appears. emctl upload Output: Agent is not running. We cannot invite an expert because our db is secret and we have restricted funds. For emergency oracle support also need to pay. We hope in Internet and forums.
  7. Last week
  8. Thanks for posting the solution! Take care. . .
  9. Hello, After long searchs, it seams that there is no possibilities to use SQLNETAuthentication to connect as sysdba on a puggable database with impdp and expdp. The below syntaxe doesn't work for connect to a pdb: \"pdb1/as sysdba\" So i decide to use Oracle Wallet to avoid password display in my scripts. Have a nice day and thank you for your help! VME
  10. 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!
  11. Dear Sir! Unfortunately our technical support is already over. I said before that I added the “log on as a batch job” privilege already. I noticed one thing. In EM the status of agent is unreachable. Can it cause my error? If yes how to fix it?
  12. Thank you. This is very helpful and clear. If you could share the SQL, I'd appreciate it. We set up a test scenario. User A creates a report on Thursday and shares it with user B and user C. Both user B and user C view the report on Friday. The following query is run: SELECT USERS.EU_USERNAME , DOCUMENTS.DOC_NAME WORKBOOK_NAME , ACCESS_PRIVS.AP_UPDATED_DATE LAST_UPDATED , DOCUMENTS.DOC_DEVELOPER_KEY WORKBOOK_KEY , DOCUMENTS.DOC_DESCRIPTION WORKBOOK_DESCR FROM EUL5_ACCESS_PRIVS ACCESS_PRIVS ,EUL5_DOCUMENTS DOCUMENTS ,EUL5_EUL_USERS USERSWHERE DOCUMENTS.DOC_ID = ACCESS_PRIVS.GD_DOC_ID AND USERS.EU_ID = ACCESS_PRIVS.AP_EU_ID AND DOCUMENTS.DOC_CONTENT_TYPE = 'application/vnd.oracle-disco.wb' AND DOCUMENTS.DOC_NAME = '01_OBIE_test_tbj'ORDER BY USERS.EU_USERNAME, DOCUMENTS.DOC_NAME; The results return 2 rows. We only see the share with user B and user C on Thursday. (I don't have access to play around in the data yet, so I'm asking someone else to send me results.) This suggests that the EUL5_ACCESS_PRIVS table only identifies who the report was shared with... thus providing me a clear roadmap of who the reports have to be shared with in OBIEE. I'm wondering if I should send a query with an outer join so I can see the creator as well as the users the report is shared with. Then any entry without an "ACCESS_PRIVS.AP_UPDATED_DATE" value would be the originator and the others could be eliminated as "shared copies". If I was to just query the EUL_DOCUMENTS table for this one report, would I get 1 entry or 3? (I've just asked the DBA to query this one report in the EUL_DOCUMENTS table.) If it is just one entry, then I know all reports in EUL_DOCUMENTS identifies uniquely saved reports... aka, all the reports we need to convert. Sadly, I'm still just trying to figure out how to identify the scope of the project and how we will know when we have successfully completed it. My next question is whether there is a way to pull the SQL without having to click through the GUI to display it for each report individually. I know there are some queries that return SQL, but without documentation on the underlying tables, who knows what it's returning. Definitely not enough data to indicate it's the SQL for all reports. Thank you for your help!
  13. 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/
  14. Earlier
  15. Dear Sir! I checked connection with ping, tnsping etc. The connection is normal. There is a connection in SQLPlus. In EM all functions work except host credentials. No host credentials are accepted. May be there is a specificity for virtual machine and local host. My OS are WIN 7 and WIN 10. Best Regards
  16. The latest patch of Oracle server

    Hi, I always download patches from MOSC: http://support.oracle.com Good luck!
  17. 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!
  18. Edited to make sure that any replies are notified to me
  19. Hi Liz First of all. The terminology "base report" is not a term within Discoverer. The correct term is a Workbook, and a Workbook contains one or more Worksheets. Each worksheet is essentially a report. So, if you think in terms of an Excel file, the file itself is the Workbook, with the Excel sheets being the Worksheets. If a workbook is shared with another user then ALL of the worksheets within that workbook are also shared. The worksheets are in essence separate reports, just like Excel sheets are separate, so care has to be taken to make sure that a shared workbook only contain worksheets that really need to be shared. Let me try and answer your questions one by one: Q1) Can the user who receives the shared report change it? A1) No, let me explain. The "owner" of a Discoverer workbook is the only one allowed to save changes to that workbook in the database. Shared users can, however, save a copy of the workbook under their own account, if they have the correct privileges, but it then becomes a separate and distinct workbook. Any changes subsequently made to the original will not be replicated within any saved user workbooks. Q2) Is the shared report a separate copy of the base report (or just a reference to the base report)? A2) It is not a separate workbook but a reference to the original workbook. Q3) If the base report is changed, will the shared report also change? A3) Yes, if the "owner" makes a change to a worksheet that it is a shared workbook, all of the users with whom the workbook was shared will see the change Q4) Is there a way to determine which reports are base reports and which ones are shared? A4) It is possible, using SQL, to query the underlying EUL (End User Layer) tables to determine whether a workbook has been shared or not. If need be, I can share some SQL with you Best wishes Michael Armstrong-Smith
  20. I have Oracle 11g db. DBs are in two computers: virtual and local. I want to back up and recover in Enterprise Manager. Need to specify Host credentials. I enter Host credentials and button. The error appears: connection to host as user Administrator failed, connection refused: connect. Login of administrator, password is correct. In local policy administrator was added in Logon as batch job. Administrator was added in ora_dba. Administrator was added in users of oracle with sysdba privileges. In EM preferences/preferred credentials through Host and Database Instance I specified Username, Userpassword, Host User and Host Password. No results. What to do? What else settings do I have to do? Best Regards Temur Yakubov
  21. Hi, Please provide the link to download the latest patch to apply on Oracle server Many Thanks and Best Regards
  22. First, I should ask if my understanding is correct... I understand Discoverer users can generate a report and once they like the results they are getting, they can share it with other users so they don't have to write their own report. To keep them straight, I refer to the original report as the "base report" and the copies that were shared to other users as the "shared report". So, here are a few questions: 1) Can the user who receives the shared report change it? 2) Is the shared report a separate copy of the base report (or just a reference to the base report)? 3) If the base report is changed, will the shared report also change? 4) Is there a way to determine which reports are base reports and which ones are shared? Unrelated, is there a way for the DBA to access all the reports, by all users? I understand you can log in as a particular user and see their reports, but as a DBA, can you see all reports made by all users? Thanks for the help. Liz
  23. Oracle 12 : xml file with several declarations

    Hi burleson. I found this page already but it does not say anything about it. If you can open the request, it would be quite appreciated. Thank you
  24. 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!
  25. Hi, I have a program working with xml files that is not performing anymore since we installed Oracle 12 databases. The error we suddenly have is this one : ORA-31011: XML parsing failed ORA-06512: at "MYUSER.MYPACKAGE", line 1663 ORA-19213: error occurred in XML processing at lines 2 LPX-00209: PI names starting with XML are reserved ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at "MYUSER.MYPACKAGE", line 1162 ORA-06512: at line 1 It seems there is a problem on line 2 of the xml. Indeed this file is particular. There is an xml declaration on each line and lines are pretty long, defining several xml blocks : <?xml version="1.0" encoding="utf-8"?><Flag:...... <?xml version="1.0" encoding="utf-8"?><Message:...... <?xml version="1.0" encoding="utf-8"?><Message:...... ..... <?xml version="1.0" encoding="utf-8"?><Message:...... <?xml version="1.0" encoding="utf-8"?><EndFile:...... In the program the first thing done is to create a blob file from this xml file (this is a function called at the beginning : FUNCTION TransformToCLOB(filename varchar2) RETURN CLOB) src_clob:=BFILENAME('MY_REPERTOIRE', filename); dbms_lob.createtemporary(dest_clob, cache=>TRUE); DBMS_LOB.FILEOPEN(src_clob); DBMS_LOB.LoadFromFile( dest_clob , src_clob ,DBMS_LOB.GETLENGTH(src_clob) ); dbms_lob.close(src_clob); RETURN dest_clob; after that, there is this instruction (ligne 1162 where the error occurs): v_xml:=XMLTYPE(dest_clob); What has changed in Oracle 12 that causes the problem? I have the feeling that several declarations in one file are not welcome anymore.
  26. 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!
  27. WCC silent install

    Hello everybody! Have a task to create silent install for WCC. Everything goes fine with software install and DB schemas creations because there is "Save Response File" button in the wizards. Unfortunately there isn't such button in weblogic domain creation wizard. If anybody knows the fastest and easiest way of how to create domain that is is the same as wizard creates, please advice... Leonid.
  28. 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!
  29. Oracle Discoverer - report definition comparison?

    I still don't have access, but someone sent me the output from the dump utility and the actual SQL from the report. He said he was able to use the Discoverer desktop tool to pull up the SQL, and he cut and pasted the contents so I could compare the dump with the actual SQL. It seems the workbook dump is just a wordy version of the SQL so it seems it would be easier to parse/compare the SQL. Plus, I understand there is a way to quickly create some simple/rough reports in OBIEE using the SQL from the Discoverer reports... so this is my current focus. I'm trying to get 500-1000 reports converted in 2-3 months so any automation is a good idea. The need is to just get the users operational, then we'll focus on creating a data warehouse and replacing their reports with ones that take advantage of the new DW and OBIEE bells and whistles. Do you know if there is a way to automate gathering the SQL for all the reports in Discoverer? Manually pulling up the SQL for each of these reports will be very time consuming. Is SQL for the reports stored in the database somewhere so I can just query it? Thanks so much for your help.
  1. Load more activity