Enable Trace and take Tkprof
Posted by : Unknown This Post will demonstrate to enabling the trace and take tkprof Step 1 : Check Request ID from Find Concurrent request screen (In my case…
Read MoreSteps to Modify Scan listener port number
Posted by : Selvakumar Raja This Post will demonstrate the Steps to Modify Scan listener port . Due to security reasons some of environment require using a different port…
Read MoreSGA Resizing history
SGA resizing history Summary You can find all the resizing history of the SGA by querying the view V$SGA_RESIZE_OPS. As you know if you have set the parameter sga_target then…
Read MoreSteps to create ORACLE_HOME after copying oracle binaries from source to destination.
WE ARE GOING TO COPY THE ORACLE BINARIES FORM SOURCE TO DESTINATION. Step 1 : Tar the ORACLE_HOME in the source instance. tar -cvf /DUMP_TABLE/backup/11203_PROD.tar /prddb01/oracle/PROD/db/tech_st/11.2.0.3/ Step 2 : Scp…
Read MoreImport fails with ORA-39126,ORA-06512,ORA-01403
WE ARE GOING TO SEE THE IMPORT FAILURE with ORA-39126,ORA-06512,ORA-01403 . Cause: The issue happen when we migrate using export from 11gR2 windows and import it in 12cR2 Linux server.…
Read MoreQuery to find audit information about dropped users
Find audit information about dropped users NOTE : “DROP USER” is audited by default from Oracle 12c onwards. Use the below query to take information if you have not turned…
Read MoreORA-01270: RENAME operation is not allowed if STANDBY_FILE_MANAGEMENT is auto
INTRODUCTION : This post describes renaming a datafile in standby. NOTE : In Primary database renaming a Datafile will not be reflected in Standby database even the STANDBY_FILE_MANAGEMENT=auto , So…
Read MoreExtract a particular file from an zipped archive file to a given directory.
Unzip particular file from an zip file NOTE : Sometimes we would know the archive file present in zip folder and would like to unzip only that particular file. The…
Read MoreQuery to check when the profile was updated
To check when the profile was updated. QUERY : select p.profile_option_name SHORT_NAME, n.user_profile_option_name “PROFILE NAME”, decode(v.level_id, 10001, ‘Site’, 10002, ‘Application’, 10003, ‘Responsibility’, 10004, ‘User’, 10005, ‘Server’, 10007, ‘SERVRESP’, ‘UnDef’) LEVEL_SET,…
Read MoreAPEX INSTALLATION WITH HTTP(OHS) SERVER
APEX INSTALLATION WITH HTTP(OHS) SERVER Description: 1.We have to install first apex in our database after we have to install http(OHS) server: Apex Installation Unzip Apex files in specific PATH.…
Read More