News

  1. Home
  2. All posts
All posts, Linux, Oracle, Unix by Team Ajara

DB Installation and Configuration best practices 1

DB Installation and Configuration best practices

1.Disable Transparent hugepages

Description:

Transparent HugePages memory is enabled by default with Red Hat Enterprise Linux , Red Hat Enterprise Linux , SUSE ,   and Oracle Linux  with earlier releases of Oracle Linux Unbreakable Enterprise Kernel 2 (UEK2) kernels. Transparent HugePages memory is disabled by default in UEK2 and later releases of UEK kernels.

Benefits:

Transparent HugePages can cause memory allocation
delays at runtime. To avoid performance issues, Oracle recommends that you disable Transparent HugePages on all Oracle Database servers. Oracle recommends that you instead use standard HugePages for enhanced performance.

Any Impact?

None

How to check

# cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
o/p [always] never
To disable
edit the /etc/default/grub file and then run the grub2-mkconfig command. And Restart the system

 

2.Group creation

Description:

Below are the group names.

oinstall,dba.oper,asmadmin–11g
oinstall,dba.oper,asmadmin,backupdba,dgdba,kmdba,asmdba,asmoper — 12cR1
oinstall,dba.oper,asmadmin,backupdba,dgdba,kmdba,asmdba,asmoper,racdba — 12cR2

Benefits:

Good to have all group set up during initial setup to maintain/administer with proper privileges.

Any Impact?

None

 

3.INVENTORY_LOCATION

Description:

Oracle software inventory

Benefits:

Maintaining proper inventory location resolves somany patch installation issues.
Useful for smooth silent /automatic installations

Any Impact?

None

 

4.Online updates

Description:

yum updates on Linux

Benefits:

No need to add prerequisite packages manually

Any Impact?

None

 

5.Additional tools and utilities

Description:

Mailx / mutt should be installed and verified during prerequisite packages check.

Benefits:

Useful for alerts configuration.

Any Impact:

None

 

6.Multiple OracleHomes

Description:

During Initial setup if there is no commonality among databases running on one database
server, it is good to have different OracleHomes for everey database on the server.

Benefits:

Patching and maintenance activities can be done independently.

Any Impact:

Occupies more space

 

See Also: