OUR SYSTEM HAS DETECTED THAT THIS MESSAGE DOES NOT MEET IPV6 [GMAIL]
ISSUE When an email is sent from the server to a Gmail account it fails to deliver. The postfix is used as Mail Transfer Agent to deliver emails. SYMPTOMS In the /var/log/maillog the following error appears [root@dbpilot ~]# cat /var/log/maillog Apr 17 10:41:38…
ORA-01031 WHEN CONNECTING TO ORACLE 12C WITH TOAD 11.6
ISSUE A user cannot connect to Oracle Database 12c with Toad. He gets ORA-01031: insufficient privileges every time when attempting to connect. REASON In 12c release an access to SYS.USER$ table has been restricted. SOLUTION The issue only related to TOAD of…
RECLAIMING WASTED SPACE IN A SEGMENT
QUESTIONS How to reduce the size of a segment? How to run the Segment Advisor manually with a PL/SQL package for a specific segment? How to perform an online segment shrink? SOLUTION Run Segment Advisor against a segment and review results in dba_advisor_*…
FIXING DispatchingTaskScheduler:1071
REQUEST 13c agents generates many DispatchingTaskScheduler alerts. I want to stop them to be generated. SYMPTOMS Host=dbpilot.net Target type=Agent Target name=dbpilot.net:3872 Categories=Diagnostics Message=Internal error detected: java.lang.Throwable: oracle.sysman.gcagent.task.scheduler.DispatchingTaskScheduler:1071. Severity=Critical Event reported time=Feb 12, 2018 7:43:23 AM MSK Customer Support Identifier=10000001 Operating System=Linux Platform=x86_64 Associated…
CREATING A LOCAL YUM REPOSITORY USING AN ISO IMAGE
REQUEST I want to set up yum repository with downloaded iso image. RELATED CREATING A LOCAL YUM REPOSITORY USING MANUALLY DOWNLOADED PACKAGES SOLUTION Every RHEL, OEL, CENTOS iso image has a preconfigured repository. Just mount iso image and create a .repo file…
CREATING A LOCAL YUM REPOSITORY USING MANUALLY DOWNLOADED PACKAGES
REQUEST I want to set up a local yum repository with packages I downloaded manually. RELATED CACHING ALL PACKAGES AFTER YUM HAS INSTALLED IT DOWNLOADING A PACKAGE WITHOUT INSTALLING IT SOLUTION There is a tool called createrepo which simplifies the task at…
CACHING ALL PACKAGES AFTER YUM HAS INSTALLED IT
REQUEST I want to keep all packages installed by yum in a custom directory. Later I want to use them for setting up a repository. RELATED DOWNLOADING A PACKAGE WITHOUT INSTALLING IT SOLUTION To change default yum cache location, set the cachedir…
DOWNLOADING A PACKAGE WITHOUT INSTALLING IT
QUESTIONS How do I use yum to download a package without installing it? RELATED CACHING ALL PACKAGES AFTER YUM HAS INSTALLED IT SOLUTION You can use both yum downloadonly plugin and yumdownloader utility TESTCASE Downloadonly plugin Create a directory for…
ORA-1555: SNAPSHOT TOO OLD DUE TO CORRUPTED LOBS
QUESTIONS During schema(s) export or querying a table containing a clob column I recieve the following error ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually the ORA-01555 error is related either to the undo retention and the…
INSTALLING ORACLE PREREQUISITE PACKAGES FOR ORACLE DATABASE (Linux)
REQUEST I want to ensure that the Oracle database prerequisites packages are installed. SOLUTION For Oracle Enterprise Linux (OEL) there are default packages that simplify an Oracle database installation, eg oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall. They are used to install all prerequisite packages and to…
Search
Social Link(s)
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (59)
- Account (2)
- AWR (1)
- Database Errors (4)
- Database Performance (9)
- Datapump (3)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (3)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (5)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Temporary Tablespace (2)