A 13c AGENT DEPLOYMENT ERROR : THE USER “ORACLE” DOES NOT HAVE THE PRIVILEGES TO RUN COMMANDS AS USER “ROOT”
ISSUE The remote prerequisite check fails during a 13c agent deployment process in Enterprise Manager Cloud Control 13c Console. RELATED A 13c AGENT DEPLOYMENT PROCESS CRASHES ON REDHAT/OEL 7.X TARGET HOSTS A 13c AGENT DEPLOYMENT ERROR : THE “VISIBLEPW” IS NOT SET THE…
A 13c AGENT DEPLOYMENT ERROR : THE “VISIBLEPW” IS NOT SET THE SUDOERS FILE
ISSUE The remote prerequisite check fails during a 13c agent deployment process in Enterprise Manager Cloud Control 13c Console. RELATED A 13c AGENT DEPLOYMENT PROCESS CRASHES ON REDHAT/OEL 7.X TARGET HOSTS A 13c AGENT DEPLOYMENT ERROR : THE USER “ORACLE” DOES NOT HAVE…
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…
TROUBLESHOOTING THE ORA-00600 ERROR WHILE A “MATERIALIZED VIEW” IS BEING CREATED OR COMPILED
ISSUE A database writes ORA-00600 [qsmkzfs:NULL seminfo] errors into the alert log everytime when a materialized view is being created or being compiled. RELATED ORA-00600 [qsmkzfs:NULL seminfo] While Compiling A Materialized View / Alter Summary (Doc ID 2069148.1) RETRIEVING AN OBJECT’S DDL STATEMENT…
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…
Search
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (53)
- Account (2)
- AWR (1)
- Database Errors (5)
- Database Performance (3)
- Datapump (2)
- Enterprise Manager (17)
- Environments (4)
- High CPU Usage (1)
- Interview (1)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- PL/SQL (4)
- UTL_FILE (4)
- Prerequisites (1)
- Queries (1)
- Redologs (1)
- Segment Shrink (1)
- Session (5)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Statistics (2)
- Temporary Tablespace (1)