SCOPE
Below script helps to identify the space utilization of Databases including the files such as Datafiles, Redologfiles, Archivelog files on ASM diskgroup categorized by Database names and their files.
Sharing knowledge is the ultimate key to gaining knowledge…
The only two things that stay with you for life are you & your knowledge...
Live while you can! Teach & inspire while you could & Smile while you have the teeth.
SCOPE
Below script helps to identify the space utilization of Databases including the files such as Datafiles, Redologfiles, Archivelog files on ASM diskgroup categorized by Database names and their files.
SCOPE
Application complains about the error ORA-12519: TNS:no appropriate service handler found while connection to the database.
SCOPE
Restoring
the database using RMAN backup.
After completion of cloning to the staging environment, OPEN RESETLOGS fails with error as below.
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
SCOPE
Application jobs fails with messages as below.
ORA-20001:
Job failed
ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS
Below document explains the issue faced after the upgrade, troubleshooting and need for timezone files.
At the point when you take a gander at PostgreSQL versus Prophet data set administration frameworks, the primary distinction between these two information bases is that PostgreSQL is an open-source data set, while Oracle is a shut data set framework.
We recently performed the cloning of the staging Database from a production database, but unfortunately we faced an issue.
Once the restore is complete, we were not able to stop the database to rename it and perform the post checks.
Many times when we kill a session with alter system kill session command ( or Toad )
PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased security.
Official documentation : https://www.postgresql.org/download/linux/redhat/
Lets assume that we have an update, insert or delete statement that running but has not been committed yet. So question is how to show uncommitted transactions ?
While troubleshooting sqlnet issue a week back and we used very same article to read trace files. It was very useful.
Found an interesting event, that helps to open the database with delay option. The event db_open_begin delay (opening database with delay) is undocumented event ( read unsupported )