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…
Tag: how to
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…
Export A Table with Specific Columns in Oracle 19c
Yesterday, someone asked in whatsapp group about how to take expdp backup of a table with specific columns or Export A Table excluding few Columns. Hence today I am going to cover how to export ( expdp) a table with specific columns only That is you will be excluding the columns of table which you…
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 Clear Socket Files in Oracle RAC 19c
Hello Readers, You might be thinking why we are clearing network socket files in oracle 19c RAC configuration. How to Clear Socket Files in Oracle RAC. How often we need to clear it. What are the location of the socket files. How to clear socket files in Oracle RAC 19c. What happens if you clear…
DBMS_AUDIT_MGMT invalid Post Downgrade from 19c to 11g | PL/SQL: ORA-00947: not enough values
Hey Readers, We had a request to downgrade a oracle database from 19c to 11g. It’s very rare when you have a request to downgrade a system back to square zero. Reason usually are dependent upon functionality of the application. In my case, application had a separate tool which is used once in a quarter…
How to Kill Session in Oracle 19c | ALTER SYSTEM KILL SESSION / ALTER SYSTEM DISCONNECT SESSION /ALTER SYSTEM CANCEL SQL
Hey Readers, Welcome to the blog once again, Being an Oracle DBA, you might receive a request for killing a session. For Instance Application developer fired a Update/Delete statement two times and now He want to kill the session or Since pandemic most of us are working from home and due to network fluctuation at…
ORA-00257: Archiver error. Connect AS SYSDBA only until resolved
Hello Readers, You are here because you faced ORA-00257: Archiver error. Connect AS SYSDBA only until resolved error ? Lets come to point -> ORA-00257: Archiver error. Connect AS SYSDBA only until resolved error means archiver process is stuck because of various reasons due to which redo logs are not available for further transaction as…
How to Install Oracle 19c Binaries along with RU
Hey readers, if you remember, last post was about how to create physical standby database in Oracle 19c And there I mentioned that you have to install the binaries on your DR server. And apply same patch as that of production. Earlier when we were on 11g we used to download the Oracle Binaries and…
How to Upgrade OPatch Utility
Today we will cover where, why and how to download OPatch utility and how to upgrade the current version of the Utility to latest one. It’s a easy task and same procedure is followed from 10g ( I have worked only from 10g hence I am confirming from 10g. If you have done this same…