Wednesday, May 1, 2024

How to generate an SSH Key Pair in Linux ?

 

Generate an SSH Key Pair in Linux 



[aaf@ip-10.0.0.0 ~]$

[aaf@ip-10.0.0.0 ~]$

[aaf@ip-10.0.0.0 ~]$

[aaf@ip-10.0.0.0 ~]$ ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/home/aaf/.ssh/id_rsa):

Created directory '/home/aaf/.ssh'.

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /home/aaf/.ssh/id_rsa

Your public key has been saved in /home/aaf/.ssh/id_rsa.pub

The key fingerprint is:

SHA256:mWZkHs4sTs3rue1E+9dQJXMN+imORLrDlh/IbJxNq4I aaf@ip-10.0.0.0.us-west-1.compute.internal

The key's randomart image is:

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

|              ...|

|             .o +|

|        + . .  +.|

|       X *   . ..|

|      o S + . o. |

|     o O @ = ..  |

|     .. # B .  o |

|    E .+ B o  . .|

|       .=o+ ..   |

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

[aaf@ip-10.0.0.0 ~]$

[aaf@ip-10.0.0.0 ~]$

[aaf@ip-10.0.0.0 ~]$



[aaf@ip-10.0.0.0 ~]$ cat .ssh/id_rsa.pub


ssh-rsa AAAAB3NzaC1yc4ttt546regehtrhrty2EAAAADAQrgregfdvfdhfgjfjfgABAAABgQCoqxYxIvbLOHN0bkqFMe+pFxVyWk4NvD0qQ0JPUADWCujJdzwZWZls7rYwUCVOdfdsfdz3pVaqqzubHQdDVvOMB3drUcyodgfu9D6aYL+oLIHWtbZPjYsadsadada243243249Mf14ewcCOxF0bA2MaPEcZzjXdfdsya0jVJGCg85gfhgfhgfh4VKEJoOqNX82jxTLo+HbHhmwc6xmFRQqpekSLWbdsfdsfds707aZ7kp/rghghgKkDg+p+9asfsdfdsIhGcbIKc8dfdsfds554HN3V6glirulUVbtD2d0ON/DasdasdafghgghodtRzurn1Wkl972vbA79APgfhgfhgfhhWdSwyjnNqIZ8uGDH5fc6CVqnASB7gT7idWccghghhghghgghgha8d8NCzu9d3PIjSfdgfdVaBKGYEgfhgfhrgfduCLny3KdRJcjEqq24IX96prIXF7Zwfgrfrgretgrdw2323r4343tefdtregdfgffdgghghgggghghghghY01eUbxxqqUDRQtFR9KLOx73TfDRBZ8PC8YydFyFbdEpTQyJixu5nu5dtGcDVtqBVMY+f01NzdfgfdgfdgfdwYwnAH9/8Zd7Jwu+f6KE0tAR6FDm01iuQQXvAvk75rNl2szN1c3+82xgabO79yQE2S/Tdnze6OoLpyVMPb5c/ujX+dBc= aaf@ip-10.0.0.0.us-west-1.compute.internal

Monday, April 29, 2024

How to Change Parallelism for a datapump job which is current running in oracle database

Change Parallelism for a datapump job which is current running in oracle database

SELECT owner_name, job_name, operation, job_mode, state 

FROM dba_datapump_jobs


impdp world_sample/world_sample attach=SYS_IMPORT_FULL_01


Import> status


Job: SYS_IMPORT_FULL_01

  Operation: IMPORT

  Mode: FULL

  State: EXECUTING

  Bytes Processed: 4,136,377,784

  Percent Done: 41

  Current Parallelism: 1

  Job Error Count: 0

  Job heartbeat: 1

  Dump File: /u01/app/oracle/admin/oracleiac1/dpdump/world_sample.dmp


Worker 1 Status:

  Instance ID: 1

  Instance name: oracleiac1

  Host name: oraclesrc-2

  Object start time: Monday, 29 April, 2024 15:06:57

  Object status at: Monday, 29 April, 2024 15:06:57

  Process Name: DW00

  State: EXECUTING

  Object Schema: WORLD_SAMPLE

  Object Name: NTC_MAP_WATER_AREA_SIDX

  Object Type: TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX

  Completed Objects: 5

  Worker Parallelism: 1


Import>



 Import> parallel=16


Wednesday, March 20, 2024

RDS Oracle Switchover Activity

 









Thursday, March 14, 2024

ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable.

 


RPM required to enable X11 display on Linux
---------------------------------------------


yum install  xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y