Environment

Oracle VM Server 3.4 installed on Cisco UCS blade

Oracle VM Manager 3.4

Problem Summary

1) This server has the same IP address as another server. Please correct that on the servers. Or,
2 ( Read more... )

Installation
Following instructions from here https://www.postgresql.org/download/linux/redhat/:
Select version: 9.6 (I needed 9.6 because of my specific product requirements)
Select platform: RHEL7
Install the repository RPM: yum install Read more... )

Get-NetConnectionProfile

Open Windows PowerShell and type “Get-NetConnectionProfile”
PS C:\Users\Administrator> Get-NetConnectionProfile

Name : Network
InterfaceAlias : Ethernet
InterfaceIndex : 12
NetworkCategory : Public
IPv4Connectivity : LocalNetwork
IPv6Connectivity : NoTraffic

We need just InterfaceIndex number. It’s usually ( Read more... )

Get-NetConnectionProfile

Open Windows PowerShell and type “Get-NetConnectionProfile”
PS C:\Users\Administrator> Get-NetConnectionProfile

Name : Network
InterfaceAlias : Ethernet
InterfaceIndex : 12
NetworkCategory : Public
IPv4Connectivity : LocalNetwork
IPv6Connectivity : NoTraffic

We need just InterfaceIndex number. It’s usually ( Read more... )

SELECT table_name AS table_name, engine, ROUND(data_length/1024/1024,2) AS total_size_mb, table_rows FROM information_schema.tables WHERE table_schema=DATABASE(); //or just table_schema='table_name';
Originally published at blog.trichev.com. You can comment here or there.

SELECT table_name AS table_name, engine, ROUND(data_length/1024/1024,2) AS total_size_mb, table_rows FROM information_schema.tables WHERE table_schema=DATABASE(); //or just table_schema='table_name';
Originally published at blog.trichev.com. You can comment here or there.

tar -cvfp file.tar dir
tar -xvfp file.tar
-p Restore the named files to their original modes,and ACLs if applicable,ignoring the present umask

Originally published at blog.trichev.com. You can comment here or there.

tar -cvfp file.tar dir
tar -xvfp file.tar
-p Restore the named files to their original modes,and ACLs if applicable,ignoring the present umask

Originally published at blog.trichev.com. You can comment here or there.

Kernel Parameters:
Parameter Minimum Value File semmsl 250 /proc/sys/kernel/sem semopm 100 semmni 128 semm 32000 shmall 2097152 /proc/sys/kernel/shmall shmmax Minimum: 536870912;

Maximum: A value that is 1 byte less than the physical memory

Recommended: More than half the physical memory

See My Oracle Support Note 567506.1 for ( Read more... )

Kernel Parameters:
Parameter Minimum Value File semmsl 250 /proc/sys/kernel/sem semopm 100 semmni 128 semm 32000 shmall 2097152 /proc/sys/kernel/shmall shmmax Minimum: 536870912;

Maximum: A value that is 1 byte less than the physical memory

Recommended: More than half the physical memory

See My Oracle Support Note 567506.1 for ( Read more... )