Recent content by dgs!

  1. dgs!

    Do I need TNS_ADMIN set?

    Thanks Marco. The primary issue I was having is that I created tnsnames.ora and it was actually created as tnsnames.ora.txt. After I exposed the extension of all the files I discovered this issue.
  2. dgs!

    Do I need TNS_ADMIN set?

    I just installed version 15.0.4.2064 and I just downloaded an instant client. I populated my tnsnames.ora file and completed the Connection>Oracle Home and Connection>OCI Library entries. Then I closed pl/sql developer and restarted it. When attempting to create a connection, my database is...
  3. dgs!

    Oracle Cloud Login Issues

    thx
  4. dgs!

    Is PL/SQL Developer available for MAC

    Is PL/SQL Developer available for installation om MAC?
  5. dgs!

    Import CSV data

    Duh, I do this all the time..... I find the answer after posting a question. TEXT INPORT
  6. dgs!

    Import CSV data

    Is there a way to import records from a CSV file?
  7. dgs!

    Oracle Cloud Login Issues

    Solved..... Oracle's SQL Developer was referencing a ZIP file. I unzipped it, then fully qualified the path to the unzipped wallet information. Then I added WALLET_LOCATION to my SQLNET.ora file.
  8. dgs!

    Oracle Cloud Login Issues

    I am struggling to login to our oracle database located in the cloud. Oracle's SQL Developer is using a WALLET to connect. As far as I know, PL/SQL Developer does not have this capability. I installed an instant Oracle Client and extracted the TNSNAMES.ora info from the wallet. I added a...
  9. dgs!

    Debugger hangs

    Yes it is RAC. What do I need to do on a RAC system to get the debugger to work?
  10. dgs!

    Debugger hangs

    Attached picture shows PL/SQL Developer attempting to debug a procedure. It says 'Executing" at the bottom, but none of the debug icons are active.
  11. dgs!

    Stored Procedures not showing up

    This problem was not happening in DEV, only QA and PROD. I enabled the DBA views in the preferences and the problem got fixed in QA and PROD. Wonder why DEV worked? As always, THANKS Marco!! I have an open issue with the PL/SQL Debugger I was hoping you could assist with
  12. dgs!

    Stored Procedures not showing up

    I am logged into our PROD database and when I open the PACKAGE, PROCEDURE, FUNCTION I do not see anything. I am able to see these objects from DBA_OBJECTS, but they do not show up in the navigation bar
  13. dgs!

    Debugger hangs

    I had our DBA group issue DEBUG CONNECT SESSION to my Oracle User but that did not help
  14. dgs!

    Debugger hangs

    SQL> select* from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production...
  15. dgs!

    Debugger hangs

    12c
Back
Top