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;

Answer 2

If you want to save parameters in a file, you can do it this way:

SET WRAP OFF;
SET TRIMSPOOL ON;
SPOOL memory_parameters.txt;
select * from v$parameter;
SPOOL OFF;

Answer 3

select * from V$PARAMETER;
This will result the list of all the database parameters