When I started as L1 Oracle Database Administrator, it was my regular task to check free space at tablespace level and maintain enough space to avoid application downtime because of “Unable to extend <tablespace> by XX Bytes” error. That’s the reason I brought this post. How to add datafile in tablespace in oracle 19c, We…
Category: L1ORACLEDBA
How to Create a Service Request (SR) in My Oracle Support
Today, I was wondering let me create a blog which will have all the basic points which are needed for a L1 Oracle DBA to know. It will be based on my experience so far. So if you think I need to add any post under L1ORACLEDBA category. Do let me know in comment section…
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…
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…
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…