Oracle | Linux | Cook Book

  Create all folders: mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ init parameters: *.audit_file_dest='/audit/file/path/' *.audit_sys_operations=TRUE *.audit_trail='DB_EXTENDED' *.compatible='compatible_parameter_as_per_your_env' *.control_files='/folder/path/goes/here/control01.ctl','/folder/path/goes/here/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='TGT_DB_NAME' *.db_recovery_file_dest_size=214748364800 *.diagnostic_dest='folder/path' *.global_names=FALSE *.local_listener='listener_name' *.log_archive_dest='/archived/redo/location' *.log_archive_format='%%ORACLE_SID%%_ARC%s_%R.%T' *.open_cursors=300 *.processes=2210 *.remote_login_passwordfile='EXCLUSIVE' *.sga_max_size=3G *.sga_target=2G *.pga_aggregate_target=1G *.undo_tablespace=...

  How to export[EXPDP] just Package: =================================== Create PARFILE ============== $ cat > new_tmp.par USERID="/ as sysdba" SCHEMAS=SPSE INCLUDE=PACKAGE:"IN ('SPSE_ER_BOND_REPORT')" COMPRESSION=ALL CLUSTER=N DUMPFILE=CFRAEXPORTS:tmp_new_expdp_10.dmp NOLOGFILE=Y Execute EXPDP using PARFILE =========================== $ expdp parfile=/exports1/cfrabackup/new_tmp.par Export: Release 11.2.0.4.0 - Production on Wed Sep 13 14:36:05 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYS"."SYS_EXPORT_SCHEMA_02":  /******** AS SYSDBA parfile=/exports1/cfrabackup/new_tmp.par Estimate in progress usin...

First Power on Redhat Enterprise Linux #    Click redhat 7 mapio #     Search for the text “rhgb quiet” and replace it with “init=/bin/bash” without quotes. #    Click ctrl+x #    mount | grep root #    mount -o remount,rw / #    mount | grep root #    passwd root #    touch /.autorelabel #    exec /sbin/init

open up cmd as admin and change directories to the folder with the setup.exe  run setup.exe /download configuration.xml it created a folder in the same directory with about 2gigs of data once done run  setup.exe /configure configuration.xml It ran the installer and finished. Volume Lisence :  Sign in to the VLSC. Select the Downloads and Keys tab. Find your Office 2019 product in the list and click its Key link. In the table beneath the name of the product,  find your product key in the column labeled Key.   Copy the product's individual key from this table and paste it into a program like Notepad or click Export all keys:  CSV just above the list of products to download a list of keys in comma-separated-values format (which can be opened with Excel).  Download the configuration files that you need from the table below by right-clicking the link for the file you need, selecting Save link as…,  and saving t...

1. SELinux Make SELinux as enforcing mode which is permanent [root@server6 ~]# vim /etc/sysconfig/selinux SELINUX=enforcing [root@server6 ~]# setenforce enforcing [root@server6 ~]# getenforce Enforcing 2.To create a new 500 MB physical partion To create a new 500 MB physical partition mounted on /common with xfs filesystem. Note because partition sizes are seldom exactly what is specified when you are created, anything with range of 475MB to 525 MB is acceptable . [root@server6 ~]# lsblk [root@server6 ~]# fdisk /dev/vdb Command (m for help): p Command (m for help): n Partition type:    p   primary (0 primary, 0 extended, 4 free)    e   extended Select (default p): p Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519): +500M Command (m for help): p  Device Boot      Start         End  ...

Initial setup: password break: restart system > press esc key     linux  > press e > fi ( line not enter) > linux16  /boot/vmliuz  > go to end of the line and enter below the command      rd.break console=tty1 >ctrl+X switch_root:# mount -o remount,rw /sysroot switch_root:# ch root /sysroot sh-4.2# passwd newpasswd: retypepasswd: sh-4.2# exit switch_root:#exit [root@server6 ~]# nmtui  > Edit a connection  >  system eth0  > Edit >Profile name:system eth0 > ipv4 configuration -->show(click)--Enter         ( IP address,gateway,dns,search domain give in EXAM u can enter below)         Addressed:172.25.20.11         Gateway  :172.25.254.254         DNS serv...

Initial setup Password break Edit a connection Activate a connection Set host name Firewall mask setup Create repo 1.  Selinux make enforcing 2.  Create a partition 500MB with xfs to be mounted /common 3.  User create with secondary group admin and no login 4. create a collaborative directory /common/admin with the following characterstics.Group ownership of /common/admin is admin the directory should be readable ,writeable and accessible to members of admin but not to any other users.(It is understood the root as access to all files and directories on the system).files created in /common/admin automatically have group ownership set to the admin group 5.  shedule a job.harry set the own job schedule on 12:40 at noon print /bin/echo on "hello world".natasha should not schedule cron jobs 6. Install the appropriate kernel update from http://classroom.example.com/rhel7.0/x86_64/errata/ The following criteria must also be met .the updated kerne...

This article presents how to configure physical standby database for Oracle Database 11G release 2 (11.2). It’s not focusing on transportation method, duplication method, protection modes nor extra functionality available for physical standbys. This presentation is based on the following article Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7). Architecture Final standby configuration is very simple: one host: oel7.dbaora.com – already configured with latest binaries Oracle Database 11G primary database: ORA11G listener LISTENER – already installed standby database: SORA11G – this article shows how to configure it standby configuration will work in default mode MAXIMUM PERFORMANCE standby_physical_11g_01 Configuration consists of the following steps: For primary database prepare space for archivelog and turn on archivelog mode switch to force logging on database level or tablespace level add standby redo logs prepare initialization parameters prepar...