Shripal 
In this article, we will check tablespace utilization in CDB and PDB databases as you know oracle introduced a multitenant architecture from the Oracle 12c version. New views have been introduced in 12c multitenant architecture for checking the size of datafiles and tempfiles that are used in CDB or PDB in the Oracle database. We … Read more
In this article, we are going to learn how to delete rman backups using the RMAN utility. As an Oracle DBA, you must know all ways to delete the database backups to clean the disk space. How to Delete all RMAN backups If you want to delete all the RMAN backups from the disk using … Read more
In this article, we will learn how to configure the recovery catalog on the Linux environment step by step. What is Recovery Catalog? The recovery catalog is a separate database, and totally different from your production environment. Catalog database only stores your backup information in terms of backup metadata. The recovery catalog database could be … Read more
This article will learn how to reset the High Water Mark in the oracle table. How does HWM work in the oracle table, what is the High Water Mark? What is a High Water Mark? In the Oracle database, the data is stored in blocks, and by default one block size is 8KB so you … Read more
In this article, we are going to understand why we use FAL_SERVER and FAL_CLIENT parameters in the Oracle dataguard environment. FAL full form is “fetch archive log“. The FAL is an oracle data guard environment parameter. With the name, you can clearly understand it fetched the archive logs for the standby database from the primary … Read more
In this article, we are going to learn how to upgrade the oracle 11g to 19c database on the Linux platform step by step. My Environment for this practice Prerequisites: Before starting the upgrade make sure you have done the below checklist: Stop the Listener Take full database backup using RMAN Purge Recycblebin Gather Dictionary … Read more
We want to find out OS PID against sid in the Oracle database to check the performance related to OS and Database. In the Linux platform, every process has its process ID (PID) and a user can easily get PID from SID (Identify OS PID from SID). Query to check PID from sid in Oracle … Read more
In this article, we are going to learn how to change archivelog mode and destination in oracle 19c. Start Change Archivelog mode and Destination Step 1: Check Archive log mode Status Check current archive log mode status in oracle 19c. As we checked our database running in no archive mode. Step 2: Create the Archive … Read more
Hi, I’m facing this error “ORA-02019: connection description for remote database not found” during making a connection with the DB link. ORA-02019 This could be happening because of the wrong DB link name or a TNS entry missing of the remote database. In my case my DB link name is xdb_link. Find DB Link Using … Read more
In this article, we are going to learn how to recover lost datafile with no backup. Suppose expediently you lost a datafile at the OS level and there is no current backup available. But the best point is that you are in archivelog mode and you have all archive logs available since the datafile was … Read more
In our previous post, we already discussed about the RMAN utility and oracle database backup types. In this article, we are going to discuss RMAN utility configuration and create a backup oracle database using RMAN. RMAN backup configuration Before we can take the backup, we need to set up certain RMAN parameters. For instance, for the … Read more
In this article, we are going to discuss oracle rman backup types. As you know RMAN is a utility of oracle database which is used to take Database backup. The RMAN backup is two types: Full Backup Incremental Backup Full RMAN backup A complete backup differs from a full database backup. A full backup of the … Read more
In this article, we are going to learn how to access Ubuntu Linux from Windows using putty step by step. To access ubuntu or any Linux server through putty we required the server IP address and ssh services must be enabled, also you must be able to ping the server from your windows server. Access … Read more
Knowing how to generate an execution plan optimizer of the SQL statement is an important part of optimizing SQL performance. There are many methods for generating an execution plan. The best option that suits you should be your tuning tool. Execution plan with autotrace When you want to display the SQL execution plan and don’t … Read more
In this article, we are going to solve ORA 12954 the request exceeds the maximum allowed database size of 12 GB. The above error comes because of oracle XE (Express Edition), we faced this error in the oracle 18c XE PDB database. Steps to solve ORA 12954 In that case, don’t have only two choices … Read more
In this article, we are going to learn how to change archive log destination in the oracle database production (LIVE) environment step by step. Sometimes we face disk space issues in the production environment due to high archive generation. So, here we are going to discuss how to change the archive destination in a standalone … Read more
In this article, we are going to learn how to create rman full database backup script step by step. RMAN (Recovery Manager) is a popular tool to create Oracle Database backups. Using RMAN we can create two types of backups listed below. Full Database Backup Incremental Database Backup So, here we are going to learn … Read more
In this article, we are going to learn, why we need to run crosscheck archivelog all commands. You must read this article carefully and follow all steps. Why we run crosscheck archivelog all? Rman utility is a very powerful utility that is used for creating Oracle Database backup. The crosscheck command only verifies the existence … Read more
Here we are going to learn how to find the long running queries in oracle, sometimes the query takes time to complete. Oracle has a view v$session_longops which is used to tracke these kinds of queries. The view shows the details about the work has donned in percentage, the pending percentage also and sofar completed, … Read more
In this article, we are going to learn datapump performance tuning. The Datapump is a tool that helps us to create a database backup. There are a few ways to increase export backup performance listed below: DIRECT=Y PARALLEL=n DIRECT=Y During export backup, if we use direct=y, it’s allowed to skip the SQL evaluation buffer. Though … Read more
Today we facing the ORA-19913 unable to decrypt backup error during RMAN backup restoration. After troubleshooting we found, this backup belonged to the encryption-enabled database and there is a wallet also configured. while backup restoration, open database in nomount state then check wallet status, it is showing closed. SQL> select status from v$encryption_wallet; STATUS ————– … Read more
how to get ddl for db_link in oracle with password, export db_link with password, drop db link, dbms_metadata.get_ddl dblink, get public db link ddl in oracle, drop db link in oracle. Viewing Information About Database Links Oracle has three data dictionary views listed below, which help us to find the information about DB links. View … Read more
In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case: Sometimes we need to move a table or schema from one database to another database but don’t have sufficient disk space on the production server. As you know the dump file … Read more
In this article, we are going to check oracle database growth per month. Here we have to script one is for complete database growth and another one is to check growth as per tablespace level. Oracle Database Growth per month script Using the below query you can find out the per month database growth. SQL> … Read more
Sometimes, we face ORA-14452 during drop or alter. SO, in this article, we are going to learn how to solve “ORA-14452: attempt to create” this error. We face this issue if the table is currently used in any other session, and we trying to drop or alter the table. Find Session Details Let’s find in … Read more
In this article, we are going to discuss the oracle wait event “Streams AQ: enqueue blocked on low memory” due to this wait event we are facing a performance issue in the export backup, today my export backup was in a hung state and it takes a very long time. ideally, the export backup was … Read more
Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to the waiter by utilizing Global … Read more
Hello, friends in this article we are going to learn how to schedule database export backup automatically. Yes, it is possible to export backup automation with a crontab scheduler. How to schedule Export Backup Using shell scripting, we can schedule the export backup as per our convenient time. Using the following steps we can schedule … Read more
How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to enable RMAN backups. In this article, we’ll look at automating RMAN backup using a shell script. Create Backup Location On your database server, create a … Read more
Oracle TDE implementation In this article, we are going to learn about Oracle TDE implementation. The TDE full form is transparent data encryption. What is TDE implementation? Which is used to encrypt the sensitive data at table level and tablespace level also. Once TDE is configured on the data, only the authorized users can access … Read more
Crosscheck Archivelog all Validation failed for archived log In this article, we are going to learn how to perform crosscheck for archives in the oracle database step by step. Validation failed for archived solution. validation failed Sometimes we face the error validation failed message during rman backup. Actually, we face the error because someone deletes … Read more
How do I install Oracle Client Installer? The Oracle Instant Client is lightweight software, Which is freely distributable implementation. The advantage of the Oracle Instant Client is it does not need a formal installation. Instead, just unzip the instant client software and used it without any fuss. How to install Oracle instant Client step-by-step guide. … Read more
Install Oracle 21c Linux In this article, we are going to learn oracle 21c installation on the Linux platform step by step. What is Oracle Database 21c? Oracle 21c is the latest release of Oracle database software, if you want to read more about click here. Can I download Oracle for free? Yes, You can … Read more
How do you Rename Oracle Database Schema? This is a very common question to every oracle dba person and sometimes we need to rename a database schema. So, in this article, we are going to learn how to change schema names in oracle step by step. Read: How to Rename Database Using Controlfile Can we … Read more
In this article, we are going to learn how to check past password change history in the oracle database. Using the below commands you can check the password change history step by step. Read: What is control file and datafile in Oracle? When was my Oracle password last changed? The below query will show you … Read more
What is control file and datafile in Oracle? In this article, we are going to learn what is control files and datafiles in Oracle. In the Oracle database environment, each and every database has its own separate control files. The control files also called binary files which record the physical structure of the oracle database. … Read more
How do I check flash recovery area? The flash recovery area or FRA in the oracle database is a location on the disk where the oracle database stores the backup files and archive files. Read: How to Add New Disk in ASM instance? How to configure FRA size Before starting configuration you must decide on … Read more
Linux/UNIX Commands For DBAs Here we learn some useful Linux commands for dba. Read: How to add SWAP Space in Linux Useful Linux commands for an Oracle DBA 1. PWD: show the present working directory. 2. ls: list all files and directories from a given location, if the location is not given it shows the … Read more
How do you monitor Expdp Impdp process? This article is all about monitoring oracle DataPump jobs, checking expdp or impdp jobs status, killing running jobs,troubleshoot hang jobs, etc. Here you will get different queries, which you can use to start, stop, resume, kill and see the status of data pump jobs. So, let’s monitor the … Read more
Hi, In this article we are going to learn how to kill inactive sessions. Sometimes there are so many inactive sessions available in the database. Due to these inactive sessions our database response a little slowly. So we need to kill them using the below steps. Read: How to create a database link Subscribe on YouTube … Read more
Database size and tablespace Utilization? In this article, we are going to check full database size, used size, and free space in the database as well as check the tablespace utilization details. Read: Find redo log members, redo log file size and redo log status Subscribe on YouTube Step 1. To check Database total space. … Read more
How do I delete old archive logs? Hi, in this article we are going to learn how to delete old archives using asmcmd. ASMCMD will work only in the case of the ASM environment. Read: How to create ASM diskgroup Subscribe to us on YouTube So, before deleting the archives in the ASM environment we … Read more
In this article, we are going to learn how to Relocate Datafiles in Oracle from one mount point to another mount point or disk. In other words, you can say that due to insufficient disk space we need to move data files to a different location. Read: How to drop oracle database manually Subscribe on … Read more
data guard configuration steps in oracle 11gr2 Oracle 11g R2 Dataguard configuration step by step, before starting DG configuration you must read the below note. Subscribe on YouTube Oracle Database RDBMS software installed with one database on the PRIMARY server and on STANDBY server installed only RDBMS software without any Database. PRIMARY STANDBY IP Address: 192.168.1.10 IP Address: 192.168.1.20 … Read more
The error ORA-00054 occurs if DDL or DML currently running without commits on the target table. The ORA-00054 mostly occurs in sessions that try to change table data or the structure of a table. Read: ORA-00031: session marked for kill Solution You can get the information about the locks using the below lists views: DBA_BLOCKERS: … Read more
Load data from CSV file into oracle Hi Friends, in this article, we will load data from the CSV file into oracle using SQL loader. SQL Loader is a tool which is providing by oracle. Read: How to create a SEQUENCE step by step What is SQL Loader? SQL Loader helps us to load data … Read more
RMAN script In this article, we are going to learn how to create a rman restoration script with a set newname parameter. If you try to restore the database on another server using RMAN and the directory structure is different, you can use the below query for restoration. Step 1. Check datafile location on the … Read more
In this article, we will show you how to find redo log members, redo log file size, and redo log status using some simple commands. How do you find the redo log? You can subscribe to my YouTube Channel Click Here Step 1. Find redo log file members and group details. Output from the above … Read more
Oracle Restart Configuration In this article, we are going to reconfigure the oracle restart step by step. Why do we need to reconfigure the oracle restart? Actually, in my organization, they rename the server name, if the server is renamed and rebooted the ASM instance failed to show error ORA-29701 unable to connect to cluster … Read more
What is ora 19502? Today I’m just performing the database full backup and suddenly I’m facing an ORA-19502 error message. I didn’t understand why this error came because I did not see any ora error in the alert file. I’m suffering on google but didn’t get any solution then I just checked my mount points … Read more
OEM DBconsole Manually This tutorial is from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you have previously configured the OEM console but it is not working then we need to drop the existing configuration and recreate the OEM repository, start configuration using the … Read more
How do I manually drop a database? In this article, we are going to learn how to drop the oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server. How to Create Pluggable Database Oracle How do I drop an entire database? Prerequisites Before taking any … Read more
TNS-00583 Actually, in today’s session I am facing the error TNS-00583 Valid Node Checking first time in my career, and unable to find the proper solution. Then I’m suffering on Google and found one solution on oracle support which I am going to discuss with you. Doc-id 1680353.1 ORA-00031: session marked for kill Solution I … Read more
In this tutorial, we will learn how to solve the ORA-00031 session marked for kill error. “How do I fix the ORA 00031 error?” | “ora-00031 session marked for kill” How do you resolve ORA 00031? Step 1. Login in Database with administrator (sys) user and find spid to kill at os level. If you … Read more
Hello Friends, in this article we are going to learn how to install oracle 19c on OEL 7) step by step. In this installation, we use the oracle-database-preinstall-19c package. Creating Non-CDB database in silent mode – ORACLE 19C OS Version OS version which we are going to use in this article. Prerequisite for Oracle 19c … Read more
Oracle Statspack Hello guys, in this article we are going to learn how to install, configure and use statspack in oracle. In this activity, I’m going to use the Oracle 12c environment. Introduction to Statspack If the DB server running very slow, then we need to perform DB tuning and it is very important to … Read more
How do I change a database name in Controlfile? Hi Guys, in this article we are going to learn how to rename a database using controlfile. Actually, we have two ways to rename the oracle database listed below. Rename Database using controlfile. Rename Database using NID utility. So, here I’m going to us first one … Read more
In this example, we are using oracle 19c and going to learn how to Creating Non-CDB database in silent mode. As you know, we can also create a database using the DBCA utility but in some cases, we don’t have access to the GUI. So here we will learn silent mode database creation step by … Read more
In this article, we are going to learn how to create pluggable database Oracle in oracle 12c or 19c. Here I’m going to create a pluggable database using PDB seed (PDB$SEED). How to set Oracle Pluggable Database Automatic startup Create Pluggable Database Step 1. Check current database details with existing pdbs. In my case the … Read more
As you know the pluggable database concept introduce in oracle 12c and when we startup the CDB database the PDBs (Pluggable Database) will be mount stage. So that time we need to open PDBs manually using alter command. Here we are going to learn how to Oracle Pluggable Database Automatic startup step by step. To … Read more
In this article, we are going to learn how to create an ASM diskgroup, so here I’m going to show you the complete steps to creating ASM devices and then the ASM disk group. To create ASM diskgroups you can use asmca (Oracle ASM Configuration Assistant) which is providing a GUI interface. But in this … Read more
Export Tables using PARFILE, Table export also known as the table level export in oracle data pump utility. DBA take table level export using expdp data pump command. Oracle DBA perform export import task as per there requirements. Export backup also called as logical backup. The export backup we can perform as table level, schema … Read more
Hi friends, in this article we are going to solve the ORA-01244 error, that you will be facing during manual database recovery. ORA-01244 unnamed datafiles added to control file by media recovery Cause: Actually that error most of the time you will face during the recovery, due to the datafile entry is not in the … Read more
In this article we are going to learn how to load oracleasm module or solve if oracleasm not mounted. Some time we face loading module oracleasm failed error. During creating the ASM disk we are facing the below error Read: Oracle Database Migration from Non-ASM to ASM oracleasm module not loaded or /dev/oracleasm not mounted. … Read more
In Data Pump EXPDP command use estimate only, to check the estimate the disk space required for the export backup job without performing real export backup. Before creating the export dump it’s better to check dump size using estimate_only. For example we are going to take demo of scott user. EXPDP Estimate only Step 1. … Read more
Hi guys, I’m getting an “ora-01654 unable to extend index” error during the production database shutdown in the system tablespace. Actually, in my case, the database is created manually, the tablespace size is 200MB, and auto extend also off. What the ora 01654? It comes if the tablespace doesn’t have sufficient space or its autoextend … Read more
How do I change my NID database name? Hello friends, in this article we are going to learn how to rename a database using the NID utility step by step. So in this demo, we are going to rename the db11g database name to ocptech. Before the NID utility, we can rename the database using … Read more
Sometimes we need to add extra swaps to our Linux machine, so in this article, I’m going to show you how to add swap space. We have two ways to add swap in the Linux environment. Create swap space using the file. Use Hard disk to adding swap space. Check existing swap details using the … Read more
Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to drop default tablespace. Action – … Read more
Export Tablespace Using Expdp Hi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically. What is tablespace? A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes. We can export tablespaces using the … Read more
What is Character Functions Hello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both. Type of Character Functions There are Eight types of Character Functions in SQL. CONCAT SUBSTR LENGTH INSTR LPAD RPAD … Read more
Single row functions operate on a single row only then return one result for each row, there are many types of single-row functions. Following are the types of Single Row Functions. Number Function. Date Function. Character Function. Conversion Function. General Function. Number Function Always accept only numeric values and also return always numeric values. Number Function … Read more
In this article, we are going to learn how to create and use SEQUENCE. What is SEQUENCE? SEQUENCE is an oracle shareable object which is generated numeric values and it can be unique. you can use this value as a primary key and unique value. Let see how to create SEQUENCE and how to use sequence step by step. How to … Read more
Hello friends, In this article, we are going to discuss, how to use the ALTER TABLE ORACLE MODIFY column. Using this command we can modify table structure if required after table creation. Alter Table Oracle Modify In this practical, we are using the following table which has three columns. Modify Column Suppose, I want to … Read more
Hello friends, In this article, we are going to find CPU and memory information of the oracle database server. How do I find CPU and memory information in Linux? The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt. How do I check … Read more
Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is Empty
Here is the solution of ORA 25153. If you faced the above error just add more space in the temporary tablespace or add a new tempfile in the temporary tablespace. How to check temporary tablespace in oracle Check the temporary tablespace size using the below query. Or you can use following query. Change the the … Read more
In this article, we are going to show you how to get tablespace quota details of a user in oracle. What is tablespace quota in Oracle? In the Oracle database when we set the quota for a user, that means we set the limit of data storage for particular schemas objects in the specified tablespace. … Read more
Hello Friends, In this article we are going to show you how to get ddl of all tablespaces in oracle. Get DDL of All Tablespaces Oracle Use below query to get ddl of all tablespaces in oracle. If you really like this article, please subscribe my YouTube channel. Read – How to Recover Controlfile without … Read more
Recover Controlfile without Backup Hello Friends, In this article we are going to discuss how to recover our controlfile without backup. Suppose if your controlfile is deleted accidentally and you don’t have any backup then what is the way to recover them. How do you recover a lost control file? So here you can find … Read more
How to Install JAVA 8 on Linux using the compiled source code? In this article, I’m going to show you how to install java 8 using the compiled source code on Redhat Linux, CentOS, and Fedora also the same steps. Step 1. Extract the zip file Extract downloaded source code inside the /opt/ directory using the following … Read more
What is MySQL, My is the daughter’s name of MySQL’s co-founder, Monty Widenius. The name of My/SQL is the combination of My and SQL, MySQL. What is mysql database MySQL is a DBMS (database management system) that allows you to manage RDBMS (relational databases). My/SQL is open-source Database software backed by Oracle. It means you can use My/SQL without paying … Read more
How install MySQL server in Linux? In this article, I’m going to show you how to Install MySQL Database Server step by step on Redhat Linux. For the MySQL database installation, we have required MySQL rpm files. You can find out these rpm files from your OS CD or from your YUM repository. If the … Read more
In this article, I’m going to show you how to add a new hard drive to a Linux environment. Start to Add New hard drive to the Linux platform. Environment In this tutorial, I’m using a VMware environment. And my machine has a 40 GB disk, as you can see below the screenshot. Add new Hard Disk Now … Read more
In this article, I’m going to show you how to create a DB Link step by step. How to create a database link, A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access … Read more
What is SQL, DBMS and RDBMS Hello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS. What is SQL? SQL (Structured Query Language) is used for Data Manipulation and … Read more
How to use SQL select statement? In this article, we are going to learn how to use SQL select statement to retrieve data from tables or views. In the database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements. Important points for … Read more
Schedule automatic task to Shutdown or Restart PC Hello Friends in this article I’m going to discuss with you how to schedule automatic tasks on your PC so let’s start. Click on the start button and search task scheduler or press window + r then type taskschd.msc then hit enter, then click on create a basic task in the … Read more
Do you have an upcoming interview to prepare for? If so, it is likely that you also suffer from the pre-interview jitters. The best way to counter interview-related anxiety is to prepare, prepare, prepare. Of course, it goes without saying that you should practice for your interview performance, but one area you need to pay … Read more
In this post, I’m going to demonstrate to you how to install ORACLE 12c Release 1 (12.1) on ORACLE LINUX-7 64 bit step by step. For ORACLE 12c installation minimum 2GB swap is required. Download ORACLE 12c R1 software from www.oracle.com accept OTN License Agreement, it’s downloaded in two parts and it’s a zip file. Start Oracle … Read more
Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step-by-step guide. Restore oracle database from rman backup to another server Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password … Read more
Partitioning in existing table Hello, friends in this article we are going to disuse how to partition the existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article, we are going to perform the below actions. Create a sample table and insert some records in this table. … Read more
Transport tablespace from Linux to windows platform step by step In this tutorial, I’m going to show you how Transport tablespace from Linux to windows platform, in oracle Database we can transport tablespace and Database from one platform to another platform. In this topic, I’m using Redhat Linux 6 (64 bit) and Microsoft Windows 7 … Read more
Transport Database from Linux to Windows Hello, friends in this article we are going to discuss How to Transport Database from Linux to windows. Transportable Database (TDB) requires 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 one … Read more
In this article, I’m going to show you how to convert a NON-CDB database into cdb database. Convert non-container database to multitenant pluggable database with Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit. Run the following commands on both machines. Output from Non-CDB database Output from CDB database Output from CDB database Run the … Read more
Uninstall Oracle 18c? Dear friends if you using the windows platform for the 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. Steps to Remove … Read more
How to Install Oracle 18c on Windows? Oracle Database 18c is 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 … Read more
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 to 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 … Read more
Hello friends, today we are going to discuss how to change the oracle user password without showing the actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in the case of alter command, the password will show on screen, and in the case of PASSWORD, the keyword did not. In my case, … Read more
DDL of users In this article, we going to discuss how we will get the ddl of users and roles. We can get the ddl of users and roles using toad also, but in this article, we are going to get metadata manually. Generally, DBA’s need to check the following details for a user, listed … Read more