Connect OCI DB system using Console Connection

 

 

Step 1:

In your local machine, open terminal (Windows Powershell) and generate key pair

PS C:\Users\admin> ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (C:\Users\admin/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in C:\Users\admin/.ssh/id_rsa

Your public key has been saved in C:\Users\admin/.ssh/id_rsa.pub

The key fingerprint is:

SHA256:5Ioqw+KE2SJqgucRgjxXNhCpzZOBMgH4zSl/vYpD1Ec arunkumar k@doyenltp1980

The key's randomart image is:

+---[RSA 3072]----+

|=..oo            |

|+. o.   E        |

|.o+oo* ..        |

|o.o=B oo.        |

|oo.=.  oS        |

|.+o.o....        |

|B.o....  .       |

|X+.o..  .        |

|**o ....         |

+----[SHA256]-----+

PS C:\Users\admin>

 

Step 2:

Copy the contents of public key

PS C:\Users\admin> cat C:\Users\admin/.ssh/id_rsa.pub

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQDKYsAVXzjj1dmLevNjKdJkK7so6efkrlLq7Iy9jVOLcvsEOR4lFprAyXq+sQIl+xSzdlcEl7mFrbf+dzb2gzewWiGn6cj5zPRgQ6CVElhHizFFEfv9Nn2X4p3heeligRwnj4Alw80iqEaC3vf4a9b8npkQ05t0cRHJzX/Go/+NhLkwBA7XvfnrUY9iry05wLl1dzj+BseD3JuK/Zj8dx9mhCCurTh1bc72k1DMDSzlfpHifuFBLXylNPmEe/o3orHppakhbki7dYZTNuqS9jdXvZyWnA1oNYslCS773yULfFi82Dbdhpbp71B10jgKVt1t/AdoMLc7iT4UEDFUTcmIbNDp1raqtGb1LPgOl1G9WQhYzSLV3ciDtcMAYRTKmjljDkm/W9FMCZ2qZO3CCDkB4JchhLyhSzN51c+4a7nWG+xhXpI68wRJ5Q0xkpVmc84S6RUiybgLpyxblWgH5qAoHQm5OFiP89IqmcJt/U//VbavslvDlAzHUWM5tXhYb8E= username@desktop

PS C:\Users\admin>

Step 3:

 

Database service -> select the Database system -> consoleconnections-> click “Create console connection”

 

 

 

Step 4:

 

Add the public key you copied from step 2:

 

Step 5:

Once it is available after the below creating stage

 

Copy the ssh string and paste in notepad.

 

Step 6:

 

Switch to you local desktop and cd to .ssh directory.

 

Step 7:

Paste the SSH string and press enter and you will see the prompt asking for login.

 

ssh -o "HostKeyAlgorithms=+ssh-rsa" -o "PubkeyAcceptedAlgorithms=+ssh-rsa" -o ProxyCommand='ssh -W %h:%p -p 443 ocid1.instanceconsoleconnection.oc1.phx.anyhqljtwdx4egacfcdgmnzwb4itm3i3utnvuuwopeczdoyu6akmxgqev7aa@instance-console.us-phoenix-1.oci.oraclecloud.com' ocid1.instance.oc1.phx.anyhqljtwdx4egacejrj33wgjwhpcmn3xzafpv2htje66pa3ngtu5niy2wiq

 

 

Step 8:

Go back to OCI console and reboot the node and come back to you local machine and press enter. You will see the below message. As soon as you see this message, press up or down key to pause the reboot.

 

Step 9:

As soon as you see reboot message, press up or down key to pause the reboot. You will end up with below screen.

 

 

Step 10:

You may proceed with your troubleshooting.