• Arun Kumar

Find physical locations of all Database files


show parameter spfile;

select name from v$controlfile;

select name from v$datafile;

select name from v$tempfile;

select member from v$logfile;

archive log list;


Recent Posts

See All

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 Co

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

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback