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.
- Oracle Scheduler Job Failing
- Event read by other session causing blocks
- Create date periods based on two tables
- Oracle SQL query using regexp_substr to get string between 2 strings
- Missing expression in Oracle Function
- Examine all REF CURSOR outputs from stored procedure called in a loop
- PLS-00382: "expression is of wrong type" when opening REF CURSOR on stored procedure called in a loop
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PowerShell Script Failing at insert records
- How to resolve the following AWS Glue error while writing to Redshift using Spark: "ORA-01722: invalid number"?
- How to create an oracle.sql.ARRAY object?
- Select rows with same item code but different value in another column
- SQL select distinct with condition
- How to pretty format the printing of SQL queries in SQLAlchemy
- JetBrains PhpStorm / DataGrip introspecting Oracle database error
- Is there any way to maintain large scale data rules efficiently in SQL?
- How to check if input parameter of timestamp type in oracle stored procedure is null?
- How can I number the instance of a duplicate record?
- How to convert oracle regex pattern into Databricks compatible version?
- oracle add_months function differs from Java
- How to export (expdp) a tablespace Oracle express 21c?
- How to query the distribution (grouped by value range) of a column value in Oracle?
- Avoid ZERO and NULL Record
- BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page
- ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 82: ORA-00936: missing expression
- django how to see sql query when running tests?
- How to identify rows that add up (sum) to a specific amount
- oracle sql developer - HOW TO put together the results of 2 selects that have nothing in common
- No more data to read from socket error
- How Grant Create Foreign Key on another schema?