KTEXPERTS – Page 69 – KNOWLEDGE SHARING PLATFORM

Oracle : Setting up Oramenu for Databases

9 years ago by Vinod SiramOracle DB Admin

Use this script to setup oramenu:

#!/bin/bash
# set -x
# Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017 
# 
# THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab.
# It will simplify the way you set environment varaibles.
#
# Get the list of SID's from /etc/oratab file
# Draw the menu
# let user select the option
# set those environment variables.
# 

if [ -f /etc/oratab ]
then
echo "Please select your SID to set its environment variables"
select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'`
do
if [ `echo "X"${sid}` == "X" ]
then
echo "Invalid selection. Select numbers of respectice SID"
break
else
. /usr/local/bin/oraenv <<< $sid >/dev/null
break
fi
done
else
echo "Oracle is not installed on this server"
fi

#!/bin/bash

# set -x

# Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017

# THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab.

# It will simplify the way you set environment varaibles.

# Get the list of SID's from /etc/oratab file

# Draw the menu

# let user select the option

# set those environment variables.

if [ -f /etc/oratab ]

then

echo "Please select your SID to set its environment variables"

select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'`

if [ `echo "X"${sid}` == "X" ]

then

echo "Invalid selection. Select numbers of respectice SID"

break

else

. /usr/local/bin/oraenv <<< $sid >/dev/null

break

done

else

echo "Oracle is not installed on this server"

~$ chmod +x oramenu ~$ sudo su – root ~# cp /home/oracle/oramenu /usr/local/bin/ ~# exit logout ~$ . oramenu Or Example : $ chmod +x oramenu oracle@server123:ORCL1:/home/oracle > $ . oramenu Please select your SID to… Read More

Oracle_Apps: Performance issue with particular form

9 years ago by NamashivayaOracle Apps DBA

Performance issue with particular form in EBS: Its common issue which reports by end user that they have a performance problem with particular form or form is slow responding Have the user show DBA exactly which form runs slow by select Help->Diagnostics->Trace and click in the… Read More

Oracle : Steps for Update Statement Process in SGA

9 years ago by DayakerOracle Architecture

Steps for Update Statement Process in SGA: update processes >update emp set sal=5000 where empno=7903; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3… Read More

Oracle : Steps for Select Statement Process in SGA

9 years ago by DayakerOracle Architecture

Steps for Select Statement Process in SGA : >SELECT * FROM EMP; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3 server processes to… Read More

Oracle : Important Queries for Data Pump

9 years ago by Vinod SiramOracle Datapump (Export & Imports)

—– Create user for using EXPDP/IMPDP : create user admin identified by PW; grant connect,resource to admin; grant unlimited tablespace to admin; grant create any view to admin; create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin; grant EXP_FULL_DATABASE to… Read More

Oracle : Important Queries for Checking Temp Usage.

9 years ago by Vinod SiramOracle DB Admin

Checking Default_Temp_Tablespace : col property_name for a35 col property_value for a20 col description for a45 set linesize 300 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; Temp tablespace usage : set linesize 300 SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,… Read More

Oracle : Important Queries for RMAN

9 years ago by Vinod SiramOracle DB Admin

RMAN Backup Size : set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : &current_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More

SQL Server – Issue to view Alwayson Health Events

9 years ago by Pawana PaulSQL Server - Production Support

SQL Server – Issue to view Alwayson Health Events If you find AlwaysOn Health Events grayed out and you are not able to see extended events. Please find below screenshot. When you connect Dashboard of AlwaysOn, you will find View AlwaysOn Health Events grayed out… Read More

Script to copy one particular database role from one SQL server to another

9 years ago by Pawana PaulSQL Server - Production Support

Below Script is to copy one particular database role from one SQL server to another declare @RoleName varchar(50) = ‘Database_Role_Name’ declare @Script varchar(max) = ‘CREATE ROLE ‘ + @RoleName + char(13) select @script = @script + ‘GRANT ‘ + prm.permission_name + ‘ ON ‘ +… Read More

Oracle Golden Gate : Installing GG in AWS (Table replication in same DB)

9 years ago by Vinod SiramGolden Gate

Dear Readers, In this article we will see Installing GG in AWS (Table replication in same DB). Step 1 : Download GG software Step 2 : check for xclock in AWS server. [ec2-user@ip-172-31-21-177 tmp]$ su – oracle Password: Last login: Sat Dec 24 12:03:29… Read More