Monday, October 18, 2010

PLSQL Developer Error - SQL*Net not properly installed [SOLVED]

Hello friends..

If you are using PLSQL developer to connect to the ORACLE database may have faced the problem "SQL*Net not properly installed".

This problem occur beacause ORACLE_HOME and the oci.dll path location may not have been configured in the preferences.

To do this, go to Tools>Preferences.

Now set the Oracle Home as the location of the ORACLE_HOME variable or where the Oracle is installed. In my case it is:

C:\Oracle\DataBase\product\10.2.0\db_1

After this set the oci.dll file location just under the Oracle Home text field.In my case it is:

C:\Oracle\DataBase\product\10.2.0\db_1\bin\oci.dll

click Apply>OK

Now restart the PLSQL developer. This should solve the problem.

Cheers..

7 comments:

  1. Still its showing initialization error.Couldnt load c:......\oci.dll

    ReplyDelete
  2. Thank you so much for your help,it solved my issue, Divakar Ganni

    ReplyDelete
  3. It solved my issue. Thanks for helping.

    ReplyDelete
  4. I have not installed oracle database what to do kindly help....

    ReplyDelete
  5. We don't use PLSQL Developer yet we get this error. Can you explain how to set MANUALLY:
    "After this set the oci.dll file location just under the Oracle Home text field.In my case it is:"

    ReplyDelete
  6. If you're attempting to lose weight then you absolutely have to jump on this brand new custom keto meal plan diet.

    To design this service, certified nutritionists, fitness trainers, and professional cooks have joined together to develop keto meal plans that are productive, decent, money-efficient, and enjoyable.

    From their grand opening in early 2019, 1000's of clients have already remodeled their figure and health with the benefits a certified keto meal plan diet can provide.

    Speaking of benefits; in this link, you'll discover eight scientifically-tested ones provided by the keto meal plan diet.

    ReplyDelete