How to get the values of oracle database parameters from a unix development server?

Question

How to get the fallowing details from the unix development server?
The below parameter values should be provided in the .dbc file
and it should be mapped to the ETL Server .

dbms:<br> db_version:<br> 
db_home:
<br> db_name: <br> db_nodes: <br>
case: <br>
generate_dml_with_nulls:<br>
field_type_preference:<br>
treat_blanks_as_null:<br>
oldstyle_emptystring_as_null:<br>
fully_qualify_dml: <br>
dml_with_maximum_length:<br>
interface: <br> direct_parallel:
<br>

Please correct me if i am any where wrong in asking this question?
Many Thanks!!

Answer 1

If you can connect to it (not quite sure about your question), you can find some interesting information using the following query:

SELECT * FROM v$instance;