It is very easy to export and save output of executed query in xls sheet using toad but how to do it on sql prompt. To do so you need...
VI editor shows the error Terminal too wide within Solaris
You may receive the following error when using VI editor within Solaris. I got this error when I was adding tns entry in tnsnames.ora...
How to Change the Default SSH Port When Selinux is Enable on Linux
In this How-To guide we are going to explain you though changing the default SSH port on a Linux system.
SSH - The Secure Shell Protocol by...
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
Question: I am getting ORA-32004 error while starting the database but all the parameters in spfile are fine. This issue came after upgrade the database from 10g to 11.2.0.4.0
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
How to fix the ORA-32004 error?
Cause:...
[A-Z] VI Editor Commands for Editing Files in Linux
For operating systems like Solaris and Linux, you must know some of the basic vi editor commands for the smooth and frequent editing of files....
5 Steps to Move Control File from File System to ASM Disk
Moving controlfile from filesystem to ASM disk using RMAN in RAC.
You can migrate controlfile from file system to asm disk or...
Top 10 Commands to Check CPU Information on Linux
CPU info includes detailed information about the processor, like it's architecture, vendor name, model, number of cores, speed of each core...
ORA-27211: Failed to load Media Management Library
RMAN backup failed With below error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch1 channel...
Resolving ORA-19588: archived log recid stamp is no longer valid
ORA-19588: archived log recid 14859 stamp 747949646 is no longer valid
channel dev_0: starting archive log backupset
released channel: dev_0
RMAN-00571:...
35 Practical Find Command Examples in Linux
Find Command is one of the powerful Unix / Linux utility used for searching the files in a directory hierarchy from the command line....
Top 20 Practical Examples of RPM Commands in Linux
RPM is a default open source package management utility for installing, updating, uninstalling, querying and verifying software packages...
Top 10 Ways to Get Current Date and Time in Oracle DB
To get the current date and time on the Database Server Oracle has SYSDATE internal value which returns the current date from the operating...
How to Kill All Sessions of a Specific User in Oracle
Any time request may come like "Can you please kill all the sessions that is on ORAHOW database for user name Tiwary. Killing sessions can be very destructive if you kill the wrong session, so be very careful when identifying the session to be killed. If you kill a session belonging to a background process...
ORA-00245: Control File Backup Failed; Target is Likely on a Local File System
In alert log I got an issue ORA-00245: control file backup failed; target is likely on a local file system. Regarding this issue, I checked the snapshot control file location on rman prompt and observed that it was on local file system. In RAC environment, Snapshot control file backup location should be on...
4 Best Ways to Find Blocking Sessions in Oracle 11g
Blocking sessions occur when one sessions holds an exclusive lock on an object and doesn't release it before another sessions wants to update the same data. This will block the second until the first one has done its work. It mainly happens when a session issues an insert, update or delete command that changes...
HTTP Listener Failed at Startup Possible Port Conflict on Port
Few days back I got an alert: Agent is Not Running. Possible port conflict on port(3872): Retrying the operation. Failed to start...
Subscribe to:
Posts (Atom)