Register the database connection in dbartisan 9.1.1 (XE3)

click on oracle servers
register
choose oracle
click next
enter host, port, service_name, instance_name, datasource_name
click on next
enter login id and password
test connection
no need to have local tnsnames.ora file in the OS level