Today we will cover everything about Temporary Tablespace, Sparse files, alter session set events=’60063′ . Everyone might know this – Temporary Tablespace are used for sorting operation in Oracle database. But Have you ever noticed ? Why creating a temporary tablespace with a size of 10gb is faster then creating a data tablespace with a…
Tag: oracle dba
How to Migrate OCR , Vote File , ASM SPFILE and ASM Password file to new Diskgroup in Oracle 19c
Similar to Database, storage also comes with support timelines, and this is one of the major reason storage team will ask you to migrate asm disks from old to new. Adding a disks and removing the old disks can be done with minor change in size for external redundancy diskgroups but not for high or…
How to Change Scan Listener Port in Oracle RAC 19c | Modify Scan Listener Port in Oracle RAC 19c
Welcome back, recently I have shared how to change local listener port in Oracle 19c, Similarly today I will cover how to modify scan listener port in Oracle RAC 19c. To be honest with you, I never got such request from application team / Any team as of now. But recently my colleague forgot to…
How to Change Listener Port in Oracle 19c
Changing of Listener Port is not a regular activity. But Application team can request you to change it. Today, we are going to learn how to change Local listener port in Oracle 19c RAC and Non Rac. Why to Change Local Listener Port in Oracle 19c You might be wondering what makes application team to…
Multiplex Control file in Oracle RAC database 19c
If you are working for Financial/Banking domain, you will have a Guidelines given by the Auditors and doesn’t matter if you are restoring a fresh database or making a copy of it. You need to follow it. So recently we had a request to restore a database for PUC purpose, but since it was on…
root.sh – CLSRSC-196: ACFS driver install actions failed in Oracle 19c
Yesterday, one of my colleague reported an issue where we were doing HAS installation. It was an AIX 7.1 OS on which were trying to install 19.14 Grid Infra and Oracle Binary. All prechecks were completed. And everything was looking good. But when we executed root.sh it failed with – CLSRSC-196: ACFS driver install actions…
How to Check and Set Hidden or Underscore Parameter in Oracle 19c
Changing Hidden parameters may lead to serious corruption issues, high performance degradation and other problems in the database. Oracle Doc I was upgrading my database from 11g to 19c, and pre-upgrade sql asked me to remove all the hidden parameters before starting actual upgrade of the database. You can refer following document which I used…
Oracle Database and Server Reboot Request
Let’s discuss about Oracle Database and Server Reboot Request. When Oracle Database services / cluster services are running on the server which is scheduled for server reboot then you will be asked to stop the database services. It’s always recommended to shutdown your database before releasing your database server for reboot. There are various reasons…
crsctl stop cluster -all vs crsctl stop crs in Oracle 19c
What is the difference between crsctl stop cluster -all vs crsctl stop crs. What all process will be running. Today we will share all the details about it. Crsctl stop cluster -all Honestly so far I haven’t got chance to use this command though Oracle says this will be used in Maintenance. Please note you…
How to Install Linux (Any Flavors) on VMWARE
Hello Readers, Welcome to my blog – oracledbworld, Today we are going to concentrate on how to Install Linux on VMWARE. To be honest, VMWARE is add-on for a student like us, who are willing to learn, understand, do R&D. VMWARE is not a freeware, hence you will have a restriction for using trail version….