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!

select SYS_CONTEXT ('USERENV', 'HOST') from dual; not giving any data

SmohibJul 18 2018 — edited Jul 19 2018

hi all,

i have installed Oracle 11.2.0.4 client on a application server and connecting to a db successfully.

client team have connected to db and fired below query but the query does not return any data from the appicaiton server, but when the same query is used from local machine(oracle client, sqldeveloper) it works/gives details.

select SYS_CONTEXT ('USERENV', 'HOST') from dual;

i am not sure where what might be issue - infact i had uninstalled 11.2.0.2 oracle client and installed 11.2.0.4 but the same issue persists.

can you please share more thoughts as to where i might have missed to check.

thanks,

Mohib

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2018

Added on Jul 18 2018

#general-database-discussions

9 comments

4,629 views