Results 1 to 5 of 5

Thread: Can not use SQLDeeloper after "ldconfig"

  1. #1

    Default Can not use SQLDeeloper after "ldconfig"

    Hi,

    I have openSUSE 11.2, KDE4.3.3 on my system. This weekend I installed Oracle 11gR1 on my system, the installation went on smoothly. I could connect to my database after installation from Konsole as well as SQL-Developer. I also wanted to install the COBOL pre-compiler. So I also installed Oracle Client for 11gR1. The installation for this also got over smoothly.

    But, when I invoked the pre-compiler (procob) from konsole it said that it could not find some ".so" file. The file was present in Oracle lib directory ( which existed in $ORACLE_HOME path). So I ran "ldconfig $path_of_oracle_lib_directory". After that procob worked fine. But since then I am not able to connect to Oracle instance from SQLDeveloper. It gave me some "Network Adapter Could not connect" error.

    Has anyone some solution to this problem... Please ask me if more information is needed from my side...


    --
    Vivek Bhat
    Linux User #496540
    Dell 620 S Desktop, 8GB, Intel(R) Core(TM) i5-2310 CPU @ 2.90GHz, openSuSE Leap 42.1
    +Plasma 5, Kernel 4.1.20-11-default x86_64

  2. #2

    Default Re: Can not use SQLDeeloper after "ldconfig"

    No Idea... No suggestions I am still looking for a solution...
    --
    Vivek Bhat
    Linux User #496540
    Dell 620 S Desktop, 8GB, Intel(R) Core(TM) i5-2310 CPU @ 2.90GHz, openSuSE Leap 42.1
    +Plasma 5, Kernel 4.1.20-11-default x86_64

  3. #3
    Join Date
    Aug 2008
    Location
    192.168.1.124
    Posts
    9

    Default Re: Can not use SQLDeeloper after "ldconfig"

    my guest is that there is a libraries conflict in your system.

    > So I also installed Oracle Client for 11gR1.


    i think you should not install Oracle-client if you already have a full
    Oracle database on the same system. And let's hope you not replaced some
    files on $ORACLE_HOME/lib with files from Oracle-client.


    > So I ran \"ldconfig
    > $path_of_oracle_lib_directory\". After that procob worked fine. But
    > since then I am not able to connect to Oracle instance from
    > SQLDeveloper. It gave me some \"Network Adapter Could not connect\"
    > error.


    just curious, what was the output of "lsnrctl status" and "ldd
    $ORACLE_HOME/bin/sqlplus" ?

    can you connect using sqlplus from local ?

    is $path_of_oracle_lib_directory point to $ORACLE_HOME/lib or point to
    Oracle-client library directory ? if it point to Oracle-client, remove
    it from /etc/ld.so.conf or change it to point to $ORACLE_HOME/lib, and
    try run SQLDeveloper again.

    Remove $path_of_oracle_lib_directory from /etc/ld.so.conf, run ldconfig,
    and try SQLDeveloper again.

    i hope that can give some lights on your way.

  4. #4
    Join Date
    Nov 2008
    Location
    West Plains, MO, USA
    Posts
    21

    Default Re: Can not use SQLDeeloper after "ldconfig"

    Oracle should have put the client in a seperate oracle home so you should be ok there (unless ldconfig got confused between the two). When you connect through SQL Developer, do you use tnsnames? If so, you might check to see if your database is listed.

  5. #5

    Default Re: Can not use SQLDeeloper after "ldconfig"

    Quote Originally Posted by shuLhan View Post
    my guest is that there is a libraries conflict in your system.

    can you connect using sqlplus from local ?

    i hope that can give some lights on your way.
    I am not sure what do you mean by "local" here... I am connecting to the Oracle installed on my laptop from my laptop only .. If you meant that can I connect through "Konsole" (KDE Terminal), then yes I can...

    Anyways, I must thank you both shuLhan and beef623 for looking into my problem.. I will check the things you have said tonight and report back...
    --
    Vivek Bhat
    Linux User #496540
    Dell 620 S Desktop, 8GB, Intel(R) Core(TM) i5-2310 CPU @ 2.90GHz, openSuSE Leap 42.1
    +Plasma 5, Kernel 4.1.20-11-default x86_64

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •