Friday, February 17, 2023

Checking swap space: 0 MB available, 150 MB required. Failed

Checking swap space: 0 MB available, 150 MB required.    Failed 


[oracle@oracle12c database]$ ./runInstaller

Starting Oracle Universal Installer...


Checking Temp space: must be greater than 500 MB.   Actual 1991 MB    Passed

Checking swap space: 0 MB available, 150 MB required.    Failed 

Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed


Some requirement checks failed. You must fulfill these requirements before


continuing with the installation,


User Selected: No



Solution :

Need to add swap space 




[root@oracle12c ~]# free -g
              total        used        free      shared  buff/cache   available
Mem:              7           0           2           0           4           6
Swap:             1           0           1
[root@oracle12c ~]#

Thursday, February 16, 2023

How to check the valid components loaded into the database (JVM,XML,XDK,Oracle Label Security......) ?

How to check the valid components loaded into the database ?


Login as privilege user and run below commands : 


SQL> select * from all_registry_banners;


BANNER                                                                           BANNER_FULL

-------------------------------------------------------------------------------- --------------------------------------------------------------------------------------

Oracle Database Catalog Views Release 19.0.0.0.0 - Production                    Oracle Database Catalog Views Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Packages and Types Release 19.0.0.0.0 - Production               Oracle Database Packages and Types Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle XML Database Release 19.0.0.0.0 - Production                              Oracle XML Database Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Workspace Manager Release 19.0.0.0.0 - Production                         Oracle Workspace Manager Release 19.0.0.0.0 - Production Version 19.3.0.0.0

JServer JAVA Virtual Machine Release 19.0.0.0.0 - Production                     JServer JAVA Virtual Machine Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle XDK Release 19.0.0.0.0 - Production                                       Oracle XDK Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Java Packages Release 19.0.0.0.0 - Production                    Oracle Database Java Packages Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Text Release 19.0.0.0.0 - Production                                      Oracle Text Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Multimedia Release 19.0.0.0.0 - Production                                Oracle Multimedia Release 19.0.0.0.0 - Production Version 19.3.0.0.0

OLAP Analytic Workspace Release 19.0.0.0.0 - Production                          OLAP Analytic Workspace Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle OLAP API Release 19.0.0.0.0 - Production                                  Oracle OLAP API Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Spatial Release 19.0.0.0.0 - Production                                          Spatial Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Label Security Release 19.0.0.0.0 - Production                            Oracle Label Security Release 19.0.0.0.0 - Production Version 19.3.0.0.0

Oracle Database Vault Release 19.0.0.0.0 - Production                            Oracle Database Vault Release 19.0.0.0.0 - Production Version 19.3.0.0.0



14 rows selected.


SQL>

Monday, February 13, 2023

Login using SSH into a new EC2 instance created from an custom AMI (image)

 Not able to login (SSH) to EC2 running Linux(Custom AMI)


Solution 

Login as ec2-user 

sudo su - root 


first use source *.pem key to login ec2 instance launch from custom AMI using ec2-user 

enable PasswordAuthentication to yes


vi /etc/ssh/sshd_config


PasswordAuthentication yes


systemctl restart sshd



then login with root user with same password as source. 

Complex Oracle 19c to PostgreSQL 15 Database Migration

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...