Location: FAQ

Discussion: TNSNAMES.ORA file read through SQL promptReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 3 posts

RashidRMA
TNSNAMES.ORA file read through SQL prompt
Jun 27 2009, 3:09 AM EDT | Post edited: Jun 27 2009, 3:16 AM EDT
Dear Sir/ Madm
i am working in Oracle 9i Database, i want to see connection host string, as well as SID_NAME through which, i have connected my connection on client side in Distributed database.

With Profound Regard 1  out of 1 found this valuable. Do you?    
Keyword tags: None
luciofer
luciofer
1. RE: TNSNAMES.ORA file read through SQL prompt
Jul 1 2009, 1:14 PM EDT | Post edited: Jul 1 2009, 1:14 PM EDT
"Dear Sir/ Madm
i am working in Oracle 9i Database, i want to see connection host string, as well as SID_NAME through which, i have connected my connection on client side in Distributed database.

With Profound Regard"
How did you connect to the instance if you don't know that information?

Cheers Do you find this valuable?    

prestonoracle
2. RE: TNSNAMES.ORA file read through SQL prompt
Aug 19 2009, 1:00 PM EDT | Post edited: Aug 19 2009, 1:00 PM EDT
I'm not sure if I understand your question; but I will say much of the info I interpret you to want is found in the V$ views. These are well documented, and can be found on the Net.

To get you started:
v$parameter
v$database Do you find this valuable?