Can not use SQLDeeloper after "ldconfig"

**vendetta18** · 29-Nov-2009, 23:42

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...

**vendetta18** · 02-Dec-2009, 01:35

No Idea... No suggestions

I am still looking for a solution...

**shuLhan** · 02-Dec-2009, 03:57

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.

**beef623** · 02-Dec-2009, 10:22

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.

**vendetta18** · 02-Dec-2009, 22:51

Originally Posted by shuLhan

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...