• Home
  • RMAN
  • Database
    • Data Guard
    • Data Pump
    • Performance Tuning
    • Security
    • General
  • Enterprise Manager
    • Grid Control 11g
    • Cloud Control 12c
  • Middleware
    • APEX
    • Application Server
    • Forms & Reports
    • WebLogic Server
  • OS
    • Linux & UNIX
    • Windows
    • VirtualBox
  • SQL Server
  • MongoDB
  • About Me
Home » Articles posted by Garth ( » Page 6)

Author Archives: Garth

Readable df -h output in HP-UX

Posted on October 16, 2012 by Garth

After my first encounter with a HP-UX system recently, I soon discovered that annoyingly, neither the df -h or df -g commands work in HP-UX! There are other commands such as df -PK or bdf I’ve found that can provide you with a more readable view of the filesystems, but after a bit of faffing around, I put this together instead:

Read More…

Posted in Linux & UNIX | Tags: filesystem, hp-ux | 10 Comments |

How to check which PSU is installed…if any

Posted on October 10, 2012 by Garth

How to check which PSU is installed…if any Oracle PSUs (Patch Set Updates) are referenced by their 5-place version number.  Unfortunately they do not change version numbers in the Oracle binaries, product banners and such though (see MOS 861152.1), so here’s how to identify which PSU your ORACLE_HOME is at… Database Server: To check the Oracle

Read More…

Posted in Enterprise Manager, General, WebLogic Server | Tags: psu, version | 5 Comments |

Importing a trusted certificate (SSL) into Oracle Wallet Manager

Posted on October 4, 2012 by Garth

Simple stuff really, but here’s how… Open a terminal window, set the ORACLE_HOME environment variable as appropriate, and start the utility: export ORACLE_HOME=/u01/app/oracle/product/11.2.0 cd $ORACLE_HOME/bin owm & When the GUI appears, if the default wallet path is not being used, click ‘Open Wallet’ from the sidebar then specify the wallet path, for example: /home/oracle/secure_wallet …then

Read More…

Posted in Middleware | Tags: certificate, ssl, wallet manager | Leave a comment |

How to uninstall Grid Control 11g agents

Posted on July 23, 2012 by Garth

Shutdown the agent: export AGENT_HOME=/u01/app/oracle/agent11g $AGENT_HOME/bin/emctl stop agent Delete the related targets from Enterprise Manager. Run the deinstaller (silent mode): $AGENT_HOME/oui/bin/runInstaller -invPtrLoc $AGENT_HOME/oraInst.loc -deinstall -silent “REMOVE_HOMES={$AGENT_HOME}” -removeallfiles NOTE: I’ve included the ‘invPtrLoc’ flag above.  This is optional, but if you ever come across a server where multiple inventories are used, you’re going to have to

Read More…

Posted in Grid Control 11g | Tags: agent, deinstall, grid control, uninstall | 1 Comment |

How to prevent the “Page Expired” message from appearing in EM12c

Posted on July 6, 2012 by Garth

After moving to Oracle Enterprise Manager Cloud Control 12c, one of the annoyances I soon discovered was this message “The page has expired. Click OK to continue”. When you’re not actively using the console, it doesn’t take long before the message appears, which is especially annoying when you have the performance monitoring pages running in the background! According to Oracle it’s

Read More…

Posted in Cloud Control 12c | Tags: cloud control, timeout | 4 Comments |

Error stopping the blackout ORA-20708 in EM11g Grid Control

Posted on June 6, 2012 by Garth

This post explains how to resolve a blackout in an inconsistent state, when you trying ending it from within Enterprise Manager Grid Control 11g, and see the following message: Error stopping the blackout “Blackout-06-Jun-2012 13:55:32”: ORA-20708: The start of the blackout is currently being processed ORA-06512: at “SYSMAN.MGMT_BLACKOUT_ENGINE”, line 3394 ORA-06512: at “SYSMAN.MGMT_BLACKOUT”, line 74 ORA-06512:

Read More…

Posted in Grid Control 11g | Tags: back-post, blackout, em11g, grid control, ORA-06512, ORA-20708 | Leave a comment |

How to repair a SQL Server 2005/2008 database in suspect mode

Posted on November 2, 2011 by Garth

This can happen following things like hardware failure, power outages, database files being locked by the Operating System (Anti-Virus, backup software etc.) or actual corruption of the database. Attempting the repair procedure below is really a last resort.  If you have good and recent backups, then if at all possible I would perform point-in-time recovery of

Read More…

Posted in SQL Server | Tags: recovery, repair, sql server, suspect mode | 6 Comments |

How to reset the WebLogic Admin Server password

Posted on May 12, 2010 by Garth

If you ever lose or forget your WebLogic Admin Server password, and you need to reset it, here’s how (tested against WLS 10.3)… Set the following environment variables (updating the <domain_name> as appropriate): export MW_HOME=/u01/app/oracle/product/middleware export DOMAIN_HOME=$MW_HOME/user_projects/domains/<domain_name> export CLASSPATH=$CLASSPATH:$MW_HOME/wlserver_10.3/server/lib/weblogic.jar . $DOMAIN_HOME/bin/setDomainEnv.sh Shutdown your WebLogic domain: $DOMAIN_HOME/bin/stopWebLogic.sh Rename and backup the DefaultAuthenticatorInit.ldift file: cd $DOMAIN_HOME/security mv

Read More…

Posted in WebLogic Server | Tags: boot.properties, password, security, weblogic | 3 Comments |

Checking the Oracle Application Server version

Posted on August 7, 2008 by Garth

The first time I had to find out what version of Oracle Application Server was running, I thought it would be a pretty straight forward task, but it’s not so straight forward as you’d first think, so I thought I’d blog it so I know for next time 😉 Some people check the $ORACLE_HOME/install/readme.txt file, which

Read More…

Posted in Application Server | Tags: oas, version | Leave a comment |

Archived

Popular Posts

  • Restoring a MongoDB document from the oplog
  • PLS-00801: internal error [hshuid:LU invalid] when compiling a package body
  • OTN Appreciation Day : Oracle Reports Server Job Queue Monitoring
  • Configuring Oracle Reports Server Job Queue Monitoring
  • Data Guard "CORRUPTION DETECTED: In redo blocks starting at block..." issues

External Links

  • SQL Formatter
  • Oracle Live SQL
  • SQL Fiddle
  • ASH Viewer
  • MOS
  • Oracle Forum
  • Oracle Base
  • Oracle FAQ
  • Oracle Articles
  • Rob Zoeteweij’s EM Blog
  • Prev
  • 1
  • …
  • 4
  • 5
  • 6
Copyright © 2020 SnapDBA.com