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…
Listener in Oracle 19c
What is Listener in Oracle 19c ? Listener is service which runs on a specific port and used to connect to oracle database. In Oracle, listener.ora is used to configure the listener service on Oracle Database Server. The listerner.ora file has network configuration parameters. It comes into picture when you want to connect to the…
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…
ORA-12547: TNS:lost contact in Oracle 19c
Today, we faced an issue with one of recently upgraded database where sqlplus “/ as sysdba” on node 1 was working and sqlplus “/ as sysdba” was not working on node 2. It was giving following error – Problem Statement – ORA-12547: TNS:lost contact On Node 2, sqlplus “/ as sysdba” has problem and end…
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…