DB Version & DB Type

select *
from v$version;

Untitled

Archive Log Mode

archive log list

Untitled

CharacterSet

select * 
from sys.props$
where name = 'NLS_CHARACTERSET';

Untitled

Startup Time

select instance_name, startup_time, status
from v$instance;

Untitled

Service Name

select name
from v$database;

Untitled