Pages

Tuesday, January 31, 2023

OCI Cloud - Top 10 things to consider when deploying applications.

Deploying applications on Oracle Cloud Infrastructure (OCI) involves several best practices to ensure efficiency, scalability, security, and reliability. Here are some key practices for OCI cloud deployments:

1. Well-Architected Framework:

Reliability, Performance, Security: Follow OCI's well-architected framework principles to design and implement your solutions for reliability, performance, and security.

2. Resource Planning and Optimization:

Right Sizing: Properly size compute, storage, and networking resources to meet application demands while avoiding unnecessary costs.

Utilize Autoscaling: Configure auto-scaling policies to dynamically adjust resources based on traffic patterns.

Cost Management: Leverage Oracle's tools for cost management and monitoring to optimize expenses.

3. Security Best Practices:

Identity and Access Management (IAM): Implement least privilege access control, utilize IAM policies, and regularly review permissions.

Network Security: Use Virtual Cloud Networks (VCNs), security lists, and security groups to control network traffic.

Data Encryption: Encrypt data at rest and in transit using encryption services provided by OCI.

4. High Availability and Fault Tolerance:

Multi-Availability Domains (ADs) and Regions: Deploy across multiple availability domains and regions to ensure high availability and disaster recovery.

Load Balancing: Use Load Balancers to distribute traffic across multiple instances for fault tolerance.

5. Automated Deployments:

Infrastructure as Code (IaC): Use tools like Terraform or Oracle's Resource Manager to define and provision infrastructure, ensuring consistency and repeatability.

CI/CD Pipelines: Implement continuous integration and deployment pipelines for automated testing and deployment.

6. Monitoring and Logging:

Monitoring Services: Use OCI Monitoring and Notifications to set up alerts and monitor resources, enabling proactive issue resolution.

Logging: Centralize logs using OCI Logging to facilitate troubleshooting and security auditing.

7. Backup and Disaster Recovery:

Backup Strategies: Implement regular backups of critical data and ensure their integrity.

Disaster Recovery Plans: Have well-defined plans for disaster recovery, including backup restoration and failover procedures.

8. Compliance and Governance:

Compliance Standards: Adhere to relevant compliance standards (e.g., GDPR, HIPAA) and regularly audit configurations.

Governance Policies: Establish governance policies for resource tagging, naming conventions, and access controls.

9. Performance Optimization:

Content Delivery Networks (CDN): Utilize OCI's CDN for caching and delivering content closer to end-users, enhancing performance.

Optimize Database Performance: Utilize OCI's database tuning and optimization features for improved performance.

10. Documentation and Training:

Documentation: Maintain detailed documentation of configurations, deployments, and best practices.

Training and Knowledge Sharing: Continuously educate and train teams on new features, best practices, and security measures within OCI.

Implementing these best practices will help in creating robust, secure, and efficient deployments on Oracle Cloud Infrastructure. Tailor these practices based on specific application requirements and stay updated with OCI's latest features and improvements for continual enhancement. 

Saturday, November 20, 2021

Exadata DBMCLI - Useful Commands for Database Admin

Exadata  DBMCLI  - Useful Commands for Database Admin


DBMCLI is the database machine command line interface to administrate exadata database server.It runs on each database machine. Importent Commands DBMCLI> list DBSERVER attributes name,coreCount,makeModel,id exadb_adm01 48/48 Oracle Corporation ORACLE SERVER X8-2 2112XLB044 DBMCLI> LIST PHYSICALDISK 252:0 L91ZYC normal 252:1 L923C2 normal 252:2 L92C25 normal 252:3 L92CK4 normal DBMCLI> Commands Reference: DBMCLI> help HELP [topic] Available Topics: ALTER ALTER ALERTHISTORY ALTER DBSERVER ALTER IBPORT ALTER PHYSICALDISK ALTER THRESHOLD ALTER USER CREATE CREATE DBSERVER CREATE DIAGPACK CREATE ROLE CREATE THRESHOLD CREATE USER DESCRIBE DROP DROP ALERTHISTORY DROP DBSERVER DROP PHYSICALDISK DROP ROLE DROP THRESHOLD DROP USER GRANT GRANT PRIVILEGE GRANT ROLE LIST LIST ALERTDEFINITION LIST ALERTHISTORY LIST DBSERVER LIST DIAGPACK LIST IBPORT LIST LUN LIST METRICCURRENT LIST METRICDEFINITION LIST METRICHISTORY LIST PHYSICALDISK LIST ROLE LIST THRESHOLD LIST USER REVOKE REVOKE PRIVILEGE REVOKE ROLE SET SPOOL START

Sunday, June 20, 2021

Exadata DCLI Utility for Database Engineer

 Exadata DCLI Utility for Database Engineer


DCLI:


 Distributed command line utility(dcli) provides an option to execute the monitoring and administration commands on multiple servers simultaneously.In exadata database  machine , you may need to create the griddisks on all the exadata storage cells frequently. Each time , you need to login to all the storage cells and create the griddisk manually.But dcli will make our life easier once you configured  the all the storage cells on any one of the storage cell or on the database node. In this article ,we will see how to configure the dcli on multiple storage cells.


# dcli [Options] [Command]



Options



Option Use

-c CELLNAMES Executes the commands only on those cells (Storage Servers).

-g GROUPFILE Executes the command on the cells mentioned in the file.

-l USERNAME The default user is celladmin; but we can use any other user to use for remote ssh execution. Make sure the user has ssh equivalency across all the cells where you run this command

-n This shows an abbreviated output instead of a long output from each command execution

-r REGEXP Suppresses the output that matches the regular expression

-t Displays the target cells where the command will run

-x script_name The script will be executed on the target cells

-k Establishes the ssh user equivalency

-f FILENAE Copies the files to the other cells but does not execute them. It's useful for copying files and executing them later.

-d DESTFILE Destination directory or file

-s SSHOPTIONS String of options passed through to ssh

--scp=SCPOPTIONS String of options passed through to scp if different  from sshoptions

--serial Serialize execution over the cells

--unkey Drop keys from target cell's authorized_keys file

-v Verbose, print extra messages to stdout

--vmstat=VMSTATOPS vmstat command options

--version Show dcli version number

-h, --help Show help message


Importent Commands:


Command to find the image version of all db nodes

[root@exadb-adm01 ~]# dcli -l root -g /root/dbs_group imageinfo|grep "Image version"


exadb-adm01: Image version: 22.1.8.0.0.230211


exadb-adm02: Image version: 22.1.8.0.0.230211


exadb-admnp01: Image version: 22.1.8.0.0.230211


exadb-admnp02: Image version: 22.1.8.0.0.230211


exadb-admnp03: Image version: 22.1.8.0.0.230211


[root@exadb-adm01 ~]# 



List celldisks in all Cell servers:


[root@exadbcel-adm01 ~]#  dcli -g ~/cell_group -l root "cellcli -e list celldisk attributes name,status"


exadbcel-adm01: CD_00_ash_xd08cel_adm01 normal


exadbcel-adm01: CD_01_ash_xd08cel_adm01 normal


exadbcel-adm01: CD_02_ash_xd08cel_adm01 normal


exadbcel-adm01: CD_03_ash_xd08cel_adm01 normal


exadbcel-adm01: CD_04_ash_xd08cel_adm01 normal


.


.


.



List all Harddisks with name, freespace attributes


[root@exadb-adm01 ~]# dcli -g ~/cell_group_prod -l root "cellcli -e list celldisk attributes name,freespace where disktype=harddisk"


exadbcel-adm01: CD_00_exdbcel_adm01 1.447296142578125T


exadbcel-adm01: CD_01_exadbcel_adm01 1.447296142578125T


exadbcel-adm01: CD_02_exadacel_adm01 1.447296142578125T


exadbcel-adm01: CD_03_exadbcel_adm01 1.447296142578125T


.

.

.

.



[root@exadb-adm01 ~]#

Thursday, May 20, 2021

How to Resizing EXAVMIMAGES File System

 How to Resizing EXAVMIMAGES File System

The objective is to expand the size of the /EXAVMIMAGES file system using the provided instructions:

  1. Check the current size of the /EXAVMIMAGES file system:

# df -h /EXAVMIMAGES

  1. Verify the volume group (VG) details:

# vgdisplay -s

  1. Extend the logical volume (LV) named LVDbExaVMImages with 15% free space within the VGExaDb volume group:

# lvextend -l +15%FREE /dev/VGExaDb/LVDbExaVMImages

  1. Expand the XFS file system on /EXAVMIMAGES to accommodate the newly allocated space:

# xfs_growfs /EXAVMIMAGES

  1. Confirm the updated size of the /EXAVMIMAGES file system:

# df -h /EXAVMIMAGES

Note: The procedure aims to increase the size of the /EXAVMIMAGES file system by extending the logical volume and growing the XFS file system accordingly.

Wednesday, November 8, 2017

Oracle EBS JDK7 Upgrade - Step By Step

 


Oracle EBS JDK7 Upgrade - Step By Step 


EBS  Applications JDK7 Upgrade:


Using the Latest JDK 7.0 Update with Oracle E-Business Suite Release 12.2 (Doc ID 1530033.1)

Detailed steps for JDK upgrade - /extmount/security_patches/Jan17Patches/EBS/JDK7


1.Rename below folders


$ cd $COMMON_TOP/util/

$ mv jdk32 jdk32_pre_upgrade

$ mv jdk64 jdk64_pre_upgrade

2. Copy JDK7 From /extmount to $COMMON_TOP/util directory


 $ cd /opt/app/EBSPRD/fs1/EBSapps/comn/util

 $ cp -RH /extmount/security_patches/Jan17Patches/EBS/JDK7/jdk64 .

 $ cp -RH /extmount/security_patches/Jan17Patches/EBS/JDK7/jdk32 .

 $ chmod -R +w jdk*

$ ls -ltr $FMW_HOME/Oracle_EBS-app1/jdk

lrwxrwxrwx 1 applmgr appdba 43 Aug 13  2015 /opt/app/EBSPRD/fs1/FMW_Home/Oracle_EBS-app1/jdk -> /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk64

4. Copy the Albany Fonts Required for Invoice.

$ cp /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk64_pre_upgrade/jre/lib/fonts/ALB* /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk64/jre/lib/fonts


$ls -ltr /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk64/jre/lib/fonts/ALB*

$cp /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk32_pre_upgrade/jre/lib/fonts/ALB* /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk32/jre/lib/fonts


$ls -ltr /opt/app/EBSPRD/fs1/EBSapps/comn/util/jdk32/jre/lib/fonts/ALB*


3. Update jdk in $ORACLE_HOME (Forms 10.1.2)


 $ cd $ORACLE_HOME

 $ mv jdk jdk_pre_upgrade

 $ cp -RH /extmount/security_patches/Jan17Patches/EBS/JDK7/jdk32 jdk

4. Rebuild Forms and Reports Executables

$ cd $ORACLE_HOME/forms/lib

$ make -f ins_forms.mk sharedlib install

$ cd $ORACLE_HOME/reports/lib

$ make -f ins_reports.mk install



5. Verifications -

$ $ADJVAPRG -version

$ echo $CLASSPATH

$ $AFJVAPRG -version

$ echo $AF_CLASSPATH

EBS Database JRE7 Upgrade:


1) Login to Database Node Database nodes and perform the below

Copy


$ cd $ORACLE_HOME/appsutil

$ mv jre jre_pre_upgrade

$ tar -xvzf /extmount_new/security_patches/Jan17Patches/EBS/JDK7/JRE7/jre-7u121-linux-x64.tar.gz

$ mv jre1.7.0_121 jre

$ cd $ORACLE_HOME/appsutil/jre/bin

$ ./java -version