DBA Genesis Support

Search

Arun Kumar
- 1 min read

Give Oracle user permissions to connect remotely

On a aws server, you need to connect via EC2-USER and then perform switch user to connect Oracle user.

Use below commands to allow Oracle user connect the aws EC2 server remotely

Connect EC2 server

Connect to your ec2 server with ec2-user and switch to oracle user and make .ssh directory to hold remote authentication key


su - oracle
mkdir .ssh
chmod 700 .ssh

Add remote authentication

Below commands will add remote authentication to oracle user


touch .ssh/authorized_keys
chmod 600 .ssh/authorized_keys
GET http://169.254.169.254/latest/meta-data/public-keys/0/openssh-key>.ssh/authorized_keys

Now you must be able to login to EC2 server via putty directly with Oracle user!

AWS

128 views

Recent Posts

Mount EFS on EC2 Instance

You might have created an Elastic File System (EFS) and now would like to mount it on EC2 instance. Get EFS link Check the EFS details and you should get a link which looks like below fs-06b8137f.efs.

Connect EC2 Server Without Keypair

You can enable keyless access on EC2 server that will allow you to connect to the server with username and password. Once you enable keyless access, you need not provide key file location under putty

How to Setup SSH on EC2 Instances

I have created two EC2 instances on AWS. I created a key pair for each of them. I downloaded the .pem private keys and converted them into .ppk format. I can connect to each of my ec2 instances using