STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH > VIRTUAL NETWORK GATEWAY> SELECT VIRTUAL NETWORK GATEWAY >VPN> >ROUTE BASED >SKU-SPEED( STANDARD -) VPN-GW1 > SELECT VIRTUAL NETWORK ( CREATED IN STEP 1 ) > PUBLIC IP- CREATE NEW – NAME-GW-PIP>FINISH . > WAIT … Read more
There is no excerpt because this is a protected post.
As an “Oracle DBA ” normally interviewer ask about ORA-01555 snapshot too old error. What is Undo? Oracle Database maintain information that is used to roll back, or undo. Such information consists of records of the actions of transactions, primarily before they are committed. These records are collectively referred to as undo. Undo records are used to: 1. Roll … Read more
Source Database Name is PRODDB Target (duplicate) Database name is MYDB Source Host Name : server1.localdomain Target Host Name : server2.localdomain Put Database in archivelog mode. Step 1: Configure listener.ora and tnsnames.ora files Step 2: Create pfile for target database from Source database Step 3: Create password file Step 4: SCP passwordfile & pfile to target … Read more
Check the status of ASM instance . Check the database version and its status. Check ASM disk name available from the instance which we created earlier If you are using a spfile, take a backup of spfile using rman to restore it to ASM disk. Now restore the spfile from the backup to ASM disk as … Read more
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile. Suppose the sql id is – 72nggna3640qk 1. Create Tuning Task 2. Execute Tuning task: 3. Tuning … Read more
There is no excerpt because this is a protected post.
vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh To save the script and change its permissions, follow these steps:1. Save the script by typing `:wq` in the editor.2. Change the file permissions using the `chmod` command. Add this entry to the crontab for the oracle user:
Add the Target Database TNS entry to the Source’s tnsnames.ora file(s) (all of them if it’s a clustered Source) Set the log_archive_dest_<#> parameter on the Source Database, as Oracle: Then enable the log_archive_dest_state_ parameter on the Source Database, as Oracle: Set fal/standby_file_management parameters on the Target Database, as Oracle: Using the db_unique_name, set log_archive_config parameter … Read more