DB Installation and Configuration best practices. 1.Separate oracle binaries owner Description: This can be considered if the databases are managed by different DBA groups Benefits: It provides more security. Any
DB Installation and Configuration best practices. 1. export NLS_DATE_FORMAT=”MM-DD-YYYY HH24:MI:SS” Description: Environment variable to get the date value upto seconds.This variable we can set in the .profile or .bash_profile. Benefits:
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 ,
How to connect the Database as sysdba in windows. DB Version: 19.3.0.0.0 Platform: Windows 11 Step1 Start the command prompt Step 2 Verify whether DB services are
Received Below error while creating database using DBCA 19c. Error: DIM-00019: create service error O/S-Error: (OS 5) Access is denied. [DBT-50000] Unable to check for available memory Actions
Standard input , output and error files in Unix and Linux. UNIX/LINUX treats the keyboard as the Standard Input File and VDU (Visual Display Unit for example putty screen) as
Step by step procedure to clone Oracle Home Source Home /u01/app/oracle/product/11.2.0/dbhome_1 Target Home /u01/app/oracle/product/11.2.0/dbhome_2 Steps to clone the Oracle Home Below steps can be executed Step 1. Pack the Source
df -k defunct issue on apps server causing connectivity problems Over view of the issue Issue on Application Server where “Apps is experiencing clocking” and it happened because of defunct
Script to get oracle database status UP or DOWN. This script verifies if the oratab file exists in /etc/ directory then the server is Linux or AIX and ORATAB variable
Command Prompts in Unix and Linux Operating systems. Command Prompt is a built-in feature in computers that allows users to interact with their operating system through a command-line interface.
