Configuration of oracle 11g remote database with PL/SQL Developer 14
I need some assistance in configuring my oracle 11g database with the PL/SQL developer 14. I have installed and configured 11g client for my windows PC but the database is not show in the DBs list on PL/SQL 14 as:
But I got connected when I use PL/SQL Developer 7 as:
Actually, I want to use some advance features and plugins of PL/SQL Developer 14 which are not available in 7.
The problem has been solved. Actually, the issue was that the PL/SQL was 64 bit and the client was 32 bit that's why I had to download and install a 64 bit client which I installed and set the path to it's oci.dll file and that's solved my problem. One more thing I need to mention is that I have also created an environment variable for TNS_ADMIN and set the path to the folder which contains tnsnames.ora file.
Other answers are also appreciated.
- Connecting to Oracle 11g Database from Dockerized Spring Boot Application
- How to find Oracle Service Name
- Oracle Apex: ORA-24344 Success with compilation error
- Oracle database 23ai: Error ORA-02264 occurs, but I can neither find a constraint with the specified name nor drop one
- Select only one role for user when logging to Oracle
- How can I connect to an Oracle database as SYS using an ADO connection string?
- Oracle Apex passing item results from a Select list to another Select list on the same page
- Oracle database seems to be locked
- SQL developer not show results if they match certain criteria
- Only include records that all rows within a group meet a specific condtion
- ORA-28001: The password has expired
- Oracle/SQL PLUS: How to spool a log and write intermittently throughout script
- How to kill all active and inactive oracle sessions for user
- Is Execute SQL script a preferable way to run PL/SQL?
- What is the disadvantage of using SHRINK SPACE for an Oracle Table?
- Oracle JSON Query with hyphen-key
- Could not find file 'C:\SomePath\Oracle.DataAccess.Common.Configuration.Section.xsd' when connecting to Oracle server
- Aging distribution by location using receipt transactions
- How to shrink secure file LOBs in Oracle
- How to convert date to timestamp(DD-MON-YYYY HH24:MI:SS.FF format) in oracle?
- Save output of loop in single table in oracl SQL
- How can I confirm a database is Oracle & what version it is using SQL?
- Outer function returning multi-line values with the help of refcursors
- Spring's Stored Procedure - results coming back from procedure always empty
- How to replace unicode displaying in XML from SQL results
- How to use recursive function for product transition?
- Using condition inside subquery
- DELETE Multiple Duplicate Rows Without Column ID
- Reset sequence value with a simple SQL statement in Oracle 19c
- Aspire AddOracleDatabaseDbContext set optionsBuilder.UseQueryTrackingBehavior