For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
oracle client is installed in the following path- D:\oracle\product\10.2.0\client_1
what should be set in the oracle home of PL/SQL DEVELOPER?
Hello,
I'm sorry but I think this is not the correct forum to ask. This forum is related to SQL and PL/SQL questions.
You are asking question which are specific to PL/SQL developer which is not an Oracle product.
You should ask your question to PL/SQL developer forum: PL/SQL Developer - Allround Automations forums
Regards,
Alberto
Dear Gayathri,
Believe the same should point to where the tnsnames.ora file is.
Thanks and Regards,
Vysakh Suresh
If you have properly installed Oracle Client then you can see the list of Oracle Homes in the relevant drop down list.
Then you may choose one of them.
If you have instant client you should fill the next to the Oracle Home field OCI library with path to the oci.dll
I think you are using different (32/64) bit software for plsql developer and oracle client.
If you can check -
What is the plsql developer (32 bit or 64 bit)
What is the Oracle Clinet (32 bit or 64 bit)
If both are not same, than download and install the correct versions.
Also try setting TNS_ADMIN environment variable to the location where TNSADMIN.ORA file is located.
What should be set in the oracle home of PL/SQL dev
Nothing.
ORACLE_HOME does not need to be set for an Oracle client to connect to the database.
On Windows, there is a single requirement. When the kernel loads the client executable into memory, external dependencies need to be resolved by the link loader. The client executable will have a static or dynamic reference to the Oracle Call Interface (oci.dll). This DLL needs to exist either in the existing working directory, or reside in a directory listed in the PATH environment variable.
The easiest method to get Oracle client-server working, is to download the Oracle Instant Client ZIP file, unzip it to a user folder on your system, and add that directory to the PATH environmental variable. That is it. No installation needed. No registry settings to create and maintain. No ORACLE_HOME to set.
Optionally create a TNSNAMES.ORA and SQLNET.ORA file in a user folder, and set environment variable TNS_ADMIN to this directory.
That simple.
You were told yesterday (Empty message while logging onto PL/SQL developer version 7) that you should be asking your PL/SQL Developer questions on a forum for that product.
Oracle do not create that product, so don't expect support for it from the Oracle community. Sure, some people may use it, but you'd be better asking the people who definitely do use it, or who created it over on their community.
What would you like help with next? MS SQL Server perhaps? or Photoshop? ... some other non-oracle product?
If you read the text above drop down it states empty is autodetect so let it be empty, you might be facing issues as your PL/SQL Developer version doesn't support 64 bit Oracle Client and your Oracle Client is 64 bit. Check this out, use 32 bit client and that should help.
use dual session can avoid more session single users
Thanks all for the response.
I am new to pl/sql developer .How do I check if it is 32 or 64 bit?
By asking in the PL/SQL developer forum (wherever that is) and following the instructions they give you.
Hi Gayu,
Select * FROM V$VERSION you can see version and 32 bit or 64 bit details
3218565 wrote: Hi Gayu, Select * FROM V$VERSION you can see version and 32 bit or 64 bit details
3218565 wrote:
Wrong: this is returning the version of database, not the oracle client and not PL/SQL developer.
http://o7planning.org/web/fe/default/en/document/20948/guide-to-installing-and-configuring-pl-sql-developer#a27425
refer this site
Gayathri Venugopal wrote: Thanks all for the response. I am new to pl/sql developer .How do I check if it is 32 or 64 bit?
Gayathri Venugopal wrote:
In my first answer I have already provided you the link to PL/SQL Developer forum. You can keep asking questions here but, as I said before, this is not the proper place to get answers to your question.
Just check the Oracle Client is 32 or 64 bit. To connect to an Oracle database, the 32 bit PL/SQL Developer version requires a 32 bit Oracle Client and the 64 bit PL/SQL Developer version requires a 64 bit Oracle Client.
Gayathri Venugopal wrote: I am new to pl/sql developer .How do I check if it is 32 or 64 bit?
Windows sucks - no Linux/Unix like file command.
Open Task Manager. As I recall the 64bit version shows which executables currently running are 32bit on the 64bit o/s.
There is also a PowerShell method that I used some time ago - cannot recall what the commands were. Googling will likely turn up PowerShell scripts that can be used for this.
Thanks Billy!!
Yeah thanks.I had raised a question there but I see a faster response here .Also, don't have much time to rely upon only one source
I hear the SQL Server forums are slow too - but that doesn't mean you should post those questions here.
From your machine change your folder to D:\oracle\product\10.2.0\client_1\bin execute tnsping from command prompt without any parameters, the output will show if it's 32 bit or 64 bit. PL/SQL developer doesn't support 64 bit client as it's 32 bit software.
You stated yesterday your PL/SQL developer is version 7, I believe it's 32 bit but you can check that also,once you start PL/SQL Developer cross check in task manager if it has *32, if yes than it's 32 bit.
if you have the setup file it can tell you as 64bit setup has "x64" mentioned in file name.
Or if you have installed the software at default location, the path can tell you
- program file (x86) holds 32 bit application
- program file holds 64 bit application
There should be a Help/About option in PL/SQL developer too, which can reveal this.
Thanks Nimish!!
