Skip to Main Content

Oracle Database Discussions

Announcement

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!

Unable to connect to database (from server) using sqlplus after doing "relink"

Noname123Aug 28 2018 — edited Sep 4 2018

I am not able to connect to oracle database (from server) using sqlplus after doing oracle relink.  (I used to connect before the relink)

The error I am getting is :

sqlplus: symbol lookup error: /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib/libclntsh.so.11.1: undefined symbol: nnfgtent

I use Oracle Database R11.2.0.3

$ ls -ltr /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib/libclntsh.so.11.1

-rwxr-xr-x 1 oracle oracle 52178642 Aug 29 03:28 /Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib/libclntsh.so.11.1

$ echo $ORACLE_HOME

/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3

$ echo $LD_LIBRARY_PATH

/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib:/usr/X11R6/lib:/usr/openwin/lib:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/lib:/usr/dt/lib:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/ctx/lib

$ echo $PATH

/usr/bin:/usr/bin:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/perl/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oratest3/bin:/Stage/prodDB11gr2/prod/db/tech_st/11.2.0.3/bin:.:.:.

$ cat /etc/oracle-release

Oracle Linux Server release 5.9

Kindly, help

Comments

Please Help. How should i achieve this usecase.

Mr.Enzo

Hi , I think first you should have a look to the rules for posting,

you're not making a proper question.

Aside from that I think you could achieve this by doing an xslt transformation from you database collection to your output schema.

All the best,

Enzo Godoy.

Muhammad Shaheen Akhtar

Dear Enzo,

Thanks for your feedback. Can you help me in this matter that how can i use xslt transformation to achieve the output.

Regards,

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2018
Added on Aug 28 2018
8 comments
1,091 views