Tools Installation in alma linux

Laravel xampp install pre requisite
lavavel 5.6(qrius,boneandall) prerequisite:
PHP >= 7.1.3
OpenSSL PHP Extension
PDO PHP Extension
Mbstring PHP Extension
Tokenizer PHP Extension
XML PHP Extension
Ctype PHP Extension
JSON PHP Extension
BCMath PHP Extension
lavavel 7.0(viokart) prerequisite:
PHP >= 7.2.5
BCMath PHP Extension
Ctype PHP Extension
Fileinfo PHP extension
JSON PHP Extension
Mbstring PHP Extension
OpenSSL PHP Extension
PDO PHP Extension
Tokenizer PHP Extension
XML PHP Extension
Grail,Spring Boot,Tomcat install pre requisite
Grails 2.5 prerequisite:
Java Development Kit (JDK) >= 6

Grails 3.X prerequisite:
Java Development Kit (JDK) >= 8

Grails 6.0 prerequisite:
Java Development Kit (JDK) >= 11

tomcat 8 prerequisite:
Java Development Kit (JDK) >= 7

tomcat 9 prerequisite:
Java Development Kit (JDK) >= 8

Spring 2.7 prerequisite:
Java Development Kit (JDK) >= 8 and <= 20

Spring 3.0 prerequisite:
Java Development Kit (JDK) >= 17

Yum command list

How to Install phpMyAdmin on AlmaLinux

Before installing PHPMyAdmin, you need to have the following requisite packages installed.

About Httpd for Fedora/CentOS/Red Hat Enterprise Linux(Server version: Apache/2.4.37 (AlmaLinux) )

Install PHP(7.2)

Install PHP(7.4.33)-- best

Install Mysql Server

How to set mysql server password

how to reset mysql password

Laravel Project problem: storage access denied

Enable htaccess in httpd server

go to /etc/httpd/conf/httpd.conf => using editor change as follows

# Further relax access to the default document root:
<Directory "/var/www/html">
    # Possible values for the Options directive are "None", "All",
    # or any combination of:
    #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    # The Options directive is both complicated and important.  Please see
    # for more information.
    Options Indexes FollowSymLinks

    # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    #   Options FileInfo AuthConfig Limit
    #AllowOverride None
    AllowOverride All

    # Controls who can get stuff from this server.
    Require all granted

How to install apache tomcat
Oracle 19c install on alma linux pre requisite
Server Display Cards:At least 1024 x 768 display resolution, which Oracle Universal Installer requires.
Minimum RAM:At least 1 GB RAM for Oracle Database installations. 2 GB RAM recommended.
hard disk space:

How to install oracle 19c database on alma linux using rpm ********************************

Step One:

Step Two:

Step Three:

install oracle using rpm tutorial 1

install oracle using rpm tutorial 2

How to oracle service start and stop:
>logisn as sysdba

Now start listener service:
root>lsnrctl start

listener support no service.
Now we are go to check listener status:

root>tnsping ORCLCDB        -- where orcl is the SERVICE_NAME name
root>tnsping ORCL        -- where orcl is the SERVICE_NAME name

Now we are going to shutdown oracle service. first login as sysdba
>logisn as sysdba
sql>shutdown immediate
How to create pluggable database
su - oracle -- will show /opt/oracle path
. oraenv  -- to set oracle SID 
sqlplus /nolog
conn sys/sys as sysdba
show pdbs

alter session set container=PDB$SEED;
select FILE_NAME from dba_data_files;
alter pluggable database PDB$SEED open force;
select open_mode from v$pdbs where name = 'PDB$SEED';
#re connect again 

CREATE PLUGGABLE DATABASE commom_pdb ADMIN USER commomadmin IDENTIFIED BY commomadmin FILE_NAME_CONVERT=('/opt/oracle/oradata/ORCLCDB/pdbseed','/opt/oracle/oradata/ORCLCDB/common_pdb/commonuser');  -- ok
How to create table space dalerp

CREATE TABLESPACE dalerp DATAFILE '/opt/oracle/oradata/ORCLCDB/common_pdb/dalerp_data.DBF' SIZE 2000M;


mkdir -p $ORACLE_BASE/network

How to create schema:
alter session set container=COMMOM_PDB;
create user oms_test identified by oms_test
grant all privileges to oms_test;
conn oms_test/oms_test@commom_pdb;  -- ok

CREATE DIRECTORY export_impport as '/opt/oracle/admin/ORCLCDB/dpdump/';  -- ok

GRANT EXP_FULL_DATABASE to oms_test;  -- ok

How to import oracle database
impdp schema/password@pluggable_container directory=export_impport dumpfile=LGSPWEB_071216.DMP logfile=LGSPWEB_071216.log;  -- ok