ALTER SYSTEM SET db_create_file_dest = '/u02' SCOPE=BOTH;

ALTER SYSTEM SET db_create_online_log_dest_1 = '/redo1' SCOPE=BOTH;

ALTER SYSTEM SET db_create_online_log_dest_2 = '/redo2' SCOPE=BOTH;

ALTER SYSTEM SET db_recovery_file_dest = '/fra' SCOPE=BOTH;

ALTER SYSTEM SET db_recovery_file_dest_size = 60G SCOPE=BOTH;

COLUMN DISPLAY_VALUE FORMAT A30

COLUMN NAME FORMAT A40

SELECT name, display_value

FROM   v$parameter

WHERE  name IN ('db_create_file_dest', 

                'db_create_online_log_dest_1',

                'db_create_online_log_dest_2',

                'db_recovery_file_dest',

                'db_recovery_file_dest_size')

/