APPSDBA Data Lake

 Log in SYSDBA  Check  Tempfile  status SQL> SELECT v.file#, t.file_name, v.status 2 FROM dba_temp_files t, v$tempfile v 3 WHERE t.file_id = v.file#; FILE# FILE_NAME STATUS ---------- ------------------------- ------- 1 /appsolworld/temp01.dbf ONLINE 2 /appsolworld/temp02.dbf ONLINE 3 /appsolworld/temp03.dbf ONLINE  Make it OFFLINE the tempfile that has to move SQL> ALTER DATABASE TEMPFILE '/appsolworld/temp01.dbf' OFFLINE; We should make offline the tempfile that has to move, if not then will get this error : SQL> ALTER DATABASE RENAME FILE '/appsolworld/temp01.dbf' TO '/u02/temp01.dbf'; ALTER DATABASE RENAME FILE '/appsolwolrd/temp01.dbf' TO '/u02/temp01.dbf' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01121: cannot rename database file 1026 - file is in use or recovery ORA-01110: data file 1026: '/appsolworld/...

 Overview ======== Here we look at how to write text into a file using the Linux cat command. The cat Command ================ Cat command's common usages is to print the content of a file onto the standard output stream. Other than that, the cat command allows us to write some texts into a file. The Syntax ========== Please look at the general syntax of the cat command: cat [OPTION] [FILE] Copy First, OPTION is a list of flags we can apply to modify the command’s printing behavior,  whereas FILE is a list of files we want the command to read. Making cat Read From stdin ========================== Let’s execute the cat command: cat Now try to enter some texts into the terminal: cat This is a appsolworld This is a appsolworld Once we are done, we can terminate the command by pressing CTRL+D. [demantra@dsiddem demantra]$ cat >> a appsolworld ^C [demantra@dsiddem demantra]$ cat a sfsfsfsd appsolworld [demantra@dsiddem demantra]$ cat > a this [demantra@dsiddem demantra]$ c...

  _FIX_CONTROL is a special hidden dynamic parameter which can be used to enable or disable certain bug fixes. This is typically used in the optimizer area to allow specific fixes to be turned on or off as some fixes can have a significant  effect on execution plans.  we are using the parameter _FIX_CONTROL to  enable or disable specific patches.  The syntax for using _FIX_CONTROL is: To enable: "_fix_control"='Bugno:ON'    (OR)   "_fix_control"="Bugno:1" To disable: "_fix_control"='Bugno:OFF'  (OR)   "_fix_control"="Bugno:0"   For _FIX_CONTROL to work, several conditions must be met:  The patch that is referenced must have the option to use _FIX_CONTROL.  Using _FIX_CONTROL can't be used to back out any patch.  The patch (usually an Optimizer patch)  has to be enabled to use the _FIX_CONTROL parameter. The patch must be installed and visible in the V$SYSTEM_FIX_CONTROL view.  To check this:  ...

Below steps to manually install HR schema in the database: However it can be done during DB creation through DBCA. 1. Log on to sqlplus as SYS AS SYSDBA: [oracle@shsdnbty01 admin]$ sqlplus "/as sysdba" SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 5 22:54:00 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 DB1                            READ WRITE NO SQL> alter session set c...

Only common users who have been commonly granted the ALTER PROFILE system privilege can alter or drop the mandatory profile, and only from the CDB root. We cannot remove a limit from the DEFAULT profile. Making a Password Unavailable: The following statement makes the password of the new_profile profile unavailable for reuse for 90 days:     ALTER PROFILE new_profile     LIMIT PASSWORD_REUSE_TIME 90     PASSWORD_REUSE_MAX UNLIMITED;     Setting Default Password Values:  The following statement defaults the PASSWORD_REUSE_TIME value of the app_user profile to its defined value in the DEFAULT profile:    ALTER PROFILE app_user     LIMIT PASSWORD_REUSE_TIME DEFAULT    PASSWORD_REUSE_MAX UNLIMITED;     Limiting Login Attempts and Password Lock Time:  The following statement alters profile app_user with FAILED_LOGIN_ATTEMPTS set to 5 and PASSWORD_LOCK_TIME set to 1:   ALTER PROFILE a...

  The following error messages indicate that xdpyinfo is not installed: Checking monitor: must be configured to display at least 256 colors Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed. The xdpyinfo program must be installed. Type the following command. yum install xorg-x11-utils-<version-number> If the program is already installed, check whether the oracle user has execute privileges. [oracle@ouzo ~]$ cd /usr/bin [oracle@ouzo bin]$ ls -al | grep xdpyinfo -rwxr-xr-x   1 root root      38112 Feb 23  2015 xdpyinfo If the oracle user does not have executable privileges, log in as root and execute this command: xhost +SI:localuser:oracle Log in as the oracle user and run the installer. ./runInstaller

  [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’.  Above error occurred while  19c (19.3) binary  installation on server Oracle enterprise Linux version version 8.1 or greater   Met INS-08101 when I installed Oracle database 19c on Oracle Linux 8 update   Unexpected error while executing the action at state: 'supportedOSCheck' Solution 1 To solve this error 'supportedOSCheck' can set environment variable  CV_ASSUME_DISTID , either temporarily or permanently. At runtime, we can export the variable $ export CV_ASSUME_DISTID=OEL8.1 Solution 2 Or we can uncomment the line containing the variable in the  CVU configuration file .  $ vi $ORACLE_HOME/cv/admin/cvu_config #CV_ASSUME_DISTID=OEL5 Just remove the leading # the line