KTEXPERTS – Page 17 – KNOWLEDGE SHARING PLATFORM

Performance Tuning Articles

3 years ago by KTEXPERTS TEAMPerformance Tuning

Dear Readers, Please check the below articles to get good knowledge on Performance Tuning. SNO Article Name Article Link 1 Autonomous Health Framework https://www.ktexperts.com/autonomous-health-framework/ 2 Oracle: Free Buffer Wait https://www.ktexperts.com/oracle-free-buffer-wait/ 3 Internal mechanism of Buffer Cache https://www.ktexperts.com/internal-mechanism-of-buffer-cache/ 4 Performance Investigation(Database / SQL) https://www.ktexperts.com/performance-investigation-database-sql/ 5 Oracle:… Read More

Create and configure a virtual cloud network(VCN) by using VCN Wizard

4 years ago by Venkata Sai PavanOracle DB Admin

Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN) by using VCN Wizard. By using this option VCN will create with below-added resources by default Includes: ➸ VCN ➸ Public subnet ➸ Private subnet ➸ Internet gateway (IG) ➸… Read More

Table Restore Depends On Time in Oracle

4 years ago by Venkata Sai PavanOracle DB Admin

Dear Readers, This article will see the following Table Restore Depends On Time in Oracle. We receive requests from the requester stating that they have lost data of some tables and want us to restore it. As it is a time-consuming method to restore the… Read More

Change DBID in Oracle

4 years ago by Venkata Sai PavanOracle DB Admin

Dear Readers, This article will see the following Change DBID in Oracle. NID is the tool that is used to change DBID or database name. Before changing the NID safer side take the backup of the database, and related files dependent on DB.

[root@detedb1 ~]$ ora_env
List of instances oracle : { test1 dbdr11 dbcs16 }
   Environnement oracle
  ~~~~~~~~~~~~~~~~~~~~
    ORACLE_SID ...... : dbcs16
    ORACLE_HOME ..... : /u01/app/oracle/11.2.0.3/db_home
    TNS_ADMIN ....... : /u01/app/oracle/product/11.2.0.3/db_home/network/tnsadmin
    NLS_LANG ........ : american_america.AL32UTF8
    listener...: LISTENER_DBCS

[root@detedb1 ~]$ ora_env

List of instances oracle : { test1 dbdr11 dbcs16 }

Environnement oracle

~~~~~~~~~~~~~~~~~~~~

ORACLE_SID ...... : dbcs16

ORACLE_HOME ..... : /u01/app/oracle/11.2.0.3/db_home

TNS_ADMIN ....... : /u01/app/oracle/product/11.2.0.3/db_home/network/tnsadmin

NLS_LANG ........ : american_america.AL32UTF8

listener...: LISTENER_DBCS

[root@detedb1 ~]$ nid TARGET=SYS

DBNEWID: Release 11.2.0.3.0 - Production on Thu Feb 4 19:23:28 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Password:
Connected to database DBCS16 (DBID=3216085472)

Connected to server version 11.2.0

Control Files in database:
    /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl
   /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl

Change database ID of database DBCS16? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 3216085472 to 2519222153
    Control File     /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - modified
    Control File     /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - modified
    Datafile File     /u01/app/oracle/11.2.0.3/db_home / dbcs16 /system_01.db - dbid changed
    Datafile File     /u01/app/oracle/11.2.0.3/db_home / dbcs16/ sysaux_01.db - dbid changed
    Datafile File     /u01/app/oracle/11.2.0.3/db_home / dbcs16 /undo1_01.db - dbid changed
    Datafile File     /u01/app/oracle/11.2.0.3/db_home / dbcs16 /ttools_01.db - dbid changed
    Datafile           /u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_d1_01.db - dbid changed
    Datafile 	/u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_i1_01.db - dbid changed
    Datafile 	/u01/app/oracle/11.2.0.3/db_home / dbcs16 /temp1_01.db - dbid changed
    Control File 	/u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - dbid changed
    Control File 	/u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - dbid changed
    Instance shut down

Database ID for database DBCS16 changed to 2519222153.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.

[root@detedb1 ~]$ nid TARGET=SYS

DBNEWID: Release 11.2.0.3.0 - Production on Thu Feb 4 19:23:28 2019

Password:

Connected to database DBCS16 (DBID=3216085472)

Connected to server version 11.2.0

Control Files in database:

/u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl

/u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl

Change database ID of database DBCS16? (Y/[N]) => Y

Proceeding with operation

Changing database ID from 3216085472 to 2519222153

Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - modified

Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - modified

Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /system_01.db - dbid changed

Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16/ sysaux_01.db - dbid changed

Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /undo1_01.db - dbid changed

Datafile File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /ttools_01.db - dbid changed

Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_d1_01.db - dbid changed

Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /sbg_i1_01.db - dbid changed

Datafile /u01/app/oracle/11.2.0.3/db_home / dbcs16 /temp1_01.db - dbid changed

Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control01.ctl - dbid changed

Control File /u01/app/oracle/11.2.0.3/db_home / dbcs16 /control02.ctl - dbid changed

Instance shut down

Database ID for database DBCS16 changed to 2519222153.

All previous backups and archived redo logs for this database are unusable.

Database has been shutdown, open database with RESETLOGS option.

Succesfully changed database ID.

DBNEWID - Completed succesfully.

Create and configure a virtual cloud network(VCN)

4 years ago by Venkata Sai PavanOracle DB Admin

Dear Readers, This article will see the following Create and configure a virtual cloud network(VCN). Sign in to Oracle Cloud Infrastructure Console using your cloud tenant name, user name, and password. From the OCI services menu, click Virtual Cloud Networks under Networking. Choose the appropriate… Read More

Install SQLT and Query Slowness resolved over SQLT profile method

4 years ago by Venkata Sai PavanOracle DB Admin

Dear Readers, This article will see the following Install SQLT and Query Slowness resolved over SQLT profile method. Installing SQLT SQLT installs under its own schemas SQLTXPLAIN and SQLTXADMIN. It does not install any objects into the application schema(s). You can install this version of SQLT in Oracle databases 10.2, 11.1,… Read More

How to Install Terraform in Amazon EC2 Instance

4 years ago by Ramesh ReddyDevOps

Dear Readers, In this article, we will see the following Install Terraform in Amazon EC2 Instance. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Download and Install Terraform Set the path for terraform Start… Read More

How to Create VPC Using Cloud Formation

4 years ago by Ramesh ReddyAWS

Dear Readers, In this article, we will see the following How to Create VPC Using Cloud Formation. Steps to Follow : Logging to AWS Account Create Stack for creating VPC Very VPC Graphically 1. Logging to AWS Account First, we need to AWS Console… Read More

Install PostgreSQL 12 On RHEL 8 in AWS

4 years ago by Ramesh ReddyInstallation of PostgreSQL

Dear Readers, In this article, we will see the following Install PostgreSQL 12 On RHEL 8 . Steps to Follow : Logging to AWS Account Launch MySQL Server Connect to Linux EC2 Instance by Using Putty Switch to root user Install Server Updates Install wget… Read More