from paramiko import SSHClient
import paramiko

client = SSHClient()
client.set_missing_host_key_policy(paramiko.client.AutoAddPolicy)
client.connect('server', username='username', password='password')
#stdin, stdout, stderr = client.exec_command("sudo su - oracle")
stdin, stdout, stderr = client.exec_command('sudo su - oracle', get_pty=True)
stdin.write('passwordn')  # I donno n is compulsory or not. My password don't have it
stdin.flush()
print(stderr.read().strip())
print(stdout.read().strip())
stdin, stdout, stderr = client.exec_command("pwd")
print(stdout.read().strip())
sftp = client.open_sftp()