Storing RMAN output in log file

RMAN Outputs in Log file

Hello, friends in this article we are going to discussed how to store RMAN outputs in the log file. What is the RMAN log file? RMAN log file is a just text file which is store complete output of RMAN commands. Generally, this file is used to check the backup has been done successfully or … Read more Storing RMAN output in log file

Share

How to upgrade 11g to 19c manually?

upgrade 11g to 19c

In this article, we are going to discuss how to upgrade Oracle 11g (11.2.0.4) to 19c (19.2.0.0) manually. Follow me step by step carefully. Start upgrade 11g to 19c manually. Source Environment. About Source Details OS Details Redhat Linux 7.6 (64 bit) Oracle Database version 11.2.0.4 Database Name OCP ORACLE_HOME path /u01/app/oracle/product/11.2.0.4/dbhome_1 Target Environment. About … Read more How to upgrade 11g to 19c manually?

Share

How to Install Oracle 18c on Windows?

how to install oracle 18c on windows

Oracle database 18c available for Linux and Microsoft Windows and in this article we are going to discuss how to install oracle 18c on windows. Minimum hardware requirements for Oracle 18c. These are the minimum hardware requirements for oracle 18c installation. 2GB RAM 10GB Free space on your machine disk 16GB swap Minimum screen resolution … Read more How to Install Oracle 18c on Windows?

Share

How to Uninstall Oracle 18c from Windows

Uninstall Oracle 18c? Dear friends if you using windows platform for Oracle database so I think you know that very well this is not an easy task to uninstall oracle software like other software. In this tutorial, we are going to learn how to uninstall oracle 18c from windows manually. You also read convert non-cdb … Read more How to Uninstall Oracle 18c from Windows

Share

Oracle ALTER TABLE MODIFY

ALTER TABLE MODIFY

Hello friends, In this article we are going to discus, how to use ALTER TABLE MODIFY column. Using this command we can modify table structure if required after table creation. ALTER TABLE MODIFY In this practical we are using following table which is have three columns. SQL> desc ocptech; Name Null? Type ———— —— ———- … Read more Oracle ALTER TABLE MODIFY

Share

How to Transport Database from Linux to windows?

Migrate Database from Linux to windows

Transport Database from Linux to Windows Hello friends in this article we are going to discussed how to Migrate Database from Linux to windows. Transportable Database (TDB) require all the datafiles format must be converted to the targeted platform format. How Migrate Database from Linux to windows? During TDB, the datafiles conversion can take place … Read more How to Transport Database from Linux to windows?

Share

How to Partitioning in existing table using EXCHANGE PARTITION

Partitioning in existing table

Partitioning in existing table Hello friends in this article we are going to disuse how to partitioning in existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article we are going to perform below actions. Create sample table and insert some records in this table. Create second … Read more How to Partitioning in existing table using EXCHANGE PARTITION

Share

How to restore archive logs from rman backup

Restore archive logs from backup

To restore the archive logs from RMAN backup, we need to reset the default location of archivelogs otherwise RMAN restore it’s on default location, to change archivelogs location we used SET ARCHIVELOG DESTINATION command. You also know how to use RMAN in NOARCHIVELOG MODE Steps to restore archive logs from RMAN backup: Your Database must … Read more How to restore archive logs from rman backup

Share

Find server IP using SQL Query

Find server IP using sql

Hello, friends in this article we going to discuss how to find server IP or Hostname using SQL query. How to check hostname using SQL query in oracle? The following query will show the hostname where you’re currently connected to in that session. How to Convert Non-CDB Database into CDB Database Click here? SQL> SELECT … Read more Find server IP using SQL Query

Share

How to Change password without showing the actual password on screen?

Change password without showing

Best Juicer Mixer Grinder In India 2019 (Mixie) – Buying Guide & Reviews! Hello friends today we are going to discuses how to change oracle user password without showing actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in case of alter command the … Read more How to Change password without showing the actual password on screen?

Share
Share